2017-05-03 18:45:20.830 c.s.d.p.s.b.TgsVehicleToOracleBolt_XZ [ERROR] ORA-01502: 绱㈠?'JCPT_HC3.SYS_C0010810' 骅跨被绱㈠肩
邋哄? 瀵绋缍鎊[[?1;2c
浜涓
java.sql.BatchUpdateException: ORA-01502: 绱㈠?'JCPT_HC3.SYS_C0010810' 骅跨被绱㈠肩
邋哄? 瀵绋缍?
浜涓
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) ~[stormjar.jar:?]
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698) ~[stormjar.jar:?]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:559) ~[stormjar.jar:?]
at com.supconit.data.process.storm.bolts.TgsVehicleToOracleBolt_XZ.writeToDb(TgsVehicleToOracleBolt_XZ.java:226) [stormjar.jar:?]
at com.supconit.data.process.storm.bolts.TgsVehicleToOracleBolt_XZ.access$0(TgsVehicleToOracleBolt_XZ.java:155) [stormjar.jar:?]
at com.supconit.data.process.storm.bolts.TgsVehicleToOracleBolt_XZ$1.run(TgsVehicleToOracleBolt_XZ.java:80) [stormjar.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [?:1.7.0_71]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) [?:1.7.0_71]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) [?:1.7.0_71]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.7.0_71]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_71]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_71]
解决:
这其实是因为表的索引需要重建,只要将需要插入的目标表的所有索引rebuild即可。
至于为什么会出现这种情况,大概是:
1、一个普通heap表,被truncate了;
2、分区表,truncate一个分区或者多个分区;
3、如果分区表的一个全局索引,当drop掉分区后,最好也重建下索引;
4、大量delete操作后,建议重建下索引;
应该还有其他的场景。