Informix - Problem description
Problem IT29376 | Status: Closed |
SET ENCRYPTION PASSWORD AND CALLING ENCRYPT_AES IN PROCEDURE FROM TRIGGER STORED PROCEDURE CAN ASSERT | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The following failures can occur running IDS 12.10.FC12W1 and calling a trigger that calls a stored procedure that does a set encryption password and then utilizes the encrypt_aes() function. Common stacks are like: 0x0000000001422ac9 (oninit) afstack 0x00000000014265b1 (oninit) mt_ex_throw_sig 0x000000000142f723 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x000000000061b406 (oninit) init_cbs 0x0000000000623e65 (oninit) itexecinit 0x00000000005fb2cf (oninit) excommand 0x0000000000a49fcc (oninit) sq_execute 0x0000000000b0d281 (oninit) sqmain 0x000000000154feab (oninit) spawn_thread 0x0000000001414500 (oninit) th_init_initgls 0x0000000001459f57 (oninit) startup 0x0000000001422ac9 (oninit) afstack 0x00000000014265b1 (oninit) mt_ex_throw_sig 0x000000000142f723 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x000000000061b406 (oninit) init_cbs 0x000000000061c0b3 (oninit) init_cbs 0x0000000000623e65 (oninit) itexecinit 0x00000000008c65b1 (oninit) evalwhen 0x00000000008c6e4b (oninit) dotrigs 0x00000000008c7450 (oninit) ferafttrig 0x00000000008bc95e (oninit) dodmlrow 0x00000000008be240 (oninit) dodelupd 0x00000000005fe063 (oninit) excommand 0x0000000000a49fcc (oninit) sq_execute 0x0000000000b0d281 (oninit) sqmain 0x000000000154feab (oninit) spawn_thread 0x0000000001414500 (oninit) th_init_initgls 0x0000000001459f57 (oninit) startup and a customer reported stack also like: 0x0000000001422ac9 (/opt/informix/bin/oninit) afstack 0x00000000014265b1 (/opt/informix/bin/oninit) mt_ex_throw_sig 0x000000000142f723 (/opt/informix/bin/oninit) afsig_handler 0x0000003c8100f7e0 (Linux) 0x000000000061b406 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs 0x0000000000623e65 (/opt/informix/bin/oninit) itexecinit 0x00000000008c65b1 (/opt/informix/bin/oninit) evalwhen 0x00000000008c6e4b (/opt/informix/bin/oninit) dotrigs 0x00000000008c7450 (/opt/informix/bin/oninit) ferafttrig 0x00000000008bc95e (/opt/informix/bin/oninit) dodmlrow 0x00000000008be240 (/opt/informix/bin/oninit) dodelupd 0x00000000005fe063 (/opt/informix/bin/oninit) excommand 0x0000000000a49fcc (/opt/informix/bin/oninit) sq_execute 0x0000000000b0d281 (/opt/informix/bin/oninit) sqmain 0x000000000154feab (/opt/informix/bin/oninit) spawn_thread 0x0000000001414500 (/opt/informix/bin/oninit) th_init_initgls | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS versions prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * Setting encryption password and calling encrypt_aes in * * procedure from trigger can cause assert failure. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.06.2019 23.09.2019 23.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
Problem solved according to the fixlist(s) of the following version(s) |