|
Problem IC98734
|
Status: Closed |
ON A COLUMN-ORGANIZED TABLE, QUERIES RUNNING AT THE SAME TIME AS REORG RECLAIM EXTENTS MAY FAIL WITH SQL0901N |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
On a column-organized table, a query running at the same time
as a REORG TABLE ... RECLAIM EXTENTS may occasionally
fail with an SQLCODE SQL0901N complaining of a failed
assertion and an FODC AppErr.
In 10.5 GA, the assertion text in the diagnostic log will be of
a form similar to:
AssertionFailedException: An assertion 'pageEndTSN >=
mCurrentTSN' failed. Additional info: skipTillEndOfPage
is called to move backwards:
pageEndTSN: 144115188075859982
mCurrentTSN: 144115188075859983
TSNList.mStartTSN: 144115188075859981
TSNList.mEndTSN: 144115188075892749
Table name: TABLE16
Page header:
--- Begin dump of Page object at 0x0a00030006690030 ---
mCdePageType: 2
mCdePageFormatVersion: 1
mColGroupNumber: 1
mTupletCount: 4111
mStartTSN: 144115188075855872
(0x0200000000000000)
mPageAttributes: 0
mRegionCount: 2
mTotalDictSize: 0
mTupleMapOffset: 15600
mVariableLengthBankOffset: 0
--- End dump of Page object at 0x0a00030006690030 -----
Thrown at TSNList.cpp : 288
In DB2 10.5 FP1 through DB2 10.5 FP3, the assertion text in the
diagnostic log will be of a form similar to:
AssertionFailedException: An assertion
'(InsertRange::isUnspecifiedHWM(mRangeIndex,
mInsertRangeCachedHWMs[ mRangeIndex ]) == true ||
mCurrentStartTSN <= mInsertRangeCachedHWMs[ mRangeIndex ])'
failed. Additional info:
CurrentStartTSN greater than CachedHWM.
mCurrentStartTSN: 144115188075856241
mRangeIndex: 1
mInsertRangeCachedHWMs[ mRangeIndex ]: 144115188075856219
Table: TABLE16
Thrown at TSNRangeIterator.cpp : 292
The assertion thrown in the DB2 10.5 GA level is more generic
and could potentially indicate some other problem. The
assertion
thrown in DB2 10.5 FP1 through DB2 10.5 FP3 is more specific to
this problem scenario.
An example of the error message returned to a command line
processor session in DB2 10.5 FP1 through DB2 10.5 FP3:
SQL0901N The SQL statement or command failed because of a
database system error. (Reason "unexpected error at
TSNRangeIterator.cpp:292".)
SQLSTATE=58004 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 for Linux, UNIX, and Windows version 10.5.0.4 *
**************************************************************** |
| Local Fix: |
The problem occurs rarely and has no permanent effect on the
database. Until a fix is available, the workaround is to retry
the failing query. The problem may be avoided by not running
queries concurrently with REORG TABLE ... RECLAIM EXTENTS
operations. |
| available fix packs: |
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 is first fixed in DB2 for Linux, UNIX, and Windows
version 10.5 fix pack 4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.01.2014
06.02.2014
06.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
