What might be the issue here and how can I fix this?
Perhaps "beginners error number 2" or so ;-)) : the space to a file is released only when the last process opening the file has ended. before this, the system-call unlink(), which really destroys the files content, cannot be issued.
If you want to shorten a file to zero length, which might be written to by a background process, do:
This reduces the file immediately while preserving its inode, so that the process that holds it open can still write to it.
Right now, if you have already removed the file, the only way is to identify the process still holding it open. User strace, fuser, lsof or a similar tool to identify the process(es) and then kill the process(es). As it is a Databse you might want to stop and restart the DB properly.
As an afterthought: you should stay away from doctoring on files a DB uses as long as it is up and you are not absolutely damned sure about what you do and why. This is a great way for exploding the DB into shards of unusable diskspace.
I hope this helps.
bakunin
PS: Regarding what i said above: don't worry, that happened to all of us.
If you want to shorten a file to zero length, which might be written to by a background process, do:
This reduces the file immediately while preserving its inode, so that the process that holds it open can still write to it.
Note that the "cat /dev/null" part is useless as there is nothing to cat from /dev/null in the first place. You can actually shorten a file with any command that output nothing, e.g. :
or
and with most shells like sh, dash, bash, ksh, zsh and the likes (actually any shell but the csh family ones), you can even skip the command and only use a redirection for the expected effect :
Note that the "cat /dev/null" part is useless as there is nothing to cat from /dev/null in the first place.
Thats not entirely correct. When /dev/null is read it produces a EOF-marker and this way it is made sure that the file to be shortened is well-formed (i.e. contains a end-of-file sign).
It may well be that other tools or devices do the same. I have never claimed that my method is the only one that works - just one i know for sure to work.
Thats not entirely correct. When /dev/null is read it produces a EOF-marker and this way it is made sure that the file to be shortened is well-formed (i.e. contains a end-of-file sign).
It's not write-ing anything which truncates the file here -- just open-ing it with mode O_TRUNC is enough, as is done by > but not >>.
I know really early versions of DOS used to use end-of-file symbols, but I've never observed such a thing in UNIX before. Is that an Oracle thing? I would have thought that'd be handled internally by the filesystem driver. Do you have more information?
Hi,
I have this :
uname -a
Linux servername 2.6.18-194.11.3.el5PAE #1 SMP Mon Aug 23 15:57:10 EDT 2010 i686 i686 i386 GNU/Linux
df -k
Sys. de fich. 1K-blocs Occupied Disponible Capacity Monted on
/u01/applis 10321208 3190160 6606760 33% /applis
Does it mean... (1 Reply)
Hi,
I am installing TAM-eb components in solaris V10.o, unfortunately am running out of space. when I -df i come across a lot of directories. i would like to know whether there is any way to free some disk space. (10 Replies)
Hi
This is my script for disk space monitoring
clear
if
then
echo "You must be root user to execute the script"
fi
ALERT_LEVEL=10
CONSUMPTION_LEVEL= `df -k | awk {'print $5'} | cut -d '%' -f1 | sed "1 d"`
for i in $CONSUMPTION_LEVEL
do
FILE_SYSTEM=`df -k | awk {'print $1'} |... (3 Replies)
Hello All-
Am new member to this forum. Have some unix experience. But true believer in it compared to windows.
Have a question regarding the disk space.
I know a command to check the total disk space utilization using:
df -k .
but what is the command to check the same disk space by... (6 Replies)
HI ...
I am New to the Unix...I am trying to write a script to check the disk space.
But i am not able to write it.
I know the command to check the disk space df -k,but unable to write the script..Can any body help me...
Thanks in advance... (3 Replies)
Hi Experts.
I had 100% disk full , even though i have removed 2 GB space still dbf command shows 100%.
How to rectify that. Appreciate your prompt help. Thanks (1 Reply)
Hi experts
i am new in unix and informix
and would like to ask 2 questions
1) my server shows when using df -k
fs 1024-block used available
/usr 10079072 3668670 6381144
does this mean i have 10GB, and used up 3.7GB and available 6.3GB ???
is... (3 Replies)
Hello,
Can someone please tell me which command to use to determine the available disk space on a given disk device?
I have to write a shell script that compresses files and stores them in a specific location but I am not sure how "conservative" I should be?
Thanks in advance!
Al. (4 Replies)
Hi
I'm trying to install gcc and the installation program tells me that I'm out of disk space! I have just installed the os (using the default settings for partitions and sizes) and have only installed apache on the machine. Can it really be out of disk space already?
How do I check how much... (4 Replies)