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 |
|
| 12.10.xC5.W1 |
|