Fixes are available
APAR status
Closed as program error.
Error description
v3.9-FP1 -platform independent. Mysql being NCIM db with multi-domain. When more than one instance of ncp_model process is writing to NCIM at same time the deadlocks are observed resulting inaccurate data in ncim. In ncp_model.DOMAIN.log you would see following: 2012-08-07T13:40:34: Warning: W-RIV-002-206: [4128828304t] CMdlDbConnectSpeeds.cc(764) A database 'execute' operation has failed : CNcpMySQLSth.cc line 263 : Deadlock found when trying to get lock; try restarting transaction( statement: 'insert into connectSpeeds (CONNECTIONID,SPEEDTYPE,SPEEDVALUE ) values (?, ?, ?)' varbinds: [893583,'DEFAULT',10000000] )
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All ITNM 3.9 ncp_model users. * **************************************************************** * PROBLEM DESCRIPTION: * * NCP_MODEL CAN CAUSE DEADLOCK IN NCIM DB(MYSQL ONLY) * * RESULTING * * INCORRECT DATA IN NCIM IN A MULTI-DOMAIN ENVIRONMENT * **************************************************************** * RECOMMENDATION: * * fix pack | 3.9.0-ITNMIP-FP0003 * ****************************************************************
Problem conclusion
Changes to update connect speeds were made in fixpack 3.
Temporary fix
Comments
APAR Information
APAR number
IV26274
Reported component name
NC/PRECISIONIP
Reported component ID
5724O52RC
Reported release
390
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-08-14
Closed date
2012-10-08
Last modified date
2012-10-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
NC/PRECISIONIP
Fixed component ID
5724O52RC
Applicable component levels
R390 PSN
UP
R390 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCP984","label":"Discovery and RCA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"390","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
08 October 2012