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 @ deae9a6e30d886969c9999d89a7a4a893a71efd0:

1, 29, namespace, 30
1, 29, privileges, 51
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, schema1, 106
104, 0, schema32, 114
104, 105, seq2, 107
104, 106, seq29, 113
    schema_change_external_test.go:77: backup in /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload3702106274
    panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload3702106274
--- FAIL: TestWorkload (25.08s)

Parameters:

• TAGS=bazel,gss,deadlock
  Help

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

Same failure on other branches

- #132298 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [column is referenced by the primary key] [C-test-failure O-robot P-2 T-sql-foundations branch-master]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-43898

[fqazi]

Table is created and selected from in the same txn, this should work:

    {
10:27:05      "workerId": 1,
10:27:05      "clientTimestamp": "10:27:02.596115",
10:27:05      "ops": [
10:27:05       "BEGIN",
10:27:05       {
10:27:05        "sql": "SELECT 'validating all objects', crdb_internal.validate_multi_region_zone_configs()"
10:27:05       },
10:27:05       {
10:27:05        "sql": "CREATE TABLE IF NOT EXISTS schema32.table35 (\"col35_\n36\" REGTYPE, \"col35_\u000b37\" REGROLE NULL, col35_38 STRING COLLATE en_US NOT NULL, \"col3)5_39\" REGTYPE, \"cOl35_40\" BIT(29)[], \" col35_41\" NAME[] NOT NULL, col35_42 TIME NOT NULL, col35_43 \"char\" NOT NULL, col35_44 BOX2D NOT NULL, \"col3-5_%p45\" TSVECTOR NULL, \"col\r35_46\" OID NULL, col35_̕47 FLOAT8 NULL, col35_48 OID, INDEX (col35_42, \"col\r35_46\" ASC, \"col35_\u000b37\", \"col3)5_39\"))",
10:27:05        "potentialExecErr": "0A000,42601"
10:27:05       },
10:27:05       {
10:27:05        "sql": "SELECT t2.\" col35_41\" AS col0,t0.\"cOl35_40\" AS col1,t2.\"col3)5_39\" AS col2,t2.col35_38 AS col3,t1.\"col3-5_%p45\" AS col4,t2.col35_44 AS col5,t2.col35_̕47 AS col6,t1.\"col35_\u000b37\" AS col7,t1.\"col\r35_46\" AS col8,t0.\"col\r35_46\" AS col9,t0.col35_44 AS col10,t0.\"col35_\n36\" AS col11,t2.col35_38 AS col12 FROM schema32.table35 AS t0 ,schema32.table35 AS t1 ,schema32.table35 AS t2  FETCH FIRST 1 ROWS ONLY",
10:27:05        "potentialExecErr": "53100,53200,57014"
10:27:05       }
10:27:05      ],
10:27:05      "expectedExecErrors": "",
10:27:05      "expectedCommitErrors": "",
10:27:05      "message": "***UNEXPECTED ERROR; Received an unexpected execution error.: ERROR: relation \"schema32.table35\" does not exist (SQLSTATE 42P01)",
10:27:05      "errorState": {
10:27:05       "potentialErrors": [
10:27:05        "53100",
10:27:05        "53200",
10:27:05        "57014"
10:27:05       ],