|
Problem IT34510
|
Status: Closed |
DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
The Db2 instance may hit SIGSEGV (signal 11) with following
stacktrace:
DB2 build information: DB2 v11.1.4.4 special_38396 SQL11014
timestamp: 1601620491.106298000
timezone : 36000
convert : echo `perl -MPOSIX -le 'print strftime
"%Y-%m-%d-%H.%M.%S",gmtime(1601656491)'`.106298000 +1000
instance name: db2inst1.000
EDU name : db2agent (SAMPLE) 0 [-]
EDU ID : 75821
Signal #11
uname: S:AIX R:1 V:7 M:00FA46304C00 N:dj2102p-dbsa001
process id: 50397756
parent process id: 63439304
thread id : 75821 (0x1282D)
kthread id : 132383423
0000000B 00000000 00000032 00000000
00000000 00000000 0A00031D 30000000
00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000
Signal #11 (SIGSEGV): si_addr is 0x0A00031D30000000, si_code is
0x00000032 (SEGV_MAPERR:Address not mapped to object.)
-------Frame------ ------Function + Offset------
0x090000002C86C0C8 sqlnls_CharWidth2 + 0x3C8
0x090000004175C4DC sqlnpMaskPassword__FCPcCPUlCUiCb + 0x1DC
0x09000000429519F0
gen_dlconn_events__15sqm_dlconn_listFPC8sqeAgentP8SQLP_LRB +
0x1210
0x090000004114E4B4
sqlplWaitOnWP__FCP9sqeBsuEduCP14SQLP_LOCK_INFOCP8SQLP_LRBCP15SQL
P_LTRN_CHAINCbN25 + 0x22B4
0x090000004806520C
sqlplMakeNewRequestNonSD__FP9sqeBsuEduP14SQLP_LOCK_INFOP11SQLP_T
ENTRYP8SQLP_LRBT4P15SQLP_LTRN_CHAINbT7Cb + 0x1AAC
0x0900000041473870
sqlpUpgradeLock__FP9sqeBsuEduP14SQLP_LOCK_INFO + 0x1870
0x09000000420BC554 sqldEscalateLocks__FP8sqeAgenti + 0xD54
0x0900000041ABECB8
sqldLockTable__FP8sqeAgentP14SQLP_LOCK_INFOUiUsi + 0xF78
0x090000004210402C
sqldScanOpen__FP8sqeAgentP14SQLD_SCANINFO1P14SQLD_SCANINFO2PPv +
0x5EC
0x090000004374F9C4 sqlriopn__FP8sqlrr_cbP9sqlri_taoPi + 0xD84
0x09000000474B57E0 sqlriNljnNonPiped__FP8sqlrr_cb + 0x3E0
0x0900000043B3B95C
sqlriExecThreadFunc__FP8sqlrr_cbP12sqlri_opparmPl + 0x5C
0x0900000043B3B268 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x648
0x0900000042BB15C4 sqlrr_process_execute_request__FP8sqlrr_cbib
+ 0x3624
0x0900000042B4B720 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x4A0
0x090000004527926C executeSection__10pvmPackageFP5sqlcaUib +
0x98C
0x0900000045274228 executeQuery__3PVMFUib + 0x208
0x0900000045280EE0 run__3PVMFv + 0xFE0
0x090000004526CB5C pvm_entry + 0x45C
0x0900000040A8CA8C sqloInvokeFnArgs + 0x5D6C
0x0900000044439718
IPRA.$sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorInt
fb + 0x2AF8
0x090000004442F468 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x2008
0x0900000044430370 sqlricall__FP8sqlrr_cb + 0x670
0x0900000043B3B238 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x618
0x0900000042BB15C4 sqlrr_process_execute_request__FP8sqlrr_cbib
+ 0x3624
0x0900000042B4B720 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x4A0
0x0900000047F766BC
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x5BC
0x0900000047EF2CE0
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x280
0x0900000047EF5D64
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2264
0x0900000047EC0F3C
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
0x0900000047EC9654
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x0900000047EBEFF0
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
0x0900000047EBC434 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x334
0x0900000040BE49A0 RunEDU__8sqeAgentFv + 0xB60
0x0900000040BBEBC0 EDUDriver__9sqzEDUObjFv + 0x300
0x0900000040AA0200 sqloEDUEntry + 0x360
This is due to a db2 deadlock event monitor capturing a static
sql statement which contains sensitive information (e.g.
passwords) which must be masked. The error may occur if the
large value is being masked. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.6 or later *
**************************************************************** |
| Local Fix: |
Disable any db2 deadlock event monitors. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.6 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5.6 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.10.2020
21.06.2021
21.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
