Hi <@U04S8PLJWMT> we're running into a CDC sync fa...
# replication-troubleshooting
d
Hi @kapa.ai we're running into a CDC sync failure with the MySQL source connector (v3.51.5) on self-hosted Airbyte (Kubernetes). Error Failed to properly convert data value for 'oss.need_get_consents_08.created_at' of type DATETIME org.apache.kafka.connect.errors.DataException: Invalid value: null used for required field: "created_at", schema type: STRING at org.apache.kafka.connect.data.ConnectSchema.validateValue(ConnectSchema.java:224) ~[connect-api-3.9.0.jar:?] DDL table source required not null CREATE TABLE
need_get_consents_08
(
id
int unsigned NOT NULL AUTO_INCREMENT,
customer_id
int NOT NULL,
enrollment_id
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
state
varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
last_usage_at
datetime NOT NULL,
last_usage_by
varchar(200) NOT NULL,
status
tinyint NOT NULL DEFAULT '0',
created_at
datetime NOT NULL, PRIMARY KEY (
id
), KEY
customer_id
(
customer_id
) ) ENGINE=InnoDB AUTO_INCREMENT=1377621 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci So, How to fix it?
k
Sorry @Du Trần, I'm not enabled for this channel yet. Please contact your workspace admins to help get me set up. 👋