|
Problem IC74412
|
Status: Closed |
DB2 CRASH AFTER SYSFUN.USERS_GROUPS TABLE FUNCTION ABNORMALLY TERMINATES |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
DB2 CRASH AFTER SYSFUN.USERS_GROUPS TABLE FUNCTION ABNORMALLY
TERMINATES
In db2diag.log:
2011-02-01-08.00.02.629349+660 I6110387A653 LEVEL: Warning
PID : 839690 TID : 131975 PROC : db2sysc
0
INSTANCE: name01 NODE : 000 DB :
name0101
APPHDL : 0-6948 APPID: *N0.name01.110204103154
AUTHID : P08093
EDUID : 131975 EDUNAME: db2agent (name0101) 0
FUNCTION: DB2 UDB, oper system services,
sqloInvokeInterruptible, probe:20
DATA #1 : String, 208 bytes
An unfenced User Defined Function (UDF) was abnormally
terminated.
This may leave the DB2 engine in inconsistent state.
It is recommended that DB2 server instance is stopped and
restarted as soon as possible.
2011-02-01-08.00.02.630932+660 I6111041A1212 LEVEL: Error
PID : 839690 TID : 131975 PROC : db2sysc
0
INSTANCE: name01 NODE : 000 DB :
name0101
APPHDL : 0-6948 APPID: *N0.name01.110204103154
AUTHID : P08093
EDUID : 131975 EDUNAME: db2agent (name0101) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging func, probe:0
MESSAGE : Reporting -1476; old SQLCA:
DATA #1 : Hexdump, 136 bytes
0x07800000018F3BE8 : 5351 4C43 4120 2020 0000 0088 FFFF FE52
SQLCA .......R
0x07800000018F3BF8 : 0020 5359 5346 554E 2E55 5345 5253 5F47
. SYSFUN.USERS_G
0x07800000018F3C08 : 524F 5550 53FF 5553 4552 535F 4752 4F55
ROUPS.USERS_GROU
0x07800000018F3C18 : 5053 2020 2020 2020 2020 2020 2020 2020
PS
......
There are two thread stacks, the first is:
<StackTrace>
strcmp
sqloLookupGroupInfoForUser
sqlolgr3
getListofUsersAndGroups
sqloInvokeFnArgs
sqloInvokeUDF
sqloInvokeUDF
sqlriInvokerTrusted
sqlriInvokeInvoker
sqlriutf__FP8sqlrr_cb
sqlri_tfopn
sqlriopn
sqlriopn
sqlrita
sqlriopn
sqlrita
sqlriNljnPiped
sqlriSectInvoke
sqlrr_process_fetch_request
sqlrr_open
sqljs_ddm_opnqry
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDriveRequests
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqlzRunEDU
sqloEDUEntry
</StackTrace>
The second is:
<StackTrace>
sqloCrashOnCriticalMemoryValidationFailure
sqloCrashOnCriticalMemoryValidationFailure
sqlofmblkEx
sqlerCallDL
sqljs_ddm_excsqlstt
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDriveRequests
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
RunEDU
EDUDriver
sqlzRunEDU
EDUDriver
sqlzRunEDU
sqloEDUEntry
</StackTrace>
Local Fix:
The groupsforuser function SYSFUN.USERS_GROUPS has been
deprecated in DB2 V9.5, the AUTH_LIST_GROUPS_FOR_AUTHID table
function is recommended to use instead. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 CRASH AFTER SYSFUN.USERS_GROUPS TABLE FUNCTION *
* ABNORMALLY TERMINATES *
* *
* In db2diag.log: *
* 2011-02-01-08.00.02.629349+660 I6110387A653 LEVEL: *
* Warning *
* PID : 839690 TID : 131975 PROC : *
* db2sysc 0 *
* INSTANCE: dwaprd NODE : 000 DB : *
* DWAPRD01 *
* APPHDL : 0-6948 APPID: *N0.dwaprd.110204103154 *
* AUTHID : P08093 *
* EDUID : 131975 EDUNAME: db2agent (DWAPRD01) 0 *
* FUNCTION: DB2 UDB, oper system services, *
* sqloInvokeInterruptible, probe:20 *
* DATA #1 : String, 208 bytes *
* An unfenced User Defined Function (UDF) was abnormally *
* terminated. *
* This may leave the DB2 engine in inconsistent state. *
* It is recommended that DB2 server instance is stopped and *
* restarted as soon as possible. *
* *
* 2011-02-01-08.00.02.630932+660 I6111041A1212 LEVEL: *
* Error *
* PID : 839690 TID : 131975 PROC : *
* db2sysc 0 *
* INSTANCE: dwaprd NODE : 000 DB : *
* DWAPRD01 *
* APPHDL : 0-6948 APPID: *N0.dwaprd.110204103154 *
* AUTHID : P08093 *
* EDUID : 131975 EDUNAME: db2agent (DWAPRD01) 0 *
* FUNCTION: DB2 UDB, trace services, sqlt_logerr_data *
* (secondary logging func, probe:0 *
* MESSAGE : Reporting -1476; old SQLCA: *
* DATA #1 : Hexdump, 136 bytes *
* 0x07800000018F3BE8 : 5351 4C43 4120 2020 0000 0088 FFFF FE52 *
* SQLCA .......R *
* 0x07800000018F3BF8 : 0020 5359 5346 554E 2E55 5345 5253 5F47 *
* . SYSFUN.USERS_G *
* 0x07800000018F3C08 : 524F 5550 53FF 5553 4552 535F 4752 4F55 *
* ROUPS.USERS_GROU *
* 0x07800000018F3C18 : 5053 2020 2020 2020 2020 2020 2020 2020 *
* PS *
* ...... *
* *
* There is 2 thread stack, the first is: *
* <StackTrace> *
* *
* -------Frame------ ------Function + Offset------ *
* *
* 0x0900000001BF50E8 strcmp + 0x4 *
* *
* 0x09000000015228A4 *
* *
* @71@sqloLookupGroupInfoForUser__FCP11SQLO_USERPWCP13sqlo_ubi_d
* + *
* 0x8A0 *
* \u0007P *
* 0x0900000001521F1C sqlolgr3 + 0x228 *
* *
* 0x0900000012590ACC getListofUsersAndGroups + 0x26C *
* *
* 0x090000000D84FA0C sqloInvokeFnArgs + 0xC0 *
* *
* 0x090000000FD154E0 sqloInvokeUDF + 0x220 *
* *
* 0x090000000FD15214 sqloInvokeUDF@glue50E + 0x7C *
* *
* 0x090000000D9AC8CC *
* *
* sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf *
* + 0x1024 *
* 0x090000000DB03A38 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90 *
* *
* 0x090000000EB67D98 sqlriutf__FP8sqlrr_cb + 0x130 *
* *
* 0x090000000E61E0AC sqlri_tfopn__FP8sqlrr_cbP9sqlri_tao + *
* 0x1D4 *
* 0x090000000D667D90 sqlriopn__FP8sqlrr_cbP9sqlri_taoPi + *
* 0x7C0 *
* 0x090000000D7DADD0 *
* sqlriopn__FP8sqlrr_cbP9sqlri_taoPi@glue1D1 + 0x70 *
* 0x090000000D79D1E8 sqlrita__FP8sqlrr_cb + 0xC *
* *
* 0x090000000D7DADD0 *
* sqlriopn__FP8sqlrr_cbP9sqlri_taoPi@glue1D1 + 0x70 *
* 0x090000000D79D1E8 sqlrita__FP8sqlrr_cb + 0xC *
* *
* 0x090000000D7FED08 sqlriNljnPiped__FP8sqlrr_cb - 0x7C *
* \u0007P *
* 0x090000000D801BE0 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x7A8 *
* 0x090000000D836A24 *
* sqlrr_process_fetch_request__FP14db2UCinterface + *
* 0x150 *
* *
* 0x090000000D82F7D0 *
* sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + *
* 0x518 *
* *
* 0x090000000D985C28 *
* sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject *
* + 0x95C *
* *
* 0x090000000D9851C4 *
* *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
* *
* e + 0x4 *
* *
* 0x090000000D841DA0 *
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - *
* 0x124 *
* *
* 0x090000000D84336C *
* @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x168 *
* 0x090000000D93D228 *
* @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle *
* + 0x98 *
* *
* 0x090000000D93D090 *
* @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + *
* \u0007P *
* 0xE4 *
* *
* 0x090000000D93CDE0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
* + 0xD8 *
* 0x090000000D895498 RunEDU__8sqeAgentFv + 0x11C *
* *
* 0x090000000D895200 EDUDriver__9sqzEDUObjFv + 0x94 *
* *
* 0x090000000D89C734 sqlzRunEDU__FPcUi + 0xC *
* *
* 0x090000000D89C6F0 sqloEDUEntry + 0x57C *
* *
* </StackTrace> *
* *
* *
* The second is: *
* <StackTrace> *
* *
* -------Frame------ ------Function + Offset------ *
* *
* 0x090000000F88BA58 *
* sqloCrashOnCriticalMemoryValidationFailure + 0x30 *
* 0x090000000F88CC44 *
* sqloCrashOnCriticalMemoryValidationFailure@glue5F7 + *
* \u0007P *
* 0x74 *
* *
* 0x090000000DE522D4 sqlofmblkEx + 0x38 *
* *
* 0x090000000D97A26C *
* sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x6DC *
* 0x090000000D97A510 *
* *
* sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + *
* 0xA8 *
* 0x090000000D841F8C *
* *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
* *
* e + 0x78 *
* *
* 0x090000000D841DA0 *
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - *
* 0x124 *
* *
* 0x090000000D84336C *
* @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x168 *
* 0x090000000D93D228 *
* @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle *
* + 0x98 *
* *
* 0x090000000D93D090 *
* @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + *
* 0xE4 *
* *
* 0x090000000D93CDE0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
* + 0xD8 \u0007P *
* 0x090000000D895498 RunEDU__8sqeAgentFv + 0x11C *
* *
* 0x090000000D895200 EDUDriver__9sqzEDUObjFv + 0x94 *
* *
* 0x090000000D89C734 sqlzRunEDU__FPcUi + 0xC *
* *
* 0x090000000D895200 EDUDriver__9sqzEDUObjFv + 0x94 *
* *
* 0x090000000D89C734 sqlzRunEDU__FPcUi + 0xC *
* *
* 0x090000000D89C6F0 sqloEDUEntry + 0x57C *
* *
* </StackTrace> *
* *
* Local Fix: *
* The groupsforuser function SYSFUN.USERS_GROUPS has been *
* deprecated in DB2 V9.5, the AUTH_LIST_GROUPS_FOR_AUTHID *
* table function is recommended to use instead. *
****************************************************************
* RECOMMENDATION: *
* Upgrde to DB2 version 9.5fp8 *
**************************************************************** |
| Local Fix: |
The groupsforuser function SYSFUN.USERS_GROUPS has been
deprecated in DB2 V9.5, the AUTH_LIST_GROUPS_FOR_AUTHID table
function is recommended to use instead. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.5fp8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.02.2011
17.08.2011
17.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
