Hi Ajith, We have observed the same issue reported in [1] .But this was resolved after changing the configs in Event broker.xml and cleaning the external solar data. But not sure it was the cause though. In additional to this it was reported in [2] as well.
[1] https://wso2.org/jira/browse/REGISTRY-2762 [2] https://wso2.org/jira/browse/REGISTRY-2787 Thank you, Chalitha. On Tue, Sep 15, 2015 at 10:12 PM, Ajith Vitharana <[email protected]> wrote: > 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 > > -- *Chalitha Maheshwari* Software Engineer-QA, WSO2 Inc. *E-mail:* [email protected] *Mobile: *+94710 411 112
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
