|
Problem IT34110
|
Status: Closed |
-901 SQLCODE (CANNOT FIND CURSOR INFO IN ERT) FOLLOWED BY TRAP
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
A -901 sqlcode and FODC with the following probe in the
db2diag.log:
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 30
sqlerrmc: cannot find cursor info in ERT
sqlerrp : SQLRA19A
Trap file shows:
Followed by a seg-v (signal #11) with a stack like so:
-----Frame------ ------Address----- ------Function +
Offset------
0x000010216CFEA060 0x000010000D533BD8
_Z23sqlmTermActivityMetricsP19sqlrr_curr_activityP8sqeAgentP5sql
ca + 0x3198
( = offset 0xD253BD8 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFEBA30 0x000010000FBF8B80
_Z26sqlrr_remove_curr_activityP8sqlrr_cbiPP19sqlrr_curr_activity
+ 0x09f0
( = offset 0xF918B80 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFEBDA0 0x000010000FBD4E84
_Z23sqlrr_activity_exe_stopP8sqlrr_cb + 0x0af4
( = offset 0xF8F4E84 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFEBF40 0x000010000FEBDB88
_Z31sqlra_sqlC_disassociate_siblingP8sqlrr_cbP25sqlra_sql_contex
t_sibling + 0x0768
( = offset 0xFBDDB88 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFEC100 0x000010000FF0FC8C
_Z41sqlra_close_sections_on_finalcmt_rollbackP8sqlrr_cbPP25sqlra
_sql_context_sibling + 0x145c
( = offset 0xFC2FC8C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFEC4F0 0x000010000FF0D0AC
_Z20sqlra_close_sectionsP8sqlrr_cbjjb + 0x13ac
( = offset 0xFC2D0AC in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFEC710 0x000010000FABC948
_Z29sqlrr_cleanup_tran_before_DPSP8sqlrr_cbiiiiiiiPiS1_ + 0x0d98
( = offset 0xF7DC948 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFEC8D0 0x000010000FAC9E54
_Z8sqlrrbckP8sqlrr_cbiiiiP15SQLXA_CALL_INFO + 0x1c64
( = offset 0xF7E9E54 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFECD10 0x000010000FA66090
_Z14sqlrr_rollbackP14db2UCinterface + 0x0130
( = offset 0xF786090 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFED3E0 0x000010000CF41A30
_Z19sqljs_ddm_rdbrllbckP14db2UCinterfaceP13sqljDDMObject +
0x0b90
( = offset 0xCC61A30 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFED5F0 0x000010000CF05ED0
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x0380
( = offset 0xCC25ED0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010216CFED720 0x000010000CF0713C
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x040c |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.0 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.0 or higher *
**************************************************************** |
| Comment |
Upgrade to Db2 11.5.5.0 or higher |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.09.2020
20.11.2020
20.11.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
