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":"BU053","label":"Cloud & Data Platform"},"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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback