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

[github-actions[bot]]

pkg/ccl/testccl/workload/schemachange/schemachange_test.TestWorkload failed on release-24.3 @ 59710ae3d1105bca768e4d340c797a40419a5e27:

 ],
 "expectedExecErrors": "42P07",
 "expectedCommitErrors": "",
 "message": "ROLLBACK; Successfully got expected execution error.: ERROR: relation \"schemachange.public.table_w0_166\" already exists (SQLSTATE 42P07)"
}
{
 "workerId": 0,
 "clientTimestamp": "18:20:40.965649",
 "ops": [
  "BEGIN",
  {
   "sql": "SELECT t2.col201_w1_215 AS col0, t0.col268_w1_276 AS col1, t0.col268_w1_270 AS col2, t2.col_w1_201_w1_266 AS col3, t2.col201_w1_211 AS col4, t0.col268_w1_271 AS col5, t0.col268_w1_275 AS col6, t2.col201_w1_212 AS col7, t0.col268_w1_275 AS col8, t2.col201_w1_210 AS col9, t2.col201_w1_208 AS col10, t2.col201_w1_216 AS col11, t2.col201_w1_211 AS col12, t0.col268_w1_274 AS col13 FROM schema_w0_26.table_w1_268 AS t0 ,public.table_w0_230 AS t1 ,schema_w1_101.table_w1_201 AS t2 FETCH FIRST 1 ROWS ONLY",
   "expectedExecErr": "42P01",
   "potentialExecErr": "53100,53200,57014"
  }
 ],
 "expectedExecErrors": "42P01",
 "expectedCommitErrors": "",
 "message": "ROLLBACK; Successfully got expected execution error.: ERROR: relation \"public.table_w0_230\" does not exist (SQLSTATE 42P01)"
}
{
 "workerId": 0,
 "clientTimestamp": "18:20:41.527693",
 "ops": [
  "BEGIN",
  {
   "sql": "SELECT t1.col186_w0_202 AS col0, t1.col186_w0_192 AS col1, t1.col186_w0_191 AS col2, t1.col186_w0_187 AS col3 FROM public.table_w0_231 AS t0 ,schema_w1_101.table_w0_186 AS t1 FETCH FIRST 1 ROWS ONLY",
   "expectedExecErr": "42P01",
   "potentialExecErr": "53100,53200,57014"
  }
 ],
 "expectedExecErrors": "42P01",
 "expectedCommitErrors": "",
 "message": "ROLLBACK; Successfully got expected execution error.: ERROR: relation \"public.table_w0_231\" does not exist (SQLSTATE 42P01)"
}
{
 "workerId": 0,
 "clientTimestamp": "18:20:41.611684",
 "ops": [
  "BEGIN",
  {
   "sql": "INSERT INTO schema_w0_26.table_w0_228 (col232_w1_237, col201_w1_209, col201_w1_204, col201_w1_210) VALUES ('1985-10-19':::DATE,'14:39:25.309358':::TIME,'01030000C001000000050000009ACD9FA87C2500C255C7289B4927FCC18D89280C35EEF2C18C9F1FC9DC0701427813539E3094E9C102517AAB3C77EEC194157926F5F3FF4130CAFD66DA5FE64100401F533B8A97C1F1C83874719D00C2E404FE081D7CF541361317028E6902C24011CAD450F0BD41F662536C0EB500425879D756AB29F441B3678E00820DF5C19ACD9FA87C2500C255C7289B4927FCC18D89280C35EEF2C18C9F1FC9DC070142':::GEOMETRY,NULL)",
   "potentialExecErr": "23502,23514"
  },
  "COMMIT"
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": ""
}

Parameters:

• attempt=1
• run=1
• shard=1
  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-43496

[cockroach-teamcity]

pkg/ccl/testccl/workload/schemachange/schemachange_test.TestWorkload failed on release-24.3 @ 3839fb143f98e5009a994ad58fb6b82dc7badc55:

   "potentialExecErr": "42601"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "ROLLBACK; Successfully got expected execution error.: ERROR: column \"col6_w1_11\" of relation \"table_w1_6\" is a computed column (SQLSTATE 42601)"
}
{
 "workerId": 1,
 "clientTimestamp": "06:54:40.959089",
 "ops": [
  "BEGIN",
  {
   "sql": "SELECT t0.col6_w1_11 AS col0, t0.col6_w1_12 AS col1, t0.col6_w1_10 AS col2, t0.col6_w1_10 AS col3, t0.col6_w1_10 AS col4, t0.col6_w1_7 AS col5 FROM public.table_w1_6 AS t0 FETCH FIRST 1 ROWS ONLY",
   "potentialExecErr": "53100,53200,57014"
  }
 ],
 "expectedExecErrors": "",
 "expectedCommitErrors": "",
 "message": "ERROR: internal error: requested column col6_w1_10 not in index (SQLSTATE XX000)"
}
    schema_change_external_test.go:131: 
            Error Trace:    pkg/ccl/testccl/workload/schemachange/schemachange_test_test/pkg/ccl/testccl/workload/schemachange/schema_change_external_test.go:131
            Error:          Received unexpected error:
                            ***UNEXPECTED ERROR: ERROR: internal error: requested column col6_w1_10 not in index (SQLSTATE XX000)
                            (1) attached stack trace
                              -- stack trace:
                              | github.com/cockroachdb/cockroach/pkg/workload/schemachange.(*schemaChangeWorker).run
                              |     github.com/cockroachdb/cockroach/pkg/workload/schemachange/schemachange.go:618
                              | pkg/ccl/testccl/workload/schemachange/schemachange_test_test.TestWorkload.TestWorkload.func4.func6
                              |     pkg/ccl/testccl/workload/schemachange/schemachange_test_test/pkg/ccl/testccl/workload/schemachange/schema_change_external_test.go:120
                              | golang.org/x/sync/errgroup.(*Group).Go.func1
                              |     golang.org/x/sync/errgroup/external/org_golang_x_sync/errgroup/errgroup.go:78
                              | runtime.goexit
                              |     src/runtime/asm_amd64.s:1695
                            Wraps: (2) ***UNEXPECTED ERROR
                            Wraps: (3) ERROR: internal error: requested column col6_w1_10 not in index (SQLSTATE XX000)
                            Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *pgconn.PgError
            Test:           TestWorkload
Schema Workload Stats
Total Schema Statements Executed = 24
Total Schema Statements Succeeded = 24
Total Schema Statement Expected Failures = 0
Total Transactions Committed = 15
Total Transactions Rolled Back = 17
Total Transactions Executed = 32
    schema_change_external_test.go:96: backup, tracing data, and system table dumps in /var/lib/engflow/worker/work/3/exec/bazel-out/k8-fastbuild/testlogs/pkg/ccl/testccl/workload/schemachange/schemachange_test/run_21_of_25/test.outputs/logTestWorkload2969065234
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestWorkload2969065234
--- FAIL: TestWorkload (10.26s)

Parameters:

• attempt=1
• run=21
• shard=1
  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]

This test on roachdash | Improve this report!