Page MenuHomePhabricator

labsdb1009:s4 replication broken duplicate entry on commonswiki.wbc_entity_usage
Closed, ResolvedPublic

Description

Last_SQL_Error: Could not execute Write_rows_v1 event on table commonswiki.wbc_entity_usage; Duplicate entry 'Q20668334-L.id-496809' for key 'eu_entity_id', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log db1125-bin.002311, end_log_pos 126347927

Event Timeline

This is strange or it is too early for me:
This is supposed to be the already existing row:

mysql:root@localhost [commonswiki]> select * from wbc_entity_usage where eu_entity_id='Q20668334' and eu_aspect='L.id' and eu_page_id=496809;
+------------+--------------+-----------+------------+
| eu_row_id  | eu_entity_id | eu_aspect | eu_page_id |
+------------+--------------+-----------+------------+
| 1496604098 | Q20668334    | L.id      |     496809 |
+------------+--------------+-----------+------------+
1 row in set (0.02 sec)

mysql:root@localhost [commonswiki]> select * from wbc_entity_usage where eu_row_id=1496604098;
Empty set (0.03 sec)

Replication is now flowing on labsdb1009:s4

Marostegui claimed this task.

Replication has been working for around 12 hours now, so I am going to close this as resolved for now.