Thread: 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