Skip to content

Fix flaky test 01079_parallel_alter_detach_table_zookeeper#97681

Merged
alexey-milovidov merged 2 commits intomasterfrom
fix-flaky-01079-parallel-alter-detach-2
Feb 23, 2026
Merged

Fix flaky test 01079_parallel_alter_detach_table_zookeeper#97681
alexey-milovidov merged 2 commits intomasterfrom
fix-flaky-01079-parallel-alter-detach-2

Conversation

@alexey-milovidov
Copy link
Copy Markdown
Member

@alexey-milovidov alexey-milovidov commented Feb 23, 2026

Closes #97358

CI report: https://s3.amazonaws.com/clickhouse-test-reports/json.html?PR=97670&sha=8ca4b2d3d5c5c952378bcb73aec55e7d76f120e3&name_0=PR&name_1=Stateless%20tests%20%28amd_binary%2C%20old%20analyzer%2C%20s3%20storage%2C%20DatabaseReplicated%2C%20sequential%29

In DatabaseReplicated mode, DROP TABLE IF EXISTS cleanup commands can get a TIMEOUT_EXCEEDED error, which clickhouse-client outputs as a multi-line message. The existing grep -Fv "TIMEOUT_EXCEEDED" only filtered the middle line, letting Received exception from server and (query: ...) lines leak into stdout. Fix by joining lines with tr '\n' ' ' before grep so the whole error is on one line and gets filtered.

Changelog category (leave one):

  • CI Fix or Improvement (changelog entry is not required)

Changelog entry (a user-readable short description of the changes that goes into CHANGELOG.md):

...

Documentation entry for user-facing changes

  • Documentation is written (mandatory for new features)

In `DatabaseReplicated` mode, `DROP TABLE IF EXISTS` can produce a
`TIMEOUT_EXCEEDED` error, which `clickhouse-client` outputs as a
multi-line message to stderr:

    Received exception from server (version ...):
    Code: 159. DB::Exception: ... TIMEOUT_EXCEEDED
    (query: DROP TABLE IF EXISTS ...)

The test redirects stderr to stdout (`2>&1`) and filters with
`grep -Fv "TIMEOUT_EXCEEDED"`, but this only removes the middle line.
The surrounding lines (`Received exception...` and `(query: ...)`)
pass through to stdout and cause a diff with the reference file.

Fix by joining lines with `tr '\n' ' '` before `grep`, so the entire
error is on one line and gets filtered properly.

https://s3.amazonaws.com/clickhouse-test-reports/json.html?PR=97670&sha=8ca4b2d3d5c5c952378bcb73aec55e7d76f120e3&name_0=PR&name_1=Stateless%20tests%20%28amd_binary%2C%20old%20analyzer%2C%20s3%20storage%2C%20DatabaseReplicated%2C%20sequential%29

Co-Authored-By: Claude Opus 4.6 <[email protected]>
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Feb 23, 2026

Workflow [PR], commit [e4aa082]

Summary:

@clickhouse-gh clickhouse-gh bot added the pr-ci label Feb 23, 2026
@alexey-milovidov alexey-milovidov self-assigned this Feb 23, 2026
@alexey-milovidov alexey-milovidov added this pull request to the merge queue Feb 23, 2026
Merged via the queue into master with commit 02a4ce3 Feb 23, 2026
148 checks passed
@alexey-milovidov alexey-milovidov deleted the fix-flaky-01079-parallel-alter-detach-2 branch February 23, 2026 11:54
@robot-clickhouse robot-clickhouse added the pr-synced-to-cloud The PR is synced to the cloud repo label Feb 23, 2026
Algunenano pushed a commit to Algunenano/ClickHouse that referenced this pull request Feb 24, 2026
…arallel-alter-detach-2

Fix flaky test `01079_parallel_alter_detach_table_zookeeper`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-ci pr-synced-to-cloud The PR is synced to the cloud repo

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Flaky test: 01079_parallel_alter_detach_table_zookeeper

2 participants