Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

roachtest: pg_regress failed #123401

Closed
cockroach-teamcity opened this issue May 1, 2024 · 2 comments · Fixed by #123707
Closed

roachtest: pg_regress failed #123401

cockroach-teamcity opened this issue May 1, 2024 · 2 comments · Fixed by #123707
Assignees
@yuzefovich
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team
Milestone
24.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented May 1, 2024 •
edited by cockroach-jira-scripts
Loading

roachtest.pg_regress failed with artifacts on master @ af3173a899e16af30d2ca9489d8c2c926c410121:

 +
 +If you would rather not post publicly, please contact us directly
 +using the support form.
- 
++
 +We appreciate your feedback.
 +
 +select stacked_diagnostics_test();
@@ -249582,10 +249599,10 @@
 +Please check the public issue tracker to check whether this problem is
 +already tracked. If you cannot find it there, please report the error
 +with details by creating a new issue.
-+
+ 
 +If you would rather not post publicly, please contact us directly
 +using the support form.
- 
++
 +We appreciate your feedback.
 +
 +select foreach_test(ARRAY[1,2,3,4]);
@@ -249834,12 +249851,12 @@
 +Please check the public issue tracker to check whether this problem is
 +already tracked. If you cannot find it there, please report the error
 +with details by creating a new issue.
-+
+ 
 +If you would rather not post publicly, please contact us directly
 +using the support form.
 +
 +We appreciate your feedback.
- 
++
 +select foreach_test(ARRAY[(10,20),(40,69),(35,78)]::xy_tuple[]);
 +ERROR:  unknown function: foreach_test()
 +select foreach_test(ARRAY[[(10,20),(40,69)],[(35,78),(88,76)]]::xy_tuple[]);
@@ -276568,9 +276585,9 @@
 +
 +If you would rather not post publicly, please contact us directly
 +using the support form.
-+
+ 
 +We appreciate your feedback.
- 
++
 +select f1();
 +ERROR:  unknown function: f1()
  -- non-top-level command
If the diff is expected, copy regression.diffs from the test artifacts to pkg/cmd/roachtest/testdata/regression.diffs
test artifacts and logs in: artifacts/pg_regress/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=gce
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_metamorphicBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-38344
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team labels May 1, 2024
@cockroach-teamcity cockroach-teamcity added this to the 24.1 milestone May 1, 2024
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries May 1, 2024
@cockroach-teamcity
Copy link
Member Author

roachtest.pg_regress failed with artifacts on master @ 6e23d32dd0d36181f5c886c9a0eda9c756005bd6:

 +
 +If you would rather not post publicly, please contact us directly
 +using the support form.
- 
++
 +We appreciate your feedback.
 +
 +select stacked_diagnostics_test();
@@ -249582,10 +249588,10 @@
 +Please check the public issue tracker to check whether this problem is
 +already tracked. If you cannot find it there, please report the error
 +with details by creating a new issue.
-+
+ 
 +If you would rather not post publicly, please contact us directly
 +using the support form.
- 
++
 +We appreciate your feedback.
 +
 +select foreach_test(ARRAY[1,2,3,4]);
@@ -249834,12 +249840,12 @@
 +Please check the public issue tracker to check whether this problem is
 +already tracked. If you cannot find it there, please report the error
 +with details by creating a new issue.
-+
+ 
 +If you would rather not post publicly, please contact us directly
 +using the support form.
 +
 +We appreciate your feedback.
- 
++
 +select foreach_test(ARRAY[(10,20),(40,69),(35,78)]::xy_tuple[]);
 +ERROR:  unknown function: foreach_test()
 +select foreach_test(ARRAY[[(10,20),(40,69)],[(35,78),(88,76)]]::xy_tuple[]);
@@ -276568,9 +276574,9 @@
 +
 +If you would rather not post publicly, please contact us directly
 +using the support form.
-+
+ 
 +We appreciate your feedback.
- 
++
 +select f1();
 +ERROR:  unknown function: f1()
  -- non-top-level command
If the diff is expected, copy regression.diffs from the test artifacts to pkg/cmd/roachtest/testdata/regression.diffs
test artifacts and logs in: /artifacts/pg_regress/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=gce
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_metamorphicBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

