Confluence fails to start on Oracle protocol violation inconsistent state

Still need help?

The Atlassian Community is here for you.

Ask the community

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>/confluence/WEB-INF/lib folder.

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.