Re: [ADMIN] Question On 7.4RC2
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 13, 2003 9:23 AM
Subject: Re: [ADMIN] Question On 7.4RC2
> [EMAIL PROTECTED] ("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...
>
> [EMAIL PROTECTED] /disk3/OXRS/postgresql-7.4RC1 > uname -a
> SunOS ringo 5.8 Generic_108528-17 sun4u sparc SUNW,Ultra-4
>
> [EMAIL PROTECTED] /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'
>
> [EMAIL PROTECTED] /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 "[EMAIL PROTECTED]" "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
>
>
---(end of broadcast)---
TIP 8: explain analyze is your friend
Re: [ADMIN] Question On 7.4RC2
[EMAIL PROTECTED] ("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...
[EMAIL PROTECTED] /disk3/OXRS/postgresql-7.4RC1 > uname -a
SunOS ringo 5.8 Generic_108528-17 sun4u sparc SUNW,Ultra-4
[EMAIL PROTECTED] /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'
[EMAIL PROTECTED] /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 "[EMAIL PROTECTED]" "cbbrowne" "libertyrms.info")
Re: [ADMIN] Question On 7.4RC2
"Glenn Wiorek" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] 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) -- save counters--- 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? --+--+--+-- ! t | t | t | t (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) 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) -- clean up--- 71,77 WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?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 Thanks, Glenn Wiorek
