Page MenuHomePhabricator
Paste P8014

SlowTimer
ActivePublic
Actions

Authored by KartikMistry on Jan 21 2019, 1:10 PM.
-----------------------------------------------------------------
anwiki
-----------------------------------------------------------------
anwiki: $wgContentTranslationTranslateInTarget is enabled. This script must be run separately for each target language.
anwiki: Running for language an
anwiki: Selecting drafts with last modified timestamp older than 2016-11-12T00:00:00+00:00
anwiki: Found 12 purgeable drafts
anwiki: DRY-RUN mode: drafts are not purged unless you add --really
[Mon Jan 21 12:59:21 2019] [hphp] [757:7f249e2813c0:0:000001] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114364087,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 64321 2015-09-03T10:32:25+00:00 ca→an Serra de Rubió
[Mon Jan 21 13:00:21 2019] [hphp] [757:7f249e2813c0:0:000002] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114365675,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 71825 2015-10-03T11:46:54+00:00 en→an Epilepsy
[Mon Jan 21 13:01:22 2019] [hphp] [757:7f249e2813c0:0:000003] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114367620,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 107283 2016-01-17T15:43:01+00:00 ca→an KGB
[Mon Jan 21 13:02:22 2019] [hphp] [757:7f249e2813c0:0:000004] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114369552,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 71870 2016-01-20T17:13:17+00:00 ca→an Guam
[Mon Jan 21 13:03:22 2019] [hphp] [757:7f249e2813c0:0:000005] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114371771,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 117491 2016-02-15T05:49:04+00:00 es→an Tubalcaín
[Mon Jan 21 13:04:22 2019] [hphp] [757:7f249e2813c0:0:000006] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114373609,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 118797 2016-02-18T21:11:50+00:00 es→an Finlandia
[Mon Jan 21 13:05:22 2019] [hphp] [757:7f249e2813c0:0:000007] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114374767,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 119969 2016-02-25T19:23:23+00:00 es→an Video
[Mon Jan 21 13:06:22 2019] [hphp] [757:7f249e2813c0:0:000008] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114376252,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 108946 2016-03-21T12:26:17+00:00 ca→an Sintagma
[Mon Jan 21 13:07:22 2019] [hphp] [757:7f249e2813c0:0:000009] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114378427,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 71812 2016-03-31T11:41:21+00:00 es→an Sintagma
[Mon Jan 21 13:08:22 2019] [hphp] [757:7f249e2813c0:0:000010] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114379980,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 149174 2016-05-05T20:43:45+00:00 es→an Permacultura
[Mon Jan 21 13:09:22 2019] [hphp] [757:7f249e2813c0:0:000011] [] SlowTimer [60000ms] at runtime/ext_mysql: slow query: SELECT MASTER_GTID_WAIT('0-171966669-4075095254,171966669-171966669-3589226378,171974792-171974792-114381362,180359174-180359174-94172731,180363367-180363367-134174373', 60)
anwiki: 199832 2016-09-04T15:27:52+00:00 es→an Iglesia de la Purificación (Lituénigo)

Event Timeline

KartikMistry created this paste.Jan 21 2019, 1:10 PM
KartikMistry added subscribers: Nikerabbit, • Marostegui.
KartikMistry added a comment.EditedJan 21 2019, 1:29 PM

I'm running,

foreachwikiindblist '%% wikipedia.dblist - special.dblist - closed.dblist' extensions/ContentTranslation/scripts/purge-unpublished-drafts.php --age-in-days=800 |& tee -a ~/purgelog.txt on mwmaint1002.

Which has no write (as it is dry-run)

KartikMistry added a subscriber: jcrespo.Jan 21 2019, 1:30 PM
KartikMistry added a subscriber: aaron.Jan 21 2019, 1:33 PM
• Marostegui added a comment.Jan 21 2019, 1:33 PM

Keep in mind that there is also the Actor migration (T188327#4895206) on going

KartikMistry added a comment.Jan 21 2019, 1:34 PM
In P8014#47547, @Marostegui wrote:

Keep in mind that there is also the Actor migration (T188327#4895206) on going

Noted!

jcrespo added a comment.Jan 21 2019, 1:35 PM

Keep in mind that there is also the Actor migration (T188327#4895206) on going

Assuming this is eqiad, that should not be a factor; the waiting forever stuck on a gtid that doesn't exist on the replica matches better.

• Marostegui added a subscriber: Addshore.Jan 23 2019, 8:17 AM
KartikMistry changed the visibility from "Subscribers" to "Public (No Login Required)".Jan 23 2019, 4:33 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL