Error connecting to MariaDB (binlog_row_image could not be queried)

[coquej]

Enviroment

• Airbyte version: example is 0.29.0-alpha
• OS Version / Instance: Windows
• Deployment: Docker
• Source Connector and version:MySQL 0.3.8
• Severity: High
• Step where error happened: Setup new connection

Current Behavior

Appears error message: "Could not query the variable binlog_row_image".
It seems to be due to the version of the MariaDB database we want to extract info from, but we cannot update the database as we are not the owners of the DB.
Is there a possibility to change anything in the connector to make it work as we cannot update the version of the DB?

[freesmith]

Had the same issue here weeks ago. Couldn't solve it. Is it really necessary to query the binlog_row_image to perform the extraction? Could the source connector avoid this check?

[coquej]

I see in #7600 this is solved, but after updating the connector this is still happening. Is it possible to avoid the binlog_row_image parameter in any way?

[sherifnada]

@coquej will look into it and come back soon with an answer!

[mkhokh-33]

hi @freesmith , @coquej
Could I ask for more information from your side:

1. which replication method did you choose for a source STANDARD or CDC
2. if possible, pls provide MariaDB version

Thanks

[freesmith]

Hi,

1. Standard replication
2. 5.5.60 is our MariaDB server version
   Thanks!

[coquej]

Hi, my case is exacty the same as @freesmith. Thanks!