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..

S3 Test Run Report

DateJul 22, 2024 9:22
Duration2h 18m
Framework TestFlows 2.0.240705.1133204

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/24.3/b6642564dbf296d6e55b907d7af6c8087470b672/package_aarch64/clickhouse-common-static_24.3.5.47.altinitystable_arm64.deb
version24.3.5.47.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashc5e1513a2214ee33696c29717935e0a94989ac2a
job.id10037417827
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/10037417827
archaarch64
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/24.3/b6642564dbf296d6e55b907d7af6c8087470b672/package_aarch64/clickhouse-common-static_24.3.5.47.altinitystable_arm64.deb
keeper_binary_pathNone
zookeeper_versionNone
use_keeperFalse
stressFalse
collect_service_logsTrue
thread_fuzzerFalse
with_analyzerFalse
reuse_envFalse
storages['aws_s3']
minio_urihttp://minio1:9001
minio_root_userminio
minio_root_passwordminio123
aws_s3_bucketSecret(name='aws_s3_bucket')
aws_s3_regionSecret(name='aws_s3_region')
aws_s3_key_idSecret(name='aws_s3_key_id')
aws_s3_access_keySecret(name='aws_s3_access_key')
gcs_uriSecret(name='gcs_uri')
gcs_key_idSecret(name='gcs_key_id')
gcs_key_secretSecret(name='gcs_key_secret')

Summary

94.3%OK
4.6%Known

Statistics

Units Skip OK Fail Error XFail
Modules
2
2
Features
14
3
11
Scenarios
132
120
12
Checks
15
15
Examples
65
64
1
Steps
23477
1
23442
15
6
13

Known Fails

Test NameResultMessage
/s3/aws s3/disk/cacheXFail 2ms
Under development for 22.8 and newer.
None
/s3/aws s3/disk/cache defaultXFail 1ms
Under development for 22.8 and newer.
None
/s3/aws s3/disk/cache pathXFail 907us
Under development for 22.8 and newer.
None
/s3/aws s3/disk/generic urlXFail 2ms
not yet supported
Generic URL is treated as invalid configuration, ClickHouse
             will not start if config is added
/s3/aws s3/disk/low cardinality offsetXFail 48s 465ms
https://github.com/ClickHouse/ClickHouse/pull/44875
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 553, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 545, in regression
    Module(test=storage_module)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 409, in aws_s3_regression
    Feature(test=load("s3.tests.disk", "aws_s3"))(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/disk.py", line 2439, in aws_s3
    disk_tests(uri=uri, bucket_prefix=bucket_prefix)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/disk.py", line 2431, in disk_tests
    scenario()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/disk.py", line 2394, in low_cardinality_offset
    assert output == "23999\n", error()
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert output == "23999\n", error()

Assertion values
  assert output == "23999\n", error()
         ^ is '23999'
  assert output == "23999\n", error()
                ^ is = False

  assert output == "23999\n", error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/disk.py', line 2394 in 'low_cardinality_offset'

2386\|                      "1",
2387\|                  ),
2388\|                  (
2389\|                      "merge_tree_min_bytes_for_concurrent_read_for_remote_filesystem",
2390\|                      "1",
2391\|                  ),
2392\|              ],
2393\|          ).output
2394\|>         assert output == "23999\n", error()
2395\|  
2396\|  
2397\|  @TestFeature
/s3/aws s3/disk/no restartXFail 2ms
https://github.com/ClickHouse/ClickHouse/issues/58924
None
/s3/aws s3/invalid disk/cache path conflictXFail 1ms
Under development for 22.8 and newer.
None
/s3/aws s3/combinatoric table/engine=CollapsingMergeTree,replicated=True,n_cols=500,n_tables=3,part_type=compactXFail 1m 46s
Unstable test
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 553, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 545, in regression
    Module(test=storage_module)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 414, in aws_s3_regression
    Feature(test=load("s3.tests.combinatoric_table", "feature"))(uri=uri)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/combinatoric_table.py", line 179, in feature
    Scenario(title, test=check_table_combination)(**table_config)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/combinatoric_table.py", line 143, in check_table_combination
    retry(assert_row_count, timeout=60, delay=5)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/common.py", line 1531, in assert_row_count
    assert rows == actual_count, error()
           ^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert rows == actual_count, error()

