make check regression "test stats" failed
Postgresql Version 7.4.2
Slackware 9.1
kernel 2.4.26
I did:
./configure
make
make check
Here is the regression.diffs file:
*** ./expected/stats.out Fri Oct 31 19:18:20 2003
--- ./results/stats.out Wed Apr 21 09:41:57 2004
***************
*** 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
======================================================================
I also did:
make install
# and make a database and start the postmaster then
make installcheck
and got the same sort of results.
If you need anymore information let me know.
"Mike Quinn" <mquinn@co.merced.ca.us> writes:
[ $subject ]
The stats collector isn't starting, but you're not showing any evidence
to suggest why. Try looking in the postmaster log file for related
error messages.
regards, tom lane
I found my problem. My iptables setup was not allowing UDP communication
from source 127.0.0.1 and some high port to destination 127.0.0.1 and
the same high port. Once I allowed that communication the "test stats"
was ok. I ran a diff on the postmaster log file from an "ok" run and a
"failed" run and the only difference was the date/time, so there was no
indication there of this type of problem there.
Thanks,
Mike Quinn
Tom Lane <tgl@sss.pgh.pa.us> 4/27/04 9:38:58 PM >>>
"Mike Quinn" <mquinn@co.merced.ca.us> writes:
[ $subject ]
The stats collector isn't starting, but you're not showing any
evidence
to suggest why. Try looking in the postmaster log file for related
error messages.
regards, tom lane
Import Notes
Resolved by subject fallback