• 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


Active member
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
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?


Active member
drives still have space

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
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.