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:33
This propably means that some data blocks are corrupted
and 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.
Some of the noise here is coming from the fact that you didn't wait for
the old postmaster to quit before you tried to start another. ("pg_ctl
stop" doesn't wait unless you say -w ... there's been some talk of
reversing that default ...)
However, it still looks like you had other problems. What sort of
platform is this on? Do the regression tests pass for you?
regards, tom lane
Architecture and regression.diffs:
valter.
-------------
valter@lora:$ uname -a:
Linux lorax 2.2.17 #3 Mon Oct 2 23:11:04 UTC 2000 i686 unknown
-------------
valter@lora:$ less
./src/test/regress/regression.diffs
*** ./expected/random.out Thu Jan 6 06:40:54 2000
--- ./results/random.out Fri Jan 12 06:18:18 2001
***************
*** 25,31 ****
GROUP BY random HAVING count(random) > 1;
random | count
--------+-------
! (0 rows) SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
--- 25,32 ----
GROUP BY random HAVING count(random) > 1;
random | count
--------+-------
! 103 | 2
! (1 row) SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
======================================================================
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Valter Mazzola" <txian@hotmail.com>
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Pg7.1beta3: FATAL: s_lock(0x401f7010) at spin.c:147,
stuck spinlock.
Date: Thu, 11 Jan 2001 23:08:14 -0500Some of the noise here is coming from the fact that you didn't wait for
the old postmaster to quit before you tried to start another. ("pg_ctl
stop" doesn't wait unless you say -w ... there's been some talk of
reversing that default ...)However, it still looks like you had other problems. What sort of
platform is this on? Do the regression tests pass for you?regards, tom lane
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Import Notes
Resolved by subject fallback