WordPress.org

1. anmari
   Member
   Posted 1 year ago #

   Hi I am just hoping someone can educate me here. This is the second time in a matter of weeks that I have had a problme that turned out to something going wrong with a db table - repair table from phpmyadmin fixed it both times.

   Different tables, different websites - table shows up in the phpmydamin list as "in use" - whatever that means!

   Also most scarily - since the second time is was the posts table, ALL pages and posts were delivering 404's - I tried permalinks, but was not that.

   QUESTION:
   what causes this? is it a mysql problem, a hardware problem?

2. anmari
   Member
   Posted 1 year ago #

   okay I have semi answered myself I guess, Although any advice on how to detect and/or prevent would be appreciated.

   It is either the hardware or a bug in the sql code?

   http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html

   The mysql site says:
   * The mysqld process is killed in the middle of a write.
   * An unexpected computer shutdown occurs (for example, the computer is turned off).
   * Hardware failures.
   * You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time.
   * A software bug in the MySQL or MyISAM code.

3. anmari
   Member
   Posted 1 year ago #

   Found this in the trac
   http://core.trac.wordpress.org/ticket/4677 and this
   http://core.trac.wordpress.org/ticket/10728

   which seem to indicate that wordpress can detect a corrupt table? If so , seems one really should have some kind of alert sent to the admin user if possible.

   Does any one know if there is a plugin that could send an alert (assuming it can run even if the options table (for eg) is broken? )

Topic Closed

This topic has been closed to new replies.