[01:08:38] Anyone know how to convert base36 to base16 in MySQL? [01:14:54] conv(input, 36, 16) ? [01:20:57] Unfortunately, rev_sha1 too long for that it becomes FFFFFFFFFFFFFFFF. Base36 doesn't seem like it can be evenly divisible 8 (3*3*2*2=36). And don't have a GRANT for creating a FUNCTION. I guess file a task? [02:17:08] (03PS1) 10Zhuyifei1999: crontab: Remove -u parameter, and make uid < 500 always edit local [labs/toollabs] - 10https://gerrit.wikimedia.org/r/405830 (https://phabricator.wikimedia.org/T179386) [02:18:04] (03PS2) 10Zhuyifei1999: crontab: Remove -u parameter, and make uid < 500 always edit local [labs/toollabs] - 10https://gerrit.wikimedia.org/r/405830 (https://phabricator.wikimedia.org/T179386) [05:39:09] (03CR) 10BryanDavis: crontab: Remove -u parameter, and make uid < 500 always edit local (031 comment) [labs/toollabs] - 10https://gerrit.wikimedia.org/r/405830 (https://phabricator.wikimedia.org/T179386) (owner: 10Zhuyifei1999) [10:31:27] Hello [10:33:02] It's been a long time since I was blocked on enwiki. I am changed now completely please unblock. [10:33:38] i made many useful edits on Urdu Wikipedia and en.wiktionary [10:34:11] and on Commons too. [10:37:48] !help [10:37:48] BukhariSaeed_: 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 [10:39:31] help! [10:39:34] It's been a long time since I was blocked en.wiki. I am changed now completely please unblock me. [10:40:22] BukhariSaeed__ : This is the -cloud chat. [10:40:50] I made numerous constructive edits on en.wiktionary and urwiki and commons [10:41:10] If you're looking to be unblocked, go to #wikipedia-en-unblock [10:41:21] https://en.m.wiktionary.org/wiki/User:BukhariSaeed [10:41:38] ok [11:19:19] hello [11:19:40] Hello [11:20:15] thanks so much for replying [11:20:48] No problem [11:20:53] It's been a long time since I was blocked on en.wiki. I am changed now completely please unblock me. [11:21:38] i made many constructive edits on en.wiktionary, urdu wikipedia and commons [11:21:42] Didn't you ask this here a few minutes ago? [11:22:03] This channel is for Cloud Services things [11:22:15] We have no power to unblock you [11:22:40] yes i understand [11:22:58] but... any other source of help? [11:23:12] any link or forum [11:24:17] this is my user name [11:24:19] https://ur.m.wikipedia.org/wiki/صارف:BukhariSaeed [11:26:09] Per Adotchar please try in #wikipedia-en-unblock [11:27:03] i have tried but no one is responsing ok per you i'll try once again [13:25:06] !help Hi all! I've mini trouble with my bot that is running on bastion. Now it's doing a replacement (replace.py), using -regex but... it is parsing pages (where some matches and some not) in continuous stuck... I cannot understand why cause the regex is almons simple and sometimes it parses pages very quickly, sometimes it stops for seconds and seconds [13:25:06] avgas: 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 [13:26:32] avgas: what is the bot? [13:26:35] *almost [13:26:38] chicocvenancio: IrishBot [13:27:01] Give me a minute [13:34:54] chicocvenancio: np, for eg now its on stuck for at least 2 minutes... [13:56:05] if I restart script, anything change [14:17:17] !log tools add me, arturo, chico to sudoers and removed marc [14:17:21] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [14:19:46] chicocvenancio: ? [14:20:48] avgas: sorry for the delay [14:24:10] avgas: I'm having trouble myself connecting, what is the command you're running? [14:26:29] chicocvenancio: np, now python pwb.py replace.py [14:33:44] (03CR) 10Zhuyifei1999: crontab: Remove -u parameter, and make uid < 500 always edit local (031 comment) [labs/toollabs] - 10https://gerrit.wikimedia.org/r/405830 (https://phabricator.wikimedia.org/T179386) (owner: 10Zhuyifei1999) [14:37:27] avgas: did you perform an strace and see if the 'being stuck' is in the middle of a system call? [14:39:05] really I don't know how to do that [14:39:11] zhuyifei1999_ [14:40:16] avgas: strace python ... [14:43:03] zhuyifei1999_: ok, also in this mode there's stuck moment [14:43:14] what's the last line? [14:43:25] when it is stuck [14:44:00] for eg: write(2, "No changes were necessary in [[S"..., 50No changes were necessary in [[Salvatore Antibo]]) = 50 [14:49:17] avgas: that line is writing to the output and should complete instantly [14:49:49] avgas: is it still running now? [14:49:54] if that line stays 'the last line' for a few seconds then something is really going wrong is user mode [14:50:13] how are you connecting to bastion? [14:50:17] (for example, very long loops) [14:50:57] zhuyifei1999_: right: should be. [14:51:38] chicocvenancio: yeah, its still running but it has continuous "slowdown" [14:54:06] chicocvenancio: via bash, ssh [14:55:14] and in bash it still running in "screen" so if i detach from, nothing changes (cause I see stuck in wiki RC) [14:55:20] *from it [14:56:27] I never used pdb, but the line by line traceing in pdb should be able to help with 'stuck in user mode' [14:57:03] zhuyifei1999_: he'd have to edit the pwb script for that [14:57:41] might be necessary, but I am not sure the problem is there [14:58:15] I wouldn't know why it would otherwise stuck after writing to stderr [14:59:29] changing server might be the solution? [14:59:32] paladox: 218543a121f93c28e64c88ce6646be82a3f9a9c8 is yours it seems like [14:59:41] that seems to have broken shinken-01 potentially [14:59:45] which is still Trusty [14:59:48] avgas: oh, after you get the bot fixed. please run it bot the grid not on bastion (whether screen or not) if you are not interacting with it [14:59:54] chasemp oh. [15:00:02] alex asked me to remove init.d script [15:00:15] https://wikitech.wikimedia.org/wiki/Help:Toolforge/Grid [15:02:45] though the load on bastion-03 & 02 is not high so I don't expect the server itself is causing the slowdown [15:03:59] mumble, ok [15:06:04] also changing regex (one more easier), nothing changes: stucks are present [15:10:08] I've to quit, maybe reconnect later [15:10:23] thanks zhuyifei1999_ and chicocvenancio, see you later [15:11:13] zhuyifei1999_: Grid is for toolforge, isn't it? [15:11:23] it is [15:11:54] I'm pretty sure he was not connected to toolforge bastion, but to cloud VPS [15:12:02] huh [15:12:21] I didn't know one can run bots on cloud VPS bastion [15:12:51] I don't think you should [15:14:10] indeed I see that process on bastion.wmflabs.org [15:14:22] pid 9353 [15:17:03] it's using 83% of CPU, and the host only has one core [15:17:16] yes, I was trying to login to that, but got into problems [15:17:29] zhuyifei1999_: do you have the power to kill it? [15:17:51] no. I don't have root [15:18:24] chasemp: can you kill PID 9353 on bastion.wmflabs.org? [15:18:34] I will let you know when I see avgas and I will deliver that message to them [15:18:34] @notify avgas Please run your bot on toolforge, preferably on the toolforge grid engine, instead of bastion.wmflabs.org [15:18:39] chicocvenancio: sure but so could you :) [15:19:20] chasemp: it's refusing my keys [15:19:26] huh [15:19:38] not tools-bastion [15:19:45] bastion.wmflabs.org [15:19:52] Cloud VPS bastion [15:20:07] ah [15:21:14] chicocvenancio: done [15:21:25] fwiw yeah that's not a cool place to run this [15:21:27] avgas 9353 9064 75 15:09 pts/1 00:08:31 python pwb.py replace.py -regex \{\{\s*Sportivo([^}{]+?(?:\{\{[^}]+\}\}[^}{]+?(?:\{\{[^}]+\}\}[^}{]+?(?:\{\{[^}]+\}\}[^}{]+?)?)?)?)\|\s*NomeCompleto\s*=\s*(\S+ ?\S* ?\S*) (\S+ ?\S* [15:21:27] ?\S*)\s*((?:\{\{|\[\[|\|).*?)\{\{\s*Bio([^}{]+?(?:\{\{[^}]+\}\}[^}{]+?(?:\{\{[^}]+\}\}[^}{]+?(?:\{\{[^}]+\}\}[^}{]+?)?)?)?\|\s*Nome\s*=\s*\2\s*\|\s*Cognome\s*=\s*\3\s*(?:\{\{|\[\[|\|)) {{Sportivo\1\4{{Bio\5 -ref:Template:Sportivo -dotall -nocase -always -ns:0 -pt:7 -summary:Elimino |NomeCompleto= da {{Sportivo}} come da discussione [15:21:31] gah, long [15:21:32] sorry [15:21:57] hence the request to login and checkout what was going on, I suspected this, but didn't want to state it without being sure [15:22:04] * chasemp nods [15:36:04] (03PS1) 10Hashar: Jenkins job validation (DO NOT SUBMIT) [labs/tools/ZppixBot] - 10https://gerrit.wikimedia.org/r/405889 [15:36:07] (03PS1) 10Hashar: Jenkins test (DO NOT SUBMIT) [labs/tools/ZppixBot] - 10https://gerrit.wikimedia.org/r/405890 [15:48:45] !log tools Admin clean up; removed Coren, Ryan Lane, and Springle. [15:48:51] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [15:59:10] (03CR) 10Hashar: "recheck" [labs/tools/ZppixBot] - 10https://gerrit.wikimedia.org/r/405890 (owner: 10Hashar) [16:01:06] (03CR) 10Hashar: "recheck" [labs/tools/ZppixBot] - 10https://gerrit.wikimedia.org/r/405889 (owner: 10Hashar) [16:46:22] (03CR) 10BryanDavis: [C: 031] "Needs a quick bit of live testing (patch locally, scp oge-crontab to a bastion, make sure root and a tool can use it)." [labs/toollabs] - 10https://gerrit.wikimedia.org/r/405830 (https://phabricator.wikimedia.org/T179386) (owner: 10Zhuyifei1999) [17:40:05] zhuyifei1999_: tnx for memo, now I try on toolforge [17:43:11] k [17:58:52] zhuyifei1999_: just for info, can I copy folder that I already have on primary.bastion to tools-bastion-03? [18:10:57] The safest way for you to do that is make a tarball (or any other archive, download to your own computer, upload to toolforge and extract [18:11:42] the easiest way is to use agent forwarding then scp, but there is a risk of agent compromise [18:14:00] uhm ok [18:14:22] now I'm trying to run bot on toolforge.. [18:14:23] avgas: is it big? [18:17:31] avgas: negative, I can get what I need via git, really np [18:17:43] *chicocvenancio [18:17:47] great [18:17:56] Now I trying to understand how to run on toolserver [18:18:01] I need to create tool? [18:18:32] I think you already have access to toolserver right? [18:20:12] chicocvenancio: I don't remember this.. :( [18:21:36] surely I was on toolserver many years ago [18:21:45] avgas: I don't see a tool group in your user, I'm not sure if it is possible to send a job to grid without a tool account but I'm pretty sure you should'nt [18:22:09] can you logon to login.tools.wmflabs.org? [18:22:28] then I leaved wiki project for years until I returned, many months ago [18:22:31] chicocvenancio: yes! [18:22:38] I can login [18:23:36] If i use tools.wmflabs.org, access to tools-bastion-03 [18:24:37] avgas: please create a tool account at http://toolsadmin.wikimedia.org/ [18:25:02] afterwards in the ssh bastion you can run $ become [18:25:18] yes zhuyifei1999_ is correct [18:26:32] zhuyifei1999_: LDAP account password is equal to...? (I've forgot it) [18:26:40] wikitech one [18:27:33] avgas: your ldap user is .avgas btw [18:28:37] (which is not a given from you SUL account, though the same in this case) [18:34:26] chicocvenancio: yeah, created irishbot tool and becomed it, now i'll download pywikibot and try to run... let me see if works properly [18:35:03] great [18:39:31] avgas: no need to download it [18:39:33] https://wikitech.wikimedia.org/wiki/Help:Toolforge/Developing#Pywikibot [18:39:44] there is a shared install of it [18:40:18] whoah, super [19:21:44] chicocvenancio: I've set .bash_profile, but... I've to use "python python /data/project/shared/pywikipedia/core/scripts/replace.py" everytime I want to use replace.py? O.o [19:23:30] yes, but you can create a symbolic link and simplify it to "python scripts/replace.py" [19:24:29] its more geared towards long running tasks and low maintenance [19:28:32] avgas: if you do not plan to run it interactively please run it on grid. if you plan to make it run periodically you can put the script into your crontab [19:32:32] zhuyifei1999_: yeah already use crontab on bastion with gnubotmarcoo [19:33:15] you mean bastion.wmflabs.org? that host is not for you to run any bots [19:33:25] please remove it [19:33:38] urgh, ok [19:34:18] btw, we killed the bot process that was running on that host [19:34:31] yeah I see [19:34:57] zhuyifei1999_: ok, I've lauched replace.py with same regex... no way, it is still running with stucks [19:34:59] :( [19:35:23] on bastion-03? [19:35:35] yes [19:36:06] avgas: how did you run it? [19:39:10] with: "python /data/project/shared/pywikipedia/core/scripts/replace.py -regex ..." [19:39:55] I don't see that running in tools-bastion [19:40:00] on tools.irishbot@tools-bastion-03: [19:40:14] chicocvenancio: ok, recheck [19:40:38] it is now [19:40:43] CPU 100% [19:40:56] and in user mode [19:41:00] yes, grid is necessary [19:41:06] !log tools Add bstorm to project admins [19:41:06] incredible [19:41:11] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [19:42:07] I've used the same regex for other task and all gone ok [19:42:24] so what's different about this task? [19:43:22] nearly some, infact in old one there was no " ?\S* ?\S*" in the middle [19:43:50] so now i know that \S* can be huge problem, incredible [19:44:23] huh you know how a broken regex once crashed the entire ORES? [19:44:58] https://phabricator.wikimedia.org/phame/post/view/64/laughing_ores_to_death_with_regular_expressions_and_fake_threads/ [19:45:12] also try changing metacharacter, [\"\'\(\w\)] will be more or less the same for that task [19:46:16] whoah [19:48:10] zhuyifei1999_: ok, last problem: when I using my old name Gnumarcoo, I created a tool called gnubotmarcoo for my bot GnuBotmarcoo. Now it is no longer possible for me manage that tool as Gnumarcoo (which is the actually maintainer), any admin can delete it or change the maintainer in .avgas? [19:50:22] probably file a bug describing your issue? we might need proof that you're the same as Gnumarcoo [19:52:20] that would be the main problem, indeed [19:55:02] I vote for a task avgas to keep a narrative of changes made to resolve and reasoning [19:56:59] I don't see why you couldn't log in as the old user [19:57:10] presumably you still have the ssh key used? [19:58:24] https://meta.wikimedia.org/w/index.php?title=Steward_requests/Username_changes&diff=prev&oldid=9882703 [20:00:57] the SUL username shanges do not affect LDAP [20:01:01] I've no longer access to email recovery access [20:01:03] avgas: a task with that, and maybe the move log at https://meta.wikimedia.org/w/index.php?title=User:Gnumarcoo&oldid=9883091 should suffice, but the SUL account rename should not affect the LDAP [20:01:13] you should be able to log into wikitech with old password [20:01:23] and into the machines with the used ssh key [20:01:33] that is, the old *wikitech* password [20:01:44] I don't remember it, I've used it about 4 years ago... [20:01:59] oh, wait [20:02:09] we are talking about a 4 years old rename [20:06:25] Platonides: uhm.. yes! [20:06:48] the point is: I can't access to email recovery of gnumarcoo on wikitech, so I can't access [20:08:25] avgas: I get your situation. Create a task in phabricator and we might be able to add .avgas as a maintainer [20:08:53] chicocvenancio: many thanks [20:20:09] https://phabricator.wikimedia.org/T185601 [20:45:55] andrewbogott, madhuvishy: can you restart wikistream? I'm getting 502 [20:46:14] Sagan: is that a tool? [20:46:31] madhuvishy: it's a project: https://tools.wmflabs.org/openstack-browser/project/wikistream [20:46:48] (with only one instance) [20:46:56] it looks like it failed to start up after the host reboots [20:47:01] would be nice if you can take a look [20:47:28] Sagan: ah, are you saying the instance isn't up? [20:47:56] madhuvishy: I guess the instance is up, but the service running on it providing http://wikistream.wmflabs.org/ seems not to run [20:49:12] Sagan: I'm willing to take a quick look but the most realistic thing is to ping the maintainer https://wikitech.wikimedia.org/wiki/User:Edsu [20:49:29] chasemp: ok, thx. [20:50:14] chasemp: the wikistream service is running at least [20:50:17] chasemp: according to the readme on github, the command to start it is sudo start wikistream [20:52:44] madhuvishy: yeah seems like varnish and wikistream but restarting both has no effect [20:52:59] !log wikistream restart varnish adn wikistream for 502 but no effect [20:53:01] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikistream/SAL [20:53:38] Sagan: I would reach out to https://wikitech.wikimedia.org/wiki/User:Edsu as the primary if you believe it's meant to be up [20:53:54] chasemp: ok :). thx for trying [20:54:52] madhuvishy: it's weird I don't see errors for either service but I drudged their bash_history and didn't come up with anything useful [20:56:09] chasemp: according to the sal, andrewbogott deleted something of the syslog some days ago [22:00:38] when I becomed and try to screen, bash return: "Cannot open your terminal '/dev/pts/15' - please check." [22:01:29] what does it means? [22:06:15] avgas: https://wikitech.wikimedia.org/wiki/Screen#Troubleshooting [22:08:40] You can run "script /dev/null" or run screen first and then become from inside screen. [23:57:50] (03PS1) 10Dzahn: add fake keys for wmcspuppetmaster to allow compiling [labs/private] - 10https://gerrit.wikimedia.org/r/406001 [23:59:19] (03PS2) 10Dzahn: add fake keys for wmcspuppetmaster to allow compiling [labs/private] - 10https://gerrit.wikimedia.org/r/406001 [23:59:34] (03CR) 10Dzahn: [V: 032 C: 032] add fake keys for wmcspuppetmaster to allow compiling [labs/private] - 10https://gerrit.wikimedia.org/r/406001 (owner: 10Dzahn)