|
Problem IT06431
|
Status: Closed |
ADDING NEW STATEMENTS TO THE STATEMENT CACHE UPON REACHING STMT_CACHE_HITS CAN CAUSE VARIOUS FAILURES |
| product: |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* Those using STMT_CACHE_HITS > 0 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.01.2015
16.10.2015
16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.0
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC5
|
 |
| 12.10.xC5.W1
|
|
