762742 - generic[1-2].db.phx1 addons_forum_mozilla_org.phpbb_sessions incorrect key file causing slave replication to stop

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Matt Pressman [:mpressman]]

Query caused different errors on master and slave.     Error on master: message (format)='Invalid error code' error code=126 ; Error on slave: actual message='no error', error code=0. Default database: 'addons_forums_mozilla_org'. Query: 'DELETE FROM phpbb_sessions
			WHERE session_user_id = 1
				AND session_time < 1339094001'

Comment 1

[Matt Pressman [:mpressman]]

on generic1.db.phx1
mysql> check table phpbb_sessions;
+------------------------------------------+-------+----------+----------------------------------------------------------+
| Table                                    | Op    | Msg_type | Msg_text                                                 |
+------------------------------------------+-------+----------+----------------------------------------------------------+
| addons_forums_mozilla_org.phpbb_sessions | check | warning  | Table is marked as crashed                               |
| addons_forums_mozilla_org.phpbb_sessions | check | warning  | 2 clients are using or haven't closed the table properly |
| addons_forums_mozilla_org.phpbb_sessions | check | error    | Found 1696 keys of 1697                                  |
| addons_forums_mozilla_org.phpbb_sessions | check | error    | Corrupt                                                  |
+------------------------------------------+-------+----------+----------------------------------------------------------+

mysql> repair table phpbb_sessions;
+------------------------------------------+--------+----------+----------+
| Table                                    | Op     | Msg_type | Msg_text |
+------------------------------------------+--------+----------+----------+
| addons_forums_mozilla_org.phpbb_sessions | repair | status   | OK       |
+------------------------------------------+--------+----------+----------+
1 row in set (0.04 sec)