This post originated from an RSS feed registered with Python Buzz
by Phillip Pearson.
Original Post: untitled
Feed Title: Second p0st
Feed URL: http://www.myelin.co.nz/post/rss.xml
Feed Description: Tech notes and web hackery from the guy that brought you bzero, Python Community Server, the Blogging Ecosystem and the Internet Topic Exchange
People have been reporting recently that pycs.net has been going down a lot. I just noticed a minute ago that it had stopped responding to queries, and also that one PostgreSQL process was indicating that it was doing a SELECT query for the the 'pycs' user. straceing the two processes revealed this:
# strace -p (pid of python process) Process 10043 attached - interrupt to quit send(4, "s_spam=0 AND usernum=377 AND pos"..., 42, 0 <unfinished ...>
# strace -p (pid of postgres process) Process 10051 attached - interrupt to quit send(8, "/www.pills-best.com/online-pharm"..., 8192, 0 <unfinished ...>
i.e., PyCS is sending an SQL query while Postgres is sending a response, presumably to another query.
I wonder what's happening here. It looks like PyCS has gone onto another DB query without finishing up the first one. Damn.
Previous Topic
