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

Architecture and regression.diffs:
valter.

-------------
valter(at)lora:$ uname -a:

Linux lorax 2.2.17 #3 Mon Oct 2 23:11:04 UTC 2000 i686 unknown
-------------

valter(at)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(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Valter Mazzola" <txian(at)hotmail(dot)com>
>CC: pgsql-hackers(at)postgresql(dot)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.