Sudden database issue. Failed repair.

  • rickmacmerc

    (@rickmacmerc)


    13 years, 7 months ago

    I was made aware that my site was down and was greeted by a repair page and followed the procedure until I was told to come here and post the following information:

    wp_posts: Wrong bytesec: 49-50-48 at linkstart: 2011104
    wp_comments: Can’t read indexpage from filepos: 5120
    wp_options: Size of datafile is: 2031799 Should be: 1966116

    Any help would be greatly appreciated. Thanks.

Viewing 13 replies - 1 through 13 (of 13 total)
  • s_ha_dum

    (@apljdi)

    13 years, 7 months ago

    I am curious as to who told you to come here? I am happy to look into things– it is kind of my hobby 🙂 — but that is a database error, proper. It isn’t a WordPress issue. That is, WordPress runs “on top of” a database (MySQL). You have a failure of that database. It is a bit like the relationship of a car to the road. A mechanic can fix a car (WordPress) but can’t do anything about the underlying road (your database). Unless you have high level privileges on your server (usually that means a VPS or better) you will have to get help from your host. Here are some links though:

    http://lists.mysql.com/mysql/1849

    http://www.webhostingtalk.com/showthread.php?t=714539

    The concensus seems to be myisamchk -r *.MYI. but that isn’t a personal endorsement.

    Thread Starter rickmacmerc

    (@rickmacmerc)

    13 years, 7 months ago

    WordPress itself tells me to come here at the end of the repair.

    s_ha_dum

    (@apljdi)

    13 years, 7 months ago

    I see. 🙂 It’s the automated response that told you to come here. Well, it is a database error. It isn’t a WordPress error, really. Your answer is above. You need administrative permissions on your server and a working knowledge of the database’s repair functions, or you need to get help from your host. This is not a minor issue, nor is it a programming problem. The database had a serious failure, but it may be recoverable.

    leethompson

    (@leethompson)

    13 years, 7 months ago

    You can repair your database edit username and password into the connection string upload this to your server browse to it, Make sure to delete it when you are done.

    <?

$dbLink = mysql_connect("localhost", "username", "password") or die("Unable to connect to the database.");

$sql = "show databases";
$query = mysql_query($sql) or die("error fetching database names");

while ($rs=mysql_fetch_array($query)) {

//echo "Database: " . $rs['Database'] . "\n";

mysql_select_db($rs['Database'],$dbLink) or die("Unable to select database: " . $rs['Database']);

$sql = "show tables";
$query2 = mysql_query($sql) or die("error fetching table names");

while ($rs2=mysql_fetch_array($query2)) {
$key = "Tables_in_" . $rs['Database'];
//echo "Table: " . $rs2[$key] . "\n";

$sql = "repair table " . $rs2[$key];
$query3 = mysql_query($sql) or die("Error repairing a table - $sql");
$rs3 = mysql_fetch_array($query3);
echo $rs3['Table'] . " | " . $rs3['Op'] . " | " . $rs3['Msg_type'] . " | " . $rs3['Msg_text'] . "\n";

}

}

echo "Finished!\n";

?>

    Lee

    Thread Starter rickmacmerc

    (@rickmacmerc)

    13 years, 7 months ago

    Ok, my web host claims it’s a problem with WordPress (surprise surprise). They say that they’ve gone into the database and repaired the corrupted tables and that WordPress is connecting to the database but it isn’t using the data as it should and, thus, is giving the errors.

    To prove this claim, my host has provided the following queries that they say you brilliant folks will be able to recognize. They suggested that someone here would undoubtably know how to talk some sense into WordPress and get it to behave.

    So, with no further adieu, the queries…

    462615 Connect     macmerc_11@209.68.1.202 on 
		 462615 Query       SET NAMES utf8
		 462615 Init DB     macmerc_wordpressed
		 462615 Query       SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
		 462615 Query       SELECT option_value FROM wp_options WHERE option_name = 'siteurl'
		 462615 Query       DESCRIBE wp_users
		 462615 Quit       
		 462616 Connect     macmerc_11@209.68.1.202 on 
		 462616 Query       SET NAMES utf8
		 462616 Init DB     macmerc_wordpressed
		 462616 Query       SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
		 462616 Query       SELECT option_value FROM wp_options WHERE option_name = 'siteurl'
		 462616 Query       DESCRIBE wp_users
		 462616 Quit       
    Thread Starter rickmacmerc

    (@rickmacmerc)

    13 years, 7 months ago

    …and, leethompson, I got this…
    Error repairing a table - repair table CHARACTER_SETS

    leethompson

    (@leethompson)

    13 years, 7 months ago

    Do you have access to phpmyadmin or access to the MySQL server?

    leethompson

    (@leethompson)

    13 years, 7 months ago

    If you do not have your host run a show table status and give you the output.

    Lee

    Thread Starter rickmacmerc

    (@rickmacmerc)

    13 years, 7 months ago

    I can access the SQL database via a desktop SQL client.

    wp_ad_buttons	MyISAM	10	Dynamic	8	177	1420	281474976710655	2048	0	9	2012-01-25 22:41:58	2012-08-28 04:01:28	2012-08-28 13:30:58	latin1_swedish_ci	NULL
