-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql/logictest: schema_change_in_txn gets TransactionRetry error #53724
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.
Milestone
Description
(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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.