Skip to content

roachtest: pg_regress failed #155302

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.pg_regress failed with artifacts on master @ 7d15c710e7514e363557c2d7e7d0fe736e1e7e24:

  -- matview rewrite when changing access method
  CREATE MATERIALIZED VIEW heapmv USING heap AS SELECT 1 AS a;
 +ERROR:  at or near "using": syntax error
@@ -861,7 +878,7 @@
  -- typed tables are rewritten when their type changes.  Don't emit table
  -- name, because firing order is not stable.
  CREATE OR REPLACE FUNCTION test_evtrig_no_rewrite() RETURNS event_trigger
-@@ -541,21 +728,52 @@
+@@ -541,21 +744,56 @@
                 pg_event_trigger_table_rewrite_reason();
  END;
  $$;
@@ -890,6 +907,8 @@
 +See: https://go.crdb.dev/issue-v/48701/_version_
  -- but this doesn't work
  create table rewritemetoo3 (a rewritetype);
++NOTICE:  waiting for job(s) to complete: 1114423678558339073
++If the statement is canceled, jobs will continue in the background.
  alter type rewritetype alter attribute a type varchar cascade;
 -ERROR:  cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it
 +ERROR:  at or near "EOF": syntax error: unimplemented: this syntax
@@ -899,6 +918,8 @@
 +HINT:  You have attempted to use a feature that is not yet implemented.
 +See: https://go.crdb.dev/issue-v/48701/_version_
  drop table rewriteme;
++NOTICE:  waiting for job(s) to complete: 1114423678822350849
++If the statement is canceled, jobs will continue in the background.
  drop event trigger no_rewrite_allowed;
 +ERROR:  at or near "event": syntax error
 +DETAIL:  source SQL:
@@ -917,7 +938,7 @@
  CREATE TABLE event_trigger_test (a integer, b text);
  CREATE OR REPLACE FUNCTION start_command()
  RETURNS event_trigger AS $$
-@@ -563,37 +781,46 @@
+@@ -563,37 +801,46 @@
  RAISE NOTICE '% - ddl_command_start', tg_tag;
  END;
  $$ LANGUAGE plpgsql;
@@ -973,7 +994,7 @@
  -- Check the object addresses of all the event triggers.
  SELECT
      e.evtname,
-@@ -604,13 +831,22 @@
+@@ -604,13 +851,22 @@
      LATERAL pg_identify_object_as_address('pg_event_trigger'::regclass, e.oid, 0) as b,
      LATERAL pg_get_object_address(b.type, b.object_names, b.object_args) as a
    ORDER BY e.evtname;
If the diff is expected, copy event_trigger.diffs from the test artifacts to pkg/cmd/roachtest/testdata/event_trigger.diffs
test artifacts and logs in: /artifacts/pg_regress/run_1

Parameters:

  • arch=amd64
  • cloud=gce
  • coverageBuild=false
  • cpu=4
  • encrypted=false
  • metamorphicLeases=default
  • 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-55348

Metadata

Metadata

Assignees

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions