Copyright 2023, 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..

Tiered Storage Test Run Report

DateSep 19, 2023 8:21
Duration2h 8m
Framework TestFlows 1.9.230315.1003122

Artifacts

Test artifacts can be found at https://altinity-test-reports.s3.amazonaws.com/index.html#clickhouse/22.8.15.25.altinitystable/6231175917/testflows/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/265/6b52da82b6ca003e8ebd34ead5f4eabbc45d1cd6/package_aarch64/clickhouse-common-static_22.8.15.25.altinitystable_arm64.deb
version22.8.15.25.altinitystable
user.nameMyroTk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashc23ebf091e566342377fb79fbd78ac3f7a42e678
job.id6231175917
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/6231175917
archaarch64
stressFalse
with_minioFalse
with_s3amazonTrue
with_s3gcsFalse
aws_s3_access_keySecret(name='aws_s3_access_key')
aws_s3_key_idSecret(name='aws_s3_key_id')
aws_s3_uriSecret(name='aws_s3_uri')
gcs_key_secretSecret(name='gcs_key_secret')
gcs_key_idSecret(name='gcs_key_id')
gcs_uriSecret(name='gcs_uri')
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/265/6b52da82b6ca003e8ebd34ead5f4eabbc45d1cd6/package_aarch64/clickhouse-common-static_22.8.15.25.altinitystable_arm64.deb
collect_service_logsTrue

Summary

94.9%OK
5.1%Known

Statistics

Units OK Fail XFail
Modules
1
1
Suites
1
1
Features
1
1
Scenarios
93
88
5
Examples
3
3
Steps
11674
11461
212
1

Known Fails

Test NameResultMessage
/tiered storage/with s3amazon/alter table policyXFail 1ms
Investigating
None
/tiered storage/with s3amazon/double move while selectXFail 13s 340ms
not yet supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 399, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 387, in regression
    Feature(name, test=feature)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 276, in feature
    Scenario(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../tiered_storage/tests/double_move_while_select.py", line 120, in scenario
    assert r == [
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert r == [
      ("jbod1" if positive else "external")
  ], error()

Assertion values
  assert r == [
         ^ is ['jbod1']
      ("jbod1" if positive else "external")
  ], error()
  assert r == [
      ("jbod1" if positive else "external")
                  ^ is 0
  ], error()
  assert r == [
      ("jbod1" if positive else "external")
       ^ is = 'external'
  ], error()
  assert r == [
              ^ is = ['external']
      ("jbod1" if positive else "external")
  ], error()
  assert r == [
           ^ is = False
    @@ -1 +1 @@
    -['jbod1']
    +['external']
      ("jbod1" if positive else "external")
  ], error()
  assert r == [
  ^ is False
      ("jbod1" if positive else "external")
  ], error()

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../tiered_storage/tests/double_move_while_select.py', line 122 in 'scenario'

114\|                                      .output.strip()
115\|                                      .splitlines()
116\|                                  )
117\|                                  with Then(
118\|                                      "if select locked old part on the destination disk the move shall fail"
119\|                                  ):
120\|                                      assert r == [
121\|                                          ("jbod1" if positive else "external")
122\|>                                     ], error()
123\|                          finally:
124\|                              with Finally("I join the thread"):
125\|                                  task.result(timeout=60)

Results

Test Name Result Duration
/tiered storage OK 2h 8m
/tiered storage/with s3amazon OK 2h 8m
/tiered storage/with s3amazon/startup and queries OK 44s 578ms
/tiered storage/with s3amazon/metadata OK 13s 412ms
/tiered storage/with s3amazon/no changes to queries OK 14s 837ms
/tiered storage/with s3amazon/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 13s 803ms
/tiered storage/with s3amazon/system tables OK 289ms
/tiered storage/with s3amazon/system.detached_parts OK 5s 122ms
/tiered storage/with s3amazon/attach or replace partition different policies OK 1s 175ms
/tiered storage/with s3amazon/query parser OK 1s 494ms
/tiered storage/with s3amazon/keep free space OK 24s 393ms
/tiered storage/with s3amazon/no warning about zero max data part size OK 1s 132ms
/tiered storage/with s3amazon/round robin OK 2s 460ms
/tiered storage/with s3amazon/max data part size OK 13s 460ms
/tiered storage/with s3amazon/jbod overflow OK 59s 716ms
/tiered storage/with s3amazon/start stop moves OK 33s 402ms
/tiered storage/with s3amazon/mutate to another disk OK 37s 580ms
/tiered storage/with s3amazon/alter table policy XFail 1ms
/tiered storage/with s3amazon/simple replication and moves OK 1m 5s
/tiered storage/with s3amazon/download appropriate disk OK 12s 302ms
/tiered storage/with s3amazon/download appropriate disk advanced OK 27s 151ms
/tiered storage/with s3amazon/download appropriate disk max data part size OK 27s 27ms
/tiered storage/with s3amazon/rename OK 13s 35ms
/tiered storage/with s3amazon/freeze OK 10s 505ms
/tiered storage/with s3amazon/double move while select XFail 13s 340ms
/tiered storage/with s3amazon/background move OK 7m 38s
/tiered storage/with s3amazon/alter move OK 36m 11s
/tiered storage/with s3amazon/merge parts different volumes OK 16s 316ms
/tiered storage/with s3amazon/merge parts different volumes no space OK 28s 107ms
/tiered storage/with s3amazon/ttl moves OK 1h 8m
/tiered storage/with s3amazon/change config norestart OK 6m 15s

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122