• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 MySQL database server log file

xmlxp

Active member
#1
in the past few days around 1pm to 2pm ( peak time of traffic ) i am getting this error in the server error log:

Zend_Db_Adapter_Mysqli_Exception: Lost connection to MySQL server at 'sending authentication information', system error: 32 - library/Zend/Db/Adapter/Mysqli.php:333

when i checked MySQL database server log file i found huge number of lines in MySQL database server log file
Code:
Number of processes running now: 0
071004 00:51:31  mysqld restarted
071004  0:51:31  InnoDB: Started; log sequence number 0 45456
071004  0:51:31 [ERROR] /usr/sbin/mysqld: Error writing file '/sdb/mysql/user.theplanet.host.pid' (Errcode: 28)
071004  0:51:31 [ERROR] Can't start server: can't create PID file: No space left on device
what does it mean and how to fix it?
 

xmlxp

Active member
#4
drives still have space
sdb.png

to clerify,
mysql database is located in the sdb drive for performance reasons
all my board tables are MyISAM not InnoDB
InnoDB is enabled on /etc/my.cnf
 

Adam Howard

Well-known member
#5
It is possible, depending on how much you've got running and how many users you have.... That your /tmp which only has 109MB free, is filling faster then it is flushing out. I have seen that before, but it's kind of rare as Linux works memory differently.

This is a guess. But if you really do have a busy site, it would be something you should look into and monitor.

/var/log/mysqld log

Will give your some hints.