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

DateOct 05, 2023 15:01
Duration1h 48m
Framework TestFlows 1.9.230315.1003122

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.3/f040635d5f373c5e4be08e5fbec2622a9889adde/package_release/clickhouse-common-static_23.3.13.7.altinitystable_amd64.deb
version23.3.13.7.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash53dd0b4af71fdeac6704e70f4ff79eacbae2159a
job.id6416627213
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/6416627213
archx86_64
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/23.3/f040635d5f373c5e4be08e5fbec2622a9889adde/package_release/clickhouse-common-static_23.3.13.7.altinitystable_amd64.deb
collect_service_logsTrue

Summary

93.9%OK
6.1%Known

Statistics

Units OK Fail XFail
Modules
1
1
Suites
1
1
Features
1
1
Scenarios
93
87
6
Examples
3
3
Steps
11520
11309
210
1

Known Fails

Test NameResultMessage
/tiered storage/with s3amazon/alter table policyXFail 1ms
Investigating
None
/tiered storage/with s3amazon/double move while selectXFail 7s 416ms
not yet supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 388, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 376, in regression
    Feature(name, test=feature)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 266, 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 1h 48m
/tiered storage/with s3amazon OK 1h 48m
/tiered storage/with s3amazon/startup and queries OK 35s 687ms
/tiered storage/with s3amazon/metadata OK 9s 758ms
/tiered storage/with s3amazon/no changes to queries OK 10s 790ms
/tiered storage/with s3amazon/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 15s 21ms
/tiered storage/with s3amazon/system tables OK 196ms
/tiered storage/with s3amazon/system.detached_parts OK 2s 864ms
/tiered storage/with s3amazon/attach or replace partition different policies OK 565ms
/tiered storage/with s3amazon/query parser OK 679ms
/tiered storage/with s3amazon/keep free space OK 14s 348ms
/tiered storage/with s3amazon/no warning about zero max data part size OK 580ms
/tiered storage/with s3amazon/round robin OK 1s 317ms
/tiered storage/with s3amazon/max data part size OK 8s 314ms
/tiered storage/with s3amazon/jbod overflow OK 46s 100ms
/tiered storage/with s3amazon/start stop moves OK 21s 375ms
/tiered storage/with s3amazon/mutate to another disk OK 26s 872ms
/tiered storage/with s3amazon/alter table policy XFail 1ms
/tiered storage/with s3amazon/simple replication and moves OK 54s 469ms
/tiered storage/with s3amazon/download appropriate disk OK 7s 896ms
/tiered storage/with s3amazon/download appropriate disk advanced OK 19s 971ms
/tiered storage/with s3amazon/download appropriate disk max data part size OK 21s 346ms
/tiered storage/with s3amazon/rename OK 7s 927ms
/tiered storage/with s3amazon/freeze OK 7s 258ms
/tiered storage/with s3amazon/double move while select XFail 7s 416ms
/tiered storage/with s3amazon/background move OK 5m 55s
/tiered storage/with s3amazon/alter move OK 27m 41s
/tiered storage/with s3amazon/merge parts different volumes OK 13s 126ms
/tiered storage/with s3amazon/merge parts different volumes no space OK 15s 792ms
/tiered storage/with s3amazon/ttl moves OK 1h 0m
/tiered storage/with s3amazon/change config norestart OK 5m 56s

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122