DB2 - Problembeschreibung
Problem IC97792 | Status: Geschlossen |
DROP ROLE COMMAND CAUSES A SQLOSPINLOCKCONFLICT IN SQLRLC_ROLECA CHE.C AND SQLRLC_INLINES.H FUNCTIONS AND LOCKING ABOUT 52 APPLIC | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Drop role command causes a sqloSpinLockConflict in sqlrlc_rolecache.C and sqlrlc_inlines.h functions. Due to a coding issue, db2 is not releasing the anchor lacth and so all applications that try to access some entry in the cache will have to wait and the latch is being held unconditionally. Printing Latch information ========================================= ******** LATCHWAIT DETECTED ( #1 ) *********** Printing LatchWait information ========================================= <<<< Holder Information (Address = 0x2ab3c727e0d0) >>>> File Information: Line: 140, File: sqlrlc_inlines.h HoldCount: 1 ---------------------------- PID(s): 185 (./27091.185.000.stack.txt) -- Line: 140, File: sqlrlc_inlines.h HoldCount: 1 (SQLO_LT_sqlrlc_entry_common__usage_latch) Agent Type: db2agent (CMDCRC) *** Stack *** Timestamp: 2013-04-04-12.38.09.779053 0x00002AAAB07D8417 ossDumpStackTraceEx + 0x01ef 0x00002AAAB07D31D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00002AAAAD76F777 sqlo_trce + 0x03fb 0x00002AAAAD7B6080 sqloDumpDiagInfoHandler + 0x00e0 0x00002AAAAACD7BE0 address: 0x00002AAAAACD7BE0 ; dladdress: 0x00002AAAAACC9000 ; offset in lib: 0x000000000000EBE0 ; 0x00002AAAB14DA07A semtimedop + 0x000a 0x00002AAAAC17BDFB sqloWaitEDUWaitPost + 0x019d 0x00002AAAAC21540D _Z8sqlplnfdP9sqeBsuEduP14SQLP_LOCK_INFOP8SQLP_LCBP9SQLP_LHSHP8SQ LP_LRBjimiP8SQLP_AWBi + 0x1065 0x00002AAAAE52521B _Z7sqlplrqP9sqeBsuEduP14SQLP_LOCK_INFO + 0x0fed 0x00002AAAAC26F09B _Z14sqlrr_get_lockP8sqlrr_cbP14SQLP_LOCK_INFOjPj + 0x0083 0x00002AAAAC286D54 _Z19sqlrr_init_get_lockP8sqlrr_cbP14SQLP_LOCK_INFOciijjP13SQLP_L OCKNAMEjPj + 0x0076 0x00002AAAADEE789C _Z20sqlrlcRoleInvalidateP8sqlrr_cbPhmmm + 0x01ae 0x00002AAAADE9E045 _Z20sqlrlc_execute_eventP8sqlrr_cbP17sqlrlc_event_rqst + 0x02a3 0x00002AAAADE9E85A _Z16sqlrlc_broadcastP8sqlrr_cbP17sqlrlc_event_rqst + 0x0256 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~ <<<< Waiter Information (Address = 0x2ab3c727e0d0) >>>> TOTAL WAITERS >> 1 File Information: Line: 682, File: sqlrlc_rolecache.C ---------------------------- PID(s): 163 (./27091.163.000.stack.txt) -- Line: 682, File: sqlrlc_rolecache.C (SQLO_LT_sqlrlc_entry_common__usage_latch) Agent Type: db2agent (CMDCRC) <<< Stack >>> Timestamp: 2013-04-04-12.38.09.744589 0x00002AAAB07D8417 ossDumpStackTraceEx + 0x01ef 0x00002AAAB07D31D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00002AAAAD76F777 sqlo_trce + 0x03fb 0x00002AAAAD7B6080 sqloDumpDiagInfoHandler + 0x00e0 0x00002AAAAACD7BE0 address: 0x00002AAAAACD7BE0 ; dladdress: 0x00002AAAAACC9000 ; offset in lib: 0x000000000000EBE0 ; 0x00002AAAB14D1DB2 __select + 0x0062 0x00002AAAAC1995AB sqloSpinLockConflict + 0x0271 0x00002AAAAE551713 address: 0x00002AAAAE551713 ; dladdress: 0x00002AAAAAEE5000 ; offset in lib: 0x000000000366C713 ; 0x00002AAAAC3A8544 _Z22sqlrlcAuthidFindInsertP8sqlrr_cbP19sqlrlcRolesRequiredP14SQL P_LOCK_INFOPb + 0x00ec 0x00002AAAAC3A783E _Z25sqlrlcAuthidsFindRolelistP8sqlrr_cbP11sqlr_aainfomP13SQLO_ME M_POOLPP19sqlrlcRolesRequiredPmS8_m + 0x00fa 0x00002AAAAC3A7075 _Z31sqlrlcRequestRolelistsForAuthidP8sqlrr_cbP11sqlr_aainfobbb + 0x00c7 0x00002AAAADEF0269 _Z28sqlrlGetAainfoFromRepositoryP8sqlrr_cbP16aainfoRepositoryPhm mPcPP11sqlr_aainfo + 0x0289 0x00002AAAADEF6CE1 _Z31sqlrlRevokeRoleFromUserOrPublicP8sqlrr_cbP10sqlr_rolesP27sql rlDropRoleLostTableAuthsP30sqlrlDropRoleLostSequenceAuthsP30sqlr lDropRoleLostVariableAuthsP29sqlrlDropRoleLostRoutineAuthsP28sql rlDropRoleLostModuleAuthsP12sqlrl_authidbbPbP18sqlrlPkgPrivUpdat eb + 0x27ed 0x00002AAAADEFF04E _Z13sqlrlDropRoleP8sqlrr_cbPctb + 0x26f6 ******** LATCHWAIT DETECTED ( #2 ) *********** Printing LatchWait information ========================================= <<<< Holder Information (Address = 0x2ab3c279764c) >>>> File Information: Line: 71, File: sqlrlc_inlines.h HoldCount: 1 ---------------------------- PID(s): 163 (./27091.163.000.stack.txt) -- Line: 71, File: sqlrlc_inlines.h HoldCount: 1 (SQLO_LT_sqlrlc_anchor_common__anchor_latch) Agent Type: db2agent (CMDCRC) *** Stack *** Timestamp: 2013-04-04-12.38.09.744589 0x00002AAAB07D8417 ossDumpStackTraceEx + 0x01ef 0x00002AAAB07D31D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00002AAAAD76F777 sqlo_trce + 0x03fb 0x00002AAAAD7B6080 sqloDumpDiagInfoHandler + 0x00e0 0x00002AAAAACD7BE0 address: 0x00002AAAAACD7BE0 ; dladdress: 0x00002AAAAACC9000 ; offset in lib: 0x000000000000EBE0 ; 0x00002AAAB14D1DB2 __select + 0x0062 0x00002AAAAC1995AB sqloSpinLockConflict + 0x0271 0x00002AAAAE551713 address: 0x00002AAAAE551713 ; dladdress: 0x00002AAAAAEE5000 ; offset in lib: 0x000000000366C713 ; 0x00002AAAAC3A8544 _Z22sqlrlcAuthidFindInsertP8sqlrr_cbP19sqlrlcRolesRequiredP14SQL P_LOCK_INFOPb + 0x00ec 0x00002AAAAC3A783E _Z25sqlrlcAuthidsFindRolelistP8sqlrr_cbP11sqlr_aainfomP13SQLO_ME M_POOLPP19sqlrlcRolesRequiredPmS8_m + 0x00fa 0x00002AAAAC3A7075 _Z31sqlrlcRequestRolelistsForAuthidP8sqlrr_cbP11sqlr_aainfobbb + 0x00c7 0x00002AAAADEF0269 _Z28sqlrlGetAainfoFromRepositoryP8sqlrr_cbP16aainfoRepositoryPhm mPcPP11sqlr_aainfo + 0x0289 0x00002AAAADEF6CE1 _Z31sqlrlRevokeRoleFromUserOrPublicP8sqlrr_cbP10sqlr_rolesP27sql rlDropRoleLostTableAuthsP30sqlrlDropRoleLostSequenceAuthsP30sqlr lDropRoleLostVariableAuthsP29sqlrlDropRoleLostRoutineAuthsP28sql rlDropRoleLostModuleAuthsP12sqlrl_authidbbPbP18sqlrlPkgPrivUpdat eb + 0x27ed 0x00002AAAADEFF04E _Z13sqlrlDropRoleP8sqlrr_cbPctb + 0x26f6 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~ <<<< Waiter Information (Address = 0x2ab3c279764c) >>>> TOTAL WAITERS >> 52 File Information: Line: 71, File: sqlrlc_inlines.h ---------------------------- PID(s): 119 (./27091.119.000.stack.txt) -- Line: 71, File: sqlrlc_inlines.h (SQLO_LT_sqlrlc_anchor_common__anchor_latch) Agent Type: db2agent (CMDCRC) <<< Stack >>> Timestamp: 2013-04-04-12.38.09.802196 0x00002AAAB07D8417 ossDumpStackTraceEx + 0x01ef 0x00002AAAB07D31D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00002AAAAD76F777 sqlo_trce + 0x03fb 0x00002AAAAD7B6080 sqloDumpDiagInfoHandler + 0x00e0 0x00002AAAAACD7BE0 address: 0x00002AAAAACD7BE0 ; dladdress: 0x00002AAAAACC9000 ; offset in lib: 0x000000000000EBE0 ; 0x00002AAAB14D1DB2 __select + 0x0062 0x00002AAAAC1995AB sqloSpinLockConflict + 0x0271 0x00002AAAAC39CD1E _Z24sqlrlc_find_latch_anchorP8sqlrr_cbP10sqlrlc_keyPP20sqlrlc_an chor_commonPP19sqlrlc_entry_commonS8_Pb + 0x0224 0x00002AAAAC3A84ED _Z22sqlrlcAuthidFindInsertP8sqlrr_cbP19sqlrlcRolesRequiredP14SQL P_LOCK_INFOPb + 0x0095 0x00002AAAAC3A783E _Z25sqlrlcAuthidsFindRolelistP8sqlrr_cbP11sqlr_aainfomP13SQLO_ME M_POOLPP19sqlrlcRolesRequiredPmS8_m + 0x00fa 0x00002AAAAC3A7075 _Z31sqlrlcRequestRolelistsForAuthidP8sqlrr_cbP11sqlr_aainfobbb + 0x00c7 0x00002AAAAE531E5D _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP 15db2UCCursorInfo + 0x250d 0x00002AAAAD97CF5A _Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x00c6 0x00002AAAACCA49E2 _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x0102 120 (./27091.120.000.stack.txt) -- Line: 71, File: sqlrlc_inlines.h (SQLO_LT_sqlrlc_anchor_common__anchor_latch) Agent Type: db2agent (CMDCRC) <<< Stack >>> Timestamp: 2013-04-04-12.38.09.798235 0x00002AAAB07D8417 ossDumpStackTraceEx + 0x01ef 0x00002AAAB07D31D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00002AAAAD76F777 sqlo_trce + 0x03fb 0x00002AAAAD7B6080 sqloDumpDiagInfoHandler + 0x00e0 0x00002AAAAACD7BE0 address: 0x00002AAAAACD7BE0 ; dladdress: 0x00002AAAAACC9000 ; offset in lib: 0x000000000000EBE0 ; 0x00002AAAB14BF847 __sched_yield + 0x0007 0x00002AAAAC19951B sqloSpinLockConflict + 0x01e1 0x00002AAAAC39CD1E _Z24sqlrlc_find_latch_anchorP8sqlrr_cbP10sqlrlc_keyPP20sqlrlc_an chor_commonPP19sqlrlc_entry_commonS8_Pb + 0x0224 0x00002AAAAC3A84ED _Z22sqlrlcAuthidFindInsertP8sqlrr_cbP19sqlrlcRolesRequiredP14SQL P_LOCK_INFOPb + 0x0095 0x00002AAAAC3A783E _Z25sqlrlcAuthidsFindRolelistP8sqlrr_cbP11sqlr_aainfomP13SQLO_ME M_POOLPP19sqlrlcRolesRequiredPmS8_m + 0x00fa 0x00002AAAAC3A7075 _Z31sqlrlcRequestRolelistsForAuthidP8sqlrr_cbP11sqlr_aainfobbb + 0x00c7 0x00002AAAAE531E5D _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP 15db2UCCursorInfo + 0x250d 0x00002AAAAD97CF5A _Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x00c6 0x00002AAAACCA49E2 _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x0102 121 (./27091.121.000.stack.txt) -- Line: 71, File: sqlrlc_inlines.h (SQLO_LT_sqlrlc_anchor_common__anchor_latch) Agent Type: db2agent (CMDCRC) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users under v10.1 below FP 4 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 version 10.1 Fix Pack 4 * **************************************************************** | |
Local-Fix: | |
No local fix | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.11.2013 07.07.2014 07.07.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |
![]() |