[Catalog-sig] psycoph errors from pypi

[Jim Fulton]

On Jul 5, 2007, at 10:33 PM, Martin v. Löwis wrote:

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

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?

Jim

--
Jim Fulton			mailto:jim at zope.com		Python Powered!
CTO 				(540) 361-1714			http://www.python.org
Zope Corporation	http://www.zope.com		http://www.zope.org