View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004891 | SymmetricDS Pro | Bug | public | 2021-03-12 20:23 | 2021-03-30 19:47 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.7 | ||||
| Target Version | 3.12.8 | Fixed in Version | 3.12.8 | ||
| Summary | 0004891: Oracle log miner fails to move forward in the log mining when starting SCN is too low | ||||
| Description | When the starting SCN is too small (either the database server complains about not being able to open the log file or no SCN number is found), the processing tries over and over to use that bad SCN number. When this occurs (ORA-01291 or ORA-01292), the starting SCN number should be set to 0 and the handle error should return retry to allow the processing to continue. Failed to mine the log StackTraceKey.init [eI:2270200880] com.jumpmind.symmetric.console.impl.eI: Failed to init oracle log miner with options=LogMinerOptions [startScn=203083208741, endScn=203083208754, tableNames=[], operations=[DELETE, COMMIT, LOB_TRIM, INSERT, UPDATE, LOB_WRITE, XML DOC END, XML DOC BEGIN, XML DOC WRITE, ROLLBACK], dataSource=org.jumpmind.db.util.ResettableBasicDataSource@4767a5d] Statement: null at com.jumpmind.symmetric.console.impl.eG.a(OracleLogMiner.java:357) at com.jumpmind.symmetric.console.impl.eG.a(OracleLogMiner.java:107) at com.jumpmind.symmetric.console.impl.ed.a(TransactionMiner.java:134) at com.jumpmind.symmetric.console.service.impl.LogMinerService.mineDataForTables(LogMinerService.java:126) at com.jumpmind.symmetric.console.service.impl.LogMinerService.mineData(LogMinerService.java:68) at org.jumpmind.symmetric.job.LogMinerJob.doJob(LogMinerJob.java:45) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 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:1052) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:610) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:249) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:82) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:924) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1136) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3640) at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1318) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3752) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4242) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079) at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at com.jumpmind.symmetric.console.impl.eG.i(OracleLogMiner.java:195) at com.jumpmind.symmetric.console.impl.eG.a(OracleLogMiner.java:102) ... 14 more Caused by: Error : 1291, Position : 0, Sql = BEGIN dbms_logmnr.start_logmnr(STARTSCN => 203083208741, ENDSCN => 203083208754, OPTIONS => DBMS_LOGMNR.SKIP_CORRUPTION+DBMS_LOGMNR.NO_SQL_DELIMITER+DBMS_LOGMNR.NO_ROWID_IN_STMT+DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG+DBMS_LOGMNR.CONTINUOUS_MINE);END;, OriginalSql = BEGIN dbms_logmnr.start_logmnr(STARTSCN => 203083208741, ENDSCN => 203083208754, OPTIONS => DBMS_LOGMNR.SKIP_CORRUPTION+DBMS_LOGMNR.NO_SQL_DELIMITER+DBMS_LOGMNR.NO_ROWID_IN_STMT+DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG+DBMS_LOGMNR.CONTINUOUS_MINE);END;, Error Msg = ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 32 more | ||||
| Tags | dialect: oracle, log miner | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-03-12 20:23 | pmarzullo | New Issue | |
| 2021-03-12 20:23 | pmarzullo | Status | new => assigned |
| 2021-03-12 20:23 | pmarzullo | Assigned To | => pmarzullo |
| 2021-03-12 20:23 | pmarzullo | Tag Attached: dialect: oracle | |
| 2021-03-12 20:23 | pmarzullo | Tag Attached: log-miner | |
| 2021-03-12 21:12 | pmarzullo | Status | assigned => resolved |
| 2021-03-12 21:12 | pmarzullo | Resolution | open => fixed |
| 2021-03-12 21:12 | pmarzullo | Fixed in Version | => 3.12.8 |
| 2021-03-30 19:47 | admin | Status | resolved => closed |
| 2022-08-09 17:57 | admin | Tag Renamed | log-miner => log miner |