Informix - Problem description
Problem IT32022 | Status: Closed |
RUNNING "UPDATE STATISTICS FOR PROCEDURE ..." CAUSES ASSERTION FAILURES HOWEVER THE UPDATES STATISTICS FINISHES WITHOUT ERRORS | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Running "update statistics for procedure ..." causes assertion failures with following stack trace : 0x00000000014e501d (oninit) afstack 0x00000000014e9d5d (oninit) afhandler 0x00000000014ea372 (oninit) affail_interface 0x00000000014eae3a (oninit) mt_ex_throw_sig 0x00000000014f8d68 (oninit) afsig_handler 0x00007f1eb6634d80 (Linux) 0x00000000006fb8f3 (oninit) col2expr 0x00000000006fcc7d (oninit) dotted2expr 0x00000000006f5d98 (oninit) expr2expr 0x00000000006fdd1d (oninit) elist2arg 0x000000000076dd74 (oninit) common_routine2expr 0x00000000006f60a9 (oninit) expr2expr 0x000000000095566e (oninit) bldtabtrigs 0x0000000000958199 (oninit) bldtrigs 0x00000000008bc540 (oninit) itcallbldquery 0x00000000008c2be5 (oninit) itbldroot 0x00000000008738b0 (oninit) sqoptim 0x00000000007113bf (oninit) ip_sqloptim 0x0000000000732afb (oninit) cmp_stmt 0x00000000007330a5 (oninit) pr_compile 0x0000000000750181 (oninit) aud_pr_compile 0x0000000000734339 (oninit) updprocstat 0x0000000000640bfe (oninit) excommand 0x0000000000af260b (oninit) sq_execute_workhorse 0x0000000000af2e4d (oninit) sq_execute 0x0000000000bc655e (oninit) sqmain 0x0000000001613a7a (oninit) spawn_thread 0x00000000014d5cf2 (oninit) th_init_initgls 0x000000000151c00f (oninit) startup however the updates statistics finishes without errors : update statistics for procedure xxxxxxxxx; Database selected. Routine Statistics updated. Database closed. When the "update statistics for procedure .." is executed, it generates the assertion failures but instance does not crash. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update 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: * * Update 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 : | 27.02.2020 09.06.2020 09.06.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |