home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC92188 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 / 970 - 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:                                              * 
* N/A                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 9                        * 
****************************************************************
Local-Fix:
No local fix
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
N/A
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC97792 IC97796 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.05.2013
19.11.2013
19.11.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP9
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList