|
Problem IT05466
|
Status: Closed |
LARGE QUERY STUCK IN PARSING CAUSING ENGINE TO HANG |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
A significantly large query with a number of CASE operators and
ANSI joins is run and the session hangs. Attempts to kill the
session with 'onmode -z <sid>' command do not work and onmode
hangs. A pstack or procstack run against the VP on which the
thread is running finds a stack trace similar to this:
old_do_rualloc ()
old_rualloc ()
gtexpnode ()
val2expr ()
expr2expr ()
expr2expr ()
expr2expr ()
expr2expr ()
expr2expr ()
expr2expr ()
expr2expr ()
prjlst2expr ()
sel2cb ()
qblk2cb ()
stmt2cb ()
p_sp2cb ()
parsecmd ()
sqcmd ()
sq_cmnd ()
sq_prepare ()
sqmain ()
spawn_thread ()
th_init_initgls ()
startup () |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* users using CASE expression *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 12.10.xC5 or earlier PID if available *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.11.2014
16.10.2015
16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC5
|
 |
| 12.10.xC5.W1
|
|
