[04:15:57] 2013/06/27 04:15 CRIT z-dat-s1-b /sql DISK CRITICAL - free space: /sql 58341 MB (5% inode=99%): [04:26:57] 2013/06/27 04:26 WARN z-dat-s1-b /sql DISK WARNING - free space: /sql 58586 MB (6% inode=99%): [05:17:59] 2013/06/27 05:17 CRIT z-dat-s1-b /sql DISK CRITICAL - free space: /sql 58328 MB (5% inode=99%): [06:27:06] 2013/06/27 06:26 WARN z-dat-s1-b /sql DISK WARNING - free space: /sql 58347 MB (6% inode=99%): [06:33:07] 2013/06/27 06:32 CRIT z-dat-s1-b /sql DISK CRITICAL - free space: /sql 58343 MB (5% inode=99%): [08:24:04] Marlen Caemmerer * [Toolserver-announce] Move of user-store NFS [08:33:04] Marlen Caemmerer * [Toolserver-l] Cleanup of user-store [09:11:37] [[Report tool]] ! 10https://wiki.toolserver.org/w/index.php?diff=8047&oldid=8012&rcid=22006 * 82.42.89.123 * (-942) (/* For users */ delete spam) [09:16:24] [[Report tool]] ! 10https://wiki.toolserver.org/w/index.php?diff=8048&oldid=8047&rcid=22007 * 82.42.89.123 * (+942) (Undo revision 8047 by [[Special:Contributions/82.42.89.123|82.42.89.123]] ([[User talk:82.42.89.123|talk]])) [09:18:32] [[Report tool]] ! 10https://wiki.toolserver.org/w/index.php?diff=8049&oldid=8048&rcid=22008 * 82.42.89.123 * (+1567) (Undo revision 8012 by [[Special:Contributions/125.209.70.3|125.209.70.3]] ([[User talk:125.209.70.3|talk]])) [09:55:16] 2013/06/27 09:48 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 2.795 second response time [10:10:16] 2013/06/27 10:09 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.263 second response time [10:27:18] 2013/06/27 10:25 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 4.364 second response time [10:34:18] 2013/06/27 10:33 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.149 second response time [10:51:18] 2013/06/27 10:44 CRIT ortelius toolserver.org HTTP CRITICAL - Socket timeout after 10 seconds [10:52:19] 2013/06/27 10:51 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.175 second response time [11:15:43] hello all [12:27:02] [[Special:Log/newusers]] create 10 * Tine * (New user account) [12:33:39] [[Special:Log/newusers]] create 10 * Ravivictor007 * (New user account) [13:06:24] 2013/06/27 12:59 WARN z-dat-s2-b MySQL slave SLOW_SLAVE WARNING: Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 2083 [13:11:25] 2013/06/27 13:04 WARN wolfsbane / DISK WARNING - free space: / 6286 MB (20% inode=92%): [13:17:25] 2013/06/27 13:11 WARN wolfsbane /tmp DISK WARNING - free space: / 6191 MB (20% inode=92%): [13:49:26] 2013/06/27 13:48 OK z-dat-s2-b MySQL slave Uptime: 3389135 Threads: 11 Questions: 3170069669 Slow queries: 63107 Opens: 24359233 Flush tables: 1 Open tables: 256 Queries per second avg: 935.362 Slave IO: Yes Slave SQL: Yes Seconds Behind Master: 1773 [14:06:51] DaBPunkt, is it intentional that all VARBINARY has become VARCHAR on commonswiki_p? Cuz' its dragging down performance. [14:07:23] Dispenser: which server? [14:07:32] sql commonswiki_p [14:13:20] Dispenser: do you have an example for a field? [14:30:48] https://commons.wikimedia.org/w/index.php?title=User:Dispenser/Wrong_Extension&diff=94429346&oldid=93521608 [14:38:30] DaBPunkt: IIRC page.page_title = image.img_name had problems since the comparison was case insensitive. [14:38:32] Example http://commons.wikimedia.org/?diff=97585658 where img_name=transcode_image_name kept list [[File:CItation surfing from journal to Google Scholar - 1750-0680-6-1-S1.WMV.ogv]] when it had been moved [14:42:46] Dispenser: but img_name is a varbinary on all servers I checked [14:45:49] You're right, it just all the other tables on dephne that use VARCHAR which screws things up (e.g. page, transcode) [14:48:26] "Transcode errors" has an incorrect result on daphne but correct on z-dat-s5-b (dewiki server) [14:50:15] Dispenser: page.page_title is a VARCHAR on the wmf-servers too [14:52:25] I'm having trouble understand why they aren't having performance issue with that [14:53:21] no idea. maybe they convert it on the fly or never join these tables [14:56:24] I'm bring this up now since dschwen asked why his queries were all of a sudden running horribly slow. Could we change things back to the way they were before mid-March? [14:57:55] Dispenser: I’m not aware on any change in these fields. We just replicate the wmf-servers here [15:02:09] Something definitively changed (likely on WMF end) as according to mediawiki.org those fields are suppose to VARBINARY [15:41:32] 2013/06/27 15:34 WARN z-dat-s4-a /sql DISK WARNING - free space: /sql 67081 MB (10% inode=99%): [18:03:39] hi folks, is there some tool on TS to process xml files, large ones [18:04:27] I can't use lxml, because it is not installed :( [18:22:35] jonas_agx: create a bug in jira, I will install it tomorrow [18:22:58] thank you DaBPunkt !!! [18:23:38] np [19:02:47] 2013/06/27 19:01 OK wolfsbane / DISK OK - free space: / 10742 MB (35% inode=92%): [19:02:47] 2013/06/27 19:02 OK wolfsbane /tmp DISK OK - free space: / 10732 MB (35% inode=92%): [19:20:42] 2013/06/27 19:13 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 2.631 second response time [19:30:33] hay dab, are you still around? [19:32:50] DaBPunkt: ^ [19:33:01] yes [19:34:24] Can you do me a quick favor and 7z everything in my home dir (and sub directories) I want to back things up for mysekf [19:34:30] *myself [19:35:44] 2013/06/27 19:34 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.448 second response time [19:38:59] Betacommand: I can try [19:39:28] thanks [19:51:43] 2013/06/27 19:50 OK z-dat-s4-a /sql DISK OK - free space: /sql 68208 MB (11% inode=99%): [19:57:44] 2013/06/27 19:54 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 1.350 second response time [19:58:44] 2013/06/27 19:57 WARN ortelius toolserver.org HTTP HTTP WARNING: HTTP/1.1 200 OK - 239 bytes in 0.862 second response time [19:59:45] 2013/06/27 19:58 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.200 second response time [20:00:36] Betacommand: betacommand.tar.gz in your home for your service [20:05:50] DaBPunkt: thanks [20:12:45] 2013/06/27 20:10 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 1.072 second response time [20:13:45] 2013/06/27 20:13 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.265 second response time [20:51:47] 2013/06/27 20:51 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 1.132 second response time [20:52:47] 2013/06/27 20:52 WARN ortelius toolserver.org HTTP HTTP WARNING: HTTP/1.1 200 OK - 239 bytes in 0.852 second response time [20:55:48] 2013/06/27 20:55 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 1.510 second response time [20:56:48] 2013/06/27 20:56 WARN ortelius toolserver.org HTTP HTTP WARNING: HTTP/1.1 200 OK - 239 bytes in 0.788 second response time [20:58:48] 2013/06/27 20:58 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 1.272 second response time [20:59:48] 2013/06/27 20:59 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.224 second response time [21:06:48] 2013/06/27 21:06 WARN ortelius toolserver.org HTTP HTTP WARNING: HTTP/1.1 200 OK - 239 bytes in 0.725 second response time [21:08:49] 2013/06/27 21:08 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.337 second response time [21:20:49] 2013/06/27 21:20 CRIT ortelius toolserver.org HTTP HTTP CRITICAL: HTTP/1.1 200 OK - 239 bytes in 1.615 second response time [21:22:49] 2013/06/27 21:22 WARN ortelius toolserver.org HTTP HTTP WARNING: HTTP/1.1 200 OK - 239 bytes in 0.654 second response time [21:24:49] 2013/06/27 21:24 OK ortelius toolserver.org HTTP HTTP OK: HTTP/1.1 200 OK - 239 bytes in 0.158 second response time [21:57:46] @replag [21:57:46] stwalkerster: s1-rr-a-wd: 1w 2d 7h 26m 19s [-1.02 s/s]; s1-user-wd: 7h 57m 15s [-1.26 s/s]; s2-user-c: error; s2-user-wd: 6w 3d 16h 50m 29s [+1.00 s/s]; s3-user: 52s [+0.00 s/s]; s4-user-wd: 10w 4d 20h 50m 35s [+1.00 s/s]