[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

_______________________________________________
Zope3-users mailing list
Zope3-users@zope.org
http://mail.zope.org/mailman/listinfo/zope3-users