Folks, I got a system here (8.3.7), that is locked up. Few queries waiting for autovacuum aquired locks on a table or two. But it looks like autovacuum is also waiting for some semaphore:
#0 0x00f07410 in __kernel_vsyscall () #1 0x00252d2b in semop () from /lib/libc.so.6 #2 0x081ca1ce in PGSemaphoreLock () #3 0x081f590e in ProcWaitForSignal () #4 0x081e8dea in LockBufferForCleanup () #5 0x08160e68 in ?? () #6 0x08161482 in lazy_vacuum_rel () #7 0x081603b5 in ?? () #8 0x081605c4 in vacuum () #9 0x081cd154 in ?? () #10 0x081cd7f1 in ?? () #11 0x081cd911 in StartAutoVacWorker () #12 0x081d6d47 in ?? () #13 <signal handler called> #14 0x00f07410 in __kernel_vsyscall () #15 0x00249fcd in ___newselect_nocancel () from /lib/libc.so.6 #16 0x081d3964 in ?? () #17 0x081d5105 in PostmasterMain () #18 0x0818be60 in main () There's still other transcations going on , and working fine - but two tables seem to be cut out by autovacuum, and other queries stuck waiting for autovacuum to finish. Any ideas ? Is there a possible fix up the 8.3 stream, that would target that ? (I need leverage to upgrade to 8.3.18, and if that's the case - happy days). -- GJ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
