SAP Knowledge Base Article - Preview

2383671 - Drop data volume failed

Symptom

You want to delete a volume, but it fails with "Drop data volume failed - volume x still contains yy pages"

You can see following errors in the trace files:

dbm.prt

INF          1 DBMSrvCo A DBM Server client connection was established at 2016-10-20 11:52:14
INF        283 DBMSrv   Command 'db_deletevolume DATA 1' is being executed.
INF          1 DBMKnl   Sending an administrative statement to the database TST on computer localhost
INF          8 DBMKnl   Statement:  DROP DATA VOLUME 1
ERR          3 DBMKnl   Received the result of an administrative statement from the database TST on computer localhost
ERR          9 DBMKnl   Statement:  DROP DATA VOLUME 1
ERR         10 DBMKnl   Returncode: -9407
ERR          5 DBMKnl   Errortext:  System error: unexpected error
ERR     -24988 DBMSrv   ERR_SQL: SQL error
INF          0 DBMSrv   -9407,System error: unexpected error
INF          0 DBMSrv   20077,Drop data volume failed - volume 1 still contains 34 pages

KnlMsg

    IOMan      20019:  Start reading pages from data volume 1 for dropping
    IOMan      20020:  Stop reading pages from data volume 1 for dropping
    Savepoint      1:  Savepoint (DropVolume) with ID 262363 started
    DataCache     12:  Savepoint (phase 1): Start write data
    DataCache     13:  Savepoint (phase 1): Stop write data, 2622 pages written with 372 io calls
    DataCache     12:  Savepoint (phase 2): Start write data
    DataCache     13:  Savepoint (phase 2): Stop write data, 0 pages written with 0 io calls
    DataCache      4:  Mark data pages for savepoint (prepare phase)
    DataCache     12:  Savepoint (phase 3): Start write data
    DataCache     13:  Savepoint (phase 3): Stop write data, 3 pages written with 1 io calls
    Converter  20047:  Savepoint (phase 3): Start write converter
    Converter  20048:  Savepoint (phase 3): Stop write converter, 1383 pages written with 1383 io calls
    DataCache      3:  Savepoint with ID 262363 completed
    FBM        20000:  BlockNo: 30424 is still in use, state: Occupied
    FBM        20000:  BlockNo: 241200 is still in use, state: Occupied
    ...
    FBM        20000:  BlockNo: 633875 is still in use, state: Occupied
    FBM        20000:  BlockNo: 673377 is still in use, state: Occupied
    FBM        20000:  BlockNo: 685432 is still in use, state: Occupied
    FBM        20000:  BlockNo: 686585 is still in use, state: Occupied
ERR SYSERROR   51080:  -9407 unexpected error
ERR IOMan      20077:  Drop data volume failed - volume 1 still contains 34 pages,_FILE=IOMan_DataFileSystem+noPIC.cpp,_LINE=1104


Read more...

Environment

MaxDB/liveCache databases

Keywords

drop, delete, volume , KBA , BC-DB-SDB , MaxDB , BC-DB-LVC , liveCache , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.