You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "Denis Signoretto (Created) (JIRA)" <ji...@apache.org> on 2012/04/17 18:08:16 UTC
[jira] [Created] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
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
R: [jira] [Created] (SYNCOPE-59) ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob instance - ORA-01002: fetch out of sequence
Posted by Denis Signoretto <de...@intesys.it>.
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.
> -----Messaggio originale-----
> Da: Denis Signoretto [mailto:denis.signoretto@intesys.it]
> Inviato: mercoledì 18 aprile 2012 11.01
> A: syncope-dev@incubator.apache.org
> Oggetto: R: [jira] [Created] (SYNCOPE-59) ERROR
> org.syncope.core.init.JobInstanceLoader - While loading
> NotificationJob
> instance - ORA-01002: fetch out of sequence
>
>
>
> Hi Fabio,
>
> for completeness, we are using:
>
> as Database: Oracle Database 10g Release 10.2.0.3.0 - 64bit
> Production,
> and we are accessing to DB with this settings (by OCI Driver).
>
> <Resource name="jdbc/syncopeDataSource" auth="Container"
> type="javax.sql.DataSource"
>
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> testWhileIdle="true"
> testOnBorrow="true" testOnReturn="true"
> validationQuery="SELECT 1 FROM DUAL" validationInterval="30000"
> maxActive="150" minIdle="2" maxWait="10000"
> initialSize="2" removeAbandonedTimeout="10"
> removeAbandoned="true" logAbandoned="true"
> suspectTimeout="10"
> timeBetweenEvictionRunsMillis="5000"
> minEvictableIdleTimeMillis="5000"
>
> jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.Conn
> ectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementF
> inalizer"
> username="xxxxx" password="xxxxx"
> driverClassName="oracle.jdbc.OracleDriver"
> url="jdbc:oracle:oci:@ORACLE" />
>
> Do you think, we should try excluding connection pool and
> switching to thin client (without Oracle OCI driver)?
> What Oracle configuration are you using?
>
> Thanks,
> Denis.
>
> P.S. Further more at startup we have a warning on connection
> pool abandoned (probably it doesn't matter)
>
> Apr 18, 2012 10:55:26 AM
> org.apache.tomcat.jdbc.pool.ConnectionPool abandon
> WARNING: Connection has been abandoned
> PooledConnection[oracle.jdbc.driver.T2CConnection@305bf465]:ja
va.lang.Exception
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(Conne
> ctionPool.java:1006)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(Co
> nnectionPool.java:735)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(Co
> nnectionPool.java:591)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(Conne
> ctionPool.java:179)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(Data
> SourceProxy.java:124)
> at
> ch.qos.logback.core.db.JNDIConnectionSource.getConnection(JNDI
> ConnectionSource.java:69)
>
> > -----Messaggio originale-----
> > Da: Fabio Martelli [mailto:fabio.martelli@gmail.com]
> > Inviato: mercoledì 18 aprile 2012 10.47
> > A: syncope-dev@incubator.apache.org
> > Oggetto: Re: [jira] [Created] (SYNCOPE-59) ERROR
> > org.syncope.core.init.JobInstanceLoader - While loading
> > NotificationJob
> > instance - ORA-01002: fetch out of sequence
> >
> >
> > 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+n
> > ew+Syncope+project
> > [2]
> > https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncop
> > e+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(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
> >
> >
>
>
R: [jira] [Created] (SYNCOPE-59) ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob instance - ORA-01002: fetch out of sequence
Posted by Denis Signoretto <de...@intesys.it>.
Hi Fabio,
for completeness, we are using:
as Database: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production,
and we are accessing to DB with this settings (by OCI Driver).
<Resource name="jdbc/syncopeDataSource" auth="Container" type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true"
testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1 FROM DUAL" validationInterval="30000"
maxActive="150" minIdle="2" maxWait="10000" initialSize="2" removeAbandonedTimeout="10"
removeAbandoned="true" logAbandoned="true" suspectTimeout="10"
timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="xxxxx" password="xxxxx" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:oci:@ORACLE" />
Do you think, we should try excluding connection pool and switching to thin client (without Oracle OCI driver)?
What Oracle configuration are you using?
Thanks,
Denis.
P.S. Further more at startup we have a warning on connection pool abandoned (probably it doesn't matter)
Apr 18, 2012 10:55:26 AM org.apache.tomcat.jdbc.pool.ConnectionPool abandon
WARNING: Connection has been abandoned PooledConnection[oracle.jdbc.driver.T2CConnection@305bf465]:java.lang.Exception
at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1006)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:735)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:591)
at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:179)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:124)
at ch.qos.logback.core.db.JNDIConnectionSource.getConnection(JNDIConnectionSource.java:69)
> -----Messaggio originale-----
> Da: Fabio Martelli [mailto:fabio.martelli@gmail.com]
> Inviato: mercoledì 18 aprile 2012 10.47
> A: syncope-dev@incubator.apache.org
> Oggetto: Re: [jira] [Created] (SYNCOPE-59) ERROR
> org.syncope.core.init.JobInstanceLoader - While loading
> NotificationJob
> instance - ORA-01002: fetch out of sequence
>
>
> 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+n
> ew+Syncope+project
> [2]
> https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncop
> e+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(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
>
>
Re: [jira] [Created] (SYNCOPE-59) ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob instance - ORA-01002: fetch out of sequence
Posted by Fabio Martelli <fa...@gmail.com>.
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
>
>
Re: [jira] [Commented] (SYNCOPE-59) ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob instance - ORA-01002: fetch out of sequence
Posted by Fabio Martelli <fa...@gmail.com>.
Il giorno 18/apr/2012, alle ore 13.11, Denis Signoretto (Commented) (JIRA) ha scritto:
>
> [ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256443#comment-13256443 ]
>
> Denis Signoretto commented on SYNCOPE-59:
> -----------------------------------------
>
>
> Trying more, the problem only occurs using OCI driver:
>
> Our current release is: Oracle JDBC Driver version - "10.2.0.5.0"
>
Hi Denis,
I cannot reproduce the problem.
I made my check by using oracle 11 and the relative instant client.
My datasource configuration is the following
<Resource name="jdbc/syncopeDataSource" auth="Container" type="javax.sql.DataSource"^M
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true"^M
testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1 FROM DUAL" validationInterval="30000"^M
maxActive="150" minIdle="2" maxWait="10000" initialSize="2" removeAbandonedTimeout="10"^M
removeAbandoned="true" logAbandoned="true" suspectTimeout="10"^M
timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"^M
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"^M
username="syncope" password="syncope" driverClassName="oracle.jdbc.OracleDriver"^M
url="jdbc:oracle:oci:@pioppo:1521:orcl" />
Probably, apart the oracle version, the difference between my configuration and yours in into the jdbc url. Did you use a tnsnames.ora file for your connection?
Could you try with a "legacy" jdbc url?
Cheers,
F.
> Bye,
> Denis.
>
>
>
> ssian.jira.plugin.system.issuetabpanels:comment-> tabpanel&focusedCommentId=13256389#comment-13256389 ]
> fault.jspa
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>
>
>> 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
>> Assignee: fabio martelli
>> 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
>
>
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Denis Signoretto (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256443#comment-13256443 ]
Denis Signoretto commented on SYNCOPE-59:
-----------------------------------------
Trying more, the problem only occurs using OCI driver:
Our current release is: Oracle JDBC Driver version - "10.2.0.5.0"
Bye,
Denis.
ssian.jira.plugin.system.issuetabpanels:comment-> tabpanel&focusedCommentId=13256389#comment-13256389 ]
fault.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
> 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
> Assignee: fabio martelli
> 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
R: Error creating user schema attributes from console - java.lang.NoSuchMethodError: org.apache.syncope.client.to.SchemaTO.getEnumerationKeys()Ljava/lang/String;
Posted by Denis Signoretto <de...@intesys.it>.
Hi Fabio,
After re-build form scratch and cleaning local maven repository
it works.
Thanks,
denis.
> -----Messaggio originale-----
> Da: Fabio Martelli [mailto:fabio.martelli@gmail.com]
> Inviato: venerdì 20 aprile 2012 10.22
> A: syncope-dev@incubator.apache.org
> Oggetto: Re: Error creating user schema attributes from console -
> java.lang.NoSuchMethodError:
> org.apache.syncope.client.to.SchemaTO.getEnumerationKeys()Ljav
> a/lang/Str
> ing;
>
>
>
> Il giorno 20/apr/2012, alle ore 10.12, Denis Signoretto ha scritto:
>
> > Hi,
> >
> > I have rebuild syncope project from scratch. I get this
> error when I try creating new user schema attribute.
> > Could be related to improvement issue
> https://issues.apache.org/jira/browse/SYNCOPE-62 or I'm doing
> something wrong ?
>
> It seems that you are using an old client module.
> Could you verify?
>
> Regards,
> F.
>
> > 10:02:09.996 ERROR
> org.apache.syncope.console.SyncopeRequestCycleListener -
> Exception found
> > org.apache.wicket.WicketRuntimeException: Method onRequest
> of interface org.apache.wicket.behavior.IBehaviorListener
> targeted at org.apache.wicket.ajax.markup.html.AjaxLink$1
> {event='onclick'} on component [ [Component id =
> createUserSchemaWinLink]] threw an exception
> > at
> org.apache.wicket.RequestListenerInterface.internalInvoke(Requ
> estListenerInterface.java:270) ~[wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.RequestListenerInterface.invoke(RequestListe
> nerInterface.java:241) ~[wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.request.handler.ListenerInterfaceRequestHand
> ler.invokeListener(ListenerInterfaceRequestHandler.java:255)
> ~[wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.request.handler.ListenerInterfaceRequestHand
> ler.respond(ListenerInterfaceRequestHandler.java:234)
> ~[wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.r
> espond(RequestCycle.java:781) ~[wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.request.RequestHandlerStack.execute(RequestH
> andlerStack.java:64) ~[wicket-request-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCy
> cle.java:255) [wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.request.cycle.RequestCycle.processRequest(Re
> questCycle.java:212) [wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.request.cycle.RequestCycle.processRequestAnd
> Detach(RequestCycle.java:283) [wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.protocol.http.WicketFilter.processRequest(Wi
> cketFilter.java:185) [wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFi
> lter.java:241) [wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> er(ApplicationFilterChain.java:243) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> cationFilterChain.java:210) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.java:224) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.java:169) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Aut
> henticatorBase.java:472) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:168) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:98) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv
> e.java:927) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java:118) [catalina.jar:7.0.26]
> > at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap
> ter.java:407) [catalina.jar:7.0.26]
> > at
> org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.
> java:197) [tomcat-coyote.jar:7.0.26]
> > at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.p
> rocess(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.26]
> > at
> org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProces
> sor.run(AprEndpoint.java:1763) [tomcat-coyote.jar:7.0.26]
> > at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadP
> oolExecutor.java:886) [na:1.6.0_31]
> > at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolE
> xecutor.java:908) [na:1.6.0_31]
> > at java.lang.Thread.run(Thread.java:662) [na:1.6.0_31]
> > Caused by: java.lang.reflect.InvocationTargetException: null
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.6.0_31]
> > at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess
> orImpl.java:39) ~[na:1.6.0_31]
> > at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth
> odAccessorImpl.java:25) ~[na:1.6.0_31]
> > at java.lang.reflect.Method.invoke(Method.java:597)
> ~[na:1.6.0_31]
> > at
> org.apache.wicket.RequestListenerInterface.internalInvoke(Requ
> estListenerInterface.java:260) ~[wicket-core-1.5.5.jar:1.5.5]
> > ... 26 common frames omitted
> > Caused by: java.lang.NoSuchMethodError:
> org.apache.syncope.client.to.SchemaTO.getEnumerationKeys()Ljav
> a/lang/String;
> > at
> org.apache.syncope.console.pages.SchemaModalPage.setSchemaModa
> lPage(SchemaModalPage.java:121) ~[SchemaModalPage.class:na]
> > at
> org.apache.syncope.console.pages.Schema$3$1.createPage(Schema.
> java:842) ~[Schema$3$1.class:na]
> > at
> org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindo
> w.createPage(ModalWindow.java:807)
> ~[wicket-extensions-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindo
> w.getWindowOpenJavaScript(ModalWindow.java:1054)
> ~[wicket-extensions-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindo
> w.show(ModalWindow.java:357) ~[wicket-extensions-1.5.5.jar:1.5.5]
> > at
> org.apache.syncope.console.pages.Schema$3.onClick(Schema.java:
> 848) ~[Schema$3.class:na]
> > at
> org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink
> .java:86) ~[wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBeha
> vior.java:184) ~[wicket-core-1.5.5.jar:1.5.5]
> > at
> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(A
> bstractDefaultAjaxBehavior.java:369) ~[wicket-core-1.5.5.jar:1.5.5]
> > ... 31 common frames omittedextensions-1.5.5.j
> >
> > Thanks,
> > Denis.
>
>
Re: Error creating user schema attributes from console - java.lang.NoSuchMethodError: org.apache.syncope.client.to.SchemaTO.getEnumerationKeys()Ljava/lang/String;
Posted by Fabio Martelli <fa...@gmail.com>.
Il giorno 20/apr/2012, alle ore 10.12, Denis Signoretto ha scritto:
> Hi,
>
> I have rebuild syncope project from scratch. I get this error when I try creating new user schema attribute.
> Could be related to improvement issue https://issues.apache.org/jira/browse/SYNCOPE-62 or I'm doing something wrong ?
It seems that you are using an old client module.
Could you verify?
Regards,
F.
> 10:02:09.996 ERROR org.apache.syncope.console.SyncopeRequestCycleListener - Exception found
> org.apache.wicket.WicketRuntimeException: Method onRequest of interface org.apache.wicket.behavior.IBehaviorListener targeted at org.apache.wicket.ajax.markup.html.AjaxLink$1 {event='onclick'} on component [ [Component id = createUserSchemaWinLink]] threw an exception
> at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:270) ~[wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:241) ~[wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.request.handler.ListenerInterfaceRequestHandler.invokeListener(ListenerInterfaceRequestHandler.java:255) ~[wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.request.handler.ListenerInterfaceRequestHandler.respond(ListenerInterfaceRequestHandler.java:234) ~[wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:781) ~[wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64) ~[wicket-request-1.5.5.jar:1.5.5]
> at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:255) [wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:212) [wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:283) [wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:185) [wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:241) [wicket-core-1.5.5.jar:1.5.5]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.26]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.26]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.26]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.26]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.26]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.26]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.26]
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.26]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.26]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.26]
> at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) [tomcat-coyote.jar:7.0.26]
> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.26]
> at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) [tomcat-coyote.jar:7.0.26]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_31]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_31]
> at java.lang.Thread.run(Thread.java:662) [na:1.6.0_31]
> Caused by: java.lang.reflect.InvocationTargetException: null
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_31]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_31]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_31]
> at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_31]
> at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:260) ~[wicket-core-1.5.5.jar:1.5.5]
> ... 26 common frames omitted
> Caused by: java.lang.NoSuchMethodError: org.apache.syncope.client.to.SchemaTO.getEnumerationKeys()Ljava/lang/String;
> at org.apache.syncope.console.pages.SchemaModalPage.setSchemaModalPage(SchemaModalPage.java:121) ~[SchemaModalPage.class:na]
> at org.apache.syncope.console.pages.Schema$3$1.createPage(Schema.java:842) ~[Schema$3$1.class:na]
> at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow.createPage(ModalWindow.java:807) ~[wicket-extensions-1.5.5.jar:1.5.5]
> at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow.getWindowOpenJavaScript(ModalWindow.java:1054) ~[wicket-extensions-1.5.5.jar:1.5.5]
> at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow.show(ModalWindow.java:357) ~[wicket-extensions-1.5.5.jar:1.5.5]
> at org.apache.syncope.console.pages.Schema$3.onClick(Schema.java:848) ~[Schema$3.class:na]
> at org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink.java:86) ~[wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:184) ~[wicket-core-1.5.5.jar:1.5.5]
> at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:369) ~[wicket-core-1.5.5.jar:1.5.5]
> ... 31 common frames omittedextensions-1.5.5.j
>
> Thanks,
> Denis.
Error creating user schema attributes from console - java.lang.NoSuchMethodError: org.apache.syncope.client.to.SchemaTO.getEnumerationKeys()Ljava/lang/String;
Posted by Denis Signoretto <de...@intesys.it>.
Hi,
I have rebuild syncope project from scratch. I get this error when I try creating new user schema attribute.
Could be related to improvement issue https://issues.apache.org/jira/browse/SYNCOPE-62 or I'm doing something wrong ?
10:02:09.996 ERROR org.apache.syncope.console.SyncopeRequestCycleListener - Exception found
org.apache.wicket.WicketRuntimeException: Method onRequest of interface org.apache.wicket.behavior.IBehaviorListener targeted at org.apache.wicket.ajax.markup.html.AjaxLink$1 {event='onclick'} on component [ [Component id = createUserSchemaWinLink]] threw an exception
at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:270) ~[wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:241) ~[wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.request.handler.ListenerInterfaceRequestHandler.invokeListener(ListenerInterfaceRequestHandler.java:255) ~[wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.request.handler.ListenerInterfaceRequestHandler.respond(ListenerInterfaceRequestHandler.java:234) ~[wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:781) ~[wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64) ~[wicket-request-1.5.5.jar:1.5.5]
at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:255) [wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:212) [wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:283) [wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:185) [wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:241) [wicket-core-1.5.5.jar:1.5.5]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.26]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.26]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) [catalina.jar:7.0.26]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) [catalina.jar:7.0.26]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [catalina.jar:7.0.26]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [catalina.jar:7.0.26]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [catalina.jar:7.0.26]
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [catalina.jar:7.0.26]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.26]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [catalina.jar:7.0.26]
at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197) [tomcat-coyote.jar:7.0.26]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote.jar:7.0.26]
at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1763) [tomcat-coyote.jar:7.0.26]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_31]
at java.lang.Thread.run(Thread.java:662) [na:1.6.0_31]
Caused by: java.lang.reflect.InvocationTargetException: null
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_31]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_31]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_31]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_31]
at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:260) ~[wicket-core-1.5.5.jar:1.5.5]
... 26 common frames omitted
Caused by: java.lang.NoSuchMethodError: org.apache.syncope.client.to.SchemaTO.getEnumerationKeys()Ljava/lang/String;
at org.apache.syncope.console.pages.SchemaModalPage.setSchemaModalPage(SchemaModalPage.java:121) ~[SchemaModalPage.class:na]
at org.apache.syncope.console.pages.Schema$3$1.createPage(Schema.java:842) ~[Schema$3$1.class:na]
at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow.createPage(ModalWindow.java:807) ~[wicket-extensions-1.5.5.jar:1.5.5]
at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow.getWindowOpenJavaScript(ModalWindow.java:1054) ~[wicket-extensions-1.5.5.jar:1.5.5]
at org.apache.wicket.extensions.ajax.markup.html.modal.ModalWindow.show(ModalWindow.java:357) ~[wicket-extensions-1.5.5.jar:1.5.5]
at org.apache.syncope.console.pages.Schema$3.onClick(Schema.java:848) ~[Schema$3.class:na]
at org.apache.wicket.ajax.markup.html.AjaxLink$1.onEvent(AjaxLink.java:86) ~[wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:184) ~[wicket-core-1.5.5.jar:1.5.5]
at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:369) ~[wicket-core-1.5.5.jar:1.5.5]
... 31 common frames omittedextensions-1.5.5.j
Thanks,
Denis.
Re: R: [jira] [Commented] (SYNCOPE-59) ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob instance - ORA-01002: fetch out of sequence
Posted by Fabio Martelli <fa...@gmail.com>.
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:jira@apache.org]
>> Inviato: mercoledì 18 aprile 2012 11.39
>> A: syncope-dev@incubator.apache.org
>> 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
>
>
R: [jira] [Commented] (SYNCOPE-59) ERROR org.syncope.core.init.JobInstanceLoader - While loading NotificationJob instance - ORA-01002: fetch out of sequence
Posted by Denis Signoretto <de...@intesys.it>.
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:jira@apache.org]
> Inviato: mercoledì 18 aprile 2012 11.39
> A: syncope-dev@incubator.apache.org
> 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
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Denis Signoretto (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.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(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
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Denis Signoretto (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13282383#comment-13282383 ]
Denis Signoretto commented on SYNCOPE-59:
-----------------------------------------
Searching on Oracle Metalink, the issues it's related to a know Oracle JDBC and OCI Bug.
As reported in the Oracle Note 1160014.1:
- Applies to: JDBC - Version: 10.1.0.3.0 and later [Release: and later ] When executing a SELECT FOR UPDATE through the OCI JDBC driver with the 'Auto Commit' enabled, following error is reported: java.sql.SQLException: ORA-01002: fetch out of sequence. The same problem is not seen using Oracle Thin drivers.
- Solution
An internal bug exists for this issue and it has been fixed in JDBC 11g.
There are multiple solutions to this issue:
a) Use the 11g version of JDBC-OCI.
Install an Oracle 11g client. Either 11.1.0.7.0 or above should be fine. Make sure to install this into a seperate ORACLE_HOME and not in the same home as the 10g client.
According to the below note:
Note 207303.1 - Client / Server / Interoperability Support Between Different Oracle Versions
11g clients supported/certified against 10g database if database has a minimum version of 10.2.0.2.
b) Use Oracle JDBC Thin Driver 10.2.0.1 or above.
c) If you do not wish to upgrade to the 11g drivers or if you do not want to change to thin drivers, raise a SR with Oracle Software Support and request for a one-off patch for the version of JDBC OCI driver that you are using.
> 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, OCI
> Reporter: Denis Signoretto
> Assignee: fabio martelli
> 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
[jira] [Assigned] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "fabio martelli (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
fabio martelli reassigned SYNCOPE-59:
-------------------------------------
Assignee: fabio martelli
> 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
> Assignee: fabio martelli
> 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
[jira] [Resolved] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Francesco Chicchiriccò (Resolved JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francesco Chicchiriccò resolved SYNCOPE-59.
-------------------------------------------
Resolution: Cannot Reproduce
Syncope has been verified to be working with OCI driver 11 on Oracle 11g.
> 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, OCI
> Reporter: Denis Signoretto
> Assignee: fabio martelli
> 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
[jira] [Updated] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Francesco Chicchiriccò (Updated JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francesco Chicchiriccò updated SYNCOPE-59:
------------------------------------------
Due Date: (was: 17/Apr/12)
Priority: Major (was: Critical)
Environment: Oracle 10g, Linux x86_64, OCI (was: Oracle 10g, Linux x86_64, )
> 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, OCI
> Reporter: Denis Signoretto
> Assignee: fabio martelli
> 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
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "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
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "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=13258052#comment-13258052 ]
fabio martelli commented on SYNCOPE-59:
---------------------------------------
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.
> 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
> Assignee: fabio martelli
> 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
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Denis Signoretto (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256382#comment-13256382 ]
Denis Signoretto commented on SYNCOPE-59:
-----------------------------------------
Hi Fabio,
for completeness, we are using:
as Database: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production,
and we are accessing to DB with this settings (by OCI Driver).
<Resource name="jdbc/syncopeDataSource" auth="Container" type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true"
testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1 FROM DUAL" validationInterval="30000"
maxActive="150" minIdle="2" maxWait="10000" initialSize="2" removeAbandonedTimeout="10"
removeAbandoned="true" logAbandoned="true" suspectTimeout="10"
timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="xxxxx" password="xxxxx" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:oci:@ORACLE" />
Do you think, we should try excluding connection pool and switching to thin client (without Oracle OCI driver)?
What Oracle configuration are you using?
Thanks,
Denis.
P.S. Further more at startup we have a warning on connection pool abandoned (probably it doesn't matter)
Apr 18, 2012 10:55:26 AM org.apache.tomcat.jdbc.pool.ConnectionPool abandon
WARNING: Connection has been abandoned PooledConnection[oracle.jdbc.driver.T2CConnection@305bf465]:java.lang.Exception
at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1006)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:735)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:591)
at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:179)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:124)
at ch.qos.logback.core.db.JNDIConnectionSource.getConnection(JNDIConnectionSource.java:69)
fault.jspa
> 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
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "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=13256536#comment-13256536 ]
fabio martelli commented on SYNCOPE-59:
---------------------------------------
Hi Denis,
I cannot reproduce the problem.
I made my check by using oracle 11 and the relative instant client.
My datasource configuration is the following
<Resource name="jdbc/syncopeDataSource" auth="Container" type="javax.sql.DataSource"^M
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true"^M
testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1 FROM DUAL" validationInterval="30000"^M
maxActive="150" minIdle="2" maxWait="10000" initialSize="2" removeAbandonedTimeout="10"^M
removeAbandoned="true" logAbandoned="true" suspectTimeout="10"^M
timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"^M
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"^M
username="syncope" password="syncope" driverClassName="oracle.jdbc.OracleDriver"^M
url="jdbc:oracle:oci:@pioppo:1521:orcl" />
Probably, apart the oracle version, the difference between my configuration and yours in into the jdbc url. Did you use a tnsnames.ora file for your connection?
Could you try with a "legacy" jdbc url?
Cheers,
F.
> 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
> Assignee: fabio martelli
> 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
[jira] [Closed] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francesco Chicchiriccò closed SYNCOPE-59.
-----------------------------------------
Bulk closing for 1.0.0-RC1-incubating
> 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, OCI
> Reporter: Denis Signoretto
> Assignee: fabio martelli
> 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
[jira] [Commented] (SYNCOPE-59) ERROR
org.syncope.core.init.JobInstanceLoader - While loading NotificationJob
instance - ORA-01002: fetch out of sequence
Posted by "Denis Signoretto (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SYNCOPE-59?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13258247#comment-13258247 ]
Denis Signoretto commented on SYNCOPE-59:
-----------------------------------------
Hi Fabio,
the error disappear using Thin Client. I tried with different jdbc connection url but every time we use OCI the problem occurs.
So at the moment, the a possible workaround is avoid using OCI driver.
> 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
> Assignee: fabio martelli
> 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