Informix - Problembeschreibung
Problem IT09609 | Status: Geschlossen |
RSAM MEMORY POOL CORRUPTION RUNNING UPDATE STATISTICS ON TABLE WITH USTLOW_SAMPLE ENABLED (SET TO 1) | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
With certain types of indexes the low sample feature has problems which leads to corrupting a block in the RSAM pool. The trigger seems to be a composite unique index where the lead column of the index has only 1 value for the entire table. This corruption can be seen with onstat -g mem output when looking at the rsam pool, it's size could be nonsensical (ie larger then all of shared memory on the instance), if the table were to be dropped, it would then lead to block header corruption assertion failures. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * users running update statistics * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.06.2015 30.12.2015 30.12.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6 | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |