|
Problem IC62487
|
Status: Closed |
DB2 GET SIGNAL 11 DURING THE ROLLBACK PROCESS WHEN CALLING NESTED STORE PROCEDURE IN DPF |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
When customer is calling nested store procedure, some errors may
happen (such as dead lock), and the transaction may be rolled
back.
During the rollback process, DB2 may trap with signal #11 with
below call stacks:
...
(4) 0xe0000001304fe900 ---- Signal 11 (SIGSEGV) delivered ----
(5) 0xc0000000180a9a01
_Z19sqlri_send_dss_msgsP8sqlrr_cbP10sqlri_ssobP23connect_msg_lis
t_anchorPsi
+ 0x221 at sqlri_dss.C:2076
[/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so]
(6) 0xc0000000180a5cd0 _Z9sqlri_dssP8sqlrr_cb + 0xcb0 at
sqlri_dss.C:1219 [/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so]
(7) 0xc0000000156c6d00
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x240
[/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so]
(8) 0xc000000015235200
_Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x640 at
sqlrr_sql.C:1257 [/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so]
(9) 0xc00000001529e440
_Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x740
[/opt/IBM/db2/V9.1.6.SP/lib64/libdb2e.so]
or
5 sqlriecc
6 sqlra_close_section
7 sqlra_sqlC_free_section
8 sqlra_sqlC_free_sibling
9 sqlra_sqlC_rmv_invoc_siblings
10 sqlrr_destroy_invocation_cb
11 sqlrr_chk_destroy_invocation_cb
12 sqlrr_end_invocation
In the db2diag.log, customer may see below message indicating a
rollback is happening:
2009-01-01-00.00.00.000000+000 I111111111A111 LEVEL: Severe
PID : XXXXX TID : 1 PROC :
db2agent (DBNAME) 0
INSTANCE: db2inst1 NODE : 000 DB : DBNAME
APPHDL : 0-XXX APPID: XXXXXXXX
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca, probe:20
MESSAGE : Received sqlcode -1229 (rollback) for request 80000017
(interrupt) from node number 0 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DPF users. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Abstract: DB2 GET SIGNAL 11 DURING THE ROLLBACK PROCESS *
* WHENCALLING NESTED STORE PROCEDURE IN DPF *
* Description: *
* *
* When customer is calling nested store procedure, some errors *
* may *
* happen (such as dead lock), and the transaction may be *
* rolled *
* back. *
* During the rollback process, DB2 may trap with signal #11 *
* with *
* below call stacks: *
* ... *
* (4) ---- Signal 11 (SIGSEGV) delivered ---- *
* (5) *
* _Z19sqlri_send_dss_msgsP8sqlrr_cbP10sqlri_ssobP23connect_msg_l
* + 0x221 at sqlri_dss.C:2076 *
* (6) _Z9sqlri_dssP8sqlrr_cb + 0xcb0 at sqlri_dss.C:1219 *
* (7) _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x240 *
* (8) _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x640 at *
* sqlrr_sql.C:1257 *
* (9) _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x740 *
* *
* or *
* *
* 5 sqlriecc *
* 6 sqlra_close_section *
* 7 sqlra_sqlC_free_section *
* 8 sqlra_sqlC_free_sibling *
* 9 sqlra_sqlC_rmv_invoc_siblings *
* 10 sqlrr_destroy_invocation_cb *
* 11 sqlrr_chk_destroy_invocation_cb *
* 12 sqlrr_end_invocation *
* *
* In the db2diag.log, customer may see below message *
* indicating a *
* rollback is happening: *
* *
* 2009-01-01-00.00.00.000000+000 I111111111A111 LEVEL: Severe *
* PID : XXXXX TID : 1 PROC : *
* db2agent (DBNAME) 0 *
* INSTANCE: db2inst1 NODE : 000 DB : DBNAME *
* APPHDL : 0-XXX APPID: XXXXXXXX *
* AUTHID : DB2INST1 *
* FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca, *
* probe:20 *
* MESSAGE : Received sqlcode -1229 (rollback) for request *
* 80000017 *
* (interrupt) from node number 0 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version 9.1 fix pack 9 or later. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
This problem is first fixed in version 9.1 fix pack 9. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC62551 IC65710
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.08.2009
19.04.2010
19.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
