|
Problem IC97369
|
Status: Closed |
Crash recovery through an inplace reorg may fail with SQL1224N if a tablespace is not available. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
If an instance crashes while an inplace reorg is in progress, if
the tablespace in which the table that is being reorged resides
is not available during the crash recovery, the crash recovery
may fail with SQL1224N.
The stack trace of the agent servicing the failed crash
recovery may look like this :
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAB70ED9E5
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
(/home/mikeho/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB70ED5EC ossDumpStackTraceV98 + 0x002c
(/home/mikeho/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB70E870D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
(/home/mikeho/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB187326D sqlo_trce + 0x03ed
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB18C7F0F sqloEDUCodeTrapHandler + 0x025f
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAABD5E00 address: 0x00002AAAAABD5E00 ; dladdress:
0x00002AAAAABC8000 ; offset in lib: 0x000000000000DE00 ;
(/lib64/libpthread.so.0)
0x00002AAAB054D0D8 _Z16sqldOLRTerminateP13SQLD_DFM_WORKtmtt +
0x0068
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB050B79B address: 0x00002AAAB050B79B ; dladdress:
0x00002AAAAACE1000 ; offset in lib: 0x000000000582A79B ;
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0510A4C
_Z10sqldomUndoP8sqeAgentP10SQLDOM_LRHP9SQLP_LSN8sP15SQLD_RECOV_I
NFO + 0x068c
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAABFDB8EC
_Z8sqldmundP8sqeAgentP8SQLP_LRHPcP15SQLD_RECOV_INFO + 0x059c
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAF5BB5B2
_Z8sqlptudoP8sqeAgentPmP15SQLD_RECOV_INFOP11SQLP_TENTRYP8SQLP_LR
HPc + 0x01e2
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB19DFC02 _Z8sqlprudmP8sqeAgent + 0x0f12
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB19A5DFF _Z8sqlprbckP8sqeAgent + 0x0d6f
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB19AC98C _Z20sqlprDbBackwardPhaseP8sqeAgentRi + 0x037c
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB19AD6DD
_Z8sqlprecmP8sqeAgentP9SQLP_LSN8Pmj10sqlprTypes + 0x052d
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB19B8E16
_Z8sqlpresrP8sqeAgentP16sqlpRecoveryTypePbP5sqlca + 0x09d6
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0C3C554
_ZN16sqeLocalDatabase15RecoverDatabaseEP8sqeAgentPbS2_P5sqlca +
0x0154
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0C3EB58
_ZN16sqeLocalDatabase15RestartDatabaseEP14sqeApplicationP8sqeAge
ntP8SQLE_BWAP22SQLESRSU_STATUS_VECTORP5sqlca + 0x02d8
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE803AEA
_ZN14sqeApplication20InitEngineComponentsEcP8sqeAgentP8SQLE_BWAP
5sqlcaP22SQLESRSU_STATUS_VECTORc + 0x1e2a
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE800351
_ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlca
Pc + 0x0771
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE7F7284
_ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x0574
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE9F5720 _Z11sqlelostWrpP14db2UCinterface + 0x0040
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE9F45FC _Z14sqleUCengnInitP14db2UCinterfacet + 0x06ec
(/home/mikeho/sqllib/lib64/libdb2e.so.1)
0x00002AAAAE9F3032 sqleUCagentConnect + 0x04d2
(/home/mikeho/sqllib/lib64/libdb2e.so.1) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.11.2013
11.02.2015
11.02.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
