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 1
LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries
1
MySQL thread id *redacted*, OS thread handle *redacted*, query id
*redacted* 10.64.0.169 wikiuser202206 Update
INSERT /* Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages */ IGNORE
INTO `wbc_entity_usage` (eu_page_id,eu_aspect,eu_entity_id) VALUES
(783633,'C.P227','Q760690'),(783633,'C.P244','Q760690'),(783>
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id *redacted* page no *redacted* n bits *redacted* index
eu_entity_id of table `eowiki`.`wbc_entity_usage` trx id *redacted* lock mode S
waiting
Record lock, heap no 495 PHYSICAL RECORD: n_fields 4; compact format; info
bits 0
*redacted*
*** (2) TRANSACTION:
TRANSACTION 160726462551, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 3
MySQL thread id 1736043481, OS thread handle *redacted*, query id
*redacted* 10.64.32.38 wikiuser202206 Update
INSERT /* Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages */ IGNORE
INTO `wbc_entity_usage` (eu_page_id,eu_aspect,eu_entity_id) VALUES
(783633,'C.P227','Q760690'),(783633,'C.P244','Q760690'),(783>
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id *redacted* page no *redacted* n bits *redacted* index
eu_entity_id of table `eowiki`.`wbc_entity_usage` trx id *redacted* lock_mode X
locks rec but not gap
Record lock, heap no 495 PHYSICAL RECORD: n_fields 4; compact format; info
bits 0
*redacted*
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id *redacted* page no *redacted* n bits *redacted* index
eu_entity_id of table `eowiki`.`wbc_entity_usage` trx id *redacted* lock_mode X
locks gap before rec insert intention waiting
Record lock, heap no 495 PHYSICAL RECORD: n_fields 4; compact format; info
bits 0
*redacted*
*** WE ROLL BACK TRANSACTION (1)
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,
thcipriani, Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE,
Akuckartz, darthmon_wmde, Rosalie_WMDE, Nandana, Lahi, Gq86, GoranSMilovanovic,
QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Verdy_p, Wikidata-bugs,
aude, Jdforrester-WMF, Mbch331, Jay8g
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
