make check regression "test stats" failed

Started by Mike Quinnalmost 22 years ago3 messagesbugs
Jump to latest
#1Mike Quinn
mquinn@co.merced.ca.us

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Mike Quinn (#1)
Re: make check regression "test stats" failed

"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

#3Mike Quinn
mquinn@co.merced.ca.us
In reply to: Tom Lane (#2)
Re: make check regression "test stats" failed

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