home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 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