IBM Support

IC65617: ASSERT FAILED ERROR WHEN USING FORCE_DDL_EXEC

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

  • There was assert failed error when using force_ddl_exec
    14:31:25
    14:31:25  IBM Informix Dynamic Server Version 11.50.FC6TL
    Software
    Serial Number AAA#B000000
    
    14:31:25  Assert Warning: (PARTP->pt_ocount == 1)
    14:31:25   Who: Session(580, jfdba@koko, 1448, 7000001d2929108)
      Thread(1298, sqlexec, 7000001d28e02c8, 5)
      File: rspartn.c Line: 12570
    14:31:25   Results: Consistency check failed
    14:31:25   Action: Please notify IBM Informix Technical Support.
    14:31:25  Raw hex dump of stack located in
    /informix_cq/tmp/af.8fad03d.rawstk
    14:31:25  Stack for thread: 1298 sqlexec
    
     base: 0x07000001d3ea0000
      len:   528384
       pc: 0x00000001000dbf74
      tos: 0x07000001d3f1dc00
    state: running
       vp: 5
    
    0x00000001000dc1a8 (oninit)afstack
    0x00000001000de2bc (oninit)afhandler
    0x000000010030e4d8 (oninit)rspnforce_excl_access
    0x00000001002d3e7c (oninit)ispnopen_with_forceddl
    0x0000000100374f74 (oninit)fm_openfragx
    0x00000001002e12d4 (oninit)fmftopen_with_child
    0x000000010058d0e4 (oninit)sqftopen_tab_hierarchy
    0x000000010058cdb4 (oninit)openrel
    0x00000001005fcdd0 (oninit)ddaltfrag
    0x00000001006237e8 (oninit)aud_ddaltfrag
    0x00000001004a9ea8 (oninit)excommand
    0x00000001004ceb80 (oninit)sq_execute
    0x00000001002574bc (oninit)sqmain
    0x0000000100451f98 (oninit)listen_verify
    0x0000000100450468 (oninit)spawn_thread
    0x0000000100d462c4 (oninit)startup
    
    ....
    14:31:26
    14:31:26  IBM Informix Dynamic Server Version 11.50.FC6TL
    Software
    Serial Number AAA#B000000
    
    14:31:26  Assert Failed: Condition Failed (Memory pointer
    (0x7000001dbf97798) freed twice), In (mt_shm_free)
    14:31:26   Who: Session(580, jfdba@koko, 1448, 7000001d2929108)
      Thread(1298, sqlexec, 7000001d28e02c8, 5)
      File: mtshpool.c Line: 4161
    14:31:26   Action: Please notify IBM Informix Technical Support.
    14:31:26  Raw hex dump of stack located in
    /informix_cq/tmp/af.8fad03d.rawstk
    14:31:26  Stack for thread: 1298 sqlexec
    
     base: 0x07000001d3ea0000
      len:   528384
       pc: 0x00000001000dbf74
      tos: 0x07000001d3f1d630
    state: running
       vp: 5
    
    0x00000001000dc1a8 (oninit)afstack
    0x00000001000de2bc (oninit)afhandler
    0x000000010007122c (oninit)mem_asfail
    0x0000000100074c24 (oninit)mt_free
    0x000000010030e5f8 (oninit)rspnforce_excl_access
    0x00000001002d3e7c (oninit)ispnopen_with_forceddl
    0x0000000100374f74 (oninit)fm_openfragx
    0x00000001002e12d4 (oninit)fmftopen_with_child
    0x000000010058d0e4 (oninit)sqftopen_tab_hierarchy
    0x000000010058cdb4 (oninit)openrel
    0x00000001005fcdd0 (oninit)ddaltfrag
    0x00000001006237e8 (oninit)aud_ddaltfrag
    0x00000001004a9ea8 (oninit)excommand
    0x00000001004ceb80 (oninit)sq_execute
    0x00000001002574bc (oninit)sqmain
    0x0000000100451f98 (oninit)listen_verify
    0x0000000100450468 (oninit)spawn_thread
    0x0000000100d462c4 (oninit)startup
    
    There are two reproduce environment.
    
    1. The error happens when the engine terminates a remote sql
    Example: server a and server b
    a). execute the sql from server b
       unload to /dev/null
       select * from bsn_acctdb@a:acct_item_23;
    
    b). When the first sql  is running ,execute the sql in server a
       set environment force_ddl_exec "60";
    set lock mode to wait 10;
    begin;
    alter fragment on table acct_item_23 DETACH dbs1
    acct_item_23_old;
    
    c). The assert failed happens every time.
    
    2 The same error also happens in the following stress test.
    a) There are 100 sql to do select action continuously
        dbaccess cq <<!
    select * from acct_item_23 where acct_id = 100;
    !
    b) There are 20 sql to do update action continuously
    dbaccess cq <<!
    update acct_item_23 set serv_id = serv_id+1 where acct_id = 200;
    !
    c) A large transaction to do update continuously
      dbaccess cq <<!
    begin work;
    update acct_item_23 set amount = amount +5
    where 1=1;
    rollback;
    !
    d) another session to do alter fragment action continuously
    dbaccess cq <<!
    set environment force_ddl_exec "60";
    set lock mode to wait 10;
    begin;
    alter fragment on table acct_item_23 DETACH dbs1
    acct_item_23_old;
    
    set environment force_ddl_exec "off";
    rollback;
    !
    
    The assert failed happen in half a day.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Those using new feature FORCE_DDL_EXEC                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * AF is seen when using the feature FORCE_DDL_EXEC.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.50.xC7 and above.                              *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in 11.50.xC7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65617

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-18

  • Closed date

    2010-10-01

  • Last modified date

    2010-10-01

  • 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

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 October 2010