Closed Bug 846559 Opened 12 years ago Closed 12 years ago

backup2.db.scl3.mozilla.com:MySQL DB Backups is CRITICAL: CRITICAL: webdev has a replication error

Categories

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

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: mpressman, Assigned: mpressman)

Details

15:28:21] <nagios-scl3> Thu 15:28:21 PST [573] backup2.db.scl3.mozilla.com:MySQL DB Backups is CRITICAL: CRITICAL: webdev has a replication error. (http://m.allizom.org/MySQL+DB+Backups) Error 'Unknown column 'deleted' in 'field list''
Assignee: server-ops-database → mpressman
sql: REPLACE INTO `percona`.`checksums`... back ticked column `deleted` confused parser I rewrote the statement and changed the back ticks to single quotes, skipped statement and restarted replication. Had to do this five times with different statements. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for the slave SQL thread to free enough relay log space Master_Host: webdev1.db.scl3.mozilla.com Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: webdev1-bin.000769 Read_Master_Log_Pos: 1794551085 Relay_Log_File: backup1-scl3-relay-bin.000104 Relay_Log_Pos: 550062585 Relay_Master_Log_File: webdev1-bin.000758 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: remora.% Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 550062438 Relay_Log_Space: 21475722461 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 442295 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.00 sec)
Status: NEW → RESOLVED
Closed: 12 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.