Logminer hangs where log switch happens

[sriramcms]

Hi Erdem:

In my tests i notice this frequently. I start the kafka connect logminer , it keep capturing the inserts. After some time i shutoff of the table insert simulator. If if leave it for a long period without any traffic -- and then start sending inserts again I noticed that
i dont get any more notifications on the kafka-connect-logminer

I checked that the network socket is still in established state,

I also noticed everytime this happens the the v$log entry for the SCN "v$log where ? between FIRST_CHANGE# and NEXT_CHANGE#" is now no more CURRENT and is archived.

I dont know what might be happening but some log getting switched from online to archived may be causing it.

To fix it , I have to kill and restart the process and then it catches up. Any thoughts on this behavior ?

Thanks

Sriram C

[zhaoxiangyublzcat]

What is the oracle version you have the problem with?

[yascov]

Hi Erdem:

In my tests i notice this frequently. I start the kafka connect logminer , it keep capturing the inserts. After some time i shutoff of the table insert simulator. If if leave it for a long period without any traffic -- and then start sending inserts again I noticed that
i dont get any more notifications on the kafka-connect-logminer

I checked that the network socket is still in established state,

I also noticed everytime this happens the the v$log entry for the SCN "v$log where ? between FIRST_CHANGE# and NEXT_CHANGE#" is now no more CURRENT and is archived.

I dont know what might be happening but some log getting switched from online to archived may be causing it.

To fix it , I have to kill and restart the process and then it catches up. Any thoughts on this behavior ?

Thanks

Sriram C

Hello Sriram,

We are facing the same issue. Did you solve it ?

Best regards
Yascov

[erdemcer]

Hi,
Could you please send your connector log file from start to kill ?
Thanks

[sriramcms]

Yascov:

I did not solve it. For now the only option was to detect and kill the process so that it starts again clean from the previous state.