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 19, 2024 17:31 |
Duration | 1h 16m |
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/0a8ac3b092733da37e3e2a0079c486938a36790d/package_release/clickhouse-common-static_23.3.19.34.altinityfips_amd64.deb |
version | 23.3.19.34.altinityfips |
user.name | Enmk |
repository | https://github.com/Altinity/clickhouse-regression |
commit.hash | 6da94b78dc53cb8965ab56c04a89ebf54ed04cbc |
job.id | 8247806903 |
job.url | https://github.com/Altinity/ClickHouse/actions/runs/8247806903 |
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/0a8ac3b092733da37e3e2a0079c486938a36790d/package_release/clickhouse-common-static_23.3.19.34.altinityfips_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 16m | 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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 16m 39s | 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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 11s | 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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 11s | 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_b1fc0560_e61e_11ee_88c5_0bf5005c6dc9 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_b1fc0560_e61e_11ee_88c5_0bf5005c6dc9 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 11s | 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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_b1fa96da_e61e_11ee_88c5_0bf5005c6dc9 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 213ms 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 16m |
/alter/replace partition | OK | 56m 42s |
/alter/replace partition/partition types | OK | 31s 47ms |
/alter/replace partition/partition types/replace partition with different partition types | OK | 31s 46ms |
/alter/replace partition/rbac | OK | 15m 30s |
/alter/replace partition/rbac/check replace partition with privileges | OK | 15m 30s |
/alter/replace partition/concurrent replace partitions | OK | 4m 44s |
/alter/replace partition/data integrity | OK | 8s 343ms |
/alter/replace partition/data integrity/keep data on a source table | OK | 2s 158ms |
/alter/replace partition/data integrity/non existent partition destination | OK | 2s 112ms |
/alter/replace partition/data integrity/non existent partition source | OK | 2s 436ms |
/alter/replace partition/data integrity/partition changes in system | OK | 1s 634ms |
/alter/replace partition/prohibited actions | OK | 12s 598ms |
/alter/replace partition/prohibited actions/from clause | OK | 5s 703ms |
/alter/replace partition/prohibited actions/from clause/table functions | OK | 837ms |
/alter/replace partition/prohibited actions/from clause/join | OK | 803ms |
/alter/replace partition/prohibited actions/from clause/subquery | OK | 826ms |
/alter/replace partition/prohibited actions/from clause/non mergetree table | OK | 988ms |
/alter/replace partition/prohibited actions/from clause/view | OK | 245ms |
/alter/replace partition/prohibited actions/from clause/materialized view | OK | 253ms |
/alter/replace partition/prohibited actions/from clause/remote | OK | 863ms |
/alter/replace partition/prohibited actions/from clause/remote secure | OK | 883ms |
/alter/replace partition/prohibited actions/conditions | OK | 3s 488ms |
/alter/replace partition/prohibited actions/conditions/storage policy | OK | 877ms |
/alter/replace partition/prohibited actions/conditions/partition by | OK | 856ms |
/alter/replace partition/prohibited actions/conditions/order by | OK | 871ms |
/alter/replace partition/prohibited actions/conditions/structure | OK | 881ms |
/alter/replace partition/prohibited actions/miscellaneous | OK | 3s 405ms |
/alter/replace partition/prohibited actions/miscellaneous/order by partition by | OK | 835ms |
/alter/replace partition/prohibited actions/miscellaneous/into outfile | OK | 872ms |
/alter/replace partition/prohibited actions/miscellaneous/format | OK | 823ms |
/alter/replace partition/prohibited actions/miscellaneous/settings | OK | 873ms |
/alter/replace partition/temporary table | Skip | 674us |
/alter/replace partition/engines | OK | 56s 448ms |
/alter/replace partition/engines/replace partition with different engines | OK | 56s 447ms |
/alter/replace partition/concurrent actions | OK | 54m 53s |
/alter/replace partition/concurrent actions/one replace partition | OK | 48m 28s |
/alter/replace partition/concurrent replace partitions/concurrent replace | OK | 19s 150ms |
/alter/replace partition/concurrent merges and mutations | OK | 8s 33ms |
/alter/replace partition/concurrent merges and mutations/merges on unrelated partition | OK | 5s 818ms |
/alter/replace partition/concurrent merges and mutations/mutations on unrelated partition | XFail | 2s 213ms |
/alter/replace partition/storage | OK | 27s 931ms |
/alter/replace partition/storage/different disks | OK | 850ms |
/alter/replace partition/storage/shards | OK | 986ms |
/alter/replace partition/storage/replicas | OK | 2s 529ms |
/alter/replace partition/storage/replace partition on minio and default disks | OK | 7s 395ms |
/alter/replace partition/storage/replace partition on tiered and default storages | OK | 7s 658ms |
/alter/replace partition/storage/partition moved to another disk | OK | 8s 509ms |
/alter/replace partition/corrupted partitions | OK | 3m 0s |
/alter/replace partition/corrupted partitions/replace partition with corrupted parts | OK | 3m 0s |
/alter/replace partition/clickhouse versions | OK | 42s 406ms |
/alter/replace partition/clickhouse versions/replace partition on table created after update | OK | 8s 477ms |
/alter/replace partition/clickhouse versions/replace partition on table created before update | OK | 7s 983ms |
/alter/replace partition/clickhouse versions/replace partition on updated and reverted version | OK | 13s 362ms |
/alter/replace partition/clickhouse versions/replace partition on updated version | OK | 12s 50ms |
/alter/replace partition/concurrent replace partitions on replicas | OK | 16m 50s |
/alter/replace partition/concurrent replace partitions on replicas/multiple shards with replicas | OK | 5m 42s |
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas | OK | 5m 53s |
/alter/replace partition/concurrent replace partitions on replicas/single shard three replicas secure | OK | 5m 14s |
/alter/replace partition/concurrent actions/replace partition along other actions | OK | 6m 25s |
/alter/attach partition | Fail | 16m 39s |
/alter/attach partition/partition types | OK | 6s 898ms |
/alter/attach partition/partition types/attach part detached with different partition types | OK | 6s 897ms |
/alter/attach partition/partition key | Fail | 2m 11s |
/alter/attach partition/partition key/attach partition from without id | Fail | 2m 11s |
/alter/attach partition/partition key/attach partition from with id | Fail | 2m 11s |
/alter/attach partition/partition key datetime | OK | 2m 40s |
/alter/attach partition/partition key datetime/attach partition from | OK | 2m 40s |
/alter/attach partition/storage | OK | 13s 173ms |
/alter/attach partition/storage/shards | OK | 1s 697ms |
/alter/attach partition/storage/attach partition on minio and default disks | OK | 4s 568ms |
/alter/attach partition/storage/attach partition on tiered and default storages | OK | 4s 449ms |
/alter/attach partition/storage/attach partition detached on different types of disks | OK | 2s 444ms |
/alter/attach partition/corrupted partitions | OK | 3m 36s |
/alter/attach partition/corrupted partitions/attach partition from with corrupted parts | OK | 2m 56s |
/alter/attach partition/rbac | OK | 5m 24s |
/alter/attach partition/rbac/check attach partition from with privileges | OK | 4m 59s |
/alter/attach partition/corrupted partitions/attach partition detached with corrupted parts | OK | 23s 675ms |
/alter/attach partition/corrupted partitions/attach corrupted part | OK | 16s 666ms |
/alter/attach partition/conditions | OK | 46s 716ms |
/alter/attach partition/conditions/structure | OK | 458ms |
/alter/attach partition/conditions/order by | OK | 31s 294ms |
/alter/attach partition/conditions/primary key | OK | 10s 446ms |
/alter/attach partition/conditions/storage policy | OK | 2s 578ms |
/alter/attach partition/conditions/indices | OK | 999ms |
/alter/attach partition/conditions/projections | OK | 937ms |
/alter/attach partition/table names | OK | 6m 17s |
/alter/attach partition/table names/check table names with id | OK | 3m 7s |
/alter/attach partition/rbac/check attach partition with privileges | OK | 12s 304ms |
/alter/attach partition/rbac/check attach part with privileges | OK | 12s 234ms |
/alter/attach partition/partition expression | OK | 21s 455ms |
/alter/attach partition/partition expression/check partition expression with id | OK | 10s 580ms |
/alter/attach partition/partition expression/check partition expression without id | OK | 10s 465ms |
/alter/attach partition/temporary table | OK | 8m 5s |
/alter/attach partition/temporary table/attach partition detached with temporary tables | OK | 3s 957ms |
/alter/attach partition/temporary table/attach partition from with temporary tables | OK | 8m 1s |
/alter/attach partition/table names/check table names without id | OK | 3m 9s |
Generated by TestFlows Open-Source Test Framework v2.0.231215.1221232