Test 00180_no_seek_avoiding_when_reading_from_cache is flaky #66683
Description
Test 00180_no_seek_avoiding_when_reading_from_cache is flaky - seems due to interference with (see update below):00170_s3_cache.sql - both perform SYSTEM DROP FILESYSTEM CACHE on which 00180 relies
https://s3.amazonaws.com/clickhouse-test-reports/65238/b69978b5df385a545bf60efd353fd1f9044d2d58/stateful_tests__msan_.html
2024-07-16 02:54:23 Reason: result differs with reference:
2024-07-16 02:54:23 --- /usr/share/clickhouse-test/queries/1_stateful/00180_no_seek_avoiding_when_reading_from_cache.reference 2024-07-16 02:32:33.753996489 -0700
2024-07-16 02:54:23 +++ /tmp/clickhouse-test/1_stateful/00180_no_seek_avoiding_when_reading_from_cache.stdout 2024-07-16 02:54:23.962792790 -0700
2024-07-16 02:54:23 @@ -1 +1 @@
2024-07-16 02:54:23 -0 0
2024-07-16 02:54:23 +0 12046620
2024-07-16 02:54:23
2024-07-16 02:54:23
2024-07-16 02:54:23
2024-07-16 02:54:23 Database: test_4wytrcfr
from server log:
2024.07.16 02:54:14.983122 [ 2712 ] {36da1933-ff0f-4e56-a762-c3784ed4ae87} <Debug> executeQuery: (from [::1]:43522) (comment: 00180_no_seek_avoiding_when_reading_from_cache.sh) SYSTEM DROP FILESYSTEM CACHE (stage: Complete)
.....
2024.07.16 02:54:24.257522 [ 2248 ] {bacefd72-9a68-44aa-bdce-63eb75519f1f} <Debug> executeQuery: (from [::1]:41010) (comment: 00170_s3_cache.sql) SYSTEM DROP FILESYSTEM CACHE; (stage: Complete)
UPDATE:
After some investigation it seems that both tests are already have no-parallel tag, and from logs appears they do not interfere - so 00180_no_seek_avoiding_when_reading_from_cache is flaky on its own and further investigation is required.