Hi Denis, any progress about this issue? I cannot reproduce the problem by using oracle 11g as the backend.
Please, let me have a feedback asap. Regartds, F. Il giorno 18/apr/2012, alle ore 13.10, Denis Signoretto ha scritto: > > Trying more, the problem only occurs using OCI driver: > > Our current release is: Oracle JDBC Driver version - "10.2.0.5.0" > > Bye, > Denis. > > > >> -----Messaggio originale----- >> Da: Denis Signoretto (Commented) (JIRA) [mailto:[email protected]] >> Inviato: mercoledì 18 aprile 2012 11.39 >> A: [email protected] >> Oggetto: [jira] [Commented] (SYNCOPE-59) ERROR >> org.syncope.core.init.JobInstanceLoader - While loading >> NotificationJob >> instance - ORA-01002: fetch out of sequence >> >> >> >> [ >> https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atla > ssian.jira.plugin.system.issuetabpanels:comment-> > tabpanel&focusedCommentId=13256389#comment-13256389 ] >> >> Denis Signoretto commented on SYNCOPE-59: >> ----------------------------------------- >> >> Hi Fabio, >> >> I tryed various combinations and I found that using thin >> client and excluding >> usage of jdbc/syncopeDataSource connection pool the error disappear. >> >> Are you able to reproduce the error using OCI and jndi >> Connection Pool? >> >> Thanks, >> Denis. >> >> va.lang.Exception >> >> >>> 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 >>> Labels: oracle >>> >>> 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(St >> dRowLockSemaphore.java:109) ~[quartz-1.8.6.jar:na] >>> at >> org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphor >> e.java:112) ~[quartz-1.8.6.jar:na] >>> at >> org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStor >> eCMT.java:235) ~[quartz-1.8.6.jar:na] >>> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(Job >> StoreSupport.java:3712) ~[quartz-1.8.6.jar:na] >>> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigge >> r(JobStoreSupport.java:1059) ~[quartz-1.8.6.jar:na] >>> at >> org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.ja >> va: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(JobInstanc >> eLoader.java:134) ~[JobInstanceLoader.class:na] >>> at >> org.syncope.core.init.JobInstanceLoader.registerJob(JobInstanc >> eLoader.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$$edd >> 08387.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!de > fault.jspa > For more information on JIRA, see: http://www.atlassian.com/software/jira > >
