JDBC Source connector on Oracle - Request/query timeout and backoff

Kafka Connect
1

Hi all,

I use a Confluent JDBC Source Connector on an Oracle database. The connector runs in an on-prem Confluent platform.

My connector is configured to poll every 5 seconds.
I observed that if the query last more than 10 seconds, it will be considered as failed and the backoff/retry mechanism will start. So, the next poll will no be 5s later but more or less 20s, then 60s, …

My questions :

  • I don’t have configured any timeout at 10s. Can you explain which parameter is set at 10s as default to timeout the query ?
  • How the backoff mechanism work ? What are the configuration parameters to control it ?

Any help would be appreciate.
Thanks in advance.

Hervé

2

What gets logged on the connect worker when a query is considered failed? AFAIK there isn’t any config param to control query timeout. Statement.setQueryTimeout isn’t called anywhere so it should be the default behavior of unlimited. That’s why I’m wondering if it’s a timeout exception logged, or a different error.

Here is the source connector source code if you’d like to poke around. Start with JdbcSourceTask which calls into one of the *Querier classes where the JDBC client code lives.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.