IBM Support

IT06492: "DELETE VOLUME" GETS ANR0104E ERROR 1114 DELETING ROW FROM TABLE "AS.VOLUME.STATUS" AND ANR9999D_2308965227 ON 7.1

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • "delete volume" sometimes fails with ANR0104E error 1114
    deleting row from table "AS.Volume.Status" and
    ANR9999D_2308965227 on Tivoli Storage Manager server 7.1
    
    Here is the actlog.
    
    ANR2017I Administrator ADMIN issued command: DELETE VOLUME
    AAAAAAL6 discarddata=y wait=y  (SESSION: ***)
    ANR0984I Process *** for delete volume (disacrddata) started in
    the FOREGROUND at 00:17:02. (SESSION: ***, PROCESS: ***)
    ANR0104E asvol.c(5292): Error 1114 deleting row from table
    "AS.Volume.Status". (SESSION: ***, PROCESS: ***)
    ANR9999D_2308965227 DeleteVolId(asvol.c:4968)  Thread<28936>:
    Failure 9999 deleting orphaned segments for volume ***.
    (SESSION: ***, PROCESS: ***)
    ANR9999D Thread<28936> issued message 9999 from: (SESSION: ***,
    PROCESS: ***)
    ANR9999D Thread<28936>  0x000000010001cc50 StdPutText (SESSION:
    ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x000000010001d6b0 OutDiagToCons
    (SESSION: ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x00000001000098c8 outDiagfExt (SESSION:
    ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x00000001004e6504 DeleteVolId (SESSION:
    ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x00000001004e5800 AsDeleteVol (SESSION:
    ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x00000001006cd070 ssDeleteVolume
    (SESSION: ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x00000001002b92dc bfEndDeleteVol
    (SESSION: ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x0000000100be9824 AdmVolDelThread
    (SESSION: ***, PROCESS: ***)
    ANR9999D Thread<28936>  0x000000010000cb40 StartThread (SESSION:
    ***, PROCESS: ***)
    ANR2225W Discard Data process terminated for volume AAAAAAL6 -
    volume still contains data. (SESSION: ***, PROCESS: ***)
    ANR0986I Process *** for delete volume (discarddata) running in
    the FOREGROUND processed *** items for a total of *** bytes with
    a completion state of  FAILURE at hh:mm:ss. (SESSION: ***,
    PROCESS: ***)
    ANR1893E Process *** for delete volume (discarddata)completed
    with a completion state of FAILURE. (SESSION: ***, PROCESS: ***)
    
    The problem is that in 7.1.0, we introduced a new feature of
    "super aggregate", by default, files bigger than 10G will be
    stored as super aggregates. There are some background threads
    used to delete these kind of objects. There is a timing window
    for the "delete vol" thread between fetching a segment and
    deleting it. A background super aggregate deletion thread could
    delete this same segment in this timing window. This problem
    affects 7.1.0 and above server levers on all supported
    platforms. It's not related to specific volumes but related to
    super aggregates.
    
    Tivoli Storage Manager Versions affected:
    Tivoli Storage Manager Server 7.1 on all supported platforms.
    
    Customer/L2 Diagnostics (If Applicable)
    BFDESTROY, ASVOL and ASDEALLOC trace classes will be helped to
    find the issue.
    
    Initial Impact:
    Middle
    
    Additional Keywords:
    Tivoli Storage Manager, TSM, delete volume
    
    Additional L2 info:
    None.
    

Local fix

  • Retry "delete volume".
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users of the "DELETE       *
    * VOLUME" command.                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This                      *
    * problem is currently projected to be fixed                   *
    * in levels 7.1.1.200 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

    IT06492

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-18

  • Closed date

    2015-01-22

  • Last modified date

    2015-01-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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT06492

Modified date: 22 January 2015