IC89310: ASSERT FAIL, CRASH OR SESSION HANG POSSIBLE FOLLOWING LONG TRANSACTION ROLLBACK INVOLVING REMOTE SERVER

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

  • An assert failure or crash of the local instance is possible
    following the rollback of a long transaction which involves an
    SQL operation with a remote IDS instance. It is also possible
    that a hang of the local session may result from a deadlock
    situation whereby the sqlexec thread in the local instance is
    waiting on the srvinfx thread in the remote instance which is
    also waiting on the local thread.
    
    Example AF information showing a crash:
    
    10:01:04  Long Transaction 0x7000000203a3fe8 Aborted. Rollback
    Duration: 2 Seconds
    10:01:04  stack trace for pid 3539450 written to /tmp/af.415335f
    10:01:04  Assert Failed: No Exception Handler
    10:01:04  IBM Informix Dynamic Server Version 11.70.FC5W1
    10:01:04   Who: Session(30, informix@portland, 24183018,
    7000000203a3fe8)
                    Thread(45, sqlexec, 7000000203672f8, 8)
                    File: mtex.c Line: 490
    10:01:04   Results: Exception Caught. Type: MT_EX_OS, Context:
    mem
    
    10:01:04  Stack for thread: 45 sqlexec
    
     base: 0x070000004068f000
      len:   69632
       pc: 0x0000000100096cec
      tos: 0x070000004069d2a0
    state: running
       vp: 8
    
    (oninit)afstack
    (oninit)mt_ex_throw_sig@AF11_4
    (oninit)afsig_handler
    (oninit)mt_lock
    (oninit)net_buf_get
    (oninit)recvsocket
    (oninit)tlRecv
    (oninit)slSQIrecv@AF45_25
    (oninit)slSQIrecv
    (oninit)pfRecv@AF25_17
    (oninit)asfRecv
    (oninit)ASF_Call
    (oninit)asf_recv
    (oninit)_iread
    (oninit)_igetint
    (oninit)fetchahead
    (oninit)rembegin
    (oninit)remfetch
    (oninit)rem_gettupl
    (oninit)remote_scan_next
    (oninit)insert_next
    (oninit)doinsert
    (oninit)aud_doinsert
    (oninit)excommand
    (oninit)sq_execute
    (oninit)sqmain
    (oninit)listen_verify
    (oninit)spawn_thread
    (oninit)startup
    
    
    Another example where an Assertion Failure is raised:
    10:24:32  Long Transaction 0x7000000203a2998 Aborted. Rollback
    Duration: 2 Seconds
    10:24:32  Assert Failed: Invalid Mutex Type
    ..
    (oninit)afstack
    (oninit)afhandler
    (oninit)afcrash_interface
    (oninit)mt_lock
    (oninit)net_buf_get
    (oninit)recvsocket
    (oninit)tlRecv
    ... (remaining stack is as above)
    
    The problem may be intermittent in nature but has been
    reproduced on 11.70.FC5, 11.70.FC5W1 and 11.70.FC6.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * informix server long transaction with remote query           *
    ****************************************************************
    * 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

    IC89310

  • 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-12-27

  • Closed date

    2014-05-08

  • Last modified date

    2014-05-08

  • 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

  • RB70 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

B70

Reference #:

IC89310

Modified date:

2014-05-08

Translate my page

Machine Translation

Content navigation