Copyright 2024, 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 22, 2024 9:22
Duration1h 52m
Framework TestFlows 2.0.240708.1162538

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/24.3/b6642564dbf296d6e55b907d7af6c8087470b672/package_aarch64/clickhouse-common-static_24.3.5.47.altinitystable_arm64.deb
version24.3.5.47.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash63d4d92ec52dfe1f25bef0361a280f15cdae6e2e
job.id10037417827
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/10037417827
archaarch64
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/24.3/b6642564dbf296d6e55b907d7af6c8087470b672/package_aarch64/clickhouse-common-static_24.3.5.47.altinitystable_arm64.deb
keeper_binary_pathNone
zookeeper_versionNone
use_keeperFalse
stressFalse
collect_service_logsTrue
thread_fuzzerFalse
with_analyzerFalse
reuse_envFalse
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_uriSecret(name='gcs_uri')
gcs_key_idSecret(name='gcs_key_id')
gcs_key_secretSecret(name='gcs_key_secret')

Summary

96%OK
2.9%Known
1.1%Fail

Statistics

Units OK Fail Error XFail
Modules
1
1
Features
1
1
Scenarios
94
89
5
Checks
92
90
2
Examples
84
80
1
3
Steps
12293
12063
218
6
6

Known Fails

Test NameResultMessage
/tiered storage/with s3amazon/alter table policyXFail 1ms
Investigating
None
/tiered storage/with s3amazon/double move while selectXFail 9s 827ms
not yet supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 387, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  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 265, 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)
/tiered storage/with s3amazon/manual move with downtimeXFail 886ms
https://altinity.atlassian.net/browse/CH-124
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 387, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  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 277, in feature
    Scenario(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../tiered_storage/tests/manual_move_with_downtime.py", line 80, in scenario
    node.command(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../helpers/cluster.py", line 276, in command
    return self.cluster.command(self.name, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../helpers/cluster.py", line 1971, in command
    assert r.exitcode == exitcode, error(r.output)
           ^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert r.exitcode == exitcode, error(r.output)

Description
  Mv: target '/external/store/*/*/detached/.' is not a directory

Assertion values
  assert r.exitcode == exitcode, error(r.output)
         ^ is 
  assert r.exitcode == exitcode, error(r.output)
         ^ is = 1
  assert r.exitcode == exitcode, error(r.output)
                       ^ is 0
  assert r.exitcode == exitcode, error(r.output)
                    ^ is = False
  assert r.exitcode == exitcode, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../helpers/cluster.py', line 1971 in 'command'

1963\|                  Then(f"exitcode should be {exitcode}", format_name=False)
1964\|                  if steps
1965\|                  else NullStep()
1966\|              ):
1967\|                  if str(exitcode).startswith("!="):
1968\|                      exitcode = int(str(exitcode).split("!=", 1)[-1].strip())
1969\|                      assert r.exitcode != exitcode, error(r.output)
1970\|                  else:
1971\|>                     assert r.exitcode == exitcode, error(r.output)
1972\|  
1973\|          if messages is None:
1974\|              messages = []

Results

Test Name Result Duration
/tiered storage OK 1h 52m
/tiered storage/with s3amazon OK 1h 52m
/tiered storage/with s3amazon/startup and queries OK 40s 414ms
/tiered storage/with s3amazon/metadata OK 13s 503ms
/tiered storage/with s3amazon/no changes to queries OK 14s 735ms
/tiered storage/with s3amazon/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 13s 83ms
/tiered storage/with s3amazon/system tables OK 234ms
/tiered storage/with s3amazon/system․detached_parts OK 4s 689ms
/tiered storage/with s3amazon/attach or replace partition different policies OK 609ms
/tiered storage/with s3amazon/query parser OK 715ms
/tiered storage/with s3amazon/keep free space OK 23s 18ms
/tiered storage/with s3amazon/no warning about zero max data part size OK 610ms
/tiered storage/with s3amazon/round robin OK 1s 464ms
/tiered storage/with s3amazon/max data part size OK 11s 142ms
/tiered storage/with s3amazon/jbod overflow OK 1m 1s
/tiered storage/with s3amazon/start stop moves OK 27s 299ms
/tiered storage/with s3amazon/mutate to another disk OK 21s 143ms
/tiered storage/with s3amazon/alter table policy XFail 1ms
/tiered storage/with s3amazon/simple replication and moves OK 1m 18s
/tiered storage/with s3amazon/download appropriate disk OK 11s 276ms
/tiered storage/with s3amazon/download appropriate disk advanced OK 23s 266ms
/tiered storage/with s3amazon/download appropriate disk max data part size OK 20s 494ms
/tiered storage/with s3amazon/rename OK 12s 55ms
/tiered storage/with s3amazon/freeze OK 11s 390ms
/tiered storage/with s3amazon/double move while select XFail 9s 827ms
/tiered storage/with s3amazon/background move OK 7m 14s
/tiered storage/with s3amazon/alter move OK 18m 43s
/tiered storage/with s3amazon/manual move with downtime XFail 886ms
/tiered storage/with s3amazon/merge parts different volumes OK 12s 695ms
/tiered storage/with s3amazon/merge parts different volumes no space OK 30s 130ms
/tiered storage/with s3amazon/ttl moves OK 1h 9m
/tiered storage/with s3amazon/change config norestart OK 6m 22s

Generated by TestFlows Open-Source Test Framework v2.0.240708.1162538