From: | Jeff Waugh <jaw(at)ic(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | stuck spinlock |
Date: | 2001-11-22 17:50:59 |
Message-ID: | 20011122125059.7ec431d3.jaw@ic.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-11-23 01:42:56 | Re: stuck spinlock |
Previous Message | MG | 2001-11-22 10:39:37 | table permissions |