DB2 - Problembeschreibung
Problem IC95142 | Status: Geschlossen |
UPGRADE FROM DOWNLEVEL PERMITS OTHER CONNECTION FROM SAME USER PERFORMING UPGRADE TO CONNECT AND CRASH THE SERVER. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
When restore a downlevel database backup on a higher level instance which is quiesced we end up downgrading the upgrade connection from super exclusive to exclusive. This can allow other connections from user performing upgrade to get through and crash the server. db2diag.log *********** -------------------------------- 240 I366813102E621 LEVEL: Error PID : 543 TID : 140723445819136 PROC : db2sysc 0 INSTANCE: xxxx NODE : 000 DB : APPHDL : 0-563 APPID: *LOCAL.xxxx.999999999999 AUTHID : HOSTNAME: testibm EDUID : 588 EDUNAME: db2agent 0 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10 MESSAGE : Error in agent servicing application with APPLICATION NAME: DATA #1 : Hexdump, 8 bytes 0x00000002196D83F2 : 7065 726C 352E 3130 perl5.10 <-- other connection during migration Stack trace: *********** 0x00007FFFF00A6DBA _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x020a (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2osse.so.1) 0x00007FFFF00A6B4B ossDumpStackTraceV98 + 0x002b (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2osse.so.1) 0x00007FFFF00A1A73 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x0103 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2osse.so.1) 0x00007FFFF393ABF7 sqlo_trce + 0x0407 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF3985DE7 sqloEDUCodeTrapHandler + 0x0277 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1)Page 7 of 31 0x00007FFFF7BD04A0 address: 0x00007FFFF7BD04A0 ; dladdress: 0x00007FFFF7BC1000 ; offset in lib: 0x000000000000F4A0 ; (/lib64/libpthread.so.0) 0x00007FFFF483FBD3 _ZN16sqlrlCatalogScan5fetchEv + 0x03a3 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF25C9740 _Z23sqlrlFetchEnabledWlDefsP8sqlrr_cbPPvbPP12sqlrw_wl_def + 0x02c0 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF23A2AD5 _Z19sqlrwBuildWlDefListP8sqlrr_cbPP12sqlrw_wl_defPib + 0x00d5 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF23A2849 _Z23sqlrwCreateCatWlDefListP8sqlrr_cb + 0x0079 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF23ACB82 _Z22sqlrwPopulateCatWLMCbsP8sqlrr_cb + 0x0082 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF234B260 _Z15sqlrr_appl_initP8sqeAgentP5sqlca + 0x1cd0Page 8 of 31 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF17E3DDC _ZN14sqeApplication20InitEngineComponentsEcP8sqeAgentP8SQLE_BWAP 5sqlcaP2 2SQLESRSU_STATUS_VECTORc + 0x069c (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF17E2877 _ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlca Pc + 0x0697 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF17DC0F5 address: 0x00007FFFF17DC0F5 ; dladdress: 0x00007FFFF0597000 ; offset in lib: 0x00000000012450F5 ; (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF17DAD49 _ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x01a9 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF1985AB0 _Z11sqlelostWrpP14db2UCinterface + 0x0020Page 9 of 31 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF1984D7F _Z14sqleUCengnInitP14db2UCinterfacet + 0x052f (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF198404F sqleUCagentConnect + 0x038f (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 0x00007FFFF1A3A6D9 _Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x00d9 (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See problem description above. * **************************************************************** * RECOMMENDATION: * * First Fixed in Version DB2 10.1Fix Pack 4. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in Version DB2 10.1Fix Pack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC97759 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.08.2013 18.04.2014 18.04.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |