I decided to run a periodic vacuum on my work queue. Lo and behold,
I get this:
ERROR: tuple concurrently updated
Which PG version is this, and do you have autovacuum enabled?
7.4.8, so no autovac, right?
In addition, all of my workers locked up, apparently indefinitely.
[ squint... ] That shouldn't happen. Look into pg_locks to see if
you can determine who's waiting for what.
I don't want to recreate the problem right now, but I will
investigate later. For what it's worth, while the workers were
locked up, I couldn't query the table in psql either.
- John D. Burger
MITRE
