Describe the situation
02435_rollback_cancelled_queries runs three threads for 20 seconds — one inserting, one selecting, one killing clients mid-query. When they stop, the test waits for the server to go quiet. Some INSERTs keep running for more than 15 seconds after that, so the test dumps system.processes and the output no longer matches the reference.
It needs two things at once. ASan alone never fails it. CAS alone almost never does. Together they fail it a quarter of the time:
Upstream CI runs the same test 122,907 times in 60 days and fails it once — 0.001%. Our rate on that lane is about 25,000 times higher.
This issue:
Actual behavior
The leftover rows in the diff come from system.processes, not from the query log. tests/queries/shell_config.sh:189 polls for 15 seconds, then dumps whatever is still running:
@@ -1,2 +1,48 @@
1000000
0
+Row 1:
+──────
+is_initial_query: 1
+query_id: 02435_insert_default_14483-25065-2
+is_cancelled: 0
+memory_usage: 61360603
...
is_cancelled: 0 on every leftover row. These INSERTs were never cancelled — they're simply still going.
All 23 failures, with job and report links: query. Most recent in a release run: 34481990917.
Root cause analysis
⚠️ This section is AI analysis (Claude, via Claude Code), from the CI database and the test source. The rates and the log excerpt are checkable from the links. The mechanism is not established.
Both ingredients slow writes down. CAS writes go to object storage, and ASan slows everything further. An INSERT that was mid-flight when its client died then needs more than 15 seconds to wind down, and the test's wait expires first.
What that guess doesn't explain is Failed 3 out of 3 reruns. Plain slowness should vary between attempts. Failing every rerun points at a run reaching a state and staying in it, which is a different shape.
Two questions would settle it:
- Are those
INSERTs making progress, or are they stuck? system.processes gives elapsed and written_rows over successive polls.
- Does raising the wait past 15 seconds turn the failures green? If it does, this is lane slowness and belongs in the test. If it doesn't, an
INSERT isn't finishing.
Additional context
- Job:
Stateless tests (amd_asan_ubsan, cas s3 storage, parallel, 2/2)
- Branch:
antalya-26.6
- First seen: 2026-08-04 · Latest: 2026-09-14
Describe the situation
02435_rollback_cancelled_queriesruns three threads for 20 seconds — one inserting, one selecting, one killing clients mid-query. When they stop, the test waits for the server to go quiet. SomeINSERTs keep running for more than 15 seconds after that, so the test dumpssystem.processesand the output no longer matches the reference.It needs two things at once. ASan alone never fails it. CAS alone almost never does. Together they fail it a quarter of the time:
Upstream CI runs the same test 122,907 times in 60 days and fails it once — 0.001%. Our rate on that lane is about 25,000 times higher.
This issue:
cas_gc_interval_sec60 #2299. Several failing jobs carry zeroCode: 241—7515aa5aehad 21 failures and none,cc9034ea1had 16 and none.Failed 3 out of 3 reruns.Actual behavior
The leftover rows in the diff come from
system.processes, not from the query log.tests/queries/shell_config.sh:189polls for 15 seconds, then dumps whatever is still running:is_cancelled: 0on every leftover row. TheseINSERTs were never cancelled — they're simply still going.All 23 failures, with job and report links: query. Most recent in a release run: 34481990917.
Root cause analysis
Both ingredients slow writes down. CAS writes go to object storage, and ASan slows everything further. An
INSERTthat was mid-flight when its client died then needs more than 15 seconds to wind down, and the test's wait expires first.What that guess doesn't explain is
Failed 3 out of 3 reruns. Plain slowness should vary between attempts. Failing every rerun points at a run reaching a state and staying in it, which is a different shape.Two questions would settle it:
INSERTs making progress, or are they stuck?system.processesgiveselapsedandwritten_rowsover successive polls.INSERTisn't finishing.Additional context
Stateless tests (amd_asan_ubsan, cas s3 storage, parallel, 2/2)antalya-26.6