Skip to content

sql: TestSavepoints failed #72911

@cockroach-teamcity

Description

@cockroach-teamcity

sql.TestSavepoints failed with artifacts on release-21.2 @ de3aa0be93809feccd8040bf55cdbb8bea8cb1e9:

=== RUN   TestSavepoints
    test_log_scope.go:79: test logs captured to: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestSavepoints595601019
    test_log_scope.go:80: use -show-logs to present logs inline
=== CONT  TestSavepoints
    panic.go:613: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestSavepoints595601019
--- FAIL: TestSavepoints (1.42s)
=== RUN   TestSavepoints/rollback_after_lock_timeout
    conn_executor_savepoints_test.go:107: 7: reading progress: pq: canceling statement due to lock timeout on row (conn,n)=('default',3) in progress@primary
    datadriven.go:243: 
        testdata/savepoints:265: SET lock_timeout = '1ms'
        BEGIN
        SAVEPOINT foo
        SELECT * FROM t WHERE x = 1 FOR UPDATE
        ROLLBACK TO SAVEPOINT foo
        SELECT * FROM t WHERE x = 2 FOR UPDATE
        COMMIT
        SET lock_timeout = 0
        output didn't match expected:
        @@ -9,9 +9,9 @@
         5: ROLLBACK TO SAVEPOINT foo -- 0 rows
         -- Aborted     -> Open        ###.....  foo
         6: SELECT * FROM t WHERE x = 2 FOR UPDATE -- 0 rows
         -- Open        -> Open        ###..#..  foo
         7: COMMIT -- 0 rows
        --- Open        -> NoTxn       ###..##.  (none)
        +-- Open        -> NoTxn       ........  (none)
         8: SET lock_timeout = 0 -- 0 rows
         -- NoTxn       -> NoTxn       ###..###  (none)
         
    --- FAIL: TestSavepoints/rollback_after_lock_timeout (0.08s)
Reproduce

To reproduce, try:

make stressrace TESTS=TestSavepoints PKG=./pkg/sql TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Parameters in this failure:

  • GOFLAGS=-json

Same failure on other branches

/cc @cockroachdb/sql-queries andreimatei

This test on roachdash | Improve this report!

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.T-kvKV TeamT-sql-queriesSQL Queries TeamX-stale

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions