Observed same issue today henced create a JIRA https://wso2.org/jira/browse/IDENTITY-3580
-Ajith On Thu, Sep 10, 2015 at 1:28 PM, Ajith Vitharana <[email protected]> wrote: > Hi All. > > > [2015-09-10 13:21:42,373] ERROR > {org.wso2.carbon.humantask.core.scheduler.SimpleScheduler} - Error loading > immediate jobs from database. > <openjpa-2.2.0-wso2v1-r128166:129108 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Database is already > closed (to disable automatic closing at VM shutdown, add > ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-140] {SELECT t0.id, > t0.JOB_DETAILS, t0.JOB_NAME, t0.NODEID, t0.SCHEDULED, t0.TASKID, > t0.JOB_TIME, t0.TRANSACTED, t0.JOB_TYPE FROM HT_JOB t0 WHERE (t0.NODEID = ? > AND t0.JOB_TIME < ?) ORDER BY t0.JOB_TIME ASC LIMIT ?} [code=90121, > state=90121] > FailedObject: SELECT DISTINCT t FROM > org.wso2.carbon.humantask.core.dao.jpa.openjpa.model.HumanTaskJob t WHERE > t.nodeId = ?1 AND t.time < ?2 order by t.time [java.lang.String] > at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918) > at > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70) > at > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155) > at > org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40) > at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) > at > org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542) > at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286) > at > org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302) > at > org.wso2.carbon.humantask.core.dao.jpa.openjpa.HumanTaskDAOConnectionImpl.dequeueImmediate(HumanTaskDAOConnectionImpl.java:248) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$2.call(SimpleScheduler.java:344) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$2.call(SimpleScheduler.java:342) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler.execTransaction(SimpleScheduler.java:881) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler.execTransaction(SimpleScheduler.java:830) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:342) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:297) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$1.call(SimpleScheduler.java:149) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$1.call(SimpleScheduler.java:146) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Database is > already closed (to disable automatic closing at VM shutdown, add > ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-140] {SELECT t0.id, > t0.JOB_DETAILS, t0.JOB_NAME, t0.NODEID, t0.SCHEDULED, t0.TASKID, > t0.JOB_TIME, t0.TRANSACTED, t0.JOB_TYPE FROM HT_JOB t0 WHERE (t0.NODEID = ? > AND t0.JOB_TIME < ?) ORDER BY t0.JOB_TIME ASC LIMIT ?} [code=90121, > state=90121] > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247) > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:227) > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:72) > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:279) > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1622) > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:449) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:429) > at > org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:479) > at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:420) > at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382) > at > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) > at > org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34) > ... 20 more > NestedThrowables: > org.h2.jdbc.JdbcSQLException: Database is already closed (to disable > automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db > URL) [90121-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at org.h2.message.DbException.get(DbException.java:133) > at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1348) > at org.h2.jdbc.JdbcConnection.checkClosed(JdbcConnection.java:1323) > at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:598) > at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.wso2.carbon.ndatasource.rdbms.ConnectionRollbackOnReturnInterceptor.invoke(ConnectionRollbackOnReturnInterceptor.java:51) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) > at > org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) > at > org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) > at com.sun.proxy.$Proxy16.prepareStatement(Unknown Source) > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:135) > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:276) > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1622) > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:449) > at > org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:429) > at > org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:479) > at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:420) > at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382) > at > org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94) > at > org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34) > at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) > at > org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542) > at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286) > at > org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302) > at > org.wso2.carbon.humantask.core.dao.jpa.openjpa.HumanTaskDAOConnectionImpl.dequeueImmediate(HumanTaskDAOConnectionImpl.java:248) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$2.call(SimpleScheduler.java:344) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$2.call(SimpleScheduler.java:342) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler.execTransaction(SimpleScheduler.java:881) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler.execTransaction(SimpleScheduler.java:830) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:342) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:297) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$1.call(SimpleScheduler.java:149) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$1.call(SimpleScheduler.java:146) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > [2015-09-10 13:21:42,378] ERROR > {org.wso2.carbon.humantask.core.scheduler.SimpleScheduler} - Error during > SchedulerTask execution > java.lang.NullPointerException > at > org.eclipse.osgi.internal.loader.BundleLoader.createExportPackageSource(BundleLoader.java:271) > at > org.eclipse.osgi.internal.loader.BundleLoader.findDynamicSource(BundleLoader.java:1169) > at > org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:469) > at > org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421) > at > org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412) > at > org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107) > at java.lang.ClassLoader.loadClass(ClassLoader.java:358) > at > org.apache.solr.logging.log4j.EventAppender.append(EventAppender.java:35) > at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251) > at > org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66) > at org.apache.log4j.Category.callAppenders(Category.java:206) > at org.apache.log4j.Category.forcedLog(Category.java:391) > at org.apache.log4j.Category.log(Category.java:856) > at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:229) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:392) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:297) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$1.call(SimpleScheduler.java:149) > at > org.wso2.carbon.humantask.core.scheduler.SimpleScheduler$1.call(SimpleScheduler.java:146) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > [2015-09-10 13:21:42,625] INFO > {org.wso2.carbon.core.init.CarbonServerManager} - Shutdown complete > [2015-09-10 13:21:42,625] INFO > {org.wso2.carbon.core.init.CarbonServerManager} - Halting JVM > > -Ajith > > > -- > Ajith Vitharana. > > WSO2 Inc. - http://wso2.com > Email : [email protected] > Blog : http://vitharana.org > Mobile : +1-812-360-5335 > > -- Ajith Vitharana. WSO2 Inc. - http://wso2.com Email : [email protected] Blog : http://vitharana.org Mobile : +1-812-360-5335
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
