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:28
Duration2h 0m
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_release/clickhouse-common-static_24.3.5.47.altinitystable_amd64.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
archx86_64
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/24.3/b6642564dbf296d6e55b907d7af6c8087470b672/package_release/clickhouse-common-static_24.3.5.47.altinitystable_amd64.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 XFail
Modules
2
2
Features
14
3
11
Scenarios
132
120
12
Checks
15
15
Examples
65
64
1
Steps
23360
1
23335
11
13

Known Fails

Test NameResultMessage
/s3/aws s3/disk/cacheXFail 3ms
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 2ms
Under development for 22.8 and newer.
None
/s3/aws s3/disk/generic urlXFail 5ms
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 42s 585ms
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 2ms
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 39s
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 38s
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 66297399
  assert abs(current_size - expected_size) <= tolerance, error()
                          ^ is = -66297399
  assert abs(current_size - expected_size) <= tolerance, error()
         ^ is = 66297399
  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 0m
/s3/aws s3 OK 2h 0m
/s3/aws s3/sanity OK 48s 715ms
/s3/aws s3/sanity/sanity OK 8s 743ms
/s3/aws s3/table function OK 2m 16s
/s3/aws s3/table function/auto OK 8s 766ms
/s3/aws s3/table function/compression OK 8s 540ms
/s3/aws s3/table function/credentials OK 901ms
/s3/aws s3/table function/data format OK 8s 914ms
/s3/aws s3/table function/measure file size OK 46s 273ms
/s3/aws s3/table function/multipart OK 4s 683ms
/s3/aws s3/table function/multiple columns OK 1s 342ms
/s3/aws s3/table function/partition OK 723ms
/s3/aws s3/table function/remote host filter OK 40s 39ms
/s3/aws s3/table function/syntax OK 1s 523ms
/s3/aws s3/table function/wildcard OK 15s 126ms
/s3/aws s3/table function/ssec encryption check Skip 2ms
/s3/aws s3/invalid table function OK 2s 699ms
/s3/aws s3/invalid table function/empty path OK 323ms
/s3/aws s3/invalid table function/empty structure OK 329ms
/s3/aws s3/invalid table function/invalid compression OK 314ms
/s3/aws s3/invalid table function/invalid credentials OK 483ms
/s3/aws s3/invalid table function/invalid format OK 654ms
/s3/aws s3/invalid table function/invalid path OK 282ms
/s3/aws s3/invalid table function/invalid structure OK 298ms
/s3/aws s3/disk OK 41m 32s
/s3/aws s3/disk/access OK 39s 752ms
/s3/aws s3/disk/access skip check OK 38s 776ms
/s3/aws s3/disk/add storage OK 1m 19s
/s3/aws s3/disk/alter move OK 44s 624ms
/s3/aws s3/disk/alter on cluster modify ttl OK 1m 23s
/s3/aws s3/disk/cache XFail 3ms
/s3/aws s3/disk/cache default XFail 1ms
/s3/aws s3/disk/cache path XFail 2ms
/s3/aws s3/disk/compact parts OK 40s 551ms
/s3/aws s3/disk/config over restart OK 1m 6s
/s3/aws s3/disk/default move factor OK 52s 937ms
/s3/aws s3/disk/delete OK 2m 13s
/s3/aws s3/disk/download appropriate disk OK 1m 10s
/s3/aws s3/disk/drop sync OK 1m 15s
/s3/aws s3/disk/environment credentials OK 1m 18s
/s3/aws s3/disk/exports OK 42s 962ms
/s3/aws s3/disk/generic url XFail 5ms
/s3/aws s3/disk/imports OK 43s 273ms
/s3/aws s3/disk/log OK 4m 29s
/s3/aws s3/disk/low cardinality offset XFail 42s 585ms
/s3/aws s3/disk/max single part upload size syntax OK 44s 905ms
/s3/aws s3/disk/mergetree OK 7m 55s
/s3/aws s3/disk/mergetree collapsing OK 1m 29s
/s3/aws s3/disk/mergetree versionedcollapsing OK 1m 29s
/s3/aws s3/disk/metadata OK 45s 909ms
/s3/aws s3/disk/min bytes for seek syntax OK 41s 224ms
/s3/aws s3/disk/multiple storage OK 50s 685ms
/s3/aws s3/disk/multiple storage query OK 48s 381ms
/s3/aws s3/disk/no restart XFail 2ms
/s3/aws s3/disk/perform ttl move on insert OK 1m 23s
/s3/aws s3/disk/perform ttl move on insert default OK 45s 879ms
/s3/aws s3/disk/performance ttl move OK 1m 5s
/s3/aws s3/disk/remote host filter OK 1m 22s
/s3/aws s3/disk/specific url OK 39s 545ms
/s3/aws s3/disk/syntax OK 44s 918ms
/s3/aws s3/disk/wide parts OK 41s 322ms
/s3/aws s3/disk/ssec Skip 2ms
/s3/aws s3/invalid disk OK 3m 48s
/s3/aws s3/invalid disk/access default OK 11s 779ms
/s3/aws s3/invalid disk/access failed OK 12s 973ms
/s3/aws s3/invalid disk/access failed skip check OK 43s 741ms
/s3/aws s3/invalid disk/cache path conflict XFail 2ms
/s3/aws s3/invalid disk/empty endpoint OK 8s 917ms
/s3/aws s3/invalid disk/invalid endpoint OK 2m 11s
/s3/aws s3/invalid disk/invalid type OK 19s 876ms
/s3/aws s3/alter OK 2m 59s
/s3/aws s3/alter/attach from OK 9s 732ms
/s3/aws s3/alter/columns OK 7s 682ms
/s3/aws s3/alter/detach OK 17s 787ms
/s3/aws s3/alter/drop OK 35s 648ms
/s3/aws s3/alter/fetch OK 22s 613ms
/s3/aws s3/alter/freeze OK 4s 349ms
/s3/aws s3/alter/index OK 8s 862ms
/s3/aws s3/alter/move to table OK 13s 546ms
/s3/aws s3/alter/order by OK 1s 851ms
/s3/aws s3/alter/projection OK 3s 151ms
/s3/aws s3/alter/replace OK 6s 603ms
/s3/aws s3/alter/sample by OK 1s 910ms
/s3/aws s3/alter/update delete OK 5s 521ms
/s3/aws s3/combinatoric table OK 5m 26s
/s3/aws s3/combinatoric table/engine=MergeTree,replicated=False,n_cols=500,n_tables=1,part_type=wide OK 8s 458ms
/s3/aws s3/combinatoric table/engine=ReplacingMergeTree,replicated=True,n_cols=500,n_tables=3,part_type=unspecified OK 24s 592ms
/s3/aws s3/combinatoric table/engine=CollapsingMergeTree,replicated=True,n_cols=10,n_tables=1,part_type=wide OK 8s 757ms
/s3/aws s3/combinatoric table/engine=CollapsingMergeTree,replicated=False,n_cols=2000,n_tables=3,part_type=unspecified OK 10s 27ms
/s3/aws s3/combinatoric table/engine=VersionedCollapsingMergeTree,replicated=False,n_cols=10,n_tables=3,part_type=compact OK 4s 284ms
/s3/aws s3/combinatoric table/engine=AggregatingMergeTree,replicated=False,n_cols=500,n_tables=1,part_type=unspecified OK 2s 202ms
/s3/aws s3/combinatoric table/engine=SummingMergeTree,replicated=False,n_cols=500,n_tables=1,part_type=compact OK 8s 367ms
/s3/aws s3/combinatoric table/engine=MergeTree,replicated=True,n_cols=10,n_tables=3,part_type=unspecified OK 22s 808ms
/s3/aws s3/combinatoric table/engine=ReplacingMergeTree,replicated=True,n_cols=10,n_tables=3,part_type=wide OK 28s 141ms
/s3/aws s3/combinatoric table/engine=CollapsingMergeTree,replicated=True,n_cols=500,n_tables=3,part_type=compact XFail 1m 39s
/s3/aws s3/combinatoric table/engine=VersionedCollapsingMergeTree,replicated=True,n_cols=500,n_tables=1,part_type=unspecified OK 8s 828ms
/s3/aws s3/combinatoric table/engine=AggregatingMergeTree,replicated=True,n_cols=10,n_tables=3,part_type=wide OK 26s 128ms
/s3/aws s3/combinatoric table/engine=SummingMergeTree,replicated=True,n_cols=10,n_tables=3,part_type=wide OK 26s 487ms
/s3/aws s3/combinatoric table/engine=SummingMergeTree,replicated=True,n_cols=10,n_tables=1,part_type=unspecified OK 7s 723ms
/s3/aws s3/zero copy replication OK 38m 39s
/s3/aws s3/zero copy replication/add remove one replica OK 40s 900ms
/s3/aws s3/zero copy replication/add remove replica parallel XFail 1ms
/s3/aws s3/zero copy replication/add replica global setting OK 1m 27s
/s3/aws s3/zero copy replication/add replica local setting OK 40s 215ms
/s3/aws s3/zero copy replication/alter OK 4m 48s
/s3/aws s3/zero copy replication/bad detached part OK 1m 14s
/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 17s
/s3/aws s3/zero copy replication/default value OK 12s 84ms
/s3/aws s3/zero copy replication/delete XFail 10m 38s
/s3/aws s3/zero copy replication/delete all OK 26s 662ms
/s3/aws s3/zero copy replication/drop replica OK 42s 4ms
/s3/aws s3/zero copy replication/global setting OK 1m 13s
/s3/aws s3/zero copy replication/insert multiple replicas OK 2m 8s
/s3/aws s3/zero copy replication/metadata OK 1m 11s
/s3/aws s3/zero copy replication/migration OK 1m 15s
/s3/aws s3/zero copy replication/offline alter replica OK 40s 386ms
/s3/aws s3/zero copy replication/performance alter OK 38s 751ms
/s3/aws s3/zero copy replication/performance insert OK 57s 263ms
/s3/aws s3/zero copy replication/performance select OK 1m 4s
/s3/aws s3/zero copy replication/stale alter replica XFail 1ms
/s3/aws s3/zero copy replication/ttl delete OK 2m 0s
/s3/aws s3/zero copy replication/ttl move OK 2m 1s
/s3/aws s3/reconnect OK 2m 29s
/s3/aws s3/reconnect/local and s3 disk OK 50s 458ms
/s3/aws s3/reconnect/local and s3 volumes OK 49s 208ms
/s3/aws s3/reconnect/s3 disk OK 49s 780ms
/s3/aws s3/backup Skip 3ms
/s3/aws s3/settings OK 15m 37s
/s3/aws s3/settings/setting combinations OK 14m 57s
/s3/aws s3/table function performance OK 4m 0s
/s3/aws s3/table function performance/setup OK 646ms
/s3/aws s3/table function performance/wildcard OK 3m 59s

Generated by TestFlows Open-Source Test Framework v2.0.240705.1133204