[00:03:31] Sun Grid Engine execd on willow is WARNING: all.q@willow exceedes load threshold: alarm hl:np_load_short=0.514648/1.75, alarm hl:np_load_avg=0.615234/2.00, alarm hl:mem_free=274.000000M/300M [00:04:32] Sun Grid Engine execd on willow is OK: all.q@willow OK: longrun@willow OK [00:24:02] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [00:24:32] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [00:27:31] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [00:27:31] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [00:31:02] SSH on nightshade.mgmt is CRITICAL: Server answer: [00:46:21] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52397 MB (5% inode=99%): [00:48:30] What are the odds that the home directory of a long-since expired user might be kicking around somewhere? >.> [01:24:03] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [01:24:32] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [01:27:32] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [01:27:33] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [01:32:01] SSH on nightshade.mgmt is CRITICAL: Server answer: [01:41:21] 3(created) [TS-1268] Requesting account restoration: madman; Toolserver: Accounts; Task <10https://jira.toolserver.org/browse/TS-1268> (madman) [01:41:28] 3(updated) [TS-1268] Requesting account restoration: madman <10https://jira.toolserver.org/browse/TS-1268> (madman) [01:46:32] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52249 MB (5% inode=99%): [01:59:33] RAID on hyacinth is CRITICAL: CHECK_NRPE: Socket timeout after 30 seconds. [02:00:01] RAID on hyacinth is OK: OK - TOTAL: 2: FAILED: 0: DEGRADED: 0 [02:24:02] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [02:24:41] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [02:27:41] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [02:28:31] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [02:32:01] SSH on nightshade.mgmt is CRITICAL: Server answer: [02:47:31] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52102 MB (5% inode=99%): [03:12:41] Sun Grid Engine execd on willow is WARNING: all.q@willow exceedes load threshold: alarm hl:np_load_short=0.671875/1.75, alarm hl:np_load_avg=0.641602/2.00, alarm hl:mem_free=231.000000M/300M: longrun@willow exceedes load threshold: alarm hl:np_load_short=0.671875/1.50, alarm hl:np_load_long=0.594727/1.75, alarm hl:mem_free=231.000000M/250M [03:14:40] Sun Grid Engine execd on willow is OK: all.q@willow OK: longrun@willow OK [03:25:02] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [03:25:42] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [03:27:41] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [03:28:30] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [03:32:01] SSH on nightshade.mgmt is CRITICAL: Server answer: [03:47:32] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 51966 MB (5% inode=99%): [03:51:20] 3(created) [ACCAPP-444] Verificar acesso estatistica; Account Approval; New Account <10https://jira.toolserver.org/browse/ACCAPP-444> (JA Rezende) [04:08:55] [[Special:Log/newusers]] create 10 * Gunchat * (New user account) [04:17:42] SMTP on z-dat-s6-a is CRITICAL: CRITICAL - Socket timeout after 10 seconds [04:17:42] SMTP on z-dat-s7-a is CRITICAL: CRITICAL - Socket timeout after 10 seconds [04:18:32] SMTP on z-dat-s6-a is OK: SMTP OK - 0.033 sec. response time [04:18:32] SMTP on z-dat-s7-a is OK: SMTP OK - 0.021 sec. response time [04:25:41] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [04:26:02] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [04:27:41] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [04:28:42] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [04:32:03] SSH on nightshade.mgmt is CRITICAL: Server answer: [04:48:31] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52813 MB (5% inode=99%): [05:25:42] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [05:26:13] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [05:27:43] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [05:28:42] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [05:30:12] Sun Grid Engine execd on nightshade is WARNING: all.q@nightshade exceedes load threshold: alarm hl:np_load_short=1.780762/1.75, alarm hl:np_load_avg=1.439453/2.00, alarm hl:mem_free=2291.000000M/300M: longrun@nightshade exceedes load threshold: alarm hl:np_load_short=1.780762/1.50, alarm hl:np_load_long=1.185059/1.75, alarm hl:mem_free=2291.000000M/250M [05:32:11] SSH on nightshade.mgmt is CRITICAL: Server answer: [05:33:12] Sun Grid Engine execd on nightshade is OK: all.q@nightshade OK: longrun@nightshade OK [05:48:31] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52665 MB (5% inode=99%): [06:23:42] Sun Grid Engine execd on ortelius is WARNING: short@ortelius exceedes load threshold: alarm hl:np_load_short=1.076172/1.00, alarm hl:np_load_long=0.601562/1.50, alarm hl:mem_free=23524.000000M/300M [06:24:42] Sun Grid Engine execd on ortelius is OK: short@ortelius OK: all.q@ortelius OK [06:25:43] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [06:27:12] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [06:27:42] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [06:29:42] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [06:32:12] SSH on nightshade.mgmt is CRITICAL: Server answer: [06:43:42] Sun Grid Engine execd on ortelius is WARNING: short@ortelius exceedes load threshold: alarm hl:np_load_short=1.625976/1.00, alarm hl:np_load_long=0.850586/1.50, alarm hl:mem_free=24333.000000M/300M: all.q@ortelius exceedes load threshold: alarm hl:np_load_short=1.625976/1.10, alarm hl:np_load_long=0.850586/1.75, alarm hl:mem_free=24333.000000M/300M [06:48:31] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52558 MB (5% inode=99%): [06:48:43] Sun Grid Engine execd on ortelius is OK: short@ortelius OK: all.q@ortelius OK [06:55:43] Sun Grid Engine execd on ortelius is WARNING: short@ortelius exceedes load threshold: alarm hl:np_load_short=1.109375/1.00, alarm hl:np_load_long=0.972656/1.50, alarm hl:mem_free=24021.000000M/300M: all.q@ortelius exceedes load threshold: alarm hl:np_load_short=1.109375/1.10, alarm hl:np_load_long=0.972656/1.75, alarm hl:mem_free=24021.000000M/300M [07:21:05] [[Toolserver:Sandbox]] ! 10https://wiki.toolserver.org/w/index.php?diff=6567&oldid=6492&rcid=8639 * 122.164.181.205 * (+5) () [07:26:41] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [07:27:51] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [07:28:11] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [07:29:41] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [07:32:12] SSH on nightshade.mgmt is CRITICAL: Server answer: [07:48:31] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52433 MB (5% inode=99%): [08:09:06] nosy: are you currently around? [08:09:20] apmon: yes [08:09:31] /aux0 on daphne is CRITICAL: DISK CRITICAL - free space: /aux0 36249 MB (3% inode=99%): [08:10:14] would it be possible to try to change some settings on postgresql to see if that improves performance? [08:11:25] apmon: do you have measures of the current status? [08:11:53] mainly just http://munin.toolserver.org/OSM/ptolemy/index.html [08:12:53] ah ok [08:13:04] but significant improvements should hopefully be visible on the various graphs over time [08:13:44] which parameters do you want to change? [08:14:54] If you could try setting shared_buffers to 7168Mb? [08:15:11] I think that is more or less the maximum without tuning the kernel for larger shared memory [08:16:28] Most things are otherwise running fairly smoothly now as far as I can tell. [08:17:02] The main thing that is possibly still causing problems are the sockets. [08:18:50] apmon: really set shared_buffers to 7168 MB? [08:18:56] this would be very much [08:19:12] currently I have 512 MB [08:19:25] or do you mean 768? [08:19:35] 8 Gb of cache for the db on a 32Gb machine doesn't seem to much [08:20:50] It isn't sure that it will improve things, but moving it all the way to 7Gb, should at least give an indication if that direction will improve things [08:22:51] Thanks [08:22:54] apmon: restarted postgres [08:24:41] I'll watch it over the next couple of days to see if any of the performance indicators have changed and improved [08:26:42] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [08:27:52] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [08:28:21] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [08:29:52] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [08:32:23] SSH on nightshade.mgmt is CRITICAL: Server answer: [08:48:42] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52308 MB (5% inode=99%): [09:26:42] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [09:27:52] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [09:28:23] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [09:29:52] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [09:33:23] SSH on nightshade.mgmt is CRITICAL: Server answer: [09:49:40] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52159 MB (5% inode=99%): [10:26:52] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [10:27:52] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [10:29:22] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [10:29:52] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [10:34:22] SSH on nightshade.mgmt is CRITICAL: Server answer: [10:49:41] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52001 MB (5% inode=99%): [11:26:52] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [11:28:01] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [11:29:22] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [11:30:01] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [11:35:23] SSH on nightshade.mgmt is CRITICAL: Server answer: [11:49:41] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 51863 MB (5% inode=99%): [12:12:52] Sun Grid Engine execd on willow is WARNING: all.q@willow exceedes load threshold: alarm hl:np_load_short=0.382812/1.75, alarm hl:np_load_avg=0.376953/2.00, alarm hl:mem_free=284.000000M/300M [12:13:53] Sun Grid Engine execd on willow is OK: all.q@willow OK: longrun@willow OK [12:26:53] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [12:28:01] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [12:29:22] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [12:30:02] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [12:35:23] SSH on nightshade.mgmt is CRITICAL: Server answer: [12:49:41] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52647 MB (5% inode=99%): [13:27:52] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [13:29:00] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [13:30:21] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [13:31:01] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [13:35:22] SSH on nightshade.mgmt is CRITICAL: Server answer: [13:40:20] 3(assigned) [TS-1268] Requesting account restoration: madman <10https://jira.toolserver.org/browse/TS-1268> (DaB.) [13:42:21] 3(commented) [TS-1268] Requesting account restoration: madman <10https://jira.toolserver.org/browse/TS-1268> (DaB.) [13:44:53] Sun Grid Engine execd on ortelius is WARNING: short@ortelius exceedes load threshold: alarm hl:np_load_short=1.206055/1.00, alarm hl:np_load_long=0.605469/1.50, alarm hl:mem_free=24183.000000M/300M: all.q@ortelius exceedes load threshold: alarm hl:np_load_short=1.206055/1.10, alarm hl:np_load_long=0.605469/1.75, alarm hl:mem_free=24183.000000M/300M [13:45:52] Sun Grid Engine execd on ortelius is OK: short@ortelius OK: all.q@ortelius OK [13:49:40] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52508 MB (5% inode=99%): [14:28:51] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [14:29:01] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [14:31:01] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [14:31:21] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [14:35:31] SSH on nightshade.mgmt is CRITICAL: Server answer: [14:49:42] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52341 MB (5% inode=99%): [15:08:02] Sun Grid Engine execd on willow is WARNING: all.q@willow exceedes load threshold: alarm hl:np_load_short=0.380371/1.75, alarm hl:np_load_avg=0.351562/2.00, alarm hl:mem_free=245.000000M/300M: longrun@willow exceedes load threshold: alarm hl:np_load_short=0.380371/1.50, alarm hl:np_load_long=0.322754/1.75, alarm hl:mem_free=245.000000M/250M [15:09:01] Sun Grid Engine execd on willow is OK: all.q@willow OK: longrun@willow OK [15:19:02] Sun Grid Engine execd on willow is WARNING: all.q@willow exceedes load threshold: alarm hl:np_load_short=0.278809/1.75, alarm hl:np_load_avg=0.326172/2.00, alarm hl:mem_free=270.000000M/300M [15:29:02] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [15:29:02] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [15:31:02] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [15:31:32] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [15:35:32] SSH on nightshade.mgmt is CRITICAL: Server answer: [15:49:52] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52182 MB (5% inode=99%): [16:29:12] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [16:29:12] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [16:31:12] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [16:31:31] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [16:36:31] SSH on nightshade.mgmt is CRITICAL: Server answer: [16:50:51] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 51996 MB (5% inode=99%): [17:13:01] Sun Grid Engine execd on willow is WARNING: all.q@willow exceedes load threshold: alarm hl:np_load_short=0.484863/1.75, alarm hl:np_load_avg=0.496094/2.00, alarm hl:mem_free=236.000000M/300M: longrun@willow exceedes load threshold: alarm hl:np_load_short=0.484863/1.50, alarm hl:np_load_long=0.466797/1.75, alarm hl:mem_free=236.000000M/250M [17:17:00] Sun Grid Engine execd on willow is OK: all.q@willow OK: longrun@willow OK [17:21:24] [[Main Page]] ! 10https://wiki.toolserver.org/w/index.php?diff=6568&oldid=6405&rcid=8640 * Sebastian Sooth (WMDE) * (+157) () [17:23:23] [[Toolserver:Homepage]] ! 10https://wiki.toolserver.org/w/index.php?diff=6569&oldid=2179&rcid=8641 * Sebastian Sooth (WMDE) * (+234) () [17:30:12] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [17:30:12] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [17:31:12] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [17:31:32] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [17:36:32] SSH on nightshade.mgmt is CRITICAL: Server answer: [17:50:51] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 51826 MB (5% inode=99%): [18:13:01] Sun Grid Engine execd on willow is WARNING: all.q@willow exceedes load threshold: alarm hl:np_load_short=0.397461/1.75, alarm hl:np_load_avg=0.377930/2.00, alarm hl:mem_free=264.000000M/300M [18:14:01] Sun Grid Engine execd on willow is OK: all.q@willow OK: longrun@willow OK [18:30:11] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [18:30:12] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [18:31:12] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [18:31:32] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [18:36:32] SSH on nightshade.mgmt is CRITICAL: Server answer: [18:50:51] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52586 MB (5% inode=99%): [19:30:22] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [19:30:22] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [19:31:22] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [19:31:32] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [19:37:31] SSH on nightshade.mgmt is CRITICAL: Server answer: [19:45:51] [[Special:Log/newusers]] create 10 * Rahuldeshmukh101 * (New user account) [19:51:51] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52405 MB (5% inode=99%): [20:09:41] /aux0 on daphne is CRITICAL: DISK CRITICAL - free space: /aux0 34876 MB (3% inode=99%): [20:27:23] 3(commented) [TS-1268] Requesting account restoration: madman <10https://jira.toolserver.org/browse/TS-1268> (madman) [20:29:24] 3(resolved) [TS-1268] Requesting account restoration: madman <10https://jira.toolserver.org/browse/TS-1268> (DaB.) [20:30:23] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [20:30:23] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [20:30:41] DaBPunkt: Now *that's* efficiency. :D [20:30:50] :) [20:31:23] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [20:31:32] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [20:37:32] SSH on nightshade.mgmt is CRITICAL: Server answer: [20:51:52] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52213 MB (5% inode=99%): [20:57:48] hi [20:58:19] i want to make a list of the users by number of edits [20:58:42] which tool i can use [21:01:06] sam___: If you want a list for the English wikipedia, I think one already exists at http://en.wikipedia.org/wiki/Wikipedia:List_of_Wikipedians_by_number_of_edits. [21:01:34] i want it on mr.wikipedia [21:02:38] Ah. Well, in that case, you should be able to request a query here: https://wiki.toolserver.org/view/Query_service [21:03:56] Or rather, following the instructions at the top of that page ("If you want someone to run a SQL query for you"). [21:05:19] But the service - Emijrp/List of Wikipedians by number of edits , is not working these days [21:05:28] where can [21:05:33] I get it [21:06:36] I think a database query is probably your best bet; due to the size of any such list and the potential run time, it's not something a tool's going to provide automatically. [21:06:52] As I understand it, you can request that the results be refreshed weekly, or monthly, or so. [21:07:23] yes exasictly [21:07:49] So all you need to do is file a request on DBQ. [21:07:53] I want to show at list the top 100 users (active) [21:08:22] where I can file it ? [21:08:36] Here: https://jira.toolserver.org/browse/DBQ [21:08:54] You'll have to register a Jira account if you don't already have one. [21:09:04] ok [21:09:09] Once you've done so, you click Create new issue, then Next. [21:09:24] Just say what you want in as much detail as you can provide, and someone will pick it up. [21:09:56] whether it will be one time service are regular tool [21:10:38] Just specify which you want; it's relatively easy for Toolserver users to set it up once then have it run regularly. And they'll give you a link to where you can get the list. [21:11:32] s4 replag on daphne is WARNING: QUERY WARNING: SELECT ts_rc_age() returned 1812.000000 [21:12:07] Thanks AMadman [21:12:14] I will do it [21:12:23] No problem. Feel free to let us know if you have any further questions. [21:20:22] 3(created) [EDITCOUNTER-41] Emijrp/List of Wikipedians by number of edits; Editcounter: General/Unknown; Support request <10https://jira.toolserver.org/browse/EDITCOUNTER-41> (Rahuldeshmukh101) [21:24:21] 3(commented) [EDITCOUNTER-41] Emijrp/List of Wikipedians by number of edits <10https://jira.toolserver.org/browse/EDITCOUNTER-41> (Rahuldeshmukh101) [21:26:37] sam___, what's an active user for you? [21:27:31] The user who has dome at least one edit in last 30 days [21:28:48] here's the list not taking into account the activity: http://pastebin.com/j8SKgV6A [21:31:21] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [21:31:22] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [21:32:22] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [21:32:28] requiring an action (be than an edit, protection, etc.) http://pastebin.com/PB3eBRpw [21:32:31] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [21:35:10] http://pastebin.com/j8SKgV6A is this service is standard service link [21:36:43] http://pastebin.com/j8SKgV6A can I get without BOT list [21:37:32] SSH on nightshade.mgmt is CRITICAL: Server answer: [21:45:31] s4 replag on daphne is OK: QUERY OK: SELECT ts_rc_age() returned 1749.000000 [21:52:51] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 52030 MB (5% inode=99%): [21:56:49] hi [21:56:57] any body there [21:57:28] http://pastebin.com/j8SKgV6A can I get without BOT list [22:00:12] sam____: ask Platonides [22:00:31] should be simple to filter the bots out if you have the query [22:00:56] ok [22:02:48] how to get a list without bots [22:03:31] patience is not your strength, is it? ;) [22:04:00] which wiki? [22:07:10] for mr. [22:14:00] sam____: http://pastebin.com/xqFZnW6Q [22:15:19] Thanks DaBPunkt [22:15:30] no problem [22:15:31] can i also generat this list [22:15:52] or can i have regular service for this [22:17:06] sorry, sam____ I hadn't seen your answer [22:17:17] sam____: you have to ask regularly or request a toolserver-account to run it yourself [22:17:31] yes [22:17:48] Could be a scheduled DBQ, no? [22:18:20] AMadman: oh that, yes [22:18:28] oh -> or [22:18:37] if it can be possible then I can embed it in community page [22:18:44] If someone gives me the query I can put it in the job scheduler and have it output to public_html somewhere. [22:18:55] sam____: I'm not sure there'd be any way to embed it in a wiki page. [22:19:15] You'd have to have a bot do that, and while many members have bots I doubt they've gone through the ms.wiki bot approval process. [22:19:38] A report could probably be generated in wikitext that you could copy and paste. [22:19:50] But it'd still have to be a little bit of manual intervention. [22:20:12] noproblem [22:20:21] twice in month [22:20:28] we can do that [22:20:45] Okay. Well, if you filed a DBQ, I can look at scheduling it. [22:20:58] Especially if someone comments on it with the actual SQL. [22:21:05] I have already filed it [22:21:53] URL: https://jira.toolserver.org/browse/EDITCOUNTER-41 [22:23:01] Thanks [22:23:33] Mmm. Looks like that's in the editcounter queue and not DBQ so it got assigned to Kate. I'll see if I can move it. [22:24:16] No, doesn't look like it. DaBPunkt, can you do it? [22:24:18] any thing i have to do please tell me [22:24:33] should i have to make new request or so [22:24:46] Probably be better just to move this one. [22:24:56] ok [22:25:06] AMadman: done [22:25:14] thanks [22:25:17] DaBPunkt: Thanks! [22:25:22] 3(moved) [DBQ-174] Emijrp/List of Wikipedians by number of edits <10https://jira.toolserver.org/browse/DBQ-174> (DaB.) [22:25:22] 3(assigned) [EDITCOUNTER-41] Emijrp/List of Wikipedians by number of edits <10https://jira.toolserver.org/browse/EDITCOUNTER-41> (madman) [22:25:38] np [22:27:00] Has someone in the channel already come up with SQL for the request? If not, I'll figure it out after dinner. [22:27:40] AMadman: yes, I included it in my result [22:27:48] Oh, thanks. [22:28:55] ok Thanks [22:31:22] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [22:31:22] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [22:32:23] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [22:32:32] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [22:33:10] sam____: I'm going to dinner but when I've scheduled it I'll send you a link to where you can pick up the results every other we- oops. [22:33:14] Ah well. :x [22:37:42] SSH on nightshade.mgmt is CRITICAL: Server answer: [22:44:21] 3(commented) [DBQ-174] Emijrp/List of Wikipedians by number of edits <10https://jira.toolserver.org/browse/DBQ-174> (madman) [22:46:20] 3(updated) [DBQ-174] Emijrp/List of Wikipedians by number of edits <10https://jira.toolserver.org/browse/DBQ-174> (madman) [22:52:52] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 51871 MB (5% inode=99%): [23:01:08] nighty [23:04:20] I forget, did sam__ say what his criteria for "active" vs. "inactive" was? [23:08:03] Oh, our user view doesn't have user_touched? Bleah. [23:08:24] Figured that'd be the easiest way to just say "last active". [23:09:37] AMadman: and a very nice way to spy on users ;) [23:10:38] Ah. That's a fair point. [23:11:09] * AMadman figures out how to put in a group by rev_user and max(rev_timestamp) without making it take forever. [23:12:09] mayb using user_daily_contribs would be faster? [23:12:44] also you could filter the result at the end [23:12:46] Hm. Well, it did it with the group by and max in 12.07 seconds. [23:12:58] So that's not too bad. [23:13:03] that's fast enough (mr is a small wiki after all) [23:13:14] Indeed. [23:15:38] Oh, and that has the side effect of if two users have the same edit count (as the last two do), the more active one appears first. Nifty. [23:16:01] * AMadman pats MySQL on the head happily. [23:18:33] Oh, except I don't get the same list of users (adding that join seems to have broken bot exclusion). Womp womp. I'm going to be quiet and fix this myself now. :p [23:24:34] AMadman: there are some users with "bot" in their names which have no botflags [23:24:52] Yeah, I know. But somehow my list is different than yours in the pastebin. [23:25:16] AMadman: I didn't exclude inactive users [23:25:24] Even when I run the exact same query. [23:25:43] ... Maybe I'm on the wrong database. [23:25:59] mrwiki_p? [23:26:06] In other news, I'm an idiot. [23:26:28] I was on mswiki. [23:26:28] * Damianz concurs. [23:26:44] AMadman: Always the girls in the head? ;) [23:26:54] ms. versus mr. [23:27:06] DaBPunkt: Jawohl. ;) [23:27:33] Actually more Mr. for me, but I still thought it was funny. And hey, it's a smaller wiki so instead of 12 seconds it's 5 seconds. :p [23:27:58] AMadman: You would be amazed how fewly we use that word… [23:28:52] Well, then I'm just failing on all fronts today, now, aren't I. :p [23:30:19] It's one of those days. [23:31:23] ethernet 0/1/18 on asw-oe16-esams.mgmt is CRITICAL: GigabitEthernet0/1/18:UP: 1 int NOK : CRITICAL [23:31:32] SMF on turnera.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [23:32:20] 3(commented) [DBQ-174] Emijrp/List of Wikipedians by number of edits <10https://jira.toolserver.org/browse/DBQ-174> (madman) [23:32:41] ethernet 0/1/24 on asw-oe10-esams.mgmt is CRITICAL: GigabitEthernet0/1/24:UP: 1 int NOK : CRITICAL [23:33:22] SMF on damiana.esi is CRITICAL: ERROR - offline: svc:/system/cluster/scsymon-srv:default [23:37:41] SSH on nightshade.mgmt is CRITICAL: Server answer: [23:40:53] New projects on JIRA are requested by filing a bug under "Toolserver" right? [23:41:09] yes [23:41:22] Thanks [23:53:50] /sql on rosemary is CRITICAL: DISK CRITICAL - free space: /sql 51706 MB (5% inode=99%): [23:55:22] 3(created) [TS-1269] Requesting new JIRA project for my tools; Toolserver: JIRA; Minor Task <10https://jira.toolserver.org/browse/TS-1269> (Matthew Bowker)