ansaurus

Question

Answer 1

+1 A:

Looks like the partition where your mysqld is or your data-files are located is full. What is the output of a df command (disc-free)?

Henrik 2009-09-14 06:27:10

Hi, Thanks for replying .Output of df shows:Filesystem 1K-blocks Used Available Use% Mounted on/dev/sda1 9805144 9308424 0 100% /tmpfs 131156 0 131156 0% /lib/init/rwudev 131156 20 131136 1% /devtmpfs 131156 0 131156 0% /dev/shmnone 131156 0 131156 0% /dev/shmoverflow 1024 0 1024 0% /tmp

Pankaj Khurana 2009-09-14 06:32:13

Answer 2

+1 A:

It sounds like you are out of disk space. Have you checked? This will tell you how full your mounts are:

df

I've tried to put your comment into the below block. It looked to me like your drive is full. Use% = 100% is bad.

Filesystem      1K-blocks    Used Available Use% Mounted on 
/dev/sda1         9805144 9308424         0 100% 
/tmpfs             131156       0    131156   0% 
/lib/init/rw udev  131156      20    131136   1% 
/dev  tmpfs        131156       0    131156   0% 
/dev/shm none      131156       0    131156   0% 
/dev/shm overflow    1024       0      1024   0% 
/tmp

Stu Thompson 2009-09-14 06:27:20

Hi, Thanks for replying df command output:Filesystem 1K-blocks Used Available Use% Mounted on/dev/sda1 9805144 9308424 0 100% /tmpfs 131156 0 131156 0% /lib/init/rwudev 131156 20 131136 1% /devtmpfs 131156 0 131156 0% /dev/shmnone 131156 0 131156 0% /dev/shmoverflow 1024 0 1024 0% /tmp

Pankaj Khurana 2009-09-14 06:32:48

Yup, looks like your drive is full. 100% use is bad.

Stu Thompson 2009-09-14 06:58:06

That means i have to clean up unnecessary files from my server or increase disk space.

Pankaj Khurana 2009-09-14 07:14:10

Yes, but you should start with cleaning up disk space ASAP. If your system is full, then lots of things are broken or not working. It is an unsafe situation.

Stu Thompson 2009-09-14 09:52:13

ansaurus

tags:

views:

answers:

Mysql error on debian server

related questions