>> 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?
Yes, I also made the connections to Postgres persistent, rather than opening a new connection on each request. Regards, Martin _______________________________________________ Catalog-SIG mailing list Catalog-SIG@python.org http://mail.python.org/mailman/listinfo/catalog-sig
