Skip to content

sql/logictest: schema_change_in_txn gets TransactionRetry error #53724

@cockroach-teamcity

Description

@cockroach-teamcity

(sql/logictest).TestLogic failed on master@4a25ab1bc85e404b1a8b3e28660e41e7e5063e0b:

=== RUN   TestLogic
--- FAIL: TestLogic (869.71s)
    logic.go:2812: randomize batchSize to 2
    test_log_scope.go:154: test logs captured to: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestLogic337250797
    test_log_scope.go:63: use -show-logs to present logs inline
=== RUN   TestLogic/local/schema_change_in_txn/delete_index_and_table_in_txn
--- done: testdata/logic_test/explain_analyze with config local: 22 tests, 0 failures
--- done: testdata/logic_test/materialized_view with config local: 35 tests, 0 failures
--- total progress: 9403 statements/queries
            --- FAIL: TestLogic/local/schema_change_in_txn/delete_index_and_table_in_txn (0.66s)
                logic.go:2347: 
                    
                    testdata/logic_test/schema_change_in_txn:1721: 
                    expected success, but found
                    (40001) restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=57a70e1e key=/Table/SystemConfigSpan/Start pri=0.01767040 epo=0 ts=1598934205.896191120,1 min=1598934205.890026216,0 seq=25} lock=true stat=PENDING rts=1598934205.890026216,0 wto=false max=1598934206.390026216,0
                logic.go:1660: 
                     pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE - failed preemptive refresh): "sql txn" meta={id=57a70e1e key=/Table/SystemConfigSpan/Start pri=0.01767040 epo=0 ts=1598934205.896191120,1 min=1598934205.890026216,0 seq=25} lock=true stat=PENDING rts=1598934205.890026216,0 wto=false max=1598934206.390026216,0
=== RUN   TestLogic/local/schema_change_in_txn
=== PAUSE TestLogic/local/schema_change_in_txn
=== CONT  TestLogic/local/schema_change_in_txn
--- done: testdata/logic_test/namespace with config local: 25 tests, 0 failures
        --- FAIL: TestLogic/local/schema_change_in_txn (40.62s)
=== RUN   TestLogic/local
    --- FAIL: TestLogic/local (0.73s)

More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestLogic PKG=./pkg/sql/logictest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

See this test on roachdash
powered by pkg/cmd/internal/issues

Jira issue: CRDB-3843

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-masterFailures and bugs on the master branch.

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions