[Zope3-Users] DatabaseException: Shouldn't load state for 0x28 when the connection is closed

[Keith Bolton]

The code used for connecting and retrieving data from PostgreSQL is
quite simply this:
 
 dbconn = getDatabase('name_of_psycopgda')()
 rows = queryForResults(dbconn, sql)
 return rows
 
Running this bit of code fails about 3 out 4 times; the traceback:
 
    rows = queryForResults(dbconn, sql)
  File "/usr/share/Zope32/src/zope/app/rdb/__init__.py", line 408, in
queryForResults
    raise DatabaseException(str(error))
DatabaseException: Shouldn't load state for 0x28 when the connection is
closed
 
I've tried setting the threadsafety=2 on the database adapter to no
avail.  Has anyone else seen this problem?
 
Thanks,
 
Keith
 
p.s. Zope 3.2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope3-users/attachments/20060408/2034e216/attachment.htm