ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
-------------------------------------------------------------------------------------------------------------------------
Key: SYNCOPE-59
URL: https://issues.apache.org/jira/browse/SYNCOPE-59
Project: Syncope
Issue Type: Bug
Components: core
Affects Versions: 1.0.0-incubating
Environment: Oracle 10g, Linux x86_64,
Reporter: Denis Signoretto
Priority: Critical
Stracktrace Error on startup:
15:51:05.908 ERROR org.syncope.core.init.JobInstanceLoader - While loading
NotificationJob instance
org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock:
ORA-01002: fetch out of sequence
{prepstmnt 155276228 SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = ? FOR UPDATE
[params=?]} [code=1002, state=72000]
at
org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:109)
~[quartz-1.8.6.jar:na]
at
org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:112)
~[quartz-1.8.6.jar:na]
at
org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:235)
~[quartz-1.8.6.jar:na]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3712)
~[quartz-1.8.6.jar:na]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1059)
~[quartz-1.8.6.jar:na]
at
org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:822)
~[quartz-1.8.6.jar:na]
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:243)
~[quartz-1.8.6.jar:na]
at
org.syncope.core.init.JobInstanceLoader.registerJob(JobInstanceLoader.java:134)
~[JobInstanceLoader.class:na]
at
org.syncope.core.init.JobInstanceLoader.registerJob(JobInstanceLoader.java:162)
~[JobInstanceLoader.class:na]
at
org.syncope.core.init.JobInstanceLoader.load(JobInstanceLoader.java:210)
~[JobInstanceLoader.class:na]
at
org.syncope.core.init.JobInstanceLoader$$FastClassByCGLIB$$edd08387.invoke(<generated>)
[cglib-2.2.2.jar:na]
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
[cglib-2.2.2.jar:na]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira