Marostegui added a comment.
I depooled today db1111 (https://phabricator.wikimedia.org/P14229) which is not on the vslow,dump group and I still see two things: - The host is being accessed by `wikiadmin` from `snapshot1006`: - The host keeps being accessed even though it's been depooled for more than 1 hour: root@cumin1001:/home/marostegui# mysql.py -hdb1111 -e "show processlist" | grep wikiadmin 2017398773 wikiadmin 10.64.32.149:60598 wikidatawiki Sleep 803 NULL 0.000 2018035580 wikiadmin 10.64.32.149:60960 wikidatawiki Sleep 2 NULL 0.000 2018117400 wikiadmin 10.64.32.149:32822 wikidatawiki Sleep 19 NULL 0.000 2018253068 wikiadmin 10.64.32.149:33008 wikidatawiki Sleep 1 NULL 0.000 2018279747 wikiadmin 10.64.32.149:33028 wikidatawiki Sleep 403 NULL 0.000 2018352112 wikiadmin 10.64.32.149:33082 wikidatawiki Sleep 9 NULL 0.000 2018442606 wikiadmin 10.64.32.149:33152 wikidatawiki Sleep 318 NULL 0.000 2019017411 wikiadmin 10.64.32.149:33300 wikidatawiki Sleep 767 NULL 0.000 root@cumin1001:/home/marostegui# host 10.64.32.149 149.32.64.10.in-addr.arpa domain name pointer snapshot1006.eqiad.wmnet. root@snapshot1006:~# host db1111 db1111.eqiad.wmnet has address 10.64.0.128 root@snapshot1006:~# netstat -putan | grep "10.64.0.128" tcp 0 0 10.64.32.149:60598 10.64.0.128:3306 ESTABLISHED 25933/php7.2 tcp 0 0 10.64.32.149:33300 10.64.0.128:3306 ESTABLISHED 25711/php7.2 tcp 0 0 10.64.32.149:33028 10.64.0.128:3306 ESTABLISHED 25704/php7.2 tcp 0 0 10.64.32.149:60960 10.64.0.128:3306 ESTABLISHED 29537/php7.2 tcp 0 0 10.64.32.149:33152 10.64.0.128:3306 ESTABLISHED 30709/php7.2 tcp 0 0 10.64.32.149:33082 10.64.0.128:3306 ESTABLISHED 30461/php7.2 tcp 0 0 10.64.32.149:33008 10.64.0.128:3306 ESTABLISHED 30226/php7.2 tcp 0 0 10.64.32.149:32822 10.64.0.128:3306 ESTABLISHED 29707/php7.2 root@snapshot1006:~# ps aux | grep 25933 dumpsgen 25933 0.0 0.0 457784 63076 ? S 06:38 0:03 /usr/bin/php7.2 /srv/mediawiki/php-1.36.0-wmf.27/../multiversion/MWScript.php fetchText.php --wiki wikidatawiki root@snapshot1006:~# ps aux | grep 30709 dumpsgen 30709 0.0 0.1 461880 66992 ? S 06:58 0:02 /usr/bin/php7.2 /srv/mediawiki/php-1.36.0-wmf.27/../multiversion/MWScript.php fetchText.php --wiki wikidatawiki TASK DETAIL https://phabricator.wikimedia.org/T138208 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Marostegui, Addshore, Lydia_Pintscher, daniel, hoo, ArielGlenn, jcrespo, Zppix, jannee_e, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, Lunewa, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, gnosygnu, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
