Skip to Content
0
Former Member
May 06, 2013 at 01:05 PM

MaxDB Backup File Problem

720 Views

Hello,

while a full database backup the disk got full

and the backup respond

Error code 28 (No space left on device)

##############################

/sapdb/programs/bin/dbmcli -d SM4 -u SUPERDBA,PASSWORD -i /sapdb_backups/backup_scripte/full_backup.txt -t /sapdb_backups/backup_scripte/start_full_backup.log

+++ Sun May 5 16:07:02 2013

Connection established to node (local) for database SM4

*** Sun May 5 16:07:02 2013

db_connect

---

OK

*** Sun May 5 19:31:57 2013

backup_start SM4_Full_Backup

---

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

3,Data backup failed

136,transfer of block 4294967295 to medium /sapdb_backups/full_backups/SM4_Full_Backup.bak failed

operation : write

block size : 8192 bytes

length : 8 blocks

offset : 4294967295 blocks

position : 35184372088832 bytes

Servertask Info: because Error in backup task occured

Job 1 (Backup / Restore Medium Task) [executing] WaitingT145 Result=3700

Error in backup task occured, Error code 3700 "hostfile_error"

125,Write error on medium /sapdb_backups/full_backups/SM4_Full_Backup.bak: Error code 28 (No space left on device)

###############################################

"df -h" reports

###############################################

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 473G 306G 144G 69% /

devtmpfs 24G 136K 24G 1% /dev

tmpfs 5.9G 20K 5.9G 1% /dev/shm

/dev/sdb1 99G 94G 0 100% /sapdb_backups

/dev/sdc1 79G 70G 5.1G 94% /sapdata1

/dev/sdd1 99G 86G 8.4G 92% /sapdata2

/dev/sde1 16G 8.0G 7.0G 54% /saplog1

###############################################

when I delete the corrupt backup file "rm -frv /sapdb_backups/full_backups/SM4_Full_Backup.bak"

the space on device /dev/sdb1 (/sapdb_backups) is still full.

"du -h /sapdb_backups/" show only 64M space usage.

###############################################

4.0K /sapdb_backups/lost+found

4.0K /sapdb_backups/wdf_itfs01

63M /sapdb_backups/media

68K /sapdb_backups/backup_scripte

4.0K /sapdb_backups/log_backups

4.0K /sapdb_backups/full_backups

63M /sapdb_backups/

###############################################

"lsof | grep -i sapdb_backups" shows that

the kernel process of the maxdb holds the backup file ("SM4_Full_Backup.bak")

###############################################

lsof | grep -i sapdb_backups

kernel 8859 sdb 544w REG 8,17 99959234560 6217730 /sapdb_backups/full_backups/SM4_Full_Backup.bak (deleted)

bash 13372 root cwd DIR 8,17 4096 6217729 /sapdb_backups/full_backups

lsof 13474 root cwd DIR 8,17 4096 6217729 /sapdb_backups/full_backups

grep 13475 root cwd DIR 8,17 4096 6217729 /sapdb_backups/full_backups

lsof 13476 root cwd DIR 8,17 4096 6217729 /sapdb_backups/full_backups

###############################################

this is an productive system, so I can`t stop the maxdb or SAP system and cannot kill the process.

Is there a solution to close the file ?

Best regards

Alex