pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed

[cockroach-teamcity]

pkg/ccl/testccl/workload/schemachange/schemachange_test.TestWorkload failed with artifacts on release-23.1 @ 1ae85d2986e88578216a11776be952f63e593e87:

1, 29, protected_ts_meta, 31
1, 29, protected_ts_records, 32
1, 29, rangelog, 13
1, 29, replication_constraint_stats, 25
1, 29, replication_critical_localities, 26
1, 29, replication_stats, 27
1, 29, reports_meta, 28
1, 29, role_id_seq, 48
1, 29, role_members, 23
1, 29, role_options, 33
1, 29, scheduled_jobs, 37
1, 29, settings, 6
1, 29, span_configurations, 47
1, 29, span_stats_buckets, 55
1, 29, span_stats_samples, 56
1, 29, span_stats_tenant_boundaries, 57
1, 29, span_stats_unique_keys, 54
1, 29, sql_instances, 46
1, 29, sqlliveness, 39
1, 29, statement_activity, 60
1, 29, statement_bundle_chunks, 34
1, 29, statement_diagnostics, 36
1, 29, statement_diagnostics_requests, 35
1, 29, statement_statistics, 42
1, 29, table_statistics, 20
1, 29, task_payloads, 58
1, 29, tenant_id_seq, 62
1, 29, tenant_settings, 50
1, 29, tenant_tasks, 59
1, 29, tenant_usage, 45
1, 29, tenants, 8
1, 29, transaction_activity, 61
1, 29, transaction_statistics, 43
1, 29, ui, 14
1, 29, users, 4
1, 29, web_sessions, 19
1, 29, zones, 5
100, 0, public, 101
102, 0, public, 103
104, 0, public, 105
104, 0, schema171, 142
104, 105, _enum17, 109
104, 105, _enum51, 119
104, 105, enum17, 108
104, 105, enum51, 118
104, 105, seq152, 114
    schema_change_external_test.go:80: backup in /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload1604757918
    panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload1604757918
--- FAIL: TestWorkload (52.28s)

Parameters:

• TAGS=bazel,gss,deadlock
  Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #119288 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [mismatched type in violatesFkConstraintsHelper query] [C-test-failure O-robot P-1 T-sql-foundations branch-master] - #118879 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [C-test-failure O-robot P-3 T-sql-foundations branch-release-23.1.15-rc] - #117782 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [C-test-failure O-robot P-3 T-sql-foundations branch-release-23.2.0-rc]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-36245

[fqazi]

@annrpom Check if it reproduces on 23.1, at least from a quick test I can't repro on master. Worst case we just close this out if we can't get to the bottom of the failure

[rafiss]

error was:

{
 "workerId": 1,
 "clientTimestamp": "08:53:08.403766",
 "ops": [
  "BEGIN",
  {
   "sql": "CREATE SEQUENCE IF NOT EXISTS schema171.seq174"
  },
  {
   "sql": "CREATE TABLE IF NOT EXISTS schema171.table175 (\"col175_\t176\" INTERVAL NOT NULL, PRIMARY KEY (\"col175_\t176\"), INDEX (\"col175_\t176\"), UNIQUE (\"col175_\t176\"), INDEX (\"col175_\t176\" ASC), INDEX (\"col175_\t176\" DESC), UNIQUE (\"col175_\t176\" ASC) PARTITION BY LIST (\"col175_\t176\") (PARTITION \"table1!75_part0\" VALUES IN (('-26 years -8 mons -875 days -02:20:21.060252':::INTERVAL,), ('1 year 49 days 05:24:35.66799':::INTERVAL,), ('5 years 69 days 01:52:33.921745':::INTERVAL,), ('-72 years -3 mons -677 days -15:55:40.236265':::INTERVAL,), ('29 years 4 mons 897 days 18:28:55.702176':::INTERVAL,), ('-17 years -2 mons -322 days -16:59:54.318102':::INTERVAL,), ('4 years 1 mon 575 days 08:34:40.904764':::INTERVAL,), ('19 years 561 days 17:18:31.45777':::INTERVAL,), ('19 years 1 mon 54 days 00:51:26.972594':::INTERVAL,), ('5 years 10 mons 563 days 02:36:26.774911':::INTERVAL,)), PARTITION \"table17)5_part1\" VALUES IN (('60 years 6 mons 803 days 23:26:15.651533':::INTERVAL,), ('00:00:00':::INTERVAL,), ('44 years 3 mons 578 days 04:53:48.049242':::INTERVAL,), ('37 years 10 mons 393 days 11:34:34.827569':::INTERVAL,), ('20 years 2 mons 897 days 13:28:01.505876':::INTERVAL,), ('-74 years -1 mons -7 days -12:33:11.463518':::INTERVAL,), ('290 years':::INTERVAL,), ('-26 years -9 mons -569 days -09:46:02.171294':::INTERVAL,), ('-6 years -234 days -20:09:50.96176':::INTERVAL,), ('1 day':::INTERVAL,)), PARTITION \"DEFAULT\" VALUES IN ((DEFAULT,))), UNIQUE (\"col175_\t176\"), UNIQUE (\"col175_\t176\" DESC), UNIQUE (\"col175_\t176\" ASC))"
  },
  {
   "sql": "SELECT t2.\"col175_\t176\" AS col0,t2.\"col175_\t176\" AS col1,t0.\"col175_\t176\" AS col2 FROM schema171.table175 AS t0 ,schema171.table175 AS t1 ,schema171.table175 AS t2  FETCH FIRST 1 ROWS ONLY",
   "potentialExecErr": "53100,53200,57014"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: relation \"schema171.table175\" does not exist (SQLSTATE 42P01)",
...
}