|
Problem IT22447
|
Status: Closed |
VARIOUS -901 SQLCODES AND TRAPS DURING COMPILATION RELATING TO ACCESS OF THE TABLE PACKED DESCRIPTOR |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
If auto-runstats is running on a table, then the rollback of the
runstats or other DDL on the table that occurs while other
transactions are in the middle of compilation can result in
various -901 SQLCODEs or traps as the table packed descriptor
may be removed from memory while being accessed.
Example symptoms include
Traps with the following stacks:
sqlcode -901:
"Invalid collation ID" from sqlnq_get_collation
"qunp has more columns then base table" from
sqlng_build_colRefs_obj
Traps:
Sig#11 Trap sqlng_build_IndexList_obj
0x00007FCFE0C33B8C sqloEDUCodeTrapHandler + 0x03ac
0x00007FCFDF982D15
_Z25sqlng_build_IndexList_objP9sqlng_blkttP8sqlrg_pdP18sqlrg_dat
apartinfoPP14sqlriIndexList + 0x02e5
0x00007FCFDF93F041
_Z20sqlngRecordTableInfoP9sqlng_blktthP9sqlnq_ftbbbP19sqlno_plan
_operator + 0x0321
0x00007FCFDFA5455A
_Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb
+ 0x06fa
0x00007FCFDF94A75E
_Z26sqlngProcessCdeCseProducerP9sqlng_blkP19sqlno_plan_operator
+ 0x061e
0x00007FCFDFA541AF
_Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb
+ 0x034f
Sig#11 Trap sqlngMemBlockLookup
0x00007F950C8D7B8C sqloEDUCodeTrapHandler + 0x03ac
0x00007F950B70F2D9
_Z19sqlngMemBlockLookupP9sqlng_blkPvmRP15sqlngSectObject +
0x03a9
0x00007F950B70DC70 _Z23sqlngSectSetPtrInternalP9sqlng_blkPvS1_m
+ 0x0130
0x00007F950B6E31F9
_Z18sqlng_build_TQA_opP9sqlng_blkP19sqlno_plan_operator + 0x0869
0x00007F950B6E1F89
_Z19sqlng_process_tq_opP9sqlng_blkP19sqlno_plan_operator +
0x0739
0x00007F950B6F82E4
_Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb
+ 0x0484
Sig #11 Trap sqlrlc_find_invalidate
0x00007F421E485B8C sqloEDUCodeTrapHandler + 0x03ac
0x00007F421F5BE64E
_Z22sqlrlc_find_invalidateP8sqlrr_cbP10sqlrlc_keyjP8SQLZ_RID +
0x07ce
0x00007F421F5FBFE6
_Z14sqlrlc_end_uowP8sqlrr_cbiP19sqlr_savepoint_info + 0x0246
0x00007F421EAAE020
_Z29sqlrr_cleanup_tran_before_DPSP8sqlrr_cbiiiiiiiPiS1_ + 0x1520
0x00007F421EADDABA _Z17sqlrr_tran_routerP8sqlrr_cb + 0x0eea |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher *
**************************************************************** |
| Local Fix: |
disable autorunstats (database configuration auto_runstats) |
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in Db2 11.1 Mod 3 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.09.2017
19.03.2018
19.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
