Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

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