IBM Support

IT27542: ASSERT FAILURE WHEN CREATING INDEX ONLINE AND NOT ENOUGH SPACE IN DBSPACE AND SP_AUTOEXPAND 0

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

  • While creating an ONLINE index on a dbspace with not enough
space, the engine will Assert Fail if SP_AUTOEXPAND 0.  You will
see a message in online.log like:

09/26/17 11:19:11  Warning: The storage pool is out of space. To
enable automatic chunk creation use the OpenAdmin Tool to add
space to the pool.
09/26/17 11:19:11  Assert Failed: Invalid Mutex Type
09/26/17 11:19:11  IBM Informix Dynamic Server Version 12.10.FC8
09/26/17 11:19:11   Who: Session(349, informix@xxxxxxxx, 10459,
115fb4148)
        Thread(77428, pimage_0x1600004, 115f93de8, 9)
        File: mt.c Line: 9014
09/26/17 11:19:11  stack trace for pid 20240 written to
/opt/informix/etc/af_files/af.545895b

AF With following stack:

12:07:39  SHM Globals and Master Pool/Master Block Adresses:

12:07:39  shmcb =           0x000000010a1e0678
12:07:39  rhead =           0x000000010a24d800
12:07:39  pool list =       0x000000010a1e0750
12:07:39  block pool list = 0x000000010a247358
12:07:39  TRANSP =          0x0000000115fabb38
12:07:39  PARTP =           0x0000000000000000
12:07:39  PARTNP =          0x0000000000000000
12:07:39  OPENP =           0x0000000000000000
12:07:39  FILEP =           0x0000000000000000
12:07:39  Raw hex dump of stack located in
/opt/informix/etc/af_files/af.545895b.rawstk
12:07:39  Stack for thread: 349 pimage_0x1600004

 base: 0x0000000118197000
  len:   135168
   pc: 0x00000001012d63e0
  tos: 0x00000001181b6661
state: running
   vp: 1

 ucontext: <NULL>
  siginfo: <NULL>

oninit :: afstack
oninit :: afhandler
oninit :: afcrash_interface
oninit :: mt_lock_helper
oninit :: exit_thread
oninit :: idxbld_pimage_proc
oninit :: startup

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 12.10.xC11 and older versions.                  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Assert Failure when creating index ONLINE and not enough     *
* space in dbspace and SP_AUTOEXPAND 0.                        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

    



Problem conclusion


    

  • Fixed in IDS 12.10.xC12.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT27542
    • 

  • 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
    2018-12-26
    • 

  • Closed date
    2019-10-07
    • 

  • Last modified date
    2019-10-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


    








      
              
                            

              

              [{"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:
            

            07 October 2019
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback