[rrd-users] Re: The old "illegal attempt to update" problem

C. Bensend rrdtool at stinkweasel.net
Tue Aug 17 14:16:02 MEST 2004


> When you suck the data out of PostgreSQL, make sure to ORDER BY the date
> in the database. If you pull the data for a single RRD out of order you
> will hit this problem.
>
> I don't think it matters when the RRD was created.
>
> Basically, the problem is that you cannot insert data in an RRD with a
> timestamp prior to the latest datapoint in the RRD. When loading an RRD
> from another source data must be inserted sequentially by timestamp or
> it will not work.

Very good point, Mike.  I've added the ORDER BY to my SQL statement.  I
should have thought of that.

This didn't fix my problem, but is a necessary step as well.  Thanks much!

Benny

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi



More information about the rrd-users mailing list