IBM Support

IT32830: Select substring op [] on views w/ queries using substring ops [] on *char types can produce unpredictable results/crashes

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

  • 13:12:26  Found during mt_shm_malloc_segid 6
13:12:26  Pool '50.H.ext' (0x700000023f26040)
13:12:26  Bad block header 0x700000023d62850

0700000023d62850: 0e000000 47c820f9 ffff0000 00002888   ....G. .
......(.
0700000023d62860: 07000000 23f260a8 07000000 23d627a0   ....#.`.
....#.'.
0700000023d62870: 00000000 000007b0 00000000 00000000   ........
........
0700000023d62880: 00000000 00000000 0e000000 47e4c1d1   ........
....G...

The above checkword should be 0xe00000047c88ff9 so it has had
one byte of 0x20 overwriting 0x0700000023d62856.

The lower portion of the stack may differ but from new_val seems
to be consistent when seeing the problem.

0x00000001000b5250 (oninit)afstack
0x00000001000b3fa0 (oninit)afhandler
0x00000001000b4498 (oninit)affail_interface
0x000000010004bd50 (oninit)mt_shm_malloc_segid
0x000000010004b78c (oninit)mt_malloc
0x000000010019c9bc (oninit)rh_alloc
0x00000001001a4c10 (oninit)tmalloc
0x00000001004c1c50 (oninit)geval
0x00000001004c206c (oninit)geval
0x00000001005069c4 (oninit)ev_geval
0x00000001004fbc20 (oninit)new_eval
0x00000001009977a4 (oninit)scan_filter
0x0000000101179798 (oninit)physical_scan
0x000000010117ade4 (oninit)rsseqscan_read
0x00000001007b141c (oninit)fmseqscan_read
0x00000001009a9784 (oninit)readseq_batch
0x000000010099f1e0 (oninit)gettupl
0x0000000100995704 (oninit)scan_next
0x00000001015b9490 (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b9b3c (oninit)merge_next
0x00000001015b44f0 (oninit)sort_open
0x000000010099bc54 (oninit)filltemp
0x00000001009949b4 (oninit)scan_open
0x00000001009b2c8c (oninit)IPRA.$materialize_viewtmp
0x00000001009b523c (oninit)materialize_viewtmp
0x000000010108a62c (oninit)prepselect
0x00000001006d9504 (oninit)open_cursor
0x00000001006d9ca4 (oninit)sql_open
0x00000001006d99fc (oninit)sq_open
0x000000010076b8ac (oninit)sqmain

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC5.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 14.10.xC5.                         *
****************************************************************
This contains a fix for CHAR, NCHAR and LVARCHAR types

    



Problem conclusion


    

  • Fixed in Informix Server 14.10.xC5.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT32830
    • 

  • Reported component name
    INFORMIX SERVER
    • 

  • Reported component ID
    5725A3900
    • 

  • Reported release
    E10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-05-12
    • 

  • Closed date
    2020-12-07
    • 

  • Last modified date
    2020-12-07
    • 





    

  • 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


    








      
              
                            

              

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

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            08 December 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback