[Zope] commit problems psycopg

robert rottermann robert at redcor.ch
Mon Aug 23 14:07:07 EDT 2010

fyou probably need to commit the data
Am 23.08.2010 18:24, schrieb Richard Harley:
>    We have had a problem with postgresql 8.3 on a Windows server 2008. I
>    wonder whether there has been any other experiences like this. We have
>    connected to Potsgres from Zope via a Psycopg adapter and noticed that
>    sometimes when data is inserted via a form in Zope, the data is
>    available in Zope but doesn't get committed to the database. This has
>    come to a head over the weekend where at least one month's worth of data
>    has disappeared and this includes changes to the actual database
>    structure - luckily only on a testing machine, but concerning nevertheless.
>    The data seemed to disappear after we upgraded to the most recent
>    version of Zpsycopg2 database adapter, previously we were using version
>    1 (I know it's old, we are only testing after all) and have never had
>    these sorts of problem before. It's almost as if all the data and
>    changes to the db were held in memory, and Postgres continued to work
>    fine from there, but when the db adapter was changed and Zope restarted
>    everything was cleared from memory.
>    Has anyone had similar experiences or can anyone cast any light on where
>    the problem may lie. To us it seems the db adapter is the most likely
>    candidate but we can't understand how this could happen, explanations
>    also welcome. Have posted this to psycopg list too.
> Thanks
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> https://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>   https://mail.zope.org/mailman/listinfo/zope-announce
>   https://mail.zope.org/mailman/listinfo/zope-dev )

More information about the Zope mailing list