Adding Support for Defining Query Connection Timeout in MI CDC Inbound Endpoint

[sajith-madhusanka]

Current Limitation

As per the current version of Debezium supported by WSO2 MI, the database.query.timeout.ms parameter is not supported.

We have recently identified an issue where the WSO2 MI CDC inbound endpoint stops receiving events from the database when the connection between WSO2 MI and the database server is dropped for some time. Due to the absence of a query timeout, the system hangs on the socket read until the MI server is restarted.

Suggested Improvement

We need to update the Debezium library version to 2.7.4.Final in order to support the database.query.timeout.ms configuration.

Version

4.2.0