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

DateJul 20, 2023 11:43
Duration1h 43m
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.8.23.altinityfips/5601674688/testflows/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.3/3a254fe0cc318f5620a5df4043f7c6d322a8ad04/package_release/clickhouse-common-static_23.3.8.23.altinityfips_amd64.deb
version23.3.8.23.altinityfips
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashb13df10b2ee4ce720b5635d1e0208debff3f6ca8
job.id5601674688
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/5601674688
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/3a254fe0cc318f5620a5df4043f7c6d322a8ad04/package_release/clickhouse-common-static_23.3.8.23.altinityfips_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
11534
11317
216
1

Known Fails

Test NameResultMessage
/tiered storage/with s3amazon/alter table policyXFail 1ms
Investigating
None
/tiered storage/with s3amazon/double move while selectXFail 7s 7ms
not yet supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 405, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 393, in regression
    Feature(name, test=feature)(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 282, in feature
    Scenario(
  File "/home/ubuntu/actions-runner/_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/actions-runner/_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 43m
/tiered storage/with s3amazon OK 1h 43m
/tiered storage/with s3amazon/startup and queries OK 36s 300ms
/tiered storage/with s3amazon/metadata OK 8s 735ms
/tiered storage/with s3amazon/no changes to queries OK 10s 478ms
/tiered storage/with s3amazon/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 14s 193ms
/tiered storage/with s3amazon/system tables OK 223ms
/tiered storage/with s3amazon/system.detached_parts OK 3s 330ms
/tiered storage/with s3amazon/attach or replace partition different policies OK 704ms
/tiered storage/with s3amazon/query parser OK 834ms
/tiered storage/with s3amazon/keep free space OK 16s 161ms
/tiered storage/with s3amazon/no warning about zero max data part size OK 845ms
/tiered storage/with s3amazon/round robin OK 1s 628ms
/tiered storage/with s3amazon/max data part size OK 8s 158ms
/tiered storage/with s3amazon/jbod overflow OK 46s 106ms
/tiered storage/with s3amazon/start stop moves OK 21s 590ms
/tiered storage/with s3amazon/mutate to another disk OK 27s 231ms
/tiered storage/with s3amazon/alter table policy XFail 1ms
/tiered storage/with s3amazon/simple replication and moves OK 53s 484ms
/tiered storage/with s3amazon/download appropriate disk OK 8s 814ms
/tiered storage/with s3amazon/download appropriate disk advanced OK 21s 386ms
/tiered storage/with s3amazon/download appropriate disk max data part size OK 21s 282ms
/tiered storage/with s3amazon/rename OK 8s 93ms
/tiered storage/with s3amazon/freeze OK 7s 196ms
/tiered storage/with s3amazon/double move while select XFail 7s 7ms
/tiered storage/with s3amazon/background move OK 5m 40s
/tiered storage/with s3amazon/alter move OK 22m 47s
/tiered storage/with s3amazon/merge parts different volumes OK 13s 98ms
/tiered storage/with s3amazon/merge parts different volumes no space OK 15s 294ms
/tiered storage/with s3amazon/ttl moves OK 1h 1m
/tiered storage/with s3amazon/change config norestart OK 5m 43s

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122