This is not solr related thing. According to the stack trace human task scheduler jobs are not properly terminate with the server shutdown.
-Ajith On Wed, Sep 16, 2015 at 1:02 AM, Chalitha Waldeniyage <[email protected]> wrote: > 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 > -- 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
