Strange php and mySQL warining suddenly appeard

[igordr]

Hi, i need some help.
I have problems with mySQL. In some of my sites, i get warnings at the top of the pages:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in  Warning: session_start() [function.session-start]: open(/tmp/sess_2768563f6f13c08c044c710c554aaa37, O_RDWR) failed: No space left on device (28) in /home/stranifi/public_html/musicvideo.php on line 17  Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/stranifi/public_html/musicvideo.php:17) in /home/stranifi/public_html/musicvideo.php on line 17  Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/stranifi/public_html/musicvideo.php:17) in /home/stranifi/public_html/musicvideo.php on line 17

Mentioned problems appeared suddenly. I didn't do anything.
My server configuration is:

HDD 2x 500 GB SATARAM
6 GB DDR2-RAM
CPU AMD Athlon 64 X2 3400+, Dual-Core
Template CentOS 6 - minimal - RAID 1

I have about 15k unique visitors every day.

My present my.cnf file looks like this:

[mysqld]
set-variable = max_connections=500
query_cache_limit       = 2M
query_cache_size        = 256M
table_cache = 400
thread_cache_size = 286
log-slow-queries
safe-show-database

What i should tweak to get error disappear and get mySQL to work again?

THANKS,
Igor

igordr Reviewed by igordr on 16th Jul 2012. Strange php and mySQL warining suddenly appeard Hi, i need some help. I have problems with mySQL. In some of my sites, i get warnings at the top of the pages: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in Warning: session_start() : open(/tmp/sess_2768563f6f13c08c044c710c554aaa37, O_RDWR) failed: No space left on device (28) in /home/stranifi/public_html/musicvideo.php on line 17 Warning: session_start() : Cannot send session cookie - headers already sent by (output started at Rating: 5

[Whoo]

Your space is full on your server.

[mRAza]

from your above error
"No space left on device (28)"
I guess your ran out of HDD space

Edit: Whoo beats me to it..

[igordr]

It says Total Space Used 11491.92 MB I have HDD 2x 500 GB SATA.

What could cause the problem than?

[t3od0r]

check the root partition

[l0calh0st]

What is the size of your MySQL db's?

[Whoo]

Run the command below and see which use is as 100%:

df -h

[mRAza]

you need to increase ur tmp folder size. if you are on Cenots, it uses tmpfs for /tmp. modify ur /etc/fstab to increase tmp size. an example how it should look

tmpfs /tmp tmpfs size=1g 0 0

[igordr]

check the root partition

How i do that?

What is the size of your MySQL db's?

That should not be the problem .They are not bigger than 500 MB, together.

Run the command below and see which use is as 100%:

Results:

root@bravo612 [~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/md1              586G   22G  535G   4% /
tmpfs                 2.8G     0  2.8G   0% /dev/shm
/dev/md0              496M   63M  409M  14% /boot
/usr/tmpDSK           4.0G  151M  3.6G   4% /tmp

Any help?

you need to increase ur tmp folder size. if you are on Cenots, it uses tmpfs for /tmp. modify ur /etc/fstab to increase tmp size. an example how it should look

I just need to type this in SHH?

tmpfs /tmp tmpfs size=1g 0 0

[mRAza]

I just need to type this in SHH?

tmpfs /tmp tmpfs size=1g 0 0

no you need to modify that file but before run this command and post results here

df -h /tmp

also have you tried to clear your cache?