|
Problem IT26992
|
Status: Geschlossen |
DETERMINISTIC UDF CAN CAUSE INSTANCE TO TRAP
|
| Produkt: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problembeschreibung: |
A geospatial query can cause DB2 to trap.
The trap file produced will show a stack like this:
0x00001016EFFED0C0 0x000010000F436C7C
0x00001016EFFED200 0x000010000F4353CC
_Z15sqlriusf_commonP8sqlrr_cbP10sqlri_ufob + 0x040c
0x00001016EFFED390 0x000010000F434E8C _Z8sqlriusfP8sqlrr_cb +
0x005c
0x00001016EFFED3E0 0x000010000F346760
_Z14sqlriNljnPipedP8sqlrr_cb + 0x0600
0x00001016EFFED4E0 0x000010000F29A410
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x0400
0x00001016EFFED630 0x000010000EB5964C
_Z16sqlrr_dss_routerP8sqlrr_cb + 0x09ec
0x00001016EFFED880 0x000010000EB582C8
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0eb8
0x00001016EFFEDB90 0x000010000B74BBE0
0x00001016EFFEDDF0 0x000010000B746378
_Z21sqleProcessSubRequestP8sqeAgent + 0x22c8
0x00001016EFFEE200 0x000010000B7C3298 _ZN8sqeAgent6RunEDUEv +
0x09d8
0x00001016EFFEE3D0 0x00001000105270C4 _ZN9sqzEDUObj9EDUDriverEv
+ 0x0344
0x00001016EFFEE440 0x0000100010526D5C _Z10sqlzRunEDUPcj + 0x001c
0x00001016EFFEE460 0x000010000E2D15B4 sqloEDUEntry + 0x0334
0x00001016EFFEE790 0x0000100000088AF4
0x00001016EFFEEA10 0x00001000169C8814 clone + 0x00e4
A few conditions that need to be fullfilled:
- More than 2 input parameters
- Many variations of input parameters
The problem is more likely when VARCHAR/VARBINARY input data
types are used.
BLU users might be affected since Db2 V11.1 M3FP3, non BLU users
starting with M4FP4. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher *
**************************************************************** |
| Local-Fix: |
Disable UDF caching.
ROW: db2set DB2_RUNTIME_DEBUG_FLAGS=10000000 (since M4FP4)
BLU: db2set DB2_CDE_FLAGS=288230376151711744 |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 15.11.2018
16.01.2020
16.01.2020 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
