IBM Support

IT29509: EXECUTE IMMEDIATE OF BUFFER WITH MANY INSERT STATEMENTS AND INSERT TRIGGER ON TABLE CAN ASSERT IN ITEXECINIT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as duplicate of another APAR.

Error description

  • This problem was reported in 11.70.FC8W1 on linux x86_64.
    
    The test case I developed uses an esql/c client to load a file
    that contains about 17000 inserts into a buffer
    and then runs an execute immediate on that buffer which
    eventually leads to the failure.
    
    When the problem reproduces, a common stack for the failing
    sqlexec is:
    
    0x0000000001320cb3 (oninit) afstack
    0x000000000132752c (oninit) mt_ex_throw_sig
    0x00000000012cdc43 (oninit) afsig_handler
    0x0000003ddfa0e4c0 (Linux) <signal frame>
    0x00000000005ce933 (oninit) itexecinit
    0x00000000008437a1 (oninit) evalwhen
    0x0000000000844008 (oninit) dotrigs
    0x00000000008446d6 (oninit) ferafttrig
    0x00000000007dd8e0 (oninit) addone
    0x00000000007e0e85 (oninit) insone_next
    0x000000000083d367 (oninit) doinsert
    0x00000000005b0312 (oninit) excommand
    0x00000000009b00dc (oninit) sq_execute
    0x0000000000a6e78b (oninit) sqmain
    0x00000000013e5639 (oninit) spawn_thread
    0x000000000131e360 (oninit) th_init_initgls
    0x00000000012eaaa8 (oninit) startup
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • This APAR is a duplicate of IT29507
    

APAR Information

  • APAR number

    IT29509

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED DUB

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-06-20

  • Closed date

    2022-08-01

  • Last modified date

    2022-08-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":[{"code":"LOB10","label":"Data and AI"}]}]

Document Information

Modified date:
01 August 2022