[01:05:22] 10Analytics: Long query running on dbstore1005:3318 - https://phabricator.wikimedia.org/T243871 (10Marostegui) [06:33:35] 10Analytics: Long query running on dbstore1005:3318 - https://phabricator.wikimedia.org/T243871 (10elukey) This is probably ` analyti+ 145527 98.8 4.3 3283004 2843800 ? R 03:00 204:04 /usr/bin/php /srv/analytics-wmde/graphite/src/scripts/src/betafeatures/counts.php ` @Ladsgroup @Addshore can you check... [11:14:31] 10Analytics: Long query running on dbstore1005:3318 - https://phabricator.wikimedia.org/T243871 (10Addshore) `/srv/analytics-wmde/graphite/src/scripts/src/betafeatures/counts.php` should not be doing a query like this one in the description. It sounds more like one I have run at some point and for some reason d... [12:07:56] 10Analytics, 10Wikidata, 10Wikidata-Campsite: Long query running on dbstore1005:3318 - https://phabricator.wikimedia.org/T243871 (10Addshore) p:05Triage→03Normal It definitely doesn't come from the script mentioned, and I am definitely not running anything. It looks like we do have some issues with long... [12:10:46] 10Analytics, 10Wikidata, 10Wikidata-Campsite: Long query running on dbstore1005:3318 - https://phabricator.wikimedia.org/T243871 (10Addshore) Did: ` addshore@stat1007:~$ sudo -u analytics-wmde kill 188134 addshore@stat1007:~$ sudo -u analytics-wmde kill 145527 addshore@stat1007:~$ sudo -u analytics-wmde kil... [12:18:54] 10Analytics, 10Wikidata, 10Wikidata-Campsite: Add time limits to scripts executed on stat1007 as part of analytics/wmde/scripts - https://phabricator.wikimedia.org/T243894 (10Addshore) [12:19:24] 10Analytics, 10Wikidata, 10Wikidata-Campsite: Long query running on dbstore1005:3318 - https://phabricator.wikimedia.org/T243871 (10Addshore) Created T243894 to handle these long running php scripts [12:19:42] 10Analytics, 10Wikidata, 10Wikidata-Campsite: Add time limits to scripts executed on stat1007 as part of analytics/wmde/scripts - https://phabricator.wikimedia.org/T243894 (10Addshore) p:05Triage→03Low [13:58:17] 10Analytics, 10WMDE-Analytics-Engineering, 10Privacy, 10User-GoranSMilovanovic: Public data set review for T237728 - https://phabricator.wikimedia.org/T239393 (10GoranSMilovanovic) Hey, @Dydimusz and I would really like to proceed with his research project. Could anyone take a look at these data sets and... [15:03:10] 10Analytics, 10Wikidata, 10Wikidata-Campsite (Wikidata-Campsite-Iteration-∞): Add time limits to scripts executed on stat1007 as part of analytics/wmde/scripts - https://phabricator.wikimedia.org/T243894 (10Addshore) [15:54:47] 10Analytics, 10Product-Analytics: Reconfigure R to have Java support on stat and notebook machines - https://phabricator.wikimedia.org/T243914 (10mpopov) [20:20:56] 10Analytics, 10Wikidata, 10User-Ladsgroup, 10Wikidata-Campsite (Wikidata-Campsite-Iteration-∞): Run hadoop analysis on wb_terms migration for entities below 29 million to check state - https://phabricator.wikimedia.org/T243763 (10Ladsgroup) It seems that our term store is badly broken: ` MariaDB [wikidataw... [20:26:49] 10Analytics, 10Wikidata, 10User-Ladsgroup, 10Wikidata-Campsite (Wikidata-Campsite-Iteration-∞): Run hadoop analysis on wb_terms migration for entities below 29 million to check state - https://phabricator.wikimedia.org/T243763 (10Ladsgroup) ` MariaDB [wikidatawiki_p]> SELECT wbit_item_id as id, wby_nam... [21:55:34] 10Analytics, 10Product-Analytics: Reconfigure R to have Java support on stat and notebook machines - https://phabricator.wikimedia.org/T243914 (10elukey) ` elukey@stat1007:~$ sudo R CMD javareconf *** JAVA_HOME is not a valid path, ignoring Java interpreter : /usr/bin/java Java version : 1.8.0_232 Java hom... [23:27:43] 10Analytics: Request for Kerberos identity - https://phabricator.wikimedia.org/T243929 (10KartikMistry) [23:32:03] 10Analytics, 10Wikidata, 10Wikidata-Campsite: Long query running on dbstore1005:3318 - https://phabricator.wikimedia.org/T243871 (10Marostegui) Thanks - do you want me to kill the query? It is still running there.