[01:47:09] Coren, you there? [01:47:56] How about petan? [02:46:00] Hi Guys, Is there any place where I could SQL like query the Wikimedia Commons Metadata ? [02:50:53] you mean you want to access the commons database [02:50:54] ? [02:57:05] Yes [03:36:37] karthiksripal, "sql commons" will get you to the database. [03:36:43] Good night everyone. [03:37:02] Thank you! [04:06:22] * Hazard-SJ says hello and wonders if he can finally get to talk toeither Coren or petan [04:15:21] * Hazard-SJ sighs [04:15:24] I guess not? [05:23:00] Hazard-SJ: Why you always do that? [05:24:54] he can do that, by using a feature of this protocol called 'private messages' [05:25:54] Hazard-SJ: Coren's time is 01:25, and petan's time is 7:25. I guess they're still asleep [05:26:58] gry: and your time was 15:00 just now [05:27:23] i know [05:28:38] * zhuyifei1999 wonders whether gry have the wrong time. [05:29:33] it's a few minutes off but it shouldn't be more wrong than that [05:29:36] just not synced [05:30:00] 14:55 was probably a bit closer to what it should be [05:42:55] gry: I decided to just email labs-l [05:43:26] Sjawp [05:43:58] sorry, never mind [05:45:14] wtf, my continous job just died [08:34:59] hi [08:41:09] petan: Hazard-SJ was finding you again [08:41:20] yes finally he wrote a mail :D [08:42:06] @seen Hazard-SJ [08:42:06] zhuyifei1999: Last time I saw Hazard-SJ they were quitting the network with reason: Quit: Ping timeout: 1 second N/A at 7/7/2013 5:43:12 AM (02:58:54.2223160 ago) [09:52:56] !ping [09:52:57] pong [09:52:57] pong [09:58:35] * zhuyifei1999 wonders why everyone's so silent [09:59:09] * YuviPanda makes noise [10:00:23] * zhuyifei1999 wonders what kind of noise YuviPanda is making [10:00:34] * YuviPanda makes typing noises on his bad keyboard [10:01:48] * zhuyifei1999 don't know what to say to YuviPanda [10:01:56] * YuviPanda goes back to fixing his tool [10:30:41] petan: Why Hazard-Bot always fails to run task "mass creating similar categories"? [10:32:57] @notify petan [10:32:57] This user is now online in #huggle. I'll let you know when they show some activity (talk, etc.) [10:40:14] petan: ? [10:51:57] yes [10:52:20] how could I know that I don't run it [10:57:58] petan: you can look at the run history [10:59:35] zhuyifei1999: but you don't run it either... why do you want to know that? [11:01:14] petan: because one of my job that starts at 11:45 (UTC) does some "mass creating similar categories" [11:02:24] and the ones he does is taking too much space on the list on commons [11:03:35] so that's affecting my job [11:07:33] petan: name: comwcat [11:08:34] eh, I /can/ have a look when it ended and what was technical reason from side of SGE, but that won't really help you... [11:11:04] so what is name of his task? [11:11:39] Coren, ? [11:12:56] Cyberpower678 what you need? [11:13:11] petan: I don't know. Can you have a look at his crontab? [11:13:24] Finally one of you two anwer. :p [11:13:35] zhuyifei1999 I figured the name of bot, what time you want [11:13:45] zhuyifei1999 lot of them started during last day [11:14:23] petan, can you look into why rfx-tally was abrubtly terminated and never restrted? [11:14:36] zhuyifei1999 most of them exit with 0 so they don't technically fail [11:14:47] Cyberpower678 ok [11:14:58] Cyberpower678 98% it was OOM issue, but I will check [11:15:14] The process id of them should be in the log for this channel. [11:15:31] Cyberpower678 when you started it and under which user [11:15:42] petan: From Hazard-SJ: That's okay. I've checked, the task is still in it's crontab, but on the last run it only made Category:Images from the Geograph British Isles project needing categories in grid TL6154 (no errors seem to have been encountered). I'll wait and see what happens when the list is updated again. Hazard-SJ ✈ 21:32, 29 June 2013 (UTC) [11:15:59] 7/5/13 under cyberbot I believe [11:16:35] zhuyifei1999 ok but what you need to know from me? [11:17:22] petan: Why is it not working? [11:18:20] zhuyifei1999 you are asking wrong person, you need to speak with hazard. According to SGE the task ended with return code 0. I can't analyze source code of his task to find out what is wrong with that, this is what programmer is supposed to do [11:18:25] I don't even know how his bot works [11:18:45] neither which language it's written in [11:20:14] ok [11:21:01] Cyberpower678 it was ended with return code 0, such task is never restarted because it's considered finished [11:21:17] That can't be right. [11:21:31] It ended in the middle of processing an RfA. [11:21:32] petan: from Hazard: It's actually supposed to check every day, I'm not sure what the problem is. I've just manually submitted the job and it's running now. Hazard-SJ ✈ 23:29, 1 July 2013 (UTC) [11:21:38] Cyberpower678 I am talking about one from Thu Jul 4 22:26:27 2013 [11:21:49] Wrong onr. [11:22:19] Where is the irc log searcher? [11:22:25] zhuyifei1999 if you want me to tell you status of some precise job id, I need to know that id [11:22:38] or at least precise information that help me detect it [11:22:43] like time when it run [11:22:55] not just today or yesterday I need time with hours and seconds [11:23:01] GMT [11:23:09] petan, where's the IRC log searcher? [11:23:16] petan: name may be c-masscatcreate, I don't have the permission to read [11:23:16] !logsearch [11:23:25] !logsearch [11:23:28] not that [11:23:41] ???? [11:23:51] * Cyberpower678 is confused now. [11:24:01] Is wm-bot not working? [11:24:12] Cyberpower678: no [11:24:22] !logsearch log [11:24:27] ? [11:24:27] !searchlog is http://bots.wmflabs.org/~wm-bot/searchlog [11:24:28] This key already exist - remove it, if you want to change it [11:24:32] wth [11:24:44] !logsearch is http://bots.wmflabs.org/~wm-bot/searchlog [11:24:44] Key was added [11:24:48] here we go [11:24:57] !searchlog [11:24:57] http://bots.wmflabs.org/~wm-bot/searchlog [11:25:02] I need to go now [11:25:11] petan, wait one sec. [11:25:11] brb 2h [11:25:28] That's too long. [11:25:32] I'm on vacation. [11:25:37] petan: (again) name may be c-masscatcreate, I don't have the permission to read [11:25:41] so am I [11:25:53] Can you wait 5 minutes? [11:26:04] zhuyifei1999 ok that is name, but I need precise time [11:27:17] petan, 592266 [11:27:26] July 4 or 5. Is that possible? [11:27:28] zhuyifei1999 sorry, I really think this is something what bot creator should handle somehow... [11:27:48] That was the PID [11:27:55] zhuyifei1999 precise time like yesterday at 16:22:36 not just day [11:28:07] Cyberpower678 ok [11:28:26] That process abrubtly ended and never restarted. [11:31:21] Cyberpower678: http://pastebin.com/J76RJMUZ [11:31:29] it ended with return code 0 [11:31:46] it may ended not as you wanted but in that case it's wrapper is written badly [11:31:52] * its [11:32:02] you need to write the source code so that it return non 0 on error [11:32:17] There was no error. It just stopped. [11:32:26] also you should make it log information somewhere so that you can dig what happened [11:32:41] Nothing in the logs that I can see. [11:32:52] make the logs more descriptive then [11:33:11] It throws an error on even the slightest problems, but nothing was thrown. [11:33:29] petan: told hazard [11:33:37] I really need to go now... [11:33:39] Oh well. [11:33:44] maybe write an e-mail? [11:33:45] !mail [11:33:45] we have a mailing list labs-l@lists.wikimedia.org feel free to send a message there, don't forget to subscribe [11:33:46] Maybe a glitch [11:34:01] bye petan and thanks. [11:34:15] np [11:34:28] bye from me too [13:14:26] revertlist rudraksha-india.com [13:14:32] revertlist rudraksha-rudraksha.com [13:14:38] eh .. wrong channel [14:22:10] Coren: hello, is this info updated? -> https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help#Creating_databases [14:22:36] i'm getting a ERROR 1044 (42000): Access denied for user 'p [15:10:00] Alchimista: The info is okay; can you show me exactly which command fails and what the message is? [15:13:29] Coren, Alchimista gone [15:13:58] I still see him in the channel. [15:14:03] Oh, well. :-( [15:14:08] the erros is 'ERROR 1044 (42000): Access denied for user 'pxxxxxxxxxxxxx'@'%' to database 'alchimista__test'' [15:14:45] Coren, ^ [15:16:10] Ah! The cause is simple, then. When the doc explains "username followed by two underscores" it means /database/ username (the one starting with p) - so the DB should have been named 'pxxxxxxx__test' :-) [15:18:32] Coren, I do not know if I understand [15:19:09] how to solve? [15:19:16] Created databases must be named __* [15:19:29] is the username you connect to the database with, [15:19:54] and * ? [15:20:01] Look at the error message: It says "for user 'pxxxxxxxx'" -- /that/ is what the database name must start with. [15:20:42] * is whatever you want. So if your usename is p50000g20000 then you can create any database that starts with 'p50000g20000__' [15:26:55] Coren, i see [17:36:19] [bz] (8REOPENED - created by: 2MZMcBride, priority: 4Normal - 6normal) [Bug 36885] wmflabs.org does not resolve - https://bugzilla.wikimedia.org/show_bug.cgi?id=36885 [18:26:38] Coren, [18:29:37] guys [18:29:49] i see the new error: [18:30:01] ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-sousa_bmv2' at line 1 [18:30:34] or better: MariaDB [(none)]> CREATE DATABASE raylton-sousa_bmv2; [18:30:34] ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-sousa_bmv2' at line 1 [18:32:20] !adm [18:32:31] !admin [18:34:27] Raylton: going to be tough on weekends for a while, I Guess [18:34:30] poke scfc_de? [18:34:34] (who is also an admin) [18:35:28] YuviPanda, you can help me? [18:35:41] please :P [18:35:47] try [18:35:48] Raylton: What's your query? [18:36:16] or better: MariaDB [(none)]> CREATE DATABASE raylton-sousa_bmv2; [18:36:17] i think [18:36:33] yep [18:36:58] it show error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-sousa_bmv2' at line 1 [18:38:05] Raylton: What's the query that causes this error? [18:38:18] scfc_de: just trying to create it [18:38:27] MariaDB [(none)]> CREATE DATABASE raylton-sousa_bmv2; [18:38:39] scfc_de, ^ [18:39:48] Raylton: I think "-" are not allowed in identifiers; you would need to quote it with -- hmmm, "`"? But if you're asking about Tools, there are some more restrictions on database names. [18:41:48] scfc_de, " where? [18:42:31] Raylton: Are you talking about the project Tools or something else? [18:43:09] scfc_de, tools [18:44:06] i'm try it https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help#Creating_databases [18:44:12] scfc_de, ^ [18:45:52] Raylton: Yeah, but then your database needs to be named "u2020__bmv2" (for example). [18:46:51] scfc_de, sorry, what means? [18:47:24] Raylton: "CREATE DATABASE u2020__bmv2;" [18:48:05] scfc_de, what means u2020 ? [18:49:40] Raylton: "where username is your credentials' user, which can be found in your ~/replica.my.cnf" [18:51:24] let me see [18:53:35] scfc_de, pxxxgxxxx? [18:54:23] scfc_de, is what I see in the file [18:54:47] is it? [18:56:09] Raylton: Yes, sorry, I thought you meant your personal account. [18:57:00] let me try [18:58:10] great [18:58:17] its work [18:58:46] scfc_de, [19:20:13] btw, thank you scfe and YuviPanda :) [19:21:29] scfc_de: :) [19:21:32] Raylton: :) [19:42:34] Raylton: You're welcome.