MaxDB Backup File Problem

[Former Member]

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

[MichaelTe]

Hello Alex,

perhaps this thread will help you:

http://scn.sap.com/thread/1109766

Especially the commands to find out which db task is holding the file.

x_cons SM4 show ac

Regards,

Michael

[former_member188883]

Hi Alexander,

As per the error log

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

your backup folder /sapdb_backups/full_backups does not have enough space to accomodate the backup file. You may do the following

1) Increase the space in the file system /sapdb_backups

2) move or delete older backup files to different location.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hello Deepak,

is there an other way to clean up the /sapdb_backups directory.

I have already deleted the backupfile but the space on /sapdb_backups is still at 100% full.

an a "du -h /sapdb_backups/"

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/

shows only 63M of usage.

I tried also a "umount -l /sapdb_backups" and than mount again.

But no success. A "fsck.ext3 /dev/sdb1" also with no success.

Best regards

Alex

[yashwanthkumar_kethineed]

Hello Alexander,

This is a strange problem and has to be analyzed at OS level.

It would be helpful if you can provide more information here:

What is version of MaxDB ?

Did you try running the backup again with OVERWRITE = YES (but be carefull, copy or move the last successfull backup to another location before you try this).

Are you SAP Customer ?? Do you already have a CSS message open with us regarding this issue ?

Let me know.

Regards, Yashwanth