Page MenuHomePhabricator
Paste P8014

SlowTimer
ActivePublic

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 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)

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

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

Noted!

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.

KartikMistry changed the visibility from "Subscribers" to "Public (No Login Required)".Jan 23 2019, 4:33 PM