Quartz scheduler error

salvotop
2012-03-01
2013-03-19
  • salvotop

    salvotop - 2012-03-01

    Hi Sasa,

    after rebuild all, something happened in my project, because at startup, i get the error above in stack.
    SharkWebClient starts and apparently runs well, but i'd like to solve the error.

    Im using Oracle DB, not HSQL, but, reading error, Quatrz Scheduler seems to search hsql db…any idea ?

    tnx
    salnic

    Quartz Scheduler has been initialized...
    Starting Quartz Scheduler...
    - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 2sa1l28l1lc1cmxb4b84i|1e5add3, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.hsqldb.jdbcDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2sa1l28l1lc1cmxb4b84i|1e5add3, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:hsqldb:E:/Progetti/U4U/sharkwf/SharkWebClient/application/bin/application/webapps/sharkWebClient/hsql/hsql, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 96, maxStatements -> 0, maxStatementsPerConnection -> 120, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
    - checkpointClose start
    - checkpointClose end
    Quartz Scheduler failed to start: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: user lacks privilege or object not found: QRTZ_TRIGGERS [See nested exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: QRTZ_TRIGGERS]]
    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: user lacks privilege or object not found: QRTZ_TRIGGERS [See nested exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: QRTZ_TRIGGERS]]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:683)
        at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:526)
        at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
        at org.enhydra.shark.utilities.QuartzInitializer.startQuartzScheduler(QuartzInitializer.java:92)
        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:563)
        at org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:1057)
        at org.enhydra.shark.SharkEngineManager.configure(SharkEngineManager.java:686)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.enhydra.shark.Shark._conf(Shark.java:149)
        at org.enhydra.shark.Shark.configure(Shark.java:76)
        at org.enhydra.shark.client.utilities.SharkInterfaceWrapper.getShark(SharkInterfaceWrapper.java:211)
        at org.enhydra.shark.webclient.SharkWebClient.startup(SharkWebClient.java:218)
        at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.changeToRunningState(Unknown Source)
        at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.ensureAppIsRunning(Unknown Source)
        at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.init(Unknown Source)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1216)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1135)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
        at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
        at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)
    Caused by: org.quartz.JobPersistenceException: Couldn't recover jobs: user lacks privilege or object not found: QRTZ_TRIGGERS [See nested exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: QRTZ_TRIGGERS]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:889)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.execute(JobStoreSupport.java:827)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$46.execute(JobStoreSupport.java:3776)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3810)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3772)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:823)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:681)
        ... 28 more
    Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: QRTZ_TRIGGERS
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooStatementCache.java:525)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
    Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: QRTZ_TRIGGERS
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.SchemaManager.getTable(Unknown Source)
        at org.hsqldb.ParserDQL.readTableName(Unknown Source)
        at org.hsqldb.ParserDQL.readSimpleRangeVariable(Unknown Source)
        at org.hsqldb.ParserDML.compileUpdateStatement(Unknown Source)
        at org.hsqldb.ParserCommand.compilePart(Unknown Source)
        at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
        at org.hsqldb.Session.compileStatement(Unknown Source)
        at org.hsqldb.StatementManager.compile(Unknown Source)
        at org.hsqldb.Session.execute(Unknown Source)
        ... 8 more
    
     
  • Sasa Bojanic

    Sasa Bojanic - 2012-03-08

    Hi,

    you can either turn-off the quartz functionality if you do not use it (in Shark.conf, set SharkKernel.useQuartz=false) or look at the end of sharkwebclient/conf/quartz..properties file to set-up database correctly.

    Regards,
    Sasa.

     
  • salvotop

    salvotop - 2012-03-08

    Tnx Sasa

    i resolved setting quartz..properties file correctly.
    tnx
    salnic

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks