|
Problem IT17361
|
Status: Closed |
FODC_TRAP, DROP() HIT SEGV DURING SQLNR_SPLIT_AND_GBPD |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Certain query could cause db2 server to generate FODC_trap.
Subsequently db2 server fails the query and suspends its
associated db2agent EDU.
The trap has the following stack:
DB2 build information: DB2 v10.1.0.5 special_35237 SQL10015
timestamp: 2016-06-28-04.50.06.763552
instance name: db2test1.999
EDU name : db2agent (SAMPLE) 999 [-]
EDU ID : 97052
Signal #11
uname: S:AIX R:1 V:6 M:00F630294C00 N:host01
.......
0x090000000AE6D9C4 drop__9sqlnq_qtbFP13sqlnq_memPool + 0x11FC
0x0900000009D17884 box_drop_ts__9sqlnq_qtbFiN21 + 0x1154
0x090000000C8526CC
sqlnr_split_and_gbpd__FP9sqlnq_qtb20sqlnr_partition_modeRiPP13sq
lnq_deplist + 0x368
0x090000000C852188
sqlnr_gbpd_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0xD0
0x0900000009A34520
.sqlnr_comp.fdpr.clone.1423__FPiiP16sqlnr_rule_stateP10sqlnr_qrw
aP14sqlnr_progress + 0x300
0x0900000009A33FFC
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0xBC
0x0900000009A33D1C sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress
+ 0xC4
0x0900000009A34848
sqlnr_endqtb_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x15C
0x0900000009A34520
.sqlnr_comp.fdpr.clone.1423__FPiiP16sqlnr_rule_stateP10sqlnr_qrw
aP14sqlnr_progress + 0x300
0x0900000009A33FFC
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0xBC
0x0900000009A33D1C sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress
+ 0xC4
0x0900000009A392A0
sqlnr_start_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x2F4
0x0900000009A34520
.sqlnr_comp.fdpr.clone.1423__FPiiP16sqlnr_rule_stateP10sqlnr_qrw
aP14sqlnr_progress + 0x300
0x0900000009A33FFC
sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0xBC
0x0900000009A33D1C sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress
+ 0xC4
0x090000000C933C68 sqlnr_exe__FP9sqlnq_qur + 0x188
0x090000000986C85C
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x4C0
0x090000000987275C
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x50
........ |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod1 Fix pack1 or higher *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
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 Mod1 Fix pack1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.10.2016
10.10.2017
10.10.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 11.1.1.1
|
 |
