Copyright 2025, Altinity Inc.. All Rights Reserved. All information contained herein is, and remains the property of Altinity Inc.. Any dissemination of this information or reproduction of this material is strictly forbidden unless prior written permission is obtained from Altinity Inc..

Alter Test Run Report

DateJun 27, 2025 13:09
Duration1h 45m
Framework TestFlows 2.0.250110.1002922

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#0/d1f73c287081665b9e9ca2767a633a3cc8a41f08/regression/x86_64/with_analyzer/zookeeper/without_thread_fuzzer/alter/replace_partition/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/24.8/d1f73c287081665b9e9ca2767a633a3cc8a41f08/package_release/clickhouse-common-static_24.8.14.10501.altinitytest_amd64.deb
version24.8.14.10501.altinitytest
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashe3c00be97a045aa04e9d1a6ec50cc64f4c387b70
job.nameAlter
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/15925737638
archx86_64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/24.8/d1f73c287081665b9e9ca2767a633a3cc8a41f08/package_release/clickhouse-common-static_24.8.14.10501.altinitytest_amd64.deb
as_binaryFalse
base_osNone
keeper_pathNone
zookeeper_versionNone
use_keeperFalse
stressFalse
collect_service_logsTrue
thread_fuzzerFalse
with_analyzerTrue
reuse_envFalse
use_specific_versiondocker://altinity/clickhouse-server:23.3.13.7.altinitytest

Summary

99.6%OK
<1%Known

Statistics

Units Skip OK Fail XFail
Modules
1
1
Features
18
18
Scenarios
860
4
853
3
Checks
1013
1013
Steps
224054
1
221228
2825

Known Fails

