Horology & stats tests fail in 7.4.3/RH 9

From: Chuck Bearden <cbearden(at)hal-pc(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Horology & stats tests fail in 7.4.3/RH 9
Date: 2004-07-15 16:15:28
Message-ID: 40f6ada0$0$443$a726171b@news.hal-pc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Li 2004-07-15 17:05:42 Re: Describe table and varchar lrngth
Previous Message Tom Lane 2004-07-15 14:24:19 Re: tcl and rpms for rhel3