[Catalog-sig] psycoph errors from pypi

"Martin v. Löwis" martin at v.loewis.de
Fri Jul 6 04:33:54 CEST 2007

Martin v. Löwis schrieb:
> Jim Fulton schrieb:
>> I imagine the people working on the cheeseshop are aware of this,  
>> but, in case you aren't, I'm getting intermittent  errors from the  
>> cheeseshop.  For example, requests for:  http://www.python.org/pypi/  
> I wasn't aware of this until you reported it.
> I don't have a clue what's causing it.

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


More information about the Catalog-SIG mailing list