xf_session table crashing continously

[Rodrigo Farcas]

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.

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]

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.

 

[Rodrigo Farcas]

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.

 

[Digital Doctor]

Any clue?

Disk full ?

Not a Xenforo issue really.
Read these.

 

[Jake Bunce]

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.

 

[Digital Doctor]

******AdvStats - are you using this ?

http://xenforo.com/community/threads/i-am-sick-of-tired.30373/

other xenforo users have had this. [click search]

 

[Rodrigo Farcas]

******AdvStats - are you using this ?

http://xenforo.com/community/threads/i-am-sick-of-tired.30373/

other xenforo users have had this. [click search]

Hi! No, we are not using that addon

 

[Rodrigo Farcas]

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!

 

[Digital Doctor]

Server guys says there is no drive space or memory issue there.

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

 

[Luke F]

Have you checked the mysqld log?

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

 

[Digital Doctor]

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.

 

[Rodrigo Farcas]

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

Hey Digital Doctor!

MySQL version is: 5.0.77-log

 

[Rodrigo Farcas]

Have you checked the mysqld log?

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

Hi Luke

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

 

[Digital Doctor]

MySQL version is: 5.0.77-log

Way too old.