@yuzefovich yuzefovich mentioned this issue May 5, 2024
Merged
craig bot pushed a commit that referenced this issue May 6, 2024
@yuzefovich
Merge #123652
208fd12 
123652: roachtest: skip opr_sanity.sql in pg_regress r=yuzefovich a=yuzefovich

We currently have incomplete `pg_catalog.pg_proc` contents, so `opr_sanity.sql` subtest results in invalid entries that need to be updated every time when a new builtin function is introduced, which is an unnecessary toil. Let's skip this subtest for now.

Informs: #123401.
Informs: #123651.
Epic: None

Release note: None

Co-authored-by: Yahor Yuzefovich <[email protected]>
@yuzefovich yuzefovich self-assigned this May 7, 2024
@yuzefovich yuzefovich moved this from Triage to Active in SQL Queries May 7, 2024
@yuzefovich yuzefovich mentioned this issue May 7, 2024
Merged
@cockroach-teamcity
Copy link
Member Author

roachtest.pg_regress failed with artifacts on master @ 59b261a579cbe2c032a5dd3e182ff67aeee900b9:

++NOTICE:  using sequential values in a primary key does not perform as well as using random UUIDs. See https://www.cockroachlabs.com/docs/v24.2/serial.html
  insert into rewriteme
       select x * 1.001 from generate_series(1, 500) as t(x);
  alter table rewriteme alter column foo type numeric;
 -ERROR:  rewrites not allowed
 -CONTEXT:  PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE
 +ERROR:  ALTER COLUMN TYPE from float to decimal is only supported experimentally
-+HINT:  See: https://go.crdb.dev/issue-v/49329/v24.1
++HINT:  See: https://go.crdb.dev/issue-v/49329/v24.2
 +--
 +you can enable alter column type general support by running ``SET enable_experimental_alter_column_type_general = true``
  alter table rewriteme add column baz int default 0;
@@ -267590,7 +267594,7 @@
   alter column foo type numeric(10,4);
 -NOTICE:  Table 'rewriteme' is being rewritten (reason = 4)
 +ERROR:  ALTER COLUMN TYPE from float to decimal is only supported experimentally
-+HINT:  See: https://go.crdb.dev/issue-v/49329/v24.1
++HINT:  See: https://go.crdb.dev/issue-v/49329/v24.2
 +--
 +you can enable alter column type general support by running ``SET enable_experimental_alter_column_type_general = true``
  -- matview rewrite when changing access method
@@ -267612,7 +267616,7 @@
  -- shouldn't trigger a table_rewrite event
  alter table rewriteme alter column foo type numeric(12,4);
 +ERROR:  ALTER COLUMN TYPE from float to decimal is only supported experimentally
-+HINT:  See: https://go.crdb.dev/issue-v/49329/v24.1
++HINT:  See: https://go.crdb.dev/issue-v/49329/v24.2
 +--
 +you can enable alter column type general support by running ``SET enable_experimental_alter_column_type_general = true``
  begin;
@@ -267652,7 +267656,7 @@
 +alter type rewritetype alter attribute a type text cascade
 +                                                          ^
 +HINT:  You have attempted to use a feature that is not yet implemented.
-+See: https://go.crdb.dev/issue-v/48701/v24.1
++See: https://go.crdb.dev/issue-v/48701/v24.2
  -- but this doesn't work
  create table rewritemetoo3 (a rewritetype);
  alter type rewritetype alter attribute a type varchar cascade;
@@ -267662,7 +267666,7 @@
 +alter type rewritetype alter attribute a type varchar cascade
 +                                                             ^
 +HINT:  You have attempted to use a feature that is not yet implemented.
-+See: https://go.crdb.dev/issue-v/48701/v24.1
++See: https://go.crdb.dev/issue-v/48701/v24.2
  drop table rewriteme;
  drop event trigger no_rewrite_allowed;
 +ERROR:  at or near "event": syntax error
If the diff is expected, copy regression.diffs from the test artifacts to pkg/cmd/roachtest/testdata/regression.diffs
test artifacts and logs in: /artifacts/pg_regress/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=gce
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_metamorphicBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

@craig craig bot closed this as completed in 7c6feb0 May 14, 2024
@github-project-automation github-project-automation bot moved this from Active to Done in SQL Queries May 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yuzefovich yuzefovich

Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
24.1
Development

Successfully merging a pull request may close this issue.

roachtest: adjust pg_regress and the diff yuzefovich/cockroach
2 participants
@yuzefovich @cockroach-teamcity