MEMBER table deadlocks occur after installing
Coremetrics for IBM WebSphere Commerce enhancement
Technote (troubleshooting) Problem(Abstract) After installing the Coremetrics for IBM WebSphere Commerce enhancement, exceptions indicating transaction rollbacks and deadlocks appear in the SystemOut.log file. These exceptions look like the following example:
[4/22/05 10:01:24:097 EDT] 4eff2 ExceptionUtil E CNTR0021E: Non-application exception occurred on bean "BeanId(WC_wcsprod#Member-MemberManagementData.jar#UserRegistry, UserId=603624 )": Exception data: com.ibm.websphere.cpi.CPIException: ; nested exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001
Cause These exceptions are related to a known performance problem with the UserRegistrationDataBean which is used by the Coremetrics Tag Library for the Registration and Order tags. The UserRegistrationDataBean has been found to cause deadlocks and rollbacks while accessing the MEMBER table in the database, especially when many orders are being placed at the same time. Resolving the problem Contact Support for APAR LI71970.
Related information TechNote Reference 1209776
Cross Reference information
Segment Product Component Platform Version Edition Commerce WebSphere Commerce Professional Edition AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, OS/390, Solaris, Windows 5.6.0.1, 5.6.0.2, 5.6.0.3, 5.6.0.4, 5.6.0.5, 5.6.0.6, 5.6.1, 5.6.1.1, 5.6.1.2, 6.0, 6.0.0.1 Professional Edition Commerce WebSphere Commerce Business Edition AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, OS/390, Solaris, Windows 5.6, 5.6.0.1, 5.6.0.2, 5.6.0.3, 5.6.0.4, 5.6.0.5, 5.6.0.6, 5.6.1, 5.6.1.1, 5.6.1.2 Business Edition
Document Information Current web document: http://www.ibm.com/support/docview.wss?uid=swg21248921