|
Problem IC63524
|
Status: Closed |
PANIC DURING COMMIT FROM SQLDINVCURSORPOS ON ONLINE MOVE TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Panic can occur during sqldInvCursorPos() function processing
with a partitioned table
2009-09-30-11.19.23.401863-240 I73670567A443 LEVEL: Severe
PID : 663804 TID : 11824 PROC : db2sysc
INSTANCE: svtdbm10 NODE : 000 DB : HADR
APPHDL : 0-25 APPID:
*LOCAL.svtdbm10.090930151705
AUTHID : SVTDBM10
EDUID : 11824 EDUNAME: db2agent (HADR)
FUNCTION: DB2 UDB, data management, sqldInvCursorPos, probe:3585
MESSAGE : Unheld scan is open during COMMIT.
2009-09-30-11.19.23.402525-240 I73671011A517 LEVEL: Severe
PID : 663804 TID : 11824 PROC : db2sysc
INSTANCE: svtdbm10 NODE : 000 DB : HADR
APPHDL : 0-25 APPID:
*LOCAL.svtdbm10.090930151705
AUTHID : SVTDBM10
EDUID : 11824 EDUNAME: db2agent (HADR)
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging fu, probe:0
MESSAGE : SQLD_CCB:
DATA #1 : String, 51 bytes
pool(TID)=0, obj(FID)=1288, indexid(IID)=2, class=0
<StackTrace>
-------Frame------ ------Function + Offset------
0x09000000004B96BC pthread_kill + 0x88
0x0900000012FE5D38 sqloDumpEDU + 0x58
0x0900000012F68280 sqle_panic__Fv + 0x60
0x0900000013822330 sqldInvCursorPos__FP8sqeAgenti + 0x350
0x0900000013823044 sqldEndTransaction__FP8sqeAgenti + 0x3C4
0x0900000013BE2970
sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0xC10
0x0900000013BE9190 sqlrrcom__FP8sqlrr_cbiT2 + 0x390
0x09000000143A8798 sqlrr_commit__FP14db2UCinterface + 0x378
0x09000000169C8B4C
sqljs_ddm_rdbcmm__FP14db2UCinterfaceP13sqljDDMObject + 0x9AC
0x0900000014044F00
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x260
0x0900000014046F58
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x14B8
0x090000001402B988 sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb +
0x928
0x090000001402AEA0
sqljsDrdaAsSPDriver__FP14db2UCconHandleP17SQLCC_COMHANDLE_TPPUcl
+ 0x480
0x0900000014017694 sqlerInvokeFencedRoutine__FP13sqlerFmpParms +
0x2494
0x090000001566E398 sqlriInvokeInvoker__FP10sqlri_ufobb + 0xEF8
0x090000001566FFB4 sqlricall__FP8sqlrr_cb + 0x5F4
0x0900000014165438 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x298
0x09000000143D2480 sqlrr_process_execute_request__FP8sqlrr_cbi +
0x2BE0
0x0900000014396AF4 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x494
0x090000001569BF6C executeSection__10pvmPackageFP5sqlcaUi +
0x70C
0x09000000156A28D8 executeQuery__3PVMFUi + 0x198
0x09000000156A1958 run__3PVMFv + 0xBB8
0x09000000156971C4 pvm_entry + 0x444
0x0900000012F9BEFC sqloInvokeFnArgs + 0xBC
0x0900000015676350
sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf +
0x1390
0x090000001566EEF0 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x1A50
0x090000001566FFB4 sqlricall__FP8sqlrr_cb + 0x5F4
0x0900000014165438 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x298
0x09000000143D2480 sqlrr_process_execute_request__FP8sqlrr_cbi +
0x2BE0
0x0900000014396AF4 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x494
0x09000000169B99E4
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x5E4
0x0900000014044EB8
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x218
0x0900000014046F58
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x14B8
0x090000001402B988 sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb +
0x928
0x0900000014030820
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x160
0x090000001402A424
sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x4E4
0x09000000140294B8 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x2F8
0x0900000013073788 RunEDU__8sqeAgentFv + 0xB08
0x09000000130661D8 EDUDriver__9sqzEDUObjFv + 0x278
0x0900000013065F10 sqlzRunEDU__FPcUi + 0x10
0x0900000012FE2AAC sqloEDUEntry + 0x2CC
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2diag.log.. *
* *
* 2009-09-30-11.19.23.401863-240 I73670567A443 LEVEL: *
* Severe *
* PID : 663804 TID : 11824 PROC : *
* db2sysc *
* INSTANCE: svtdbm10 NODE : 000 DB : *
* HADR *
* APPHDL : 0-25 APPID: *
* *LOCAL.svtdbm10.090930151705 *
* AUTHID : SVTDBM10 *
* EDUID : 11824 EDUNAME: db2agent (HADR) *
* FUNCTION: DB2 UDB, data management, sqldInvCursorPos, *
* probe:3585 *
* MESSAGE : Unheld scan is open during COMMIT. *
* *
* 2009-09-30-11.19.23.402525-240 I73671011A517 LEVEL: *
* Severe *
* PID : 663804 TID : 11824 PROC : *
* db2sysc *
* INSTANCE: svtdbm10 NODE : 000 DB : *
* HADR *
* APPHDL : 0-25 APPID: *
* *LOCAL.svtdbm10.090930151705 *
* AUTHID : SVTDBM10 *
* EDUID : 11824 EDUNAME: db2agent (HADR) *
* FUNCTION: DB2 UDB, trace services, sqlt_logerr_string *
* (secondary logging fu, probe:0 *
* MESSAGE : SQLD_CCB: *
* DATA #1 : String, 51 bytes *
* pool(TID)=0, obj(FID)=1288, indexid(IID)=2, class=0 *
* *
* *
* *
* <StackTrace> *
* -------Frame------ ------Function + Offset------ *
* 0x09000000004B96BC pthread_kill + 0x88 *
* 0x0900000012FE5D38 sqloDumpEDU + 0x58 *
* 0x0900000012F68280 sqle_panic__Fv + 0x60 *
* 0x0900000013822330 sqldInvCursorPos__FP8sqeAgenti + 0x350 *
* 0x0900000013823044 sqldEndTransaction__FP8sqeAgenti + 0x3C4 *
* 0x0900000013BE2970 *
* sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0xC10 *
* 0x0900000013BE9190 sqlrrcom__FP8sqlrr_cbiT2 + 0x390 *
* 0x09000000143A8798 sqlrr_commit__FP14db2UCinterface + 0x378 *
* 0x09000000169C8B4C *
* sqljs_ddm_rdbcmm__FP14db2UCinterfaceP13sqljDDMObject + 0x9AC *
* 0x0900000014044F00 *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
* + 0x260 *
* 0x0900000014046F58 *
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x14B8 *
* 0x090000001402B988 sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb *
* + 0x928 *
* 0x090000001402AEA0 *
* sqljsDrdaAsSPDriver__FP14db2UCconHandleP17SQLCC_COMHANDLE_TPPU
* + 0x480 *
* 0x0900000014017694 *
* sqlerInvokeFencedRoutine__FP13sqlerFmpParms + 0x2494 *
* 0x090000001566E398 sqlriInvokeInvoker__FP10sqlri_ufobb + *
* 0xEF8 *
* 0x090000001566FFB4 sqlricall__FP8sqlrr_cb + 0x5F4 *
* 0x0900000014165438 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x298 *
* 0x09000000143D2480 *
* sqlrr_process_execute_request__FP8sqlrr_cbi + 0x2BE0 *
* 0x0900000014396AF4 *
* sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x494 *
* 0x090000001569BF6C executeSection__10pvmPackageFP5sqlcaUi + *
* 0x70C *
* 0x09000000156A28D8 executeQuery__3PVMFUi + 0x198 *
* 0x09000000156A1958 run__3PVMFv + 0xBB8 *
* 0x09000000156971C4 pvm_entry + 0x444 *
* 0x0900000012F9BEFC sqloInvokeFnArgs + 0xBC *
* 0x0900000015676350 *
* sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf *
* + 0x1390 *
* 0x090000001566EEF0 sqlriInvokeInvoker__FP10sqlri_ufobb + *
* 0x1A50 *
* 0x090000001566FFB4 sqlricall__FP8sqlrr_cb + 0x5F4 *
* 0x0900000014165438 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x298 *
* 0x09000000143D2480 *
* sqlrr_process_execute_request__FP8sqlrr_cbi + 0x2BE0 *
* 0x0900000014396AF4 *
* sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x494 *
* 0x09000000169B99E4 *
* sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + *
* 0x5E4 *
* 0x0900000014044EB8 *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
* + 0x218 *
* 0x0900000014046F58 *
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x14B8 *
* 0x090000001402B988 sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb *
* + 0x928 *
* 0x0900000014030820 *
* sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x160 *
* 0x090000001402A424 *
* sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x4E4 *
* 0x09000000140294B8 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
* + 0x2F8 *
* 0x0900000013073788 RunEDU__8sqeAgentFv + 0xB08 *
* 0x09000000130661D8 EDUDriver__9sqzEDUObjFv + 0x278 *
* 0x0900000013065F10 sqlzRunEDU__FPcUi + 0x10 *
* 0x0900000012FE2AAC sqloEDUEntry + 0x2CC *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* update to v97fp1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Version V97 FixPak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.10.2009
17.02.2010
17.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
