IBM Support

PI33656: Enhance statement cache multi-thread access detection

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The WebSphere statement cache held within a managed
    connection should not get accessed simultaneously by two
    threads since the WebSphere JDBC objects like connection should
    be accessed by only one thread at a time. Violating this
    programming model will result in the data structures within
    the statement cache getting corrupted and can result in index
    out of bounds errors. This apar enhances the multi-thread
    access detection capability around the statement cache.
    

Local fix

  • Identify and fix the multithreaded access in the code
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Enhance statement cache multi-thread    *
    *                      access detection                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Multi-threaded access to a connection occurs when an
    application shares a connection handle across multiple threads
    before closing it. This condition should be avoided, as it can
    lead to various unexpected failures during the run of the
    application. Each connection has an associated statement
    cache within it and if a connection is used simultaneously by
    multiple threads, the indexes used in the statement cache can
    get corrupted. This apar enhances the multi-thread access
    detection capability around the statement cache and helps to
    identify if there are any violations from the application.
    This apar is enabled by a datasource custom property
    statementCacheMultiThreadDetector=true
    In the administrative console, Navigate to JDBC providers >
    (JDBC Provider Name) > Data sources > (datasource name) >
    Custom properties
    Create a new property statementCacheMultiThreadDetector
    with a value set to true.
    

Problem conclusion

  • The WebSphere relational resource adapter component has been
    updated to enhance the multi thread access detection around
    the statement cache.
    
    This apar is enabled by a datasource custom property
    statementCacheMultiThreadDetector=true
    
    In the administrative console, Navigate to JDBC providers >
    (JDBC Provider Name) > Data sources > (datasource name) >
    Custom properties
    Create a new property statementCacheMultiThreadDetector
    with a value set to true.
    
    The fix for this APAR is currently targeted for inclusion in
    fix packs 7.0.0.39, 8.0.0.12, 8.5.5.7.  Please refer to the
    Recommended Updates page for delivery information:
    http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI33656

  • Reported component name

    WEBSPHERE APP S

  • Reported component ID

    5724J0800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-01-28

  • Closed date

    2015-06-05

  • Last modified date

    2015-06-05

  • 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

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

  • R700 PSY

       UP

  • R800 PSY

       UP

  • R850 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PI33656

Modified date: 05 June 2015