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

DateDec 26, 2023 12:46
Duration1h 32m
Framework TestFlows 2.0.231130.1212236

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.8/57762a45dd8d7579a37ae9643654cde6896312dc/package_release/clickhouse-common-static_23.8.8.21.altinitystable_amd64.deb
version23.8.8.21.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash27f122d9326c830125ea4abefe85b76889afde24
job.id7328846900
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/7328846900
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.8/57762a45dd8d7579a37ae9643654cde6896312dc/package_release/clickhouse-common-static_23.8.8.21.altinitystable_amd64.deb
collect_service_logsTrue

Summary

91.9%OK
8.1%Known

Statistics

Units OK Fail XFail
Modules
1
1
Suites
1
1
Features
1
1
Scenarios
93
85
8
Examples
3
3
Steps
12686
12177
508
1

Known Fails

Test NameResultMessage
/tiered storage/with s3amazon/alter table policyXFail 633us
Investigating
None
/tiered storage/with s3amazon/double move while selectXFail 4s 641ms
not yet supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 392, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 380, in regression
    Feature(name, test=feature)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 270, 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 32m
/tiered storage/with s3amazon OK 1h 32m
/tiered storage/with s3amazon/startup and queries OK 31s 260ms
/tiered storage/with s3amazon/metadata OK 5s 239ms
/tiered storage/with s3amazon/no changes to queries OK 8s 323ms
/tiered storage/with s3amazon/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 14s 793ms
/tiered storage/with s3amazon/system tables OK 158ms
/tiered storage/with s3amazon/system.detached_parts OK 1s 418ms
/tiered storage/with s3amazon/attach or replace partition different policies OK 413ms
/tiered storage/with s3amazon/query parser OK 446ms
/tiered storage/with s3amazon/keep free space OK 8s 979ms
/tiered storage/with s3amazon/no warning about zero max data part size OK 389ms
/tiered storage/with s3amazon/round robin OK 922ms
/tiered storage/with s3amazon/max data part size OK 5s 843ms
/tiered storage/with s3amazon/jbod overflow OK 36s 995ms
/tiered storage/with s3amazon/start stop moves OK 17s 400ms
/tiered storage/with s3amazon/mutate to another disk OK 12s 706ms
/tiered storage/with s3amazon/alter table policy XFail 633us
/tiered storage/with s3amazon/simple replication and moves OK 53s 670ms
/tiered storage/with s3amazon/download appropriate disk OK 8s 900ms
/tiered storage/with s3amazon/download appropriate disk advanced OK 17s 31ms
/tiered storage/with s3amazon/download appropriate disk max data part size OK 23s 129ms
/tiered storage/with s3amazon/rename OK 4s 827ms
/tiered storage/with s3amazon/freeze OK 4s 449ms
/tiered storage/with s3amazon/double move while select XFail 4s 641ms
/tiered storage/with s3amazon/background move OK 4m 2s
/tiered storage/with s3amazon/alter move OK 17m 38s
/tiered storage/with s3amazon/merge parts different volumes OK 13s 246ms
/tiered storage/with s3amazon/merge parts different volumes no space OK 4s 300ms
/tiered storage/with s3amazon/ttl moves OK 58m 40s
/tiered storage/with s3amazon/change config norestart OK 5m 19s

Generated by TestFlows Open-Source Test Framework v2.0.231130.1212236