Informix - Problem description
Problem IT12133 | Status: Closed |
THREAD CAN GET HUNG RUNNING FOREVER OR POSSIBLY CRASH WHEN EXECUTING JOINS ON SYSMASTER SYSSQEXPLAIN, SYSSCBLST | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A thread can hang running forever or possibly crash when executing joins on sysmaster syssqexplain and sysscblst. A shared memory dump showed one running thread. The stack for this thread is: printkeypart smi_opexplain smi_storeexplainflags prconblock pstread pst_rsread rsread fmread getsinglerow readidx_new gettupl inner_next join_next join_next filltemp scan_open materialize_viewtmp materialize_viewtmp materialize_viewtmp prepselect doinsert excommand sq_execute sqmain listen_verify spawn_thread th_init_initgls Stacks observed using pstack for continually running threads are: $ rasu pstack 17028 #0 in smi_oplooksubq () #1 in smi_oplooksubq () #2 in smi_oplooksubq () ... ... ... #102 in smi_storeexplainflags () #103 in prconblock () #104 in pstread () #105 in pst_rsread () #106 in rsread () #107 in fmread () #108 in getsinglerow () #109 in readidx_new () #110 in gettupl () #111 in scan_next () #112 in join_next () #113 in join_next () #114 in filltemp () #115 in scan_open () #116 in materialize_viewtmp () #117 in materialize_viewtmp () #118 in materialize_viewtmp () #119 in prepselect () #120 in doinsert () #121 in excommand () #122 in sq_execute () #123 in sqmain () #124 in spawn_thread () #125 in th_init_initgls () #126 in startup () #127 in ?? () and #0 in opIsUfunc () #1 in smi_printexpr () #2 in smi_printexpr () #3 in smi_printexpr () ... ... ... #51 in smi_pr_filter () #52 in smi_opexplain () #53 in smi_storeexplainflags () #54 in prconblock () #55 in pstread () #56 in pst_rsread () #57 in rsread () #58 in fmread () #59 in getsinglerow () #60 in readidx_new () #61 in gettupl () #62 in scan_next () #63 in join_next () #64 in join_next () #65 in filltemp () #66 in scan_open () #67 in materialize_viewtmp () #68 in materialize_viewtmp () #69 in materialize_viewtmp () #70 in prepselect () #71 in doinsert () #72 in excommand () #73 in sq_execute () #74 in sqmain () #75 in spawn_thread () #76 in th_init_initgls () #77 in startup () #78 in ?? () | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * While Running SYSMASTER:SYSSQEXPLAIN query can crash or hang * * while actual query the explain is getting is in releasing * * state. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.11.2015 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |