Skip to content

Instantly share code, notes, and snippets.

@mayhem
Created July 25, 2012 19:07
Show Gist options
  • Save mayhem/3177935 to your computer and use it in GitHub Desktop.
Save mayhem/3177935 to your computer and use it in GitHub Desktop.
Wed Jul 25 19:06:41 2012 WARNING Process 23127 has been running for over 30 seconds
Wed Jul 25 19:06:41 2012 Query: SELECT editor, count(vote.id) FROM vote
JOIN editor ON vote.editor = editor.id
WHERE NOT superseded AND vote != -1
AND cast(privs AS bit(10)) & 2::bit(10) = 0::bit(10)
GROUP BY editor, editor.name
ORDER BY count(vote.id) DESC, musicbrainz_collate(editor.name)
LIMIT 25
Wed Jul 25 19:06:41 2012 STATUS Processes stuck: 23127
Wed Jul 25 19:06:51 2012 STATUS Processes stuck: 23127
Wed Jul 25 19:07:01 2012 STATUS Processes stuck: 23127
Wed Jul 25 19:07:11 2012 STATUS Processes no longer stuck: 23127
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment