JBoss looses connection to oracle - in the logs we see: ORA-01502: index 'xxx' or partition of such index is in unusable state
Issue
We see the following error in our JBoss logs:
07:49:26,706 INFO [stdout] (ajp-/172.22.40.163:8009-7) Caused by: java.sql.SQLException: ORA-01502: index 'MISUMIADM.I_V_SURTIDO_TIENDA_1' or partition of such index is in unusable state
07:49:26,706 INFO [stdout] (ajp-/172.22.40.163:8009-7)
07:49:26,706 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
07:49:26,706 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
07:49:26,707 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
07:49:26,707 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
07:49:26,707 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
07:49:26,707 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
07:49:26,708 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
07:49:26,708 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
07:49:26,708 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
07:49:26,709 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
07:49:26,709 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
07:49:26,709 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
07:49:26,709 INFO [stdout] (ajp-/172.22.40.163:8009-7) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
07:49:26,710 INFO [stdout] (ajp-/172.22.40.163:8009-7) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
....
Environment
- Oracle database
- JBoss Enterprise Application Platform (EAP) or any other product (including non-RedHat products) making connections to Oracle databases
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.