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.2.19-rc @ 49acfe2ec569eee317e7100954ba3f340a5ecf08:

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_execution_insights, 65
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_execution_insights, 64
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, 105, _enum346, 149
104, 105, enum346, 148
104, 105, table223, 137
104, 105, table237, 138
104, 105, table270, 139
104, 105, table294, 141
104, 105, table342, 147
104, 105, table350, 151
    schema_change_external_test.go:79: backup in /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload3724759211
    panic.go:523: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/fcba020ca7cb44bf8385bd0e13bcbe2d/logTestWorkload3724759211
--- FAIL: TestWorkload (157.91s)

Parameters:

• TAGS=bazel,gss,deadlock
• stress=true

Help

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

Same failure on other branches

• pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [requested column not in index] #137972 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [C-test-failure O-robot T-sql-foundations branch-release-24.3.3-rc release-blocker]
• pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed #136966 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [C-test-failure O-robot P-2 T-sql-foundations branch-master]
• pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed #136308 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [C-test-failure O-robot P-3 T-sql-foundations branch-release-24.3.0-rc]
• pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed #136305 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [C-test-failure O-robot P-3 T-sql-foundations branch-release-24.3.1-rc]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-45832

[annrpom]

E241225 10:27:02.346842 12889775 jobs/registry.go:1677 â‹® [T1,Vsystem,n3] 10129  NEW SCHEMA CHANGE job
 1032362284406177793: stepping through state reverting with unexpected error: failed to read descriptors [137 142] for the 
declarative schema change state: referenced descriptor ID 142: looking up ID 142: descriptor not found

[annrpom]

ah found the workload op:

{
 "workerId": 0,
 "clientTimestamp": "10:26:05.72153",
 "ops": [
  "BEGIN",
  {
   "sql": "DROP VIEW public.view347 CASCADE"
  },
  "COMMIT"
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "***UNEXPECTED COMMIT ERROR; Received an unexpected commit error: ERROR: transaction committed but schema change aborted with error: (XXUUU): failed to read descriptors [137 142] for the declarative schema change state: referenced descriptor ID 142: looking up ID 142: descriptor not found (SQLSTATE XXUUU)",

[annrpom]

seems to be a dupe of #137487; we aren't backporting the fix to this branch. i'll leave this open until this branch is axed