>> 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