Pg7.1beta3: FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock.

what happens?

valter.

[i've done vacuum analyze while query are running... vacuum stopped at some 
point, then i've decided to ctrl-c, then killed postmaster]

-------------------------------------
postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ stop

Smart Shutdown request at Fri Jan 12 05:46:11 2001
postmaster successfully shut down.

postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ start

pg_ctl: It seems another postmaster is running. Trying to start postmaster 
anyway.
Lock file "/usr/pg71/data//postmaster.pid" already exists.
Is another postmaster (pid 11320) running in "/usr/pg71/data/"?
pg_ctl: Cannot start postmaster. Is another postmaster is running?

postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ restart

Waiting for postmaster to shut down.........................
FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.

FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.
Startup failed - abort
done.
postmaster successfully shut down.
postmaster successfully started up

postgres@lora:~$ /usr/pg71/bin/postmaster: invalid argument -- '-D'

Try '/usr/pg71/bin/postmaster --help' for more information.

postgres@lora:~$ /usr/pg71/bin/pg_ctl -D /usr/pg71/data/ start
postmaster successfully started up
postgres@lora:~$ DEBUG:  starting up

DEBUG:  database system was interrupted being in recovery at 2001-01-12 
05:45:33This propably means that some data blocks are corruptedand you will have to use last backup for recovery.
DEBUG:  CheckPoint record at (0, 107606368)
DEBUG:  Redo record at (0, 107467584); Undo record at (0, 107484188); 
Shutdown FALSE
DEBUG:  NextTransactionId: 46738; NextOid: 59680
DEBUG:  database system was not properly shut down; automatic recovery in 
progress...
DEBUG:  redo starts at (0, 107467584)
FATAL 2:  out of free buffers: time to abort !


postgres@lora:~$
postgres@lora:~$
FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.

FATAL: s_lock(0x401f7010) at spin.c:147, stuck spinlock. Aborting.
Startup failed - abort



_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.