This is a multi-part message in MIME format.
--------------DEB00E0BB23FD1CEF689C3AD
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

gmake check result


template1=# select version();
version
-------------------------------------------------------------------------------
PostgreSQL 8.0.0rc1 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc (GCC)
3.3.1
(1 row)

1 of 96 tests failed

test stats ... FAILED

Please find attached

src/test/regress/regression.out
src/test/regress/regression.diffs

BTW, as mentioned the other day I had to do configure as

configure LIBS="-ltermcap" ...

From my previous mail

I have successfully compiled and installed 7.4.5 yesterday.
After doing 'make' I saw the line "Ready to install".
template1=# select version();
version
--------------------------------------------------------
PostgreSQL 7.4.5 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc (GCC)
3.3.1
(1 row)

But when I started psql it immediately core dumped with
libreadline.sl.5 Unresolved external: tgetent

I did a search on the mailing list archives and got 63 hits on
'tgetent',
dating from 1997 to 2004, all having the same problem,
the missing '-ltermcap' in LIBS in src/Makefile.global.

After distclean and doing configure LIBS="-ltermcap" ...
and make again it finally worked.

In http://archives.postgresql.org/pgsql...9/msg00023.php
Peter Eisentraut writes
That's a good fix.

The current CVS tip also works around this problem.

But the 7.4.5 src/Makefile.global still has this:
LIBS = -lz -lreadline -lPW -lgen -lBSD -ldld -lnsl -lm

So it appears this fix must have been lost anywhere.

And it is not fixed in 8.0.0rc1.
8.0.0rc1 src/Makefile.global still has this:
LIBS = -lz -lreadline -lPW -lgen -lBSD -ldld -lnsl -lm

Regards, Christoph
--------------DEB00E0BB23FD1CEF689C3AD
Content-Type: text/plain; charset=iso-8859-2;
name="regression.diffs"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="regression.diffs"

*** ./expected/stats.out Sat Nov 1 04:18:20 2003
--- ./results/stats.out Wed Dec 15 13:57:14 2004
***************
*** 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

================================================== ====================


--------------DEB00E0BB23FD1CEF689C3AD
Content-Type: text/plain; charset=iso-8859-2;
name="regression.out"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="regression.out"

parallel group (13 tests): boolean char varchar name text int2 int8 int4 oid float4 float8 bit numeric
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... ok
int4 ... ok
int8 ... ok
oid ... ok
float4 ... ok
float8 ... ok
bit ... ok
numeric ... ok
test strings ... ok
test numerology ... ok
parallel group (20 tests): point box lseg path polygon circle timetz date time comments inet tinterval reltime interval abstime timestamp timestamptz type_sanity oidjoins opr_sanity
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... ok
test horology ... ok
test insert ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok
parallel group (7 tests): create_operator create_aggregate triggers vacuum constraints inherit create_misc
constraints ... ok
triggers ... ok
create_misc ... ok
create_aggregate ... ok
create_operator ... ok
inherit ... ok
vacuum ... ok
parallel group (2 tests): create_view create_index
create_index ... ok
create_view ... ok
test sanity_check ... ok
test errors ... ok
test select ... ok
parallel group (18 tests): select_into select_distinct_on select_implicit select_having union case select_distinct update random arrays transactions join aggregates hash_index namespace portals btree_index subselect
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... ok
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
test privileges ... ok
test misc ... ok
parallel group (5 tests): portals_p2 cluster select_views rules foreign_key
select_views ... ok
portals_p2 ... ok
rules ... ok
foreign_key ... ok
cluster ... ok
parallel group (14 tests): limit copy2 temp truncate sequence domain polymorphism conversion prepare rangefuncs rowtypes without_oid alter_table plpgsql
limit ... ok
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
rowtypes ... ok
test stats ... FAILED
test tablespace ... ok

--------------DEB00E0BB23FD1CEF689C3AD
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

--------------DEB00E0BB23FD1CEF689C3AD--

Christoph Haller <ch (AT) rodos (DOT) fzk.de> writes:
Check the postmaster.log file to find out why the stats collector didn't
start.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Christoph Haller <ch (AT) rodos (DOT) fzk.de> writes:
Hmm, I'd expect there to be a complaint right at the beginning.

Off-list please.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Christoph Haller <ch (AT) rodos (DOT) fzk.de> writes:
I believe the first two messages relate to being unable to open a TCP/IP
postmaster socket, which is not fatal because we can still listen on a
Unix socket; and the third one indicates that we failed to open a UDP
socket for the stats collector. In any case you've got to fix your name
resolution setup.

Memo to list: I'm inclined to reshuffle the code in pgstat_init() so
that the notice "disabling statistics collector for lack of working
socket" is emitted in *all* cases where we fail to start the stats
collector, rather than only some cases as now. Any objections?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

In ./src/test/regress/log/postmaster.log I cannot find
anything regarding the stats collector non-start.
Does it help to send the file (about 72 KB)?

Regards, Christoph

Tom Lane wrote:
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match