IBM Support

IT07761: INCREMENTAL BACKUP MAY FAIL DUE TO ANR0379W A SERVER DATABASE DEADLOCK WHEN COPY ACTIVEDATA IS ALSO RUNNING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During a backup, Tivoli Storage Manager server may detect
    ANR0379W a server database deadlock situation has been
    encountered; the lock request for the bf aggregate
    (superbitfile) id lock, **** will be denied to resolve the
    deadlock.  Then, the backup is aborted with ANS1301E error.
    The error occurs when COPY ACTIVEDATA is running at the same
    time for the active data pool in which data for the backup
    would be stored.
    
    Tivoli Storage Manager Versions affected:
    Tivoli Storage Manager Server all levels on all platforms.
    
    Customer/L2 Diagnostics (If Applicable)
    SHOW DEADLOCK and SHOW THREAD will show the following (or
    similar):
    
    ANS8000I Server command: 'SHOW DEADLOCK'.
    A Deadlock was found:
    Transaction 0:****.
      Waiting for Lock mode xLock on: Type=46001(bf aggregate
    (superbitfile) id), NameSpace=0, Key='****'
      Held by transaction 0:**** in mode xLock.
    Transaction 0:****.
      Waiting for Lock mode sLock on: Type=19002(im node
    filespace), NameSpace=0, Key='*.**'
      Held by transaction 0:**** in mode xLock.
    
    ANS8000I Server command: 'SHOW THREADS'.
    ...
    (Stack trace of psSessionThread that requests xLock on
    Type=46001)
        0x0900000000c14ab0 _cond_wait_global
        0x0900000000c1563c _cond_wait
        0x0900000000c1632c pthread_cond_wait
        0x00000001000079f4 pkWaitConditionTracked
        0x000000010004de64 tmLockTracked
        0x0000000100768250 BfLockAggregateTracked
        0x000000010076abf8 bfGetSubBitfileInfoEx
        0x000000010075c4b8 afDecrInactiveLogOcc
        0x0000000100729944 Deactivate
        0x0000000100733d14 imDeactivateBackup
        0x0000000100722b08 imUpdateInventory
        0x00000001007196d4 imPrepareTxn
        0x0000000100044a48 CollectVotes
        0x000000010004405c tmEndX
        0x0000000100690a50 SmEndVbTxn
        0x000000010068807c SmNodeSession
        0x000000010054089c HandleNodeSession
        0x00000001005381b4 DoNodeGeneral
        0x00000001005331e0 smExecuteSession
        0x00000001001784fc psSessionThread
        0x000000010000c264 StartThread
    
    (Stack trace of  AfCopyActiveDataThread that requests sLock on
    Type=19002)
        0x0900000000c14ab0 _cond_wait_global
        0x0900000000c1563c _cond_wait
        0x0900000000c1632c pthread_cond_wait
        0x00000001000079f4 pkWaitConditionTracked
        0x000000010004de64 tmLockTracked
        0x000000010070ecc0 ImLockFileSpaceTracked
        0x0000000100870640 imGetActiveInactiveState
        0x00000001007d6c0c BfReconstruct
        0x0000000100a6c5ec CopyBatch
        0x0000000100a62cc4 CopyVolume
        0x0000000100a620e8 AfCopyVolume
        0x0000000100abcd74 AfCopyActiveDataThread
        0x000000010000c264 StartThread
    
    Additional Keywords:
    ANS1999E
    
    Additional L2 info:
    None
    
    Initial Impact:
    Middle
    

Local fix

  • Avoid running COPY ACTIVEDATA at the same time as client backup.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This                      *
    * problem is currently projected to be fixed                   *
    * in levels 6.3.6 and 7.1.3. Note that this is subject         *
    * to change at the discretion of IBM.                          *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms: AIX, HP-UX, Solaris, Linux and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07761

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-03-17

  • Closed date

    2015-04-22

  • Last modified date

    2015-04-22

  • 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

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
22 April 2015