home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT06431 Status: Geschlossen

ADDING NEW STATEMENTS TO THE STATEMENT CACHE UPON REACHING STMT_CACHE_HITS
CAN CAUSE VARIOUS FAILURES

Produkt:
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10
Problembeschreibung:
In my testing, I observed a 2nd cache entry for the statement 
that 
was defunct, probably because an update stats on the underlying 
table had been run. 
 
The following stack was observed at a customer site running IDS 
12.10.FC4W1 on hpia64: 
 
    (rmix/12.1FC4/bin/oninit)afstack 
    (rmix/12.1FC4/bin/oninit)mt_ex_throw_sig 
    (rmix/12.1FC4/bin/oninit)afsig_handler 
    (rmix/12.1FC4/bin/oninit)__milli_memmove 
    (rmix/12.1FC4/bin/oninit)routine_unknown 
    (rmix/12.1FC4/bin/oninit)routine_operator 
    (rmix/12.1FC4/bin/oninit)op_bind_rtn 
    (rmix/12.1FC4/bin/oninit)buildexpr 
    (rmix/12.1FC4/bin/oninit)expr2expr 
    (rmix/12.1FC4/bin/oninit)op_bind_rtn 
    (rmix/12.1FC4/bin/oninit)buildexpr 
    (rmix/12.1FC4/bin/oninit)expr2expr 
    (rmix/12.1FC4/bin/oninit)op_bind_rtn 
    (rmix/12.1FC4/bin/oninit)buildexpr 
    (rmix/12.1FC4/bin/oninit)expr2expr 
    (rmix/12.1FC4/bin/oninit)op_bind_rtn 
    (rmix/12.1FC4/bin/oninit)buildexpr 
    (rmix/12.1FC4/bin/oninit)expr2expr 
    (rmix/12.1FC4/bin/oninit)cond2expr 
    (rmix/12.1FC4/bin/oninit)sel2cb 
    (rmix/12.1FC4/bin/oninit)qblk2cb 
    (rmix/12.1FC4/bin/oninit)stmt2cb 
    (rmix/12.1FC4/bin/oninit)p_sp2cb 
    (rmix/12.1FC4/bin/oninit)parsecmd 
    (rmix/12.1FC4/bin/oninit)sqcmd 
    (rmix/12.1FC4/bin/oninit)sq_cmnd 
    (rmix/12.1FC4/bin/oninit)sq_prepare 
    (rmix/12.1FC4/bin/oninit)sqmain 
    (rmix/12.1FC4/bin/oninit)listen_verify 
    (rmix/12.1FC4/bin/oninit)spawn_thread 
    (rmix/12.1FC4/bin/oninit)th_init_initgls 
    (rmix/12.1FC4/bin/oninit)startup 
    (rmix/12.1FC4/bin/oninit)coroutine_start 
 
I reproduced many failures on linux x86_64 running 12.10.FC4W1. 
Some examples are below: 
 
(oninit) afstack 
(oninit) mt_ex_throw_sig 
(oninit) afsig_handler 
(Linux) <signal frame> 
(oninit) reduce_expr 
(oninit) evalcexpr 
(oninit) prmt_expr 
(oninit) expr2expr 
(oninit) op_bind_rtn 
(oninit) buildexpr 
(oninit) expr2expr 
(oninit) op_bind_rtn 
(oninit) buildexpr 
(oninit) expr2expr 
(oninit) cond2expr 
(oninit) sel2cb 
(oninit) qblk2cb 
(oninit) stmt2cb 
(oninit) p_sp2cb 
(oninit) parsecmd 
(oninit) sqcmd 
(oninit) sq_cmnd 
(oninit) sq_prepare 
(oninit) sqmain 
(oninit) listen_verify 
(oninit) spawn_thread 
(oninit) th_init_initgls 
(oninit) startup 
 
(oninit) afstack 
(oninit) mt_ex_throw_sig 
(oninit) afsig_handler 
(Linux) <signal frame> 
(oninit) routine_argtypes_body 
(oninit) routine_argtypes 
(oninit) routine_bind 
(oninit) sqbind 
(oninit) sq_common_bind 
(oninit) sq_bind 
(oninit) sqmain 
(oninit) listen_verify 
(oninit) spawn_thread 
(oninit) th_init_initgls 
(oninit) startup 
 
(oninit) afstack 
(oninit) mt_ex_throw_sig 
(oninit) afsig_handler 
(Linux) <signal frame> 
(oninit) old_do_rualloc 
(oninit) old_rualloc 
(oninit) chkralloc 
(oninit) new_celist 
(oninit) sqmksdb2 
(oninit) ssc_sqmksdb 
(oninit) sq_cmnd 
(oninit) sq_prepare 
(oninit) sqmain 
(oninit) listen_verify 
(oninit) spawn_thread 
(oninit) th_init_initgls 
(oninit) startup
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Those using STMT_CACHE_HITS > 0                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10                          * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IBM Informix Server 12.10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.01.2015
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.0
Problem behoben lt. FixList in der Version
12.10.xC5 FixList
12.10.xC5.W1 FixList