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 17:05
Duration2h 32m
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_aarch64/clickhouse-common-static_23.8.11.29.altinitystable_arm64.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
archaarch64
stressFalse
allow_vfsFalse
allow_experimental_analyzerFalse
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/23.8/8e9be16153250c8307730c9b88c8517181f494ce/package_aarch64/clickhouse-common-static_23.8.11.29.altinitystable_arm64.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
221205
219625
1580

Known Fails

Test NameResultMessage
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partitionXFail 2s 808ms
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 = '168876801190089428\n3635743309040211892\n4574950380889982544\n7375937845745423811\n10144798118160638147\n13392499214311055113\n14923543119034695259\n16012780140964821697\n16439013794143894174\n17375432582673405355'
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is '168876801190089428\n3635743309040211892\n4574950380889982544\n7375937845745423811\n10144798118160638147\n13392499214311055113\n14923543119034695259\n16012780140964821697\n16439013794143894174\n17375432582673405355'
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is = 
  assert old_data.output.strip() != new_data.output.strip(), error()
         ^ is = '168876801190089428\n3635743309040211892\n4574950380889982544\n7375937845745423811\n10144798118160638147\n13392499214311055113\n14923543119034695259\n16012780140964821697\n16439013794143894174\n17375432582673405355'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is 
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = '168876801190089428\n3635743309040211892\n4574950380889982544\n7375937845745423811\n10144798118160638147\n13392499214311055113\n14923543119034695259\n16012780140964821697\n16439013794143894174\n17375432582673405355'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is '168876801190089428\n3635743309040211892\n4574950380889982544\n7375937845745423811\n10144798118160638147\n13392499214311055113\n14923543119034695259\n16012780140964821697\n16439013794143894174\n17375432582673405355'
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = 
  assert old_data.output.strip() != new_data.output.strip(), error()
                                    ^ is = '168876801190089428\n3635743309040211892\n4574950380889982544\n7375937845745423811\n10144798118160638147\n13392499214311055113\n14923543119034695259\n16012780140964821697\n16439013794143894174\n17375432582673405355'
  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 2h 32m
/alter/replace partition OK 2h 28m
/alter/replace partition/partition types OK 49s 274ms
/alter/replace partition/partition types/replace partition with different partition types OK 49s 272ms
/alter/replace partition/rbac OK 39m 44s
/alter/replace partition/rbac/check replace partition with privileges OK 39m 44s
/alter/replace partition/concurrent replace partitions OK 11m 47s
/alter/replace partition/data integrity OK 11s 255ms
/alter/replace partition/data integrity/keep data on a source table OK 3s 81ms
/alter/replace partition/data integrity/non existent partition destination OK 3s 142ms
/alter/replace partition/data integrity/non existent partition source OK 2s 854ms
/alter/replace partition/data integrity/partition changes in system OK 2s 174ms
/alter/replace partition/prohibited actions OK 18s 786ms
/alter/replace partition/prohibited actions/from clause OK 8s 535ms
/alter/replace partition/prohibited actions/from clause/table functions OK 1s 236ms
/alter/replace partition/prohibited actions/from clause/join OK 1s 316ms
/alter/replace partition/prohibited actions/from clause/subquery OK 1s 304ms
/alter/replace partition/prohibited actions/from clause/non mergetree table OK 1s 464ms
/alter/replace partition/prohibited actions/from clause/view OK 324ms
/alter/replace partition/prohibited actions/from clause/materialized view OK 329ms
/alter/replace partition/prohibited actions/from clause/remote OK 1s 287ms
/alter/replace partition/prohibited actions/from clause/remote secure OK 1s 268ms
/alter/replace partition/prohibited actions/conditions OK 5s 157ms
/alter/replace partition/prohibited actions/conditions/storage policy OK 1s 263ms
/alter/replace partition/prohibited actions/conditions/partition by OK 1s 284ms
/alter/replace partition/prohibited actions/conditions/order by OK 1s 309ms
/alter/replace partition/prohibited actions/conditions/structure OK 1s 298ms
/alter/replace partition/prohibited actions/miscellaneous OK 5s 92ms
/alter/replace partition/prohibited actions/miscellaneous/order by partition by OK 1s 336ms
/alter/replace partition/prohibited actions/miscellaneous/into outfile OK 1s 246ms
/alter/replace partition/prohibited actions/miscellaneous/format OK 1s 233ms
/alter/replace partition/prohibited actions/miscellaneous/settings OK 1s 274ms
/alter/replace partition/temporary table OK 1s 560ms
/alter/replace partition/temporary table/from temporary to regular OK 914ms
/alter/replace partition/temporary table/from temporary to temporary table OK 316ms
/alter/replace partition/temporary table/from regular to temporary OK 326ms
/alter/replace partition/engines OK 1m 24s
/alter/replace partition/engines/replace partition with different engines OK 1m 24s
/alter/replace partition/concurrent actions OK 2h 25m
/alter/replace partition/concurrent actions/one replace partition OK 2h 10m
/alter/replace partition/concurrent replace partitions/concurrent replace OK 52s 789ms
/alter/replace partition/concurrent merges and mutations OK 9s 254ms
/alter/replace partition/concurrent merges and mutations/merges on unrelated partition OK 6s 443ms
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partition XFail 2s 808ms
/alter/replace partition/storage OK 2m 31s
/alter/replace partition/storage/different disks OK 1s 269ms
/alter/replace partition/storage/shards OK 1s 472ms
/alter/replace partition/storage/replicas OK 2s 733ms
/alter/replace partition/storage/replace partition on minio and default disks OK 9s 668ms
/alter/replace partition/storage/replace partition on tiered and default storages OK 57s 540ms
/alter/replace partition/storage/partition moved to another disk OK 1m 19s
/alter/replace partition/corrupted partitions OK 3m 45s
/alter/replace partition/corrupted partitions/replace partition with corrupted parts OK 3m 45s
/alter/replace partition/clickhouse versions OK 54s 43ms
/alter/replace partition/clickhouse versions/replace partition on table created after update OK 10s 662ms
/alter/replace partition/clickhouse versions/replace partition on table created before update OK 9s 587ms
/alter/replace partition/clickhouse versions/replace partition on updated and reverted version OK 15s 359ms
/alter/replace partition/clickhouse versions/replace partition on updated version OK 18s 28ms
/alter/replace partition/concurrent replace partitions on replicas OK 51m 26s
/alter/replace partition/concurrent replace partitions on replicas/multiple shards with replicas OK 16m 27s
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas OK 18m 10s
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas secure OK 16m 47s
/alter/replace partition/partition keys OK 5m 46s
/alter/replace partition/partition keys/replace partition partition key OK 5m 46s
/alter/replace partition/concurrent actions/replace partition along other actions OK 15m 33s

Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232