Page MenuHomePhabricator

Replication broken on db1124:3311
Closed, ResolvedPublic

Description

Replication broke on db1124:3311 with:

Last_Error: Could not execute Delete_rows_v1 event on table enwiki.pagelinks; Can't find record in 'pagelinks', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log db1106-bin.004050, end_log_pos 125470104

Which corresponds to:

### DELETE FROM `enwiki`.`pagelinks`
### WHERE
###   @1=43107469 /* INT meta=0 nullable=0 is_null=0 */
###   @2=4 /* INT meta=0 nullable=0 is_null=0 */
###   @3='Citing_sources' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @4=0 /* INT meta=0 nullable=0 is_null=0 */
### DELETE FROM `enwiki`.`pagelinks`
### WHERE
###   @1=43107469 /* INT meta=0 nullable=0 is_null=0 */
###   @2=10 /* INT meta=0 nullable=0 is_null=0 */
###   @3='Unreferenced' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @4=0 /* INT meta=0 nullable=0 is_null=0 */
### DELETE FROM `enwiki`.`pagelinks`
### WHERE
###   @1=43107469 /* INT meta=0 nullable=0 is_null=0 */
###   @2=14 /* INT meta=0 nullable=0 is_null=0 */
###   @3='Articles_lacking_sources_from_June_2014' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @4=0 /* INT meta=0 nullable=0 is_null=0 */

Those were fixed and then the following broke:

Last_SQL_Error: Could not execute Delete_rows_v1 event on table enwiki.categorylinks; Can't find record in 'categorylinks', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log db1106-bin.004050, end_log_pos 125554682

Which is:

### DELETE FROM `enwiki`.`categorylinks`
### WHERE
###   @1=43107469 /* INT meta=0 nullable=0 is_null=0 */
###   @2='All_articles_lacking_sources' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @3='LAFFAK, ST HELENS' /* VARSTRING(230) meta=230 nullable=0 is_null=0 */
###   @4=1403353134 /* TIMESTAMP meta=0 nullable=0 is_null=0 */
###   @5='' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @6='uppercase' /* VARSTRING(32) meta=32 nullable=0 is_null=0 */
###   @7=1 /* ENUM(1 byte) meta=63233 nullable=0 is_null=0 */
### DELETE FROM `enwiki`.`categorylinks`
### WHERE
###   @1=43107469 /* INT meta=0 nullable=0 is_null=0 */
###   @2='Articles_lacking_sources_from_June_2014' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @3='LAFFAK, ST HELENS' /* VARSTRING(230) meta=230 nullable=0 is_null=0 */
###   @4=1403353134 /* TIMESTAMP meta=0 nullable=0 is_null=0 */
###   @5='' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @6='uppercase' /* VARSTRING(32) meta=32 nullable=0 is_null=0 */
###   @7=1 /* ENUM(1 byte) meta=63233 nullable=0 is_null=0 */

And then:

Last_SQL_Error: Could not execute Delete_rows_v1 event on table enwiki.templatelinks; Can't find record in 'templatelinks', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log db1106-bin.004050, end_log_pos 125710504
### DELETE FROM `enwiki`.`templatelinks`
### WHERE
###   @1=43107469 /* INT meta=0 nullable=0 is_null=0 */
###   @2=10 /* INT meta=0 nullable=0 is_null=0 */
###   @3='Unreferenced' /* VARSTRING(255) meta=255 nullable=0 is_null=0 */
###   @4=0 /* INT meta=0 nullable=0 is_null=0 */

Everything has been fixed and replication is catching up again. I have created this for the record