RangeError: DateTimeDelta value out of range: %f seconds

Hi,

In my organization, we have a multi threaded python application with high db
activity using psycopg2 (2.0.10) in linux. The db connections etc. are
protected by locks and there is no problem there. In fact, it is the same
application where we discovered a couple of psyopg2 issues earlier, which
were fixed in 2.0.10:

http://lists.initd.org/pipermail/psycopg/2009-April/006425.html
http://lists.initd.org/pipermail/psycopg/2009-April/006428.html
http://lists.initd.org/pipermail/psycopg/2009-April/006429.html

Now we have this new issue which occurs only when there is frequent db
activity on an interval column and we are not able to reproduce it at all
(except in production environment, where we obviously can not sit down and
diagnose the issue).

It all started when we added an interval type column to a table and started
accessing it frequently via select calls on the table. We do 10 or so
selects on this table every second (by the same db connection and all
serialized via a lock) and after 10 minutes or so of that the application
has the following exception:

"""

  File "###", line 190, in __getitem__
    return self._cursor.fetchone()
RangeError: DateTimeDelta value out of range: %f seconds

"""

If we revert out the code related to the interval column and drop the
column, and start up the application, this issue stops.

Note that the data in the interval column in the table is fine because we
select all the rows of this table at application startup and that happens
without issue. But after 10 minutes or so, an arbitrary attempt at select
fails as above.

Any idea on what this issue is and how we would have a better chance of
reproducing it?

Thanks,
Gangadharan

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg