Informix - Problem description
Problem IT27514 | Status: Closed |
BTREE SEARCH OPERATIONS WITH INTENTION TO MODIFY MAY UPDATE MANYPAGES WITH POTENTIAL FOR PHSYICAL LOG OVERFLOW | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The internal function within IDS known as btusearch() will search an index fragment from the root to locate a given item. The search will traverse the levels of the btree and leaf pages within a level to locate the key value and rowid. Depending on how the function is called the pages may be checked as candidates for page split or merge operations, each of which could result in pages being written to the physical log. Index maintenance operations such as the sysadmin task "fragment repack" may result in large numbers of pages being physically logged as the index is repacked. Checkpoints will be triggered if necessary as the physical log fills but if the level of system activity is such that there are a number of such operations running concurrently then a situation may arise when the physical log fills completely. This will result in an Assert Failure: Physical log file overflow and the IDS server will need to be restarted. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC9 or older versions. * **************************************************************** * PROBLEM DESCRIPTION: * * Btree search operations with intention to modify may update * * many pages with potential for phsyical log overflow. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.12.2018 08.10.2019 08.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC10 | |
Problem solved according to the fixlist(s) of the following version(s) |