on 05-06-2013 2:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.