-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: TestSavepoints failed #72911
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-kvKV TeamKV TeamT-sql-queriesSQL Queries TeamSQL Queries TeamX-stale
Description
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>&1Parameters in this failure:
- GOFLAGS=-json
Same failure on other branches
- sql: TestSavepoints failed #70220 sql: TestSavepoints failed [C-test-failure O-robot T-kv T-sql-queries branch-master]
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-kvKV TeamKV TeamT-sql-queriesSQL Queries TeamSQL Queries TeamX-stale