Confluence fails to start on Oracle protocol violation inconsistent state
Symptoms
Confluence fails to upgrade using a Oracle database
The following appears in the atlassian-confluence.log
:
Job threw an unhandled exception. [See nested
exception: org.springframework.transaction.TransactionSystemException:
Could not commit Hibernate transaction; nested exception is
net.sf.hibernate.TransactionException: Commit failed with SQL exception:
org.springframework.transaction.TransactionSystemException: Could not
commit Hibernate transaction; nested exception is
net.sf.hibernate.TransactionException: Commit failed with SQL exception:
Caused by: net.sf.hibernate.TransactionException: Commit failed with SQL exception:
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:71)
at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:510)
Caused by: java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
AND
ERROR [DefaultQuartzScheduler_Worker-7] [springframework.transaction.interceptor.TransactionInterceptor] completeTransactionAfterThrowing Application exception overridden by rollback exception
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [99999]; error code [17447]; OALL8 is in an inconsistent state; nested exception is java.sql.SQLException: OALL8 is in an inconsistent state
Caused by: java.sql.SQLException: OALL8 is in an inconsistent state
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:474)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:180)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
Cause
The problem is caused by a incorrect JDBC driver which is either defective or old for the current Oracle version being used.
Resolution
Check for the latest JDBC driver available for Oracle version being used and replace the other in the
<Confluence installation>
folder./confluence
/WEB-INF/lib
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.