Use Hikari Connection Pool for handling Clickhouse connections #1052
130 tests run, 91 passed, 11 skipped, 28 failed.
Annotations
github-actions / JUnit Test Report
ClickHouseDebeziumEmbeddedMongoIT.com.altinity.clickhouse.debezium.embedded.ClickHouseDebeziumEmbeddedMongoIT
Container startup failed for image clickhouse/clickhouse-server:latest
Raw output
org.testcontainers.containers.ContainerLaunchException: Container startup failed for image clickhouse/clickhouse-server:latest
Caused by: org.rnorth.ducttape.RetryCountExceededException: Retry limit hit with exception
Caused by: org.testcontainers.containers.ContainerLaunchException: Could not create/start container
Caused by: org.testcontainers.ext.ScriptUtils$UncategorizedScriptException:
Failed to execute database script from resource [CREATE database datatypes;
CREATE database employees;
CREATE database public;
CREATE database project;
CREATE TABLE project.items
(
`price` Int64,
`name` String,
`_id` String,
`uuid` String,
`_sign` Int8,
`_version` UInt64
)
ENGINE = ReplacingMergeTree(_version)
ORDER BY _id;
CREATE TABLE public.protocol_test
(
`id` Int64,
`consultation_id` Int64,
`recomendation` Nullable(String),
`create_date` DateTime64(6),
`_sign` Int8,
`_version` UInt64
)
ENGINE = ReplacingMergeTree(_version)
ORDER BY id;
CREATE DATABASE altinity_sink_connector;
CREATE TABLE altinity_sink_connector.replica_source_info
(
`id` String,
`offset_key` String,
`offset_val` String,
`record_insert_ts` DateTime,
`record_insert_seq` UInt64,
`_version` UInt64 MATERIALIZED toUnixTimestamp64Nano(now64(9))
)
ENGINE = ReplacingMergeTree(_version)
ORDER BY id
SETTINGS index_granularity = 8192;
INSERT INTO altinity_sink_connector.replica_source_info (id,offset_key,offset_val,record_insert_ts,record_insert_seq) VALUES
('1e34dce5-f61c-4fe7-ba83-0a6805a6ea8e','["altinity_sink_connector",{"server":"embeddedconnector"}]','{"transaction_id":null,"ts_sec":1687277615,"file":"mysql-bin.000003","pos":1144937,"gtids":"4ada0375-0f7e-11ee-afd1-0242c0a85003:1-2418","row":1,"server_id":189,"event":2}','2023-06-20 16:13:35',3);
INSERT INTO altinity_sink_connector.replica_source_info (id,offset_key,offset_val,record_insert_ts,record_insert_seq) VALUES
('f15e5c94-4338-409b-b3ed-5044fa20e38e','["company-1",{"server":"embeddedconnector"}]','{"transaction_id":null,"ts_sec":1687278006,"file":"mysql-bin.000003","pos":1156385,"gtids":"30fd82c7-0f86-11ee-9e3b-0242c0a86002:1-2442","row":1,"server_id":266,"event":2}','2023-06-20 16:20:07',3);
-- PostgreSQL
--INSERT INTO altinity_sink_connector.replica_source_info
--(id, offset_key, offset_val, record_insert_ts, record_insert_seq)
--VALUES('03750062-c862-48c5-9f37-451c0d33511b', '["\"engine\"",{"server":"embeddedconnector"}]', '{"transaction_id":null,"lsn_proc":27485360,"messageType":"UPDATE","lsn":27485360,"txId":743,"ts_usec":1687876724804733}', 2023-06-27 14:38:45.000, 1);
--CREATE TABLE employees.rmt_test
--(
-- `id` Int64,
-- `consultation_id` Int64,
-- `recomendation` Nullable(String),
-- `create_date` DateTime64(6),
-- `is_deleted` UInt8,
-- `_version` UInt64
--)
--ENGINE = ReplacingMergeTree(_version, is_deleted)
--ORDER BY id
]
Caused by: org.testcontainers.exception.ConnectionCreationException: Could not obtain JDBC connection
Caused by: java.sql.SQLException: Could not create new connection
Caused by: java.sql.SQLException:
Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name.
If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.
If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.
. (REQUIRED_PASSWORD) (version 25.1.3.23 (official build))
Caused by: java.io.IOException:
Code: 194. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name.
If you use ClickHouse Cloud, the password can be reset at https://clickhouse.cloud/
on the settings page for the corresponding service.
If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml
and deleting this file will reset the password.
See also /etc/clickhouse-server/users.xml on the server where ClickHouse is installed.
. (REQUIRED_PASSWORD) (version 25.1.3.23 (official build))
github-actions / JUnit Test Report
ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.testDecoderBufsPlugin
Code: 60. DB::Exception: Unknown table expression identifier 'tm' in scope SELECT count(*) FROM tm. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException:
Code: 60. DB::Exception: Unknown table expression identifier 'tm' in scope SELECT count(*) FROM tm. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))
at com.altinity.clickhouse.debezium.embedded.ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.testDecoderBufsPlugin(ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.java:100)
github-actions / JUnit Test Report
MySQLGenerateColumnsTest.testMySQLGeneratedColumns
Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
Raw output
java.lang.NullPointerException: Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
at com.altinity.clickhouse.debezium.embedded.MySQLGenerateColumnsTest.testMySQLGeneratedColumns(MySQLGenerateColumnsTest.java:102)
github-actions / JUnit Test Report
MySQLJsonIT.testMultipleDatabases
java.lang.AssertionError
at com.altinity.clickhouse.debezium.embedded.MySQLJsonIT.testMultipleDatabases(MySQLJsonIT.java:129)
Raw output
java.lang.AssertionError
at com.altinity.clickhouse.debezium.embedded.MySQLJsonIT.testMultipleDatabases(MySQLJsonIT.java:129)
github-actions / JUnit Test Report
PostgresInitialDockerIT.testDecoderBufsPlugin
Code: 60. DB::Exception: Unknown table expression identifier 'tm' in scope SELECT count(*) FROM tm. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException:
Code: 60. DB::Exception: Unknown table expression identifier 'tm' in scope SELECT count(*) FROM tm. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))
at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerIT.testDecoderBufsPlugin(PostgresInitialDockerIT.java:104)
github-actions / JUnit Test Report
PostgresInitialDockerWKeeperMapStorageIT.testDecoderBufsPlugin
Container startup failed for image clickhouse/clickhouse-server:22.3
Raw output
org.testcontainers.containers.ContainerLaunchException: Container startup failed for image clickhouse/clickhouse-server:22.3
at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerWKeeperMapStorageIT.startContainers(PostgresInitialDockerWKeeperMapStorageIT.java:58)
Caused by: org.rnorth.ducttape.RetryCountExceededException: Retry limit hit with exception
at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerWKeeperMapStorageIT.startContainers(PostgresInitialDockerWKeeperMapStorageIT.java:58)
Caused by: org.testcontainers.containers.ContainerLaunchException: Could not create/start container
at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerWKeeperMapStorageIT.startContainers(PostgresInitialDockerWKeeperMapStorageIT.java:58)
Caused by: java.lang.IllegalArgumentException: Requested port (32787) is not mapped
at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerWKeeperMapStorageIT.startContainers(PostgresInitialDockerWKeeperMapStorageIT.java:58)
github-actions / JUnit Test Report
ReplicatedRMTClickHouse22TIT.testReplicatedRMTAutoCreate{String}[1]
Container startup failed for image clickhouse/clickhouse-server:22.3
Raw output
org.testcontainers.containers.ContainerLaunchException: Container startup failed for image clickhouse/clickhouse-server:22.3
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTClickHouse22TIT.startContainers(ReplicatedRMTClickHouse22TIT.java:68)
Caused by: org.rnorth.ducttape.RetryCountExceededException: Retry limit hit with exception
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTClickHouse22TIT.startContainers(ReplicatedRMTClickHouse22TIT.java:68)
Caused by: org.testcontainers.containers.ContainerLaunchException: Could not create/start container
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTClickHouse22TIT.startContainers(ReplicatedRMTClickHouse22TIT.java:68)
Caused by: java.lang.IllegalArgumentException: Requested port (32821) is not mapped
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTClickHouse22TIT.startContainers(ReplicatedRMTClickHouse22TIT.java:68)
github-actions / JUnit Test Report
ReplicatedRMTDDLClickHouse22TIT.testReplicatedRMTAutoCreate{String}[1]
Container startup failed for image clickhouse/clickhouse-server:22.3
Raw output
org.testcontainers.containers.ContainerLaunchException: Container startup failed for image clickhouse/clickhouse-server:22.3
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLClickHouse22TIT.startContainers(ReplicatedRMTDDLClickHouse22TIT.java:68)
Caused by: org.rnorth.ducttape.RetryCountExceededException: Retry limit hit with exception
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLClickHouse22TIT.startContainers(ReplicatedRMTDDLClickHouse22TIT.java:68)
Caused by: org.testcontainers.containers.ContainerLaunchException: Could not create/start container
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLClickHouse22TIT.startContainers(ReplicatedRMTDDLClickHouse22TIT.java:68)
Caused by: java.lang.IllegalArgumentException: Requested port (32813) is not mapped
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLClickHouse22TIT.startContainers(ReplicatedRMTDDLClickHouse22TIT.java:68)
github-actions / JUnit Test Report
ReplicatedRMTDDLIT.testReplicatedRMTAutoCreate{String}[1]
Container startup failed for image clickhouse/clickhouse-server:latest
Raw output
org.testcontainers.containers.ContainerLaunchException: Container startup failed for image clickhouse/clickhouse-server:latest
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLIT.startContainers(ReplicatedRMTDDLIT.java:68)
Caused by: org.rnorth.ducttape.RetryCountExceededException: Retry limit hit with exception
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLIT.startContainers(ReplicatedRMTDDLIT.java:68)
Caused by: org.testcontainers.containers.ContainerLaunchException: Could not create/start container
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLIT.startContainers(ReplicatedRMTDDLIT.java:68)
Caused by: java.lang.IllegalArgumentException: Requested port (32771) is not mapped
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLIT.startContainers(ReplicatedRMTDDLIT.java:68)
github-actions / JUnit Test Report
ReplicatedRMTIT.testReplicatedRMTAutoCreate{String}[1]
Container startup failed for image clickhouse/clickhouse-server:latest
Raw output
org.testcontainers.containers.ContainerLaunchException: Container startup failed for image clickhouse/clickhouse-server:latest
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTIT.startContainers(ReplicatedRMTIT.java:68)
Caused by: org.rnorth.ducttape.RetryCountExceededException: Retry limit hit with exception
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTIT.startContainers(ReplicatedRMTIT.java:68)
Caused by: org.testcontainers.containers.ContainerLaunchException: Could not create/start container
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTIT.startContainers(ReplicatedRMTIT.java:68)
Caused by: java.lang.IllegalArgumentException: Requested port (32781) is not mapped
at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTIT.startContainers(ReplicatedRMTIT.java:68)
github-actions / JUnit Test Report
DatabaseOverrideRRMTIT.testDatabaseOverride
Mapped port can only be obtained after the container is started
Raw output
java.lang.IllegalStateException: Mapped port can only be obtained after the container is started
at com.altinity.clickhouse.debezium.embedded.cdc.DatabaseOverrideRRMTIT.testDatabaseOverride(DatabaseOverrideRRMTIT.java:83)
github-actions / JUnit Test Report
AlterTableAddColumnIT.testAddColumn
Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
Raw output
java.lang.NullPointerException: Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.AlterTableAddColumnIT.testAddColumn(AlterTableAddColumnIT.java:94)
github-actions / JUnit Test Report
AlterTableChangeColumnIT.testChangeColumn
Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
Raw output
java.lang.NullPointerException: Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.AlterTableChangeColumnIT.testChangeColumn(AlterTableChangeColumnIT.java:82)
github-actions / JUnit Test Report
AlterTableModifyColumnIT.testModifyColumn
java.lang.AssertionError
at com.altinity.clickhouse.debezium.embedded.ddl.parser.AlterTableModifyColumnIT.testModifyColumn(AlterTableModifyColumnIT.java:76)
Raw output
java.lang.AssertionError
at com.altinity.clickhouse.debezium.embedded.ddl.parser.AlterTableModifyColumnIT.testModifyColumn(AlterTableModifyColumnIT.java:76)
github-actions / JUnit Test Report
AutoCreateTableIT.testAutoCreateTable{String}[1]
Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
Raw output
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.AutoCreateTableIT.testAutoCreateTable(AutoCreateTableIT.java:94)
github-actions / JUnit Test Report
AutoCreateTableIT.testAutoCreateTable{String}[2]
Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
Raw output
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.AutoCreateTableIT.testAutoCreateTable(AutoCreateTableIT.java:94)
github-actions / JUnit Test Report
CreateTableDataTypesIT.testCreateTable
Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
Raw output
java.lang.NullPointerException: Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.CreateTableDataTypesIT.testCreateTable(CreateTableDataTypesIT.java:78)
github-actions / JUnit Test Report
CreateTableDataTypesTimeZoneIT.testCreateTable
Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
Raw output
java.lang.NullPointerException: Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.CreateTableDataTypesTimeZoneIT.testCreateTable(CreateTableDataTypesTimeZoneIT.java:88)
github-actions / JUnit Test Report
DDLIgnoreRegExIT.testDDLIgnoreRegex
expected:<null> but was:<alter table sales analyze partition p2022>
Raw output
java.lang.AssertionError: expected:<null> but was:<alter table sales analyze partition p2022>
at com.altinity.clickhouse.debezium.embedded.ddl.parser.DDLIgnoreRegExIT.testDDLIgnoreRegex(DDLIgnoreRegExIT.java:96)
github-actions / JUnit Test Report
DateTimeWithTimeZoneColumnSchemaOnlyIT.testSchemaOnlyMode
Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
Raw output
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.DateTimeWithTimeZoneColumnSchemaOnlyIT.testSchemaOnlyMode(DateTimeWithTimeZoneColumnSchemaOnlyIT.java:133)
github-actions / JUnit Test Report
DateTimeWithTimeZoneIT.testCreateTable
Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
Raw output
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "this.conn" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.DateTimeWithTimeZoneIT.testCreateTable(DateTimeWithTimeZoneIT.java:90)
github-actions / JUnit Test Report
DateTimeWithTimeZoneSchemaOnlyIT.testCreateTable
Connection is closed
Raw output
java.sql.SQLException: Connection is closed
at com.altinity.clickhouse.debezium.embedded.ddl.parser.DateTimeWithTimeZoneSchemaOnlyIT.testCreateTable(DateTimeWithTimeZoneSchemaOnlyIT.java:119)
github-actions / JUnit Test Report
DateTimeWithUserProvidedDifferentTimeZoneIT.testCreateTable
Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "com.altinity.clickhouse.sink.connector.db.BaseDbWriter.getConnection()" is null
Raw output
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "com.altinity.clickhouse.sink.connector.db.BaseDbWriter.getConnection()" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.DateTimeWithUserProvidedDifferentTimeZoneIT.testCreateTable(DateTimeWithUserProvidedDifferentTimeZoneIT.java:125)
github-actions / JUnit Test Report
DateTimeWithUserProvidedTimeZoneSchemaOnlyIT.testCreateTable
Cannot invoke "java.sql.Connection.close()" because the return value of "com.altinity.clickhouse.sink.connector.db.BaseDbWriter.getConnection()" is null
Raw output
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.close()" because the return value of "com.altinity.clickhouse.sink.connector.db.BaseDbWriter.getConnection()" is null
at com.altinity.clickhouse.debezium.embedded.ddl.parser.DateTimeWithUserProvidedTimeZoneSchemaOnlyIT.testCreateTable(DateTimeWithUserProvidedTimeZoneSchemaOnlyIT.java:97)
github-actions / JUnit Test Report
IsDeletedColumnsIT.testIsDeleted{String}[1]
Code: 60. DB::Exception: Unknown table expression identifier 'new_table' in scope SELECT * FROM new_table. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException:
Code: 60. DB::Exception: Unknown table expression identifier 'new_table' in scope SELECT * FROM new_table. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))
at com.altinity.clickhouse.debezium.embedded.ddl.parser.IsDeletedColumnsIT.testIsDeleted(IsDeletedColumnsIT.java:94)