stuck spinlock

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

Responses

Browse pgsql-admin by date

  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