|
Problem IT15987
|
Status: Closed |
FODC_TRAP, DROP() HIT SEGV DURING SQLNR_SPLIT_AND_GBPD |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 10.1 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 10.1 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.07.2016
02.03.2017
02.03.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