Assertion values
  assert rows == actual_count, error()
         ^ is 10000
  assert rows == actual_count, error()
                 ^ is 0
  assert rows == actual_count, error()
              ^ is = False
  assert rows == actual_count, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/common.py', line 1531 in 'assert_row_count'

1523\|  
1524\|  @TestStep(Then)
1525\|  def assert_row_count(self, node, table_name: str, rows: int = 1000000):
1526\|      """Assert that the number of rows in a table is as expected."""
1527\|      if node is None:
1528\|          node = current().context.node
1529\|  
1530\|      actual_count = get_row_count(node=node, table_name=table_name)
1531\|>     assert rows == actual_count, error()
1532\|  
1533\|  
1534\|  @TestStep(Then)
/s3/aws s3/zero copy replication/add remove replica parallelXFail 1ms
This test causes boto errors in subsequent tests.
None
/s3/aws s3/zero copy replication/deleteXFail 10m 40s
test is slow to clean up, needs investigation
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 553, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 545, in regression
    Module(test=storage_module)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/regression.py", line 415, in aws_s3_regression
    Feature(test=load("s3.tests.zero_copy_replication", "aws_s3"))(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/zero_copy_replication.py", line 1703, in aws_s3
    outline(uri=uri, bucket_prefix=bucket_prefix)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/zero_copy_replication.py", line 1692, in outline
    scenario()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/zero_copy_replication.py", line 826, in delete
    check_bucket_size(expected_size=size_before, tolerance=5)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/common.py", line 814, in check_bucket_size
    assert abs(current_size - expected_size) <= tolerance, error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert abs(current_size - expected_size) <= tolerance, error()

Assertion values
  assert abs(current_size - expected_size) <= tolerance, error()
             ^ is 0
  assert abs(current_size - expected_size) <= tolerance, error()
                            ^ is 66313522
  assert abs(current_size - expected_size) <= tolerance, error()
                          ^ is = -66313522
  assert abs(current_size - expected_size) <= tolerance, error()
         ^ is = 66313522
  assert abs(current_size - expected_size) <= tolerance, error()
                                              ^ is 5
  assert abs(current_size - expected_size) <= tolerance, error()
                                           ^ is = False
  assert abs(current_size - expected_size) <= tolerance, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/s3/../s3/tests/common.py', line 814 in 'check_bucket_size'

806\|  ):
807\|      current_size = get_bucket_size(
808\|          name=name,
809\|          prefix=prefix,
810\|          minio_enabled=minio_enabled,
811\|          access_key=self.context.secret_access_key,
812\|          key_id=self.context.access_key_id,
813\|      )
814\|>     assert abs(current_size - expected_size) <= tolerance, error()
815\|  
816\|  
817\|  @TestStep(When)
/s3/aws s3/zero copy replication/stale alter replicaXFail 1ms
This test causes boto errors in subsequent tests.
None

Results

