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:[EMAIL PROTECTED] Python Powered! CTO (540) 361-1714 http://www.python.org Zope Corporation http://www.zope.com http://www.zope.org _______________________________________________ Catalog-SIG mailing list Catalog-SIG@python.org http://mail.python.org/mailman/listinfo/catalog-sig
