[Zope] commit problems psycopg

[Peter Bengtsson]

Most likely you have raise conditions that you don't notice but that
the ZPsycopg2 adapter notices. Perhaps it's a ConflictError or a
Unauthorized.
Either start committing the data yourself (transaction.get().commit()
will commit in Postgres too)
You can also debug your problems by keeping a close eye on the SQL
logs. You'll need to enable it somewhere in the postgres conf. On
linux you can look for a line like "log_statement = 'all'"


On 23 August 2010 12:24, Richard Harley <richard at scholarpack.com> wrote:
>  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 )
>



-- 
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com
fun crosstips.org