From: | Gregg Jaskiewicz <gryzman(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | autovacuum locks |
Date: | 2012-03-02 10:44:07 |
Message-ID: | CAJY59_jb1QQT-YYiz_6_VVvUh9_VReiJHrgL6y3X522qRuYMTQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2012-03-02 11:03:03 | Re: autovacuum locks |
Previous Message | Jehan-Guillaume (ioguix) de Rorthais | 2012-03-02 09:26:51 | Re: Allowing multi "-t" and adding "-n" to vacuumdb ? |