[Catalog-sig] psycoph errors from pypi
"Martin v. Löwis"
martin at v.loewis.de
Sat Jul 7 00:02:47 CEST 2007
>> I now do, somewhat. Apparently, when you discard a cursor object
>> in psycopg, and create a new one, that doesn't necessarily start
>> a new transaction. So if there was some SQL error in the connection,
>> it stops accepting further SQL statements.
>> I fixed that by rolling back the connection after each request,
>> and before each new request.
>> What I don't understand is why there was an error in the first
>> place (or what that error was).
> OK, this probably isn't helpful, but I can't help asking an obvious
> question. Did something change in the software other than a switch from
> mod_python to FastCGI?
Yes, I also made the connections to Postgres persistent, rather than
opening a new connection on each request.
More information about the Catalog-SIG