I have xen virtual machine (Debian stable in PV mode) and I've Joomla on it. Several times in a day I see this message on the front page of my site.
jtablesession::Store Failed DB function failed with error number 144 Table './database@002enet/hfd_session' is marked as crashed and last (automatic?) repair failed SQL=INSERT INTO `hfd_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'iae9qhmfhst464v4d0a6ho6nt3','1330628728','','0','1','0' )
I can't find the reason why it is crashing.
mysql.log and mysql.err log are clear. There are only some records in the mysql slow log, but they seem not be connected with this table. It is only this table that is crashing.
I tried to drop this table and to create it again, to restart system and to check disk with fsck (there was no error). But I still encounter this crash And I need to fix it manually every time I see it.
Is there any way to fix this issue?
$ dpkg -l | grep mysql ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database ii libmysqlclient16 5.1.49-3 MySQL database client library ii mysql-client-5.1 5.1.49-3 MySQL database client binaries ii mysql-common 5.1.49-3 MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.1.49-3 MySQL database server (metapackage depending on the latest version) ii mysql-server-5.1 5.1.49-3 MySQL database server binaries and system database setup ii mysql-server-core-5.1 5.1.49-3 MySQL database server binaries ii php5-mysql 5.3.3-7+squeeze3 MySQL module for php5