Page MenuHomePhabricator
Paste Active Pastes
  • akosiaris@netmon1001:/srv/deployment/librenms/librenms$ git status
    On branch master
    Your branch and 'origin/master' have diverged,
    and have 5496 and 1 different commit each, respectively.
    (use "git pull" to merge the remote branch into yours)
    ...
    • May 5 2017, 8:53 AM
    • 121 Lines
  • hive (wmf)> select wiki_db, min(count), max(count), avg(count) from (select wiki_db, event_date, count(1) as count from (select wiki_db, substr(event_timestamp, 1, 8) as event_date from mediawiki_history where snapshot='2017
    -04' and cast(substr(event_timestamp, 1, 8) as int) > 20170000) x group by wiki_db, event_date) y group by wiki_db;
    Query ID = ebernhardson_20170504212525_47844c90-642f-451c-89b9-09b41f9fb5a3
    Total jobs = 1
    Launching Job 1 out of 1
    ...
    • May 4 2017, 9:28 PM
    • 765 Lines
  • [neodymium:~] $ sudo cumin -b 100 -s 5 '*' 'id syslog'
    1257 hosts will be targeted:
    acamar.wikimedia.org,achernar.wikimedia.org,alsafi.wikimedia.org,aluminium.wikimedia.org,analytics[1001-1003,1027-1068].eqiad.wmnet,aqs[1004-1009].eqiad.wmnet,argon.eqiad.wmnet,auth2001.codfw.wmnet,auth1001.eqiad.wmnet,baham.wikimedia.org,bast[1001,2001,3002,4001].wikimedia.org,bohrium.eqiad.wmnet,bromine.eqiad.wmnet,californium.wikimedia.org,cerium.eqiad.wmnet,chlorine.eqiad.wmnet,chromium.wikimedia.org,cobalt.wikimedia.org,conf[2001-2003].codfw.wmnet,conf[1001-1003].eqiad.wmnet,contint[1001,2001].wikimedia.org,copper.eqiad.wmnet,cp[2001-2026].codfw.wmnet,cp[1045-1055,1058-1068,1071-1074,1099].eqiad.wmnet,cp[3003-3008,3010,3030-3049].esams.wmnet,cp[4001-4021].ulsfo.wmnet,cp1008.wikimedia.org,d-i-test.eqiad.wmnet,darmstadtium.eqiad.wmnet,dataset1001.wikimedia.org,db[2010-2012,2016-2019,2023,2028-2030,2033-2092].codfw.wmnet,db[1001,1009,1011,1015-1016,1018,1020-1024,1026,1028-1031,1033-1041,1043-1056,1059-1097,1099,1101-1103].eqiad.wmnet,dbmonitor[1001,2001].wikimedia.org,dbproxy[1001-1011].eqiad.wmnet,dbstore[2001-2002].codfw.wmnet,dbstore[1001-1002].eqiad.wmnet,druid[1001-1003].eqiad.wmnet,dubnium.wikimedia.org,eeden.wikimedia.org,einsteinium.wikimedia.org,elastic[2001-2036].codfw.wmnet,elastic[1017-1052].eqiad.wmnet,es[2001-2004,2011-2019].codfw.wmnet,es[1011-1019].eqiad.wmnet,etcd[1001-1006].eqiad.wmnet,etherpad1001.eqiad.wmnet,eventlog2001.codfw.wmnet,eventlog1001.eqiad.wmnet,fermium.wikimedia.org,francium.eqiad.wmnet,ganeti[2001-2006].codfw.wmnet,ganeti[1001-1004].eqiad.wmnet,gerrit2001.wikimedia.org,graphite[2001-2002].codfw.wmnet,graphite[1001-1003].eqiad.wmnet,hafnium.eqiad.wmnet,hassaleh.codfw.wmnet,hassium.eqiad.wmnet,helium.eqiad.wmnet,heze.codfw.wmnet,hydrogen.wikimedia.org,install[1002,2002].wikimedia.org,iridium.eqiad.wmnet,iron.wikimedia.org,kafka[2001-2003].codfw.wmnet,kafka[1001-1003,1012-1014,1018,1020,1022].eqiad.wmnet,kraz.wikimedia.org,krypton.eqiad.wmnet,kubernetes[1001-1004].eqiad.wmnet,labcontrol[1001-1002].wikimedia.org,labmon1001.eqiad.wmnet,labnet[1001-1002].eqiad.wmnet,labnodepool1001.eqiad.wmnet,labsdb[1001,1003-1007,1009-1011].eqiad.wmnet,labservices[1001-1002].wikimedia.org,labstore[2001,2003-2004].codfw.wmnet,labstore[1001-1005].eqiad.wmnet,labtestcontrol2001.wikimedia.org,labtestnet2001.codfw.wmnet,labtestneutron2001.codfw.wmnet,labtestservices2001.wikimedia.org,labtestvirt[2001-2002].codfw.wmnet,labtestweb2001.wikimedia.org,labvirt[1001-1014].eqiad.wmnet,lithium.eqiad.wmnet,logstash[1001-1006].eqiad.wmnet,lvs[2001-2006].codfw.wmnet,lvs[1007-1012].eqiad.wmnet,lvs[3001-3004].esams.wmnet,lvs[4001-4004].ulsfo.wmnet,lvs[1001-1006].wikimedia.org,maerlant.wikimedia.org,maps[2001-2004].codfw.wmnet,maps[1001-1004].eqiad.wmnet,maps-test[2001-2004].codfw.wmnet,mc[2019-2036].codfw.wmnet,mc[1001-1036].eqiad.wmnet,meitnerium.wikimedia.org,mendelevium.eqiad.wmnet,mira.codfw.wmnet,ms1001.wikimedia.org,ms-be[2001-2039].codfw.wmnet,ms-be[1001-1039].eqiad.wmnet,ms-be[3001-3004].esams.wmnet,ms-fe[2005-2008].codfw.wmnet,ms-fe[1005-1008].eqiad.wmnet,ms-fe[3001-3002].esams.wmnet,multatuli.wikimedia.org,mw[2017,2097-2260].codfw.wmnet,mw[1161-1216,1218-1290,1293-1306].eqiad.wmnet,mwdebug[1001-1002].eqiad.wmnet,mwlog2001.codfw.wmnet,mwlog1001.eqiad.wmnet,mwreleases1001.eqiad.wmnet,mx[1001,2001].wikimedia.org,naos.codfw.wmnet,neodymium.eqiad.wmnet,nescio.wikimedia.org,netmon[1001-1002].wikimedia.org,nihal.codfw.wmnet,nitrogen.eqiad.wmnet,notebook[1001-1002].eqiad.wmnet,ocg[1001-1003].eqiad.wmnet,oresrdb[2001-2002].codfw.wmnet,oresrdb[1001-1002].eqiad.wmnet,osmium.eqiad.wmnet,oxygen.eqiad.wmnet,pc[2004-2006].codfw.wmnet,pc[1004-1006].eqiad.wmnet,phab2001.codfw.wmnet,planet2001.codfw.wmnet,planet1001.eqiad.wmnet,pollux.wikimedia.org,poolcounter[1001-1002].eqiad.wmnet,praseodymium.eqiad.wmnet,prometheus[2003-2004].codfw.wmnet,prometheus[1003-1004].eqiad.wmnet,puppetmaster[2001-2002].codfw.wmnet,puppetmaster[1001-1002].eqiad.wmnet,pybal-test[2001-2003].codfw.wmnet,radium.wikimedia.org,radon.wikimedia.org,rcs[1001-1002].eqiad.wmnet,rdb[2001-2006].codfw.wmnet,rdb[1001-1008].eqiad.wmnet,relforge[1001-1002].eqiad.wmnet,restbase[2001-2012].codfw.wmnet,restbase[1007-1018].eqiad.wmnet,restbase-dev[1001-1003].eqiad.wmnet,restbase-test[2001-2003].codfw.wmnet,rhenium.wikimedia.org,rhodium.eqiad.wmnet,roentgenium.eqiad.wmnet,ruthenium.eqiad.wmnet,rutherfordium.eqiad.wmnet,sarin.codfw.wmnet,sca[2003-2004].codfw.wmnet,sca[1003-1004].eqiad.wmnet,scb[2001-2006].codfw.wmnet,scb[1001-1004].eqiad.wmnet,seaborgium.wikimedia.org,serpens.wikimedia.org,silver.wikimedia.org,snapshot[1001,1005-1007].eqiad.wmnet,sodium.wikimedia.org,stat[1002-1004].eqiad.wmnet,subra.codfw.wmnet,suhail.codfw.wmnet,tegmen.wikimedia.org,tempdb2001.codfw.wmnet,terbium.eqiad.wmnet,thorium.eqiad.wmnet,thumbor[1001-1002].eqiad.wmnet,tin.eqiad.wmnet,tungsten.eqiad.wmnet,tureis.codfw.wmnet,ununpentium.wikimedia.org,uranium.wikimedia.org,wasat.codfw.wmnet,wdqs[2001-2003].codfw.wmnet,wdqs[1001-1003].eqiad.wmnet,wezen.codfw.wmnet,wtp[2001-2020].codfw.wmnet,wtp[1001-1024].eqiad.wmnet,xenon.eqiad.wmnet,zosma.codfw.wmnet
    Confirm to continue [y/n]? y
    ===== NODE GROUP =====
    ...
    • May 4 2017, 8:29 PM
    • 39 Lines
  • cassandra@cqlsh> show session fa7edbb0-30ae-11e7-b126-b9bcb1f4f467;
    Tracing session: fa7edbb0-30ae-11e7-b126-b9bcb1f4f467
    activity | timestamp | source | source_elapsed | client
    ...
    • May 4 2017, 8:24 PM
    • 43 Lines
  • mwscript sql.php --wiki eswiktionary --cluster extension1 --wikidb cognate_wiktionary --replicadb any --query="SHOW TABLES;"
    stdClass Object
    (
    [Tables_in_cognate_wiktionary] => cognate_pages
    )
    ...
    • May 4 2017, 1:57 PM
    • 13 Lines
  • # you can append the following code to your config2.py module for testing
    mycode = 'mycode' or mylang
    ...
    • May 4 2017, 12:38 PM
    • 25 Lines
    • Python
  • $:acko\> diff -dipu0 gerrit.list github.list | egrep '^[+-]'
    --- gerrit.list 2017-05-04 12:55:01.216117052 +0200
    +++ github.list 2017-05-04 12:43:44.289274339 +0200
    -3d2png-deploy
    +AFNetworking
    ...
    • May 4 2017, 10:58 AM
    • 480 Lines
  • date: 2017-05-04T10:47:42+00:00
    tool: pageviews
    language: de
    chart: bar
    ...
    • May 4 2017, 10:47 AM
    • 18 Lines
  • root@PRODUCTION x1[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | tempdb2001 |
    ...
    • May 4 2017, 6:20 AM
    • 55 Lines
  • |1|mr96ncUVquOccX45cV5eJgJmMto=|fTz8Qek7t7rHTTUwNd4jlZzuA8c= ecdsa-sha2-nistp256 AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBGs74V0LaOXLN2zqa+wZgSziUrBmc5nTN1X+EBqIVY6v2LMyxXBXJ4k+BKm5n51lLYGhr+iygVVVMRYXWeiNqtg=
    |1|307Mf25a48jG7A8k9X7p1mxUXko=|m29JXn9wlHmhGwL6/7CUAMOaAP4= ecdsa-sha2-nistp256 AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBGs74V0LaOXLN2zqa+wZgSziUrBmc5nTN1X+EBqIVY6v2LMyxXBXJ4k+BKm5n51lLYGhr+iygVVVMRYXWeiNqtg=
    |1|sQj3Qv4SAg6XQsZ358nyEg+k+Go=|reo+oJiMg8kIRzlFQS6IMi09AwA= ecdsa-sha2-nistp256 AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBCSyFsBAw7UBZCSKyrealtJjGcHM2cv/yNKVRX1USMAo7Ofer2nF/HbM3gCp08Yr3xEs3vAGDuTAxnwmW+7lWlo=
    |1|bzyQVpCG/2mex0UbAfgWqhaniys=|Wvv0kcMnj0ydXQQ6jJcYhx2Ce7Y= ecdsa-sha2-nistp256 AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBCSyFsBAw7UBZCSKyrealtJjGcHM2cv/yNKVRX1USMAo7Ofer2nF/HbM3gCp08Yr3xEs3vAGDuTAxnwmW+7lWlo=
    |1|j3X0MtD5xu0bzCzClkRca7dssa8=|qap2zB/7hUC/mrJ/0ZVgt/wKq4s= ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAq2A7hRGmdnm9tUDbO9IDSwBK6TbQa+PXYPCPy6rbTrTtw7PHkccKrpp0yVhp5HdEIcKr6pLlVDBfOLX9QUsyCOV0wzfjIJNlGEYsdlLJizHhbn2mUjvSAHQqZETYP81eFzLQNnPHt4EVVUh7VfDESU84KezmD5QlWpXLmvU31/yMf+Se8xhHTvKSCZIFImWwoG6mbUoWf9nzpIoaSjB+weqqUUmpaaasXVal72J+UX2B+2RPW3RcT0eOzQgqlJL3RKrTJvdsjE3JEAvGq3lGHSZXy28G3skua2SmVi/w4yCE6gbODqnTWlg7+wC604ydGXA8VJiS5ap43JXiUFFAaQ==
    ...
    • May 3 2017, 7:11 PM
    • 7 Lines
  • [05/03/17 19:06:51] [SSH] Opening SSH connection to jenkins-slave-01:22.
    [05/03/17 19:06:51] [SSH] The SSH key presented by the remote host does not match the key saved in the Known Hosts file against this host. Connections to this host will be denied until the two keys match.
    Key exchange was not finished, connection is closed.
    java.io.IOException: There was a problem while connecting to jenkins-slave-01:22
    at com.trilead.ssh2.Connection.connect(Connection.java:834)
    ...
    • May 3 2017, 7:07 PM
    • 26 Lines
  • hive (default)> add jar hdfs://analytics-hadoop/wmf/refinery/current/artifacts/refinery-hive.jar;
    hive (default)> create temporary function stemmer as 'org.wikimedia.analytics.refinery.hive.StemmerUDF';
    hive (default)> select
    wikiid,
    count(distinct norm_query) as all_distinct_norm_q,
    ...
    • May 3 2017, 7:06 PM
    • 24 Lines
  • Error creating thumbnail: '/usr/bin/ffmpeg' -threads 1 -ss 140 -y -i 'http://ms-fe.svc.eqiad.wmnet/v1/AUTH_mw/wikipedia-commons-local-public.6a/6/6a/Templeborough_Roman_Fort_visualised_3D_flythrough_-_Rotherham.webm?temp_url_sig=d142b543bb9c30f72565baf5e54804a296efdd61&temp_url_expires=1493916574' -ss 3 -s 1280x768 -f mjpeg -an -vframes 1 '/tmp/transform_891dd1521048.jpg' 2>&1 wgMaxShellMemory: 1048576 ffmpeg version 3.0.2-2~bpo8+1 Copyright (c) 2000-2016 the FFmpeg developers built with gcc 4.9.2 (Debian 4.9.2-10) configuration: --prefix=/usr --extra-version='2~bpo8+1' --toolchain=hardened --libdir=/usr/lib/x86_64-linux-gnu --incdir=/usr/include/x86_64-linux-gnu --cc=cc --cxx=g++ --enable-gpl --enable-shared --disable-stripping --disable-decoder=libopenjpeg --disable-decoder=libschroedinger --enable-avresample --enable-avisynth --enable-gnutls --enable-ladspa --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libcdio --enable-libflite --enable-libfontconfig --enable-libfreetype...
    • May 3 2017, 4:50 PM
    • 1 Line
  • #0 /srv/mediawiki/php-1.29.0-wmf.21/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
    #1 /srv/mediawiki/php-1.29.0-wmf.21/includes/libs/rdbms/database/Database.php(1269): Wikimedia\Rdbms\Database->query(string, string)
    #2 /srv/mediawiki/php-1.29.0-wmf.21/includes/pager/IndexPager.php(368): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
    #3 /srv/mediawiki/php-1.29.0-wmf.21/includes/pager/IndexPager.php(225): IndexPager->reallyDoQuery(string, integer, boolean)
    #4 /srv/mediawiki/php-1.29.0-wmf.21/includes/logging/LogPager.php(428): IndexPager->doQuery()
    ...
    • May 3 2017, 3:26 PM
    • 16 Lines
  • https://commons.wikimedia.org/wiki/Template:Cc-by-1.0-fi,https://creativecommons.org/licenses/by/1.0/fi/deed.en
    https://commons.wikimedia.org/wiki/Template:Cc-by-1.0-il,https://creativecommons.org/licenses/by/1.0/il/deed.en
    https://commons.wikimedia.org/wiki/Template:Cc-by-1.0-nl,https://creativecommons.org/licenses/by/1.0/nl/deed.en
    https://commons.wikimedia.org/wiki/Template:Cc-by-2.0-at,https://creativecommons.org/licenses/by/2.0/at/deed.en
    https://commons.wikimedia.org/wiki/Template:Cc-by-2.0-au,https://creativecommons.org/licenses/by/2.0/au/deed.en
    ...
    • May 3 2017, 12:37 PM
    • 186 Lines
  • MediaWiki:Collapserefs.js (abwiki)
    MediaWiki:Common.js (abwiki)
    MediaWiki:Editpage.js (abwiki)
    MediaWiki:Group-sysop.js (abwiki)
    MediaWiki:Mainpage.js (abwiki) | Skipped (Does not use mw.loader or mediaWiki.loader). Loading next subject...
    ...
    • May 3 2017, 1:36 AM
    • 935 Lines
  • Using credentials from /Users/krinkle/.config/tourbot/.mwauth.json for Krinkle@KrinkleMigrate
    Reading /Users/krinkle/Development/tmp/mwgrep.util.nonRL.txt
    MediaWiki:Collapserefs.js (abwiki)
    ...
    • May 3 2017, 1:33 AM
    • 3,258 Lines
  • abwiki MediaWiki:Collapserefs.js
    abwiki MediaWiki:Common.js
    abwiki MediaWiki:Editpage.js
    abwiki MediaWiki:Gadget-markblocked.js
    abwiki MediaWiki:Group-sysop.js
    ...
    • May 3 2017, 12:37 AM
    • 3,735 Lines
  • gerrit2@cobalt /var/lib/gerrit2/review_site$ ssh -vvv -4 gerrit2001.wikimedia.org
    OpenSSH_6.7p1 Debian-5+deb8u3, OpenSSL 1.0.2k 26 Jan 2017
    debug1: Reading configuration data /etc/ssh/ssh_config
    debug1: /etc/ssh/ssh_config line 19: Applying options for *
    debug2: ssh_connect: needpriv 0
    ...
    • May 2 2017, 10:48 PM
    • 121 Lines
  • Started by upstream project "selenium-GettingStarted" build number 386
    originally caused by:
    Started by user mattflaschen
    Building remotely on saucelabs-03 (BrowserTests) in workspace /srv/jenkins-workspace/workspace/selenium-GettingStarted/BROWSER/firefox/MEDIAWIKI_ENVIRONMENT/beta/PLATFORM/Linux/label/BrowserTests
    Using checkout strategy: Default
    ...
    • May 2 2017, 7:09 PM
    • 210 Lines
  • cassandra@cqlsh> show session 5cea2d40-2ea2-11e7-b2f5-fb01042a29f3;
    Tracing session: 5cea2d40-2ea2-11e7-b2f5-fb01042a29f3
    activity | timestamp | source | source_elapsed | client
    ...
    • May 2 2017, 4:49 PM
    • 34 Lines
  • # This file is managed by puppet!
    # Package generated configuration file
    # See the sshd_config(5) manpage for details
    # What ports, IPs and protocols we listen for
    ...
    • May 2 2017, 4:03 PM
    • 107 Lines
  • add jar hdfs://analytics-hadoop/wmf/refinery/current/artifacts/refinery-hive.jar;
    create temporary function stemmer as 'org.wikimedia.analytics.refinery.hive.StemmerUDF';
    select
    wikiid,
    ...
    • May 2 2017, 12:31 AM
    • 21 Lines
  • import regex
    import pathlib
    JOB_ID_SEARCH = regex.compile('(?<=\nJob id: )\d+').search
    ...
    • May 1 2017, 7:49 PM
    • 109 Lines
    • Python
  • [phab2001:~] $ systemctl status phd
    ● phd.service - phabricator-phd
    Loaded: loaded (/etc/systemd/system/phd.service; enabled)
    Active: inactive (dead) since Mon 2017-05-01 17:02:15 UTC; 5min ago
    Process: 38284 ExecStop=/srv/phab/phabricator/bin/phd stop --force (code=exited, status=0/SUCCESS)
    ...
    • May 1 2017, 5:06 PM
    • 33 Lines
  • <!DOCTYPE html>
    <html class="content-ltr ui-ltr page-protected">
    <head>
    <meta charset="UTF-8">
    ...
    • May 1 2017, 3:46 PM
    • 1,184 Lines
    • HTML
  • * Get all instances
    * Get all labvirts
    ...
    • May 1 2017, 3:45 PM
    • 8 Lines
  • ` `
    ```..---.----...`````
    ``..-::////++///////++////::--.```
    `````.://///////:::::::::::::://///////::.```
    ...
    • May 1 2017, 3:15 PM
    • 47 Lines
  • date: 2017-05-01T03:54:00+00:00
    tool: pageviews
    language: zh-tw
    chart: bar
    ...
    • May 1 2017, 3:53 AM
    • 17 Lines
  • $ git log 1.28.1..1.28.2 --oneline
    438c3d6c41 Merge "Bump version to 1.28.2 for new point release" into REL1_28
    f928f0269c Bump version to 1.28.2 for new point release
    d472f96e8a Merge "Replace use of &$this" into REL1_28
    6a98aae85e Replace use of &$this
    ...
    • Apr 30 2017, 8:07 PM
    • 19 Lines
  • root@mediawiki-vagrant:/var/log# df -Th
    Filesystem Type Size Used Avail Use% Mounted on
    /dev/sda1 ext4 9.2G 8.8G 0 100% /
    udev devtmpfs 10M 0 10M 0% /dev
    tmpfs tmpfs 590M 52M 538M 9% /run
    ...
    • Apr 28 2017, 10:15 PM
    • 88 Lines
  • /admin1/system1/logs1/log1/record1-> show
    properties
    CreationTimestamp = 20170428132613.000000-300
    ElementName = System Event Log Entry
    ...
    • Apr 28 2017, 4:56 PM
    • 8 Lines
  • $ cat pixel_count_avgsize |grep -v '146.2784580498866' | awk '{print $1 " " $2}' | ~/.local/bin/histogram.py -A --max 5000 -p
    # NumSamples = 82942062200; Min = 0.00; Max = 5000.00
    # 830617 values outside of min/max
    # Mean = inf; Variance = inf; SD = inf; Median 5227.000000
    # each ∎ represents a count of 1054729691
    ...
    • Apr 28 2017, 3:14 PM
    • 47 Lines
  • Error: Could not retrieve catalog from remote server: Error 400 on SERVER: create_resources(): second argument must be a hash at /etc/puppet/modules/scap/manifests/dsh.pp:33 on node phab-tin.phabricator.eqiad.wmflabs
    • Apr 28 2017, 2:28 PM
    • 1 Line
  • puppetmaster1001 0 ~$ dig db1061.eqiad.wmnet
    ; <<>> DiG 9.9.5-9+deb8u10-Debian <<>> db1061.eqiad.wmnet
    ;; global options: +cmd
    ;; Got answer:
    ...
    • Apr 28 2017, 2:25 PM
    • 41 Lines
  • root@neodymium:/home/marostegui/git/software/dbtools# host db1061
    db1061.eqiad.wmnet has address 10.64.48.14
    root@neodymium:/home/marostegui/git/software/dbtools# host db1061
    db1061.eqiad.wmnet has address 10.64.32.227
    root@neodymium:/home/marostegui/git/software/dbtools# host db1061
    ...
    • Apr 28 2017, 2:09 PM
    • 6 Lines
  • Hello,
    I am Paul Norman, a contractor working with the Maps team on Discovery at improving the Wikimedia map styles, infrastructure, and other map-related tasks. My background is as an OpenStreetMap developer, and I am a maintainer of the OpenStreetMap Carto style, the default on osm.org, as well as many other components in a standard OSM map rendering setup.
    As part of https://phabricator.wikimedia.org/T153282 a new style for
    ...
    • Apr 27 2017, 10:52 PM
    • 39 Lines
    • Plain Text
  • ### INSERT INTO `wikidatawiki`.`wb_terms`
    ### SET
    ### @1=954321060 /* LONGINT meta=0 nullable=0 is_null=0 */
    ### @2=20755174 /* INT meta=0 nullable=0 is_null=0 */
    ### @3='item' /* VARSTRING(32) meta=32 nullable=0 is_null=0 */
    ...
    • Apr 27 2017, 4:41 PM
    • 10 Lines
  • +--------+-------+----------+-------------------+---------------------+----------------+
    | JobId | Level | JobFiles | JobBytes | StartTime | VolumeName |
    +--------+-------+----------+-------------------+---------------------+----------------+
    | 52,105 | F | 2,732 | 1,861,922,046,944 | 2017-04-20 05:29:30 | production0015 |
    | 52,105 | F | 2,732 | 1,861,922,046,944 | 2017-04-20 05:29:30 | production0017 |
    ...
    • Apr 27 2017, 2:19 PM
    • 9 Lines
  • root@PRODUCTION es3[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | es1014 |
    ...
    • Apr 27 2017, 6:57 AM
    • 55 Lines
  • CREATE TABLE `hashs` (
    `hs_nstitle` varbinary(48) DEFAULT NULL,
    `hs_timestamp` varbinary(14) DEFAULT NULL,
    `hs_old_id` int(8) unsigned DEFAULT NULL,
    `hs_hash` varbinary(48) DEFAULT NULL,
    ...
    • Apr 27 2017, 6:35 AM
    • 9 Lines
  • date: 2017-04-26T21:10:20+00:00
    tool: pageviews
    language: en
    chart: bar
    ...
    • Apr 26 2017, 9:10 PM
    • 28 Lines
  • class shiny_server {
    $essentials = [
    'gfortran', 'g++-4.8', 'gfortran-4.8',
    'libssl-dev', 'libcurl4-openssl-dev', 'libxml2-dev', 'libssh2-1-dev',
    ...
    • Apr 26 2017, 8:08 PM
    • 140 Lines
    • Ruby
  • import numpy as np
    import matplotlib.pyplot as plt
    source = list(np.log(np.arange(1,1000))/np.log(1000))
    result = [1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,7.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,9.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,10.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,14.0,14.0,14.0,14.0,14.0,14.0,14.0,14.0,14.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0,15.0,16.0,16.0,16.0,16.0,16.0,16.0,16.0,17.0,17.0,17.0,17.0,17.0,17.0,18.0,18.0,18.0,18.0,18.0,19.0,19.0,19.0,19.0,19.0,20.0,20.0,20.0,20.0,21.0,21.0,21.0,21.0,22.0,22.0,22.0,23.0,23.0,23.0,24.0,24.0,24.0,25.0,25.0,25.0,26.0,26.0,27.0,27.0,28.0,28.0,29.0,29.0,30.0,30.0,31.0,32.0,32.0,33.0,34.0,35.0,36.0,36.0,37.0,38.0,40.0,41.0,42.0,43.0,45.0,46.0,48.0,49.0,51.0,54.0,56.0,58.0,61.0,64.0,68.0,72.0,77.0,82.0,88.0,97.0,106.0,119.0,137.0,161.0,204.0,296.0]
    ...
    • Apr 26 2017, 4:03 PM
    • 12 Lines
  • From: Tilman Bayer <tbayer@wikimedia.org>
    Date: Fri, 1 Nov 2013 02:55:49 -0700
    Message-ID: <CAPDdKA6dv_bv5qFezGpBLygE46TyvV8A3CZv53SZDPiDgyJq3A@mail.gmail.com>
    To: wikimediaannounce-l@lists.wikimedia.org
    X-Mailman-Approved-At: Fri, 01 Nov 2013 09:57:17 +0000
    ...
    • Apr 26 2017, 2:47 PM
    • 48 Lines
    • Plain Text
  • date: 2017-04-26T10:06:56+00:00
    tool: pageviews
    language: ar
    chart: bar
    ...
    • Apr 26 2017, 10:06 AM
    • 17 Lines
  • date: 2017-04-26T00:17:57+00:00
    tool: pageviews
    language: de
    chart: bar
    ...
    • Apr 26 2017, 12:17 AM
    • 24 Lines
  • Gaisoumibcgi28
    Mimikellimaagoo 75
    Xanaxcasscool
    Athalietem200
    Dominumachour35
    ...
    • Apr 25 2017, 11:55 PM
    • 34 Lines
  • INFO global: Vagrant version: 1.8.5
    INFO global: Ruby version: 2.2.3
    INFO global: RubyGems version: 2.4.5.1
    INFO global: VAGRANT_LOG="debug"
    INFO global: VAGRANT_OLD_ENV_COMPIZ_CONFIG_PROFILE="ubuntu"
    ...
    • Apr 25 2017, 11:46 PM
    • 47,639 Lines
  • ```root@tools-exec-1434:~# puppet agent --test
    Info: Retrieving plugin
    Info: Loading facts in /var/lib/puppet/lib/facter/service_provider.rb
    Info: Loading facts in /var/lib/puppet/lib/facter/interface_primary.rb
    Info: Loading facts in /var/lib/puppet/lib/facter/facter_dot_d.rb
    ...
    • Apr 25 2017, 8:15 PM
    • 82 Lines
  • Apr 25 18:49:52 labstore1005 systemd[1]: Starting NFS exports daemon...
    Apr 25 18:49:52 labstore1005 systemd[1]: Started NFS exports daemon.
    Apr 25 18:49:53 labstore1005 nfs-exportd[135188]: 2017-04-25 18:49:53,257 INFO found 2 public NFS exports
    Apr 25 18:49:53 labstore1005 nfs-exportd[135188]: 2017-04-25 18:49:53,275 INFO Starting new HTTP connection (1): labcontrol1001.wikimedia.org
    Apr 25 18:49:53 labstore1005 nfs-exportd[135188]: 2017-04-25 18:49:53,397 INFO Starting new HTTP connection (1): labnet1001.eqiad.wmnet
    ...
    • Apr 25 2017, 6:55 PM
    • 85 Lines
  • ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDgjynrQCEXg2nQMZSAEGiXo8sAtLJMbWFB52ylg+ZqeJuesQ5z0zySj9/pX7xvc5a5HBzOwpT72thhdnoQCV9s52hC98tSQY2YzPlybu3tltM7WNzfoKboMfQ2aZHbi+bcTZEjvzwc+6h5dMZvCwmSUva8fAPfyPvnuV0AegNksbG1PInSyOD4pbfXf9y6QfZcJWyzV+Q+7hFlKmSNT53If06qFRAWW8ZgcMi9k//jC2fpn7P2CHKe4w0oz1yVZUgDLUyBwYECPtsbfw+xcrbFlfyoEmP1yLbolgFo/pZfNd7mGS4MrRhBPMEaMXMm34901/d1kJpztVqO/MTwAjO5 jmorgan@wikimedia.org
    • Apr 25 2017, 6:23 PM
    • 1 Line
  • 58f8bf1845105
    User 58f8c2fa0dea40.95147457
    158f8eff845374371143
    158f8f030ac64a308413
    158f8f04ae0a9b319648
    ...
    • Apr 25 2017, 5:05 PM
    • 302 Lines
  • root@PRODUCTION s7[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | db1041 |
    ...
    • Apr 25 2017, 8:27 AM
    • 63 Lines
  • +-------------+----------------+------------------+---------------+-------------+-------------------------------------+-------------------------------------+-------------+
    | term_row_id | term_entity_id | term_entity_type | term_language | term_type | term_text | term_search_key | term_weight |
    +-------------+----------------+------------------+---------------+-------------+-------------------------------------+-------------------------------------+-------------+
    | 28915 | 286 | item | it | label | ABC | abc | 0 |
    | 28913 | 286 | item | it | label | ABC | abc | 0 |
    ...
    • Apr 25 2017, 2:49 AM
    • 4,299 Lines
  • chad@notsexy /a/java/gerrit (master)$ git log --author=Chad --oneline
    9e34a7d7f6 Increase diff font size to 9pt
    fcfa425097 Provide direct link to REST API documentation
    1dfe36c9b2 Add gitweb.linkDrafts to control if gitweb links are shown on drafts
    ca708a8217 Removing 2 unused imports
    ...
    • Apr 24 2017, 9:23 PM
    • 42 Lines
  • Revisions:
    curl -H 'Content-Type: application/json' -X POST -d '{"domain": "mlebtesting-stable.wmflabs.org.", "backends": ["http://10.68.22.54:80"]}' localhost:5668/v1/language/mapping/mlebtesting-stable.wmflabs.org.
    curl -H 'Content-Type: application/json' -X POST -d '{"domain": "language-dev.wmflabs.org.", "backends": ["http://10.68.18.8:80"]}' localhost:5668/v1/language/mapping/language-dev.wmflabs.org.
    curl -H 'Content-Type: application/json' -X POST -d '{"domain": "cxserver-dev.wmflabs.org.", "backends": ["http://10.68.18.8:8080"]}' localhost:5668/v1/language/mapping/cxserver-dev.wmflabs.org.
    curl -H 'Content-Type: application/json' -X POST -d '{"domain": "mlebtesting.wmflabs.org.", "backends": ["http://10.68.22.180:80"]}' localhost:5668/v1/language/mapping/mlebtesting.wmflabs.org.
    ...
    • Apr 24 2017, 7:31 PM
    • 302 Lines
    • Bash Scripting
  • HEAD is now at da787d1... lxc: new box image
    nemobis@nemobis:/srv/mediawiki-vagrant$ vagrant up
    Bringing machine 'default' up with 'lxc' provider...
    ==> default: Box 'fgrehm/trusty64-lxc' could not be found. Attempting to find and install...
    default: Box Provider: lxc
    ...
    • Apr 24 2017, 3:15 PM
    • 665 Lines
    • Plain Text
  • BEGIN BATCH
    DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:DeltaQuad/UAA/Wait';
    DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:DeltaQuad/UAA/Wait';
    DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:DeltaQuad/UAA/Wait';
    DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Administrators''_noticeboard/Incidents';
    ...
    • Apr 24 2017, 1:29 PM
    • 20 Lines
  • mysql:wikiadmin@db1072 [enwiki]> describe SELECT oresc_id FROM `ores_classification` LEFT JOIN `ores_model` ON ((oresm_id = oresc_model)) LEFT JOIN `recentchanges` ON ((oresc_rev = rc_this_oldid)) WHERE (oresm_name = 'damaging' OR oresm_name IS NULL) AND rc_this_oldid IS NULL LIMIT 1000;
    +------+-------------+---------------------+--------+---------------+---------+---------+----------------------------------------+----------+--------------------------------------+
    | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
    +------+-------------+---------------------+--------+---------------+---------+---------+----------------------------------------+----------+--------------------------------------+
    | 1 | SIMPLE | ores_classification | ALL | NULL | NULL | NULL | NULL | 98339198 | |
    ...
    • Apr 24 2017, 12:44 PM
    • 13 Lines
  • root@PRODUCTION s7[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | db1062 |
    ...
    • Apr 24 2017, 9:18 AM
    • 55 Lines
  • diff --git a/bin/varnishd/cache/cache.h b/bin/varnishd/cache/cache.h
    index c03570389..da9ba22aa 100644
    --- a/bin/varnishd/cache/cache.h
    +++ b/bin/varnishd/cache/cache.h
    @@ -824,14 +824,15 @@ extern pthread_key_t witness_key;
    ...
    • Apr 24 2017, 8:52 AM
    • 92 Lines
  • /mediawiki/extensions/TestGlobals/extension.json:
    {
    "name": "TestGlobals",
    "manifest_version": 1
    }
    ...
    • Apr 23 2017, 11:12 AM
    • 64 Lines
    • PHP
  • date: 2017-04-22T14:45:23+00:00
    tool: pageviews
    language: zh-tw
    chart: bar
    ...
    • Apr 22 2017, 2:45 PM
    • 17 Lines
  • date: 2017-04-22T14:31:10+00:00
    tool: pageviews
    language: zh-tw
    chart: bar
    ...
    • Apr 22 2017, 2:31 PM
    • 17 Lines
  • date: 2017-04-22T14:19:23+00:00
    tool: pageviews
    language: zh-tw
    chart: bar
    ...
    • Apr 22 2017, 2:19 PM
    • 17 Lines
  • date: 2017-04-22T14:16:48+00:00
    tool: pageviews
    language: zh-tw
    chart: bar
    ...
    • Apr 22 2017, 2:16 PM
    • 17 Lines
  • date: 2017-04-22T13:56:06+00:00
    tool: pageviews
    language: zh-tw
    chart: bar
    ...
    • Apr 22 2017, 1:56 PM
    • 17 Lines
  • $ cat *.dblist | while read db; do mysql -BN -A -h es2019.codfw.wmnet $db -e "SELECT '$db', max(blob_id) FROM blobs_cluster25"; done
    enwiki 137353196
    bgwiki 1424466
    bgwiktionary 33930
    cswiki 3085923
    ...
    • Apr 22 2017, 8:12 AM
    • 900 Lines
  • diff --git a/bin/varnishd/cache/cache_fetch.c b/bin/varnishd/cache/cache_fetch.c
    index 8cb14fe1b..b3a233fb2 100644
    --- a/bin/varnishd/cache/cache_fetch.c
    +++ b/bin/varnishd/cache/cache_fetch.c
    @@ -501,6 +501,9 @@ vbf_fetch_body_helper(struct busyobj *bo)
    ...
    • Apr 21 2017, 5:55 PM
    • 14 Lines
  • root@neodymium:~$ mysql -h db2023.codfw.wmnet -e "SELECT * FROM sys.schema_index_statistics WHERE table_schema='wikidatawiki' and table_name='wb_terms' and index_name IN ('wb_terms_entity_type', 'wb_terms_type')"
    +--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
    | table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency |
    +--------------+------------+----------------------+---------------+----------------+---------------+----------------+--------------+----------------+--------------+----------------+
    | wikidatawiki | wb_terms | wb_terms_entity_type | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
    ...
    • Apr 21 2017, 12:13 PM
    • 42 Lines
  • root@PRODUCTION s5[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | db1071 |
    ...
    • Apr 21 2017, 7:49 AM
    • 55 Lines
  • root@db2070.codfw.wmnet[sys]> SELECT * FROM schema_index_statistics WHERE table_name='revision' AND index_name='page_user_timestamp'\G
    *************************** 1. row ***************************
    table_schema: enwiki
    table_name: revision
    index_name: page_user_timestamp
    ...
    • Apr 21 2017, 7:03 AM
    • 14 Lines
  • $ vagrant roles enable visualeditor
    Ok. Run `vagrant provision` to apply your changes.
    Note the following settings have changed and your environment will be reloaded.
    forward_ports: {} -> { 1970: 1970, 7231: 7231, 8000: 8000 }
    ...
    • Apr 21 2017, 12:42 AM
    • 1,707 Lines
  • ALTER TABLE image
    DROP INDEX img_sha1,
    ADD INDEX img_sha1 (img_sha1(10));
    ALTER TABLE oldimage
    ...
    • Apr 20 2017, 11:55 PM
    • 7 Lines
    • SQL
  • root@tools-proxy-02:/var/log/nginx# strace -p19897
    Process 19897 attached
    epoll_wait(17, {{EPOLLIN|EPOLLOUT, {u32=1505799664, u64=140077569191408}}}, 512, 3577223) = 1
    recvfrom(109, "\201\0032::", 4096, 0, NULL, NULL) = 5
    write(48, "\27\3\3\0\25W\212\10\n\25\332\264\371\370+j\304n\237\364,{d\352N\300", 26) = 26
    ...
    • Apr 20 2017, 4:51 PM
    • 25 Lines
  • <!DOCTYPE html>
    <html class="content-ltr ui-ltr page-protected">
    <head>
    <meta charset="UTF-8">
    ...
    • Apr 20 2017, 4:46 PM
    • 1,218 Lines
    • HTML
  • restbase1007.eqiad.wmnet: 8963
    restbase1007.eqiad.wmnet: 8890
    restbase1007.eqiad.wmnet: 9149
    restbase1010.eqiad.wmnet: 8744
    restbase1010.eqiad.wmnet: 8593
    ...
    • Apr 20 2017, 3:55 PM
    • 69 Lines
  • root@PRODUCTION s4[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | db1081 |
    ...
    • Apr 20 2017, 2:00 PM
    • 54 Lines
  • FROM debian:jessie-slim AS test
    USER root
    WORKDIR /srv
    RUN apt-get update && apt-get install -y libjpeg libyaml chromium libjpeg-dev libyaml-dev && rm -rf /var/lib/apt/lists/*
    RUN mkdir -p /srv/service
    ...
    • Apr 19 2017, 6:48 PM
    • 21 Lines
    • Docker
  • root@db2069.codfw.wmnet[enwiki]> EXPLAIN SELECT /* AFComputedVariable::{closure} */ rev_user_text FROM `revision` WHERE rev_page = '1743794' ORDER BY rev_timestamp DESC LIMIT 100\G
    *************************** 1. row ***************************
    id: 1
    select_type: SIMPLE
    table: revision
    ...
    • Apr 19 2017, 5:06 PM
    • 28 Lines
  • <!DOCTYPE html>
    <html class="content-ltr ui-ltr page-protected">
    <head>
    <meta charset="UTF-8">
    ...
    • Apr 19 2017, 5:03 PM
    • 1,987 Lines
    • HTML
  • varnishtest "Test hit for pass obj size"
    server s1 {
    rxreq
    expect req.url == "/foo"
    ...
    • Apr 19 2017, 5:01 PM
    • 32 Lines
  • UTC+3
    [18:13:02] @paravoid> so who can help debug the contenttranslation issue?
    [18:13:07] @paravoid> anyone from the language team around?
    [18:13:20] akosiaris> Nikerabbit: ^
    [18:13:21] @paravoid> Nikerabbit: ?
    ...
    • Apr 19 2017, 4:23 PM
    • 206 Lines
  • 08:28 yuvipanda: [16:10] bd808: ldap.yaml, ldap.conf and novaobserver.yaml now present in all containers
    08:28 yuvipanda: [16:10] \o/
    08:28 yuvipanda: [16:20] lol, kube-proxy is failing and I've no idea why
    08:28 yuvipanda: [16:21] however, it isn't failing because of anything I did
    08:28 yuvipanda: [16:21] it's been failing for a while
    ...
    • Apr 19 2017, 3:49 PM
    • 298 Lines
  • root@tools-proxy-02:/var/log# date
    Wed Apr 19 15:18:36 UTC 2017
    root@tools-proxy-02:/var/log# df -Th
    Filesystem Type Size Used Avail Use% Mounted on
    udev devtmpfs 10M 0 10M 0% /dev
    ...
    • Apr 19 2017, 3:19 PM
    • 12 Lines
  • root@tools-proxy-02:/# date
    Wed Apr 19 14:56:38 UTC 2017
    root@tools-proxy-02:/# df -Th
    Filesystem Type Size Used Avail Use% Mounted on
    udev devtmpfs 10M 0 10M 0% /dev
    ...
    • Apr 19 2017, 2:57 PM
    • 10 Lines
  • hive (default)> add jar hdfs://analytics-hadoop/wmf/refinery/current/artifacts/refinery-hive.jar;
    hive (default)> create temporary function stemmer as 'org.wikimedia.analytics.refinery.hive.StemmerUDF';
    hive (default)> select
    wikiid,
    count(distinct norm_query) as all_distinct_norm_q,
    ...
    • Apr 18 2017, 9:39 PM
    • 24 Lines
  • ==============================================================
    qname continuous
    hostname tools-exec-1405.eqiad.wmflabs
    group tools.iabot
    owner tools.iabot
    ...
    • Apr 18 2017, 8:54 PM
    • 43 Lines
  • root@tools-docker-builder-04:/srv/images/toollabs# ./build.py base
    Building following images: ['base', 'jdk8/base', 'ruby/base', 'tcl/base', 'golang/base', 'static-web', 'php/base', 'nodejs/base', 'python2/base', 'python/base', 'jdk8/web', 'ruby/web', 'tcl/web', 'golang/web', 'php/web', 'nodejs/web', 'python2/web', 'python/web']
    Sending build context to Docker daemon 6.144 kB
    Step 1 : FROM docker-registry.tools.wmflabs.org/wikimedia-jessie
    ---> 35690d23731d
    ...
    • Apr 17 2017, 6:20 PM
    • 91 Lines
  • 15:21:13 SUMMARY:
    15:21:13 ✔ 1627 tests completed
    15:21:13 ✖ 26 tests failed
    15:21:13
    15:21:13 FAILED TESTS:
    ...
    • Apr 17 2017, 5:31 PM
    • 395 Lines
  • P5281 2009-c
    local_group_wikimedia_T_mobileDSuCY0V_8QMmb7m5ao.data commons.wikimedia.org:Commons\:Deletion_requests/2017/04
    local_group_wikimedia_T_mobilewKT4BougZJL2msO9eA.data commons.wikimedia.org:Commons\:Deletion_requests/2017/04
    local_group_wikipedia_T_mobileDSuCY0V_8QMmb7m5ao.data en.wikipedia.org:Template\:Admin_dashboard/aiv
    local_group_wikipedia_T_mobileDSuCY0V_8QMmb7m5ao.data en.wikipedia.org:Template\:Admin_dashboard/testcases
    local_group_wikipedia_T_mobileDSuCY0V_8QMmb7m5ao.data en.wikipedia.org:User\:Ctwabn/start
    ...
    • Apr 17 2017, 12:46 PM
    • 30 Lines
  • P5280 2004-b
    local_group_wikimedia_T_mobileDSuCY0V_8QMmb7m5ao.data commons.wikimedia.org:User\:YLSS/BSicon/Stations_and_stops
    local_group_wikimedia_T_mobilewKT4BougZJL2msO9eA.data commons.wikimedia.org:User\:YLSS/BSicon/Stations_and_stops
    local_group_wikipedia_T_mobileDSuCY0V_8QMmb7m5ao.data de.wikipedia.org:State_Champs
    local_group_wikipedia_T_mobileDSuCY0V_8QMmb7m5ao.data en.wikipedia.org:Envelope_model
    local_group_wikipedia_T_mobileDSuCY0V_8QMmb7m5ao.data en.wikipedia.org:Template\:Admin_dashboard/uaarfpp
    ...
    • Apr 17 2017, 12:45 PM
    • 56 Lines
  • date: 2017-04-16T06:08:20+00:00
    tool: pageviews
    language: en
    chart: bar
    ...
    • Apr 16 2017, 6:08 AM
    • 28 Lines
  • root@tools-exec-1412:~# ps axo user:20,pid,ppid,pcpu,pmem,vsz,rss,tty,stat,start,time,comm | grep tools.link
    tools.linkwatcher 2153 2151 0.0 0.0 4452 460 ? SNs Mar 30 00:00:00 25739
    tools.linkwatcher 2157 2153 0.0 0.0 9544 648 ? SN Mar 30 00:00:00 linkwatcher.sh
    tools.linkwatcher 2164 2157 2.7 0.3 205192 32180 ? SN Mar 30 10:18:00 perl
    tools.linkwatcher 2435 1 0.1 1.7 277948 145944 ? SN Mar 30 00:33:55 perl
    ...
    • Apr 15 2017, 6:47 AM
    • 54 Lines
  • date: 2017-04-15T03:08:51+00:00
    tool: pageviews
    language: en
    chart: bar
    ...
    • Apr 15 2017, 3:08 AM
    • 28 Lines
  • $wgHooks['MimeMagicInit'][] = function( $mimeMagic ) {
    $mimeMagic->addExtraTypes( "text/plain 0" );
    };
    • Apr 14 2017, 1:44 PM
    • 3 Lines
    • PHP
  • vagrant@mediawiki-vagrant:/vagrant/srv/libphutil$ git status
    On branch wmf/stable
    Your branch is up-to-date with 'origin/wmf/stable'.
    Changes not staged for commit:
    (use "git add <file>..." to update what will be committed)
    ...
    • Apr 13 2017, 11:46 PM
    • 798 Lines
  • mysql:wikiadmin@db1083 [enwiki]> SELECT * FROM recentchanges WHERE rc_type = /* RC_EXTERNAL from Defines.php */ 5 LIMIT 1 \G
    *************************** 1. row ***************************
    rc_id: 923142319
    rc_timestamp: 20170314220029
    rc_cur_time:
    ...
    • Apr 13 2017, 10:00 PM
    • 30 Lines