|
Problem IT26054
|
Status: Closed |
-901 ERROR WITH TEXT "WITH HOLD BUT USAGE LOCK ARGUMENT NULL" REPORTED BY SQLRLC_REQUEST_ULOCK() AS CALLED BY SQLRLGETREPLMQTREF
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
SELECT referencing SYSCAT.TABLES of replication-maintained MQT
might hang/crash with SQL0901N
Stack:
0x090000000055AF14 pthread_kill + 0xD4
0x0900000008AEDB7C sqloDumpEDU + 0x9C
0x0900000009711550 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
0x150
0x090000000AA1702C sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x90C
0x0900000008C4AB38 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x158
0x0900000008C4A61C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
0x27C
0x0900000008C4710C sqlrrSqlCode + 0x18C
0x090000000B146A78
sqlrlc_request_ulock__FP8sqlrr_cbP19sqlrlc_entry_commonP20sqlrlc
_anchor_commonPbUiN25PUiP14SQLP_LOCK_INFOT9T8 + 0x1D8
0x090000000B145FE4
sqlrlc_find_request_usage_lock__FP8sqlrr_cbP10sqlrlc_keyUiN23PP1
9sqlrlc_entry_commonPUiP14SQLP_LOCK_INFOT8 + 0x664
0x090000000B140E20
sqlrlc_systables_fetch__FP8sqlrr_cbPUcUsT2T3UiN26P13SQLO_MEM_POO
LP14SQLP_LOCK_INFOP21sqlrlc_systables_info + 0x9E0
0x090000000DB83ACC
sqlrlGetReplMQTRefreshTimestamp__FP8sqlrr_cbPbPUc + 0x20C
0x0900000009C99ECC
sqlra_check_mqt_replication_latency__FP8sqlrr_cbPCUcPb + 0x3AC
0x0900000009C9517C
sqlra_find_var_var__FP8sqlrr_cbP17sqlra_cached_stmtPP16sqlra_cac
hed_envP14sqlra_cmpl_envUiiT615sqlra_fill_modePiT6N29P14SQLP_
LOCK_INFOT13_PP16sqlra_cached_varN49bT20_PUiT22_ + 0x4D9C
0x0900000009C9C8E8
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_
P14SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x848
0x090000000AD59194 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBF4
0x090000000A4B6E94
IPRA.$sqlrr_process_open_request__FP8sqlrr_cbPbPUlP15db2UCCursor
InfoT2 + 0x3594
0x090000000A4AF388
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x4A8
0x090000000F8A1BC0
sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4C0
0x090000000F8405F8
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x298
0x090000000F843650
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2250
0x090000000F80FACC
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC
0x090000000F818594
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x090000000F80DB70
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
0x090000000F80AFB4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x334
0x0900000008C14DA0 RunEDU__8sqeAgentFv + 0xB60
0x0900000008BF78A0 EDUDriver__9sqzEDUObjFv + 0x2E0
0x0900000008AE7814 sqloEDUEntry + 0x374 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1fp5 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.08.2018
21.01.2019
21.01.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
