Skip to content

Test 01090_zookeeper_mutations_and_insert_quorum_long failed #79675

@nickitat

Description

@nickitat

Describe the bug

Test
Reference

https://s3.amazonaws.com/clickhouse-test-reports/json.html?PR=79665&sha=5904fd9e783ba69ba8a1b0e4db4a661722768a81&name_0=PR&name_1=Stateless%20tests%20%28debug%2C%20distributed%20plan%2C%20s3%20storage%29

How to reproduce

No response

Error message and/or stacktrace

2025-04-28 19:12:53 Reason: result differs with reference:  
2025-04-28 19:12:53 --- /repo/tests/queries/0_stateless/01090_zookeeper_mutations_and_insert_quorum_long.reference	2025-04-28 18:46:42.600244165 +0200
2025-04-28 19:12:53 +++ /repo/tests/queries/0_stateless/01090_zookeeper_mutations_and_insert_quorum_long.stdout	2025-04-28 19:12:53.619902528 +0200
2025-04-28 19:12:53 @@ -1,3 +1,3 @@
2025-04-28 19:12:53 -9
2025-04-28 19:12:53 -9
2025-04-28 19:12:53 +11
2025-04-28 19:12:53 +10
2025-04-28 19:12:53  0

So, it looks like the mutation wasn't completed when the selects were already executing.
Though, the mutation query looks completed fine to me:

❯ rg -zaui a593f2d6-382a-4e2d-aad7-eada72171655 /Users/nickitat/Downloads/clickhouse-server.log-103.zst
4757099:2025.04.28 19:12:49.313562 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Debug> executeQuery: (from [::1]:50192) (comment: 01090_zookeeper_mutations_and_insert_quorum_long.sql) (query 7, line 15) ALTER TABLE mutations_and_quorum1 DELETE WHERE something = 'test1' SETTINGS mutations_sync=2; (stage: Complete)
4757108:2025.04.28 19:12:49.317371 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Trace> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Created mutation with ID 0000000000 (data versions: 201901 = 1; 201902 = 1; 201903 = 1; 201904 = 1; 201905 = 1; 201906 = 1; 201907 = 1; 201908 = 1; 201909 = 1; 201910 = 2; 201911 = 1; 201912 = 1; )
4757111:2025.04.28 19:12:49.317741 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Debug> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Waiting for 1 to apply mutation 0000000000
4758767:2025.04.28 19:12:50.318461 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Trace> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Failed to wait for mutation '0000000000', will recheck
4759959:2025.04.28 19:12:51.319506 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Trace> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Failed to wait for mutation '0000000000', will recheck
4761703:2025.04.28 19:12:52.320821 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Trace> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Failed to wait for mutation '0000000000', will recheck
4762434:2025.04.28 19:12:53.110026 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Trace> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Mutation 0000000000 is done because mutation pointer is 0000000000
4762435:2025.04.28 19:12:53.110282 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Debug> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Waiting for 2 to apply mutation 0000000000
4762437:2025.04.28 19:12:53.110950 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Trace> test_vesplfba.mutations_and_quorum1 (2248e916-2719-4624-b2a5-f69a5e459dc7): Mutation 0000000000 is done because mutation pointer is 0000000000
4762439:2025.04.28 19:12:53.111405 [ 146151 ] {a593f2d6-382a-4e2d-aad7-eada72171655} <Debug> TCPHandler: Processed in 3.798318602 sec.

Metadata

Metadata

Assignees

No one assigned

    Labels

    testingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions