IC77276: NEW FLASHCOPY MANAGER FOR SQL VSS BACKUPS FAIL WITH ANS2719E BECAUSE AN OLD BACKUP REMAINS "IN PROGRESS"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a FlashCopy Manager for SQL VSS backup operation is
    interrupted abnormally while the VSS objects are about to be
    committed the backup remains "in progress" instead of properly
    exiting at the end of the process.
    
    Example:
    If a backup of a database db1 (with version exists=1)  is
    interrupted abnormally,  that backup is left "in progress"
    instead of properly exiting at the end of the process. The next
    backup operation that is attempted will attempt to delete the
    oldest backup for db1 based on the defined backup retention
    policy. However, the oldest backup in this scenario is the one
    left  in progress. Since, the a backup is still "in progress":
    
    - "ANS2719E A previous backup started on 'MM/DD/YYYY hh:mm:ss',
    is using the resources needed for new backup is still pending. "
    mesage will be issued
    - the backup will not be deleted (due to the fact that current
    backup is still on going)
    - the new backup operation fails with the message
     ANS1768E TSM was unable to find space for a new snapshot
                      TSM function name : vssInitBackupSpec;
                      TSM function      : No Space available for new
    backup
     because there  is no space available for a new backup.
     It's not normal behaviour to attempt to delete the backup in
    progress in order to create a new backup. A new backup (i.e.
    snapshot) should not just be created if the space for only one
    version is allocated, so the out of space error is retuned.
    
    
    
    Customer/L2 Diagnostics:
    The following can be seen in the logs:
    
    tdpsql.log may show:
     ANS1236E (RC115)  An unexpected error occurred.
     ACO5060E A Tivoli Storage Manager API error has occurred.
    
    In some cases, the following message may also be present:
    .
    "backup of db $NAME is complete, return code is 418"
    .
    This is a general message indicating that there has been
    some problem detected by a VSS requestor component. However,
    to determine which VSS requestor component had the error,
    additional examination of the dsmerror.log is required.
    .
    dsmerror.log:
    ANS2719E A previous backup started on '02/18/201106:00:36', is
    using the resources needed for new backup is still pending.
    ANS5250E An unexpected error was encountered.
       TSM function name : CLocalPolicyManager::lpmFindSpace
       TSM function      : Error in versionBasedPolicyUsingTSM.
       TSM return code   : -1
       TSM file          : lpm.cpp (471)
    
    ANS5250E An unexpected error was encountered.
       TSM function name : vssCreateSpaceForSnapshot
       TSM function      : lpmFindSpace failed
       TSM return code   : -1
       TSM file          : vssback.cpp (5139)
    ANS1768E TSM was unable to find space for a new snapshot.
       TSM function name : vssInitBackupSpec
       TSM function      : No Space available for new backup.
       TSM return code   : 115
       TSM file          : vssback.cpp (1384)
    
    agent trace:
    CLocalPolicyManager::versionBasedPolicyUsingTSM(): The backup
    version to recycle is still in progress.
    
    Tivoli Storage Manager Versions Affected:
    Data Protection for SQL 5.5.5
    FlashCopy Manager for SQL 2.2.1
    
    Initial Impact:
    Medium
    
    Additional Keywords:
    TSM, Databases, TDP, SQL, FCM
    

Local fix

  • manually delete the backup which is shown as "in progress"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the Tivoli Storage FlashCopy        *
    *                 Manager VSS Requestor component V2.2.0 -     *
    *                 2.2.1 in a Microsoft Exchange or SQL         *
    *                 environment who perform VSS Backups.         *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. Until a   *
    *                 FlashCopy Manager VSS Requestor component    *
    *                 fix is available, FlashCopy Manager          *
    *                 customers may install and use a fixed        *
    *                 level of the Tivoli Storage Manager (TSM)    *
    *                 Backup-Archive Client in their               *
    *                 environment. The TSM Backup-Archive client   *
    *                 provides equivalent functionality as the     *
    *                 FlashCopy Manager VSS Requestor when used    *
    *                 in FlashCopy Manager environments.           *
    ****************************************************************
    If a FlashCopy Manager for SQL VSS backup operation is
    interrupted abnormally while the VSS objects are about to be
    committed inconsistent backup should be properly deleted at
    the end of the process.
    

Problem conclusion

  • Backup-archive client agent
    The FlashCopy Manager VSS Requestor component was changed so
    that any interrupted FlashCopy Manager for Exchange or
    FlashCopy Manager for SQL VSS backups are cleaned up at the
    start of the next backup, restore, or query operation.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77276

  • Reported component name

    TSM CLIENT

  • Reported component ID

    5698ISMCL

  • Reported release

    62W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-30

  • Closed date

    2011-06-30

  • Last modified date

    2011-08-16

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

    IC75691

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

Modules/Macros

  • TDPEXC   DSMAGENT
    

Fix information

  • Fixed component name

    TSM CLIENT

  • Fixed component ID

    5698ISMCL

Applicable component levels

  • R62W PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

62W

Reference #:

IC77276

Modified date:

2011-08-16

Translate my page

Machine Translation

Content navigation