Skip to content

Use Hikari Connection Pool for handling Clickhouse connections #1039

Use Hikari Connection Pool for handling Clickhouse connections

Use Hikari Connection Pool for handling Clickhouse connections #1039

GitHub Actions / JUnit Test Report failed Feb 4, 2025 in 0s

132 tests run, 86 passed, 11 skipped, 35 failed.

Annotations

Check failure on line 1 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ClickHouseDebeziumEmbeddedMongoIT.java

See this annotation in the file changed.

@github-actions 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: java.lang.IllegalStateException: Container is started, but cannot be accessed by (JDBC URL: jdbc:clickhouse://localhost:32833/default), please check container logs
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))

Check failure on line 97 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.testDecoderBufsPlugin

java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.testDecoderBufsPlugin(ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.java:97)
Raw output
java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.testDecoderBufsPlugin(ClickHouseDebeziumEmbeddedPostgresDecoderBufsDockerIT.java:97)

Check failure on line 101 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ClickHouseDebeziumEmbeddedPostgresPgoutputDockerIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

ClickHouseDebeziumEmbeddedPostgresPgoutputDockerIT.testPgOutputPlugin

java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.ClickHouseDebeziumEmbeddedPostgresPgoutputDockerIT.testPgOutputPlugin(ClickHouseDebeziumEmbeddedPostgresPgoutputDockerIT.java:101)
Raw output
java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.ClickHouseDebeziumEmbeddedPostgresPgoutputDockerIT.testPgOutputPlugin(ClickHouseDebeziumEmbeddedPostgresPgoutputDockerIT.java:101)

Check failure on line 103 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/MySQLGenerateColumnsTest.java

See this annotation in the file changed.

@github-actions 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:103)

Check failure on line 125 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/MySQLJsonIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

MySQLJsonIT.testMultipleDatabases

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.MySQLJsonIT.testMultipleDatabases(MySQLJsonIT.java:125)

Check failure on line 98 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/PostgresInitialDockerIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

PostgresInitialDockerIT.testDecoderBufsPlugin

java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerIT.testDecoderBufsPlugin(PostgresInitialDockerIT.java:98)
Raw output
java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerIT.testDecoderBufsPlugin(PostgresInitialDockerIT.java:98)

Check failure on line 119 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/PostgresInitialDockerWKeeperMapStorageIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

PostgresInitialDockerWKeeperMapStorageIT.testDecoderBufsPlugin

java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerWKeeperMapStorageIT.testDecoderBufsPlugin(PostgresInitialDockerWKeeperMapStorageIT.java:119)
Raw output
java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.PostgresInitialDockerWKeeperMapStorageIT.testDecoderBufsPlugin(PostgresInitialDockerWKeeperMapStorageIT.java:119)

Check failure on line 109 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/PostgresPgoutputMultipleSchemaIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

PostgresPgoutputMultipleSchemaIT.testMultipleSchemaReplication

java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.PostgresPgoutputMultipleSchemaIT.testMultipleSchemaReplication(PostgresPgoutputMultipleSchemaIT.java:109)
Raw output
java.lang.AssertionError
	at com.altinity.clickhouse.debezium.embedded.PostgresPgoutputMultipleSchemaIT.testMultipleSchemaReplication(PostgresPgoutputMultipleSchemaIT.java:109)

Check failure on line 106 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTClickHouse22TIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

