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

Discussion in 'Troubleshooting and Problems' started by xmlxp, Feb 21, 2012.

  1. xmlxp

    xmlxp 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
    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?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Looks like you need to free up some space on the disk.
     
  3. Mike

    Mike XenForo Developer Staff Member

    Looks like one of your drives is out of space -- whatever /sdb is.
     
  4. xmlxp

    xmlxp Active Member

    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
     
  5. Adam Howard

    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.
     

Share This Page