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

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -