roachtest: pg_regress failed

[cockroach-teamcity]

roachtest.pg_regress failed with artifacts on master @ 0f2bc7b8fb79175f32fe44754a872845cd01e038:

Failed with:

(pg_regress.go:499).runPGRegress: Regression diffs do not match expected output for create_view.
--- testdata/create_view.diffs
+++ create_view.diffs
@@ -977,7 +977,7 @@
  ALTER TABLE a2 RENAME TO tx1;
 +ERROR:  relation "a2" does not exist
  ALTER TABLE tx1 SET SCHEMA temp_view_test;
-+ERROR:  cannot set schema on relation "tx1" because view "aliased_view_1" depends on it
++ERROR:  cannot set schema on relation "root.testviewschm2.tx1" because view "aliased_view_1" depends on it
 +HINT:  consider dropping "aliased_view_1" first.
  \d+ aliased_view_1
 -                    View "testviewschm2.aliased_view_1"
If the diff is expected, copy create_view.diffs from the test artifacts to pkg/cmd/roachtest/testdata/create_view.diffs
(pg_regress.go:499).runPGRegress: Regression diffs do not match expected output for matview.
--- testdata/matview.diffs
+++ matview.diffs
@@ -164,7 +164,7 @@
  -- test schema behavior
  CREATE SCHEMA mvtest_mvschema;
  ALTER MATERIALIZED VIEW mvtest_tvm SET SCHEMA mvtest_mvschema;
-+ERROR:  cannot set schema on relation "mvtest_tvm" because view "mvtest_tvmm" depends on it
++ERROR:  cannot set schema on relation "root.public.mvtest_tvm" because view "mvtest_tvmm" depends on it
 +HINT:  consider dropping "mvtest_tvmm" first.
  \d+ mvtest_tvm
 +ERROR:  at or near ".": syntax error
If the diff is expected, copy matview.diffs from the test artifacts to pkg/cmd/roachtest/testdata/matview.diffs
(pg_regress.go:499).runPGRegress: Regression diffs do not match expected output for alter_table.
--- testdata/alter_table.diffs
+++ alter_table.diffs
@@ -4359,10 +4359,10 @@
  insert into alter1.t1(f2) values(11);
  insert into alter1.t1(f2) values(12);
  alter table alter1.t1 set schema alter1; -- no-op, same schema
-+ERROR:  cannot set schema on relation "t1" because view "v1" depends on it
++ERROR:  cannot set schema on relation "root.alter1.t1" because view "v1" depends on it
 +HINT:  consider dropping "v1" first.
  alter table alter1.t1 set schema alter2;
-+ERROR:  cannot set schema on relation "t1" because view "v1" depends on it
++ERROR:  cannot set schema on relation "root.alter1.t1" because view "v1" depends on it
 +HINT:  consider dropping "v1" first.
  alter table alter1.v1 set schema alter2;
  alter function alter1.plus1(int) set schema alter2;
@@ -5390,13 +5390,13 @@
  CREATE TABLE new_system_table(id serial primary key, othercol text);
 +NOTICE:  using sequential values in a primary key does not perform as well as using random UUIDs. See https://www.cockroachlabs.com/docs/_version_/serial.html
  ALTER TABLE new_system_table SET SCHEMA pg_catalog;
-+ERROR:  cannot move objects into or out of virtual schemas
++ERROR:  user test_admin does not have CREATE privilege on schema pg_catalog
  ALTER TABLE new_system_table SET SCHEMA public;
  ALTER TABLE new_system_table SET SCHEMA pg_catalog;
-+ERROR:  cannot move objects into or out of virtual schemas
++ERROR:  user test_admin does not have CREATE privilege on schema pg_catalog
  -- will be ignored -- already there:
  ALTER TABLE new_system_table SET SCHEMA pg_catalog;
-+ERROR:  cannot move objects into or out of virtual schemas
++ERROR:  user test_admin does not have CREATE privilege on schema pg_catalog
  ALTER TABLE new_system_table RENAME TO old_system_table;
  CREATE INDEX old_system_table__othercol ON old_system_table (othercol);
  INSERT INTO old_system_table(othercol) VALUES ('somedata'), ('otherdata');
If the diff is expected, copy alter_table.diffs from the test artifacts to pkg/cmd/roachtest/testdata/alter_table.diffs
test artifacts and logs in: /artifacts/pg_regress/run_1

Cluster Node to Ip Mapping:

Node	Public IP	Private IP
teamcity-20789941-1764398814-70-n1cpu4-0001	34.73.95.133	10.142.1.81

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• fs=ext4
• localSSD=true
• 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-57332