Hi, Since our Launchpad developers switched from 8.1 to 8.2.3, they often encounter a situation when the postmaster gets stuck and needs to be restarted. This happens on various CREATE commands (FUNCTION, DATABASE, not consistently).
The backtraces show that the process doing the CREATION, another client connection that InitPostgres(), and the autovacuum daemon all hang eternally in PGSemaphoreLock(), so I suspect that there is a race condition of some sort? I tried to reproduce this with an hour-long run of CREATE/DROP DATABASE, but without success. It occurred to me that the process which does the CREATE is in _bt_vacuum_cycleid(), is that also related to the autovacuum daemon? I asked the original reporter (Mark Shuttleworth, in CC) to disable the autovacuum daemon for testing. https://launchpad.net/bugs/93042 has symbolic gdb backtraces of all three processes that are involved. At this point I am not sure which further information I could provide. Mark would be happy provide more information and/or directly talk with you. Thanks in advance, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org
signature.asc
Description: Digital signature
