[2023-05-02 16:26:48,246] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:48,239] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3239. Offset SCN: 316929811760, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811772, txIds=[10001600b1200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:48,239] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:48,212] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811760, 316929811781] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:48,180] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811781 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:48,180] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:45,176] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:45,169] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3169. Offset SCN: 316929811747, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811760, txIds=[1000070090200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:45,169] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:45,144] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811747, 316929811767] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:45,113] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811767 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:45,113] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:42,309] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:42,303] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3302. Offset SCN: 316929811736, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811747, txIds=[1000200097200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:42,302] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:42,277] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811736, 316929811755] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:42,243] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811755 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:42,243] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:39,239] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:39,232] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3231. Offset SCN: 316929811722, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811736, txIds=[10001d008a200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:39,231] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:39,204] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811722, 316929811742] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:39,172] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811742 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:39,172] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:36,368] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:36,361] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3361. Offset SCN: 316929811710, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811722, txIds=[10000500a5200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:36,361] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:36,335] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811710, 316929811731] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:36,304] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811731 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:36,304] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:33,300] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:33,293] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3292. Offset SCN: 316929811696, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811710, txIds=[06001b00fa0b0000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:33,292] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:33,267] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811696, 316929811717] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:33,234] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811717 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:33,234] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:30,430] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:30,423] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3423. Offset SCN: 316929811684, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811696, txIds=[10000e00a7200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:30,423] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:30,398] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811684, 316929811705] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:30,365] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811705 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:30,365] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:27,361] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:27,354] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3354. Offset SCN: 316929811670, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811684, txIds=[08001800600c0000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:27,354] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:27,328] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811670, 316929811691] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:27,292] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811691 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:27,292] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:24,487] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:24,480] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3480. Offset SCN: 316929811657, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811670, txIds=[05001000b70b0000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:24,480] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:24,454] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811657, 316929811679] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:24,423] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811679 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:24,423] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:21,419] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:21,412] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3411. Offset SCN: 316929811643, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811657, txIds=[10000c00a2200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:21,411] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:21,386] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811643, 316929811665] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:21,353] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811665 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:21,353] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:18,549] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:18,543] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3543. Offset SCN: 316929811627, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811643, txIds=[1000130086200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:18,543] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:18,518] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811627, 316929811652] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:18,487] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811652 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:18,487] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:15,484] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:15,477] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3477. Offset SCN: 316929811613, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811627, txIds=[100010007e1f0000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:15,477] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:15,453] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811613, 316929811638] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:15,421] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811638 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:15,421] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:12,617] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:12,610] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3610. Offset SCN: 316929811601, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811613, txIds=[10001a007d200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:12,610] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:12,583] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811601, 316929811622] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:12,551] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811622 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:12,551] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:09,547] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:09,540] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3540. Offset SCN: 316929811588, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811601, txIds=[10001f009d200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:09,540] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:09,515] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811588, 316929811608] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:09,483] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811608 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:09,482] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:06,679] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:06,672] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3672. Offset SCN: 316929811576, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811588, txIds=[10001200b6200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:06,672] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:06,646] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811576, 316929811596] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:06,615] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811596 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:06,614] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:03,611] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:03,605] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3605. Offset SCN: 316929811562, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811576, txIds=[10000a0089200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:03,605] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:03,580] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811562, 316929811583] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:03,548] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811583 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:03,548] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:26:00,744] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:26:00,737] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3737. Offset SCN: 316929811550, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811562, txIds=[07001300ec0b0000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:26:00,737] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:26:00,712] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811550, 316929811571] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:26:00,680] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811571 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:26:00,680] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:57,677] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:57,669] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3669. Offset SCN: 316929811536, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811550, txIds=[10001500a8200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:57,669] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:57,644] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811536, 316929811557] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:57,611] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811557 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:57,611] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:54,807] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:54,799] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3799. Offset SCN: 316929811524, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811536, txIds=[10000000c7200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:54,799] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:54,773] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811524, 316929811545] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:54,741] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811545 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:54,740] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:51,737] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:51,730] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3730. Offset SCN: 316929811510, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811524, txIds=[1000040059200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:51,730] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:51,703] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811510, 316929811531] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:51,670] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811531 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:51,670] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:48,867] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:48,860] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3860. Offset SCN: 316929811497, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811510, txIds=[10000f00b1200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:48,860] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:48,835] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811497, 316929811519] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:48,803] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811519 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:48,803] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:45,800] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:45,792] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3792. Offset SCN: 316929811483, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811497, txIds=[02000900f7090000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:45,792] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:45,767] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811483, 316929811505] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:45,735] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811505 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:45,735] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:42,931] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:42,925] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3925. Offset SCN: 316929811471, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811483, txIds=[10001600b0200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:42,925] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:42,899] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811471, 316929811492] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:42,868] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811492 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:42,868] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:39,865] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:39,857] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3857. Offset SCN: 316929811441, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811471, txIds=[100007008f200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:39,857] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:39,827] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811441, 316929811478] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:39,794] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811478 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:39,794] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:36,990] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:36,983] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3983. Offset SCN: 316929811429, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811441, txIds=[100006005f200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:36,983] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:36,959] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811429, 316929811466] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:36,926] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811466 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:36,926] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:33,923] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:33,916] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 2916. Offset SCN: 316929811414, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811429, txIds=[04000f006a0b0000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:33,916] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:33,890] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811414, 316929811436] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:33,858] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811436 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:33,858] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:31,054] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:31,048] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 4047. Offset SCN: 316929811402, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811414, txIds=[10000500a4200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:31,047] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:31,022] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811402, 316929811423] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:30,990] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811423 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:30,990] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:27,987] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:27,979] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 2979. Offset SCN: 316929811388, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811402, txIds=[10000b0001200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:27,979] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:27,953] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811388, 316929811409] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:27,920] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811409 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:27,920] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:25,116] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:25,108] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3108. Offset SCN: 316929811376, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811388, txIds=[1000140064200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:25,108] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:25,083] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811376, 316929811397] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:25,050] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811397 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:25,050] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:22,046] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:22,039] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3039. Offset SCN: 316929811362, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811376, txIds=[0a0014009a320000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:22,039] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:22,014] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811362, 316929811383] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:21,984] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811383 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:21,983] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:19,180] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:19,169] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3169. Offset SCN: 316929811354, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811362, txIds=[0c000800fb220000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:19,169] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:19,144] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811354, 316929811371] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:19,113] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811371 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:19,113] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:16,110] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:16,103] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 1103. Offset SCN: 316929811321, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811354, txIds=[1000130085200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:16,103] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=13, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=6, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:16,075] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811321, 316929811357] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:16,042] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811357 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:16,042] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:13,238] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:13,231] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3231. Offset SCN: 316929811307, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811321, txIds=[10001f009c200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:13,231] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:13,206] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811307, 316929811330] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:13,173] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811330 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:13,173] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:10,169] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:10,162] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3162. Offset SCN: 316929811293, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811307, txIds=[10001200b5200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:10,162] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:10,137] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811293, 316929811316] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:10,106] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811316 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:10,106] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:07,302] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:07,295] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3295. Offset SCN: 316929811281, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811293, txIds=[10000a0088200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:07,295] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:07,270] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811281, 316929811302] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:07,240] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811302 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:07,240] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:04,237] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:04,230] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3230. Offset SCN: 316929811267, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811281, txIds=[0b001400040f0000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:04,230] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:04,207] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811267, 316929811288] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:04,176] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811288 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:04,176] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:25:01,373] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:25:01,365] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3365. Offset SCN: 316929811255, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811267, txIds=[1000190065200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:25:01,365] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:25:01,340] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811255, 316929811276] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:25:01,308] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811276 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:25:01,308] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:58,305] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:58,298] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3298. Offset SCN: 316929811240, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811255, txIds=[10001500a7200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:58,298] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:58,273] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811240, 316929811262] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:58,241] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811262 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:58,241] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:55,438] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:55,431] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3430. Offset SCN: 316929811228, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811240, txIds=[10000000c6200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:55,431] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:55,406] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811228, 316929811249] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:55,373] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811249 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:55,373] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:52,369] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:52,363] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3363. Offset SCN: 316929811214, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811228, txIds=[1000040058200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:52,363] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:52,338] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811214, 316929811235] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:52,307] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811235 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:52,307] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:49,504] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:49,497] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3497. Offset SCN: 316929811202, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811214, txIds=[040013007f0b0000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:49,497] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:49,472] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811202, 316929811223] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:49,438] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811223 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:49,438] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:46,435] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:46,428] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3428. Offset SCN: 316929811188, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811202, txIds=[10001600af200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:46,428] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:46,403] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811188, 316929811209] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:46,368] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811209 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:46,368] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:43,564] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:43,558] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3558. Offset SCN: 316929811176, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811188, txIds=[100007008e200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:43,558] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:43,531] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811176, 316929811197] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:43,500] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811197 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:43,500] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:40,496] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:40,489] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3489. Offset SCN: 316929811162, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811176, txIds=[1000200095200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:40,489] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:40,464] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811162, 316929811183] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:40,433] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811183 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:40,433] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:37,630] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:37,623] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3623. Offset SCN: 316929811150, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811162, txIds=[10001d0088200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:37,623] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:37,598] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811150, 316929811171] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:37,567] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811171 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:37,567] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:34,737] INFO [src-ase1-dbz22-test21|task-0] 118044 records sent during previous 00:01:26.452, last recorded offset of {server=ASE1} partition is {commit_scn=316929811150:1:10000500a3200000, transaction_id=null, snapshot_scn=316929810527, scn=316929811149} (io.debezium.connector.common.BaseSourceTask:195) [2023-05-02 16:24:34,563] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:34,556] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 2 ms. Lag: 3556. Offset SCN: 316929811149, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811150, txIds=[10000500a3200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:34,556] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=8, stuckCount=0, dmlCount=1, ddlCount=0, insertCount=0, updateCount=1, deleteCount=0, commitCount=3, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:34,527] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811133, 316929811157] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:34,496] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811157 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:34,496] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:31,693] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:31,687] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3687. Offset SCN: 316929811121, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811133, txIds=[040019008e0b0000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:31,687] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:31,663] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811121, 316929811142] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:31,632] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811142 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:31,632] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:28,629] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:28,621] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3621. Offset SCN: 316929811106, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811121, txIds=[1000140063200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:28,621] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:28,596] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811106, 316929811128] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:28,562] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811128 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:28,562] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:25,758] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:25,751] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3751. Offset SCN: 316929811094, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811106, txIds=[04000500960b0000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:25,751] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:25,726] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811094, 316929811115] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:25,694] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811115 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:25,693] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:22,690] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:22,683] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3683. Offset SCN: 316929811080, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811094, txIds=[1000010077200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:22,683] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:22,658] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811080, 316929811101] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:22,627] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811101 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:22,627] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:19,823] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:19,816] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3816. Offset SCN: 316929811064, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811080, txIds=[100011008b200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:19,816] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:19,790] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811064, 316929811089] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:19,753] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811089 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:19,753] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:16,749] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:16,743] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3743. Offset SCN: 316929811049, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811064, txIds=[10001b009d200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:16,743] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:16,718] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811049, 316929811075] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:16,687] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811075 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:16,687] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:13,883] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:13,876] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3875. Offset SCN: 316929811037, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811049, txIds=[10001c00a1200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:13,875] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:13,851] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811037, 316929811059] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:13,819] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811059 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:13,819] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:10,815] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:10,809] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3809. Offset SCN: 316929811023, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811037, txIds=[10001700ab200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:10,809] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:10,784] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811023, 316929811044] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:10,753] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811044 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:10,753] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:07,949] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:07,942] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3942. Offset SCN: 316929811011, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811023, txIds=[10002100c4200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:07,942] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:07,917] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929811011, 316929811032] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:07,886] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811032 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:07,885] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:04,882] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:04,876] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3876. Offset SCN: 316929810997, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929811011, txIds=[1000190064200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:04,876] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:04,850] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810997, 316929811018] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:04,819] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811018 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:04,819] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:24:02,016] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:24:02,009] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 4009. Offset SCN: 316929810985, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810997, txIds=[1000080099200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:24:02,009] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:24:01,984] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810985, 316929811006] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:24:01,951] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929811006 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:24:01,951] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:58,949] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:58,941] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 2941. Offset SCN: 316929810971, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810985, txIds=[02002100e7090000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:58,941] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:58,915] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810971, 316929810992] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:58,883] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810992 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:58,882] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:56,079] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:56,072] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 4072. Offset SCN: 316929810959, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810971, txIds=[1000040057200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:56,072] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:56,046] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810959, 316929810980] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:56,014] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810980 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:56,014] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:53,009] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:53,002] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3002. Offset SCN: 316929810945, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810959, txIds=[10001e009e200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:53,002] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:52,977] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810945, 316929810966] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:52,944] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810966 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:52,944] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:50,141] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:50,134] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3133. Offset SCN: 316929810933, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810945, txIds=[1000020061200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:50,134] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:50,108] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810933, 316929810954] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:50,075] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810954 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:50,075] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:47,072] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:47,064] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3064. Offset SCN: 316929810918, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810933, txIds=[100007008d200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:47,064] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:47,039] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810918, 316929810940] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:47,008] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810940 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:47,008] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:44,204] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:44,197] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3197. Offset SCN: 316929810906, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810918, txIds=[100006005d200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:44,197] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:44,172] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810906, 316929810927] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:44,140] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810927 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:44,139] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:41,136] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:41,129] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3129. Offset SCN: 316929810892, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810906, txIds=[10001d0087200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:41,129] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:41,104] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810892, 316929810913] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:41,072] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810913 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:41,072] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:38,269] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:38,262] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3262. Offset SCN: 316929810880, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810892, txIds=[08000c00790c0000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:38,262] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:38,238] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810880, 316929810901] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:38,203] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810901 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:38,203] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:35,200] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:35,193] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3193. Offset SCN: 316929810866, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810880, txIds=[10000d008a200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:35,193] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:35,169] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810866, 316929810887] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:35,139] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810887 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:35,139] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:32,336] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:32,330] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3330. Offset SCN: 316929810854, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810866, txIds=[10000e00a4200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:32,330] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:32,304] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810854, 316929810875] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:32,274] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810875 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:32,274] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:29,271] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:29,264] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3264. Offset SCN: 316929810842, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810854, txIds=[1000140062200000]}}], Active Transactions: 0, Sleep: 3000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:29,264] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:29,235] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810842, 316929810861] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:29,191] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810861 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:29,191] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 3000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:26,388] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:26,381] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3381. Offset SCN: 316929810830, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810842, txIds=[10000c009f200000]}}], Active Transactions: 0, Sleep: 2800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:26,381] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:26,355] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810830, 316929810849] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:26,322] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810849 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:26,322] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:23,719] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:23,711] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 2711. Offset SCN: 316929810820, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810830, txIds=[1000130083200000]}}], Active Transactions: 0, Sleep: 2600 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:23,711] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:23,686] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810820, 316929810837] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:23,653] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810837 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:23,653] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2600. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:21,250] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:21,243] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 3243. Offset SCN: 316929810808, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810820, txIds=[100011008a200000]}}], Active Transactions: 0, Sleep: 2400 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:21,243] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:21,218] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810808, 316929810825] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:21,185] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810825 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:21,185] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2400. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:18,982] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:18,975] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 2975. Offset SCN: 316929810794, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810808, txIds=[10001b009c200000]}}], Active Transactions: 0, Sleep: 2200 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:18,975] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:18,950] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810794, 316929810815] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:18,918] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810815 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:18,918] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2200. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:16,915] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.53MB (max = 68.28MB), PGA 50.9MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:16,908] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 1908. Offset SCN: 316929810784, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810794, txIds=[10001a007a200000]}}], Active Transactions: 0, Sleep: 2000 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:16,908] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:16,883] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810784, 316929810803] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:16,850] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810803 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:16,850] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 2000. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:15,047] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.78MB (max = 68.28MB), PGA 51.15MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:15,040] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 2040. Offset SCN: 316929810772, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810784, txIds=[10001f009a200000]}}], Active Transactions: 0, Sleep: 1800 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:15,040] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:15,016] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810772, 316929810789] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:14,985] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810789 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:14,985] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 1800. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:13,382] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.78MB (max = 68.28MB), PGA 51.15MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:13,376] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 1375. Offset SCN: 316929810759, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810772, txIds=[0c001500c6220000]}}], Active Transactions: 0, Sleep: 1600 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:13,375] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=7, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=3, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:13,350] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810759, 316929810779] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:13,317] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810779 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:13,317] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 1600. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:11,914] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.78MB (max = 68.28MB), PGA 51.15MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:11,908] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 1908. Offset SCN: 316929810749, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810759, txIds=[10000a0086200000]}}], Active Transactions: 0, Sleep: 1400 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:11,908] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=5, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=2, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:11,883] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810749, 316929810764] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:11,851] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810764 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:11,850] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 1400. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:10,648] DEBUG [src-ase1-dbz22-test21|task-0] Oracle Session UGA 47.78MB (max = 68.28MB), PGA 51.15MB (max = 76.77MB) (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:323) [2023-05-02 16:23:10,640] DEBUG [src-ase1-dbz22-test21|task-0] Processed in 0 ms. Lag: 640. Offset SCN: 316929810527, Offset Commit SCN: CommitScn [redoThreadCommitScns={1=RedoThreadCommitScn{thread=1, commitScn=316929810749, txIds=[10001500a5200000]}}], Active Transactions: 0, Sleep: 1200 (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:209) [2023-05-02 16:23:10,640] DEBUG [src-ase1-dbz22-test21|task-0] Counters{rows=121, stuckCount=0, dmlCount=0, ddlCount=0, insertCount=0, updateCount=0, deleteCount=0, commitCount=60, rollbackCount=0, tableMetadataCount=0}. (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:208) [2023-05-02 16:23:10,589] DEBUG [src-ase1-dbz22-test21|task-0] Fetching results for SCN [316929810527, 316929810753] (io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor:183) [2023-05-02 16:23:10,551] DEBUG [src-ase1-dbz22-test21|task-0] Using current SCN 316929810753 as end SCN. (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:669) [2023-05-02 16:23:10,551] DEBUG [src-ase1-dbz22-test21|task-0] Updating sleep time window. Sleep time 1200. Min sleep time 0. Max sleep time 3000. (io.debezium.connector.oracle.OracleStreamingChangeEventSourceMetrics:475) [2023-05-02 16:23:10,530] DEBUG [src-ase1-dbz22-test21|task-0] Last mined SCN: 316929810527, Log file list to mine: [+DATA/ASEX92A/ONLINELOG/group_2.3889.1131369245] (io.debezium.connector.oracle.logminer.LogMinerHelper:89) [2023-05-02 16:23:10,461] INFO [src-ase1-dbz22-test21|task-0] Group #4: 8589934592 bytes (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:244) [2023-05-02 16:23:10,461] INFO [src-ase1-dbz22-test21|task-0] Group #3: 8589934592 bytes (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:244) [2023-05-02 16:23:10,461] INFO [src-ase1-dbz22-test21|task-0] Group #2: 8589934592 bytes (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:244) [2023-05-02 16:23:10,461] INFO [src-ase1-dbz22-test21|task-0] Group #1: 8589934592 bytes (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:244) [2023-05-02 16:23:10,461] INFO [src-ase1-dbz22-test21|task-0] Redo Log Group Sizes: (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:237) [2023-05-02 16:23:10,427] INFO [src-ase1-dbz22-test21|task-0] Starting streaming (io.debezium.pipeline.ChangeEventSourceCoordinator:173) [2023-05-02 16:23:10,427] INFO [src-ase1-dbz22-test21|task-0] Connected metrics set to 'true' (io.debezium.pipeline.ChangeEventSourceCoordinator:240) [2023-05-02 16:23:10,427] INFO [src-ase1-dbz22-test21|task-0] Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=316929810527, commit_scn=[]]] (io.debezium.pipeline.ChangeEventSourceCoordinator:156) [2023-05-02 16:23:10,427] INFO [src-ase1-dbz22-test21|task-0] Snapshot completed (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource:92) [2023-05-02 16:23:10,427] INFO [src-ase1-dbz22-test21|task-0] Snapshot - Final stage (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource:88) [2023-05-02 16:23:10,426] INFO [src-ase1-dbz22-test21|task-0] Connection gracefully closed (io.debezium.jdbc.JdbcConnection:947) [2023-05-02 16:23:10,424] INFO [src-ase1-dbz22-test21|task-0] Finished exporting 117510 records for table 'ASEX92A.ASEDBUSR.ABRDVRS' (1 of 2 tables); total duration '00:00:02.137' (io.debezium.relational.RelationalSnapshotChangeEventSource:559) [2023-05-02 16:23:08,428] INFO [src-ase1-dbz22-test21|task-0] [Producer clientId=connector-producer-src-ase1-dbz22-test21-0] Resetting the last seen epoch of partition ASE1.ASEDBUSR.ABRDVRS-0 to 12 since the associated topicId changed from null to SO6nK_N7ScSyetx4eUhHiw (org.apache.kafka.clients.Metadata:402) [2023-05-02 16:23:08,416] INFO [src-ase1-dbz22-test21|task-0] [Producer clientId=connector-producer-src-ase1-dbz22-test21-0] Resetting the last seen epoch of partition ASE1.ASEDBUSR.ABRDVRSUNT-0 to 12 since the associated topicId changed from null to kzGrkmutQgS41gjcW7H36g (org.apache.kafka.clients.Metadata:402) [2023-05-02 16:23:08,313] INFO [src-ase1-dbz22-test21|task-0] [Producer clientId=connector-producer-src-ase1-dbz22-test21-0] Resetting the last seen epoch of partition ASE1-0 to 34 since the associated topicId changed from null to RTfiev2kQhqmRj_E1HgjzQ (org.apache.kafka.clients.Metadata:402) [2023-05-02 16:23:08,299] INFO [src-ase1-dbz22-test21|task-0] Finished exporting 532 records for table 'ASEX92A.ASEDBUSR.ABRDVRSUNT' (2 of 2 tables); total duration '00:00:00.012' (io.debezium.relational.RelationalSnapshotChangeEventSource:559) [2023-05-02 16:23:08,287] INFO [src-ase1-dbz22-test21|task-0] Exporting data from table 'ASEX92A.ASEDBUSR.ABRDVRSUNT' (2 of 2 tables) (io.debezium.relational.RelationalSnapshotChangeEventSource:513) [2023-05-02 16:23:08,287] INFO [src-ase1-dbz22-test21|task-0] Exporting data from table 'ASEX92A.ASEDBUSR.ABRDVRS' (1 of 2 tables) (io.debezium.relational.RelationalSnapshotChangeEventSource:513) [2023-05-02 16:23:08,287] INFO [src-ase1-dbz22-test21|task-0] For table 'ASEX92A.ASEDBUSR.ABRDVRSUNT' using select statement: 'SELECT * FROM ASEDBUSR.ABRDVRSUNT ORDER BY CREATED ASC, PKEY ASC' (io.debezium.relational.RelationalSnapshotChangeEventSource:399) [2023-05-02 16:23:08,287] INFO [src-ase1-dbz22-test21|task-0] For table 'ASEX92A.ASEDBUSR.ABRDVRS' using select statement: 'SELECT * FROM ASEDBUSR.ABRDVRS ORDER BY CREATED ASC, PKEY ASC' (io.debezium.relational.RelationalSnapshotChangeEventSource:399) [2023-05-02 16:23:08,286] INFO [src-ase1-dbz22-test21|task-0] Creating snapshot worker pool with 2 worker thread(s) (io.debezium.relational.RelationalSnapshotChangeEventSource:390) [2023-05-02 16:23:08,286] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 7 - Snapshotting data (io.debezium.relational.RelationalSnapshotChangeEventSource:156) [2023-05-02 16:23:08,285] INFO [src-ase1-dbz22-test21|task-0] 1 records sent during previous 00:00:17.318, last recorded offset of {server=ASE1} partition is {snapshot_scn=316929810527, snapshot=true, scn=316929810527, snapshot_completed=false} (io.debezium.connector.common.BaseSourceTask:195) [2023-05-02 16:23:08,282] DEBUG [src-ase1-dbz22-test21|task-0] Recorded DDL statements for database 'ASEX92A': CREATE TABLE "ASEDBUSR"."ABRDVRSUNT" ( "PKEY" NUMBER(12,0) NOT NULL ENABLE, "BOID" VARCHAR2(40 CHAR) NOT NULL ENABLE, "METABO" NUMBER(12,0) NOT NULL ENABLE, "LASTUPDATE" TIMESTAMP (9) NOT NULL ENABLE, "PROCESSID" VARCHAR2(40 CHAR) NOT NULL ENABLE, "ROWCOMMENT" VARCHAR2(15 CHAR), "CREATED" TIMESTAMP (9) NOT NULL ENABLE, "CREATEDUSER" VARCHAR2(40 CHAR) NOT NULL ENABLE, "REPLACED" TIMESTAMP (9) NOT NULL ENABLE, "REPLACEDUSER" VARCHAR2(40 CHAR), "ARCHIVETAG" VARCHAR2(40 CHAR), "MDBID" VARCHAR2(255 CHAR), "ITSABRDVRS" VARCHAR2(40 CHAR) NOT NULL ENABLE, "UNTERBRUCHVON" DATE NOT NULL ENABLE, "UNTERBRUCHBIS" DATE NOT NULL ENABLE, "BEMERKUNG" VARCHAR2(500 CHAR), "UNTERBRUCHID" VARCHAR2(40 CHAR), "LASTUPDATEBEID" RAW(16), CONSTRAINT "PK500490" PRIMARY KEY ("PKEY") USING INDEX ENABLE NOVALIDATE, SUPPLEMENTAL LOG DATA (ALL) COLUMNS ) ; (io.debezium.connector.oracle.OracleDatabaseSchema:106) [2023-05-02 16:23:08,282] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'LASTUPDATEBEID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column LASTUPDATEBEID of type -3 named RAW with constraints (16,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'UNTERBRUCHID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column UNTERBRUCHID of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'BEMERKUNG' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column BEMERKUNG of type 12 named VARCHAR2 with constraints (500,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'UNTERBRUCHBIS' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column UNTERBRUCHBIS of type 93 named DATE with constraints (-1,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'UNTERBRUCHVON' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column UNTERBRUCHVON of type 93 named DATE with constraints (-1,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ITSABRDVRS' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ITSABRDVRS of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'MDBID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column MDBID of type 12 named VARCHAR2 with constraints (255,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ARCHIVETAG' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ARCHIVETAG of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'REPLACEDUSER' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column REPLACEDUSER of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'REPLACED' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column REPLACED of type 93 named TIMESTAMP(9) with constraints (9,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'CREATEDUSER' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column CREATEDUSER of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'CREATED' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column CREATED of type 93 named TIMESTAMP(9) with constraints (9,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ROWCOMMENT' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ROWCOMMENT of type 12 named VARCHAR2 with constraints (15,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'PROCESSID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column PROCESSID of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'LASTUPDATE' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column LASTUPDATE of type 93 named TIMESTAMP(9) with constraints (9,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column METABO of type 2 named NUMBER with constraints (12,Optional[0]) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'BOID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column BOID of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column PKEY of type 2 named NUMBER with constraints (12,Optional[0]) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'BOID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,281] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column BOID of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,280] DEBUG [src-ase1-dbz22-test21|task-0] Applying schema change event SchemaChangeEvent [database=ASEX92A, schema=ASEDBUSR, ddl= CREATE TABLE "ASEDBUSR"."ABRDVRSUNT" ( "PKEY" NUMBER(12,0) NOT NULL ENABLE, "BOID" VARCHAR2(40 CHAR) NOT NULL ENABLE, "METABO" NUMBER(12,0) NOT NULL ENABLE, "LASTUPDATE" TIMESTAMP (9) NOT NULL ENABLE, "PROCESSID" VARCHAR2(40 CHAR) NOT NULL ENABLE, "ROWCOMMENT" VARCHAR2(15 CHAR), "CREATED" TIMESTAMP (9) NOT NULL ENABLE, "CREATEDUSER" VARCHAR2(40 CHAR) NOT NULL ENABLE, "REPLACED" TIMESTAMP (9) NOT NULL ENABLE, "REPLACEDUSER" VARCHAR2(40 CHAR), "ARCHIVETAG" VARCHAR2(40 CHAR), "MDBID" VARCHAR2(255 CHAR), "ITSABRDVRS" VARCHAR2(40 CHAR) NOT NULL ENABLE, "UNTERBRUCHVON" DATE NOT NULL ENABLE, "UNTERBRUCHBIS" DATE NOT NULL ENABLE, "BEMERKUNG" VARCHAR2(500 CHAR), "UNTERBRUCHID" VARCHAR2(40 CHAR), "LASTUPDATEBEID" RAW(16), CONSTRAINT "PK500490" PRIMARY KEY ("PKEY") USING INDEX ENABLE NOVALIDATE, SUPPLEMENTAL LOG DATA (ALL) COLUMNS ) ;, tables=[columns: { PKEY NUMBER(12, 0) NOT NULL BOID VARCHAR2(40) NOT NULL METABO NUMBER(12, 0) NOT NULL LASTUPDATE TIMESTAMP(9)(9) NOT NULL PROCESSID VARCHAR2(40) NOT NULL ROWCOMMENT VARCHAR2(15) DEFAULT VALUE NULL CREATED TIMESTAMP(9)(9) NOT NULL CREATEDUSER VARCHAR2(40) NOT NULL REPLACED TIMESTAMP(9)(9) NOT NULL REPLACEDUSER VARCHAR2(40) DEFAULT VALUE NULL ARCHIVETAG VARCHAR2(40) DEFAULT VALUE NULL MDBID VARCHAR2(255) DEFAULT VALUE NULL ITSABRDVRS VARCHAR2(40) NOT NULL UNTERBRUCHVON DATE NOT NULL UNTERBRUCHBIS DATE NOT NULL BEMERKUNG VARCHAR2(500) DEFAULT VALUE NULL UNTERBRUCHID VARCHAR2(40) DEFAULT VALUE NULL LASTUPDATEBEID RAW(16) DEFAULT VALUE NULL } primary key: [PKEY] default charset: null comment: null attributes: { } ], type=CREATE, ts_ms=1683037388280] (io.debezium.connector.oracle.OracleDatabaseSchema:88) [2023-05-02 16:23:08,236] INFO [src-ase1-dbz22-test21|task-0] Capturing structure of table ASEX92A.ASEDBUSR.ABRDVRSUNT (io.debezium.relational.RelationalSnapshotChangeEventSource:344) [2023-05-02 16:23:08,236] INFO [src-ase1-dbz22-test21|task-0] Already applied 1 database changes (io.debezium.relational.history.SchemaHistoryMetrics:140) [2023-05-02 16:23:08,207] INFO [src-ase1-dbz22-test21|task-0] [Producer clientId=ASE1-schemahistory] Resetting the last seen epoch of partition ase.schema-changes.asedbusr-0 to 12 since the associated topicId changed from null to 0qTX4LlrTsKgaAVsIenDIA (org.apache.kafka.clients.Metadata:402) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Recorded DDL statements for database 'ASEX92A': CREATE TABLE "ASEDBUSR"."ABRDVRS" ( "PKEY" NUMBER(12,0) CONSTRAINT "SYS_C0093435" NOT NULL ENABLE, "BOID" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093436" NOT NULL ENABLE, "METABO" NUMBER(12,0) CONSTRAINT "SYS_C0093437" NOT NULL ENABLE, "LASTUPDATE" TIMESTAMP (9) CONSTRAINT "SYS_C0093438" NOT NULL ENABLE, "PROCESSID" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093439" NOT NULL ENABLE, "ROWCOMMENT" VARCHAR2(15 CHAR), "CREATED" TIMESTAMP (9) CONSTRAINT "SYS_C0093440" NOT NULL ENABLE, "CREATEDUSER" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093442" NOT NULL ENABLE, "REPLACED" TIMESTAMP (9) CONSTRAINT "SYS_C0093443" NOT NULL ENABLE, "REPLACEDUSER" VARCHAR2(40 CHAR), "GUELTAB" DATE CONSTRAINT "SYS_C0093444" NOT NULL ENABLE, "GUELTBIS" DATE CONSTRAINT "SYS_C0093445" NOT NULL ENABLE, "ITSPARTKLKTV" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093446" NOT NULL ENABLE, "ITSKVTGANYM" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093447" NOT NULL ENABLE, "LOHNBIS" DATE CONSTRAINT "SYS_C0093448" NOT NULL ENABLE, "PRAEMIEBEZAHLT" NUMBER(11,2) CONSTRAINT "SYS_C0093449" NOT NULL ENABLE, "ABREDEGRUND" VARCHAR2(40 CHAR), "ISGUELTBISUEBERST" NUMBER(12,0) NOT NULL ENABLE, "ARCHIVETAG" VARCHAR2(40 CHAR), "ABREDEID" VARCHAR2(22 CHAR), "ITSABRDVRSDEF" VARCHAR2(40 CHAR), "MDBID" VARCHAR2(255 CHAR), "LASTUPDATEBEID" RAW(16), SUPPLEMENTAL LOG DATA (ALL) COLUMNS ) PARTITION BY LIST ("REPLACED") (PARTITION "P_CURR" VALUES (TIMESTAMP' 3000-01-01 00:00:00') , PARTITION "P_ARCH" VALUES (DEFAULT) ) ENABLE ROW MOVEMENT ; CREATE UNIQUE INDEX "ASEDBUSR"."PK1208" ON "ASEDBUSR"."ABRDVRS" ("PKEY") ; ALTER TABLE "ASEDBUSR"."ABRDVRS" ADD CONSTRAINT "PK1208" PRIMARY KEY ("PKEY") USING INDEX "ASEDBUSR"."PK1208" ENABLE NOVALIDATE; (io.debezium.connector.oracle.OracleDatabaseSchema:106) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'LASTUPDATEBEID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column LASTUPDATEBEID of type -3 named RAW with constraints (16,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'MDBID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column MDBID of type 12 named VARCHAR2 with constraints (255,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ITSABRDVRSDEF' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ITSABRDVRSDEF of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ABREDEID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ABREDEID of type 12 named VARCHAR2 with constraints (22,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ARCHIVETAG' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ARCHIVETAG of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ISGUELTBISUEBERST of type 2 named NUMBER with constraints (12,Optional[0]) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ABREDEGRUND' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ABREDEGRUND of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column PRAEMIEBEZAHLT of type 2 named NUMBER with constraints (11,Optional[2]) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'LOHNBIS' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column LOHNBIS of type 93 named DATE with constraints (-1,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ITSKVTGANYM' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ITSKVTGANYM of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ITSPARTKLKTV' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ITSPARTKLKTV of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'GUELTBIS' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column GUELTBIS of type 93 named DATE with constraints (-1,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'GUELTAB' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column GUELTAB of type 93 named DATE with constraints (-1,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'REPLACEDUSER' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column REPLACEDUSER of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,190] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'REPLACED' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column REPLACED of type 93 named TIMESTAMP(9) with constraints (9,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'CREATEDUSER' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column CREATEDUSER of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'CREATED' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column CREATED of type 93 named TIMESTAMP(9) with constraints (9,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'ROWCOMMENT' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column ROWCOMMENT of type 12 named VARCHAR2 with constraints (15,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Applying schema change event SchemaChangeEvent [database=ASEX92A, schema=ASEDBUSR, ddl= CREATE TABLE "ASEDBUSR"."ABRDVRS" ( "PKEY" NUMBER(12,0) CONSTRAINT "SYS_C0093435" NOT NULL ENABLE, "BOID" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093436" NOT NULL ENABLE, "METABO" NUMBER(12,0) CONSTRAINT "SYS_C0093437" NOT NULL ENABLE, "LASTUPDATE" TIMESTAMP (9) CONSTRAINT "SYS_C0093438" NOT NULL ENABLE, "PROCESSID" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093439" NOT NULL ENABLE, "ROWCOMMENT" VARCHAR2(15 CHAR), "CREATED" TIMESTAMP (9) CONSTRAINT "SYS_C0093440" NOT NULL ENABLE, "CREATEDUSER" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093442" NOT NULL ENABLE, "REPLACED" TIMESTAMP (9) CONSTRAINT "SYS_C0093443" NOT NULL ENABLE, "REPLACEDUSER" VARCHAR2(40 CHAR), "GUELTAB" DATE CONSTRAINT "SYS_C0093444" NOT NULL ENABLE, "GUELTBIS" DATE CONSTRAINT "SYS_C0093445" NOT NULL ENABLE, "ITSPARTKLKTV" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093446" NOT NULL ENABLE, "ITSKVTGANYM" VARCHAR2(40 CHAR) CONSTRAINT "SYS_C0093447" NOT NULL ENABLE, "LOHNBIS" DATE CONSTRAINT "SYS_C0093448" NOT NULL ENABLE, "PRAEMIEBEZAHLT" NUMBER(11,2) CONSTRAINT "SYS_C0093449" NOT NULL ENABLE, "ABREDEGRUND" VARCHAR2(40 CHAR), "ISGUELTBISUEBERST" NUMBER(12,0) NOT NULL ENABLE, "ARCHIVETAG" VARCHAR2(40 CHAR), "ABREDEID" VARCHAR2(22 CHAR), "ITSABRDVRSDEF" VARCHAR2(40 CHAR), "MDBID" VARCHAR2(255 CHAR), "LASTUPDATEBEID" RAW(16), SUPPLEMENTAL LOG DATA (ALL) COLUMNS ) PARTITION BY LIST ("REPLACED") (PARTITION "P_CURR" VALUES (TIMESTAMP' 3000-01-01 00:00:00') , PARTITION "P_ARCH" VALUES (DEFAULT) ) ENABLE ROW MOVEMENT ; CREATE UNIQUE INDEX "ASEDBUSR"."PK1208" ON "ASEDBUSR"."ABRDVRS" ("PKEY") ; ALTER TABLE "ASEDBUSR"."ABRDVRS" ADD CONSTRAINT "PK1208" PRIMARY KEY ("PKEY") USING INDEX "ASEDBUSR"."PK1208" ENABLE NOVALIDATE;, tables=[columns: { PKEY NUMBER(12, 0) NOT NULL BOID VARCHAR2(40) NOT NULL METABO NUMBER(12, 0) NOT NULL LASTUPDATE TIMESTAMP(9)(9) NOT NULL PROCESSID VARCHAR2(40) NOT NULL ROWCOMMENT VARCHAR2(15) DEFAULT VALUE NULL CREATED TIMESTAMP(9)(9) NOT NULL CREATEDUSER VARCHAR2(40) NOT NULL REPLACED TIMESTAMP(9)(9) NOT NULL REPLACEDUSER VARCHAR2(40) DEFAULT VALUE NULL GUELTAB DATE NOT NULL GUELTBIS DATE NOT NULL ITSPARTKLKTV VARCHAR2(40) NOT NULL ITSKVTGANYM VARCHAR2(40) NOT NULL LOHNBIS DATE NOT NULL PRAEMIEBEZAHLT NUMBER(11, 2) NOT NULL ABREDEGRUND VARCHAR2(40) DEFAULT VALUE NULL ISGUELTBISUEBERST NUMBER(12, 0) NOT NULL ARCHIVETAG VARCHAR2(40) DEFAULT VALUE NULL ABREDEID VARCHAR2(22) DEFAULT VALUE NULL ITSABRDVRSDEF VARCHAR2(40) DEFAULT VALUE NULL MDBID VARCHAR2(255) DEFAULT VALUE NULL LASTUPDATEBEID RAW(16) DEFAULT VALUE NULL } primary key: [PKEY] default charset: null comment: null attributes: { } ], type=CREATE, ts_ms=1683037388189] (io.debezium.connector.oracle.OracleDatabaseSchema:88) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column BOID of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'BOID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column PKEY of type 2 named NUMBER with constraints (12,Optional[0]) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column BOID of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'BOID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column METABO of type 2 named NUMBER with constraints (12,Optional[0]) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column LASTUPDATE of type 93 named TIMESTAMP(9) with constraints (9,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'LASTUPDATE' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] Building schema for column PROCESSID of type 12 named VARCHAR2 with constraints (40,Optional.empty) (io.debezium.connector.oracle.OracleValueConverters:136) [2023-05-02 16:23:08,189] DEBUG [src-ase1-dbz22-test21|task-0] JdbcValueConverters returned 'org.apache.kafka.connect.data.SchemaBuilder' for column 'PROCESSID' (io.debezium.connector.oracle.OracleValueConverters:165) [2023-05-02 16:23:07,980] INFO [src-ase1-dbz22-test21|task-0] Capturing structure of table ASEX92A.ASEDBUSR.ABRDVRS (io.debezium.relational.RelationalSnapshotChangeEventSource:344) [2023-05-02 16:23:07,980] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 6 - Persisting schema history (io.debezium.relational.RelationalSnapshotChangeEventSource:144) [2023-05-02 16:23:07,980] INFO [src-ase1-dbz22-test21|task-0] Created connection pool with 2 threads (io.debezium.relational.RelationalSnapshotChangeEventSource:213) [2023-05-02 16:23:07,980] INFO [src-ase1-dbz22-test21|task-0] Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.16.0.0.0 (io.debezium.connector.oracle.OracleConnection:83) [2023-05-02 16:23:07,933] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 5.a - Creating connection pool (io.debezium.relational.RelationalSnapshotChangeEventSource:139) [2023-05-02 16:22:51,782] INFO [src-ase1-dbz22-test21|task-0] Only captured tables schema should be captured, capturing: [ASEX92A.ASEDBUSR.ABRDVRS, ASEX92A.ASEDBUSR.ABRDVRSUNT] (io.debezium.connector.oracle.OracleSnapshotChangeEventSource:160) [2023-05-02 16:22:51,782] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 5 - Reading structure of captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource:135) [2023-05-02 16:22:51,782] INFO [src-ase1-dbz22-test21|task-0] Connection gracefully closed (io.debezium.jdbc.JdbcConnection:947) [2023-05-02 16:22:51,780] INFO [src-ase1-dbz22-test21|task-0] No in-progress transactions will be captured. (io.debezium.connector.oracle.logminer.LogMinerAdapter:204) [2023-05-02 16:22:51,725] INFO [src-ase1-dbz22-test21|task-0] No latest table SCN could be resolved, defaulting to current SCN (io.debezium.connector.oracle.AbstractStreamingAdapter:112) [2023-05-02 16:22:51,722] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 4 - Determining snapshot offset (io.debezium.relational.RelationalSnapshotChangeEventSource:132) [2023-05-02 16:22:51,721] DEBUG [src-ase1-dbz22-test21|task-0] Locking table ASEX92A.ASEDBUSR.ABRDVRSUNT (io.debezium.connector.oracle.OracleSnapshotChangeEventSource:119) [2023-05-02 16:22:51,721] DEBUG [src-ase1-dbz22-test21|task-0] Locking table ASEX92A.ASEDBUSR.ABRDVRS (io.debezium.connector.oracle.OracleSnapshotChangeEventSource:119) [2023-05-02 16:22:51,720] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 3 - Locking captured tables [ASEX92A.ASEDBUSR.ABRDVRS, ASEX92A.ASEDBUSR.ABRDVRSUNT] (io.debezium.relational.RelationalSnapshotChangeEventSource:126) [2023-05-02 16:22:51,716] INFO [src-ase1-dbz22-test21|task-0] Adding table ASEX92A.ASEDBUSR.ABRDVRS to the list of capture schema tables (io.debezium.relational.RelationalSnapshotChangeEventSource:267) [2023-05-02 16:22:51,714] INFO [src-ase1-dbz22-test21|task-0] Adding table ASEX92A.ASEDBUSR.ABRDVRSUNT to the list of capture schema tables (io.debezium.relational.RelationalSnapshotChangeEventSource:267) [2023-05-02 16:22:51,253] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 2 - Determining captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource:119) [2023-05-02 16:22:51,253] INFO [src-ase1-dbz22-test21|task-0] Snapshot step 1 - Preparing (io.debezium.relational.RelationalSnapshotChangeEventSource:110) [2023-05-02 16:22:51,253] INFO [src-ase1-dbz22-test21|task-0] According to the connector configuration both schema and data will be snapshot. (io.debezium.connector.oracle.OracleSnapshotChangeEventSource:79) [2023-05-02 16:22:51,252] INFO [src-ase1-dbz22-test21|task-0] No previous offset has been found. (io.debezium.connector.oracle.OracleSnapshotChangeEventSource:74) [2023-05-02 16:22:51,252] INFO [src-ase1-dbz22-test21|task-0] Context created (io.debezium.pipeline.ChangeEventSourceCoordinator:106) [2023-05-02 16:22:51,252] INFO [src-ase1-dbz22-test21|task-0] Metrics registered (io.debezium.pipeline.ChangeEventSourceCoordinator:103) [2023-05-02 16:22:51,251] INFO [src-ase1-dbz22-test21|task-0] Successfully started task (io.debezium.connector.common.BaseSourceTask:245) [2023-05-02 16:22:51,251] INFO [src-ase1-dbz22-test21|task-0] Creating thread debezium-oracleconnector-ASE1-change-event-source-coordinator (io.debezium.util.Threads:287) [2023-05-02 16:22:51,251] INFO [src-ase1-dbz22-test21|task-0] Requested thread factory for connector OracleConnector, id = ASE1 named = change-event-source-coordinator (io.debezium.util.Threads:270) [2023-05-02 16:22:51,251] INFO [src-ase1-dbz22-test21|task-0] App info kafka.consumer for ASE1-schemahistory unregistered (org.apache.kafka.common.utils.AppInfoParser:83) [2023-05-02 16:22:51,249] INFO [src-ase1-dbz22-test21|task-0] Metrics reporters closed (org.apache.kafka.common.metrics.Metrics:703) [2023-05-02 16:22:51,249] INFO [src-ase1-dbz22-test21|task-0] Closing reporter org.apache.kafka.common.metrics.JmxReporter (org.apache.kafka.common.metrics.Metrics:697) [2023-05-02 16:22:51,249] INFO [src-ase1-dbz22-test21|task-0] Metrics scheduler closed (org.apache.kafka.common.metrics.Metrics:693) [2023-05-02 16:22:51,249] INFO [src-ase1-dbz22-test21|task-0] [Consumer clientId=ASE1-schemahistory, groupId=ASE1-schemahistory] Request joining group due to: consumer pro-actively leaving the group (org.apache.kafka.clients.consumer.internals.ConsumerCoordinator:1063) [2023-05-02 16:22:51,249] INFO [src-ase1-dbz22-test21|task-0] [Consumer clientId=ASE1-schemahistory, groupId=ASE1-schemahistory] Resetting generation and member id due to: consumer pro-actively leaving the group (org.apache.kafka.clients.consumer.internals.ConsumerCoordinator:1016) [2023-05-02 16:22:51,230] INFO [src-ase1-dbz22-test21|task-0] [Consumer clientId=ASE1-schemahistory, groupId=ASE1-schemahistory] Cluster ID: 7U9q6C2NTQKv9Voy5YN-Wg (org.apache.kafka.clients.Metadata:287) [2023-05-02 16:22:51,160] INFO [src-ase1-dbz22-test21|task-0] Kafka startTimeMs: 1683037371160 (org.apache.kafka.common.utils.AppInfoParser:121) [2023-05-02 16:22:51,160] INFO [src-ase1-dbz22-test21|task-0] Kafka commitId: 8628b0341c3c46766f141043367cc0052f75b090 (org.apache.kafka.common.utils.AppInfoParser:120) [2023-05-02 16:22:51,160] INFO [src-ase1-dbz22-test21|task-0] Kafka version: 7.3.1-ccs (org.apache.kafka.common.utils.AppInfoParser:119) [2023-05-02 16:22:51,156] INFO [src-ase1-dbz22-test21|task-0] ConsumerConfig values: allow.auto.create.topics = true auto.commit.interval.ms = 5000 auto.offset.reset = earliest bootstrap.servers = [swwkafe01.suvanet.ch:9092] check.crcs = true client.dns.lookup = use_all_dns_ips client.id = ASE1-schemahistory client.rack = connections.max.idle.ms = 540000 default.api.timeout.ms = 60000 enable.auto.commit = false exclude.internal.topics = true fetch.max.bytes = 52428800 fetch.max.wait.ms = 500 fetch.min.bytes = 1 group.id = ASE1-schemahistory group.instance.id = null heartbeat.interval.ms = 3000 interceptor.classes = [] internal.leave.group.on.close = true internal.throw.on.fetch.stable.offset.unsupported = false isolation.level = read_uncommitted key.deserializer = class org.apache.kafka.common.serialization.StringDeserializer max.partition.fetch.bytes = 1048576 max.poll.interval.ms = 300000 max.poll.records = 500 metadata.max.age.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partition.assignment.strategy = [class org.apache.kafka.clients.consumer.RangeAssignor, class org.apache.kafka.clients.consumer.CooperativeStickyAssignor] receive.buffer.bytes = 65536 reconnect.backoff.max.ms = 1000 reconnect.backoff.ms = 50 request.timeout.ms = 30000 retry.backoff.ms = 100 sasl.client.callback.handler.class = null sasl.jaas.config = [hidden] sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.login.callback.handler.class = null sasl.login.class = null sasl.login.connect.timeout.ms = null sasl.login.read.timeout.ms = null sasl.login.refresh.buffer.seconds = 300 sasl.login.refresh.min.period.seconds = 60 sasl.login.refresh.window.factor = 0.8 sasl.login.refresh.window.jitter = 0.05 sasl.login.retry.backoff.max.ms = 10000 sasl.login.retry.backoff.ms = 100 sasl.mechanism = SCRAM-SHA-512 sasl.oauthbearer.clock.skew.seconds = 30 sasl.oauthbearer.expected.audience = null sasl.oauthbearer.expected.issuer = null sasl.oauthbearer.jwks.endpoint.refresh.ms = 3600000 sasl.oauthbearer.jwks.endpoint.retry.backoff.max.ms = 10000 sasl.oauthbearer.jwks.endpoint.retry.backoff.ms = 100 sasl.oauthbearer.jwks.endpoint.url = null sasl.oauthbearer.scope.claim.name = scope sasl.oauthbearer.sub.claim.name = sub sasl.oauthbearer.token.endpoint.url = null security.protocol = SASL_SSL security.providers = null send.buffer.bytes = 131072 session.timeout.ms = 10000 socket.connection.setup.timeout.max.ms = 30000 socket.connection.setup.timeout.ms = 10000 ssl.cipher.suites = null ssl.enabled.protocols = [TLSv1.2, TLSv1.3] ssl.endpoint.identification.algorithm = https ssl.engine.factory.class = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.certificate.chain = null ssl.keystore.key = null ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLSv1.3 ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.certificates = null ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS value.deserializer = class org.apache.kafka.common.serialization.StringDeserializer (org.apache.kafka.clients.consumer.ConsumerConfig:376) [2023-05-02 16:22:51,156] INFO [src-ase1-dbz22-test21|task-0] Connector started for the first time, database schema history recovery will not be executed (io.debezium.connector.oracle.OracleConnectorTask:202) [2023-05-02 16:22:51,156] INFO [src-ase1-dbz22-test21|task-0] No previous offsets found (io.debezium.connector.common.BaseSourceTask:375) [2023-05-02 16:22:51,117] INFO [src-ase1-dbz22-test21|task-0] [Producer clientId=ASE1-schemahistory] Cluster ID: 7U9q6C2NTQKv9Voy5YN-Wg (org.apache.kafka.clients.Metadata:287) [2023-05-02 16:22:51,034] INFO [src-ase1-dbz22-test21|task-0] Kafka startTimeMs: 1683037371033 (org.apache.kafka.common.utils.AppInfoParser:121) [2023-05-02 16:22:51,034] INFO [src-ase1-dbz22-test21|task-0] Kafka commitId: 8628b0341c3c46766f141043367cc0052f75b090 (org.apache.kafka.common.utils.AppInfoParser:120) [2023-05-02 16:22:51,033] INFO [src-ase1-dbz22-test21|task-0] Kafka version: 7.3.1-ccs (org.apache.kafka.common.utils.AppInfoParser:119) [2023-05-02 16:22:51,033] INFO [src-ase1-dbz22-test21|task-0] [Producer clientId=connector-producer-src-ase1-dbz22-test21-0] Cluster ID: 7U9q6C2NTQKv9Voy5YN-Wg (org.apache.kafka.clients.Metadata:287) [2023-05-02 16:22:51,033] INFO [src-ase1-dbz22-test21|task-0] Successfully logged in. (org.apache.kafka.common.security.authenticator.AbstractLogin:61) [2023-05-02 16:22:51,032] INFO [src-ase1-dbz22-test21|task-0] ProducerConfig values: acks = 1 batch.size = 32768 bootstrap.servers = [swwkafe01.suvanet.ch:9092] buffer.memory = 1048576 client.dns.lookup = use_all_dns_ips client.id = ASE1-schemahistory compression.type = none connections.max.idle.ms = 540000 delivery.timeout.ms = 120000 enable.idempotence = false interceptor.classes = [] key.serializer = class org.apache.kafka.common.serialization.StringSerializer linger.ms = 0 max.block.ms = 10000 max.in.flight.requests.per.connection = 5 max.request.size = 1048576 metadata.max.age.ms = 300000 metadata.max.idle.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partitioner.adaptive.partitioning.enable = true partitioner.availability.timeout.ms = 0 partitioner.class = null partitioner.ignore.keys = false receive.buffer.bytes = 32768 reconnect.backoff.max.ms = 1000 reconnect.backoff.ms = 50 request.timeout.ms = 30000 retries = 1 retry.backoff.ms = 100 sasl.client.callback.handler.class = null sasl.jaas.config = [hidden] sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.login.callback.handler.class = null sasl.login.class = null sasl.login.connect.timeout.ms = null sasl.login.read.timeout.ms = null sasl.login.refresh.buffer.seconds = 300 sasl.login.refresh.min.period.seconds = 60 sasl.login.refresh.window.factor = 0.8 sasl.login.refresh.window.jitter = 0.05 sasl.login.retry.backoff.max.ms = 10000 sasl.login.retry.backoff.ms = 100 sasl.mechanism = SCRAM-SHA-512 sasl.oauthbearer.clock.skew.seconds = 30 sasl.oauthbearer.expected.audience = null sasl.oauthbearer.expected.issuer = null sasl.oauthbearer.jwks.endpoint.refresh.ms = 3600000 sasl.oauthbearer.jwks.endpoint.retry.backoff.max.ms = 10000 sasl.oauthbearer.jwks.endpoint.retry.backoff.ms = 100 sasl.oauthbearer.jwks.endpoint.url = null sasl.oauthbearer.scope.claim.name = scope sasl.oauthbearer.sub.claim.name = sub sasl.oauthbearer.token.endpoint.url = null security.protocol = SASL_SSL security.providers = null send.buffer.bytes = 131072 socket.connection.setup.timeout.max.ms = 30000 socket.connection.setup.timeout.ms = 10000 ssl.cipher.suites = null ssl.enabled.protocols = [TLSv1.2, TLSv1.3] ssl.endpoint.identification.algorithm = https ssl.engine.factory.class = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.certificate.chain = null ssl.keystore.key = null ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLSv1.3 ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.certificates = null ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS transaction.timeout.ms = 60000 transactional.id = null value.serializer = class org.apache.kafka.common.serialization.StringSerializer (org.apache.kafka.clients.producer.ProducerConfig:376) [2023-05-02 16:22:51,032] INFO [src-ase1-dbz22-test21|task-0] Idempotence will be disabled because acks is set to 1, not set to 'all'. (org.apache.kafka.clients.producer.ProducerConfig:526) [2023-05-02 16:22:51,032] INFO [src-ase1-dbz22-test21|task-0] Requested thread factory for connector OracleConnector, id = ASE1 named = db-history-config-check (io.debezium.util.Threads:270) [2023-05-02 16:22:51,032] INFO [src-ase1-dbz22-test21|task-0] KafkaSchemaHistory Producer config: {batch.size=32768, acks=1, bootstrap.servers=swwkafe01.suvanet.ch:9092, buffer.memory=1048576, key.serializer=org.apache.kafka.common.serialization.StringSerializer, security.protocol=SASL_SSL, retries=1, value.serializer=org.apache.kafka.common.serialization.StringSerializer, sasl.mechanism=SCRAM-SHA-512, sasl.jaas.config=********, max.block.ms=10000, client.id=ASE1-schemahistory, linger.ms=0} (io.debezium.storage.kafka.history.KafkaSchemaHistory:246) [2023-05-02 16:22:51,032] INFO [src-ase1-dbz22-test21|task-0] KafkaSchemaHistory Consumer config: {key.deserializer=org.apache.kafka.common.serialization.StringDeserializer, value.deserializer=org.apache.kafka.common.serialization.StringDeserializer, group.id=ASE1-schemahistory, bootstrap.servers=swwkafe01.suvanet.ch:9092, security.protocol=SASL_SSL, enable.auto.commit=false, sasl.mechanism=SCRAM-SHA-512, sasl.jaas.config=********, fetch.min.bytes=1, session.timeout.ms=10000, auto.offset.reset=earliest, client.id=ASE1-schemahistory} (io.debezium.storage.kafka.history.KafkaSchemaHistory:245) [2023-05-02 16:22:51,031] DEBUG [src-ase1-dbz22-test21|task-0] LOG_MODE=ARCHIVELOG (io.debezium.connector.oracle.OracleConnection:432) [2023-05-02 16:22:51,028] INFO [src-ase1-dbz22-test21|task-0] Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.16.0.0.0 (io.debezium.connector.oracle.OracleConnection:83) [2023-05-02 16:22:50,981] INFO [src-ase1-dbz22-test21|task-0] Loading the custom topic naming strategy plugin: io.debezium.schema.SchemaTopicNamingStrategy (io.debezium.config.CommonConnectorConfig:849) [2023-05-02 16:22:50,981] INFO [src-ase1-dbz22-test21|task-0] Attempting to start task (io.debezium.connector.common.BaseSourceTask:243) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] WorkerSourceTask{id=src-ase1-dbz22-test21-0} Source task finished initialization and start (org.apache.kafka.connect.runtime.AbstractWorkerSourceTask:271) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.consumer.security.protocol = SASL_SSL (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] transforms.changes.header.changed.name = Changed (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] snapshot.mode = initial (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] key.converter.schema.registry.url = http://swwkafe01c1.suvanet.ch:8081 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] table.include.list = ASEDBUSR.ABRDVRS,ASEDBUSR.ABRDVRSUNT (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.producer.sasl.jaas.config = ******** (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.consumer.sasl.mechanism = SCRAM-SHA-512 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] name = src-ase1-dbz22-test21 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] schema.name.adjustment.mode = avro (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] database.password = ******** (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,980] INFO [src-ase1-dbz22-test21|task-0] task.class = io.debezium.connector.oracle.OracleConnectorTask (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] value.converter.schema.registry.url = http://swwkafe01c1.suvanet.ch:8081 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] snapshot.select.statement.overrides.ASEDBUSR.ABRDVRS = SELECT * FROM ASEDBUSR.ABRDVRS ORDER BY CREATED ASC, PKEY ASC (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] snapshot.max.threads = 2 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] event.processing.failure.handling.mode = fail (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] transforms.changes.type = io.debezium.transforms.ExtractChangedRecordState (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.kafka.bootstrap.servers = swwkafe01.suvanet.ch:9092 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] transforms.moveHeadersToValue.fields = Changed (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] time.precision.mode = connect (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] database.url = jdbc:oracle:thin:@//H52L170.suvanet.ch:1521/ASEX92A.suvanet.ch (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] snapshot.select.statement.overrides = ASEDBUSR.ABRDVRS,ASEDBUSR.ABRDVRSUNT (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] level = trace (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] database.dbname = ASEX92A (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] database.user = DSL_RO (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,979] INFO [src-ase1-dbz22-test21|task-0] log.mining.transaction.retention.hours = 24 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] transforms.moveHeadersToValue.type = io.debezium.transforms.HeaderToValue (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.producer.sasl.mechanism = SCRAM-SHA-512 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] snapshot.fetch.size = 10000 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] key.converter = io.confluent.connect.avro.AvroConverter (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] snapshot.select.statement.overrides.ASEDBUSR.ABRDVRSUNT = SELECT * FROM ASEDBUSR.ABRDVRSUNT ORDER BY CREATED ASC, PKEY ASC (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] value.converter = io.confluent.connect.avro.AvroConverter (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] transforms.moveHeadersToValue.operation = move (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] lob.enabled = true (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.producer.security.protocol = SASL_SSL (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.kafka.topic = ase.schema-changes.asedbusr (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] topic.prefix = ASE1 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] unavailable.value.placeholder = previous_value_unchanged (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] tombstones.on.delete = true (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.store.only.captured.tables.ddl = true (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,978] INFO [src-ase1-dbz22-test21|task-0] log.mining.strategy = online_catalog (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] internal.log.mining.log.query.max.retries = 10 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] transforms = changes,moveHeadersToValue (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] schema.history.internal.consumer.sasl.jaas.config = ******** (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] log.mining.archive.destination.name = LOG_ARCHIVE_DEST_10 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] tasks.max = 1 (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] transforms.moveHeadersToValue.headers = Changes (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] message.key.columns = ASEDBUSR.ABRDVRS:BOID;ASEDBUSR.ABRDVRSUNT:BOID; (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,977] INFO [src-ase1-dbz22-test21|task-0] connector.class = io.debezium.connector.oracle.OracleConnector (io.debezium.connector.common.BaseSourceTask:126) [2023-05-02 16:22:50,976] INFO [src-ase1-dbz22-test21|task-0] Starting OracleConnectorTask with configuration: (io.debezium.connector.common.BaseSourceTask:124) [2023-05-02 16:22:50,974] INFO [src-ase1-dbz22-test21|task-0] Kafka startTimeMs: 1683037370974 (org.apache.kafka.common.utils.AppInfoParser:121) [2023-05-02 16:22:50,974] INFO [src-ase1-dbz22-test21|task-0] Kafka commitId: 8628b0341c3c46766f141043367cc0052f75b090 (org.apache.kafka.common.utils.AppInfoParser:120) [2023-05-02 16:22:50,974] INFO [src-ase1-dbz22-test21|task-0] Kafka version: 7.3.1-ccs (org.apache.kafka.common.utils.AppInfoParser:119) [2023-05-02 16:22:50,974] WARN [src-ase1-dbz22-test21|task-0] These configurations '[metrics.context.connect.group.id, metrics.context.connect.kafka.cluster.id]' were supplied but are not used yet. (org.apache.kafka.clients.producer.ProducerConfig:385) [2023-05-02 16:22:50,972] INFO [src-ase1-dbz22-test21|task-0] ProducerConfig values: acks = -1 batch.size = 16384 bootstrap.servers = [swwkafe01.suvanet.ch:9092] buffer.memory = 33554432 client.dns.lookup = use_all_dns_ips client.id = connector-producer-src-ase1-dbz22-test21-0 compression.type = none connections.max.idle.ms = 540000 delivery.timeout.ms = 2147483647 enable.idempotence = false interceptor.classes = [] key.serializer = class org.apache.kafka.common.serialization.ByteArraySerializer linger.ms = 0 max.block.ms = 9223372036854775807 max.in.flight.requests.per.connection = 1 max.request.size = 1048576 metadata.max.age.ms = 300000 metadata.max.idle.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partitioner.adaptive.partitioning.enable = true partitioner.availability.timeout.ms = 0 partitioner.class = null partitioner.ignore.keys = false receive.buffer.bytes = 32768 reconnect.backoff.max.ms = 1000 reconnect.backoff.ms = 50 request.timeout.ms = 30000 retries = 2147483647 retry.backoff.ms = 100 sasl.client.callback.handler.class = null sasl.jaas.config = [hidden] sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.login.callback.handler.class = null sasl.login.class = null sasl.login.connect.timeout.ms = null sasl.login.read.timeout.ms = null sasl.login.refresh.buffer.seconds = 300 sasl.login.refresh.min.period.seconds = 60 sasl.login.refresh.window.factor = 0.8 sasl.login.refresh.window.jitter = 0.05 sasl.login.retry.backoff.max.ms = 10000 sasl.login.retry.backoff.ms = 100 sasl.mechanism = SCRAM-SHA-512 sasl.oauthbearer.clock.skew.seconds = 30 sasl.oauthbearer.expected.audience = null sasl.oauthbearer.expected.issuer = null sasl.oauthbearer.jwks.endpoint.refresh.ms = 3600000 sasl.oauthbearer.jwks.endpoint.retry.backoff.max.ms = 10000 sasl.oauthbearer.jwks.endpoint.retry.backoff.ms = 100 sasl.oauthbearer.jwks.endpoint.url = null sasl.oauthbearer.scope.claim.name = scope sasl.oauthbearer.sub.claim.name = sub sasl.oauthbearer.token.endpoint.url = null security.protocol = SASL_SSL security.providers = null send.buffer.bytes = 131072 socket.connection.setup.timeout.max.ms = 30000 socket.connection.setup.timeout.ms = 10000 ssl.cipher.suites = null ssl.enabled.protocols = [TLSv1.2, TLSv1.3] ssl.endpoint.identification.algorithm = https ssl.engine.factory.class = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.certificate.chain = null ssl.keystore.key = null ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLSv1.3 ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.certificates = null ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS transaction.timeout.ms = 60000 transactional.id = null value.serializer = class org.apache.kafka.common.serialization.ByteArraySerializer (org.apache.kafka.clients.producer.ProducerConfig:376) [2023-05-02 16:22:50,971] INFO [src-ase1-dbz22-test21|task-0] Initializing: org.apache.kafka.connect.runtime.TransformationChain{io.debezium.transforms.ExtractChangedRecordState, io.debezium.transforms.HeaderToValue} (org.apache.kafka.connect.runtime.Worker:1344) [2023-05-02 16:22:50,971] INFO [src-ase1-dbz22-test21|task-0] EnrichedConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none exactly.once.support = requested header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 offsets.storage.topic = null predicates = [] tasks.max = 1 topic.creation.groups = [] transaction.boundary = poll transaction.boundary.interval.ms = null transforms = [changes, moveHeadersToValue] transforms.changes.header.changed.name = Changed transforms.changes.header.unchanged.name = null transforms.changes.negate = false transforms.changes.predicate = transforms.changes.type = class io.debezium.transforms.ExtractChangedRecordState transforms.moveHeadersToValue.fields = [Changed] transforms.moveHeadersToValue.headers = [Changes] transforms.moveHeadersToValue.negate = false transforms.moveHeadersToValue.operation = move transforms.moveHeadersToValue.predicate = transforms.moveHeadersToValue.type = class io.debezium.transforms.HeaderToValue value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.ConnectorConfig$EnrichedConnectorConfig:376) [2023-05-02 16:22:50,971] INFO [src-ase1-dbz22-test21|task-0] SourceConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none exactly.once.support = requested header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 offsets.storage.topic = null predicates = [] tasks.max = 1 topic.creation.groups = [] transaction.boundary = poll transaction.boundary.interval.ms = null transforms = [changes, moveHeadersToValue] value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.SourceConnectorConfig:376) [2023-05-02 16:22:50,970] INFO [src-ase1-dbz22-test21|task-0] Set up the header converter class org.apache.kafka.connect.storage.SimpleHeaderConverter for task src-ase1-dbz22-test21-0 using the worker config (org.apache.kafka.connect.runtime.Worker:660) [2023-05-02 16:22:50,970] INFO [src-ase1-dbz22-test21|task-0] Set up the value converter class io.confluent.connect.avro.AvroConverter for task src-ase1-dbz22-test21-0 using the connector config (org.apache.kafka.connect.runtime.Worker:655) [2023-05-02 16:22:50,970] INFO [src-ase1-dbz22-test21|task-0] Set up the key converter class io.confluent.connect.avro.AvroConverter for task src-ase1-dbz22-test21-0 using the connector config (org.apache.kafka.connect.runtime.Worker:649) [2023-05-02 16:22:50,970] INFO [src-ase1-dbz22-test21|task-0] AvroDataConfig values: connect.meta.data = true discard.type.doc.default = false enhanced.avro.schema.support = false generalized.sum.type.support = false ignore.default.for.nullables = false schemas.cache.config = 1000 scrub.invalid.names = false (io.confluent.connect.avro.AvroDataConfig:376) [2023-05-02 16:22:50,970] INFO [src-ase1-dbz22-test21|task-0] KafkaAvroDeserializerConfig values: auto.register.schemas = true avro.reflection.allow.null = false avro.use.logical.type.converters = false basic.auth.credentials.source = URL basic.auth.user.info = [hidden] bearer.auth.cache.expiry.buffer.seconds = 300 bearer.auth.client.id = null bearer.auth.client.secret = null bearer.auth.credentials.source = STATIC_TOKEN bearer.auth.identity.pool.id = null bearer.auth.issuer.endpoint.url = null bearer.auth.logical.cluster = null bearer.auth.scope = null bearer.auth.scope.claim.name = scope bearer.auth.sub.claim.name = sub bearer.auth.token = [hidden] context.name.strategy = class io.confluent.kafka.serializers.context.NullContextNameStrategy id.compatibility.strict = true key.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy latest.compatibility.strict = true max.schemas.per.subject = 1000 normalize.schemas = false proxy.host = proxy.port = -1 schema.format = null schema.reflection = false schema.registry.basic.auth.user.info = [hidden] schema.registry.ssl.cipher.suites = null schema.registry.ssl.enabled.protocols = [TLSv1.2, TLSv1.3] schema.registry.ssl.endpoint.identification.algorithm = https schema.registry.ssl.engine.factory.class = null schema.registry.ssl.key.password = null schema.registry.ssl.keymanager.algorithm = SunX509 schema.registry.ssl.keystore.certificate.chain = null schema.registry.ssl.keystore.key = null schema.registry.ssl.keystore.location = null schema.registry.ssl.keystore.password = null schema.registry.ssl.keystore.type = JKS schema.registry.ssl.protocol = TLSv1.3 schema.registry.ssl.provider = null schema.registry.ssl.secure.random.implementation = null schema.registry.ssl.trustmanager.algorithm = PKIX schema.registry.ssl.truststore.certificates = null schema.registry.ssl.truststore.location = null schema.registry.ssl.truststore.password = null schema.registry.ssl.truststore.type = JKS schema.registry.url = [http://swwkafe01c1.suvanet.ch:8081] specific.avro.reader = false use.latest.version = false use.schema.id = -1 value.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy (io.confluent.kafka.serializers.KafkaAvroDeserializerConfig:376) [2023-05-02 16:22:50,970] INFO [src-ase1-dbz22-test21|task-0] KafkaAvroSerializerConfig values: auto.register.schemas = true avro.reflection.allow.null = false avro.remove.java.properties = false avro.use.logical.type.converters = false basic.auth.credentials.source = URL basic.auth.user.info = [hidden] bearer.auth.cache.expiry.buffer.seconds = 300 bearer.auth.client.id = null bearer.auth.client.secret = null bearer.auth.credentials.source = STATIC_TOKEN bearer.auth.identity.pool.id = null bearer.auth.issuer.endpoint.url = null bearer.auth.logical.cluster = null bearer.auth.scope = null bearer.auth.scope.claim.name = scope bearer.auth.sub.claim.name = sub bearer.auth.token = [hidden] context.name.strategy = class io.confluent.kafka.serializers.context.NullContextNameStrategy id.compatibility.strict = true key.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy latest.compatibility.strict = true max.schemas.per.subject = 1000 normalize.schemas = false proxy.host = proxy.port = -1 schema.format = null schema.reflection = false schema.registry.basic.auth.user.info = [hidden] schema.registry.ssl.cipher.suites = null schema.registry.ssl.enabled.protocols = [TLSv1.2, TLSv1.3] schema.registry.ssl.endpoint.identification.algorithm = https schema.registry.ssl.engine.factory.class = null schema.registry.ssl.key.password = null schema.registry.ssl.keymanager.algorithm = SunX509 schema.registry.ssl.keystore.certificate.chain = null schema.registry.ssl.keystore.key = null schema.registry.ssl.keystore.location = null schema.registry.ssl.keystore.password = null schema.registry.ssl.keystore.type = JKS schema.registry.ssl.protocol = TLSv1.3 schema.registry.ssl.provider = null schema.registry.ssl.secure.random.implementation = null schema.registry.ssl.trustmanager.algorithm = PKIX schema.registry.ssl.truststore.certificates = null schema.registry.ssl.truststore.location = null schema.registry.ssl.truststore.password = null schema.registry.ssl.truststore.type = JKS schema.registry.url = [http://swwkafe01c1.suvanet.ch:8081] use.latest.version = false use.schema.id = -1 value.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy (io.confluent.kafka.serializers.KafkaAvroSerializerConfig:376) [2023-05-02 16:22:50,969] INFO [src-ase1-dbz22-test21|task-0] AvroConverterConfig values: auto.register.schemas = true basic.auth.credentials.source = URL basic.auth.user.info = [hidden] bearer.auth.cache.expiry.buffer.seconds = 300 bearer.auth.client.id = null bearer.auth.client.secret = null bearer.auth.credentials.source = STATIC_TOKEN bearer.auth.identity.pool.id = null bearer.auth.issuer.endpoint.url = null bearer.auth.logical.cluster = null bearer.auth.scope = null bearer.auth.scope.claim.name = scope bearer.auth.sub.claim.name = sub bearer.auth.token = [hidden] context.name.strategy = class io.confluent.kafka.serializers.context.NullContextNameStrategy id.compatibility.strict = true key.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy latest.compatibility.strict = true max.schemas.per.subject = 1000 normalize.schemas = false proxy.host = proxy.port = -1 schema.format = null schema.reflection = false schema.registry.basic.auth.user.info = [hidden] schema.registry.ssl.cipher.suites = null schema.registry.ssl.enabled.protocols = [TLSv1.2, TLSv1.3] schema.registry.ssl.endpoint.identification.algorithm = https schema.registry.ssl.engine.factory.class = null schema.registry.ssl.key.password = null schema.registry.ssl.keymanager.algorithm = SunX509 schema.registry.ssl.keystore.certificate.chain = null schema.registry.ssl.keystore.key = null schema.registry.ssl.keystore.location = null schema.registry.ssl.keystore.password = null schema.registry.ssl.keystore.type = JKS schema.registry.ssl.protocol = TLSv1.3 schema.registry.ssl.provider = null schema.registry.ssl.secure.random.implementation = null schema.registry.ssl.trustmanager.algorithm = PKIX schema.registry.ssl.truststore.certificates = null schema.registry.ssl.truststore.location = null schema.registry.ssl.truststore.password = null schema.registry.ssl.truststore.type = JKS schema.registry.url = [http://swwkafe01c1.suvanet.ch:8081] use.latest.version = false use.schema.id = -1 value.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy (io.confluent.connect.avro.AvroConverterConfig:376) [2023-05-02 16:22:50,969] INFO [src-ase1-dbz22-test21|task-0] AvroDataConfig values: connect.meta.data = true discard.type.doc.default = false enhanced.avro.schema.support = false generalized.sum.type.support = false ignore.default.for.nullables = false schemas.cache.config = 1000 scrub.invalid.names = false (io.confluent.connect.avro.AvroDataConfig:376) [2023-05-02 16:22:50,968] INFO [src-ase1-dbz22-test21|task-0] KafkaAvroDeserializerConfig values: auto.register.schemas = true avro.reflection.allow.null = false avro.use.logical.type.converters = false basic.auth.credentials.source = URL basic.auth.user.info = [hidden] bearer.auth.cache.expiry.buffer.seconds = 300 bearer.auth.client.id = null bearer.auth.client.secret = null bearer.auth.credentials.source = STATIC_TOKEN bearer.auth.identity.pool.id = null bearer.auth.issuer.endpoint.url = null bearer.auth.logical.cluster = null bearer.auth.scope = null bearer.auth.scope.claim.name = scope bearer.auth.sub.claim.name = sub bearer.auth.token = [hidden] context.name.strategy = class io.confluent.kafka.serializers.context.NullContextNameStrategy id.compatibility.strict = true key.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy latest.compatibility.strict = true max.schemas.per.subject = 1000 normalize.schemas = false proxy.host = proxy.port = -1 schema.format = null schema.reflection = false schema.registry.basic.auth.user.info = [hidden] schema.registry.ssl.cipher.suites = null schema.registry.ssl.enabled.protocols = [TLSv1.2, TLSv1.3] schema.registry.ssl.endpoint.identification.algorithm = https schema.registry.ssl.engine.factory.class = null schema.registry.ssl.key.password = null schema.registry.ssl.keymanager.algorithm = SunX509 schema.registry.ssl.keystore.certificate.chain = null schema.registry.ssl.keystore.key = null schema.registry.ssl.keystore.location = null schema.registry.ssl.keystore.password = null schema.registry.ssl.keystore.type = JKS schema.registry.ssl.protocol = TLSv1.3 schema.registry.ssl.provider = null schema.registry.ssl.secure.random.implementation = null schema.registry.ssl.trustmanager.algorithm = PKIX schema.registry.ssl.truststore.certificates = null schema.registry.ssl.truststore.location = null schema.registry.ssl.truststore.password = null schema.registry.ssl.truststore.type = JKS schema.registry.url = [http://swwkafe01c1.suvanet.ch:8081] specific.avro.reader = false use.latest.version = false use.schema.id = -1 value.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy (io.confluent.kafka.serializers.KafkaAvroDeserializerConfig:376) [2023-05-02 16:22:50,968] INFO [src-ase1-dbz22-test21|task-0] KafkaAvroSerializerConfig values: auto.register.schemas = true avro.reflection.allow.null = false avro.remove.java.properties = false avro.use.logical.type.converters = false basic.auth.credentials.source = URL basic.auth.user.info = [hidden] bearer.auth.cache.expiry.buffer.seconds = 300 bearer.auth.client.id = null bearer.auth.client.secret = null bearer.auth.credentials.source = STATIC_TOKEN bearer.auth.identity.pool.id = null bearer.auth.issuer.endpoint.url = null bearer.auth.logical.cluster = null bearer.auth.scope = null bearer.auth.scope.claim.name = scope bearer.auth.sub.claim.name = sub bearer.auth.token = [hidden] context.name.strategy = class io.confluent.kafka.serializers.context.NullContextNameStrategy id.compatibility.strict = true key.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy latest.compatibility.strict = true max.schemas.per.subject = 1000 normalize.schemas = false proxy.host = proxy.port = -1 schema.format = null schema.reflection = false schema.registry.basic.auth.user.info = [hidden] schema.registry.ssl.cipher.suites = null schema.registry.ssl.enabled.protocols = [TLSv1.2, TLSv1.3] schema.registry.ssl.endpoint.identification.algorithm = https schema.registry.ssl.engine.factory.class = null schema.registry.ssl.key.password = null schema.registry.ssl.keymanager.algorithm = SunX509 schema.registry.ssl.keystore.certificate.chain = null schema.registry.ssl.keystore.key = null schema.registry.ssl.keystore.location = null schema.registry.ssl.keystore.password = null schema.registry.ssl.keystore.type = JKS schema.registry.ssl.protocol = TLSv1.3 schema.registry.ssl.provider = null schema.registry.ssl.secure.random.implementation = null schema.registry.ssl.trustmanager.algorithm = PKIX schema.registry.ssl.truststore.certificates = null schema.registry.ssl.truststore.location = null schema.registry.ssl.truststore.password = null schema.registry.ssl.truststore.type = JKS schema.registry.url = [http://swwkafe01c1.suvanet.ch:8081] use.latest.version = false use.schema.id = -1 value.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy (io.confluent.kafka.serializers.KafkaAvroSerializerConfig:376) [2023-05-02 16:22:50,967] INFO [src-ase1-dbz22-test21|task-0] AvroConverterConfig values: auto.register.schemas = true basic.auth.credentials.source = URL basic.auth.user.info = [hidden] bearer.auth.cache.expiry.buffer.seconds = 300 bearer.auth.client.id = null bearer.auth.client.secret = null bearer.auth.credentials.source = STATIC_TOKEN bearer.auth.identity.pool.id = null bearer.auth.issuer.endpoint.url = null bearer.auth.logical.cluster = null bearer.auth.scope = null bearer.auth.scope.claim.name = scope bearer.auth.sub.claim.name = sub bearer.auth.token = [hidden] context.name.strategy = class io.confluent.kafka.serializers.context.NullContextNameStrategy id.compatibility.strict = true key.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy latest.compatibility.strict = true max.schemas.per.subject = 1000 normalize.schemas = false proxy.host = proxy.port = -1 schema.format = null schema.reflection = false schema.registry.basic.auth.user.info = [hidden] schema.registry.ssl.cipher.suites = null schema.registry.ssl.enabled.protocols = [TLSv1.2, TLSv1.3] schema.registry.ssl.endpoint.identification.algorithm = https schema.registry.ssl.engine.factory.class = null schema.registry.ssl.key.password = null schema.registry.ssl.keymanager.algorithm = SunX509 schema.registry.ssl.keystore.certificate.chain = null schema.registry.ssl.keystore.key = null schema.registry.ssl.keystore.location = null schema.registry.ssl.keystore.password = null schema.registry.ssl.keystore.type = JKS schema.registry.ssl.protocol = TLSv1.3 schema.registry.ssl.provider = null schema.registry.ssl.secure.random.implementation = null schema.registry.ssl.trustmanager.algorithm = PKIX schema.registry.ssl.truststore.certificates = null schema.registry.ssl.truststore.location = null schema.registry.ssl.truststore.password = null schema.registry.ssl.truststore.type = JKS schema.registry.url = [http://swwkafe01c1.suvanet.ch:8081] use.latest.version = false use.schema.id = -1 value.subject.name.strategy = class io.confluent.kafka.serializers.subject.TopicNameStrategy (io.confluent.connect.avro.AvroConverterConfig:376) [2023-05-02 16:22:50,966] INFO [src-ase1-dbz22-test21|task-0] Instantiated task src-ase1-dbz22-test21-0 with version 2.2.0.Final of type io.debezium.connector.oracle.OracleConnectorTask (org.apache.kafka.connect.runtime.Worker:634) [2023-05-02 16:22:50,966] INFO [src-ase1-dbz22-test21|task-0] TaskConfig values: task.class = class io.debezium.connector.oracle.OracleConnectorTask (org.apache.kafka.connect.runtime.TaskConfig:376) [2023-05-02 16:22:50,966] INFO [src-ase1-dbz22-test21|task-0] EnrichedConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 predicates = [] tasks.max = 1 transforms = [changes, moveHeadersToValue] transforms.changes.header.changed.name = Changed transforms.changes.header.unchanged.name = null transforms.changes.negate = false transforms.changes.predicate = transforms.changes.type = class io.debezium.transforms.ExtractChangedRecordState transforms.moveHeadersToValue.fields = [Changed] transforms.moveHeadersToValue.headers = [Changes] transforms.moveHeadersToValue.negate = false transforms.moveHeadersToValue.operation = move transforms.moveHeadersToValue.predicate = transforms.moveHeadersToValue.type = class io.debezium.transforms.HeaderToValue value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.ConnectorConfig$EnrichedConnectorConfig:376) [2023-05-02 16:22:50,965] INFO [src-ase1-dbz22-test21|task-0] ConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 predicates = [] tasks.max = 1 transforms = [changes, moveHeadersToValue] value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.ConnectorConfig:376) [2023-05-02 16:22:50,965] INFO [src-ase1-dbz22-test21|task-0] Creating task src-ase1-dbz22-test21-0 (org.apache.kafka.connect.runtime.Worker:619) [2023-05-02 16:22:50,964] INFO [Worker clientId=connect-1, groupId=connect-cluster] Starting task src-ase1-dbz22-test21-0 (org.apache.kafka.connect.runtime.distributed.DistributedHerder:1701) [2023-05-02 16:22:50,964] INFO [Worker clientId=connect-1, groupId=connect-cluster] Joined group at generation 114 with protocol version 2 and got assignment: Assignment{error=0, leader='connect-1-d49a6bb5-0257-4d75-b8aa-f25908043291', leaderUrl='http://10.85.80.13:8083/', offset=20193, connectorIds=[src-ase1-dbz22-test21, src-mlp.dat.tdk_bow_request_db, src-dwh-sm19-code-bezeichnung], taskIds=[src-ase1-dbz22-test21-0, src-mlp.dat.tdk_bow_request_db-0, src-dwh-sm19-code-bezeichnung-0], revokedConnectorIds=[], revokedTaskIds=[], delay=0} with rebalance delay: 0 (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2256) [2023-05-02 16:22:50,914] INFO [Worker clientId=connect-1, groupId=connect-cluster] Tasks [src-ase1-dbz22-test21-0] configs updated (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2081) [2023-05-02 16:22:50,914] INFO [Worker clientId=connect-1, groupId=connect-cluster] Tasks [src-ase1-dbz22-test21-0] configs updated (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2081) [2023-05-02 16:22:50,912] INFO [Worker clientId=connect-1, groupId=connect-cluster] Tasks [src-ase1-dbz22-test21-0] configs updated (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2081) [2023-05-02 16:22:50,836] INFO EnrichedConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none exactly.once.support = requested header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 offsets.storage.topic = null predicates = [] tasks.max = 1 topic.creation.groups = [] transaction.boundary = poll transaction.boundary.interval.ms = null transforms = [changes, moveHeadersToValue] transforms.changes.header.changed.name = Changed transforms.changes.header.unchanged.name = null transforms.changes.negate = false transforms.changes.predicate = transforms.changes.type = class io.debezium.transforms.ExtractChangedRecordState transforms.moveHeadersToValue.fields = [Changed] transforms.moveHeadersToValue.headers = [Changes] transforms.moveHeadersToValue.negate = false transforms.moveHeadersToValue.operation = move transforms.moveHeadersToValue.predicate = transforms.moveHeadersToValue.type = class io.debezium.transforms.HeaderToValue value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.ConnectorConfig$EnrichedConnectorConfig:376) [2023-05-02 16:22:50,836] INFO SourceConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none exactly.once.support = requested header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 offsets.storage.topic = null predicates = [] tasks.max = 1 topic.creation.groups = [] transaction.boundary = poll transaction.boundary.interval.ms = null transforms = [changes, moveHeadersToValue] value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.SourceConnectorConfig:376) [2023-05-02 16:22:50,833] INFO [src-ase1-dbz22-test21|worker] Finished creating connector src-ase1-dbz22-test21 (org.apache.kafka.connect.runtime.Worker:347) [2023-05-02 16:22:50,833] INFO [src-ase1-dbz22-test21|worker] Instantiated connector src-ase1-dbz22-test21 with version 2.2.0.Final of type class io.debezium.connector.oracle.OracleConnector (org.apache.kafka.connect.runtime.Worker:322) [2023-05-02 16:22:50,832] INFO [src-ase1-dbz22-test21|worker] EnrichedConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none exactly.once.support = requested header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 offsets.storage.topic = null predicates = [] tasks.max = 1 topic.creation.groups = [] transaction.boundary = poll transaction.boundary.interval.ms = null transforms = [changes, moveHeadersToValue] transforms.changes.header.changed.name = Changed transforms.changes.header.unchanged.name = null transforms.changes.negate = false transforms.changes.predicate = transforms.changes.type = class io.debezium.transforms.ExtractChangedRecordState transforms.moveHeadersToValue.fields = [Changed] transforms.moveHeadersToValue.headers = [Changes] transforms.moveHeadersToValue.negate = false transforms.moveHeadersToValue.operation = move transforms.moveHeadersToValue.predicate = transforms.moveHeadersToValue.type = class io.debezium.transforms.HeaderToValue value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.ConnectorConfig$EnrichedConnectorConfig:376) [2023-05-02 16:22:50,832] INFO [src-ase1-dbz22-test21|worker] SourceConnectorConfig values: config.action.reload = restart connector.class = io.debezium.connector.oracle.OracleConnector errors.log.enable = false errors.log.include.messages = false errors.retry.delay.max.ms = 60000 errors.retry.timeout = 0 errors.tolerance = none exactly.once.support = requested header.converter = null key.converter = class io.confluent.connect.avro.AvroConverter name = src-ase1-dbz22-test21 offsets.storage.topic = null predicates = [] tasks.max = 1 topic.creation.groups = [] transaction.boundary = poll transaction.boundary.interval.ms = null transforms = [changes, moveHeadersToValue] value.converter = class io.confluent.connect.avro.AvroConverter (org.apache.kafka.connect.runtime.SourceConnectorConfig:376) [2023-05-02 16:22:50,832] INFO [src-ase1-dbz22-test21|worker] Creating connector src-ase1-dbz22-test21 of type io.debezium.connector.oracle.OracleConnector (org.apache.kafka.connect.runtime.Worker:300) [2023-05-02 16:22:50,832] INFO [Worker clientId=connect-1, groupId=connect-cluster] Starting connector src-ase1-dbz22-test21 (org.apache.kafka.connect.runtime.distributed.DistributedHerder:1776) [2023-05-02 16:22:50,831] INFO [Worker clientId=connect-1, groupId=connect-cluster] Joined group at generation 113 with protocol version 2 and got assignment: Assignment{error=0, leader='connect-1-d49a6bb5-0257-4d75-b8aa-f25908043291', leaderUrl='http://10.85.80.13:8083/', offset=20191, connectorIds=[src-ase1-dbz22-test21, src-mlp.dat.tdk_bow_request_db, src-dwh-sm19-code-bezeichnung], taskIds=[src-mlp.dat.tdk_bow_request_db-0, src-dwh-sm19-code-bezeichnung-0], revokedConnectorIds=[], revokedTaskIds=[], delay=0} with rebalance delay: 0 (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2256) [2023-05-02 16:22:50,731] INFO [Worker clientId=connect-1, groupId=connect-cluster] Connector src-ase1-dbz22-test21 config updated (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2066) [2023-05-02 16:22:50,731] INFO [Worker clientId=connect-1, groupId=connect-cluster] Connector src-ase1-dbz22-test21 config updated (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2066) [2023-05-02 16:22:50,731] INFO [Worker clientId=connect-1, groupId=connect-cluster] Connector src-ase1-dbz22-test21 config updated (org.apache.kafka.connect.runtime.distributed.DistributedHerder:2066)