[00:48:06] RAID on thyme is CRITICAL: Connection refused by host [00:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [00:50:05] SSH on thyme is CRITICAL: Connection refused [00:52:05] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [01:48:06] RAID on thyme is CRITICAL: Connection refused by host [01:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [01:50:06] SSH on thyme is CRITICAL: Connection refused [01:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [02:48:06] RAID on thyme is CRITICAL: Connection refused by host [02:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [02:50:06] SSH on thyme is CRITICAL: Connection refused [02:52:05] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [03:48:06] RAID on thyme is CRITICAL: Connection refused by host [03:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [03:50:05] SSH on thyme is CRITICAL: Connection refused [03:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [04:48:06] RAID on thyme is CRITICAL: Connection refused by host [04:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [04:50:06] SSH on thyme is CRITICAL: Connection refused [04:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [05:48:06] RAID on thyme is CRITICAL: Connection refused by host [05:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [05:50:06] SSH on thyme is CRITICAL: Connection refused [05:52:05] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [06:14:17] Hello, I want to run a database query but this error occurs:ERROR 1142 (42000) at line 1: SELECT command denied to user 'amir'@'damiana-bge0 .esi.toolserver.org' for table 'commonswiki_p' [06:16:36] er wat. [06:16:39] * legoktm tests [06:17:18] mysql> select * from `page` limit 1; [06:17:22] 1 row in set (0.02 sec) [06:17:26] works for me [06:17:27] problem solved [06:17:30] :D [06:17:51] i wrote image.commonswiki_p instead of commonswiki_p.image [06:18:58] Is it wowrking for duplicate images?SELECT [06:19:00] img_name [06:19:01] FROM image [06:19:03] WHERE img_sha1 in (SELECT img_sha1 FROM commonswiki_p.image) [06:19:04] ORDER BY img_name; [06:24:19] You want to do a join, not a where. [06:48:06] RAID on thyme is CRITICAL: Connection refused by host [06:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [06:50:06] SSH on thyme is CRITICAL: Connection refused [06:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [07:48:06] RAID on thyme is CRITICAL: Connection refused by host [07:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [07:50:05] SSH on thyme is CRITICAL: Connection refused [07:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [08:48:06] RAID on thyme is CRITICAL: Connection refused by host [08:49:05] Environment IPMI on thyme is CRITICAL: Connection refused by host [08:50:06] SSH on thyme is CRITICAL: Connection refused [08:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [09:48:06] RAID on thyme is CRITICAL: Connection refused by host [09:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [09:50:06] SSH on thyme is CRITICAL: Connection refused [09:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [10:48:05] RAID on thyme is CRITICAL: Connection refused by host [10:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [10:50:06] SSH on thyme is CRITICAL: Connection refused [10:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [11:48:06] RAID on thyme is CRITICAL: Connection refused by host [11:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [11:50:06] SSH on thyme is CRITICAL: Connection refused [11:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [12:48:06] RAID on thyme is CRITICAL: Connection refused by host [12:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [12:50:06] SSH on thyme is CRITICAL: Connection refused [12:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [13:48:06] RAID on thyme is CRITICAL: Connection refused by host [13:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [13:50:06] SSH on thyme is CRITICAL: Connection refused [13:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [14:37:12] hello all [14:48:05] RAID on thyme is CRITICAL: Connection refused by host [14:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [14:50:05] SSH on thyme is CRITICAL: Connection refused [14:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [15:48:06] RAID on thyme is CRITICAL: Connection refused by host [15:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [15:50:06] SSH on thyme is CRITICAL: Connection refused [15:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [16:34:06] Morten Wang * [Toolserver-l] Multiple jobs started, SGE or cron issue? [16:48:06] RAID on thyme is CRITICAL: Connection refused by host [16:49:05] Environment IPMI on thyme is CRITICAL: Connection refused by host [16:50:06] SSH on thyme is CRITICAL: Connection refused [16:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [17:48:06] RAID on thyme is CRITICAL: Connection refused by host [17:49:05] Environment IPMI on thyme is CRITICAL: Connection refused by host [17:50:06] SSH on thyme is CRITICAL: Connection refused [17:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [18:48:06] RAID on thyme is CRITICAL: Connection refused by host [18:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [18:50:06] SSH on thyme is CRITICAL: Connection refused [18:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [19:13:05] Morten Wang * Re: [Toolserver-l] Multiple jobs started, SGE or cron issue? [19:48:06] RAID on thyme is CRITICAL: Connection refused by host [19:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [19:50:06] SSH on thyme is CRITICAL: Connection refused [19:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [20:48:06] RAID on thyme is CRITICAL: Connection refused by host [20:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [20:50:05] SSH on thyme is CRITICAL: Connection refused [20:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [21:48:06] RAID on thyme is CRITICAL: Connection refused by host [21:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [21:50:06] SSH on thyme is CRITICAL: Connection refused [21:51:04] @replag [21:51:06] DaBPunkt: s1-rr-a-wd: error; s1-user-wd: 44s [-0.00 s/s]; s2-user-wd: 40m 42s [-6.38 s/s]; s3-rr-a: 57s [+0.00 s/s]; s3-user: 57s [+0.00 s/s]; s4-user-wd: 42m 6s [+0.08 s/s]; s5-user-wd: 40m 39s [-6.38 s/s]; s7-rr-a: 2w 2h 5m 39s [+1.00 s/s] [21:51:07] DaBPunkt: s7-user: 2w 2h 5m 39s [+1.00 s/s] [21:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [21:57:30] thx DaBPunkt [22:04:53] np [22:05:16] I also added wikidata to thyme [22:07:57] @replag [22:07:58] DaBPunkt: s1-rr-a-wd: 12m 39s [-]; s1-user-wd: 17s [-0.01 s/s]; s2-user: 11s [-0.00 s/s]; s2-user-wd: 17m 37s [-0.45 s/s]; s3-rr-a: 1m 40s [+0.44 s/s]; s3-user: 1m 40s [+0.44 s/s]; s4-user-wd: 18m 47s [-1.07 s/s]; s5-user-wd: 17m 37s [-0.45 s/s] [22:07:59] DaBPunkt: s7-rr-a: 2w 2h 22m 31s [+1.00 s/s]; s7-user: 2w 2h 22m 31s [+1.00 s/s] [22:11:53] @replag [22:11:53] DaBPunkt: s1-rr-a-wd: 7m 10s [-1.40 s/s]; s1-user: 10s [-]; s1-user-wd: 16s [-0.00 s/s]; s2-user: 16s [+0.02 s/s]; s2-user-wd: 12m 40s [-1.26 s/s]; s3-rr-a: 1m 43s [+0.01 s/s]; s3-user: 1m 43s [+0.01 s/s]; s4-user-wd: 14m 22s [-1.12 s/s] [22:11:54] DaBPunkt: s5-user-wd: 12m 40s [-1.26 s/s]; s7-rr-a: 2w 2h 26m 27s [+1.00 s/s]; s7-user: 2w 2h 26m 27s [+1.00 s/s] [22:26:57] whenever I try to do crontab -l, it says "crontab: can't open your crontab file." [22:28:20] I've tried on willow and clematis and get the same error [22:40:01] kaldari: which username? [22:41:36] kaldari [22:43:42] kaldari: AFAIS you have no crontab-file yet [22:43:57] you can create/edit is with "-e" [22:44:03] hmm, that's weird, I'm running daily jobs [22:44:29] I haven't set up any new ones in a year or so, so I don't remember exactly how I set them up [22:44:44] one sec... [22:44:50] kaldari: every server has its own crontab – and there is also cron(ie) [22:45:14] it's definitely cron [22:45:40] I get an email every day from Cron Daemon (root@toolserver.org) [22:46:11] I tried willow, nightshade, and clematis [22:46:14] then look into the headers so see from where the email is [22:46:18] anywhere else I should check? [22:46:26] lemme check the headers... [22:46:55] ha it's from hawthorn.toolserver.org [22:47:01] I've never even heard of that one! [22:47:27] hawthorn and clematis together are "submit" [22:47:35] try "ssh submit" [22:47:40] I tried that [22:47:43] got the same error [22:48:06] RAID on thyme is CRITICAL: Connection refused by host [22:48:24] lemme try sshing to hawthorne specifically [22:48:37] no need to. [22:48:50] I see your cron-job [22:48:53] kaldari@hawthorn:~$ crontab -l [22:48:53] crontab: can't open your crontab file. [22:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [22:49:12] yes, because it's cronie, not crontab [22:49:16] ah [22:49:41] crontab is not cluster-able, while cronie is. That's the reason we use cronie there [22:49:56] shit, I don't remember the command to view cronie jobs [22:50:05] SSH on thyme is CRITICAL: Connection refused [22:50:09] cronie -l [22:50:14] it's also -l [22:50:51] yay [22:50:54] I'll add that to http://en.wikipedia.org/wiki/Cron [22:50:59] oops wrong wiki [22:51:33] I'll add that to the documentation on the toolserver wiki if it isn't there already :) [22:51:39] thanks for the help! [22:51:42] I'm not sure if enwp likes to have ts-howtos into their artciles ;) [22:51:53] probably not :) [22:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146) [22:53:00] BTW: submit is ONLY for submitting jobs to SGE. AFAIS you let the bot run there [23:04:53] @replag [23:04:54] DaBPunkt: s1-rr-a-wd: 24s [-0.13 s/s]; s1-user: 13s [+0.00 s/s]; s1-user-wd: 24s [+0.00 s/s]; s2-user-wd: 22s [-0.23 s/s]; s3-rr-a: 51s [-0.02 s/s]; s3-user: 51s [-0.02 s/s]; s4-user-wd: 23s [-0.26 s/s]; s5-user-wd: 21s [-0.23 s/s] [23:04:55] DaBPunkt: s7-rr-a: 2w 3h 19m 28s [+1.00 s/s]; s7-user: 2w 3h 19m 28s [+1.00 s/s] [23:48:06] RAID on thyme is CRITICAL: Connection refused by host [23:49:06] Environment IPMI on thyme is CRITICAL: Connection refused by host [23:50:06] SSH on thyme is CRITICAL: Connection refused [23:52:06] MySQL on z-dat-s4-a is CRITICAL: Cant connect to MySQL server on z-dat-s4-a (146)