• 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

#1
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!
 

Jake Bunce

XenForo moderator
Staff member
#2
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
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.
 

Jake Bunce

XenForo moderator
Staff member
#5
From a Google search, possible reasons for corruption include:

1- The mysqld process being killed in the middle of a write.
2- Unexpected shutdown of the computer (for example, if the computer is
turned off).
3- A hardware error such as faulty memory/cpu/motherboard and or hard drive.
4- You are using an external program (like myisamchk) on a live table.
5- A software bug in the MySQL or MyISAM code
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.
 
#8
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.
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!
 

Luke F

Well-known member
#10
Have you checked the mysqld log?

Is the mysqld reported uptime consistent with the server uptime or last mysqld restart?
 

Digital Doctor

Well-known member
#11
That's a temporary table that MySQL is making for a query. If you're not running 1.1.1, upgrade to that as it should improve that query.

However, regardless, the fact that MySQL appears to be corrupting a table it's making is a bad thing. It sounds like a MySQL bug to me.
Was a mod security related error. The host fixed it. Thank you for your help.
It might be a mod_security error. Those are tough to troubleshoot.