[04:47:12] musikanimal: For the sql optimizer - it seems like integrating something like https://mariadb.org/explain_analyzer/analyze/ into it would be ideal, except I can't find the source code for that tool or even if its open source (And it seems to sort of not work anymore) [04:48:10] it's probably using an actual `EXPLAIN [query]`, which we can't do [04:50:01] I mean more, that it provides help popups explaining what everything in the explain means [04:50:45] Which is kind of cool [04:51:01] except the popups seem broken, so I'm not sure how indepth it goes [04:51:23] I'm kind of imagining in the back of my mind it explains everything in plain english, but it probably just gives links to documentation [04:58:59] hmm, mariadb doesn't even support show extended explain. That's kind of sad [17:44:49] !help Hi, why git clone works so much slow at tools-bastion-03 [17:44:49] Zoranzoki21: If you don't get a response in 15-30 minutes, please create a phabricator task -- https://phabricator.wikimedia.org/maniphest/task/edit/form/1/?projects=wmcs-team [17:45:23] Receiving objects: 1% (7948/749913), 3.05 MiB | 353.00 KiB/s [17:45:31] I trying to clone mediawiki/core from gerrit [17:46:27] where are you cloning to? [17:46:44] zhuyifei1999_: tools.zoranzoki21bot@tools-bastion-03:~/public_html [17:47:13] well, that's on NFS [17:47:58] you can clone to /tmp first then move it over from /tmp [17:47:58] zhuyifei1999_: What I should do? I working something wrong? [17:48:06] or better, use https://wikitech.wikimedia.org/wiki/Help:Shared_storage#/data/project/shared/mediawiki [17:48:44] zhuyifei1999_: How I can copy it for using by me? [17:49:08] what do you mean by 'using by me'? [17:50:10] zhuyifei1999_: https://wikitech.wikimedia.org/wiki/Help:Toolforge#Installing_Mediawiki_core [17:51:38] And when I want to clone repository via git clone [17:51:53] * zhuyifei1999_ should update this doc [17:52:02] it works very slow [17:52:10] ~350 KiB/s [17:52:12] the mirror has been there since forever [17:53:57] Should I cp /data/project/shared/mediawiki [17:54:43] the core is /data/project/shared/mediawiki/core [17:54:45] so yeah [17:56:19] Zoranzoki21: it doesn't seem to be a problem with toolforge, I get the same (or worse) speed while cloning from other locations [17:57:37] On my VPS at hetzner it downloads with speed ~100 MiB/s [18:00:54] use /tmp then. I get 14.04 MiB/s there [18:01:18] (at home I get 5.54 MiB/s) [18:05:44] zhuyifei1999_: same, but I need it in public_html of my tool [18:07:58] tools.zoranzoki21bot@tools-bastion-03:/var/www/html$ cp -R /data/project/shared/mediawiki/core* * [18:08:10] And I get this: cp: cannot overwrite non-directory ‘index.html’ with directory ‘/data/project/shared/mediawiki/core’ [18:08:43] cp -rf [18:09:09] cp: cannot overwrite non-directory ‘index.html’ with directory ‘/data/project/shared/mediawiki/core’ [18:10:27] Zoranzoki21: just confirming, you get 100MiB/s from gerrit on hetzner? or from hetzner in general? [18:10:54] gtirloni: yes [18:13:59] i get 7 MiB/s [18:16:57] interesting [18:17:33] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ cp -Rf /data/project/shared/mediawiki/core/* /data/project/zoranzoki21bot/public_html/ [18:17:41] Copying is much slow [18:21:47] !help Why I get this error: https://tools.wmflabs.org/zoranzoki21bot/ [18:21:47] Zoranzoki21: If you don't get a response in 15-30 minutes, please create a phabricator task -- https://phabricator.wikimedia.org/maniphest/task/edit/form/1/?projects=wmcs-team [18:22:25] you are using PHP 5.5.9-1ubuntu4.26. [18:22:26] because it requires php 7.0 [18:23:11] We need 7.0 there? [18:23:16] ofc [18:23:47] Can you upgrade it on 7.0 [18:24:01] I doin't think so? [18:24:09] since tools uses ubuntu trusty [18:24:37] webservice --backend=kubernetes php7.2 start [18:25:10] Looks like you already have another webservice running, with a gridengine backend [18:25:10] You should stop that webservice by issuing: [18:25:10] webservice --backend=gridengine stop [18:25:10] And then start it again with backend kubernetes by issuing: [18:25:11] webservice --backend=kubernetes start [18:25:35] yeah , please stop then start with param [18:25:36] do that then ^ [18:26:07] https://wikitech.wikimedia.org/wiki/Help:Toolforge/Web#Default_web_server_(lighttpd_+_PHP) [18:26:58] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ webservice --backend=gridengine stop [18:26:58] Stopping webservice.......... [18:26:58] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ webservice --backend=kubernetes start [18:26:58] Starting webservice.... [18:26:58] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ webservice --backend=kubernetes php7.2 start [18:26:59] Your job is already running [18:27:01] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ [18:28:33] Resolved with restarting of php7.2 [18:28:53] :) [18:30:37] Please note: pls don't create a public wiki in toolforge per ToS [18:31:30] rxy: no public [18:31:34] rxy: for testing purposes [18:31:41] :) [18:33:03] I have problems with composer [18:33:17] yeah, you should have composer [18:33:37] https://getcomposer.org/download/ [18:33:57] rxy: I have it already, but see https://pastebin.com/rsGZabUk [18:34:30] oh,, [18:34:34] just wait.. [18:34:55] use the k8s shell [18:35:15] what? [18:35:24] https://wikitech.wikimedia.org/wiki/Help:Toolforge/Web#Default_web_server_(lighttpd_+_PHP) [18:35:53] k8s = kubernetes [18:36:45] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ webservice --backend=gridengine lighttpd start [18:36:45] Looks like you already have another webservice running, with a kubernetes backend [18:36:45] You should stop that webservice by issuing: [18:36:45] webservice --backend=kubernetes stop [18:36:45] And then start it again with backend gridengine by issuing: [18:36:47] webservice --backend=gridengine start [18:36:49] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ [18:37:18] can you exec ` kubectl get pods ` ? [18:38:20] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ kubectl get pods [18:38:20] NAME READY STATUS RESTARTS AGE [18:38:20] zoranzoki21bot-3042610729-ezqu7 1/1 Running 0 10m [18:38:20] tools.zoranzoki21bot@tools-bastion-03:~/public_html$ [18:38:37] ` kubectl exec -it zoranzoki21bot-3042610729-ezqu7 -- /bin/bash ` [18:38:47] for k8s shell :) [18:39:27] rxy: tnx [18:40:10] https://wikitech.wikimedia.org/wiki/Help:Toolforge/Kubernetes and https://kubernetes.io/docs/tutorials/kubernetes-basics/ is useful :) [18:40:16] *are [18:40:17] (it's actually `webservice shell`) [18:41:22] (for the built-here method) [18:41:52] oh WMCS specific method! [18:42:22] (I didn't know about of WMCS specific method heh) [18:45:21] :) [18:47:47] Everything works [18:47:53] great [19:10:11] Hi, how I can use wget? [19:10:24] wget [19:10:38] on tools-bastion-03 no work [19:11:01] ah, you've perhaps a proxy to set [19:11:31] tools.zoranzoki21bot@interactive:~$ wget zorandori.tk/LocalSettings.php [19:11:31] bash: wget: command not found [19:11:31] tools.zoranzoki21bot@interactive:~$ [19:11:43] and curl? [19:12:32] curl works [19:13:16] Dereckson: See this https://tools.wmflabs.org/zoranzoki21bot/ [19:13:47] Sorry for the proxy hint, I had the production config in mind: https://github.com/wikimedia/puppet/commit/66a9e68c7e1cae40d02071a0f9de48568d4e53d3 [19:18:30] Why I can`t download files via curl? [19:19:06] with curl -O URL [19:22:35] ok, resolved [19:24:12] Zoranzoki21: you are on k8s shell [19:24:21] k8s shell don't have all the commands installed [19:24:52] you can exit the k8s shell to do 'normal' non-php stuffd [19:24:54] *stiffs [19:24:59] zhuyifei1999_: Ok, thanks! I resolved all [21:48:34] !log [21:48:34] rxy: Message missing. Nothing logged. [21:49:06] !log tools.stewardbots apply patch for T209246 [21:49:08] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.stewardbots/SAL