Support #7547: [SCP ID :##3930##] : DB2 deadlock during transaction - Maybank BII M2U-RIB Support - Penril Support System

Support #7547

[SCP ID :##3930##] : DB2 deadlock during transaction

Added by Zahir Abd Latif about 7 years ago. Updated about 7 years ago.

Status:

Closed - End of life cycle

Start date:

July 03, 2017

Priority:

High

Due date:

July 03, 2017

Assignee:

Zahir Abd Latif

% Done:

100%

Category:

Spent time:

Target version:

Description

Hi,
Kindly attend below request:

please help to check for issue get warning "System is currently unavailable. Please try again later." when doing transaction step 2/3

below attach the SysOut & SysErr log.

Error SysErr
[7/3/17 9:34:25:091 WIT] 00000d2f SystemErr R org.hibernate.exception.LockAcquisitionException: could not update: [net.penril.ibss.core.hibernate.IbUser#8417]
[7/3/17 9:34:25:097 WIT] 00000d2f SystemErr R org.hibernate.exception.LockAcquisitionException: could not update: [net.penril.ibss.core.hibernate.IbUser#8417]
[7/3/17 9:34:25:099 WIT] 00000d2f SystemErr R com.ib.common.error.exception.IBBusinessException:
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ib.common.error.handler.IBErrorHandler.createBusinessException(IBErrorHandler.java:76)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ib.rib.controller.actions.ib101_access.login.IBLoginSecurityQuestionAction.execute(IBLoginSecurityQuestionAction.java:123)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ib.common.utils.IBActionServlet.doPost(IBActionServlet.java:82)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ib.common.utils.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:85)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
[7/3/17 9:34:25:100 WIT] 00000d2f SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1815)

Error SysOut
[7/3/17 9:34:25:089 WIT] 00000d2f SystemOut O [03/07/2017] [09:34:25:089] [ERROR] [JDBCExceptionReporter]:101 - The current transaction has been rolled back beca
use of a deadlock or timeout. Reason code "68".. SQLCODE=-911, SQLSTATE=40001, DRIVER=3.63.123
[7/3/17 9:34:25:089 WIT] 00000d2f SystemOut O [03/07/2017] [09:34:25:089] [ERROR] [JDBCExceptionReporter]:101 - The current transaction has been rolled back beca
use of a deadlock or timeout. Reason code "68".. SQLCODE=-911, SQLSTATE=40001, DRIVER=3.63.123
[7/3/17 9:34:25:090 WIT] 00000d2f SystemOut O [03/07/2017] [09:34:25:090] [ERROR] [AbstractFlushingEventListener]:324 - Could not synchronize database state with
session
org.hibernate.exception.LockAcquisitionException: could not update: [net.penril.ibss.core.hibernate.IbUser#8417]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2453)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2335)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2635)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at net.penril.ibss.core.hibernate.IbUser.updateIbUser(IbUser.java:526)
at net.penril.ib.middle.service.common.RibAuthenticationService.checkRibPasswordAndDormantLifePeriod(RibAuthenticationService.java:318)
at net.penril.ib.middle.service.common.RibAuthenticationService.AUTH_RIB_VerifyUserNamePassword(RibAuthenticationService.java:79)
at net.penril.ib.middle.login.service.IBLoginSecurityQuestionService.verifyLoginPassword(IBLoginSecurityQuestionService.java:116)
at com.ib.rib.controller.actions.ib101_access.login.IBLoginSecurityQuestionAction.execute(IBLoginSecurityQuestionAction.java:87)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at com.ib.common.utils.IBActionServlet.doPost(IBActionServlet.java:82)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ib.common.utils.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:85)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1815)
Caused by:
com.ibm.db2.jcc.am.SqlTransactionRollbackException: The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".. SQLCODE=-911,
SQLSTATE=40001, DRIVER=3.63.123
at com.ibm.db2.jcc.am.fd.a(fd.java:666)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:127)
at com.ibm.db2.jcc.am.ho.c(ho.java:2644)
at com.ibm.db2.jcc.t4.cb.t(cb.java:982)
at com.ibm.db2.jcc.t4.cb.l(cb.java:405)
at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
at com.ibm.db2.jcc.t4.q.a(q.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
at com.ibm.db2.jcc.am.io.lc(io.java:3318)
at com.ibm.db2.jcc.am.io.b(io.java:4275)
at com.ibm.db2.jcc.am.io.dc(io.java:759)
at com.ibm.db2.jcc.am.io.executeUpdate(io.java:742)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1185)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:802)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2431)
... 50 more
[7/3/17 9:34:25:090 WIT] 00000d2f SystemOut O [03/07/2017] [09:34:25:090] [ERROR] [AbstractFlushingEventListener]:324 - Could not synchronize database state with
session
org.hibernate.exception.LockAcquisitionException: could not update: [net.penril.ibss.core.hibernate.IbUser#8417]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2453)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2335)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2635)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at net.penril.ibss.core.hibernate.IbUser.updateIbUser(IbUser.java:526)
at net.penril.ib.middle.service.common.RibAuthenticationService.checkRibPasswordAndDormantLifePeriod(RibAuthenticationService.java:318)
at net.penril.ib.middle.service.common.RibAuthenticationService.AUTH_RIB_VerifyUserNamePassword(RibAuthenticationService.java:79)
at net.penril.ib.middle.login.service.IBLoginSecurityQuestionService.verifyLoginPassword(IBLoginSecurityQuestionService.java:116)
at com.ib.rib.controller.actions.ib101_access.login.IBLoginSecurityQuestionAction.execute(IBLoginSecurityQuestionAction.java:87)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at com.ib.common.utils.IBActionServlet.doPost(IBActionServlet.java:82)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ib.common.utils.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:85)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1815)
Caused by:
com.ibm.db2.jcc.am.SqlTransactionRollbackException: The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".. SQLCODE=-911,
SQLSTATE=40001, DRIVER=3.63.123
at com.ibm.db2.jcc.am.fd.a(fd.java:666)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:127)
at com.ibm.db2.jcc.am.ho.c(ho.java:2644)
at com.ibm.db2.jcc.t4.cb.t(cb.java:982)
at com.ibm.db2.jcc.t4.cb.l(cb.java:405)
at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
at com.ibm.db2.jcc.t4.q.a(q.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
at com.ibm.db2.jcc.am.io.lc(io.java:3318)

at com.ibm.db2.jcc.am.io.b(io.java:4275)
at com.ibm.db2.jcc.am.io.dc(io.java:759)
at com.ibm.db2.jcc.am.io.executeUpdate(io.java:742)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:1185)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:802)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2431)
... 50 more
[7/3/17 9:34:25:099 WIT] 00000d2f SystemOut O [03/07/2017] [09:34:25:099] [ERROR] [IBBusinessException]:527 - [default] System is currently unavailable. Please t
ry again later.
[7/3/17 9:34:25:103 WIT] 00000d2f SystemOut O [03/07/2017] [09:34:25:102] [ERROR] [IBControllerAction]:538 -
com.ib.common.error.exception.IBBusinessException:
at com.ib.common.error.handler.IBErrorHandler.createBusinessException(IBErrorHandler.java:76)
at com.ib.rib.controller.actions.ib101_access.login.IBLoginSecurityQuestionAction.execute(IBLoginSecurityQuestionAction.java:123)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at com.ib.common.utils.IBActionServlet.doPost(IBActionServlet.java:82)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ib.common.utils.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:85)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1815)

History

#1 Updated by Rayvandy Gabbytian about 7 years ago

Due date set to July 03, 2017
Status changed from New - Begin Life Cycle to Pending Customer Feedback
Assignee changed from Rayvandy Gabbytian to Zahir Abd Latif

Dear all,

Last conversation with Wahyu in email on 03rd July 2017 15:56 UTC +7 as follows:

Also continuing from my email just now, please check for this one as well:

1. IBTelegraphicTransferResultsServices Line 211,
2. SMSService Line 527,
3. IbUser Line > 520

It could somehow failed to insert the TAC wrong attempt count and wait the update process until deadlock time is reached.

So far Wahyu never given any feedback about that. Full trace of conversation can be seen in email: Re: [Request ID :##3930##] : DB2 deadlock during transaction

#2 Updated by Rayvandy Gabbytian about 7 years ago

Dear Zahir, I forgot to update this in redmine. Now I reassign back to you.

Thanks.

#3 Updated by Zahir Abd Latif about 7 years ago

Status changed from Pending Customer Feedback to Closed - End of life cycle
% Done changed from 0 to 100

Issue closed in SCP.

Also available in: Atom PDF

B - Production Support » Maybank Support » Maybank BII M2U-RIB Support