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