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

DateMay 25, 2023 21:32
Duration2h 10m
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.altinityfips/5080932159/testflows/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/22.8/ef5580902f444e6a5d617e7c7a6e8d7a1f5fc9fb/package_release/clickhouse-common-static_22.8.15.25.altinityfips_amd64.deb
version22.8.15.25.altinityfips
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash63a15b5dfc55badefcf4b869296e3ec99ca08141
job.id5080932159
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/5080932159
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/22.8/ef5580902f444e6a5d617e7c7a6e8d7a1f5fc9fb/package_release/clickhouse-common-static_22.8.15.25.altinityfips_amd64.deb
collect_service_logsTrue

Summary

96%OK
4%Known

Statistics

Units OK Fail XFail
Modules
1
1
Suites
1
1
Features
1
1
Scenarios
93
89
4
Examples
3
3
Steps
11672
11466
205
1

Known Fails

Test NameResultMessage
/tiered storage/with s3amazon/alter table policyXFail 921us
Investigating
None
/tiered storage/with s3amazon/double move while selectXFail 8s 82ms
not yet supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 399, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 387, in regression
    Feature(name, test=feature)(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 276, 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 2h 10m
/tiered storage/with s3amazon OK 2h 10m
/tiered storage/with s3amazon/startup and queries OK 36s 573ms
/tiered storage/with s3amazon/metadata OK 9s 446ms
/tiered storage/with s3amazon/no changes to queries OK 11s 300ms
/tiered storage/with s3amazon/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 13s 123ms
/tiered storage/with s3amazon/system tables OK 214ms
/tiered storage/with s3amazon/system.detached_parts OK 3s 296ms
/tiered storage/with s3amazon/attach or replace partition different policies OK 657ms
/tiered storage/with s3amazon/query parser OK 798ms
/tiered storage/with s3amazon/keep free space OK 16s 798ms
/tiered storage/with s3amazon/no warning about zero max data part size OK 669ms
/tiered storage/with s3amazon/round robin OK 1s 578ms
/tiered storage/with s3amazon/max data part size OK 10s 615ms
/tiered storage/with s3amazon/jbod overflow OK 49s 939ms
/tiered storage/with s3amazon/start stop moves OK 27s 191ms
/tiered storage/with s3amazon/mutate to another disk OK 33s 487ms
/tiered storage/with s3amazon/alter table policy XFail 921us
/tiered storage/with s3amazon/simple replication and moves OK 55s 560ms
/tiered storage/with s3amazon/download appropriate disk OK 11s 91ms
/tiered storage/with s3amazon/download appropriate disk advanced OK 22s 790ms
/tiered storage/with s3amazon/download appropriate disk max data part size OK 25s 891ms
/tiered storage/with s3amazon/rename OK 9s 518ms
/tiered storage/with s3amazon/freeze OK 7s 320ms
/tiered storage/with s3amazon/double move while select XFail 8s 82ms
/tiered storage/with s3amazon/background move OK 5m 35s
/tiered storage/with s3amazon/alter move OK 45m 22s
/tiered storage/with s3amazon/merge parts different volumes OK 16s 31ms
/tiered storage/with s3amazon/merge parts different volumes no space OK 14s 813ms
/tiered storage/with s3amazon/ttl moves OK 1h 5m
/tiered storage/with s3amazon/change config norestart OK 5m 41s

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122