ReplicatedRMTClickHouse22TIT.testReplicatedRMTAutoCreate{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.ReplicatedRMTClickHouse22TIT.testReplicatedRMTAutoCreate(ReplicatedRMTClickHouse22TIT.java:106)

Check failure on line 108 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTDDLClickHouse22TIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

ReplicatedRMTDDLClickHouse22TIT.testReplicatedRMTAutoCreate{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.ReplicatedRMTDDLClickHouse22TIT.testReplicatedRMTAutoCreate(ReplicatedRMTDDLClickHouse22TIT.java:108)

Check failure on line 111 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTDDLIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

ReplicatedRMTDDLIT.testReplicatedRMTAutoCreate{String}[1]

Code: 390. DB::Exception: Table `string_types_MEDIUMTEXT_utf8mb4` doesn't exist. (CANNOT_GET_CREATE_TABLE_QUERY) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException: 
Code: 390. DB::Exception: Table `string_types_MEDIUMTEXT_utf8mb4` doesn't exist. (CANNOT_GET_CREATE_TABLE_QUERY) (version 25.1.3.23 (official build))

	at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTDDLIT.testReplicatedRMTAutoCreate(ReplicatedRMTDDLIT.java:111)

Check failure on line 109 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

ReplicatedRMTIT.testReplicatedRMTAutoCreate{String}[1]

Code: 390. DB::Exception: Table `string_types_MEDIUMTEXT_utf8mb4` doesn't exist. (CANNOT_GET_CREATE_TABLE_QUERY) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException: 
Code: 390. DB::Exception: Table `string_types_MEDIUMTEXT_utf8mb4` doesn't exist. (CANNOT_GET_CREATE_TABLE_QUERY) (version 25.1.3.23 (official build))

	at com.altinity.clickhouse.debezium.embedded.ReplicatedRMTIT.testReplicatedRMTAutoCreate(ReplicatedRMTIT.java:109)

Check failure on line 118 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/DatabaseOverrideIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DatabaseOverrideIT.testDatabaseOverride

Code: 81. DB::Exception: Database employees2 does not exist. Maybe you meant employees?. (UNKNOWN_DATABASE) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException: 
Code: 81. DB::Exception: Database employees2 does not exist. Maybe you meant employees?. (UNKNOWN_DATABASE) (version 25.1.3.23 (official build))

	at com.altinity.clickhouse.debezium.embedded.cdc.DatabaseOverrideIT.testDatabaseOverride(DatabaseOverrideIT.java:118)

Check failure on line 100 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/DatabaseOverrideInitialIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DatabaseOverrideInitialIT.testDatabaseOverride

Code: 81. DB::Exception: Database employees2 does not exist. Maybe you meant employees?. (UNKNOWN_DATABASE) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException: 
Code: 81. DB::Exception: Database employees2 does not exist. Maybe you meant employees?. (UNKNOWN_DATABASE) (version 25.1.3.23 (official build))

	at com.altinity.clickhouse.debezium.embedded.cdc.DatabaseOverrideInitialIT.testDatabaseOverride(DatabaseOverrideInitialIT.java:100)

Check failure on line 141 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/DatabaseOverrideRRMTIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DatabaseOverrideRRMTIT.testDatabaseOverride

Code: 60. DB::Exception: Unknown table expression identifier 'employees2.newtable' in scope SELECT col2 FROM employees2.newtable FINAL WHERE col1 = 'a'. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))
Raw output
java.sql.BatchUpdateException: 
Code: 60. DB::Exception: Unknown table expression identifier 'employees2.newtable' in scope SELECT col2 FROM employees2.newtable FINAL WHERE col1 = 'a'. (UNKNOWN_TABLE) (version 25.1.3.23 (official build))

	at com.altinity.clickhouse.debezium.embedded.cdc.DatabaseOverrideRRMTIT.testDatabaseOverride(DatabaseOverrideRRMTIT.java:141)

Check failure on line 147 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/DebeziumChangeEventCaptureIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

DebeziumChangeEventCaptureIT.testIncrementingSequenceNumbers

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.cdc.DebeziumChangeEventCaptureIT.testIncrementingSequenceNumbers(DebeziumChangeEventCaptureIT.java:147)

Check failure on line 125 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/MultipleUpdatesWSameTimestampIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

MultipleUpdatesWSameTimestampIT.testIncrementingSequenceNumberWithUpdates

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.cdc.MultipleUpdatesWSameTimestampIT.testIncrementingSequenceNumberWithUpdates(MultipleUpdatesWSameTimestampIT.java:125)

Check failure on line 109 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/SourceDBColumnMissingIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

SourceDBColumnMissingIT.testColumnMismatch

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.cdc.SourceDBColumnMissingIT.testColumnMismatch(SourceDBColumnMissingIT.java:109)

Check failure on line 97 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AlterTableAddColumnIT.java

See this annotation in the file changed.

@github-actions 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:97)

Check failure on line 83 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AlterTableChangeColumnIT.java

See this annotation in the file changed.

@github-actions 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:83)

Check failure on line 77 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AlterTableModifyColumnIT.java

See this annotation in the file changed.

@github-actions github-actions / JUnit Test Report

AlterTableModifyColumnIT.testModifyColumn

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.AlterTableModifyColumnIT.testModifyColumn(AlterTableModifyColumnIT.java:77)

Check failure on line 95 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AutoCreateTableIT.java

See this annotation in the file changed.

@github-actions 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:95)

Check failure on line 95 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AutoCreateTableIT.java

See this annotation in the file changed.

@github-actions 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:95)

Check failure on line 78 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/CreateTableDataTypesIT.java

See this annotation in the file changed.

@github-actions 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)

Check failure on line 89 in sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/CreateTableDataTypesTimeZoneIT.java

See this annotation in the file changed.

@github-actions 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:89)