Error querying database. Cause: java.lang.NullPointerException

[Bernd Rücker (camunda)]

Hey guys.

 

I just saw this exception in my jboss distro after starting it up. But just one time. Cannot reproduce. But pretty wired?! Primary I wanted to post that here to see if that happens more often so we have to have a look. At the moment I think we have a bad moon and it was some strange thing with my H2…

 

Cheers

Bernd

 

12:14:00,492 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (http-/127.0.0.1:8080-5) Deploying javax.ws.rs.core.Application: class org.camunda.bpm.webapp.impl.engine.EngineRestApplication

12:14:03,284 INFO  [org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher] (http-/127.0.0.1:8080-5) Deploying javax.ws.rs.core.Application: class org.camunda.bpm.admin.impl.web.AdminApplication

12:14:03,471 SEVERE [org.camunda.bpm.engine.impl.interceptor.CommandContext] (http-/127.0.0.1:8080-3) Error while closing command context: org.apache.ibatis.exceptions.PersistenceException:

### Error querying database.  Cause: java.lang.NullPointerException

### Cause: java.lang.NullPointerException

                at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)

                at org.camunda.bpm.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:335) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.persistence.entity.TaskManager.findTaskCountByQueryCriteria(TaskManager.java:115) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.TaskQueryImpl.executeCount(TaskQueryImpl.java:433) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:143) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.impl.AbstractQuery.count(AbstractQuery.java:130) [camunda-engine-7.0.0-SNAPSHOT.jar:]

                at org.camunda.bpm.engine.rest.impl.TaskRestServiceImpl.queryTasksCount(TaskRestServiceImpl.java:89) [camunda-engine-rest-7.0.0-SNAPSHOT-classes.jar:]

                at org.camunda.bpm.engine.rest.impl.TaskRestServiceImpl.getTasksCount(TaskRestServiceImpl.java:81) [camunda-engine-rest-7.0.0-SNAPSHOT-classes.jar:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_21]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_21]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_21]

                at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_21]

                at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:152) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:91) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.3.Final.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.3.Final.jar:]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.1.Final.jar:1.0.1.Final]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final.jar:]

                at org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:47) [camunda-engine-rest-7.0.0-SNAPSHOT-classes.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final.jar:]

                at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilterSecure(SecurityFilter.java:62) [classes:]

                at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilter(SecurityFilter.java:51) [classes:]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final.jar:]

                at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:62) [classes:]

                at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:59) [classes:]

                at org.camunda.bpm.webapp.impl.security.SecurityActions.runWithAuthentications(SecurityActions.java:38) [classes:]

                at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:59) [classes:]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.17.Final.jar:]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:165) [jboss-as-web-7.1.3.Final.jar:7.1.3.Final]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.17.Final.jar:]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:372) [jbossweb-7.0.17.Final.jar:]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.17.Final.jar:]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679) [jbossweb-7.0.17.Final.jar:]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931) [jbossweb-7.0.17.Final.jar:]

                at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_21]

Caused by: java.lang.NullPointerException

                at org.apache.ibatis.reflection.property.PropertyTokenizer.<init>(PropertyTokenizer.java:27)

                at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:114)

                at org.apache.ibatis.builder.xml.dynamic.DynamicContext$ContextMap.get(DynamicContext.java:89)

                at org.apache.ibatis.builder.xml.dynamic.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:107)

                at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1657)

                at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:92)

                at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)

                at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)

                at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:49)

                at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)

                at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)

                at org.apache.ibatis.ognl.ASTOr.getValueBody(ASTOr.java:56)

                at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)

                at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)

                at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:333)

                at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:413)

                at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:395)

                at org.apache.ibatis.builder.xml.dynamic.OgnlCache.getValue(OgnlCache.java:42)

                at org.apache.ibatis.builder.xml.dynamic.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)

                at org.apache.ibatis.builder.xml.dynamic.IfSqlNode.apply(IfSqlNode.java:30)

                at org.apache.ibatis.builder.xml.dynamic.MixedSqlNode.apply(MixedSqlNode.java:29)

                at org.apache.ibatis.builder.xml.dynamic.MixedSqlNode.apply(MixedSqlNode.java:29)

                at org.apache.ibatis.builder.xml.dynamic.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:37)

                at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:241)

                at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:79)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)

                ... 55 more

 

12:14:03,565 WARNING [ExceptionHandler] (http-/127.0.0.1:8080-3) org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception

                at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:193)

                at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)

                at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59)

                at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)

                at org.camunda.bpm.engine.impl.AbstractQuery.count(AbstractQuery.java:130)

                at org.camunda.bpm.engine.rest.impl.TaskRestServiceImpl.queryTasksCount(TaskRestServiceImpl.java:89)

                at org.camunda.bpm.engine.rest.impl.TaskRestServiceImpl.getTasksCount(TaskRestServiceImpl.java:81)

                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.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)

                at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)

                at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:152)

                at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:91)

                at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

                at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

                at org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:47)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

                at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilterSecure(SecurityFilter.java:62)

                at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilter(SecurityFilter.java:51)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

                at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:62)

                at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:59)

                at org.camunda.bpm.webapp.impl.security.SecurityActions.runWithAuthentications(SecurityActions.java:38)

                at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:59)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:165)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:372)

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:679)

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:931)

                at java.lang.Thread.run(Thread.java:722)

Caused by: org.apache.ibatis.exceptions.PersistenceException:

### Error querying database.  Cause: java.lang.NullPointerException

### Cause: java.lang.NullPointerException

                at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)

                at org.camunda.bpm.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:335)

                at org.camunda.bpm.engine.impl.persistence.entity.TaskManager.findTaskCountByQueryCriteria(TaskManager.java:115)

                at org.camunda.bpm.engine.impl.TaskQueryImpl.executeCount(TaskQueryImpl.java:433)

                at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:143)

                at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)

                at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)

                ... 47 more

Caused by: java.lang.NullPointerException

                at org.apache.ibatis.reflection.property.PropertyTokenizer.<init>(PropertyTokenizer.java:27)

                at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:114)

                at org.apache.ibatis.builder.xml.dynamic.DynamicContext$ContextMap.get(DynamicContext.java:89)

                at org.apache.ibatis.builder.xml.dynamic.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:107)

                at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1657)

                at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:92)

                at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)

                at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)

                at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:49)

                at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)

                at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)

                at org.apache.ibatis.ognl.ASTOr.getValueBody(ASTOr.java:56)

                at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)

                at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)

                at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:333)

                at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:413)

                at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:395)

                at org.apache.ibatis.builder.xml.dynamic.OgnlCache.getValue(OgnlCache.java:42)

                at org.apache.ibatis.builder.xml.dynamic.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)

                at org.apache.ibatis.builder.xml.dynamic.IfSqlNode.apply(IfSqlNode.java:30)

                at org.apache.ibatis.builder.xml.dynamic.MixedSqlNode.apply(MixedSqlNode.java:29)

                at org.apache.ibatis.builder.xml.dynamic.MixedSqlNode.apply(MixedSqlNode.java:29)

                at org.apache.ibatis.builder.xml.dynamic.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:37)

                at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:241)

                at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:79)

                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)

                ... 55 more