Copyright 2024, 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

DateApr 28, 2024 16:47
Duration1h 20m
Framework TestFlows 2.0.231215.1221232

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#0/false/regression/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.8/8e9be16153250c8307730c9b88c8517181f494ce/package_release/clickhouse-common-static_23.8.11.29.altinitystable_amd64.deb
version23.8.11.29.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash17a81c07fc1f41fbee651e0ef0ca4b44e537e5b1
job.id8868426423
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/8868426423
archx86_64
stressFalse
allow_vfsFalse
allow_experimental_analyzerFalse
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/23.8/8e9be16153250c8307730c9b88c8517181f494ce/package_release/clickhouse-common-static_23.8.11.29.altinitystable_amd64.deb
collect_service_logsTrue
use_specific_versionaltinity/clickhouse-server:23.3.13.7.altinitytest

Summary

99.7%OK
<1%Known

Statistics

Units OK Fail XFail
Modules
1
1
Features
18
18
Scenarios
860
857
3
Checks
1013
1013
Steps
226599
223051
3548

Known Fails

Test NameResultMessage
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partitionXFail 5s 264ms
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 161, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/regression.py", line 155, 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 = '48474214642754778\n576466544389406241\n2438672045044433870\n6190159439794124549\n6500220598446156363\n6596158141841851351\n7148986115742380570\n8347598595772214785\n13598859883987925692\n16627390048966502223'
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is '48474214642754778\n576466544389406241\n2438672045044433870\n6190159439794124549\n6500220598446156363\n6596158141841851351\n7148986115742380570\n8347598595772214785\n13598859883987925692\n16627390048966502223'
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is = 
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is = '48474214642754778\n576466544389406241\n2438672045044433870\n6190159439794124549\n6500220598446156363\n6596158141841851351\n7148986115742380570\n8347598595772214785\n13598859883987925692\n16627390048966502223'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is 
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = '48474214642754778\n576466544389406241\n2438672045044433870\n6190159439794124549\n6500220598446156363\n6596158141841851351\n7148986115742380570\n8347598595772214785\n13598859883987925692\n16627390048966502223'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is '48474214642754778\n576466544389406241\n2438672045044433870\n6190159439794124549\n6500220598446156363\n6596158141841851351\n7148986115742380570\n8347598595772214785\n13598859883987925692\n16627390048966502223'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = 
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = '48474214642754778\n576466544389406241\n2438672045044433870\n6190159439794124549\n6500220598446156363\n6596158141841851351\n7148986115742380570\n8347598595772214785\n13598859883987925692\n16627390048966502223'
  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(*)"
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 20m
/alter/replace partition OK 1h 17m
/alter/replace partition/partition types OK 34s 690ms
/alter/replace partition/partition types/replace partition with different partition types OK 34s 689ms
/alter/replace partition/rbac OK 17m 35s
/alter/replace partition/rbac/check replace partition with privileges OK 17m 35s
/alter/replace partition/concurrent replace partitions OK 6m 36s
/alter/replace partition/data integrity OK 8s 947ms
/alter/replace partition/data integrity/keep data on a source table OK 2s 410ms
/alter/replace partition/data integrity/non existent partition destination OK 2s 311ms
/alter/replace partition/data integrity/non existent partition source OK 2s 327ms
/alter/replace partition/data integrity/partition changes in system OK 1s 896ms
/alter/replace partition/prohibited actions OK 13s 964ms
/alter/replace partition/prohibited actions/from clause OK 6s 150ms
/alter/replace partition/prohibited actions/from clause/table functions OK 936ms
/alter/replace partition/prohibited actions/from clause/join OK 994ms
/alter/replace partition/prohibited actions/from clause/subquery OK 965ms
/alter/replace partition/prohibited actions/from clause/non mergetree table OK 1s 107ms
/alter/replace partition/prohibited actions/from clause/view OK 172ms
/alter/replace partition/prohibited actions/from clause/materialized view OK 191ms
/alter/replace partition/prohibited actions/from clause/remote OK 874ms
/alter/replace partition/prohibited actions/from clause/remote secure OK 905ms
/alter/replace partition/prohibited actions/conditions OK 3s 933ms
/alter/replace partition/prohibited actions/conditions/storage policy OK 986ms
/alter/replace partition/prohibited actions/conditions/partition by OK 1s 47ms
/alter/replace partition/prohibited actions/conditions/order by OK 994ms
/alter/replace partition/prohibited actions/conditions/structure OK 903ms
/alter/replace partition/prohibited actions/miscellaneous OK 3s 877ms
/alter/replace partition/prohibited actions/miscellaneous/order by partition by OK 1s 76ms
/alter/replace partition/prohibited actions/miscellaneous/into outfile OK 1s 17ms
/alter/replace partition/prohibited actions/miscellaneous/format OK 846ms
/alter/replace partition/prohibited actions/miscellaneous/settings OK 935ms
/alter/replace partition/temporary table OK 1s 397ms
/alter/replace partition/temporary table/from temporary to regular OK 749ms
/alter/replace partition/temporary table/from temporary to temporary table OK 323ms
/alter/replace partition/temporary table/from regular to temporary OK 322ms
/alter/replace partition/engines OK 1m 3s
/alter/replace partition/engines/replace partition with different engines OK 1m 3s
/alter/replace partition/concurrent actions OK 1h 15m
/alter/replace partition/concurrent actions/one replace partition OK 1h 4m
/alter/replace partition/concurrent replace partitions/concurrent replace OK 34s 305ms
/alter/replace partition/concurrent merges and mutations OK 11s 580ms
/alter/replace partition/concurrent merges and mutations/merges on unrelated partition OK 6s 313ms
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partition XFail 5s 264ms
/alter/replace partition/storage OK 42s 507ms
/alter/replace partition/storage/different disks OK 3s 389ms
/alter/replace partition/storage/shards OK 3s 705ms
/alter/replace partition/storage/replicas OK 5s 585ms
/alter/replace partition/storage/replace partition on minio and default disks OK 13s 129ms
/alter/replace partition/storage/replace partition on tiered and default storages OK 7s 731ms
/alter/replace partition/storage/partition moved to another disk OK 8s 963ms
/alter/replace partition/corrupted partitions OK 2m 40s
/alter/replace partition/corrupted partitions/replace partition with corrupted parts OK 2m 40s
/alter/replace partition/clickhouse versions OK 51s 739ms
/alter/replace partition/clickhouse versions/replace partition on table created after update OK 14s 328ms
/alter/replace partition/clickhouse versions/replace partition on table created before update OK 7s 903ms
/alter/replace partition/clickhouse versions/replace partition on updated and reverted version OK 14s 184ms
/alter/replace partition/clickhouse versions/replace partition on updated version OK 14s 440ms
/alter/replace partition/concurrent replace partitions on replicas OK 22m 4s
/alter/replace partition/concurrent replace partitions on replicas/multiple shards with replicas OK 7m 0s
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas OK 7m 19s
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas secure OK 7m 44s
/alter/replace partition/partition keys OK 2m 44s
/alter/replace partition/partition keys/replace partition partition key OK 2m 44s
/alter/replace partition/concurrent actions/replace partition along other actions OK 10m 49s

Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232