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.