Confluence fails to start on Oracle protocol violation inconsistent state
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Confluence fails to upgrade using a Oracle database
The following appears in the atlassian-confluence.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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/libfolder.
Was this helpful?