|
Problem IC92188
|
Status: Closed |
DROP ROLE COMMAND CAUSES A SQLOSPINLOCKCONFLICT IN SQLRLC_ROLECA CHE.C AND SQLRLC_INLINES.H FUNCTIONS AND LOCKING ABOUT 52 APPLIC |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 Fix Pack 9 *
**************************************************************** |
| Local Fix: |
No local fix |
| available fix packs: |
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
|
| Solution |
N/A |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC97792 IC97796
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.05.2013
19.11.2013
19.11.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
