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 Latest Python Buzz Posts Latest Python Buzz Posts by Phillip Pearson Latest Posts From Second p0st

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.

Comment