stuck spinlock
От | Jeff Waugh |
---|---|
Тема | stuck spinlock |
Дата | |
Msg-id | 20011122125059.7ec431d3.jaw@ic.net обсуждение исходный текст |
Ответы |
Re: stuck spinlock
|
Список | pgsql-admin |
I have a database that was busy when it's server was rebooted. Following is the output of postmaster -d4. It runs for about 15 minutes and then core dumps. Any advice how I can get this database started again? It is 7.1.3 on FreeBSD 4.2. Thanks, -Jeff bin/postmaster: PostmasterMain: initial environ dump: ----------------------------------------- USER=postgres MAIL=/var/mail/postgres HOME=/usr/local/pgsql TERM=xterm BLOCKSIZE=K PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/usr/local/pgsql/bin SHELL=/bin/sh FTP_PASSIVE_MODE=YES ----------------------------------------- invoking IpcMemoryCreate(size=9232384) FindExec: found "/usr/local/pgsql/bin/postmaster" using argv[0] DEBUG: database system shutdown was interrupted at 2001-11-22 04:24:53 EST DEBUG: CheckPoint record at (13, 2652568836) DEBUG: Redo record at (13, 2652568836); Undo record at (0, 0); Shutdown TRUE DEBUG: NextTransactionId: 56354001; NextOid: 205527560 DEBUG: database system was not properly shut down; automatic recovery in progress... DEBUG: ReadRecord: record with zero len at (13, 2652568900) DEBUG: redo is not required FATAL: s_lock(0x30059219) at bufmgr.c:2048, stuck spinlock. Aborting. FATAL: s_lock(0x30059219) at bufmgr.c:2048, stuck spinlock. Aborting. bin/postmaster: reaping dead processes... bin/postmaster: Startup proc 3436 exited with status 134 - abort
В списке pgsql-admin по дате отправления: