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

xf_session table crashing continously

Discussion in 'Troubleshooting and Problems' started by Rodrigo Farcas, Dec 31, 2012.

  1. Rodrigo Farcas

    Rodrigo Farcas Active Member

    Hey there!

    We did a new server architecture, with 2 web nodes and 1 mysql on the back.

    Since this, we are experiencing crashes on the xf_session table, once about 2 days.

    Code:
    Mysqli statement execute error : Incorrect key file for table './carretes_xf/xf_session.MYI'; try to repair it
    Hace 1 minuto - library/Zend/Db/Statement/Mysqli.php:214
    Any clue? Thank you!
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Are you having any uptime or crashing problems with the physical server or with the MySQL service? That can cause recurring corruption like this. A simple table repair should fix it.
     
  3. Rodrigo Farcas

    Rodrigo Farcas Active Member

    Hi Jake
    Indeed, a simple table repair IS fixing it, but the error es recurring, it has happened 4 times yet.
    Nor the physical server or MySQL are having down-times.
     
  4. Digital Doctor

    Digital Doctor Well-Known Member

    Disk full ?

    Not a Xenforo issue really.
    Read these.
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    From a Google search, possible reasons for corruption include:

    I would add to this that you need to make sure your system tmp and mysql tmp directories have enough free space. If those fill up it is bad. But you would normally get an error indicating that as the problem.
     
  6. Digital Doctor

    Digital Doctor Well-Known Member

  7. Rodrigo Farcas

    Rodrigo Farcas Active Member

  8. Rodrigo Farcas

    Rodrigo Farcas Active Member

    Hi Jake.

    Server guys says there is no drive space or memory issue there.
    Is there anything I can do to gather more information on the problem?

    Thank you!
     
  9. Digital Doctor

    Digital Doctor Well-Known Member

    Tell the server guy it's a MySQL issue.
    What version are you using.
     
  10. Luke F

    Luke F Well-Known Member

    Have you checked the mysqld log?

    Is the mysqld reported uptime consistent with the server uptime or last mysqld restart?
     
  11. Digital Doctor

    Digital Doctor Well-Known Member

    It might be a mod_security error. Those are tough to troubleshoot.
     
  12. Rodrigo Farcas

    Rodrigo Farcas Active Member

    Hey Digital Doctor!

    MySQL version is: 5.0.77-log
     
  13. Rodrigo Farcas

    Rodrigo Farcas Active Member

    Hi Luke

    No, did not check that. If they are not consistent, what it will suggest?
     
  14. Digital Doctor

    Digital Doctor Well-Known Member

    Way too old.
     

Share This Page