Test Name Result Duration
/s3 OK 2h 18m
/s3/aws s3 OK 2h 18m
/s3/aws s3/sanity OK 58s 69ms
/s3/aws s3/sanity/sanity OK 14s 241ms
/s3/aws s3/table function OK 2m 27s
/s3/aws s3/table function/auto OK 7s 104ms
/s3/aws s3/table function/compression OK 6s 969ms
/s3/aws s3/table function/credentials OK 788ms
/s3/aws s3/table function/data format OK 16s 541ms
/s3/aws s3/table function/measure file size OK 49s 1ms
/s3/aws s3/table function/multipart OK 8s 693ms
/s3/aws s3/table function/multiple columns OK 1s 72ms
/s3/aws s3/table function/partition OK 668ms
/s3/aws s3/table function/remote host filter OK 43s 65ms
/s3/aws s3/table function/syntax OK 1s 278ms
/s3/aws s3/table function/wildcard OK 12s 341ms
/s3/aws s3/table function/ssec encryption check Skip 1ms
/s3/aws s3/invalid table function OK 2s 201ms
/s3/aws s3/invalid table function/empty path OK 253ms
/s3/aws s3/invalid table function/empty structure OK 244ms
/s3/aws s3/invalid table function/invalid compression OK 268ms
/s3/aws s3/invalid table function/invalid credentials OK 423ms
/s3/aws s3/invalid table function/invalid format OK 514ms
/s3/aws s3/invalid table function/invalid path OK 238ms
/s3/aws s3/invalid table function/invalid structure OK 243ms
/s3/aws s3/disk OK 47m 14s
/s3/aws s3/disk/access OK 44s 731ms
/s3/aws s3/disk/access skip check OK 44s 64ms
/s3/aws s3/disk/add storage OK 1m 31s
/s3/aws s3/disk/alter move OK 52s 402ms
/s3/aws s3/disk/alter on cluster modify ttl OK 1m 38s
/s3/aws s3/disk/cache XFail 2ms
/s3/aws s3/disk/cache default XFail 1ms
/s3/aws s3/disk/cache path XFail 907us
/s3/aws s3/disk/compact parts OK 48s 590ms
/s3/aws s3/disk/config over restart OK 1m 14s
/s3/aws s3/disk/default move factor OK 1m 20s
/s3/aws s3/disk/delete OK 2m 26s
/s3/aws s3/disk/download appropriate disk OK 1m 18s
/s3/aws s3/disk/drop sync OK 1m 25s
/s3/aws s3/disk/environment credentials OK 1m 36s
/s3/aws s3/disk/exports OK 50s 48ms
/s3/aws s3/disk/generic url XFail 2ms
/s3/aws s3/disk/imports OK 48s 617ms
/s3/aws s3/disk/log OK 4m 58s
/s3/aws s3/disk/low cardinality offset XFail 48s 465ms
/s3/aws s3/disk/max single part upload size syntax OK 51s 260ms
/s3/aws s3/disk/mergetree OK 8m 23s
/s3/aws s3/disk/mergetree collapsing OK 1m 37s
/s3/aws s3/disk/mergetree versionedcollapsing OK 1m 37s
/s3/aws s3/disk/metadata OK 52s 737ms
/s3/aws s3/disk/min bytes for seek syntax OK 48s 245ms
/s3/aws s3/disk/multiple storage OK 1m 1s
/s3/aws s3/disk/multiple storage query OK 59s 350ms
/s3/aws s3/disk/no restart XFail 2ms
/s3/aws s3/disk/perform ttl move on insert OK 1m 37s
/s3/aws s3/disk/perform ttl move on insert default OK 56s 849ms
/s3/aws s3/disk/performance ttl move OK 1m 13s
/s3/aws s3/disk/remote host filter OK 1m 34s
/s3/aws s3/disk/specific url OK 48s 868ms
/s3/aws s3/disk/syntax OK 56s 572ms
/s3/aws s3/disk/wide parts OK 47s 973ms
/s3/aws s3/disk/ssec Skip 1ms
/s3/aws s3/invalid disk OK 3m 49s
/s3/aws s3/invalid disk/access default OK 11s 765ms
/s3/aws s3/invalid disk/access failed OK 11s 743ms
/s3/aws s3/invalid disk/access failed skip check OK 49s 339ms
/s3/aws s3/invalid disk/cache path conflict XFail 1ms
/s3/aws s3/invalid disk/empty endpoint OK 8s 763ms
/s3/aws s3/invalid disk/invalid endpoint OK 2m 10s
/s3/aws s3/invalid disk/invalid type OK 17s 380ms
/s3/aws s3/alter OK 3m 7s
/s3/aws s3/alter/attach from OK 9s 428ms
/s3/aws s3/alter/columns OK 13s 893ms
/s3/aws s3/alter/detach OK 16s 971ms
/s3/aws s3/alter/drop OK 34s 620ms
/s3/aws s3/alter/fetch OK 21s 713ms
/s3/aws s3/alter/freeze OK 4s 330ms
/s3/aws s3/alter/index OK 8s 87ms
/s3/aws s3/alter/move to table OK 11s 345ms
/s3/aws s3/alter/order by OK 1s 392ms
/s3/aws s3/alter/projection OK 2s 950ms
/s3/aws s3/alter/replace OK 6s 536ms
/s3/aws s3/alter/sample by OK 1s 818ms
/s3/aws s3/alter/update delete OK 5s 36ms
/s3/aws s3/combinatoric table OK 6m 2s
/s3/aws s3/combinatoric table/engine=MergeTree,replicated=False,n_cols=500,n_tables=1,part_type=wide OK 10s 738ms
/s3/aws s3/combinatoric table/engine=ReplacingMergeTree,replicated=True,n_cols=500,n_tables=3,part_type=unspecified OK 32s 487ms
/s3/aws s3/combinatoric table/engine=CollapsingMergeTree,replicated=True,n_cols=10,n_tables=1,part_type=wide OK 8s 419ms
/s3/aws s3/combinatoric table/engine=CollapsingMergeTree,replicated=False,n_cols=2000,n_tables=3,part_type=unspecified OK 19s 5ms
/s3/aws s3/combinatoric table/engine=VersionedCollapsingMergeTree,replicated=False,n_cols=10,n_tables=3,part_type=compact OK 4s 272ms
/s3/aws s3/combinatoric table/engine=AggregatingMergeTree,replicated=False,n_cols=500,n_tables=1,part_type=unspecified OK 4s 754ms
/s3/aws s3/combinatoric table/engine=SummingMergeTree,replicated=False,n_cols=500,n_tables=1,part_type=compact OK 10s 771ms
/s3/aws s3/combinatoric table/engine=MergeTree,replicated=True,n_cols=10,n_tables=3,part_type=unspecified OK 21s 993ms
/s3/aws s3/combinatoric table/engine=ReplacingMergeTree,replicated=True,n_cols=10,n_tables=3,part_type=wide OK 25s 488ms
/s3/aws s3/combinatoric table/engine=CollapsingMergeTree,replicated=True,n_cols=500,n_tables=3,part_type=compact XFail 1m 46s
/s3/aws s3/combinatoric table/engine=VersionedCollapsingMergeTree,replicated=True,n_cols=500,n_tables=1,part_type=unspecified OK 10s 714ms
/s3/aws s3/combinatoric table/engine=AggregatingMergeTree,replicated=True,n_cols=10,n_tables=3,part_type=wide OK 26s 461ms
/s3/aws s3/combinatoric table/engine=SummingMergeTree,replicated=True,n_cols=10,n_tables=3,part_type=wide OK 24s 937ms
/s3/aws s3/combinatoric table/engine=SummingMergeTree,replicated=True,n_cols=10,n_tables=1,part_type=unspecified OK 7s 206ms
/s3/aws s3/zero copy replication OK 39m 50s
/s3/aws s3/zero copy replication/add remove one replica OK 40s 334ms
/s3/aws s3/zero copy replication/add remove replica parallel XFail 1ms
/s3/aws s3/zero copy replication/add replica global setting OK 1m 34s
/s3/aws s3/zero copy replication/add replica local setting OK 43s 25ms
/s3/aws s3/zero copy replication/alter OK 4m 48s
/s3/aws s3/zero copy replication/bad detached part OK 1m 13s
/s3/aws s3/zero copy replication/check refcount after mutation OK 1m 15s
/s3/aws s3/zero copy replication/consistency during conflicting mutation OK 1m 16s
/s3/aws s3/zero copy replication/consistency during double mutation OK 1m 16s
/s3/aws s3/zero copy replication/default value OK 14s 202ms
/s3/aws s3/zero copy replication/delete XFail 10m 40s
/s3/aws s3/zero copy replication/delete all OK 29s 696ms
/s3/aws s3/zero copy replication/drop replica OK 47s 872ms
/s3/aws s3/zero copy replication/global setting OK 1m 17s
/s3/aws s3/zero copy replication/insert multiple replicas OK 2m 11s
/s3/aws s3/zero copy replication/metadata OK 1m 14s
/s3/aws s3/zero copy replication/migration OK 1m 14s
/s3/aws s3/zero copy replication/offline alter replica OK 46s 524ms
/s3/aws s3/zero copy replication/performance alter OK 43s 807ms
/s3/aws s3/zero copy replication/performance insert OK 1m 5s
/s3/aws s3/zero copy replication/performance select OK 1m 13s
/s3/aws s3/zero copy replication/stale alter replica XFail 1ms
/s3/aws s3/zero copy replication/ttl delete OK 2m 8s
/s3/aws s3/zero copy replication/ttl move OK 2m 5s
/s3/aws s3/reconnect OK 2m 39s
/s3/aws s3/reconnect/local and s3 disk OK 53s 809ms
/s3/aws s3/reconnect/local and s3 volumes OK 52s 133ms
/s3/aws s3/reconnect/s3 disk OK 53s 887ms
/s3/aws s3/backup Skip 1ms
/s3/aws s3/settings OK 25m 41s
/s3/aws s3/settings/setting combinations OK 24m 56s
/s3/aws s3/table function performance OK 4m 16s
/s3/aws s3/table function performance/setup OK 905ms
/s3/aws s3/table function performance/wildcard OK 4m 15s

Generated by TestFlows Open-Source Test Framework v2.0.240705.1133204