Informix - Problem description
Problem IT28483 | Status: Closed |
UPDATE STATISTICS IN CONCURRENCY ON A TABLE WITH TRIGGER AND A DEPENDEND SP WITH TRIGGER REFS CAUSE AF IN DECOMPILE_PROC | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When I have a complex table environment, with a table defined certain amount of triggers calling nested SPs and this environment has references to tables with also triggers and SPs and the entries need to be reread after an parallel running Update statistics, the server may write and af file with the following stack : 0x10150cb88 oninit :: stcmpr + 0x0 sp=0x4bb1ae90(0x0, 0x46e92c58, 0x46e92d18, 0x49479038, 0x46e92e00, 0x0) 0x1003046e0 oninit :: decompile_proc + 0xc00 sp=0x4bb1ae90(0x0, 0x46e92c58, 0x46e92d18, 0x49479038, 0x46e92e00, 0x0) 0x10031cca4 oninit :: retrieve_cache + 0x8c0 sp=0x4bb1b220(0x4594dd28, 0x4bb1b440, 0x4594e318, 0x0, 0x100303ae0, 0x4594e 028) 0x10034ab08 oninit :: udr_getbyid_uid + 0x4f0 sp=0x4bb1b360(0x0, 0x0, 0x0, 0x101cee4e0, 0x4ad1b028, 0x101c00) 0x1003128e8 oninit :: dp_udrchk + 0x128 sp=0x4bb1b460(0x4943b3b8, 0x4bb1b694, 0x101cee4e8, 0x10100, 0x0, 0x4943b228) 0x10031202c oninit :: dp_check + 0x174 sp=0x4bb1b510(0x4801f4a0, 0x3, 0x4943b3b8, 0x4bb1b694, 0x1, 0x0) 0x100313f18 oninit :: qd_check + 0x518 sp=0x4bb1b5d0(0x4801f4a0, 0x6b, 0x4bb1b79c, 0x0, 0x1, 0x0) 0x1002f8ddc oninit :: ip_evalsql + 0x2c0 sp=0x4bb1b6b0(0x4801f4a0, 0x4a21ead0, 0x0, 0x0, 0x48219dd0, 0x4758a950) 0x1002f355c oninit :: runproc + 0xab4 sp=0x4bb1b820(0x4bb1bb58, 0x4bb1bb9c, 0x4a20f330, 0x13, 0x1019c38c0, 0x10f8) 0x100306b54 oninit :: udrlm_spl_execute + 0x934 sp=0x4bb1b980(0x49479948, 0x0, 0x4801f4a0, 0x101cee4e8, 0x0, 0x0) 0x1007656c0 oninit :: udrlm_exec_routine + 0x510 sp=0x4bb1bba0(0x49479948, 0x0, 0x4bb1c0c0, 0x1, 0x2, 0x0) 0x100348168 oninit :: udr_execute + 0xf10 sp=0x4bb1bd00(0x49479838, 0x0, 0x80000000, 0x101cee4e0, 0x2, 0x4987ebd0) 0x10035171c oninit :: exroutine + 0x4a4 sp=0x4bb1bf50(0x49479778, 0x4bb1c0c0, 0x4bb1c0c0, 0x0, 0x494796c8, 0x0) 0x100218e64 oninit :: execproc + 0xac sp=0x4bb1c010(0x47b69838, 0x494796c8, 0xffffffff80012200, 0x49479708, 0x49479778, 0x8f800) 0x1003355bc oninit :: aud_execproc + 0xc sp=0x4bb1c150(0x47b69838, 0x37, 0x37, 0x2130, 0x8fbd8, 0x101cee) 0x1002150f8 oninit :: excommand + 0x1e70 sp=0x4bb1c210(0x47b69838, 0x101cee4c0, 0xdc, 0x0, 0x101cee4e0, 0x49479228) 0x100566888 oninit :: dotrstmts + 0x3f8 sp=0x4bb1c540(0x101cee000, 0x494693d0, 0x0, 0x49d9aa08, 0x101cee4e8, 0x400000) 0x100566070 oninit :: dotrigs + 0x8d4 sp=0x4bb1c670(0x80000000, 0x101cee4e8, 0x101cee4e0, 0x0, 0x494693d0, 0x494693b8) 0x1005654dc oninit :: ferafttrig + 0x48c sp=0x4bb1c830(0x49d9aa08, 0x4bb1cc54, 0x0, 0x1, 0x0, 0x459101c0) 0x100557dd0 oninit :: dodmlrow + 0x1144 sp=0x4bb1c930(0x49d9aa08, 0x0, 0x0, 0x481ea970, 0x84000004, 0x0) 0x100555c48 oninit :: dodelupd + 0xdd8 sp=0x4bb1cb60(0x49d9aa08, 0x0, 0x481ea970, 0x6078, 0x0, 0x4c) 0x100214828 oninit :: excommand + 0x15a0 sp=0x4bb1ccb0(0x49d9aa08, 0x0, 0x0, 0x0, 0x101cee4e0, 0x48f44438) 0x1006ff6d4 oninit :: sq_execute + 0x300 sp=0x4bb1cfe0(0x0, 0xfffffffffffffffd, 0x101cee4e8, 0x101cee4e0, 0x80000, 0x101 cee) 0x1007d2300 oninit :: sqmain + 0x9b8 sp=0x4bb1d0f0(0x1006ff3d4, 0x7, 0x1, 0x20000, 0x0, 0x200000) 0x101449e54 oninit :: listen_verify + 0x48c sp=0x4bb1d1c0(0x458e2f68, 0x101800, 0x1019c38c0, 0x459101c0, 0x76ec, 0x0) 0x101449624 oninit :: spawn_thread + 0x16bc sp=0x4bb1d660(0x76ec, 0x457b95d8, 0x101cf2, 0x880d88, 0x101c00, 0x880c00) 0x1012dc2d8 oninit :: th_init_initgls + 0x170 sp=0x4bb1dd10(0x1019c3, 0x101800, 0x101447f68, 0x101cfe000, 0x48942568, 0x 4656bbc8) 0x101308950 oninit :: startup + 0x1d0 sp=0x4bb1de50(0xa, 0x101cf4010, 0x101cfe098, 0x1, 0x101ced9a0, 0x101cfe098) 21:17:01 See Also: /opt/informix/IBM/12.10.FC12/tmp/af.a4e72ab | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Update statistics in concurrency on a table with trigger and * * a dependent SP with trigger refs cause Assert Failure in * * decompile_proc(). * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.03.2019 26.09.2019 26.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |