Informix - Problembeschreibung
Problem IC57169 | Status: Geschlossen |
AN ALTER FRAGMENT ON TABLE ATTACH PARTITION COMMAND CAUSES THE IDS TO ASSERT FAIL | |
Produkt: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problembeschreibung: | |
An alter fragment attach partition command executed on a table causes the Informix Dynamic Server (IDS) to assert failure, below is the stack trace of the problem thread: 13:07:11 13:07:11 IBM Informix Dynamic Server Version 11.50.UC1 13:07:11 Assert Failed: No Exception Handler 13:07:11 Who: Session(27, informix@, 12721, 0x4b75cd60) Thread(54, sqlexec, 4b730d98, 1) File: mtex.c Line: 475 13:07:11 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:07:11 Action: Please notify IBM Informix Technical Support. 13:07:11 See Also: /opt/informix/tmp/af.41eabce, shmem.41eabce.0 base: 0x4c4d2000 len: 36864 pc: 0x08ac9ab1 tos: 0x4c4d5ae0 state: running vp: 1 afstack mt_ex_throw_sig afsig_handler <>__kernel_rt_sigreturn fmftopen_with_child sqftopen_tab_hierarchy openrel droptab ddaltfrag aud_ddaltfrag excommand sq_execute sqmain spawn_thread startup An example of the statement that caused the IDS to assert failure: alter fragment on table call_details attach cdrpartn20080621 as partition cdrpartn20080621 (call_date = "06/21/2008") before cdrpartn20080620; | |
Problem-Zusammenfassung: | |
**************************************************************** USERS AFFECTED: IDS 11.50.xC1 **************************************************************** PROBLEM DESCRIPTION: The users can see a Informix Dynmic Server (IDS) abend due to a memory corruption, when they tried to execute an alter table attach fragment. This occurs especially in the case where the attached fragment has detached indexes which the IDS decides to reuse. **************************************************************** RECOMMENDATION: Please upgrade to the latest 11.50 IDS version. **************************************************************** | |
Local-Fix: | |
Lösung | |
The problem was first fixed in 11.50.xC2 where the alter table attach fragment command will not cause the abend while reusing the detached indexes of the attaching table. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.07.2008 25.09.2008 25.09.2008 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
11.50.0, 11.50.xC2 | |
Problem behoben lt. FixList in der Version | |
11.50.xC2 |