IBM Support

LI73209: SIGNAL #11 INSTANCE CRASH MIGHT OCCUR AFTER CONVERTING A STRING TO UPPER OR LOWER CASE USING FUNCTIONS LOWER/LCASE/UPPER/UCASE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A memory overwrite and memory corruption might occur due to
    problem in the upper/lower character conversion functions for
    very specific data as follows:
    - This problem will happen in UTF-8 database only.
    - It is specific to the case when invalid UTF-8 string data is
    referenced (partial UTF-8 characters).
    This problem is seen for example when the last byte in the
    string is invalid: It is a first byte of the valid 2-byte
    character.  In this scenario conversion function could corrupt
    a few bytes of memory.
    In the cases where this has been seen, those few bytes of
    memory end up being used later on during a calculation for a
    much larger memory operation which results in a much larger
    memory overwrite that leads to an instance crash during query
    execution.
    If you look at the stack traceback file for the signal #11,
    the following are some of the stack tracebacks that have been
    seen:
    1)
    memcpy
    intel_fast_memcpy.A
    sqlri_serveFromBuffer
    sqlrita
    sqlriSectInvoke
    sqlrr_process_fetch_request
    sqlrr_open
    2)
    __restore_rt
    sqldRowFetch
    sqlriFetch
    sqlriNljnNonPiped
    sqlriSectInvoke
    sqlrr_process_fetch_request
    sqlrr_open
    3)
    sqldGetNextDataPartition
    sqldRowFetch
    sqlriFetch
    sqlriNljnNonPiped
    sqlriSectInvoke
    sqlrr_process_fetch_request
    sqlrr_open
    4)
    sqlplAddLockAttributes
    sqldProtectReadBlockLock
    sqldRowFetch
    sqlriFetchPerm
    sqlriFetch
    sqlriNljnNonPiped
    sqlriExecThread
    sqlriSectInvoke
    sqlrr_process_fetch_request
    sqlrr_open
    Please note that there may be other possible stack tracebacks
    that could happen as a result of this defect that have not been
    documented yet.
    This APAR will fix the character conversion functions so that
    the initial small-bytesize corruption does not occur.
    

Local fix

Problem summary

  • See problem description.
    

Problem conclusion

  • First Fixed in DB2 V9.5 Fixpack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73209

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-03-06

  • Closed date

    2009-01-23

  • Last modified date

    2009-01-23

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

    LI73169

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 January 2009