IBM Support

IT27188: SQL LOG PURGE FAILS ON ALWAYSON AVAILABILITY GROUPS DUE TO ACCESS DENIED TO THE TRANSACTION LOG FILE ON THE VSNAP

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL log purge fails on AlwaysOn Availability Groups due to
    access denied to the transaction log file on the vSnap. The
    virgo
    log shows:
    
    [2018-11-15T13:11:26.376Z] ERROR pool-41405-thread-1
    c.c.e.s.protection.application.cal.logbackup.LogPurgeWorker
    1542286800096 Log purge failed for database
    SQLHOST:boost::filesystem::remove: Access is denied:
    "\\xx.xxx.x.xx\vpool1_fs1\SQLDB_SQLHOST\SQLDB_SQLHOST_log_z_xxxx
    xxxxxx.trn"
    
    This is caused by parallel condense of the SQL hosts.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus levels 10.1.2                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in IBM Spectrum Protect Plus levels    *
    * 10.1.2.247 and 10.1.3. Note that this is subject to change   *
    * at the discretion of IBM                                     *
    ****************************************************************
    

Problem conclusion

  • IBM Spectrum Protect Plus has been updated to change the
    behavior for SQL log purge commands. SQL log purge commands for
    Always On nodes will now be issued in a serial manner.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27188

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-12-05

  • Closed date

    2019-01-17

  • Last modified date

    2019-01-17

  • 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

    SP PLUS

  • Fixed component ID

    5737SPLUS

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
30 January 2024