[SYNCOPE-59] ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob instance - ORA-01002: fetch out of sequence

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 1.0.0-incubating
• Component/s: core
• Labels: oracle
• Environment: Oracle 10g, Linux x86_64, OCI
• Assignee: Fabio Martelli
• Reporter: Denis Signoretto
• Created: 17/Apr/12 16:06
• Updated: 22/Oct/14 06:42
• Resolved: 20/Apr/12 15:09

Description

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]

Issue Links

• relates to: SYNCOPE-61 WARNING: DB connection abandoned