Re: horology regression test failure

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: horology regression test failure
Date: 2005-09-29 21:25:49
Message-ID: 20050929212549.GC11293@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Thu, Sep 29, 2005 at 11:08:22PM +0200, Martin Pitt wrote:

> On almost all Debian platforms the horology test for 8.0.3 fails.
> Sometimes it works on a platform, sometimes not, I did not yet find a
> pattern, but most often it fails with something like

I think this test is supposed to fail when it's run near a DST
transition. The question to be asking is, then, is the server running
with a timezone that has just changed DST or is about to change? In
this case, ignore the report.

Note in the diff below that the originals have PDT (second column)/PDT
(fourth column) while the result obtained from the test is PDT/PST; or
PST/PDT and PST/PST; or PST/PST and PST/PDT.

Does this explain the issue?

> *** ./expected/horology.out Sun Jul 11 04:57:20 2004
> --- ./results/horology.out Thu Sep 29 20:48:57 2005
> ***************
> *** 1775,1784 ****
> | 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
> --- 1775,1784 ----
> | 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

--
Alvaro Herrera http://www.PlanetPostgreSQL.org
"Porque Kim no hacia nada, pero, eso sí,
con extraordinario éxito" ("Kim", Kipling)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-09-29 21:50:47 Re: horology regression test failure
Previous Message Martin Pitt 2005-09-29 21:08:22 horology regression test failure

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2005-09-29 21:41:50 Re: pgbench: undefined reference to strndup()
Previous Message Martin Pitt 2005-09-29 21:08:22 horology regression test failure