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

DateAug 03, 2023 9:07
Duration1h 53m
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.20.12.altinitystable/5744038919/testflows/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/22.8/7fb126d648460c159657a337b2f0cc24fbbce2ee/package_release/clickhouse-common-static_22.8.20.12.altinitystable_amd64.deb
version22.8.20.12.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashb13df10b2ee4ce720b5635d1e0208debff3f6ca8
job.id5744038919
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/5744038919
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/7fb126d648460c159657a337b2f0cc24fbbce2ee/package_release/clickhouse-common-static_22.8.20.12.altinitystable_amd64.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
11637
11424
212
1

Known Fails

Test NameResultMessage
/tiered storage/with s3amazon/alter table policyXFail 1ms
Investigating
None
/tiered storage/with s3amazon/double move while selectXFail 8s 742ms
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 53m
/tiered storage/with s3amazon OK 1h 53m
/tiered storage/with s3amazon/startup and queries OK 36s 525ms
/tiered storage/with s3amazon/metadata OK 9s 656ms
/tiered storage/with s3amazon/no changes to queries OK 11s 703ms
/tiered storage/with s3amazon/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 13s 105ms
/tiered storage/with s3amazon/system tables OK 227ms
/tiered storage/with s3amazon/system.detached_parts OK 3s 200ms
/tiered storage/with s3amazon/attach or replace partition different policies OK 644ms
/tiered storage/with s3amazon/query parser OK 774ms
/tiered storage/with s3amazon/keep free space OK 16s 102ms
/tiered storage/with s3amazon/no warning about zero max data part size OK 645ms
/tiered storage/with s3amazon/round robin OK 1s 440ms
/tiered storage/with s3amazon/max data part size OK 11s 777ms
/tiered storage/with s3amazon/jbod overflow OK 50s 651ms
/tiered storage/with s3amazon/start stop moves OK 28s 146ms
/tiered storage/with s3amazon/mutate to another disk OK 32s 15ms
/tiered storage/with s3amazon/alter table policy XFail 1ms
/tiered storage/with s3amazon/simple replication and moves OK 57s 491ms
/tiered storage/with s3amazon/download appropriate disk OK 9s 294ms
/tiered storage/with s3amazon/download appropriate disk advanced OK 22s 597ms
/tiered storage/with s3amazon/download appropriate disk max data part size OK 30s 145ms
/tiered storage/with s3amazon/rename OK 11s 256ms
/tiered storage/with s3amazon/freeze OK 7s 579ms
/tiered storage/with s3amazon/double move while select XFail 8s 742ms
/tiered storage/with s3amazon/background move OK 5m 45s
/tiered storage/with s3amazon/alter move OK 28m 22s
/tiered storage/with s3amazon/merge parts different volumes OK 15s 155ms
/tiered storage/with s3amazon/merge parts different volumes no space OK 14s 855ms
/tiered storage/with s3amazon/ttl moves OK 1h 4m
/tiered storage/with s3amazon/change config norestart OK 5m 47s

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122