Application Fails to Startup after Upgrading Oracle Database
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
You're running a Crowd version older than 2.4.2. Crowd fails to startup after upgrading Oracle from 10g to 11g, with the following error reported in the logs:
1
2
3
4
5
6
7
8
2010-08-18 16:00:00,409 DefaultQuartzScheduler_Worker-6 ERROR [hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)
2010-08-18 16:00:00,411 DefaultQuartzScheduler_Worker-6 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.TokenReaperJob threw an unhandled Exception:
org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
Cause
Oracle 11g is not a supported database for your version of Crowd. Oracle 11g support was added in version 2.4.2 and is available in 2.5 and newer versions.
Resolution
Revert back to Oracle 10g, or upgrade to a version of Crowd that supports Oracle 11g.
Was this helpful?