IC88699: RUNNING A CORRELATED NESTED QUERY GENERATES AF WITH MEMORY BLOCK HEADER CORRUPTION DETECTED IN MT_SHM_MALLOC_SEGID 6

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

  • Running a correlated nested query generates an assert failure
    with the following information :
    
    11:06:27  Found during mt_shm_malloc_segid 6
    11:06:27  Pool '34' (0x112d2b040)
    11:06:27  Bad block header 0x112cfc5c8
    blk-64
    0000000112cfc588: 00000000 00000000 00c7140c 0a0c0e33   ........
    .......3
    0000000112cfc598: 2b243c06 31323132 38380000 00000000   +$<.1212
    88......
    0000000112cfc5a8: 00000000 00000000 00000000 00000000   ........
    ........
    0000000112cfc5b8: 00000000 00008000 00008000 00000000   ........
    ........
    blk+64
    0000000112cfc5c8: 01010002 25a27ae1 ffff0000 00000000   ....%.z.
    ........
    0000000112cfc5d8: 00000001 12d2b0a8 00000001 12cfc000   ........
    ........
    0000000112cfc5e8: 00000000 00000a38 00000000 00000000   .......8
    ........
    0000000112cfc5f8: 00000000 00000000 00000002 25a561d1   ........
    ....%.a.
    11:06:27  Bad block removed from pool
    11:06:27  Attempting to clean up free list...
    11:06:27  Bad free block 0x112cfc5f0
    blk-64
    0000000112cfc5b0: 00000000 00000000 00000000 00008000   ........
    ........
    0000000112cfc5c0: 00008000 00000000 01010002 25a27ae1   ........
    ....%.z.
    0000000112cfc5d0: ffff0000 00000000 00000001 12d2b0a8   ........
    ........
    0000000112cfc5e0: 00000001 12cfc000 00000000 00000a38   ........
    .......8
    blk+64
    0000000112cfc5f0: 00000000 00000000 00000000 00000000   ........
    ........
    0000000112cfc600: 00000002 25a561d1 00000000 00000000   ....%.a.
    ........
    0000000112cfc610: 00000000 00000000 00000000 00000000   ........
    ........
    0000000112cfc620: 00000000 00000000 00000000 00000000   ........
    ........
    11:06:27  Can't find corrupted block's previous block
    
    11:06:28
    11:06:28  IBM Informix Dynamic Server Version 11.70.FC5W1
    Software Serial Number AAA#B000000
    
    11:06:28  Assert Failed: Memory block header corruption detected
    in mt_shm_malloc_segid 6
    11:06:28   Who: Session(34, informix@garion, 2747, 10f7828c8)
      Thread(178, sqlexec, 10f7543d8, 1)
      File: mtshpool.c Line: 1912
    11:06:28   Results:
    11:06:28   Action: Please notify IBM Informix Technical Support.
    11:06:28  Raw hex dump of stack located in
    /home/pd/edgars/tmp/af.49af313.rawstk
    11:06:28  Stack for thread: 178 sqlexec
    
     base: 0x00000001128f9000
      len:   69632
       pc: 0x00000001010e0a80
      tos: 0x0000000112906841
    state: running
       vp: 1
    
     ucontext: <NULL>
      siginfo: <NULL>
    
    afstack
    afhandler
    affail_interface
    mt_shm_malloc_segid
    mt_malloc
    rsla_open
    fmla_write
    filltemp
    scan_open
    join_open
    prepselect
    open_cursor
    sql_open
    sq_open
    sqmain
    listen_verify
    spawn_thread
    startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * User having correlated subqueris and rowid reference in a    *
    * filter.                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-11.70.xC8                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-11.70.xC8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88699

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-28

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

  • 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

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

B70

Reference #:

IC88699

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation