Horology & stats tests fail in 7.4.3/RH 9 - Mailing list pgsql-general

From Chuck Bearden
Subject Horology & stats tests fail in 7.4.3/RH 9
Date
Msg-id 40f6ada0$0$443$a726171b@news.hal-pc.org
Whole thread Raw
Responses Re: Horology & stats tests fail in 7.4.3/RH 9  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I am building from a freshly downloaded tar.gz of 7.4.3.  The machine is
a 4CPU Dell with an unsupported RH 9 install.  (FWIW, I didn't set it
up, and to do anything requiring root access I have to go sit at the
IT guy's console from which he SSHs in to the box.  The IT folks are
smart but not Linux cogniscenti.)

When I ran the regression tests, two failed: horology and stats.  I'll
append the content of the regression.diffs file to the posting.

Is this something I should be worried about?  I can get more info about
the system if that would be helpful, but the only configure option I
exercised was '--prefix=', so I'm not sure what would be helpful.

Thanks in advance,
Chuck


*** ./expected/horology.out     Thu Sep 25 01:58:06 2003
--- ./results/horology.out      Thu Jul 15 10:47:33 2004
***************
*** 1787,1796 ****
       | Wed Mar 15 13:14:02 2000 PST | @ 34 years                    | Tue Mar 15 13:14:02 1966 PST
       | Sun Dec 31 17:32:01 2000 PST | @ 34 years                    | Sat Dec 31 17:32:01 1966 PST
       | Mon Jan 01 17:32:01 2001 PST | @ 34 years                    | Sun Jan 01 17:32:01 1967 PST
!      | Sat Sep 22 18:19:20 2001 PDT | @ 34 years                    | Fri Sep 22 18:19:20 1967 PDT
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours             | Thu Jul 31 12:00:00 1969 PDT
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons                      | Fri Aug 01 00:00:00 1969 PDT
!      | Thu Jan 01 00:00:00 1970 PST | @ 3 mons                      | Wed Oct 01 00:00:00 1969 PDT
       | Thu Jan 01 00:00:00 1970 PST | @ 10 days                     | Mon Dec 22 00:00:00 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 5 hours                     | Wed Dec 31 19:00:00 1969 PST
--- 1787,1796 ----
       | Wed Mar 15 13:14:02 2000 PST | @ 34 years                    | Tue Mar 15 13:14:02 1966 PST
       | Sun Dec 31 17:32:01 2000 PST | @ 34 years                    | Sat Dec 31 17:32:01 1966 PST
       | Mon Jan 01 17:32:01 2001 PST | @ 34 years                    | Sun Jan 01 17:32:01 1967 PST
!      | Sat Sep 22 18:19:20 2001 PDT | @ 34 years                    | Fri Sep 22 18:19:20 1967 PST
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours             | Thu Jul 31 12:00:00 1969 PST
!      | Thu Jan 01 00:00:00 1970 PST | @ 5 mons                      | Fri Aug 01 00:00:00 1969 PST
!      | Thu Jan 01 00:00:00 1970 PST | @ 3 mons                      | Wed Oct 01 00:00:00 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 10 days                     | Mon Dec 22 00:00:00 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
       | Thu Jan 01 00:00:00 1970 PST | @ 5 hours                     | Wed Dec 31 19:00:00 1969 PST

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


*** ./expected/stats.out        Fri Oct 31 21:18:20 2003
--- ./results/stats.out Thu Jul 15 10:47:45 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

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

pgsql-general by date:

Previous
From: Richard A Lough
Date:
Subject: Re: Three versions of Pg.pm on my machine
Next
From: "Sumita Biswas"
Date:
Subject: Re: Error while Insertion