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

["fabio martelli (Commented) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256380#comment-13256380 ] 

fabio martelli commented on SYNCOPE-59:
---------------------------------------

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




                
> 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(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