pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [error with DROP VALUE followed by DROP SCHEMA in same txn]

[cockroach-teamcity]

pkg/ccl/testccl/workload/schemachange/schemachange_test.TestWorkload failed on release-24.1.0-rc @ 010b7b3b3f4ad23b2f0483d8d2b450961a51470c:

    "result": []
   },
   {
    "query": "WITH descriptors AS (SELECT descriptor.id, \"parentSchemaID\" AS schema_id, namespace.name AS name, crdb_internal.pb_to_json('desc', descriptor) AS descriptor FROM system.descriptor JOIN (SELECT * FROM system.namespace UNION SELECT \"parentID\", \"parentSchemaID\", (json_each).@1 AS name, (json_array_elements((json_each).@2-\u003e'signatures')-\u003e'id')::INT8 AS id FROM (SELECT ns.\"parentID\", ns.id AS \"parentSchemaID\", json_each((crdb_internal.pb_to_json('desc', descriptor)-\u003e'schema')-\u003e'functions') FROM system.descriptor JOIN system.namespace AS ns ON ns.id = descriptor.id WHERE crdb_internal.pb_to_json('desc', descriptor) ? 'schema')) AS namespace ON namespace.id = descriptor.id WHERE \"parentID\" = (SELECT id FROM system.namespace WHERE (name = current_database()) AND (\"parentID\" = 0))), functions AS (SELECT id, schema_id, name, descriptor-\u003e'function' AS descriptor FROM descriptors WHERE descriptor ? 'function'), pg_depends_from_diff_schema AS (SELECT refobjid FROM pg_depend AS d, functions AS src_function, functions AS dst_function WHERE (((((src_function.schema_id != $1::REGNAMESPACE::INT8) AND (dst_function.schema_id = $1::REGNAMESPACE::INT8)) AND (d.objid = (src_function.id + 100000))) AND (d.refobjid = (dst_function.id + 100000))) AND (d.classid = 'pg_catalog.pg_proc'::REGCLASS::INT8)) AND (d.refclassid = 'pg_catalog.pg_proc'::REGCLASS::INT8)) SELECT * FROM pg_depends_from_diff_schema",
    "queryArgs": [
     "schema_w0_2"
    ],
    "result": []
   }
  ],
  "previousStatements": [
   "ALTER TYPE schema_w0_2.enum_w0_68 DROP VALUE 'fsddsa'",
   "CREATE TYPE schema_w0_45.enum_w1_47 AS ENUM ('ds', 'dsdadd', 'afs', 'fasaf')",
   "DROP SCHEMA \"schema_w0_2\" CASCADE"
  ]
 }
}
    schema_change_external_test.go:132: 
        	Error Trace:	pkg/ccl/testccl/workload/schemachange/schemachange_test_test/pkg/ccl/testccl/workload/schemachange/schema_change_external_test.go:132
        	Error:      	Received unexpected error:
        	            	***UNEXPECTED COMMIT ERROR; Received an unexpected commit error: ERROR: transaction committed but schema change aborted with error: (42704): type with ID 141 does not exist (SQLSTATE 42704)
        	            	(1) forced error mark
        	            	  | "fatal error when running txn"
        	            	  | github.com/cockroachdb/errors/withstack/*withstack.withStack::
        	            	Wraps: (2)
        	            	Wraps: (3) attached stack trace
        	            	  -- stack trace:
        	            	  | github.com/cockroachdb/cockroach/pkg/workload/schemachange.(*schemaChangeWorker).run
        	            	  | 	github.com/cockroachdb/cockroach/pkg/workload/schemachange/schemachange.go:676
        	            	  | 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:121
        	            	  | 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: (4) ***UNEXPECTED COMMIT ERROR; Received an unexpected commit error
        	            	Wraps: (5) ERROR: transaction committed but schema change aborted with error: (42704): type with ID 141 does not exist (SQLSTATE 42704)
        	            	Error types: (1) *markers.withMark (2) *schemachange.ErrorState (3) *withstack.withStack (4) *errutil.withPrefix (5) *pgconn.PgError
        	Test:       	TestWorkload
Schema Workload Stats
Total Schema Statements Executed = 105
Total Schema Statements Succeeded = 105
Total Schema Statement Expected Failures = 0
Total Transactions Committed = 60
Total Transactions Rolled Back = 88
Total Transactions Executed = 148
    schema_change_external_test.go:98: backup, tracing data, and system table dumps in /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/testlogs/pkg/ccl/testccl/workload/schemachange/schemachange_test/run_3_of_25/test.outputs/logTestWorkload3441212122
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestWorkload3441212122
--- FAIL: TestWorkload (20.99s)

Parameters:

• attempt=1
• run=3
• shard=1

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 [error with DROP VALUE followed by DROP SCHEMA in same txn] #123488 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [error with DROP VALUE followed by DROP SCHEMA in same txn] [C-test-failure O-robot T-sql-foundations branch-release-24.1]
• pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed #122785 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [C-test-failure O-robot P-1 T-sql-foundations branch-release-23.2.5-rc]
• pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [unexpected value 143] #122745 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [unexpected value 143] [C-test-failure O-robot P-2 T-sql-foundations branch-release-23.1]
• pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [error with DROP VALUE followed by DROP SCHEMA in same txn] #121828 pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [error with DROP VALUE followed by DROP SCHEMA in same txn] [C-test-failure O-robot O-schema-testing P-1 T-sql-foundations branch-release-23.2]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-38404

[rafiss]

same as #123488 (comment)