[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added CC||aklap...@wikimedia.org --- Comment #16 from Andre Klapper aklap...@wikimedia.org --- All patches mentioned in this report were merged - is there more work left to do here (if yes: please reset the bug report status to NEW or ASSIGNED), or can you close this ticket as RESOLVED FIXED? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 Niklas Laxström niklas.laxst...@gmail.com changed: What|Removed |Added Status|PATCH_TO_REVIEW |NEW -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 Niklas Laxström niklas.laxst...@gmail.com changed: What|Removed |Added CC||pcoo...@wikimedia.org --- Comment #15 from Niklas Laxström niklas.laxst...@gmail.com --- *** Bug 56357 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #14 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 148444 merged by jenkins-bot: Use GET_LOCK to try to reduce translate_groupstats deadlocks https://gerrit.wikimedia.org/r/148444 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #12 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 148444 had a related patch set uploaded by Aaron Schulz: Use GET_LOCK to try to reduce INSERT deadlocks https://gerrit.wikimedia.org/r/148444 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 Gerrit Notification Bot gerritad...@wikimedia.org changed: What|Removed |Added Status|NEW |PATCH_TO_REVIEW -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #13 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 148444 had a related patch set uploaded by Nikerabbit: Use GET_LOCK to try to reduce INSERT deadlocks https://gerrit.wikimedia.org/r/148444 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #11 from Tomasz W. Kozlowski twkozlow...@gmail.com --- Just got that on Meta while trying to view [[m:Tech/News/2014/25]]. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #9 from Niklas Laxström niklas.laxst...@gmail.com --- Probably someone viewing Special:LanguageStats or Special:MessageGroupStats. There is during-request processing with couple of second timeout after which it will give not available for the rest for that request. The actual insertion to DB could be delayed if that helps. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #10 from Aaron Schulz aschulz4...@gmail.com --- It would probably help if the INSERT was: a) As close to the COMMIT as possible (without much else interlaced) b) Batched as one INSERT, or at least have the inserts in lexicographical order of (tgs_group, tgs_lang) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410
--- Comment #8 from Aaron Schulz aschulz4...@gmail.com ---
Log snippet from today (truncated the middle since it was repetitive):
2014-06-06 20:22:22 mw1137 metawiki: Sub-optimal transaction on DB(s)
10.64.16.22 (metawiki) (3fecc80fa293a52d):
0 30.377860 query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
1 30.378035 DatabaseBase::query-master
2 0.000352query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
3 0.000396query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
4 0.000485query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
5 0.000379query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
6 0.000360query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
7 0.000310query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
8 0.000388query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
9 0.000373query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
10 0.000331query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
11 0.000379query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
12 0.000384query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
13 0.000325query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
...snip...
392 0.000357query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
393 0.000383query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
394 0.000424query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
395 0.000362query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
396 0.000470query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
397 0.000418query-m: INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('X')
398 0.002223query-m: COMMIT
Are there some mass-updates triggered by user actions that could possibly using
a job queue or something?
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410
--- Comment #6 from Aaron Schulz aschulz4...@gmail.com ---
Dozens of servers trying to insert the same row on metawiki today:
INSERT IGNORE INTO `translate_groupstats`
(tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES
('page-Terms of use/Paid contributions amendment','en','46','46','0','0')
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #7 from Niklas Laxström niklas.laxst...@gmail.com --- (In reply to Niklas Laxström from comment #1) Any suggestions how to fix? PoolCounter? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #4 from Niklas Laxström niklas.laxst...@gmail.com --- Why is this suddenly high priority? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Priority|High|Unprioritized --- Comment #5 from Andre Klapper aklap...@wikimedia.org --- L10N Eng Dev team defines priorities themselves. Resetting. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #2 from Erik Moeller e...@wikimedia.org --- There are also MessageGroupStats related locking issues on mediawiki.org, e.g.: Mon Sep 9 18:24:16 UTC 2013 mw1194 mediawikiwiki MessageGroupStats::clear10.64.16.8 1205Lock wait timeout exceeded; try restarting transaction (10.64.16.8) DELETE FROM `translate_groupstats` WHERE tgs_group = 'page-Communication' AND tgs_lang = 'hu' This may be a separate issue, but posting here for reference. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 51410] MessageGroupStats::forItemInternal deadlocks
https://bugzilla.wikimedia.org/show_bug.cgi?id=51410 --- Comment #1 from Niklas Laxström niklas.laxst...@gmail.com --- Any suggestions how to fix? PoolCounter? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
