Hi Denis, I've just tried to reproduce the problem. Following the steps performed: 1. create a new project [1] 2. change to use oracle ad backend [2] 3. deploy syncope and syncope-console 4. start container 5. shutdown and startup again
The problem has not been reproduced. Please, let me know if I missed some steps. Regards, F. [1] https://cwiki.apache.org/confluence/display/SYNCOPE/Create+a+new+Syncope+project [2] https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments#RunSyncopeinrealenvironments-Oracle Il giorno 17/apr/2012, alle ore 18.08, Denis Signoretto (Created) (JIRA) ha scritto: > 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 > >
