DB2 - Problembeschreibung
Problem IC72594 | Status: Geschlossen |
DATABASE MAY ABEND DURING A MERGE STATEMENT IF SOURCE COLUMNS ARE MARKED AS IMPLICITLY HIDDEN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
If the source table has ROW CHANGE TIMESTAMP columns which are marked as IMPLICITLY HIDDEN then performing a merge query might lead to database crash with the following stack trace: Windows: <StackTrace> <![CDATA[ --EBP------EIP------ARGS----------------------------- 044668D8 6D662F97 00000000 54B4F234 55330060 54B4F228 offset: 00000003 in <?op@sqlnq_attattdpparent@@QAEPAVsqlnq_atd@@XZ> <T:/db2_v95fp6/nt32/s100918/engn/include/sqlnq_reldef.h:1377> 04466A9C 6D9BF11C 553A031C 00000003 00000711 553A9400 offset: 0000258E in <?sqlnq_sem_merge@@YAHQAPAUstknode_@@HW4actiontype@@PAEPAVloc@@@ Z> <sqlnq_sem_merge.C:2211> 04466AEC 6D7E3BE4 553A0220 000007E4 00000020 00000001 offset: 00000544 in <?sqlnp_smactn@@YAHPAUsqlnp_cb@@H@Z> <sqlnp_prs.C:655> 04466B58 6D7E2E89 553A0220 0365093C 4CD32BF2 0008A6D8 offset: 000001CF in <?sqlnp_parser@@YAHPAUsqlnp_cb@@@Z> <T:/db2_v95fp6/nt32/s100918/engn/sqnp/inc/sqlnp_lpgprse.h:1031> 04466BA8 6D7DEF83 044680B0 00000001 044680F4 20202020 offset: 000002D7 in <?sqlnp_main@@YAHPAVsqlnq_string@@FPAPAVsqlnq_qur@@@Z> <sqlnp_main.C:455> 044681BC 6D6AA67D 7B0AA3E0 04468D44 00000001 00000002 offset: 00000861 in<?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compile Mode@@FPAU sqlrr_cmpl_env@@HHPAPAVsqlnq_qur@@@Z> <sqlnn_cmpl.C:2518> 044681E8 6D6A9E14 7B0AA3E0 04468D44 00000001 00000002 offset: 00000024 in<?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compile Mode@@FPAU sqlrr_cmpl_env@@@Z> <sqlnn_cmpl.C:498> 04468DB8 6DD9FDA6 5515DFB0 54AD2AC0 5570FE40 00000185 offset: 000005E2 in<?sqlra_compile_var@@YAHPAUsqlrr_cb@@PAUsqlra_cmpl_env@@PAEHGH HHHHPAUsql ra_cached_var@@PAHPA_K@Z> <sqlra_cmpl.C:955> 04469790 6DDA3E9D 5515DFB0 55A680B0 00000000 00000000 offset: 00000449 in<?sqlra_find_var@@YAHPAUsqlrr_cb@@PAUsqlra_cached_stmt@@Usqlra _stmt_id@@ IIPAEIGEPAUsqlra_cmpl_env@@HPAHH5HHH5PAUSQLP_LOCK_INFO@@PAPAUsql ra_cached_var@@5PA_K_N@Z> <sqlra_dyn.C:3509> 04469EA8 6DDADDD0 5515DFB0 00000001 00000000 00000000 offset: 000004B6 in <?sqlra_get_var@@YAHPAUsqlrr_cb@@HH_NPA_N2@Z> <sqlra_var.C:589> 04469F48 6DD45E75 5515DFB0 00000000 545E07F4 545E0060 offset: 000000D7 in <?sqlrr_execute_immediate@@YAHPAUsqlrr_cb@@H@Z> <sqlrr_sql.C:1798> 04469F78 6DCC7D1E 5608FDD0 5608FDD0 00000001 0000002F offset: 00000112 in <?sqlrr_execimmd@@YAHPAUdb2UCinterface@@@Z> <sqlrr_req_sql.C:3224> 0446A02C 6D56E13B 5608FDD0 0446A0DC 7B0BFC90 0446A074 offset: 00000811 in <?sqljs_ddm_excsqlimm@@YAHPAUdb2UCinterface@@PAUsqljDDMObject@@@ Z> <sqljsexe.C:1983> 0446A08C 6D561468 545E07F4 00000355 00000000 7B0BFC90 offset: 0000020C in<?sqljsParseRdbAccessed.@@YAHPAUsqljsDrdaAsCb@@PAUsqljDDMObjec t@@PAUdb2UCinterface@@@Z> <sqljspar.C:410> On Unix: <StackTrace> --Frame--- ------Function + Offset------ 0x17CF54A8 _ZN17sqlnq_fcsqclchild2ppEv + 0x0006 (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF5674 _Z15sqlnq_sem_mergePP8stknode_i10actiontypePhP3loc + 0x286b (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF56B4 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0480 (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF5724 _Z12sqlnp_parserP8sqlnp_cb + 0x01f8 (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF5784 _Z10sqlnp_mainP12sqlnq_stringsPP9sqlnq_qur + 0x036a (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF6DB0 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x09b8 (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF6DEC _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x0034 (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF7910 _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP16sqlr a_cached_varPiPy + 0x05bf (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF82D0 _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj jPhjthP14sqlra_cmpl_enviPiiS7_iiiS7_P14SQLP_LOCK_INFOPP16sqlra_c ached_varS7_Pyb + 0x03c4 (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF89F0 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x047b (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF8A74 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x1235 (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 0x17CF8AAC _Z14sqlrr_execimmdP14db2UCinterface + 0x0340 (...) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Customer using a MERGE with implicitly hidden columns * **************************************************************** * PROBLEM DESCRIPTION: * * if the source table has ROW CHANGE TIMESTAMP columns which * * are * * marked as IMPLICITLY HIDDEN then performing a merge query * * might * * lead to database crash * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.5 fixpack 8 or later * **************************************************************** | |
Local-Fix: | |
Reverse the order of processing with UPDATE operation before INSERT operation. The workaround might not work if there is no UPDATE clause in the matching condition. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
This problem was first fixed in V9.5 Fixpack 8 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC75206 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.11.2010 08.07.2011 08.07.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP8 | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |