[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.

Regards,
Martin


More information about the Catalog-SIG mailing list