[00:28:49] [13:34:45] On a side note, can you help me burnbridges on toolserver? >_> [00:28:49] [13:35:00] Whenever I try to ssh, it asks me for my key and then my password [00:28:49] [13:35:08] Usually, it just asks me for my key [00:29:12] That is to say [00:29:22] I can't log in to my ssh session... >_> [00:30:09] Never mind, I accidentally answered my own problem [00:37:25] * SigmaWP walks out quietly [01:42:30] 2013/11/28 01:35 WARN z-dat-s5-b MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1996 [01:42:30] 2013/11/28 01:35 WARN z-dat-s5-b wikidata replag QUERY WARNING: 'SELECT ts_rc_age()' returned 2000.000000 [02:19:34] 2013/11/28 02:18 OK z-dat-s5-b MySQL slave Uptime: 80442 Threads: 9 Questions: 102106117 Slow queries: 879 Opens: 3498 Flush tables: 1 Open tables: 255 Queries per second avg: 1269.313 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1789 [02:19:34] 2013/11/28 02:18 OK z-dat-s5-b wikidata replag QUERY OK: 'SELECT ts_rc_age()' returned 1784.000000 [02:26:34] 2013/11/28 02:19 WARN z-dat-s5-b MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2026 [02:26:34] 2013/11/28 02:19 WARN z-dat-s5-b wikidata replag QUERY WARNING: 'SELECT ts_rc_age()' returned 2026.000000 [02:51:36] 2013/11/28 02:50 OK z-dat-s5-b MySQL slave Uptime: 82362 Threads: 9 Questions: 102529727 Slow queries: 901 Opens: 3529 Flush tables: 1 Open tables: 256 Queries per second avg: 1244.866 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1800 [02:51:36] 2013/11/28 02:51 OK z-dat-s5-b wikidata replag QUERY OK: 'SELECT ts_rc_age()' returned 1775.000000 [03:09:38] 2013/11/28 03:03 WARN z-dat-s5-b wikidata replag QUERY WARNING: 'SELECT ts_rc_age()' returned 2082.000000 [03:10:38] 2013/11/28 03:03 WARN z-dat-s5-b MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2119 [03:57:41] 2013/11/28 03:56 OK z-dat-s5-b MySQL slave Uptime: 86322 Threads: 8 Questions: 103383743 Slow queries: 949 Opens: 3615 Flush tables: 1 Open tables: 256 Queries per second avg: 1197.652 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1641 [03:57:41] 2013/11/28 03:57 OK z-dat-s5-b wikidata replag QUERY OK: 'SELECT ts_rc_age()' returned 1588.000000 [09:14:59] 2013/11/28 09:14 CRIT ptolemy /sql DISK CRITICAL - free space: /sql 89397 MB (10% inode=99%): [10:42:04] 2013/11/28 10:35 CRIT ptolemy PostgreSQL CRITICAL - no connection to 'osm_mapnik' (FATAL: remaining connection slots are reserved for non-replication superuser connections [13:04:13] 2013/11/28 13:03 OK ptolemy PostgreSQL OK - database osm_mapnik (0 sec.) [13:22:09] @replag [13:25:32] Dispenser: s1-rr-a: 3w 4d 11h 10m 7s [+1.00 s/s]; s1-rr-a-wd: error; s1-user-c: 3w 16h 4m 48s [+1.00 s/s]; s1-user-wd: 8w 1d 46m 15s [+1.00 s/s]; s2-rr: 18m 50s [+0.00 s/s]; s2-user: 18m 51s [+0.00 s/s]; s2-user-c: error; s2-user-wd: 6w 3d 5h 37m 29s [+1.00 s/s] [13:25:33] Dispenser: s3-user: 38s [+0.00 s/s]; s3-user-wd: 19w 5d 19h 4m 14s [+1.00 s/s]; s4-user-wd: 15w 5d 20m 48s [+1.00 s/s]; s5-rr-a-wd: 7w 3d 20h 5m 2s [+1.00 s/s]; s5-user: 32m 5s [+0.00 s/s]; s5-user-c: 2w 4d 5h 54m 29s [+0.91 s/s]; s6-user-wd: 15w 5d 21m 2s [+1.00 s/s]; s7-user-wd: 15w 5d 21m 9s [+1.00 s/s] [13:29:13] 2013/11/28 13:22 WARN z-dat-s5-b MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2059 [13:29:13] 2013/11/28 13:23 WARN z-dat-s5-b wikidata replag QUERY WARNING: 'SELECT ts_rc_age()' returned 2066.000000 [14:57:19] 2013/11/28 14:56 OK z-dat-s5-b MySQL slave Uptime: 125922 Threads: 6 Questions: 193034806 Slow queries: 1307 Opens: 5105 Flush tables: 1 Open tables: 256 Queries per second avg: 1532.971 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1766 [14:57:19] 2013/11/28 14:57 OK z-dat-s5-b wikidata replag QUERY OK: 'SELECT ts_rc_age()' returned 1751.000000 [15:08:19] 2013/11/28 15:01 WARN z-dat-s5-b MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1890 [15:08:19] 2013/11/28 15:02 WARN z-dat-s5-b wikidata replag QUERY WARNING: 'SELECT ts_rc_age()' returned 1889.000000 [15:13:19] 2013/11/28 15:12 OK z-dat-s5-b MySQL slave Uptime: 126882 Threads: 5 Questions: 193250029 Slow queries: 1319 Opens: 5119 Flush tables: 1 Open tables: 255 Queries per second avg: 1523.68 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1770 [15:13:19] 2013/11/28 15:13 OK z-dat-s5-b wikidata replag QUERY OK: 'SELECT ts_rc_age()' returned 1720.000000 [16:05:22] 2013/11/28 16:04 OK ptolemy /sql DISK OK - free space: /sql 266916 MB (33% inode=99%): [19:57:49] [[Special:Log/newusers]] create 10 * Hayley165 * (New user account) [20:10:31] There's a question that only a toolserver account holder can answer at https://en.wikipedia.org/wiki/Wikipedia:Biographies_of_living_persons/RfC_to_add_Pending_Changes_to_all_BLP_with_few_or_no_watchers#Questions_for_someone_with_a_bot_or_toolserver_access [20:10:32] It requires joining the watchlist view to the 'Living People' category; for performance reasons it would be reasonable to sample rather than query for all records. [20:13:23] might as well set 'pending changes' on all BLP articles - the watched ones will be OKed quickly anyway [20:13:35] anyway, let me take a look [21:15:52] vahalasw, if everything was PC'd immediately, an instant and huge PC backlog would be created. Best ease into it. [21:25:31] Thanks for your efforts valhallasw [21:28:40] Josh_Parris: https://en.wikipedia.org/wiki/Wikipedia:Biographies_of_living_persons/RfC_to_add_Pending_Changes_to_all_BLP_with_few_or_no_watchers#Questions_for_someone_with_a_bot_or_toolserver_access [21:31:01] Wow! [21:31:33] I was surprised by the low amount of watchers, actually. [21:31:46] I wasn't [21:32:09] And if we had a metric (which we can't on TS) of how active they are, the activity level would be low too [21:32:27] activity of the users you mean? [21:32:38] But the edits vs watchers graph was fascinating [21:32:40] Yes [21:32:43] just look at the number of edits in the last year [21:32:51] Activity of the watchers [21:32:57] yes [21:32:59] edits by the watchers [21:33:10] not necessarily the best measure, but also not a horrible one [21:33:12] watchlist is anonymized [21:33:32] Yes, a decent proxy [21:33:39] Oh. Of course. [21:33:59] there is the ts_wl_user_touched_cropped column though [21:34:01] not sure what that does [21:34:17] * Josh_Parris shrugs in agreement [21:34:26] That last graph is a doozy [21:34:41] watchers != activity [21:51:09] [[Special:Log/newusers]] create 10 * Micaela333 * (New user account) [22:44:44] 2013/11/28 22:38 WARN wolfsbane /tmp DISK WARNING - free space: / 6286 MB (20% inode=93%): [22:51:44] 2013/11/28 22:45 WARN wolfsbane / DISK WARNING - free space: / 6285 MB (20% inode=93%): [23:28:47] 2013/11/28 23:28 OK wolfsbane / DISK OK - free space: / 7071 MB (23% inode=93%): [23:29:47] 2013/11/28 23:29 OK wolfsbane /tmp DISK OK - free space: / 8092 MB (27% inode=93%):