Back to pull request #592

Added Integration test to validate mapping of MySQL JSON data types t… #414

Sign in to view logs

Triggered via pull request May 13, 2024 22:47

subkanthi

opened #592

validate_json_support

Status Failure

Total duration 4h 34m 33s

Artifacts 3

pull-request.yml

on: pull_request

build-kafka-lightweight / build

testflows-kafka / testflows-kafka

testflows-lightweight / testflows-lightweight

java-tests-kafka / java-kafka

java-tests-lightweight / java-lightweight

Annotations

28 errors and 12 warnings

MySQLGenerateColumnsTest.testMySQLGeneratedColumns: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/MySQLGenerateColumnsTest.java#L109

Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null

MySQLJsonIT.testMultipleDatabases: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/MySQLJsonIT.java#L132

Code: 60. DB::Exception: Unknown table expression identifier 'employees.audience' in scope SELECT * FROM employees.audience. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32790/system, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@1001647822

ReplicatedRMTClickHouse22TIT.testReplicatedRMTAutoCreate{String}[1]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTClickHouse22TIT.java#L110

Code: 390. DB::Exception: Table `string_types_MEDIUMTEXT_utf8mb4` doesn't exist. (CANNOT_GET_CREATE_TABLE_QUERY) (version 22.3.20.29 (official build)) , server ClickHouseNode [uri=http://localhost:32789/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=client_1}]@257949177

ReplicatedRMTDDLClickHouse22TIT.testReplicatedRMTAutoCreate{String}[1]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTDDLClickHouse22TIT.java#L112

Code: 390. DB::Exception: Table `string_types_MEDIUMTEXT_utf8mb4` doesn't exist. (CANNOT_GET_CREATE_TABLE_QUERY) (version 22.3.20.29 (official build)) , server ClickHouseNode [uri=http://localhost:32777/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=client_1}]@-1678856059

ReplicatedRMTDDLIT.testReplicatedRMTAutoCreate{String}[1]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTDDLIT.java#L58

Container startup failed for image docker.io/bitnami/mysql:latest

ReplicatedRMTIT.testReplicatedRMTAutoCreate{String}[1]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ReplicatedRMTIT.java#L114

Code: 390. DB::Exception: Table `string_types_MEDIUMTEXT_utf8mb4` doesn't exist. (CANNOT_GET_CREATE_TABLE_QUERY) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32782/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=client_1}]@1633543712

BatchRetryOnFailureIT.testBatchRetryOnCHFailure: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/BatchRetryOnFailureIT.java#L58

Container startup failed for image docker.io/bitnami/mysql:latest

DebeziumChangeEventCaptureIT.testIncrementingSequenceNumbers: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/DebeziumChangeEventCaptureIT.java#L102

Container startup failed for image docker.io/bitnami/mysql:latest

DebeziumChangeEventCaptureIT.testDeleteOffsetStorageRow2: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/DebeziumChangeEventCaptureIT.java#L102

Container startup failed for image docker.io/bitnami/mysql:latest

DebeziumStorageViewIT.debeziumStorageView: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/DebeziumStorageViewIT.java#L59

Container startup failed for image docker.io/bitnami/mysql:latest

MultipleUpdatesWSameTimestampIT.testIncrementingSequenceNumberWithUpdates: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/cdc/MultipleUpdatesWSameTimestampIT.java#L70

Container startup failed for image docker.io/bitnami/mysql:latest

AlterTableAddColumnIT.testAddColumn: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AlterTableAddColumnIT.java#L95

Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null

AlterTableChangeColumnIT.testChangeColumn: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AlterTableChangeColumnIT.java#L87

Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null

AlterTableModifyColumnIT.testModifyColumn: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AlterTableModifyColumnIT.java#L81

Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null

AutoCreateTableIT.testAutoCreateTable{String}[1]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AutoCreateTableIT.java#L104

Code: 60. DB::Exception: Unknown table expression identifier 'new-table' in scope SELECT count(*) FROM `new-table`. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32802/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@2072244332

AutoCreateTableIT.testAutoCreateTable{String}[2]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/AutoCreateTableIT.java#L104

Code: 60. DB::Exception: Unknown table expression identifier 'new-table' in scope SELECT count(*) FROM `new-table`. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32802/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@2072244332

CreateTableDataTypesIT.testCreateTable: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/CreateTableDataTypesIT.java#L85

Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null

CreateTableDataTypesTimeZoneIT.testCreateTable: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/CreateTableDataTypesTimeZoneIT.java#L96

Cannot invoke "String.equalsIgnoreCase(String)" because the return value of "java.util.Map.get(Object)" is null

DateTimeWithTimeZoneIT.testCreateTable: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/DateTimeWithTimeZoneIT.java#L94

