Skip to content

Fix test_refreshable_mat_view_replicated test_append flakiness#81973

Merged
alexey-milovidov merged 3 commits intomasterfrom
unskip
Jun 22, 2025
Merged

Fix test_refreshable_mat_view_replicated test_append flakiness#81973
alexey-milovidov merged 3 commits intomasterfrom
unskip

Conversation

@al13n321
Copy link
Copy Markdown
Member

@al13n321 al13n321 commented Jun 16, 2025

Changelog category (leave one):

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

Closes #81890

The test did REFRESH EVERY 1 HOUR and @pytest.mark.skipif(datetime.now().minute > 57) to make sure the hourly refresh doesn't happen during the test. This turned out to be unreliable because skipif is evaluated before running a group of tests, which may take longer than 3 minutes before this test starts. This PR does EVERY 1 HOUR OFFSET {opposite_minutes} MINUTE instead, so the first refresh is always scheduled 30 minutes after RMV is created.

@al13n321 al13n321 requested a review from fm4v June 16, 2025 22:06
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Jun 16, 2025

Workflow [PR], commit [7dfbf9e]

Summary:
15 failures out of 17 shown:

job_name test_name status info comment
Build (amd_darwin) error
Build (arm_darwin) error
Build (arm_v80compat) error
Build (amd_freebsd) error
Build (ppc64le) error
Build (amd_compat) error
Build (amd_musl) error
Build (riscv64) error
Build (s390x) error
Build (loongarch64) error
Build (fuzzers) error
Stateless tests (amd_msan, 2/4) failure
02483_elapsed_time FAIL
Integration tests (tsan, 2/6) failure
test_postgresql_replica_database_engine/test_1.py::test_abrupt_connection_loss_while_heavy_replication FAIL
Stress test (arm_asan) error
Upgrade check (arm_asan) error

@clickhouse-gh clickhouse-gh bot added the pr-ci label Jun 16, 2025
@al13n321 al13n321 enabled auto-merge June 17, 2025 19:11
@alexey-milovidov alexey-milovidov merged commit 461ed21 into master Jun 22, 2025
115 of 123 checks passed
@alexey-milovidov alexey-milovidov deleted the unskip branch June 22, 2025 02:08
@robot-ch-test-poll2 robot-ch-test-poll2 added the pr-synced-to-cloud The PR is synced to the cloud repo label Jun 22, 2025
@Algunenano Algunenano self-assigned this Jun 23, 2025
robot-ch-test-poll1 added a commit that referenced this pull request Jun 23, 2025
Cherry pick #81973 to 25.6: Fix test_refreshable_mat_view_replicated test_append flakiness
robot-clickhouse added a commit that referenced this pull request Jun 23, 2025
@robot-clickhouse robot-clickhouse added the pr-backports-created-cloud deprecated label, NOOP label Jun 23, 2025
@robot-ch-test-poll3 robot-ch-test-poll3 added the pr-backports-created Backport PRs are successfully created, it won't be processed by CI script anymore label Jun 23, 2025
Algunenano added a commit that referenced this pull request Jun 23, 2025
Backport #81973 to 25.6: Fix test_refreshable_mat_view_replicated test_append flakiness
@robot-clickhouse robot-clickhouse added the pr-must-backport-synced The `*-must-backport` labels are synced into the cloud Sync PR label Jul 2, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-backports-created Backport PRs are successfully created, it won't be processed by CI script anymore pr-backports-created-cloud deprecated label, NOOP pr-ci pr-must-backport-synced The `*-must-backport` labels are synced into the cloud Sync PR pr-synced-to-cloud The PR is synced to the cloud repo v25.6-must-backport

Projects

None yet

Development

Successfully merging this pull request may close these issues.

test_refreshable_mat_view_replicated/test.py::test_append is flaky

8 participants