IBM Support

IT31744: ASSERTION CRASH WITH STATEMENT CACHE ENABLED IN NEW_EVAL AND FOLLOWED BY VARIOUS OTHER ASSERTIONS AND BAD BLOCKS OR POOLS

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

  • Initial stacks may show:
    
    0x000000000142e819 (oninit) afstack
    0x0000000001432301 (oninit) mt_ex_throw_sig
    0x000000000143b453 (oninit) afsig_handler
    0x00007f3cfefa2b10 (Linux) <signal frame>
    0x000000000166831b (oninit) new_eval
    0x0000000000b8321c (oninit) next_row
    0x0000000000b83741 (oninit) get_first_row_from_producer
    0x0000000000b85e56 (oninit) hash_process_all_groups
    0x0000000000b87836 (oninit) group_open
    0x0000000000b8742b (oninit) group_open
    0x000000000082524e (oninit) prepselect
    0x0000000000a4582e (oninit) open_cursor
    0x0000000000a4d799 (oninit) sql_open
    0x0000000000a4d986 (oninit) sq_open
    0x0000000000b0b641 (oninit) sqmain
    
    or
    
    0x000000000142e819 (oninit) afstack
    0x0000000001432301 (oninit) mt_ex_throw_sig
    0x000000000143b453 (oninit) afsig_handler
    0x00007f37180e4b10 (Linux) <signal frame>
    
    followed by secondary stacks like ...
    
    12:46:02  Assert Failed: Condition Failed (Ignoring free of pool
    '114' (0x47c01040) in use by blkpool), In (mt_shm_free_pool)
    0x000000000142e819 (oninit) afstack
    0x00000000014317f1 (oninit) afhandler
    0x0000000001431fd2 (oninit) affail_interface
    0x0000000001471b39 (oninit) mem_asfail
    0x0000000001474509 (oninit) mt_shm_free_pool
    0x00000000014846aa (oninit) destroy_session
    0x000000000142f539 (oninit) hang_thread
    0x000000000142fefb (oninit) afhandler
    0x0000000001431e52 (oninit) afcrash_interface
    0x0000000001432378 (oninit) mt_ex_throw_sig
    0x000000000143b453 (oninit) afsig_handler
    0x00007f3cfefa2b10 (Linux) <signal frame>
    0x00007f3cfdddc063 (/lib64/libc-2.22.so) __GI_epoll_wait
    0x0000000001590171 (oninit) soc_devpoll_thread
    0x0000000001465c48 (oninit) startup
    
    or
    
    12:42:36  Assert Failed: Mutex Holder Value is not Null
    (0x47afa370)
    0x000000000142e819 (oninit) afstack
    0x00000000014317f1 (oninit) afhandler
    0x0000000001431e52 (oninit) afcrash_interface
    0x0000000001459d4f (oninit) mt_free_mutex
    0x00000000015e37e6 (oninit) ifxOS_mutexDestroy
    0x00000000015be697 (oninit) free_common_ctl
    0x00000000015bebae (oninit) slSQIdiscon
    0x00000000015b42da (oninit) pfDiscon
    0x00000000015ae446 (oninit) cmDiscon
    0x00000000015abc96 (oninit) ascAbort
    0x000000000155083f (oninit) asfExit
    0x0000000001550e79 (oninit) ASF_Call
    0x00000000007b752d (oninit) sqscb_cleanup
    0x000000000148438f (oninit) destroy_session
    0x000000000142f539 (oninit) hang_thread
    0x000000000142fefb (oninit) afhandler
    

Local fix

Problem summary

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IT31744

  • 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-02-04

  • Closed date

    2020-03-04

  • Last modified date

    2020-03-04

  • 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:
04 March 2020