[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

ItamarWMDE added projects: wmde-wikidata-tech, Wikidata Dev Team. TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: ItamarWMDE Cc: brennen, Ladsgroup, Krinkle, eprodromou, aaron, Michael, Aklapper,

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

brennen added a project: User-brennen. brennen added a comment. Still seeing this in 1.41.0-wmf.27 (T345888 ). TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Ladsgroup added a comment. From what I'm seeing, it seems it tries to do the exact same insert back to back. Maybe it needs de-duplication logic: 2022-08-08 14:15:01 *redacted* *** (1) TRANSACTION: TRANSACTION *redacted*, ACTIVE 0 sec inserting mysql tables in use 1, locked

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Krinkle removed a project: Wikimedia-Rdbms. TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Krinkle Cc: Umherirrender, Ladsgroup, Krinkle, eprodromou, aaron, Michael, Addshore, Aklapper,

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Krinkle added a comment. Still seen on various wikipedias, in the past week, such as: - reqId: `25a14a4b-aa85-460a-9aa2-3ddb686f1fda` - wiki: zhwiki [{reqId}] {exception_url} Wikimedia\Rdbms\DBQueryError: Error 1213: Deadlock found when trying to get lock; try restarting

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Addshore removed a project: Wikidata-Campsite. TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Umherirrender, Ladsgroup, Krinkle, eprodromou, aaron, Michael, Addshore, Aklapper,

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Umherirrender added a comment. It it using batches for the insert and doing INSERT IGNORE, after that it waits for replica with domain to the local wiki id. The current wmf config seems `wmgWikibaseClientAddEntityUsagesBatchSize` with 100, the hard coded default is 500 in case the

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Restricted Application added a project: wdwb-tech-focus. TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Ladsgroup, Krinkle, eprodromou, aaron, Michael, Addshore, Aklapper,

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Addshore added a comment. T253026: Introduce a centralized Dependency Tracking Service would help here TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Addshore merged a task: T260277: UsageTrackerException: Sql/SqlUsageTracker.php: Error 1213: Function: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock found when trying to get lock; try restarting transaction. TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Krinkle added a comment. Still seen in current production. TASK DETAIL https://phabricator.wikimedia.org/T255706 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Krinkle Cc: Krinkle, eprodromou, aaron, Michael, Addshore, Aklapper, thcipriani,

[Wikidata-bugs] [Maniphest] T255706: Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages Deadlock

Krinkle edited projects, added Wikidata-Campsite; removed Platform Team Workboards (Clinic Duty Team). Krinkle added a comment. This is related to Rdbms in the same way that it relates to PHP and MediaWiki. It uses it, but it's not where the problem is. TASK DETAIL