IBM Support

IC68207: IN RARE TIMING SCENARIOS DB2 TERMINATE MAY SEGFAULT AFTER A RESTORE OPERATION.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • After a Restore operation is performed, a subsequent db2
    terminate may hang or segfault. The problem is caused by some
    erroneous lock related book-keeping.
    
    The stack dump may have the following entries from
    sqlpTermAgent()->sqlplfre()->sqlo_xlatch::getIdentity()
    
    </Siginfo_t>
    Signal #11 (SIGSEGV): si_addr is 0x0000002C00000014, si_code is
    0x00000001 (SEGV_MAPERR:Address not mapped to object.)
    </SignalDetails>
    
    ---FUNC-ADDR---- ------FUNCTION + OFFSET------
    0000002A9B8C9157 ossDumpStackTraceEx + 0x01f7
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2osse.so.1)
    0000002A9B8C4CCC _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00b4
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2osse.so.1)
    0000002A9B8C4D93 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x0009
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2osse.so.1)
    0000002A97C8ABCF sqlo_trce + 0x03f3
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A97D08FDD sqloEDUCodeTrapHandler + 0x0107
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A956784F0 address: 0x0000002A956784F0 ; dladdress:
    0x0000002A9566C000 ; offset in lib: 0x000000000000C4F0 ;
                    (/lib64/tls/libpthread.so.0)
    0000002A968428DC _ZNK12sqloSpinLock11getIdentityEv + 0x0000
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A9684297A _ZNK11sqlo_xlatch11getIdentityEv + 0x0006
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A97DA3545 _Z8sqlplfreP8sqeAgentP8SQLP_LCBP8SQLP_LRBm +
    0x05d9
    
    (/ms/dist/ibmdb2/PROJ/ds/9.5.3.3/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1)
    0000002A97D571AF _Z13sqlpTermAgentP8sqeAgentm + 0x010d
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 LUW Users                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In rare timing scenarios DB2 TERMINATE may segfault after a  *
    * RESTORE operation.                                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customer need to upgraded to  db2_v97fp3                     *
    ****************************************************************
    

Problem conclusion

  • db2_v97fpbin will contain the fix . After a Restore operation
    isperformed, a subsequent db2 terminate will not hang or
    segfault
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68207

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-27

  • Closed date

    2010-11-11

  • Last modified date

    2010-11-11

  • APAR is sysrouted FROM one or more of the following:

    LI75366

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC68207

Modified date: 11 November 2010