|
Problem IT31976
|
Status: Closed |
IF UPDATE STATISTICS FOR PROCEDURE HAS TO CALL AUTOREGEXE IT MAYHANG THE SCHEDULER AND THE CALLING SESSION
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The reproduction environment defines a Database containing
Stored procedures calling Datablade functions.
When an Update statistics for procedure has to call the
autoregexe task from the scheduler because
of a missing registration of the base datablade in the database
and some internal functions like
SYSBldSQLTextIn or SYSBldSQLTextOut are missing in the database
a deadlock situation may occur with
the following representation :
The user session calling the Update statistics hang in
yield_processor_svp
mt_yield
ph_submit_task
dbcron_submit_task
ifknowncreate
udr_determine
expr_determine
common_routine2expr
expr2expr
op_bind_rtn
....
pr_compile
aud_pr_compile
updprocstat
The first scheduler worker show the stack
mt_call_size
mi_call_size
autoregexe
udrlm_clang_execute_internal
udrlm_clang_execute
udrlm_exec_routine
udr_execute
mi_routine_exec
ph_exec_func
ph_execute
do_task
....
The second scheduler worker
yield_processor_mvp
mt_yield
lkwait
lkmanagex
lkrow
rsread
fmread
creatproc
aud_creatproc
excommand
sq_execute
mi_exec
QUERunQuery
SYSBldLogCallback
SYSBldParseScript
SYSBldRunSQLFile
SYSBldInit
SYSBldPrepare
SYSBldPrepare2
registerBlade
SYSBldCreate
SYSBldCustomPrepare
In this situation the user session cannot be stopped by onmode
-z, a long tx will happen which cannot be rollbacked without
restart
and the scheduler is blocked. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC4. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC4. *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC4. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.02.2020
10.12.2020
11.12.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
