By testi@groups.drupal.org on

Site broken/down every page shows a huge error and also cant login.

Error message starts with (see below)

You can see the full message here http://www.omatila.com/

What caused this and how can I avoid this in the future?

Any other way to deal with this than to restore things from backup.

Any help appreciated Thanks.

"Warning: Can't open file: 'cache.MYI' (errno: 145) query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /home/omatilac/public_html/includes/database.mysql.inc on line 121

Warning: Can't open file: 'cache.MYI' (errno: 145) query: LOCK TABLES cache WRITE in /home/omatilac/public_html/includes/database.mysql.inc on line 121

Warning: Can't open file: 'cache.MYI' (errno: 145) query: UPDATE cache SET data = 'a:334:{s:13:\"theme_default\";s:15:\"zen-drops-small\";s:13:\"filter_html_1\";s:1:\"1\";s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:17:\"menu_primary_menu\";s:1:\"2\";s:19:\"menu_secondary_menu\";s:2:\"48\";s:18:\"drupal_private_key\";i:447109698;s:19:\"file_directory_temp\";s:4:\"/tmp\";s:9:\"site_name\";s:11:\"omatila.com\";s:9:\"site_mail\";s:16:\"info@omatila.com\";s:11:\"site_slogan\";s:0:\"\";s:12:\"site_mission\";s:0:\"\";s:11:\"site_footer\";s:0:\"\";s:9:\"anonymous\";s:9:\"Anonymous\";s:14:\"site_frontpage\";s:4:\"node\";s:9:\"clean_url\";s:1:\"1\";s:8:\"site_404\";s:7:\"node/47\";s:11:\" in /home/omatilac/public_html/includes/database.mysql.inc on line 121

Warning: Cannot modify header information - headers already sent by (output started at /home/omatilac/public_html/includes/database.mysql.inc:121) in /home/omatilac/public_html/includes/bootstrap.inc on line 562"

⋅ Categories: Drupal 4.7.x

Comments

stevenpatz’s picture

stevenpatz
he/him
commented

I see:
MySQL error code 145: Table was marked as crashed and should be repaired

Your database needs fixed.

testi@groups.drupal.org’s picture

testi@groups.drupal.org commented

Thanks for the answer spatz4000, I got it fixed.

I did a search and found similar cases.

All I had to do was to fix the cache table.

I just did repair database something and it it cleared the cache table.

Everything is working now.

srcnyc’s picture

srcnyc commented

I'm getting the same error messages on my site. I haven't changed anything recently; I just went to the site tonight and saw all these error messages. I've tried repairing and emptying both my cache table and my sessions table, and neither helped. None of my tables have overhead. Here are the error messages I'm seeing at www.letsdoitontheroad.com:

"Warning: Can't open file: 'cache.MYI' (errno: 145) query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /usr/www/users/srcnyc/includes/database.mysql.inc on line 120

Warning: Can't open file: 'cache.MYI' (errno: 145) query: LOCK TABLES cache WRITE in /usr/www/users/srcnyc/includes/database.mysql.inc on line 120

Warning: Can't open file: 'cache.MYI' (errno: 145) query: UPDATE cache SET data = 'a:93:{s:13:\"theme_default\";s:6:\"marvin\";s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:17:\"menu_primary_menu\";s:1:\"2\";s:19:\"file_directory_temp\";s:8:\"/usr/tmp\";s:14:\"theme_settings\";a:18:{s:11:\"toggle_logo\";i:1;s:11:\"toggle_name\";i:0;s:13:\"toggle_slogan\";i:0;s:14:\"toggle_mission\";i:1;s:24:\"toggle_node_user_picture\";i:0;s:27:\"toggle_comment_user_picture\";i:0;s:13:\"toggle_search\";i:1;s:14:\"toggle_favicon\";i:1;s:21:\"toggle_node_info_blog\";i:0;s:22:\"toggle_node_info_forum\";i:0;s:21:\"toggle_node_info_page\";i:1;s:22:\"toggle_node_info_story\";i:1;s:12:\"default_logo\";i:0;s:9:\"logo_path\";s:14:\"files/logo.gif\& in /usr/www/users/srcnyc/includes/database.mysql.inc on line 120

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/srcnyc/includes/database.mysql.inc:120) in /usr/www/users/srcnyc/includes/bootstrap.inc on line 548

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/srcnyc/includes/database.mysql.inc:120) in /usr/www/users/srcnyc/includes/bootstrap.inc on line 549

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/srcnyc/includes/database.mysql.inc:120) in /usr/www/users/srcnyc/includes/bootstrap.inc on line 550

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/srcnyc/includes/database.mysql.inc:120) in /usr/www/users/srcnyc/includes/bootstrap.inc on line 551

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/srcnyc/includes/database.mysql.inc:120) in /usr/www/users/srcnyc/includes/bootstrap.inc on line 552"

azote’s picture

azote commented

I had the same problem but with the `watchdog` table....

so when to mysqladmin and typed:
REPAIR TABLE `watchdog`
and that fix it!

OrbisMedia’s picture

OrbisMedia commented

Had the same problem, a table somehow crashed in the middle of the night.

Just made a sql query of:

REPAIR TABLE `cache_menu`

And everything was fine!