IBM Support

PM96223: ACCESSING MYSQL RESULTS USING RTCP AFTER A LONG PAUSE YIELDS "CONNECTION ABORT: SOCKET WRITE ERROR"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Attempts to access results using RTCP fail after a long period
    of inactivity with the following error:
    
    "An error occurred whilst fetching executions for stub
    (Software caused connection abort: socket write error)"
    
    STEPS TO REPRODUCE:
    
    1. Create a project database using the MySQL provider.
    2. Run some test suites or stubs to create some results.
    3. View the results from RTCP
    4. Attempt to view some results after a long period of
    inactivity.
    
    EXPECTED RESULTS:
    
    The results are returned.
    
    ACTUAL RESULTS:
    
    The results cannot be displayed and the error message above is
    returned.
    The RTCP process must be re-started before results can be viewed
    again.
    
    WORKAROUND:
    
    Consult with your database administrator and investigate the
    setting of wait_timeout.
    You may be able to increase the timeout value.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Test Control Panel                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If the Rational Test Control Panel Results Gallery view has  *
    * a long period of inactivity then when a user attempts to     *
    * view results from a MySQL results database then they may     *
    * encounter an error stating ""An error occurred whilst        *
    * fetching executions for stub (Software caused connection     *
    * abort: socket write error)"                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Rational Test Control Panel 8.6.0 or later        *
    ****************************************************************
    

Problem conclusion

  • This problem was caused due to the timing out of pooled MySQL
    database connections within Rational Test Control Panel.  This
    problem was fixed in version 8.6.0
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM96223

  • Reported component name

    RATL TEST VIRT

  • Reported component ID

    5725G9400

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-02

  • Closed date

    2014-07-07

  • Last modified date

    2014-07-07

  • 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

    RATL TEST VIRT

  • Fixed component ID

    5725G9400

Applicable component levels

  • R800 PSN

       UP

  • R801 PSN

       UP

  • R850 PSN

       UP

  • R851 PSN

       UP

  • R860 PSY

       UP



Document information

More support for: Rational Test Virtualization Server

Software version: 8.5

Reference #: PM96223

Modified date: 07 July 2014