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..
| Date | Mar 02, 2024 1:15 |
| Duration | 2h 50m |
| Framework | TestFlows 2.0.231215.1221232 |
Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#0/false/regression/
| project | Altinity/ClickHouse |
| project.id | 159717931 |
| package | https://s3.amazonaws.com/altinity-build-artifacts/23.3/19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c/package_aarch64/clickhouse-common-static_23.3.19.33.altinitystable_arm64.deb |
| version | 23.3.19.33.altinitystable |
| user.name | Enmk |
| repository | https://github.com/Altinity/clickhouse-regression |
| commit.hash | 6da94b78dc53cb8965ab56c04a89ebf54ed04cbc |
| job.id | 8115174679 |
| job.url | https://github.com/Altinity/ClickHouse/actions/runs/8115174679 |
| arch | aarch64 |
| stress | False |
| allow_vfs | False |
| local | True |
| clickhouse_version | None |
| clickhouse_binary_path | https://s3.amazonaws.com/altinity-build-artifacts/23.3/19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c/package_aarch64/clickhouse-common-static_23.3.19.33.altinitystable_arm64.deb |
| collect_service_logs | True |
| use_specific_version | altinity/clickhouse-server:23.3.13.7.altinitytest |
| Units | Skip | OK | Fail | XFail | |
|---|---|---|---|---|---|
| Modules | |||||
| Features | |||||
| Scenarios | |||||
| Checks | |||||
| Steps |
| Test Name | Result | Message |
|---|---|---|
| /alter | Fail 2h 50m | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/usr/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/attach_partition/partition_key.py", line 882, in check_attach_partition_from
data_before = self.context.node_1.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py", line 844, in query
assert False, error(r.output)
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert False, error(r.output)
Description
Received exception from server (version 23.3.19):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'time' 'date' while processing query: 'SELECT a, b, c, extra, Path, Time, Value, Timestamp, sign FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time ASC, date ASC, extra ASC', required columns: 'a' 'Timestamp' 'date' 'c' 'Path' 'b' 'extra' 'Time' 'Value' 'sign' 'time', maybe you meant: 'a', 'Timestamp', 'Path', 'c', 'b', 'extra', 'Time', 'Value' or 'sign'. (UNKNOWN_IDENTIFIER)
(query: SELECT * FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time,date,extra
)
Assertion values
assert False, error(r.output)
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py', line 844 in 'query'
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:
840\| with Then("check if output has exception") if steps else NullStep():
841\| if "Exception:" in r.output:
842\| if raise_on_exception:
843\| raise QueryRuntimeException(r.output)
844\|> assert False, error(r.output)
845\|
846\| return r
847\| |
| /alter/attach partition | Fail 25m 14s | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/usr/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/attach_partition/partition_key.py", line 882, in check_attach_partition_from
data_before = self.context.node_1.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py", line 844, in query
assert False, error(r.output)
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert False, error(r.output)
Description
Received exception from server (version 23.3.19):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'time' 'date' while processing query: 'SELECT a, b, c, extra, Path, Time, Value, Timestamp, sign FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time ASC, date ASC, extra ASC', required columns: 'a' 'Timestamp' 'date' 'c' 'Path' 'b' 'extra' 'Time' 'Value' 'sign' 'time', maybe you meant: 'a', 'Timestamp', 'Path', 'c', 'b', 'extra', 'Time', 'Value' or 'sign'. (UNKNOWN_IDENTIFIER)
(query: SELECT * FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time,date,extra
)
Assertion values
assert False, error(r.output)
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py', line 844 in 'query'
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:
840\| with Then("check if output has exception") if steps else NullStep():
841\| if "Exception:" in r.output:
842\| if raise_on_exception:
843\| raise QueryRuntimeException(r.output)
844\|> assert False, error(r.output)
845\|
846\| return r
847\| |
| /alter/attach partition/partition key | Fail 4m 19s | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/usr/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/attach_partition/partition_key.py", line 882, in check_attach_partition_from
data_before = self.context.node_1.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py", line 844, in query
assert False, error(r.output)
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert False, error(r.output)
Description
Received exception from server (version 23.3.19):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'time' 'date' while processing query: 'SELECT a, b, c, extra, Path, Time, Value, Timestamp, sign FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time ASC, date ASC, extra ASC', required columns: 'a' 'Timestamp' 'date' 'c' 'Path' 'b' 'extra' 'Time' 'Value' 'sign' 'time', maybe you meant: 'a', 'Timestamp', 'Path', 'c', 'b', 'extra', 'Time', 'Value' or 'sign'. (UNKNOWN_IDENTIFIER)
(query: SELECT * FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time,date,extra
)
Assertion values
assert False, error(r.output)
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py', line 844 in 'query'
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:
840\| with Then("check if output has exception") if steps else NullStep():
841\| if "Exception:" in r.output:
842\| if raise_on_exception:
843\| raise QueryRuntimeException(r.output)
844\|> assert False, error(r.output)
845\|
846\| return r
847\| |
| /alter/attach partition/partition key/attach partition from without id | Fail 4m 15s | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/usr/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/attach_partition/partition_key.py", line 882, in check_attach_partition_from
data_before = self.context.node_1.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py", line 844, in query
assert False, error(r.output)
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert False, error(r.output)
Description
Received exception from server (version 23.3.19):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'time' 'date' while processing query: 'SELECT a, b, c, extra, Path, Time, Value, Timestamp, sign FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time ASC, date ASC, extra ASC', required columns: 'a' 'Timestamp' 'date' 'c' 'Path' 'b' 'extra' 'Time' 'Value' 'sign' 'time', maybe you meant: 'a', 'Timestamp', 'Path', 'c', 'b', 'extra', 'Time', 'Value' or 'sign'. (UNKNOWN_IDENTIFIER)
(query: SELECT * FROM destination_981e5d5e_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time,date,extra
)
Assertion values
assert False, error(r.output)
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py', line 844 in 'query'
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:
840\| with Then("check if output has exception") if steps else NullStep():
841\| if "Exception:" in r.output:
842\| if raise_on_exception:
843\| raise QueryRuntimeException(r.output)
844\|> assert False, error(r.output)
845\|
846\| return r
847\| |
| /alter/attach partition/partition key/attach partition from with id | Fail 4m 19s | AssertionError
Traceback (most recent call last):
File "/usr/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/usr/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../alter/table/attach_partition/partition_key.py", line 882, in check_attach_partition_from
data_before = self.context.node_1.query(
File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py", line 844, in query
assert False, error(r.output)
AssertionError: Oops! Assertion failed
The following assertion was not satisfied
assert False, error(r.output)
Description
Received exception from server (version 23.3.19):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'time' 'date' while processing query: 'SELECT a, b, c, extra, Path, Time, Value, Timestamp, sign FROM destination_982445fc_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time ASC, date ASC, extra ASC', required columns: 'a' 'Timestamp' 'date' 'c' 'Path' 'b' 'extra' 'Time' 'Value' 'sign' 'time', maybe you meant: 'a', 'Timestamp', 'Path', 'c', 'b', 'extra', 'Time', 'Value' or 'sign'. (UNKNOWN_IDENTIFIER)
(query: SELECT * FROM destination_982445fc_d846_11ee_b3de_7ffdf311cc75 WHERE a > 1 ORDER BY time,date,extra
)
Assertion values
assert False, error(r.output)
^ is False
Where
File '/home/ubuntu/_work/ClickHouse/ClickHouse/alter/../helpers/cluster.py', line 844 in 'query'
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:
840\| with Then("check if output has exception") if steps else NullStep():
841\| if "Exception:" in r.output:
842\| if raise_on_exception:
843\| raise QueryRuntimeException(r.output)
844\|> assert False, error(r.output)
845\|
846\| return r
847\| |
| Test Name | Result | Duration |
|---|---|---|
| /alter | Fail | 2h 50m |
| /alter/replace partition | OK | 2h 21m |
| /alter/replace partition/partition types | OK | 51s 250ms |
| /alter/replace partition/partition types/replace partition with different partition types | OK | 51s 248ms |
| /alter/replace partition/rbac | OK | 42m 12s |
| /alter/replace partition/rbac/check replace partition with privileges | OK | 42m 12s |
| /alter/replace partition/concurrent replace partitions | OK | 12m 11s |
| /alter/replace partition/data integrity | OK | 10s 730ms |
| /alter/replace partition/data integrity/keep data on a source table | OK | 2s 406ms |
| /alter/replace partition/data integrity/non existent partition destination | OK | 2s 626ms |
| /alter/replace partition/data integrity/non existent partition source | OK | 2s 876ms |
| /alter/replace partition/data integrity/partition changes in system | OK | 2s 818ms |
| /alter/replace partition/prohibited actions | OK | 19s 656ms |
| /alter/replace partition/prohibited actions/from clause | OK | 8s 962ms |
| /alter/replace partition/prohibited actions/from clause/table functions | OK | 1s 333ms |
| /alter/replace partition/prohibited actions/from clause/join | OK | 1s 345ms |
| /alter/replace partition/prohibited actions/from clause/subquery | OK | 1s 361ms |
| /alter/replace partition/prohibited actions/from clause/non mergetree table | OK | 1s 519ms |
| /alter/replace partition/prohibited actions/from clause/view | OK | 361ms |
| /alter/replace partition/prohibited actions/from clause/materialized view | OK | 359ms |
| /alter/replace partition/prohibited actions/from clause/remote | OK | 1s 331ms |
| /alter/replace partition/prohibited actions/from clause/remote secure | OK | 1s 346ms |
| /alter/replace partition/prohibited actions/conditions | OK | 5s 378ms |
| /alter/replace partition/prohibited actions/conditions/storage policy | OK | 1s 323ms |
| /alter/replace partition/prohibited actions/conditions/partition by | OK | 1s 351ms |
| /alter/replace partition/prohibited actions/conditions/order by | OK | 1s 345ms |
| /alter/replace partition/prohibited actions/conditions/structure | OK | 1s 356ms |
| /alter/replace partition/prohibited actions/miscellaneous | OK | 5s 313ms |
| /alter/replace partition/prohibited actions/miscellaneous/order by partition by | OK | 1s 331ms |
| /alter/replace partition/prohibited actions/miscellaneous/into outfile | OK | 1s 297ms |
| /alter/replace partition/prohibited actions/miscellaneous/format | OK | 1s 315ms |
| /alter/replace partition/prohibited actions/miscellaneous/settings | OK | 1s 368ms |
| /alter/replace partition/temporary table | Skip | 1ms |
| /alter/replace partition/engines | OK | 1m 27s |
| /alter/replace partition/engines/replace partition with different engines | OK | 1m 27s |
| /alter/replace partition/concurrent actions | OK | 2h 19m |
| /alter/replace partition/concurrent actions/one replace partition | OK | 2h 5m |
| /alter/replace partition/concurrent replace partitions/concurrent replace | OK | 59s 379ms |
| /alter/replace partition/concurrent merges and mutations | OK | 20s 296ms |
| /alter/replace partition/concurrent merges and mutations/merges on unrelated partition | OK | 6s 558ms |
| /alter/replace partition/concurrent merges and mutations/mutations on unrelated partition | OK | 13s 734ms |
| /alter/replace partition/storage | OK | 2m 17s |
| /alter/replace partition/storage/different disks | OK | 13s 640ms |
| /alter/replace partition/storage/shards | OK | 18s 96ms |
| /alter/replace partition/storage/replicas | OK | 20s 557ms |
| /alter/replace partition/storage/replace partition on minio and default disks | OK | 1m 5s |
| /alter/replace partition/storage/replace partition on tiered and default storages | OK | 8s 366ms |
| /alter/replace partition/storage/partition moved to another disk | OK | 11s 182ms |
| /alter/replace partition/corrupted partitions | OK | 3m 35s |
| /alter/replace partition/corrupted partitions/replace partition with corrupted parts | OK | 3m 35s |
| /alter/replace partition/clickhouse versions | OK | 48s 674ms |
| /alter/replace partition/clickhouse versions/replace partition on table created after update | OK | 9s 355ms |
| /alter/replace partition/clickhouse versions/replace partition on table created before update | OK | 9s 442ms |
| /alter/replace partition/clickhouse versions/replace partition on updated and reverted version | OK | 14s 497ms |
| /alter/replace partition/clickhouse versions/replace partition on updated version | OK | 14s 991ms |
| /alter/replace partition/concurrent replace partitions on replicas | OK | 50m 28s |
| /alter/replace partition/concurrent replace partitions on replicas/multiple shards with replicas | OK | 16m 10s |
| /alter/replace partition/concurrent replace partitions on replicas/single shard three replicas | OK | 17m 47s |
| /alter/replace partition/concurrent replace partitions on replicas/single shard three replicas secure | OK | 16m 30s |
| /alter/replace partition/concurrent actions/replace partition along other actions | OK | 13m 39s |
| /alter/attach partition | Fail | 25m 14s |
| /alter/attach partition/partition types | OK | 35s 202ms |
| /alter/attach partition/partition types/attach part detached with different partition types | OK | 35s 201ms |
| /alter/attach partition/partition key | Fail | 4m 19s |
| /alter/attach partition/partition key/attach partition from without id | Fail | 4m 15s |
| /alter/attach partition/partition key/attach partition from with id | Fail | 4m 19s |
| /alter/attach partition/partition key datetime | OK | 5m 5s |
| /alter/attach partition/partition key datetime/attach partition from | OK | 5m 5s |
| /alter/attach partition/storage | OK | 22s 803ms |
| /alter/attach partition/storage/shards | OK | 3s 535ms |
| /alter/attach partition/storage/attach partition on minio and default disks | OK | 7s 835ms |
| /alter/attach partition/storage/attach partition on tiered and default storages | OK | 7s 567ms |
| /alter/attach partition/storage/attach partition detached on different types of disks | OK | 3s 845ms |
| /alter/attach partition/corrupted partitions | OK | 2m 54s |
| /alter/attach partition/corrupted partitions/attach partition from with corrupted parts | OK | 2m 21s |
| /alter/attach partition/rbac | OK | 8m 14s |
| /alter/attach partition/rbac/check attach partition from with privileges | OK | 7m 36s |
| /alter/attach partition/corrupted partitions/attach partition detached with corrupted parts | OK | 18s 901ms |
| /alter/attach partition/corrupted partitions/attach corrupted part | OK | 14s 370ms |
| /alter/attach partition/conditions | OK | 1m 14s |
| /alter/attach partition/conditions/structure | OK | 749ms |
| /alter/attach partition/conditions/order by | OK | 50s 592ms |
| /alter/attach partition/conditions/primary key | OK | 16s 246ms |
| /alter/attach partition/conditions/storage policy | OK | 4s 16ms |
| /alter/attach partition/conditions/indices | OK | 1s 429ms |
| /alter/attach partition/conditions/projections | OK | 1s 479ms |
| /alter/attach partition/table names | OK | 16m 23s |
| /alter/attach partition/table names/check table names with id | OK | 8m 12s |
| /alter/attach partition/rbac/check attach partition with privileges | OK | 18s 839ms |
| /alter/attach partition/rbac/check attach part with privileges | OK | 18s 761ms |
| /alter/attach partition/partition expression | OK | 34s 990ms |
| /alter/attach partition/partition expression/check partition expression with id | OK | 16s 705ms |
| /alter/attach partition/partition expression/check partition expression without id | OK | 17s 664ms |
| /alter/attach partition/temporary table | OK | 9m 54s |
| /alter/attach partition/temporary table/attach partition detached with temporary tables | OK | 4s 520ms |
| /alter/attach partition/temporary table/attach partition from with temporary tables | OK | 9m 50s |
| /alter/attach partition/table names/check table names without id | OK | 8m 10s |
Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232