Code: 60. DB::Exception: Unknown table expression identifier 'temporal_types_DATETIME' in scope SELECT * FROM temporal_types_DATETIME. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32816/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@-678944738

DateTimeWithUserProvidedDifferentTimeZoneIT.testCreateTable: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/DateTimeWithUserProvidedDifferentTimeZoneIT.java#L157

Code: 60. DB::Exception: Unknown table expression identifier 'temporal_types_DATETIME' in scope SELECT * FROM temporal_types_DATETIME. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32818/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@-1071971748

DateTimeWithUserProvidedTimeZoneSchemaOnlyIT.testCreateTable: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/DateTimeWithUserProvidedTimeZoneSchemaOnlyIT.java#L148

java.lang.AssertionError at com.altinity.clickhouse.debezium.embedded.ddl.parser.DateTimeWithUserProvidedTimeZoneSchemaOnlyIT.testCreateTable(DateTimeWithUserProvidedTimeZoneSchemaOnlyIT.java:148)

IsDeletedColumnsIT.testIsDeleted{String}[1]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/IsDeletedColumnsIT.java#L102

Code: 60. DB::Exception: Unknown table expression identifier 'new_table' in scope SELECT * FROM new_table. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32811/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@303622787

IsDeletedColumnsIT.testIsDeleted{String}[2]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/IsDeletedColumnsIT.java#L102

Code: 60. DB::Exception: Unknown table expression identifier 'new_table' in scope SELECT * FROM new_table. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32811/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@303622787

MultipleDatabaseIT.testMultipleDatabases: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/MultipleDatabaseIT.java#L133

Code: 81. DB::Exception: Database test_db does not exist. (UNKNOWN_DATABASE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32821/system, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@-795303537

TableOperationsIT.testTableOperations{String}[1]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/TableOperationsIT.java#L125

java.lang.AssertionError at com.altinity.clickhouse.debezium.embedded.ddl.parser.TableOperationsIT.testTableOperations(TableOperationsIT.java:125)

TableOperationsIT.testTableOperations{String}[2]: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/TableOperationsIT.java#L125

java.lang.AssertionError at com.altinity.clickhouse.debezium.embedded.ddl.parser.TableOperationsIT.testTableOperations(TableOperationsIT.java:125)

TruncateTableIT.testIsDeleted: sink-connector-lightweight/src/test/java/com/altinity/clickhouse/debezium/embedded/ddl/parser/TruncateTableIT.java#L94

Code: 60. DB::Exception: Unknown table expression identifier 'ship_class' in scope SELECT * FROM ship_class. (UNKNOWN_TABLE) (version 24.4.1.2088 (official build)) , server ClickHouseNode [uri=http://localhost:32798/employees, options={custom_settings=allow_experimental_object_type=1,insert_allow_materialized_columns=1,client_name=Client_1}]@-1436668944

testflows-lightweight / testflows-lightweight

Process completed with exit code 1.

build-kafka-lightweight / build

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, actions/setup-java@v2, docker/login-action@v2, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

build-kafka-lightweight / build

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/checkout@v2, actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

build-kafka-lightweight / build

No files were found with the provided path: sink-connector-lightweight/target/clickhouse-debezium-embedded-0.0.8.jar. No artifacts will be uploaded.

java-tests-kafka / java-kafka

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, actions/setup-java@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

java-tests-kafka / java-kafka

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/checkout@v2, actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

testflows-kafka / testflows-kafka

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

testflows-kafka / testflows-kafka

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/checkout@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

java-tests-lightweight / java-lightweight

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, actions/setup-java@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

java-tests-lightweight / java-lightweight

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/checkout@v2, actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

testflows-lightweight / testflows-lightweight

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, actions/upload-artifact@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

testflows-lightweight / testflows-lightweight

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/checkout@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Deprecation notice: v1, v2, and v3 of the artifact actions

The following artifacts were uploaded using a version of actions/upload-artifact that is scheduled for deprecation: "clickhouse-sink-connector-kafka-592-3a9ad720f89ab0b8f5c3b6a2deb157e8fd2e58dd.jar", "testflows-sink-connector-kafka-artefacts", "testflows-sink-connector-lightweight-artefacts". Please update your workflow to use v4 of the artifact actions. Learn more: https://github.blog/changelog/2024-04-16-deprecation-notice-v3-of-the-artifact-actions/

Artifacts

Produced during runtime

Name	Size
clickhouse-sink-connector-kafka-592-3a9ad720f89ab0b8f5c3b6a2deb157e8fd2e58dd.jar Expired	14.3 MB
testflows-sink-connector-kafka-artefacts Expired	317 MB
testflows-sink-connector-lightweight-artefacts Expired	28.9 MB