IC91412: SERVER CAN CRASH WHEN EXECUTING SELECT FROM SYSSQEXPLAIN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When selecting from syssqexplain, the server can crash with the
    following stacks -- the stack seen may be dependent on the
    platform:
    
    afstack ()
    mt_ex_throw_sig()
    afsig_handler()
    prepselect()
    open_cursor()
    sql_open()
    sq_open ()
    sqmain  ()
    spawn_thread()
    startup ()
    
    afstack ()
    mt_ex_throw_sig@AF11_4 ()
    afsig_handler ()
    sq_execute ()
    sq_execute ()
    sqmain  ()
    listen_verify ()
    spawn_thread ()
    startup  ()
    
    A select from syssqlcurses could also crash with a stack like
    this ( sdb is null ):
    
    0x00000000012f79f3 afstack
    0x00000000012fe07c mt_ex_throw_sig
    0x00000000012b2db3 afsig_handler
    0x0000003efe40f500 (Linux) <signal frame>
    0x000000000130a15b xc_adopt_global_error
    0x00000000007a76d3 getrow
    0x00000000007a8459 fetchrow
    0x00000000007a8ad3 doselect
    0x00000000005af003 excommand
    0x000000000099f09d sq_exselect
    0x0000000000a5d11b sqmain
    0x00000000013bc6cd spawn_thread
    0x00000000012c2a45 startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users running any sysmaster queries on the table sysconblock *
    * either directly or via the views syssqexplain or             *
    * syssqlcurses.                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDS version 11.70.xC8                             *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC91412

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-08

  • 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

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 #:

IC91412

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation