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:14 |
Duration | 1h 20m |
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_release/clickhouse-common-static_23.3.19.33.altinitystable_amd64.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 | x86_64 |
stress | False |
allow_vfs | False |
local | True |
clickhouse_version | None |
clickhouse_binary_path | https://s3.amazonaws.com/altinity-build-artifacts/23.3/19a57e6f4a8ca8dd7737ac12f3ba472b37ac166c/package_release/clickhouse-common-static_23.3.19.33.altinitystable_amd64.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 1h 20m | 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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 17m 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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 2m 7s | 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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 2m 7s | 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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_f04bf114_d83a_11ee_a9b5_95bd37251531 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 2m 7s | 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_f04ce20e_d83a_11ee_a9b5_95bd37251531 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_f04ce20e_d83a_11ee_a9b5_95bd37251531 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 | Message |
---|---|---|
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partition | XFail 2s 986ms The pr is not done yet: https://github.com/ClickHouse/ClickHouse/pull/54272 | AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/alter/regression.py", line 154, in |
Test Name | Result | Duration |
---|---|---|
/alter | Fail | 1h 20m |
/alter/replace partition | OK | 1h 0m |
/alter/replace partition/partition types | OK | 31s 515ms |
/alter/replace partition/partition types/replace partition with different partition types | OK | 31s 514ms |
/alter/replace partition/rbac | OK | 16m 8s |
/alter/replace partition/rbac/check replace partition with privileges | OK | 16m 8s |
/alter/replace partition/concurrent replace partitions | OK | 5m 12s |
/alter/replace partition/data integrity | OK | 8s 32ms |
/alter/replace partition/data integrity/keep data on a source table | OK | 2s 42ms |
/alter/replace partition/data integrity/non existent partition destination | OK | 1s 736ms |
/alter/replace partition/data integrity/non existent partition source | OK | 1s 966ms |
/alter/replace partition/data integrity/partition changes in system | OK | 2s 284ms |
/alter/replace partition/prohibited actions | OK | 12s 960ms |
/alter/replace partition/prohibited actions/from clause | OK | 5s 803ms |
/alter/replace partition/prohibited actions/from clause/table functions | OK | 794ms |
/alter/replace partition/prohibited actions/from clause/join | OK | 865ms |
/alter/replace partition/prohibited actions/from clause/subquery | OK | 885ms |
/alter/replace partition/prohibited actions/from clause/non mergetree table | OK | 1s 84ms |
/alter/replace partition/prohibited actions/from clause/view | OK | 220ms |
/alter/replace partition/prohibited actions/from clause/materialized view | OK | 211ms |
/alter/replace partition/prohibited actions/from clause/remote | OK | 846ms |
/alter/replace partition/prohibited actions/from clause/remote secure | OK | 893ms |
/alter/replace partition/prohibited actions/conditions | OK | 3s 647ms |
/alter/replace partition/prohibited actions/conditions/storage policy | OK | 917ms |
/alter/replace partition/prohibited actions/conditions/partition by | OK | 898ms |
/alter/replace partition/prohibited actions/conditions/order by | OK | 875ms |
/alter/replace partition/prohibited actions/conditions/structure | OK | 954ms |
/alter/replace partition/prohibited actions/miscellaneous | OK | 3s 507ms |
/alter/replace partition/prohibited actions/miscellaneous/order by partition by | OK | 868ms |
/alter/replace partition/prohibited actions/miscellaneous/into outfile | OK | 901ms |
/alter/replace partition/prohibited actions/miscellaneous/format | OK | 849ms |
/alter/replace partition/prohibited actions/miscellaneous/settings | OK | 886ms |
/alter/replace partition/temporary table | Skip | 714us |
/alter/replace partition/engines | OK | 56s 176ms |
/alter/replace partition/engines/replace partition with different engines | OK | 56s 175ms |
/alter/replace partition/concurrent actions | OK | 58m 22s |
/alter/replace partition/concurrent actions/one replace partition | OK | 51m 42s |
/alter/replace partition/concurrent replace partitions/concurrent replace | OK | 23s 119ms |
/alter/replace partition/concurrent merges and mutations | OK | 8s 682ms |
/alter/replace partition/concurrent merges and mutations/merges on unrelated partition | OK | 5s 693ms |
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partition | XFail | 2s 986ms |
/alter/replace partition/storage | OK | 34s 81ms |
/alter/replace partition/storage/different disks | OK | 854ms |
/alter/replace partition/storage/shards | OK | 911ms |
/alter/replace partition/storage/replicas | OK | 2s 111ms |
/alter/replace partition/storage/replace partition on minio and default disks | OK | 6s 693ms |
/alter/replace partition/storage/replace partition on tiered and default storages | OK | 7s 326ms |
/alter/replace partition/storage/partition moved to another disk | OK | 16s 181ms |
/alter/replace partition/corrupted partitions | OK | 3m 1s |
/alter/replace partition/corrupted partitions/replace partition with corrupted parts | OK | 3m 1s |
/alter/replace partition/clickhouse versions | OK | 42s 883ms |
/alter/replace partition/clickhouse versions/replace partition on table created after update | OK | 8s 163ms |
/alter/replace partition/clickhouse versions/replace partition on table created before update | OK | 8s 294ms |
/alter/replace partition/clickhouse versions/replace partition on updated and reverted version | OK | 12s 859ms |
/alter/replace partition/clickhouse versions/replace partition on updated version | OK | 13s 159ms |
/alter/replace partition/concurrent replace partitions on replicas | OK | 17m 19s |
/alter/replace partition/concurrent replace partitions on replicas/multiple shards with replicas | OK | 5m 37s |
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas | OK | 5m 29s |
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas secure | OK | 6m 12s |
/alter/replace partition/concurrent actions/replace partition along other actions | OK | 6m 39s |
/alter/attach partition | Fail | 17m 19s |
/alter/attach partition/partition types | OK | 7s 84ms |
/alter/attach partition/partition types/attach part detached with different partition types | OK | 7s 83ms |
/alter/attach partition/partition key | Fail | 2m 7s |
/alter/attach partition/partition key/attach partition from without id | Fail | 2m 7s |
/alter/attach partition/partition key/attach partition from with id | Fail | 2m 7s |
/alter/attach partition/partition key datetime | OK | 2m 36s |
/alter/attach partition/partition key datetime/attach partition from | OK | 2m 36s |
/alter/attach partition/storage | OK | 13s 227ms |
/alter/attach partition/storage/shards | OK | 1s 744ms |
/alter/attach partition/storage/attach partition on minio and default disks | OK | 5s 219ms |
/alter/attach partition/storage/attach partition on tiered and default storages | OK | 3s 651ms |
/alter/attach partition/storage/attach partition detached on different types of disks | OK | 2s 606ms |
/alter/attach partition/corrupted partitions | OK | 3m 37s |
/alter/attach partition/corrupted partitions/attach partition from with corrupted parts | OK | 2m 56s |
/alter/attach partition/rbac | OK | 5m 38s |
/alter/attach partition/rbac/check attach partition from with privileges | OK | 5m 13s |
/alter/attach partition/corrupted partitions/attach partition detached with corrupted parts | OK | 23s 877ms |
/alter/attach partition/corrupted partitions/attach corrupted part | OK | 16s 720ms |
/alter/attach partition/conditions | OK | 49s 716ms |
/alter/attach partition/conditions/structure | OK | 500ms |
/alter/attach partition/conditions/order by | OK | 33s 10ms |
/alter/attach partition/conditions/primary key | OK | 11s 231ms |
/alter/attach partition/conditions/storage policy | OK | 2s 831ms |
/alter/attach partition/conditions/indices | OK | 1s 69ms |
/alter/attach partition/conditions/projections | OK | 1s 70ms |
/alter/attach partition/table names | OK | 6m 41s |
/alter/attach partition/table names/check table names with id | OK | 3m 20s |
/alter/attach partition/rbac/check attach partition with privileges | OK | 12s 490ms |
/alter/attach partition/rbac/check attach part with privileges | OK | 13s 61ms |
/alter/attach partition/partition expression | OK | 23s 11ms |
/alter/attach partition/partition expression/check partition expression with id | OK | 11s 201ms |
/alter/attach partition/partition expression/check partition expression without id | OK | 11s 355ms |
/alter/attach partition/temporary table | OK | 8m 33s |
/alter/attach partition/temporary table/attach partition detached with temporary tables | OK | 4s 199ms |
/alter/attach partition/temporary table/attach partition from with temporary tables | OK | 8m 29s |
/alter/attach partition/table names/check table names without id | OK | 3m 19s |
Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232