[Catalog-sig] psycoph errors from pypi

["Martin v. Löwis"]

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

Regards,
Martin