|
Problem IT10132
|
Status: Closed |
INFINITE LOOP DURING INSERT INTO INSERT TIME CLUSTERING TABLE RESULTING IN TRANSACTION LOG FULL |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When inserting into an insert time clustering (ITC) table (i.e.
a table created with the ORGANIZE BY INSERT TIME option of the
CREATE TABLE statement), the INSERT statement might get stuck in
an infinite loop while searching for free space. The problem
occurs after a portion of the table has been filled and emptied
hundreds of times. The database manager incorrectly treats the
ITC table as it were in append mode, resulting in wasted space
in the table as deleted slots are never reused and more more
slots are added to pages. Eventually all the pages in multiple
extents contain so many deleted slots that there is no longer
room for a single record in the page. The database manager
updates the state of these pages in an infinite loop until a
transaction log full error is hit.
A trace of the INSERT statement will show the following two
functions being called repeatedly:
sqldExtendAppendCache
sqldSwitchFromAppendToPossiblyEmpty
sqldVirtualColumnDeleteKey
sqldVirtualColumnAddKey
and
sqldExtendAppendCache
sqldCreateNewAppendCache
sqldCreateAppendCachePagesForMDCTable
sqldVirtualColumnDeleteKey
sqldVirtualColumnAddKey |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
Force the application inserting into the ITC table and recreate
the table without the ORGANIZE BY INSERT TIME option. |
| Solution |
First fixed in DB2 Version 10.5 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.07.2015
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
