JBOSS 5 SQL Server nested Exception -
this situation. have application running on 2 servers 24/7 in client side:
application server: tomcat + jboss 5 database server: sql server 2008 r2
lately encounter error whereby every thursday morning 6am jboss hit error:
com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error @ com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:1368) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.terminate(sqlserverconnection.java:1355) @ com.microsoft.sqlserver.jdbc.tdschannel.write(iobuffer.java:1548) @ com.microsoft.sqlserver.jdbc.tdswriter.flush(iobuffer.java:2368) @ com.microsoft.sqlserver.jdbc.tdswriter.writepacket(iobuffer.java:2270) @ com.microsoft.sqlserver.jdbc.tdswriter.endmessage(iobuffer.java:1877) @ com.microsoft.sqlserver.jdbc.tdscommand.startresponse(iobuffer.java:4403) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement.doexecutepreparedstatement(sqlserverpreparedstatement.java:386) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement$prepstmtexeccmd.doexecute(sqlserverpreparedstatement.java:338) @ com.microsoft.sqlserver.jdbc.tdscommand.execute(iobuffer.java:4026) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.executecommand(sqlserverconnection.java:1416) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executecommand(sqlserverstatement.java:185) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executestatement(sqlserverstatement.java:160) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement.executeupdate(sqlserverpreparedstatement.java:306) @ org.jboss.resource.adapter.jdbc.wrappedpreparedstatement.executeupdate(wrappedpreparedstatement.java:365) @ sun.reflect.generatedmethodaccessor343.invoke(unknown source) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.jboss.invocation.invocation.performcall(invocation.java:386) @ org.jboss.ejb.statelesssessioncontainer$containerinterceptor.invoke(statelesssessioncontainer.java:228) @ org.jboss.resource.connectionmanager.cachedconnectioninterceptor.invoke(cachedconnectioninterceptor.java:156) @ org.jboss.ejb.plugins.statelesssessioninstanceinterceptor.invoke(statelesssessioninstanceinterceptor.java:173) @ org.jboss.ejb.plugins.callvalidationinterceptor.invoke(callvalidationinterceptor.java:63) @ org.jboss.ejb.plugins.abstracttxinterceptor.invokenext(abstracttxinterceptor.java:121) @ org.jboss.ejb.plugins.txinterceptorcmt.runwithtransactions(txinterceptorcmt.java:350) @ org.jboss.ejb.plugins.txinterceptorcmt.invoke(txinterceptorcmt.java:181) @ org.jboss.ejb.plugins.securityinterceptor.process(securityinterceptor.java:228) @ org.jboss.ejb.plugins.securityinterceptor.invoke(securityinterceptor.java:211) @ org.jboss.ejb.plugins.security.presecurityinterceptor.process(presecurityinterceptor.java:97) @ org.jboss.ejb.plugins.security.presecurityinterceptor.invoke(presecurityinterceptor.java:81) @ org.jboss.ejb.plugins.loginterceptor.invoke(loginterceptor.java:205) @ org.jboss.ejb.plugins.proxyfactoryfinderinterceptor.invoke(proxyfactoryfinderinterceptor.java:138) @ org.jboss.ejb.sessioncontainer.internalinvoke(sessioncontainer.java:650) @ org.jboss.ejb.container.invoke(container.java:1029) @ sun.reflect.generatedmethodaccessor323.invoke(unknown source) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.jboss.mx.interceptor.reflecteddispatcher.invoke(reflecteddispatcher.java:157) @ org.jboss.mx.server.invocation.dispatch(invocation.java:96) @ org.jboss.mx.server.invocation.invoke(invocation.java:88) @ org.jboss.mx.server.abstractmbeaninvoker.invoke(abstractmbeaninvoker.java:264) @ org.jboss.mx.server.mbeanserverimpl.invoke(mbeanserverimpl.java:668) @ org.jboss.invocation.unified.server.unifiedinvoker.invoke(unifiedinvoker.java:232) @ org.jboss.remoting.serverinvoker.invoke(serverinvoker.java:891) @ org.jboss.remoting.transport.socket.serverthread.completeinvocation(serverthread.java:744) @ org.jboss.remoting.transport.socket.serverthread.processinvocation(serverthread.java:697) @ org.jboss.remoting.transport.socket.serverthread.dorun(serverthread.java:551) @ org.jboss.remoting.transport.socket.serverthread.run(serverthread.java:232)
and app service give error:
javax.ejb.ejbexception: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error; nested exception is: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error; nested exception is: com.microsoft.sqlserver.jdbc.sqlserverexception: connection reset peer: socket write error: connection reset peer: socket write error
my client claimed there no activity being done on db nor apps server on thursday 6am, hence had no idea trigger error..it happens every thursday 6am. me appreciated!
what's network topology? there firewall between front end , database server? if so, firewall recycling connections.
Comments
Post a Comment