[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