unexpected null pointer encountered
A Tomcat5/Linux/Java5 web app began throwing java.sql.SQLException "System error - unexpected null pointer encountered" from the Informix JDBC driver (IfxSqli.executePrepare / prepareStatement) when inserting a row; restarting the app server only helped briefly. Suggestions offered were an internal Java error, a possible errno 2 (file/device permissions) issue, and resource/JVM memory exhaustion seen in similar WebSphere setups; the poster noted no app changes but unknown DBA actions on the database, and another reader asked to see the application code. No resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi there, In our production environment, one of our applications raised this morning the following error when trying to insert a record into a table: ERROR 02 ago 2013 09:33:18,664 ....jsf.beans.AnotacionSalidaFace ( 407 ): ....xdac.jdbc.JdbcDacException: Error SQL at ....framework.JdbcDacStatement.execute(JdbcDacStatement.java:230) at ....framework.JdbcDacBean.executeUpdate(JdbcDacBean.java:285) at sun.reflect.GeneratedMethodAccessor2323.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav a:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerIm pl.java:61) at javax.faces.component.UICommand.broadcast(UICommand.java:109) at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184) at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162) at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350) at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplication Executor.java:32) ... at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt erChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. java:173) at es.muface.iefilter.IEFilter.doFilter(IEFilter.java:20) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt erChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 13) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 78) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107 ) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876 ) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:68 4) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: System error - unexpected null pointer encountered. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373) at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208) at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269) at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1153) at com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java:318) at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:298) at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:168) at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5909) at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1991) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConn ection.java:185) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepare Statement(PoolingDataSource.java:278) at ....jdbc.framework.JdbcDacStatement.execute(JdbcDacStatement.java:224) We had to shut it down and restart it. It seems now it is running ok. Any idea about the cause of the problem? The web application is running under tomcat5 / linux / java5 Thanks Rafael
I must say, after restarting it is happening again... help!
I think that under all that chaff, the problem may have been caused by an internal Java error. See this message: at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: System error - unexpected null pointer encountered. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Aug 2, 2013 at 4:13 AM, RAFAEL SEGOVIA <rafael.segovia@fi2net.es>wrote: > Hi there, > > In our production environment, one of our applications raised this morning > the > following error when trying to insert a record into a table: > > ERROR 02 ago 2013 09:33:18,664 > .....jsf.beans.AnotacionSalidaFace ( 407 ): > .....xdac.jdbc.JdbcDacException: Error SQL > > at ....framework.JdbcDacStatement.execute(JdbcDacStatement.java:230) > > at ....framework.JdbcDacBean.executeUpdate(JdbcDacBean.java:285) at > sun.reflect.GeneratedMethodAccessor2323.invoke(Unknown Source) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav a:25) > > at java.lang.reflect.Method.invoke(Method.java:585) > > at > org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132) > > at > > org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerIm pl.java:61) > > at javax.faces.component.UICommand.broadcast(UICommand.java:109) > > at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184) > > at > org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162) > > at > > org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350) > > at > > org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplication Executor.java:32) > .... > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt erChain.java:202) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. java:173) > > at es.muface.iefilter.IEFilter.doFilter(IEFilter.java:20) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt erChain.java:202) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. java:173) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 13) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 78) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107 ) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > > at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) > > at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) > > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) > > at > > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684) > > at > > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876 ) > > at > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:68 4) > > at java.lang.Thread.run(Thread.java:595) > Caused by: java.sql.SQLException: System error - unexpected null pointer > encountered. > > at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373) > > at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208) > > at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518) > > at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353) > > at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269) > > at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1153) > > at com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java:318) > > at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:298) > > at > > com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:168) > > at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5909) > > at > com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1991) > > at > > org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConn ection.java:185) > > at > > org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepare Statement(PoolingDataSource.java:278) > > at ....jdbc.framework.JdbcDacStatement.execute(JdbcDacStatement.java:224) > > We had to shut it down and restart it. It seems now it is running ok. > > Any idea about the cause of the problem? The web application is running > under > tomcat5 / linux / java5 > > Thanks > > Rafael > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d1cf85e92a204e2f59098
If the "02" in the first line or your output is the real error, that could be errno 2 which is a file or device permissions problem. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Aug 2, 2013 at 4:37 AM, RAFAEL SEGOVIA <rafael.segovia@fi2net.es>wrote: > I must say, after restarting it is happening again... help! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e014946f4c1539204e2f5941a
On our WebSphere Applications for the State of MS, we get errors like this. Usually caused by lack of resources - ie memory. We usually have to go in an increase the JVM memory size. On 08/02/2013 06:51 AM, Art Kagel wrote: > If the "02" in the first line or your output is the real error, that could > be errno 2 which is a file or device permissions problem. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Fri, Aug 2, 2013 at 4:37 AM, RAFAEL SEGOVIA > <rafael.segovia@fi2net.es>wrote: > >> I must say, after restarting it is happening again... help! >> >> -- Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212 "Never attribute to malice, that which can be adequately explained by stupidity" - Hanlon's Razor
The thing is that we did not deploy any change in our application, and has been running for months without any problem. But we know that the DBAs performed some actions on the database, I ignore which where those actions. I was wondering if the system error was caused in the database machine or in our machine.
The problem seems to be in your NetBeans Framework Exit Phase function "AnotacionSalidaFace". Can you provide this code, explain what it does and what happens when you run in from within the IDE?