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
