roachtest: knex failed [release-25.3: disallowed due to schema_locked]

[cockroach-teamcity]

Note: This build has runtime assertions enabled. If the same failure was hit in a run without assertions enabled, there should be a similar failure without this message. If there isn't one, then this failure is likely due to an assertion violation or (assertion) timeout.

roachtest.knex failed with artifacts on release-25.3.3-rc @ 08bccf9a4ce6d8e93b9205138c27cd0b7d2ac769:

(knex.go:125).func1: COMMAND_PROBLEM: exit status 16
test artifacts and logs in: /artifacts/knex/run_1

Parameters:

• arch=amd64
• cloud=gce
• coverageBuild=false
• cpu=4
• encrypted=false
• fs=ext4
• localSSD=true
• metamorphicBufferedSender=true
• metamorphicLeases=epoch
• metamorphicWriteBuffering=true
• runtimeAssertionsBuild=true
• ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-55042

[rafiss]

  14) Updates
       cockroachdb
         "before each" hook for "should handle updates":
     error: truncate "accounts" - this schema change is disallowed because table "accounts" is locked and this operation cannot automatically unlock the table
      at Parser.parseErrorMessage (node_modules/pg-protocol/src/parser.ts:369:69)
      at Parser.handlePacket (node_modules/pg-protocol/src/parser.ts:187:21)
      at Parser.parse (node_modules/pg-protocol/src/parser.ts:102:30)
      at TLSSocket.<anonymous> (node_modules/pg-protocol/src/index.ts:7:48)
      at TLSSocket.emit (node:events:517:28)
      at addChunk (node:internal/streams/readable:368:12)
      at readableAddChunk (node:internal/streams/readable:341:9)
      at TLSSocket.Readable.push (node:internal/streams/readable:278:10)
      at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23)

seems like #154530 didn't fix this

[fqazi]

@rafiss I think this happens in the nightlies because we pick a build with assertions enabled, which will also default to create_table_with_schema_locked. I'll modify the test to just explicitly disable this setting instead. See:

cockroach/build/teamcity/cockroach/nightlies/roachtest_compile_component.sh

Line 74 in 552cfcb

bazel_args=(--config force_build_cdeps --config pgo --norun_validations //pkg/cmd/cockroach --crdb_test $crdb_extra_flags)

[rafiss]

fixed by #154770