[2021-02-04 10:22:25,587] DEBUG Transactional buffer empty, updating offset's SCN 831249769205 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:197) [2021-02-04 10:22:25,594] TRACE Updating LOG_MINING_FLUSH with SCN 831249769442 (io.debezium.connector.oracle.logminer.LogMinerHelper:217) [2021-02-04 10:22:28,644] TRACE Current Redo log fileNames: [+DATA/SBLT22/ONLINELOG/group_1.1358.1047493013, +FRA/SBLT22/ONLINELOG/group_1.8017.1047493001] (io.debezium.connector.oracle.logminer.LogMinerHelper:293) [2021-02-04 10:22:29,001] DEBUG Redo log switch detected, from [+DATA/SBLT22/ONLINELOG/group_6.1338.1047492535, +FRA/SBLT22/ONLINELOG/group_6.5269.1047492445] to [+DATA/SBLT22/ONLINELOG/group_1.1358.1047493013, +FRA/SBLT22/ONLINELOG/group_1.8017.1047493001] (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:168) [2021-02-04 10:22:29,001] TRACE Ending log mining startScn=831249769205, endScn=831249769439, offsetContext.getScn=831249769205, strategy=CATALOG_IN_REDO, continuous=false (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:173) [2021-02-04 10:22:30,419] TRACE Building data dictionary (io.debezium.connector.oracle.logminer.LogMinerHelper:94) [2021-02-04 10:22:31,647] TRACE Getting online redo logs for offset scn 831249769205 (io.debezium.connector.oracle.logminer.LogMinerHelper:578) [2021-02-04 10:22:31,695] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_1.1358.1047493013 with SCN range 831249769369 to 831249771675 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:22:31,695] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_2.831.1047492983 with SCN range 831249771675 to 831249772067 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:22:31,695] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_3.885.1047492937 with SCN range 831249772067 to 9295429630892703743 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:22:31,695] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_4.1503.1047492403 with SCN range 831249722888 to 831249725529 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:22:31,696] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_5.1465.1047492527 with SCN range 831249725529 to 831249725992 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:22:31,696] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_6.1338.1047492535 with SCN range 831249725992 to 831249769369 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:22:31,696] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_7.1340.1047492543 with SCN range 831249636099 to 831249683836 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:22:31,696] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_8.1397.1047492551 with SCN range 831249683836 to 831249686017 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:22:31,696] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_9.1075.1047492561 with SCN range 831249686017 to 831249686470 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:22:31,696] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_10.1366.1047492571 with SCN range 831249686470 to 831249722888 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:22:31,922] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64043.1643.1063621345 with SCN range 831249725992 to 831249769369 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:22:31,922] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64044.1708.1063621351 with SCN range 831249769369 to 831249771675 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:22:31,922] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64045.4995.1063621351 with SCN range 831249771675 to 831249772067 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:22:31,922] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_6.1338.1047492535 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:22:31,929] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_3.885.1047492937 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:22:31,934] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_2.831.1047492983 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:22:31,939] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_1.1358.1047493013 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:22:31,944] DEBUG Last mined SCN: 831249769205, Log file list to mine: [+DATA/SBLT22/ONLINELOG/group_6.1338.1047492535, +DATA/SBLT22/ONLINELOG/group_3.885.1047492937, +DATA/SBLT22/ONLINELOG/group_2.831.1047492983, +DATA/SBLT22/ONLINELOG/group_1.1358.1047493013] (io.debezium.connector.oracle.logminer.LogMinerHelper:525) [2021-02-04 10:22:31,990] TRACE Current Redo log fileNames: [+DATA/SBLT22/ONLINELOG/group_3.885.1047492937, +FRA/SBLT22/ONLINELOG/group_3.6761.1047492901] (io.debezium.connector.oracle.logminer.LogMinerHelper:293) [2021-02-04 10:22:32,320] TRACE Starting log mining startScn=831249769205, endScn=831249769439, strategy=CATALOG_IN_REDO, continuous=false (io.debezium.connector.oracle.logminer.LogMinerHelper:257) [2021-02-04 10:22:34,792] INFO [Consumer clientId=connector-consumer-from_kafka_to_bis_v4.1-0, groupId=connect-from_kafka_to_bis_v4.1] Node 1006 was unable to process the fetch request with (sessionId=586975833, epoch=240): FETCH_SESSION_ID_NOT_FOUND. (org.apache.kafka.clients.FetchSessionHandler:385) [2021-02-04 10:22:40,820] INFO [Consumer clientId=connector-consumer-from_kafka_to_odpp_dist_guar2_v1.9-0, groupId=connect-from_kafka_to_odpp_dist_guar2_v1.9] Node 1006 was unable to process the fetch request with (sessionId=1047418160, epoch=241): FETCH_SESSION_ID_NOT_FOUND. (org.apache.kafka.clients.FetchSessionHandler:385) [2021-02-04 10:22:55,359] INFO [Consumer clientId=connector-consumer-from_kafka_to_odpp_dist_guar2_v1.8-0, groupId=connect-from_kafka_to_odpp_dist_guar2_v1.8] Node 1006 was unable to process the fetch request with (sessionId=846305547, epoch=241): FETCH_SESSION_ID_NOT_FOUND. (org.apache.kafka.clients.FetchSessionHandler:385) [2021-02-04 10:22:58,560] INFO [Consumer clientId=connector-consumer-from_kafka_to_odpp_dist_guar2_v2.0-0, groupId=connect-from_kafka_to_odpp_dist_guar2_v2.0] Node 1006 was unable to process the fetch request with (sessionId=2145962534, epoch=240): FETCH_SESSION_ID_NOT_FOUND. (org.apache.kafka.clients.FetchSessionHandler:385) [2021-02-04 10:23:00,292] INFO WorkerSourceTask{id=hive_jdbc_test-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,292] INFO WorkerSourceTask{id=hive_jdbc_test-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:00,526] INFO WorkerSourceTask{id=from_odpp_dist_guar_to_kafka_v4.2-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=from_odpp_dist_guar_to_kafka_v4.2-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=celd_diasoft_test_connector-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=celd_diasoft_test_connector-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=TWCMS_Inhouse_TEST-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=TWCMS_Inhouse_TEST-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=ora12connector-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=ora12connector-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=from_odpp_dist_guar_to_kafka-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=from_odpp_dist_guar_to_kafka-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=from_bis_to_kafka_v4.1-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,527] INFO WorkerSourceTask{id=from_bis_to_kafka_v4.1-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:00,528] INFO WorkerSourceTask{id=mssql-test-connector3-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:00,528] INFO WorkerSourceTask{id=mssql-test-connector3-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:01,545] INFO WorkerSourceTask{id=SBLT22-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:416) [2021-02-04 10:23:01,545] INFO WorkerSourceTask{id=SBLT22-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:433) [2021-02-04 10:23:06,004] TRACE scn=831249769207, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,004] TRACE scn=831249769260, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,004] TRACE scn=831249769263, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,004] TRACE scn=831249769266, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,004] TRACE scn=831249769269, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769272, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769274, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769302, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769305, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769308, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769310, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769393, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769396, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,005] TRACE scn=831249769399, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,006] TRACE scn=831249769400, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,006] TRACE scn=831249769405, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,006] TRACE scn=831249769408, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,006] TRACE scn=831249769411, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=LOGMINER (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:108) [2021-02-04 10:23:06,006] DEBUG Transactional buffer empty, updating offset's SCN 831249769439 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:197) [2021-02-04 10:23:06,013] TRACE Updating LOG_MINING_FLUSH with SCN 831249806850 (io.debezium.connector.oracle.logminer.LogMinerHelper:217) [2021-02-04 10:23:08,886] TRACE Current Redo log fileNames: [+FRA/SBLT22/ONLINELOG/group_7.8291.1047492465, +DATA/SBLT22/ONLINELOG/group_7.1340.1047492543] (io.debezium.connector.oracle.logminer.LogMinerHelper:293) [2021-02-04 10:23:09,306] DEBUG Redo log switch detected, from [+DATA/SBLT22/ONLINELOG/group_3.885.1047492937, +FRA/SBLT22/ONLINELOG/group_3.6761.1047492901] to [+FRA/SBLT22/ONLINELOG/group_7.8291.1047492465, +DATA/SBLT22/ONLINELOG/group_7.1340.1047492543] (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:168) [2021-02-04 10:23:09,306] TRACE Ending log mining startScn=831249769439, endScn=831249789439, offsetContext.getScn=831249769439, strategy=CATALOG_IN_REDO, continuous=false (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:173) [2021-02-04 10:23:11,020] TRACE Building data dictionary (io.debezium.connector.oracle.logminer.LogMinerHelper:94) [2021-02-04 10:23:12,626] TRACE Getting online redo logs for offset scn 831249769439 (io.debezium.connector.oracle.logminer.LogMinerHelper:578) [2021-02-04 10:23:12,683] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_1.1358.1047493013 with SCN range 831249769369 to 831249771675 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_2.831.1047492983 with SCN range 831249771675 to 831249772067 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_3.885.1047492937 with SCN range 831249772067 to 831249806297 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_4.1503.1047492403 with SCN range 831249722888 to 831249725529 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_5.1465.1047492527 with SCN range 831249725529 to 831249725992 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_6.1338.1047492535 with SCN range 831249725992 to 831249769369 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_7.1340.1047492543 with SCN range 831249806297 to 831249809341 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_8.1397.1047492551 with SCN range 831249809341 to 831249809734 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:23:12,684] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_9.1075.1047492561 with SCN range 831249809734 to 9295429630892703743 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:596) [2021-02-04 10:23:12,685] TRACE Online redo log +DATA/SBLT22/ONLINELOG/group_10.1366.1047492571 with SCN range 831249686470 to 831249722888 to be excluded. (io.debezium.connector.oracle.logminer.LogMinerHelper:599) [2021-02-04 10:23:13,002] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64044.1708.1063621351 with SCN range 831249769369 to 831249771675 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:23:13,003] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64045.4995.1063621351 with SCN range 831249771675 to 831249772067 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:23:13,003] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64046.14969.1063621379 with SCN range 831249772067 to 831249806297 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:23:13,003] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64047.1993.1063621391 with SCN range 831249806297 to 831249809341 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:23:13,003] TRACE Archive log +FRA/SBLT22/ARCHIVELOG/2021_02_04/thread_1_seq_64048.10573.1063621393 with SCN range 831249809341 to 831249809734 to be added. (io.debezium.connector.oracle.logminer.LogMinerHelper:635) [2021-02-04 10:23:13,003] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_8.1397.1047492551 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:23:13,015] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_3.885.1047492937 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:23:13,022] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_2.831.1047492983 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:23:13,028] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_1.1358.1047493013 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:23:13,036] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_7.1340.1047492543 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:23:13,044] TRACE Adding log file +DATA/SBLT22/ONLINELOG/group_9.1075.1047492561 to mining session (io.debezium.connector.oracle.logminer.LogMinerHelper:520) [2021-02-04 10:23:13,050] DEBUG Last mined SCN: 831249769439, Log file list to mine: [+DATA/SBLT22/ONLINELOG/group_8.1397.1047492551, +DATA/SBLT22/ONLINELOG/group_3.885.1047492937, +DATA/SBLT22/ONLINELOG/group_2.831.1047492983, +DATA/SBLT22/ONLINELOG/group_1.1358.1047493013, +DATA/SBLT22/ONLINELOG/group_7.1340.1047492543, +DATA/SBLT22/ONLINELOG/group_9.1075.1047492561] (io.debezium.connector.oracle.logminer.LogMinerHelper:525) [2021-02-04 10:23:13,121] TRACE Current Redo log fileNames: [+FRA/SBLT22/ONLINELOG/group_9.8402.1047492487, +DATA/SBLT22/ONLINELOG/group_9.1075.1047492561] (io.debezium.connector.oracle.logminer.LogMinerHelper:293) [2021-02-04 10:23:13,549] TRACE Starting log mining startScn=831249769439, endScn=831249789439, strategy=CATALOG_IN_REDO, continuous=false (io.debezium.connector.oracle.logminer.LogMinerHelper:257) [2021-02-04 10:23:27,612] INFO [Worker clientId=connect-1, groupId=connect-cluster] Session key updated (org.apache.kafka.connect.runtime.distributed.DistributedHerder:1440) [2021-02-04 10:23:56,160] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:558) java.sql.SQLException: ORA-00310: archived log contains sequence 64055; sequence 64045 required ORA-00334: archived log: '+DATA/SBLT22/ONLINELOG/group_2.831.1047492983' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:933) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:189) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:140) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: Error : 310, Position : 0, Sql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION, USERNAME FROM V$LOGMNR_CONTENTS WHERE OPERATION_CODE in (1,2,3,5) AND SEG_OWNER = 'SIEBEL' AND table_name IN ('CX_KYC_APP','CX_LE_KYC_AP_LV','CX_REVENUE_YEAR','S_CON_XPERIENCE','CX_DBO','CX_KYC_MVG_REF','S_LST_OF_VAL','CX_SR_DBO','S_PS_CREDENTIAL','CX_LE_SRV_REQ','CX_LE_KYC_AP_CP') AND SCN >= :1 AND SCN < :2 OR (OPERATION_CODE IN (5,34) AND USERNAME NOT IN ('SYS','SYSTEM','LOGMINER')) OR (OPERATION_CODE IN (7,36)), OriginalSql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION, USERNAME FROM V$LOGMNR_CONTENTS WHERE OPERATION_CODE in (1,2,3,5) AND SEG_OWNER = 'SIEBEL' AND table_name IN ('CX_KYC_APP','CX_LE_KYC_AP_LV','CX_REVENUE_YEAR','S_CON_XPERIENCE','CX_DBO','CX_KYC_MVG_REF','S_LST_OF_VAL','CX_SR_DBO','S_PS_CREDENTIAL','CX_LE_SRV_REQ','CX_LE_KYC_AP_CP') AND SCN >= ? AND SCN < ? OR (OPERATION_CODE IN (5,34) AND USERNAME NOT IN ('SYS','SYSTEM','LOGMINER')) OR (OPERATION_CODE IN (7,36)), Error Msg = ORA-00310: archived log contains sequence 64055; sequence 64045 required ORA-00334: archived log: '+DATA/SBLT22/ONLINELOG/group_2.831.1047492983' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 22 more [2021-02-04 10:23:56,161] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31) java.sql.SQLException: ORA-00310: archived log contains sequence 64055; sequence 64045 required ORA-00334: archived log: '+DATA/SBLT22/ONLINELOG/group_2.831.1047492983' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:933) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:189) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:140) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: Error : 310, Position : 0, Sql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION, USERNAME FROM V$LOGMNR_CONTENTS WHERE OPERATION_CODE in (1,2,3,5) AND SEG_OWNER = 'SIEBEL' AND table_name IN ('CX_KYC_APP','CX_LE_KYC_AP_LV','CX_REVENUE_YEAR','S_CON_XPERIENCE','CX_DBO','CX_KYC_MVG_REF','S_LST_OF_VAL','CX_SR_DBO','S_PS_CREDENTIAL','CX_LE_SRV_REQ','CX_LE_KYC_AP_CP') AND SCN >= :1 AND SCN < :2 OR (OPERATION_CODE IN (5,34) AND USERNAME NOT IN ('SYS','SYSTEM','LOGMINER')) OR (OPERATION_CODE IN (7,36)), OriginalSql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION, USERNAME FROM V$LOGMNR_CONTENTS WHERE OPERATION_CODE in (1,2,3,5) AND SEG_OWNER = 'SIEBEL' AND table_name IN ('CX_KYC_APP','CX_LE_KYC_AP_LV','CX_REVENUE_YEAR','S_CON_XPERIENCE','CX_DBO','CX_KYC_MVG_REF','S_LST_OF_VAL','CX_SR_DBO','S_PS_CREDENTIAL','CX_LE_SRV_REQ','CX_LE_KYC_AP_CP') AND SCN >= ? AND SCN < ? OR (OPERATION_CODE IN (5,34) AND USERNAME NOT IN ('SYS','SYSTEM','LOGMINER')) OR (OPERATION_CODE IN (7,36)), Error Msg = ORA-00310: archived log contains sequence 64055; sequence 64045 required ORA-00334: archived log: '+DATA/SBLT22/ONLINELOG/group_2.831.1047492983' at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 22 more [2021-02-04 10:23:56,161] INFO startScn=831249769439, endScn=831249789439, offsetContext.getScn()=831249769439 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:215) [2021-02-04 10:23:56,161] INFO Transactional buffer metrics dump: TransactionalBufferMetrics{oldestScn=831248559515, committedScn=831248559516, offsetScn=831248559515, lagFromTheSource=PT5.891S, activeTransactions=0, rolledBackTransactions=6, committedTransactions=2325, lastCommitDuration=9, maxCommitDuration=195, registeredDmlCounter=2896, committedDmlCounter=2882, maxLagFromTheSource=PT3H14M11.015S, minLagFromTheSource=PT0S, abandonedTransactionIds=[], errorCounter=1, warningCounter=0, scnFreezeCounter=0, commitQueueCapacity=8192} (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:216) [2021-02-04 10:23:56,163] INFO Transactional buffer dump: (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:217) [2021-02-04 10:23:56,163] INFO LogMiner metrics dump: LogMinerMetrics{currentScn=831249806849, logMinerQueryCount=51181, totalCapturedDmlCount=2930, totalDurationOfFetchingQuery=PT7H19M45.417928196S, lastCapturedDmlCount=1, lastDurationOfFetchingQuery=PT7.063874953S, maxCapturedDmlCount=65, maxDurationOfFetchingQuery=PT45.178002423S, totalBatchProcessingDuration=PT4M44.147S, lastBatchProcessingDuration=PT0.026S, maxBatchProcessingDuration=PT38.096S, maxBatchProcessingThroughput=500, currentLogFileName=[Ljava.lang.String;@183bc3fa, redoLogStatus=[Ljava.lang.String;@500f9e01, switchCounter=57, batchSize=20000, millisecondToSleepBetweenMiningQuery=2800, recordMiningHistory=false, hoursToKeepTransaction=4, networkConnectionProblemsCounter0} (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:218) [2021-02-04 10:23:56,164] INFO Finished streaming (io.debezium.pipeline.ChangeEventSourceCoordinator:141)