Debezium kicking consumer group on session timeout

[Mendbayar Alzakhgui]

Hello everybody, I'm struggling some error while syncing table from Postgresql to Oracle, the table has json data on source and gets many data daily and syncing it to oracle giving me errors:

org.apache.kafka.clients.consumer.CommitFailedException: Offset commit cannot be completed since the consumer is not part of an active group for auto partition assignment; it is likely that the consumer was kicked out of the group

and warning is :

consumer poll timeout has expired. This means the time between subsequent calls to poll() was longer than the configured max.poll.interval.ms, which typically implies that the poll loop is spending too much time processing messages. You can address this either by increasing max.poll.interval.ms or by reducing the maximum size of batches returned in poll() with max.poll.records

so i tried to change the setting on sink connector to

max.poll.interval.ms = 600000
session.timeout.ms= 45000
max.poll.records=100

but even thought it's delaying more messages and keep kicking the consumer group but it's going really slowly what should I do next? the dbz version is 2 and the snapshot.mode = 'never'

what should I check? 

[Vladislav P]

Hi.
Have you been able to resolve this issue?  I ran into the same error.

четверг, 6 февраля 2025 г. в 12:16:48 UTC+4, mendbay...@gmail.com: