IBM Support

IT31586: 874 & ASSERT FAILURE ON PRINTQUAL WHEN RUNNING A QUERY ON VIEW WITH TS TABLES WITH SET EXPLAIN ON

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

  • When running set explain on avoid_execute for following query on
a view.

SELECT * FROM vw_ts_tables

Stack looks like:

12:10:51  Context ptr = 0x00000000914cab00
12:10:51  Siginfo ptr = 0x00000000914cac30
12:10:51  Reg  0(R8)      0x0000000001d81fc0 Reg  1(R9)
0x0000000000000000
12:10:51  Reg  2(R10)     0x0000000000000000 Reg  3(R11)
0x0000000000000001
12:10:51  Reg  4(R12)     0x0000000000000048 Reg  5(R13)
0x0000000188215c88
12:10:51  Reg  6(R14)     0x0000000000000000 Reg  7(R15)
0x0000000000000001
12:10:51  Reg  8(RDI)     0x0000000090ccbc28 Reg  9(RSI)
0x0000000090ccbc28
12:10:51  Reg 10(RBP)     0x000000013bdf0878 Reg 11(RBX)
0x0000000000000048
12:10:51  Reg 12(RDX)     0x000000000000000f Reg 13(RAX)
0x0000000000000049
12:10:51  Reg 14(RCX)     0x0000000000000000 Reg 15(RSP)
0x00000001c3ecb090
12:10:51  Reg 16(RIP)     0x000000000093c2e4 Reg 17(EFL)
0x0000000000010206
12:10:51  Reg 18(CSGSFS)  0x0000000000000033 Reg 19(ERR)
0x0000000000000004
12:10:51  Reg 20(TRAPNO)  0x000000000000000e Reg 21(OLDMASK)
0x0000000000000000
12:10:51  Reg 22(CR2)     0x0000000000000000
12:10:51
12:10:51  IBM Informix Dynamic Server Version 12.10.FC10XA1AEE
Software Serial Number AAA#B000000

12:10:51  Assert Failed: Exception Caught. Type: MT_EX_OS,
Context: mem
12:10:51   Who: Session(8787837, informix@hostname, 109336,
0x9016aca8)
        Thread(21415575, sqlexec, 901375f8, 46)
        File: mtex.c Line: 420
12:10:51   Action: Please notify IBM Informix Technical Support.
12:10:51  SHM Globals and Master Pool/Master Block Adresses:

12:10:51  shmcb =           0x00000000449726d8
12:10:51  rhead =           0x00000000449df800
12:10:51  pool list =       0x00000000449727b0
12:10:51  block pool list = 0x00000000449d93b8
12:10:51  TRANSP =          0x000000009016aca8
12:10:51  PARTP =           0x0000000000000000
12:10:51  PARTNP =          0x0000000000000000
12:10:51  OPENP =           0x0000000099e613f8
12:10:51  FILEP =           0x0000000172cf0460
12:10:51  Raw hex dump of stack located in
/data2/dumpdir/af.ca7fbe2a.rawstk
12:10:51  Stack for thread: 21415575 sqlexec

 base: 0x00000001c3e8c000
  len:   266240
   pc: 0x00000000013f0149
  tos: 0x00000000914c96c0
state: running
   vp: 46

0x00000000013f0149 (oninit) afstack
0x00000000013f33c7 (oninit) afhandler
0x00000000013f3842 (oninit) affail_interface
0x00000000013f3dd1 (oninit) mt_ex_throw_sig
0x0000000001404883 (oninit) afsig_handler
0x00007fdf57bf05d0 (Linux) <signal frame>
0x000000000093c2e4 (oninit) printqual
0x000000000093c268 (oninit) printqual
0x000000000093c48d (oninit) pr_filter
0x0000000000942066 (oninit) opexplain
0x00000000007d12f2 (oninit) sqoptim
0x0000000000a00fbc (oninit) bldstructs
0x0000000000a05975 (oninit) sqcmd
0x0000000000a106aa (oninit) sq_cmnd
0x0000000000a10804 (oninit) sq_prepare
0x0000000000adfb53 (oninit) sqmain
0x000000000151c29b (oninit) spawn_thread
0x00000000013e1ca0 (oninit) th_init_initgls
0x000000000144aa38 (oninit) startup

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC4.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC15 (when available) or    *
* 14.10.xC4.                                                   *
****************************************************************

    



Problem conclusion


    

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC4.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT31586
    • 

  • 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
    2020-01-20
    • 

  • Closed date
    2020-12-10
    • 

  • Last modified date
    2020-12-10
    • 





    

  • 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":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            11 December 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback