IBM Support

IT30021: EXECUTE QUERY THAT CREATES AN AUTO FUNCTIONAL INDEX IN A TRANSACTION THAT IT HAS NOT PREPARED WILL SEGV IN IS_MULTIROW_UDR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • This problem was originally reported in 12.10.FC12W1 on linux
    x86_64 and the repro I developed
    dupes on the same platform running IDS 12.10.FC13.  It is
    probably not linux specific.
    
    The test case prepares a statement that when executed creates an
    auto functional index.
    
    The statement is executed and current transaction is committed.
    Another transaction is
    started and an execute of the prepared statement will assert the
    server with a stack
    comparable to:
    0x000000000142e819 (oninit) afstack
    0x0000000001432301 (oninit) mt_ex_throw_sig
    0x000000000143b453 (oninit) afsig_handler
    0x0000003ddfa0e4c0 (Linux) <signal frame>
    0x00000000005f0ad0 (oninit) is_multirow_udr
    0x0000000001512ebe (oninit) fmamaddindex
    0x000000000151a6e9 (oninit) fmaddindex
    0x000000000080636f (oninit) filltemp_sqisaddindex
    0x000000000080fc8c (oninit) tmptab_create_index
    0x0000000000810d69 (oninit) filltemp
    0x000000000081848f (oninit) scan_open
    0x0000000000b7fe71 (oninit) join_open
    0x0000000000b7fe53 (oninit) join_open
    0x0000000000848131 (oninit) sort_open
    0x000000000082524e (oninit) prepselect
    0x00000000005fb681 (oninit) excommand
    0x0000000000a4cc25 (oninit) sq_exselect
    0x0000000000b0b641 (oninit) sqmain
    0x000000000155d1ab (oninit) spawn_thread
    0x0000000001420130 (oninit) th_init_initgls
    Description
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3.  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to Informix Server 12.10.xC14 or 14.10.xC3.           *
    ****************************************************************
    

Problem conclusion

  • Update to Informix Server 12.10.xC14 or 14.10.xC3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30021

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-08-16

  • Closed date

    2020-02-24

  • Last modified date

    2020-02-24

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

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

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
24 February 2020