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

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
4 years ago

People

(Reporter: mpressman, Assigned: mpressman)

Tracking

Details

(Assignee)

Description

6 years ago
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'
(Assignee)

Updated

6 years ago
Assignee: server-ops-database → mpressman
(Assignee)

Comment 1

6 years ago
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)
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.