IZ25955: INFINITE RECURISON CALLS OF SQLEX_AUD_REC_FUNC() BRINGS DOWN QUERY PATROLLER WITH SEGV

APAR status

• Closed as program error.

Error description

• Due to failure of sqlexGetDefaultLoginContext(), infinite
  recurison calls of sqlex_aud_rec_func() can occur, and brings
  down Query Patroller with SEGV.
  
  Here is sample stack obtained against /core generated by Java
  process running Query Patroller:
  
  Segmentation fault in sysThreadSelf at 0x9000000066dcadc
  0x9000000066dcadc (sysThreadSelf+0x8) f821ff91        stdu
  r1,-112(r1)
  (dbx) where
  sysThreadSelf() at 0x9000000066dcadc
  sysSignalCatchHandler(??, ??, ??) at 0x9000000066eea04
  userSignalHandler(??, ??, ??, ??) at 0x9000000066ed528
  intrDispatch(??, ??, ??) at 0x9000000066ed5b8
  intrDispatchMD(??, ??, ??) at 0x9000000066edf04
  usl_getinfo_user(0x3800, 0x8fffffff0000000, 0x3800, 0x1146b8a60)
  at 0x9fffffff0008c4c
  uloadquery(??, ??, ??, ??, ??, ??, ??) at 0x9fffffff0009160
  loadquery(0x200000002, 0x1146b8a60, 0x380000003800, 0x0,
  0x6462327677703100, 0xca200000ca2, 0x80, 0x7f7f7f7f7f7f7f7f) at
  0x90000000003cce0
  sqloprocname(0x1146bc6a1, 0x27) at 0x900000000fe5000
  @75@collectFFDC(SQLT_FFDC_REC*,SQLT_CFP*)(??, ??) at
  0x900000000effccc
  @75@sqltfast2__FP8SQLT_CFPUiPvT2(??, ??, ??, ??) at
  0x90000000105d13c
  sqlt_logadmin(??, ??, ??, ??, ??, ??, ??) at 0x90000000124965c
  sqlexGetDefaultLoginContext__fdpr_2() at 0x9000000010f1cb0
  sqlex_get_appn_login_context__FP16SQLEX_AUTHINFO_TP5sqlcaP19SEC_
  PLUGIN_HANDLE_T(??, ??, ??) at 0x90000000102a398
  sqlex_get_current_userid__FUcPcPiP5sqlca(??, ??, ??, ??) at
  0x900000000f98a64
  sqlex_gen_record__FciT2sP16SQLEX_AUD_DATA_TP20SQLEX_AUDIT_RECORD
  _T(??, ??, ??, ??, ??, ??) at 0x900000000f980cc
  sqlex_aud_rec_func__FcUiT2sP16SQLEX_AUD_DATA_TPUiP5sqlca__fdpr_1
  (??, ??, ??, ??, ??, ??, ??) at 0x900000001014c0c
  sqlex_get_appn_login_context__FP16SQLEX_AUTHINFO_TP5sqlcaP19SEC_
  PLUGIN_HANDLE_T__fdpr_1(??, ??, ??) at 0x900000001014598
  sqlex_get_current_userid__FUcPcPiP5sqlca(??, ??, ??, ??) at
  0x900000000f98a64
  sqlex_gen_record__FciT2sP16SQLEX_AUD_DATA_TP20SQLEX_AUDIT_RECORD
  _T(??, ??, ??, ??, ??, ??) at 0x900000000f980cc
  sqlex_aud_rec_func__FcUiT2sP16SQLEX_AUD_DATA_TPUiP5sqlca__fdpr_1
  (??, ??, ??, ??, ??, ??, ??) at 0x900000001014c0c
  sqlex_get_appn_login_context__FP16SQLEX_AUTHINFO_TP5sqlcaP19SEC_
  PLUGIN_HANDLE_T__fdpr_1(??, ??, ??) at 0x900000001014598
  sqlex_get_current_userid__FUcPcPiP5sqlca(??, ??, ??, ??) at
  0x900000000f98a64
  sqlex_gen_record__FciT2sP16SQLEX_AUD_DATA_TP20SQLEX_AUDIT_RECORD
  _T(??, ??, ??, ??, ??, ??) at 0x900000000f980cc
  sqlex_aud_rec_func__FcUiT2sP16SQLEX_AUD_DATA_TPUiP5sqlca__fdpr_1
  (??, ??, ??, ??, ??, ??, ??) at 0x900000001014c0c
  
  
  .....................
  
  
  
  sqlex_get_appn_login_context__FP16SQLEX_AUTHINFO_TP5sqlcaP19SEC_
  PLUGIN_HANDLE_T__fdpr_1(??, ??, ??) at 0x900000001014598
  sqlex_get_current_userid__FUcPcPiP5sqlca(??, ??, ??, ??) at
  0x900000000f98a64
  sqlex_gen_record__FciT2sP16SQLEX_AUD_DATA_TP20SQLEX_AUDIT_RECORD
  _T(??, ??, ??, ??, ??, ??) at 0x900000000f980cc
  sqlex_aud_rec_func__FcUiT2sP16SQLEX_AUD_DATA_TPUiP5sqlca__fdpr_1
  (??, ??, ??, ??, ??, ??, ??) at 0x900000001014c0c
  sqlex_get_appn_login_context__FP16SQLEX_AUTHINFO_TP5sqlcaP19SEC_
  PLUGIN_HANDLE_T__fdpr_1(??, ??, ??) at 0x900000001014598
  sqlex_get_current_userid__FUcPcPiP5sqlca(??, ??, ??, ??) at
  0x900000000f98a64
  sqlex_gen_record__FciT2sP16SQLEX_AUD_DATA_TP20SQLEX_AUDIT_RECORD
  _T(??, ??, ??, ??, ??, ??) at 0x900000000f980cc
  sqlex_aud_rec_func__FcUiT2sP16SQLEX_AUD_DATA_TPUiP5sqlca__fdpr_1
  (??, ??, ??, ??, ??, ??, ??) at 0x900000001014c0c
  sqlex_get_conn_login_context__FPcT1P28SQLEX_LOGIN_CONTEXT_HANDLE
  _TP16SQLEX_AUTHINFO_TP5sqlcaP7UCintfc__fdpr_1(??, ??, ??, ??,
  ??, ??) at 0
  x90000000102cf48
  sqlex_get_login_context__FP7UCintfcUc(??, ??) at
  0x9000000010295a4
  sqlexAppAuthenticate__FP7UCintfc(??) at 0x900000001029338
  sqljrDrdaArConnect__FP7UCintfc(??) at 0x9000000012023d0
  sqleUCdrdaARinit__FP11UCconHandle(??) at 0x90000000111c660
  sqleUCappConnect__fdpr_2(0x113ed4460, 0x113ec6a4c, 0x113ec6080,
  0x0) at 0x90000000111c298
  CLI_sqlConnect__FP15CLI_CONNECTINFOP5sqlcaP19CLI_ERRORHEADERINFO
  (??, ??, ??) at 0x90000000111e91c
  SQLConnect2__FP15CLI_CONNECTINFOPUcsT2T3T2T3T2T3Uc(0x113ec6080,
  0x113ec6a40, 0x1b8000001b80, 0x113ec6180, 0x0, 0x1147b7150, 0x0,
  0x0) at 0
  x900000000fab254
  SQLDriverConnect2__FP15CLI_CONNECTINFOPvPUcsT3T4PsUsUcT9P19CLI_E
  RRORHEADERINFO__fdpr_42(0x113ec6080, 0x0, 0x113ec6080,
  0x9001000a050a750,
  0x1147b71e0, 0x8422422b00000000, 0x90000000112cb2c, 0x0) at
  0x900000000fa9f78
  SQLDriverConnectW(0x200000002, 0x7300000073, 0x7000000001a16f0,
  0x4fffffffa, 0x22, 0x5, 0x1147b72e0, 0x1147b7298) at
  0x900000001390b84
  Java_COM_ibm_db2_jdbc_app_DB2Connection_SQLConnect() at
  0x9000000076dd50c
  

Local fix

Problem summary

• INFINITE RECURISON CALLS OF SQLEX_AUD_REC_FUNC() BRINGS DOWN
  QUERY PATROLLER WITH SEGV
  

Problem conclusion

• First fixed in DB2 UDB Version 8.1, FixPak 17a
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IZ28337

Fix information

• Fixed component name

  DB2 UDB QP AIX

• Fixed component ID

  5724E2500

Applicable component levels

• R820 PSY

     UP