wp_ad_buttons_stats	MyISAM	10	Fixed	4394413	10	43944130	2814749767106559	40386560	0	NULL	2010-07-10 02:02:17	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_az_indexes	MyISAM	10	Dynamic	4	2553	10212	281474976710655	2048	0	NULL	2009-05-12 03:11:10	2012-08-28 04:01:37	2012-08-28 13:31:02	utf8_general_ci	NULL
wp_bad_behavior	MyISAM	10	Dynamic	3405	383	1305492	281474976710655	72704	0	551953	2010-06-15 20:59:08	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_commentmeta	MyISAM	10	Dynamic	400	519	207916	281474976710655	19456	0	2973	2010-06-15 00:08:11	2012-08-28 04:01:37	2012-08-28 13:31:02	utf8_general_ci	NULL
wp_comments	MyISAM	10	Dynamic	243	415	101072	281474976710655	25600	0	1439	2012-06-14 11:00:49	2012-08-28 04:38:47	2012-08-28 13:31:02	utf8_general_ci	NULL
wp_comments_meta	MyISAM	10	Dynamic	0	0	0	281474976710655	1024	0	1	2010-07-27 13:52:29	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_links	MyISAM	10	Dynamic	6	147	884	281474976710655	4096	0	14	2010-06-15 00:08:11	2012-08-28 04:01:37	2012-08-28 13:31:02	utf8_general_ci	NULL
wp_liveblog_entries	MyISAM	10	Dynamic	0	0	0	281474976710655	1024	0	1	2010-08-04 02:23:08	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_liveblogs	MyISAM	10	Dynamic	0	0	0	281474976710655	1024	0	1	2010-08-04 02:23:08	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_options	MyISAM	10	Dynamic	903	2164	1954180	281474976710655	39936	0	476246	2012-06-14 11:00:49	2012-08-28 04:38:55	2012-08-28 13:31:02	utf8_general_ci	NULL
wp_pictPocket	MyISAM	10	Dynamic	90	185	16720	281474976710655	2048	0	95	2010-06-15 21:20:51	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_pictPocket_autorisation	MyISAM	10	Dynamic	12	39	468	281474976710655	2048	0	13	2010-06-15 21:20:51	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_popover	MyISAM	10	Dynamic	1	892	892	281474976710655	2048	0	2	2012-03-05 22:14:17	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_popover_ip_cache	MyISAM	10	Dynamic	0	0	0	281474976710655	1024	0	NULL	2012-05-26 20:14:38	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_popularpostsdata	MyISAM	10	Fixed	4083	25	102075	7036874417766399	44032	0	NULL	2010-07-01 02:07:57	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_popularpostsdatacache	MyISAM	10	Fixed	2689	17	45713	4785074604081151	54272	0	NULL	2012-01-25 22:41:58	2012-08-28 04:01:37	2012-08-28 13:31:02	latin1_swedish_ci	NULL
wp_postmeta	MyISAM	10	Dynamic	36578	80	2936744	281474976710655	1160192	0	46689	2010-06-15 00:08:11	2012-08-28 04:01:38	2012-08-28 13:31:02	utf8_general_ci	NULL
wp_posts	MyISAM	10	Dynamic	11036	2181	24077004	281474976710655	14670848	0	12769	2012-06-14 11:00:03	2012-08-28 04:38:37	2012-08-28 13:31:04	utf8_general_ci	NULL
wp_redirection_groups	MyISAM	10	Dynamic	2	34	68	281474976710655	4096	0	3	2010-06-22 03:03:12	2012-08-28 04:01:56	2012-08-28 13:31:04	latin1_swedish_ci	NULL
wp_redirection_items	MyISAM	10	Dynamic	56	145	8168	281474976710655	10240	0	85	2010-12-12 19:51:36	2012-08-28 04:01:56	2012-08-28 13:31:04	latin1_swedish_ci	NULL
wp_redirection_logs	MyISAM	10	Dynamic	312	268	83804	281474976710655	38912	0	241230	2010-12-12 19:51:36	2012-08-28 04:01:56	2012-08-28 13:31:04	latin1_swedish_ci	NULL
wp_redirection_modules	MyISAM	10	Dynamic	3	24	72	281474976710655	4096	0	4	2010-12-12 19:51:37	2012-08-28 04:01:56	2012-08-28 13:31:04	latin1_swedish_ci	NULL
wp_socialtraffic	MyISAM	10	Dynamic	0	0	0	281474976710655	1024	0	NULL	2010-08-02 21:55:34	2012-08-28 04:01:56	2012-08-28 13:31:04	latin1_swedish_ci	NULL
wp_term_relationships	MyISAM	10	Fixed	168869	21	3546249	5910974510923775	6283264	0	NULL	2010-06-15 00:08:14	2012-08-28 04:01:56	2012-08-28 13:31:05	utf8_general_ci	NULL
wp_term_taxonomy	MyISAM	10	Dynamic	22749	40	910132	281474976710655	785408	0	25767	2010-06-15 00:08:14	2012-08-28 04:01:57	2012-08-28 13:31:05	utf8_general_ci	NULL
wp_terms	MyISAM	10	Dynamic	22724	39	886828	281474976710655	1238016	0	25741	2010-06-15 00:08:14	2012-08-28 04:01:57	2012-08-28 13:31:05	utf8_general_ci	NULL
wp_tml_emails	MyISAM	10	Dynamic	302	32	9820	281474976710655	17408	0	303	2011-05-26 02:09:51	2012-08-28 04:01:57	2012-08-28 13:31:05	latin1_swedish_ci	NULL
wp_tml_history	MyISAM	10	Fixed	56	22	1232	6192449487634431	3072	0	NULL	2011-05-26 02:09:51	2012-08-28 04:01:57	2012-08-28 13:31:05	latin1_swedish_ci	NULL
wp_tml_log	MyISAM	10	Dynamic	54	627	33900	281474976710655	2048	0	55	2011-06-13 00:36:54	2012-08-28 04:01:57	2012-08-28 13:31:05	latin1_swedish_ci	NULL
wp_tml_queue	MyISAM	10	Fixed	0	0	0	5910974510923775	1024	0	62	2011-05-26 02:09:51	2012-08-28 04:01:57	2012-08-28 13:31:05	latin1_swedish_ci	NULL
wp_topref	MyISAM	10	Dynamic	0	0	0	281474976710655	1024	0	2	2010-08-01 13:41:05	2012-08-28 04:01:57	2012-08-28 13:31:05	latin1_swedish_ci	NULL
wp_usermeta	MyISAM	10	Dynamic	52	81	4252	281474976710655	7168	0	61	2010-06-15 00:08:14	2012-08-28 04:01:57	2012-08-28 13:31:05	utf8_general_ci	NULL
wp_users	MyISAM	10	Dynamic	2	108	216	281474976710655	4096	0	3	2009-05-12 03:12:51	2012-08-28 04:01:57	2012-08-28 13:31:05	utf8_general_ci	NULL
wp_wplinkdir_cats	MyISAM	10	Dynamic	3	72	216	281474976710655	2048	0	4	2010-08-19 19:16:38	2012-08-28 04:01:57	2012-08-28 13:31:05	latin1_swedish_ci	NULL
wp_wplinkdir_links	MyISAM	10	Dynamic	1	172	172	281474976710655	4096	0	2	2010-08-19 19:16:38	2012-08-28 04:01:57	2012-08-28 13:31:05	latin1_swedish_ci	NULL
wp_yarpp_keyword_cache	MyISAM	10	Dynamic	4	179	716	281474976710655	2048	0	NULL	2010-07-02 22:53:58	2012-08-28 04:01:57	2012-08-28 13:31:06	utf8_unicode_ci	NULL		YARPP's keyword cache table
wp_yarpp_related_cache	MyISAM	10	Fixed	20	25	500	7036874417766399	2048	0	NULL	2010-07-02 22:53:58	2012-08-28 04:01:57	2012-08-28 13:31:06	utf8_unicode_ci	NULL
wpsd_trends	MyISAM	10	Fixed	2990	25	74750	7036874417766399	44032	0	2991	2010-08-02 21:58:15	2012-08-28 04:01:57	2012-08-28 13:31:06	utf8_general_ci	NULL
    s_ha_dum

    (@apljdi)

    13 years, 7 months ago

    That CHARACTER_SETS table is a part of MySQL’s information_schema database, which is used internally by MySQL. What is show table status for that database?

    leethompson

    (@leethompson)

    13 years, 7 months ago

    Do you have a translation plugin installed on your site?

    leethompson

    (@leethompson)

    13 years, 7 months ago

    And can you run the query SET NAMES utf8 from your MyXQL client?

    Thread Starter rickmacmerc

    (@rickmacmerc)

    13 years, 7 months ago

    No translation plugin to my knowledge. Not something I’d be interested in.

    Ran the SET NAMES utf8 query and got back no errors.

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘Sudden database issue. Failed repair.’ is closed to new replies.