Test NameResultMessage
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partitionXFail 1s 752ms
The pr is not done yet: https://github.com/ClickHouse/ClickHouse/pull/54272
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/regression.py", line 292, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/regression.py", line 286, in regression
    Feature(run=load("alter.table.replace_partition.feature", "feature"))
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/replace_partition/feature.py", line 59, in feature
    Feature(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/replace_partition/concurrent_merges_and_mutations.py", line 141, in feature
    scenario()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/replace_partition/concurrent_merges_and_mutations.py", line 123, in mutations_on_unrelated_partition
    assert old_data.output.strip() != new_data.output.strip(), error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert old_data.output.strip() != new_data.output.strip(), error()

Assertion values
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is 
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is = '1159952301953917524\n1358202696589707020\n2093327207313450695\n2295968737618946998\n8545910821825938022\n10701842532831984405\n15128671614868761733\n15797830073314900867\n15815920171091083523\n15831092528801332470'
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is '1159952301953917524\n1358202696589707020\n2093327207313450695\n2295968737618946998\n8545910821825938022\n10701842532831984405\n15128671614868761733\n15797830073314900867\n15815920171091083523\n15831092528801332470'
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is = 
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is = '1159952301953917524\n1358202696589707020\n2093327207313450695\n2295968737618946998\n8545910821825938022\n10701842532831984405\n15128671614868761733\n15797830073314900867\n15815920171091083523\n15831092528801332470'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is 
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = '1159952301953917524\n1358202696589707020\n2093327207313450695\n2295968737618946998\n8545910821825938022\n10701842532831984405\n15128671614868761733\n15797830073314900867\n15815920171091083523\n15831092528801332470'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is '1159952301953917524\n1358202696589707020\n2093327207313450695\n2295968737618946998\n8545910821825938022\n10701842532831984405\n15128671614868761733\n15797830073314900867\n15815920171091083523\n15831092528801332470'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = 
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = '1159952301953917524\n1358202696589707020\n2093327207313450695\n2295968737618946998\n8545910821825938022\n10701842532831984405\n15128671614868761733\n15797830073314900867\n15815920171091083523\n15831092528801332470'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                 ^ is = False
  assert old_data.output.strip() != new_data.output.strip(), error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/replace_partition/concurrent_merges_and_mutations.py', line 123 in 'mutations_on_unrelated_partition'

115\|      with And("that the mutation is still running as the replace partition stopped it"):
116\|          with By(
117\|              "confirming that the the i column, which mutation should've changed still has the old data"
118\|          ):
119\|              new_data = node.query(
120\|                  f"SELECT i FROM {destination_table} WHERE p == 1 ORDER BY tuple(*) FORMAT TabSeparated"
121\|              )
122\|  
123\|>             assert old_data.output.strip() != new_data.output.strip(), error()
124\|  
125\|  
126\|  @TestFeature

Results

Test Name Result Duration
/alter OK 1h 45m
/alter/replace partition OK 1h 42m
/alter/replace partition/partition types OK 29s 420ms
/alter/replace partition/partition types/replace partition with different partition types OK 29s 419ms
/alter/replace partition/rbac OK 14m 4s
/alter/replace partition/rbac/check replace partition with privileges OK 14m 4s
/alter/replace partition/concurrent replace partitions OK 4m 48s
/alter/replace partition/data integrity OK 7s 438ms
/alter/replace partition/data integrity/keep data on a source table OK 1s 895ms
/alter/replace partition/data integrity/non existent partition destination OK 2s 161ms
/alter/replace partition/data integrity/non existent partition source OK 1s 807ms
/alter/replace partition/data integrity/partition changes in system OK 1s 572ms
/alter/replace partition/prohibited actions OK 10s 592ms
/alter/replace partition/prohibited actions/from clause OK 4s 847ms
/alter/replace partition/prohibited actions/from clause/table functions OK 693ms
/alter/replace partition/prohibited actions/from clause/join OK 770ms
/alter/replace partition/prohibited actions/from clause/subquery OK 777ms
/alter/replace partition/prohibited actions/from clause/non mergetree table OK 844ms
/alter/replace partition/prohibited actions/from clause/view OK 166ms
/alter/replace partition/prohibited actions/from clause/materialized view OK 167ms
/alter/replace partition/prohibited actions/from clause/remote OK 659ms
/alter/replace partition/prohibited actions/from clause/remote secure OK 765ms
/alter/replace partition/prohibited actions/conditions OK 2s 953ms
/alter/replace partition/prohibited actions/conditions/storage policy OK 709ms
/alter/replace partition/prohibited actions/conditions/partition by OK 850ms
/alter/replace partition/prohibited actions/conditions/order by OK 698ms
/alter/replace partition/prohibited actions/conditions/structure OK 692ms
/alter/replace partition/prohibited actions/miscellaneous OK 2s 791ms
/alter/replace partition/prohibited actions/miscellaneous/order by partition by OK 711ms
/alter/replace partition/prohibited actions/miscellaneous/into outfile OK 626ms
/alter/replace partition/prohibited actions/miscellaneous/format OK 706ms
/alter/replace partition/prohibited actions/miscellaneous/settings OK 746ms
/alter/replace partition/temporary table OK 1s 464ms
/alter/replace partition/temporary table/from temporary to regular OK 684ms
/alter/replace partition/temporary table/from temporary to temporary table OK 419ms
/alter/replace partition/temporary table/from regular to temporary OK 359ms
/alter/replace partition/engines OK 53s 462ms
/alter/replace partition/engines/replace partition with different engines OK 53s 461ms
/alter/replace partition/concurrent actions OK 1h 40m
/alter/replace partition/concurrent actions/one replace partition OK 1h 21m
/alter/replace partition/concurrent replace partitions/concurrent replace OK 19s 38ms
/alter/replace partition/concurrent merges and mutations OK 7s 347ms
/alter/replace partition/concurrent merges and mutations/merges on unrelated partition OK 5s 592ms
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partition XFail 1s 752ms
/alter/replace partition/storage OK 27s 671ms
/alter/replace partition/storage/different disks OK 582ms
/alter/replace partition/storage/shards OK 710ms
/alter/replace partition/storage/replicas OK 2s 101ms
/alter/replace partition/storage/replace partition on minio and default disks OK 8s 189ms
/alter/replace partition/storage/replace partition on tiered and default storages OK 5s 975ms
/alter/replace partition/storage/partition moved to another disk OK 10s 111ms
/alter/replace partition/corrupted partitions OK 1m 42s
/alter/replace partition/corrupted partitions/replace partition with corrupted parts OK 1m 42s
/alter/replace partition/clickhouse versions OK 11ms
/alter/replace partition/clickhouse versions/replace partition on table created after update Skip 1ms
/alter/replace partition/clickhouse versions/replace partition on table created before update Skip 1ms
/alter/replace partition/clickhouse versions/replace partition on updated and reverted version Skip 1ms
/alter/replace partition/clickhouse versions/replace partition on updated version Skip 1ms
/alter/replace partition/concurrent replace partitions on replicas OK 18m 51s
/alter/replace partition/concurrent replace partitions on replicas/multiple shards with replicas OK 5m 43s
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas OK 6m 39s
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas secure OK 6m 28s
/alter/replace partition/partition keys OK 1m 55s
/alter/replace partition/partition keys/replace partition partition key OK 1m 55s
/alter/replace partition/concurrent actions/replace partition along other actions OK 18m 54s

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922