sink error schema evolution is disabled

[leesan]

I'm using Kafka connect for database synchronization  from SQL server to MySQL; I'm using version 2.5 of debezium, but I get an error after configuring my sink:Caused by: java.sql.SQLException: Cannot alter table ms_AIS20200525165328_dbo_T_BAS_USEREXPERIENCE

because schema evolution is disabled;I've configured "schema.include.list" in source, but it doesn't seem to work.

[leesan]

When I use version 2.2 I don't get any errors

[Chris Cranford]

Hi,

This error means you have received an event where the schema for the event does not match the target table, in your case in MySQL. If this works on 2.2 but not on 2.5, this could be a bug.  Please enable TRACE logging and please attach the logs of when the event attempts to be processed by the JDBC sink connector.  Most likely we're recognizing a specific data type differently in 2.5 than we did in 2.2 and the connector wants to perform an ALTER TABLE but cannot because you've not explicitly enabled "schema.evolution" as "basic" in the JDBC sink connector configuration.

Thanks,
Chris

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/95cc0fe8-81e5-4c6a-b0d3-41b382be8828n%40googlegroups.com.