[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2019-01-12 Thread gerritbot
gerritbot added a comment.
Change 483943 merged by jenkins-bot:
[mediawiki/core@REL1_30] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/483943TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, gerritbotCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2019-01-12 Thread gerritbot
gerritbot added a comment.
Change 483859 merged by jenkins-bot:
[mediawiki/core@REL1_32] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/483859TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, gerritbotCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2019-01-12 Thread gerritbot
gerritbot added a comment.
Change 483942 merged by jenkins-bot:
[mediawiki/core@REL1_31] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/483942TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, gerritbotCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2019-01-12 Thread gerritbot
gerritbot added a comment.
Change 483943 had a related patch set uploaded (by Reedy; owner: Aaron Schulz):
[mediawiki/core@REL1_30] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/483943TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, gerritbotCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2019-01-12 Thread gerritbot
gerritbot added a comment.
Change 483942 had a related patch set uploaded (by Reedy; owner: Aaron Schulz):
[mediawiki/core@REL1_31] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/483942TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, gerritbotCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2019-01-11 Thread gerritbot
gerritbot added a comment.
Change 483859 had a related patch set uploaded (by Paladox; owner: Aaron Schulz):
[mediawiki/core@REL1_32] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/483859TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, gerritbotCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Vali.matei, Volans, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-13 Thread hoo
hoo added a comment.

In T204531#4813322, @hoo wrote:
I just revisited the original logs… and I found that the way way way more common error back then was from LoadBalancer::getRandomNonLagged:

2018-09-19 07:13:27 [1d74bb1b0e64917ec3cd47e7] snapshot1008 wikidatawiki 1.32.0-wmf.20 DBReplication ERROR: Wikimedia\Rdbms\LoadBalancer::getRandomNonLagged: server db1109 is not replicating? {"host":"db1109"}

I'll try to have a look at this soon.


I just had a brief look at this… and it's not easy to resolve this one AFAICT, given we don't ever want to completely ignore the fact that a DB is not replicating at all, I guess. We could use a HashBagOStuff in LoadBalancer to determine that we only log this errors once every N seconds (per DB server)?!TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, hooCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-11 Thread gerritbot
gerritbot added a comment.
Change 478773 merged by jenkins-bot:
[mediawiki/core@master] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/478773TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, gerritbotCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-11 Thread hoo
hoo added a comment.
I just revisited the original logs… and I found that the way way way more common error back then was from LoadBalancer::getRandomNonLagged:

2018-09-19 07:22:32 [c36272088a424bcc438a31e9] snapshot1008 wikidatawiki 1.32.0-wmf.20 DBReplication ERROR: Server db1109 has 37.027653932571 seconds of lag (>= 10) {"host":"db1109","lag":37.027653932571,"maxlag":10}

I'll try to have a look at this soon.TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: aaron, hooCc: Imarlier, gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, CucyNoiD, Nandana, NebulousIris, jijiki, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Lunewa, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Vali.matei, Lewizho99, Volans, Maathavan, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-10 Thread gerritbot
gerritbot added a comment.
Change 478773 had a related patch set uploaded (by Aaron Schulz; owner: Aaron Schulz):
[mediawiki/core@master] rdbms: reduce LoadBalancer replication log spam

https://gerrit.wikimedia.org/r/478773TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: gerritbot, aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Imarlier, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Vali.matei, Volans, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-07 Thread ArielGlenn
ArielGlenn added a comment.
Ah, I misread!  Before we arbitrarily throttle though, I'd like the dbas to weigh in. It might be that having the flood actually flood may be helpful sometimes.TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: ArielGlennCc: aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Volans, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-07 Thread hoo
hoo added a comment.
Anything that depends on a particular db server makes me uneasy

Hm… above I meant that for every DB server it should ever warn ever (like) LAG_WARN_THRESHOLD / 2 seconds… for all DB servers… it makes little sense to let a single LoadMonitor instance create more log entries per DB.TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hooCc: aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Volans, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-07 Thread ArielGlenn
ArielGlenn added a comment.
Of the above options, I prefer the idea of explicitly increasing the LAG_WARN_THRESHOLD in scripts where that's desired. Anything that depends on a particular db server makes me uneasy, and I don't like the idea of turning off load monitoring completely either.TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: ArielGlennCc: aaron, Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Volans, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-07 Thread hoo
hoo added a comment.
Or we could alter LoadMonitor::getServerStates to not log for a certain db-server more than every N seconds (where N could be derived from LAG_WARN_THRESHOLD, which currently is 10s).TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hooCc: Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Volans, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-12-07 Thread hoo
hoo added a comment.
I just looked into this some more… We could also create a new LB settings key which would be passed as lagWarnThreshold to LoadMonitor (currently this options is never set, as their is no way to do so, thus this always defaults to LoadMonitor::LAG_WARN_THRESHOLD (10s)).

With that, we could enable certain dump-related maintenance scripts to set it to a reasonable value for their operation… for the Wikidata dumpers, 10-20m of lag should pose no problem.
Something else which (I think) we could already do without altering LoadBalancer related code (but just live-changing DB configuration in Maintenance) is to entirely disabling the load monitoring (use LoadMonitorNull), but I'm not sure that is desirable.

Any thoughts?TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hooCc: Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Volans, _jensen, D3r1ck01, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-11-06 Thread hoo
hoo added a comment.
Just for the record, the errors were:
2018-09-19 07:13:15 [580058d7b2babd5f85e725ec] snapshot1008 wikidatawiki 1.32.0-wmf.20 DBReplication ERROR: Server db1109 has 29.26508808136 seconds of lag (>= 10) {"host":"db1109","lag":29.26508808136,"maxlag":10} 

Was there anything else?

To fix this, the following MediaWiki LB default config could be made adjustable (to use a null logger) by a maintenance-script argument (or by a config we would set for dump maintenance scripts):
MWLBFactory::applyDefaultConfig: 'replLogger' => LoggerFactory::getInstance( 'DBReplication' )TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hooCc: Joe, akosiaris, hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Nandana, jijiki, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, Volans, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-09-18 Thread ArielGlenn
ArielGlenn added a comment.
Well, the mystery of 'why eqiad' is solved; the choice of whether to parse db-eqiad.php or db-codfw.php is determined by the global $wmfDatacenter. This is set in multiversion/MWRealm.php from the value of $wmfCluster, which is taken from the contents of /etc/wikimedia-cluster on the server itself. Since the dumps are run from servers in eqiad, there we have it.TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: ArielGlennCc: hoo, Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-09-18 Thread ArielGlenn
ArielGlenn added a comment.
root@snapshot1008:~# netstat -a -p | grep php | grep eqiad | grep db
tcp0  0 snapshot1008.eqia:41898 db1087.eqiad.wmne:mysql ESTABLISHED 105786/php7.0   
tcp0  0 snapshot1008.eqia:42528 db1087.eqiad.wmne:mysql ESTABLISHED 107804/php7.0   
tcp0  0 snapshot1008.eqia:39826 db1087.eqiad.wmne:mysql ESTABLISHED 120869/php7.0   
tcp0  0 snapshot1008.eqia:36730 db1087.eqiad.wmne:mysql ESTABLISHED 118688/php7.0   
tcp0  0 snapshot1008.eqia:39936 db1087.eqiad.wmne:mysql ESTABLISHED 104820/php7.0   
tcp0  0 snapshot1008.eqia:35566 db1087.eqiad.wmne:mysql ESTABLISHED 118107/php7.0   
tcp0  0 snapshot1008.eqia:36468 db1087.eqiad.wmne:mysql ESTABLISHED 118553/php7.0   
tcp0  0 snapshot1008.eqia:35032 db1087.eqiad.wmne:mysql ESTABLISHED 117876/php7.0   

root@snapshot1008:~# ps ww -p 105786 107804 120869 118688 104820 118107 118553 117876
   PID TTY  STAT   TIME COMMAND
104820 ?S 45:03 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 6 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 6-11 --first-page-id 3521 --last-page-id 3840
105786 ?S 41:08 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 4 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 4-11 --first-page-id 3521 --last-page-id 3840
107804 ?R 40:27 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 5 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 5-11 --first-page-id 3521 --last-page-id 3840
117876 ?S 16:24 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 7 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 7-11 --first-page-id 3521 --last-page-id 3840
118107 ?R 15:45 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 3 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 3-11 --first-page-id 3521 --last-page-id 3840
118553 ?R 14:28 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 1 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 1-11 --first-page-id 3521 --last-page-id 3840
118688 ?S 13:59 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 2 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 2-11 --first-page-id 3521 --last-page-id 3840
120869 ?S 12:03 /usr/bin/php7.0 /srv/mediawiki/multiversion/MWScript.php extensions/Wikibase/repo/maintenance/dumpRdf.php --wiki wikidatawiki --shard 0 --sharding-factor 8 --batch-size 2000 --format ttl --flavor full-dump --entity-type item --entity-type property --no-cache --dbgroupdefault dump --part-id 0-11 --first-page-id 3521 --last-page-id 3840

So they are indeed using eqiad. Why is that?TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: ArielGlennCc: Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T204531: Wikidata dumps creating large amounts of log spam

2018-09-17 Thread ArielGlenn
ArielGlenn added a comment.
The wikidata weeklies are running now; the 'regular' (xml/sql) dumps completed on Sept 15th for the first run of the month.TASK DETAILhttps://phabricator.wikimedia.org/T204531EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: ArielGlennCc: Agabi10, Marostegui, ArielGlenn, Krinkle, fgiunchedi, jcrespo, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, MGChecker, gnosygnu, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Krenair___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs