Wikidata Database contention under high edit rate
Closed, DuplicatePublic

Description

Lots of errors while executing:

INSERT INTO `wb_entity_per_page` (epp_entity_id,epp_entity_type,epp_page_id,epp_redirect_target) VALUES ('25615547','item','27568157',NULL)

Wikibase\Repo\Store\SQL\EntityPerPageTable::{closure} 10.64.16.144 1213 Deadlock found when trying to get lock; try restarting transaction

https://logstash.wikimedia.org/#dashboard/temp/AVXGj9flc8qLrUhXb891

This was an excessive usage of the API (T139618), but maybe there is room for improvement?

jcrespo created this task.Jul 7 2016, 6:13 PM
Restricted Application added subscribers: Zppix, Aklapper. · View Herald TranscriptJul 7 2016, 6:13 PM

Low priority for this right now (the user war editing with a parallelism of 35), but maybe a problem in the future if the edition growth keeps going up.

jcrespo renamed this task from Database contention under high edit rate to Wikidata Database contention under high edit rate.Jul 12 2016, 5:58 PM