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":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
11 December 2020