Tiered Storage Test Run Report

DateMar 19, 2024 17:45
Duration1h 18m
Framework TestFlows 2.0.231215.1221232

Artifacts

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

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.3/0a8ac3b092733da37e3e2a0079c486938a36790d/package_release/clickhouse-common-static_23.3.19.34.altinityfips_amd64.deb
version23.3.19.34.altinityfips
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash6da94b78dc53cb8965ab56c04a89ebf54ed04cbc
job.id8247806903
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/8247806903
archx86_64
stressFalse
with_minioFalse
with_s3amazonFalse
with_s3gcsFalse
aws_s3_access_keySecret(name='aws_s3_access_key')
aws_s3_key_idSecret(name='aws_s3_key_id')
aws_s3_uriNone
gcs_key_secretNone
gcs_key_idNone
gcs_uriNone
allow_vfsFalse
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/23.3/0a8ac3b092733da37e3e2a0079c486938a36790d/package_release/clickhouse-common-static_23.3.19.34.altinityfips_amd64.deb
collect_service_logsTrue

Summary

94%OK
6%Known

Statistics

Units OK Fail XFail
Modules
1
1
Features
2
2
Scenarios
94
88
6
Examples
3
3
Steps
12588
12362
225
1

Known Fails

Test NameResultMessage
/tiered storage/normal/normal/query parserXFail 710ms
Incorrect message https://github.com/ClickHouse/ClickHouse/pull/51854
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 417, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 404, in regression
    Feature(name, test=feature)(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/regression.py", line 216, in feature
    Scenario(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../tiered_storage/tests/query_parser.py", line 101, in scenario
    node.query(sql, message, exitcode)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/tiered_storage/../helpers/cluster.py", line 836, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 23.3.19):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: New storage policy `default` shall contain volumes of old one. (BAD_ARGUMENTS)
(query: ALTER TABLE table_with_normal_policy MODIFY SETTING storage_policy='moving_jbod_with_external'
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'Exception: New storage policy `moving_jbod_with_external` shall contain volumes of the old storage policy `default`.'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = "Received exception from server (version 23.3.19):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: New storage policy `default` shall contain volumes of old one. (BAD_ARGUMENTS)\n(query: ALTER TABLE table_with_normal_policy MODIFY SETTING storage_policy='moving_jbod_with_external'\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

828\|                  assert r.exitcode == exitcode, error(r.output)
829\|  
830\|          if message is not None:
831\|              with (
832\|                  Then(f"output should contain message", description=message)
833\|                  if steps
834\|                  else NullStep()
835\|              ):
836\|>                 assert message in r.output, error(r.output)
837\|  
838\|          if not ignore_exception:
839\|              if message is None or "Exception:" not in message:

Results

Test Name Result Duration
/tiered storage OK 1h 18m
/tiered storage/normal OK 1h 18m
/tiered storage/normal/normal OK 1h 17m
/tiered storage/normal/normal/startup and queries OK 24s 738ms
/tiered storage/normal/normal/metadata OK 3s 567ms
/tiered storage/normal/normal/no changes to queries OK 4s 262ms
/tiered storage/normal/normal/volume configuration either max_data_part_size_bytes or max_data_part_size_ratio OK 12s 968ms
/tiered storage/normal/normal/system tables OK 205ms
/tiered storage/normal/normal/system.detached_parts OK 1s 722ms
/tiered storage/normal/normal/attach or replace partition different policies OK 550ms
/tiered storage/normal/normal/query parser XFail 710ms
/tiered storage/normal/normal/keep free space OK 9s 374ms
/tiered storage/normal/normal/no warning about zero max data part size OK 558ms
/tiered storage/normal/normal/round robin OK 1s 219ms
/tiered storage/normal/normal/max data part size OK 2s 609ms
/tiered storage/normal/normal/jbod overflow OK 28s 880ms
/tiered storage/normal/normal/start stop moves OK 9s 691ms
/tiered storage/normal/normal/mutate to another disk OK 7s 456ms
/tiered storage/normal/normal/alter table policy OK 12s 668ms
/tiered storage/normal/normal/simple replication and moves OK 38s 504ms
/tiered storage/normal/normal/download appropriate disk OK 2s 480ms
/tiered storage/normal/normal/download appropriate disk advanced OK 17s 170ms
/tiered storage/normal/normal/download appropriate disk max data part size OK 9s 425ms
/tiered storage/normal/normal/rename OK 3s 380ms
/tiered storage/normal/normal/freeze OK 3s 83ms
/tiered storage/normal/normal/double move while select OK 9s 113ms
/tiered storage/normal/normal/background move OK 3m 56s
/tiered storage/normal/normal/alter move OK 7m 9s
/tiered storage/normal/normal/manual move with downtime OK 3s 158ms
/tiered storage/normal/normal/merge parts different volumes OK 11s 477ms
/tiered storage/normal/normal/merge parts different volumes no space OK 4s 542ms
/tiered storage/normal/normal/ttl moves OK 57m 27s
/tiered storage/normal/normal/change config norestart OK 4m 59s

Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232