Thread

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

V. M. <txian@hotmail.com> — 2001-01-12T04:21:03Z

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 -0500
>
>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

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