Skip to content

Stateless test 02555_davengers_rename_chain is flaky #76493

@pamarcos

Description

@pamarcos

https://s3.amazonaws.com/clickhouse-test-reports/json.html?PR=75656&sha=latest&name_0=PR&name_1=Stateless+tests+%28debug%2C+s3+storage%29&name_2=02555_davengers_rename_chain

2025-02-19 19:12:39 Reason: result differs with reference:
2025-02-19 19:12:39 --- /repo/tests/queries/0_stateless/02555_davengers_rename_chain.reference 2025-02-19 18:43:38.932201101 +0000
2025-02-19 19:12:39 +++ /repo/tests/queries/0_stateless/02555_davengers_rename_chain.stdout 2025-02-19 19:12:29.245011183 +0000
2025-02-19 19:12:39 @@ -1,38 +1,2 @@
2025-02-19 19:12:39 ALTER TABLE wrong_metadata RENAME COLUMN a TO a1, RENAME COLUMN b to b1 SETTINGS replication_alter_partitions_sync = 0;
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata ORDER BY a1 FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"a1":"1","b1":"2","c":"3"}
2025-02-19 19:12:39 -INSERT INTO wrong_metadata VALUES (4, 5, 6);
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata ORDER BY a1 FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"a1":"1","b1":"2","c":"3"}
2025-02-19 19:12:39 -{"a1":"4","b1":"5","c":"6"}
2025-02-19 19:12:39 -ALTER TABLE wrong_metadata RENAME COLUMN a1 TO b, RENAME COLUMN b1 to a SETTINGS replication_alter_partitions_sync = 0;
2025-02-19 19:12:39 -INSERT INTO wrong_metadata VALUES (7, 8, 9);
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata ORDER by a1 FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"a1":"1","b1":"2","c":"3"}
2025-02-19 19:12:39 -{"a1":"4","b1":"5","c":"6"}
2025-02-19 19:12:39 -{"a1":"7","b1":"8","c":"9"}
2025-02-19 19:12:39 -SYSTEM START MERGES wrong_metadata;
2025-02-19 19:12:39 -SYSTEM SYNC REPLICA wrong_metadata;
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata order by a FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"b":"1","a":"2","c":"3"}
2025-02-19 19:12:39 -{"b":"4","a":"5","c":"6"}
2025-02-19 19:12:39 -{"b":"7","a":"8","c":"9"}
2025-02-19 19:12:39 -ALTER TABLE wrong_metadata_compact RENAME COLUMN a TO a1, RENAME COLUMN b to b1 SETTINGS replication_alter_partitions_sync = 0;
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata_compact ORDER BY a1 FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"a1":"1","b1":"2","c":"3"}
2025-02-19 19:12:39 -INSERT INTO wrong_metadata_compact VALUES (4, 5, 6);
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata_compact ORDER BY a1 FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"a1":"1","b1":"2","c":"3"}
2025-02-19 19:12:39 -{"a1":"4","b1":"5","c":"6"}
2025-02-19 19:12:39 -ALTER TABLE wrong_metadata_compact RENAME COLUMN a1 TO b, RENAME COLUMN b1 to a SETTINGS replication_alter_partitions_sync = 0;
2025-02-19 19:12:39 -INSERT INTO wrong_metadata_compact VALUES (7, 8, 9);
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata_compact ORDER by a1 FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"a1":"1","b1":"2","c":"3"}
2025-02-19 19:12:39 -{"a1":"4","b1":"5","c":"6"}
2025-02-19 19:12:39 -{"a1":"7","b1":"8","c":"9"}
2025-02-19 19:12:39 -SYSTEM START MERGES wrong_metadata_compact;
2025-02-19 19:12:39 -SYSTEM SYNC REPLICA wrong_metadata_compact;
2025-02-19 19:12:39 -SELECT * FROM wrong_metadata_compact order by a FORMAT JSONEachRow;
2025-02-19 19:12:39 -{"b":"1","a":"2","c":"3"}
2025-02-19 19:12:39 -{"b":"4","a":"5","c":"6"}
2025-02-19 19:12:39 -{"b":"7","a":"8","c":"9"}
2025-02-19 19:12:39 +[wrong_metadata] Cannot wait for column to appear
2025-02-19 19:12:39
2025-02-19 19:12:39
2025-02-19 19:12:39
2025-02-19 19:12:39 Database: test_xbita1yu

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CItestingSpecial 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