[ORACLE] - ORA-01013

[Vitor Pereira]

Hi, 

Hope this message finds you well.

Lately, our CDC process has been returning the same error, after a few days of streaming: Error Msg = ORA-01013: user requested cancel of current operation

Is there any way to mitigate this?

Best regards

[Chris Cranford]

Hi Vitor -

In one of the 2.x builds we introduced `database.query.timeout.ms`, which applies a blanket 10 minute timeout on all queries to prevent them from running indefinitely. This was applied to the LogMiner query, and therefore the driver triggers ORA-01013 when the query has exceeded this threshold. To mitigate this you have two options:

    1. Set `database.query.timeout.ms` to a value longer than 10 minutes to maintain a timeout, but one that is more reasonable for your environment.
    2. Set `database.query.timeout.ms` to `0`, to turn off query timeouts globally for Debezium. This will allow any query to run until it finishes or there is a database/connection error.

-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 visit https://groups.google.com/d/msgid/debezium/23c1d6ed-4768-4760-a567-c42b870c64d0n%40googlegroups.com.

[Vitor Pereira]

Hi,

I'll try it.

Thanks for your help.

Best regards