http://librarian.launchpad.net/7042614/postmaster-bt.txt was the bt for
the process that hanged on CREATE DATABASE.
There was another fork:
16273 ? Ss 0:00 postgres: mark launchpad_ftest_template [local]
startup waiting
which also hanged in the semaphore:
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb7c60dcb in semop () from /lib/tls/i686/cmov/libc.so.6
#2 0x081c98cc in PGSemaphoreLock (sema=0xb78dca50, interruptOK=6 '\006')
at pg_sema.c:411
#3 0x081f363f in ProcSleep (locallock=0x83b5b80, lockMethodTable=0x833f76c)
at proc.c:829
#4 0x081f2665 in LockAcquire (locktag=0xbfc5b414, lockmode=3,
sessionLock=0 '\0', dontWait=0 '\0') at lock.c:1140
#5 0x081f0146 in LockSharedObject (classid=1262, objid=16385, objsubid=0,
lockmode=3) at lmgr.c:578
#6 0x08293f28 in InitPostgres (dbname=0x83b3058 "launchpad_ftest_template",
username=0x83983a0 "mark") at postinit.c:406
#7 0x081fd522 in PostgresMain (argc=4, argv=0x83983dc,
username=0x83983a0 "mark") at postgres.c:3143
#8 0x081d211a in ServerLoop () at postmaster.c:2931
#9 0x081d3034 in PostmasterMain (argc=5, argv=0x83950e0) at postmaster.c:963
#10 0x0818c745 in main (argc=5, argv=0xbfc5ca64) at main.c:188
and the autovacuum daemon as well:
#1 0xb7c60dcb in semop () from /lib/tls/i686/cmov/libc.so.6
#2 0x081c98cc in PGSemaphoreLock (sema=0xb78ddc20, interruptOK=118 'v')
at pg_sema.c:411
#3 0x081f553e in LWLockAcquire (lockid=BtreeVacuumLock, mode=LW_EXCLUSIVE)
at lwlock.c:455
#4 0x080abe38 in _bt_end_vacuum (rel=0xb5f0b298) at nbtutils.c:1028
#5 0x080a9c68 in btbulkdelete (fcinfo=0xbfc58cd8) at nbtree.c:552
#6 0x0828b13d in FunctionCall4 (flinfo=0x8637188, arg1=3217395608, arg2=0,
arg3=135662128, arg4=140545744) at fmgr.c:1206
#7 0x080a3b96 in index_bulk_delete (info=0xbfc58f98, stats=0x0,
callback=0x8160a30 <lazy_tid_reaped>, callback_state=0x8608ed0)
at indexam.c:573
#8 0x0816099f in lazy_vacuum_index (indrel=0xb5f0b298, stats=0x86092dc,
vacrelstats=0x8608ed0) at vacuumlazy.c:651
#9 0x081611dd in lazy_vacuum_rel (onerel=0xb5f09ca8, vacstmt=0x8638ef8)
at vacuumlazy.c:478
#10 0x0815f08b in vacuum_rel (relid=<value optimized out>, vacstmt=0x8638ef8,
expected_relkind=114 'r') at vacuum.c:1088
#11 0x08160015 in vacuum (vacstmt=0x8638ef8, relids=0x8638f58) at vacuum.c:397
#12 0x081cc10a in AutoVacMain (argc=<value optimized out>,
argv=<value optimized out>) at autovacuum.c:912
#13 0x081cc5c3 in autovac_start () at autovacuum.c:178
#14 0x081d26d0 in ServerLoop () at postmaster.c:1249
#15 0x081d3034 in PostmasterMain (argc=5, argv=0x83950e0) at postmaster.c:963
#16 0x0818c745 in main (argc=5, argv=0xbfc5ca64) at main.c:188
--
Postgres 8.2 on Feisty beta dies regularly
https://launchpad.net/bugs/93042
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
