Dead Lock Issue

Question

Dead Lock Issue

s.chandrahasan

SSC Eights!

Points: 858
More actions
November 9, 2010 at 12:44 pm

#231221

Dear All,
Kindly advise me ,why it's happend ...
Kindly tell me how to avoid the below deadlock..
2010-11-09 04:00:05,880 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:960)
2010-11-09 04:00:05,880 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor214.invoke(Unknown Source)
2010-11-09 04:00:05,880 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2010-11-09 04:00:05,880 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
2010-11-09 04:00:05,880 ERROR [STDERR] at $Proxy1508.setDischargePlanDetails(Unknown Source)
2010-11-09 04:00:05,880 ERROR [STDERR] at lrp.operations.DischargeListPlanning.dischargeListPlanServlet.setDischargePlanDetails(dischargeListPlanServlet.java:128)
2010-11-09 04:00:05,880 ERROR [STDERR] at lrp.operations.DischargeListPlanning.dischargeListPlanServlet.processRequest(dischargeListPlanServlet.java:63)
2010-11-09 04:00:05,880 ERROR [STDERR] at lrp.operations.DischargeListPlanning.dischargeListPlanServlet.doPost(dischargeListPlanServlet.java:94)
2010-11-09 04:00:05,880 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
2010-11-09 04:00:05,880 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:419)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:378)
2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
2010-11-09 04:00:05,880 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

s.chandrahasan SSC Eights! Points: 858 More actions · Answer 1

com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 112) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)

2010-11-09 04:00:05,849 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)

2010-11-09 04:00:05,849 ERROR [STDERR] at lrp.operations.LoadPlanning.bean.loadPlanBean.setLoadPlanDetails(loadPlanBean.java:1217)

2010-11-09 04:00:05,849 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor650.invoke(Unknown Source)

2010-11-09 04:00:05,849 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

2010-11-09 04:00:05,849 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:960)

2010-11-09 04:00:05,849 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor214.invoke(Unknown Source)

2010-11-09 04:00:05,849 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

2010-11-09 04:00:05,849 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)

2010-11-09 04:00:05,849 ERROR [STDERR] at $Proxy2298.setLoadPlanDetails(Unknown Source)

2010-11-09 04:00:05,849 ERROR [STDERR] at lrp.operations.LoadPlanning.loadplanningServlet.setLoadPlanDetails(loadplanningServlet.java:113)

2010-11-09 04:00:05,849 ERROR [STDERR] at lrp.operations.LoadPlanning.loadplanningServlet.processRequest(loadplanningServlet.java:58)

2010-11-09 04:00:05,849 ERROR [STDERR] at lrp.operations.LoadPlanning.loadplanningServlet.doPost(loadplanningServlet.java:99)

2010-11-09 04:00:05,849 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

2010-11-09 04:00:05,849 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:419)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:378)

2010-11-09 04:00:05,849 ERROR [STDERR] at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)

2010-11-09 04:00:05,849 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)

2010-11-09 04:00:05,849 INFO [STDOUT] Status is true for updation in operationdetail table.....

2010-11-09 04:00:05,849 INFO [STDOUT] After the bean method

2010-11-09 04:00:05,849 INFO [STDOUT] Successfully Sent

2010-11-09 04:00:05,849 INFO [STDOUT] After Exceution loadPlan Details in servlet

2010-11-09 04:00:05,880 INFO [STDOUT] Exception Occured in Discharge List & Plan Bean

2010-11-09 04:00:05,880 ERROR [STDERR] com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 122) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)

2010-11-09 04:00:05,880 ERROR [STDERR] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)

2010-11-09 04:00:05,880 ERROR [STDERR] at lrp.operations.DischargeListPlanning.bean.dischargeListPlanBean.setDischargePlanDetails(dischargeListPlanBean.java:1342)

2010-11-09 04:00:05,880 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor713.invoke(Unknown Source)

2010-11-09 04:00:05,880 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

2010-11-09 04:00:05,880 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:960)

2010-11-09 04:00:05,880 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor214.invoke(Unknown Source)

2010-11-09 04:00:05,880 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

2010-11-09 04:00:05,880 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)

2010-11-09 04:00:05,880 ERROR [STDERR] at $Proxy1508.setDischargePlanDetails(Unknown Source)

2010-11-09 04:00:05,880 ERROR [STDERR] at lrp.operations.DischargeListPlanning.dischargeListPlanServlet.setDischargePlanDetails(dischargeListPlanServlet.java:128)

2010-11-09 04:00:05,880 ERROR [STDERR] at lrp.operations.DischargeListPlanning.dischargeListPlanServlet.processRequest(dischargeListPlanServlet.java:63)

2010-11-09 04:00:05,880 ERROR [STDERR] at lrp.operations.DischargeListPlanning.dischargeListPlanServlet.doPost(dischargeListPlanServlet.java:94)

2010-11-09 04:00:05,880 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

2010-11-09 04:00:05,880 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:419)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:378)

2010-11-09 04:00:05,880 ERROR [STDERR] at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)

2010-11-09 04:00:05,880 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)

Wildcat SSCarpal Tunnel Points: 4774 More actions · Answer 2

If it is for SQL Server, then ask someone to check the error log.

Otherwise, you post on a wrong site.

Edit: if one flag is on to write the deadlock info to error log.....

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

Wildcat, it's SQL Server:

com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 112) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

However, without having tracing at the time, or the deadlock graph available, there's nothing we can do to help here.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

WayneS SSC Guru Points: 95460 More actions · Answer 4

Please post the deadlock graph.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2