Skip to content

roachtest: psycopg failed [release-25.3: disallowed due to schema_locked] #154625

New issue
New issue
Closed
Closed
roachtest: psycopg failed [release-25.3: disallowed due to schema_locked]#154625
Labels
B-runtime-assertions-enabledC-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.P-1Issues/test failures with a fix SLA of 1 monthT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-release-25.3Used to mark GA and release blockers and technical advisories for 25.3
@cockroach-teamcity

Description

@cockroach-teamcity
cockroach-teamcity
opened on Oct 2, 2025

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.psycopg failed with artifacts on release-25.3 @ 35b2d15446aa78530a4ff85f359764cb35d033d0:

--- FAIL: tests.test_cursor_common.test_executemany_no_result[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_rowcount[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_returning[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_returning_discard[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_returning_discard[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_rowcount_no_hit[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_rowcount[asyncio-ClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_name[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_no_result[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_name[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_rowcount[asyncio-AsyncCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany[asyncio-ClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_no_result[asyncio-AsyncCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_returning_discard[asyncio-ClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_returning[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_rowcount[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_name[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_no_data[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_rowcount_no_hit[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_name[asyncio-AsyncCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_returning[asyncio-AsyncCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_no_result[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_no_data[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_returning_discard[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_name[asyncio-ClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_name[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_rowcount_no_hit[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_no_data[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_rowcount_no_hit[asyncio-AsyncCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_returning[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_rowcount[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_no_result[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany[asyncio-AsyncCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_rowcount_no_hit[asyncio-ClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_returning[asyncio-ClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_returning_discard[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_no_data[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_rowcount[asyncio-Cursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_returning[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_rowcount_no_hit[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany[asyncio-RawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_no_result[asyncio-ClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany_no_data[asyncio-AsyncCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany[asyncio-AsyncRawCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common_async.test_executemany[asyncio-AsyncClientCursor] - unknown (unexpected)
--- FAIL: tests.test_cursor_common.test_executemany_no_data[asyncio-ClientCursor] - unknown (unexpected)
For a full summary look at the psycopg artifacts 
An updated blocklist (psycopgBlockList) is available in the artifacts' psycopg log
test artifacts and logs in: /artifacts/psycopg/run_1

Parameters:

  • arch=amd64
  • cloud=gce
  • coverageBuild=false
  • cpu=4
  • encrypted=false
  • 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-55044

Metadata

Metadata

Assignees

No one assigned

    Labels

    B-runtime-assertions-enabledC-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.P-1Issues/test failures with a fix SLA of 1 monthT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-release-25.3Used to mark GA and release blockers and technical advisories for 25.3

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions