|
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) |
