Re: psycopg2 multiprocessing problem
Federico Di Gregorio <fog-NGVKUo/i/[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Message-ID | <[email protected]> |
On 05/02/2010 22:12, kevin wrote: > when making db queries using psycopg2, web.py on processes spawned by > multiprocessing i get this error: > > http://pastie.org/811424 > > InternalError: current transaction is aborted, commands ignored until end of > transaction block > http://stackoverflow.com/questions/2209560/internalerror-current-transaction-is-aborted-commands-ignored-until-end-of-tran This is not so bad. It is just that some query was wrong and you didn't call rollback() before issuing other queries. I suggest you enable query logging and check the PostgreSQL log for errors. Then, if the wrong query was NOT written by you, i.e., if psycopg somehow sent to the backend a wrong query, please post the code and SQL here so that we can fix the problem. federico -- Federico Di Gregorio fog-NGVKUo/i/[email protected] I porcellini di terra sono davvero Crostacei! Non lo sapevo! Certo che sono crostacei, hanno la crosta! Allora la pizza è un crostaceo?! -- discorso all'ESC2k07 _______________________________________________ Psycopg mailing list Psycopg-IAPFreCvJWPBWskQ1e/[email protected] http://lists.initd.org/mailman/listinfo/psycopg
signature.asc
(application/pgp-signature, 262 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAktuy3oACgkQvcCgrgZGjese/QCfU5MHETrOPRNEarOyYudZtUrU Y8gAoLKHV2sQez64VcD6Du1jr1oD2gEm =S1zg -----END PGP SIGNATURE-----