Skip to content

roachtest: pg_regress failed #157101

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.pg_regress failed with artifacts on master @ ddeef368172658dddb47811fe0fcdcaf5abbe8ee:

(pg_regress.go:499).runPGRegress: Regression diffs do not match expected output for horology.
--- testdata/horology.diffs
+++ horology.diffs
@@ -1212,23 +1212,6 @@
  SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08";
   23:29:00-08 
  -------------
-@@ -1034,14 +661,14 @@
-             + interval '02:01' AS time with time zone) AS time) AS "07:31:00";
-  07:31:00 
- ----------
-- 07:31:00
-+ 08:31:00
- (1 row)
- 
- SELECT CAST(cast(date 'today' + time with time zone '03:30'
-   + interval '1 month 04:01' as timestamp without time zone) AS time) AS "07:31:00";
-  07:31:00 
- ----------
-- 07:31:00
-+ 08:31:00
- (1 row)
- 
- SELECT t.d1 AS t, i.f1 AS i, t.d1 + i.f1 AS "add", t.d1 - i.f1 AS "subtract"
 @@ -1049,347 +676,67 @@
    WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
      AND i.f1 BETWEEN '00:00' AND '23:00'
@@ -2955,11 +2938,11 @@
 - 1997-02-10 17:32:01
 - 1997-02-10 17:32:01
 - 1997-02-10 17:32:01
+- 1997-02-10 17:32:01
   1997-02-10 17:32:01
   1997-02-10 17:32:01
   1997-02-10 17:32:01
   1997-02-10 17:32:01
-- 1997-02-10 17:32:01
 - 1997-02-10 17:32:01
 - 1997-06-10 18:32:01
 - 1997-02-10 17:32:01
If the diff is expected, copy horology.diffs from the test artifacts to pkg/cmd/roachtest/testdata/horology.diffs
test artifacts and logs in: /artifacts/pg_regress/run_1

Parameters:

  • arch=amd64
  • cloud=gce
  • coverageBuild=false
  • cpu=4
  • encrypted=false
  • metamorphicLeases=expiration
  • runtimeAssertionsBuild=false
  • ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-56316

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-masterFailures and bugs on the master branch.

    Type

    No type

    Projects

    Status

    Short-term

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions