|
Problem IC95142
|
Status: Closed |
UPGRADE FROM DOWNLEVEL PERMITS OTHER CONNECTION FROM SAME USER PERFORMING UPGRADE TO CONNECT AND CRASH THE SERVER. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See problem description above. *
****************************************************************
* RECOMMENDATION: *
* First Fixed in Version DB2 10.1Fix Pack 4. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in Version DB2 10.1Fix Pack 4. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC97759
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.08.2013
18.04.2014
18.04.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.4
|
 |
