MariaDB Startup Error - Unknown system variable 'transaction_isolation'

[Joe Williams]

Server version: 10.5.12-MariaDB-log (ProxySQL)

GRANT REPLICATION SLAVE, BINLOG MONITOR ON *.* TO ...

Debezium Server Version: 1.8.1.Final

Getting this error:
2022-06-02 01:46:31,135 INFO  [io.deb.ser.ConnectorLifecycle] (pool-10-thread-1) Connector completed: success = 'false', message = 'Unable to initialize and start connector's task class 'io.debezium.connector.mysql.MySqlConnectorTask' with config: {...}', error = '{}': io.debezium.DebeziumException: Unexpected error while connecting to MySQL and looking at BINLOG_FORMAT mode:
        at io.debezium.connector.mysql.MySqlConnection.isBinlogFormatRow(MySqlConnection.java:396)
        at io.debezium.connector.mysql.MySqlConnectorTask.validateBinlogConfiguration(MySqlConnectorTask.java:256)
        at io.debezium.connector.mysql.MySqlConnectorTask.start(MySqlConnectorTask.java:86)
        at io.debezium.connector.common.BaseSourceTask.start(BaseSourceTask.java:130)
        at io.debezium.embedded.EmbeddedEngine.run(EmbeddedEngine.java:759)
        at io.debezium.embedded.ConvertingEngineBuilder$2.run(ConvertingEngineBuilder.java:188)
        at io.debezium.server.DebeziumServer.lambda$start$1(DebeziumServer.java:147)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLException: Unknown system variable 'transaction_isolation'
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
        at io.debezium.jdbc.JdbcConnection.lambda$patternBasedFactory$1(JdbcConnection.java:237)
        at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:891)
        at io.debezium.connector.mysql.MySqlConnection.connection(MySqlConnection.java:91)
        at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:886)
        at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:639)
        at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:513)
        at io.debezium.connector.mysql.MySqlConnection.isBinlogFormatRow(MySqlConnection.java:391)
        ... 9 more

[Chris Cranford]

Hi Joe -

There have been quite a few changes since 1.8.1.Final.  Could you first try with the latest 1.9.3.Final build and see if the issue persists.  If it continues to be a problem, then could you please raise a Jira at https;//issues.redhat.com/projects/DBZ.

Thanks,
CC

--
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/26176313-fc57-4fec-b671-51a7fd80929cn%40googlegroups.com.