Informix - Problem description
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) |