Thread: Question On 7.4RC2
I just finished compiling 7.4RC2 on Solaris 8 and ran the regression tests (make check). The last test out of 93 (stats) failed. Is this of concern?
7.3.3 passed all tests (89 for that release).
./regression.diffs
*** ./expected/stats.out Fri Oct 31 21:18:20 2003
--- ./results/stats.out Wed Nov 12 15:18:56 2003
***************
*** 8,14 ****
SHOW stats_start_collector; -- must be on
stats_start_collector
-----------------------
! on
(1 row)
--- ./results/stats.out Wed Nov 12 15:18:56 2003
***************
*** 8,14 ****
SHOW stats_start_collector; -- must be on
stats_start_collector
-----------------------
! on
(1 row)
-- save counters
--- 8,14 ----
SHOW stats_start_collector; -- must be on
stats_start_collector
-----------------------
! off
(1 row)
--- 8,14 ----
SHOW stats_start_collector; -- must be on
stats_start_collector
-----------------------
! off
(1 row)
-- save counters
***************
*** 62,68 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
***************
*** 62,68 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! t | t | t | t
(1 row)
(1 row)
SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
--- 62,68 ----
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! f | f | f | f
(1 row)
--- 62,68 ----
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! f | f | f | f
(1 row)
SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
***************
*** 71,77 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! t | t
(1 row)
***************
*** 71,77 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! t | t
(1 row)
-- clean up
--- 71,77 ----
--- 71,77 ----
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! f | f
(1 row)
?column? | ?column?
----------+----------
! f | f
(1 row)
-- clean up
*****************************************************************************************************
./regression.out
parallel group (14 tests): limit conversion sequence copy2 polymorphism truncate without_oid temp
prepare stats rangefuncs domain plpgsql alter_table
plpgsql ... ok
copy2 ... ok
temp ... ok
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... ok
alter_table ... ok
sequence ... ok
polymorphism ... ok
stats ... FAILED
plpgsql ... ok
copy2 ... ok
temp ... ok
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... ok
alter_table ... ok
sequence ... ok
polymorphism ... ok
stats ... FAILED
Thanks,
Glenn Wiorek
"Glenn Wiorek" <gwiorek@jmlafferty.com> writes:
> I just finished compiling 7.4RC2 on Solaris 8 and ran the regression tests =
> (make check). The last test out of 93 (stats) failed. Is this of concern?=
It means the stats collector is failing, probably because it's unable to
set up the self-connected UDP port that the stats code uses. Kiyoshi
Sawada reported the same problem on Solaris a day or two back on
pg-hackers, but we've not yet been able to identify why it's failing.
(The code involved got rewritten in 7.4 for IPv6 support, so some
portability problems aren't too surprising ...) Can you dig into it
there?
regards, tom lane
gwiorek@jmlafferty.com ("Glenn Wiorek") writes:
> I just finished compiling 7.4RC2 on Solaris 8 and ran the regression
> tests (make check). The last test out of 93 (stats) failed. Is
> this of concern?
I haven't "regressed" 7.4RC2 on Solaris, though I did do RC1, without
any problems. Let's see... What might be interesting differences...
Could you share what versions of things you're using? For instance,
here's the uname, pg_config, and gcc versioning information I find.
If there are interesting differences, that might point to where the
problem is...
postgres@ringo /disk3/OXRS/postgresql-7.4RC1 > uname -a
SunOS ringo 5.8 Generic_108528-17 sun4u sparc SUNW,Ultra-4
postgres@ringo /disk3/OXRS/postgresql-7.4RC1 > /opt/OXRS/pgsql74rc1/bin/pg_config --configure
'--prefix=/opt/OXRS/pgsql74rc1' '--with-includes=/opt/OXRS/readline-4.2/include'
'--with-libraries=/opt/OXRS/readline-4.2/lib''--enable-locale' '--enable-syslog' '--enable-debug'
postgres@ringo /disk3/OXRS/postgresql-7.4RC1 > gcc -v
Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls
Thread model: posix
gcc version 3.2
--
(format nil "~S@~S" "cbbrowne" "libertyrms.info")
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)
Thanks for the ideas I will also check them out and first try RC1 to see if
I get the same results.
This was also reported by someone else as per Tom Lane reply below. --
Glenn
>>t means the stats collector is failing, probably because it's unable to
>>set up the self-connected UDP port that the stats code uses. Kiyoshi
>>Sawada reported the same problem on Solaris a day or two back on
>>pg-hackers, but we've not yet been able to identify why it's failing.
>>(The code involved got rewritten in 7.4 for IPv6 support, so some
>>portability problems aren't too surprising ...) Can you dig into it
>>there?
----- Original Message -----
From: "Christopher Browne" <cbbrowne@libertyrms.info>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, November 13, 2003 9:23 AM
Subject: Re: [ADMIN] Question On 7.4RC2
> gwiorek@jmlafferty.com ("Glenn Wiorek") writes:
> > I just finished compiling 7.4RC2 on Solaris 8 and ran the regression
> > tests (make check). The last test out of 93 (stats) failed. Is
> > this of concern?
>
> I haven't "regressed" 7.4RC2 on Solaris, though I did do RC1, without
> any problems. Let's see... What might be interesting differences...
>
> Could you share what versions of things you're using? For instance,
> here's the uname, pg_config, and gcc versioning information I find.
> If there are interesting differences, that might point to where the
> problem is...
>
> postgres@ringo /disk3/OXRS/postgresql-7.4RC1 > uname -a
> SunOS ringo 5.8 Generic_108528-17 sun4u sparc SUNW,Ultra-4
>
> postgres@ringo /disk3/OXRS/postgresql-7.4RC1 >
/opt/OXRS/pgsql74rc1/bin/pg_config --configure
> '--prefix=/opt/OXRS/pgsql74rc1'
'--with-includes=/opt/OXRS/readline-4.2/include'
'--with-libraries=/opt/OXRS/readline-4.2/lib' '--enable-locale'
'--enable-syslog' '--enable-debug'
>
> postgres@ringo /disk3/OXRS/postgresql-7.4RC1 > gcc -v
> Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.2/specs
> Configured with:
../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-n
ls
> Thread model: posix
> gcc version 3.2
> --
> (format nil "~S@~S" "cbbrowne" "libertyrms.info")
> <http://dev6.int.libertyrms.com/>
> Christopher Browne
> (416) 646 3304 x124 (land)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>