Page MenuHomePhabricator
Paste Active Pastes
  • ariel@mwmaint1002:~/table_checker$ python3 ./explain_sql_query.py --yamlfile explain-queries.yaml.eowiki --queryfile ./queries_to_explain_bigbatch.sql --settings ./eqiad.conf > abstract_query_results_eowiki.txt
    ariel@mwmaint1002:~/table_checker$ more abstract_query_results_eowiki.txt
    *** SECTION: s2
    *** HOST: db1090.eqiad.wmnet:3312
    *** WIKI: eowiki
    ...
    • May 29 2019, 12:51 PM
    • 119 Lines
  • T205300
    T205302
    T207144
    T207145
    T207146
    ...
    • May 28 2019, 10:21 PM
    • 37 Lines
  • May 28 08:55:38 acmechief-test1001 acme-chief-backend[31195]: Number of certificates per status: Counter({'VALID': 42, 'INITIAL': 2})
    May 28 08:55:38 acmechief-test1001 acme-chief-backend[31195]: Creating new certificate version a77e19e3b61c4fad89e15eedda3e42ee for non-canonical-redirect-1
    May 28 08:55:38 acmechief-test1001 acme-chief-backend[31195]: Creating initial self-signed certificate for non-canonical-redirect-1 / ec-prime256v1
    May 28 08:55:38 acmechief-test1001 acme-chief-backend[31195]: Pushing the new certificate for non-canonical-redirect-1
    May 28 08:55:38 acmechief-test1001 acme-chief-backend[31195]: Waiting till non-canonical-redirect-1 / rsa-2048 is generated to be able to push the new certificate
    ...
    • May 28 2019, 8:56 AM
    • 25 Lines
  • Attaching to process ID 19075, please wait...
    Debugger attached successfully.
    Server compiler detected.
    JVM version is 25.212-b01
    Deadlock Detection:
    ...
    • May 28 2019, 8:27 AM
    • 54 Lines
    • Java
  • tog-watchcreations
    tog-watchdefault
    tog-watchmoves
    tog-watchdeletion
    tog-watchuploads
    ...
    • May 27 2019, 2:52 PM
    • 711 Lines
  • sitetitle
    sitesubtitle
    viewdeleted_short
    imagepage
    mediawikipage
    ...
    • May 27 2019, 2:51 PM
    • 150 Lines
  • vgutierrez@traffic-upload-stretch:~$ sudo traffic_layout --run-root=/srv/trafficserver/tls verify -w trafficserver
    NOTE: using command line path as RUNROOT
    Verifying default build ...
    Verifying as user: trafficserver
    ...
    • May 27 2019, 9:32 AM
    • 35 Lines
  • root@db2078:~# mysql -S /run/mysqld/mysqld.m1.sock -e "show slave status\G"
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db1063.eqiad.wmnet
    Master_User: repl
    ...
    • May 24 2019, 6:17 AM
    • 49 Lines
  • db[2072,2112,2116].codfw.wmnet
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE revision ALL NULL NULL NULL NULL 717692523 Using where
    db1067.eqiad.wmnet
    id select_type table type possible_keys key key_len ref rows Extra
    ...
    • May 23 2019, 10:20 AM
    • 42 Lines
  • #10
    postgresql::server::config_entry { 'synchronous_standby_names':
    ensure => present,
    value => 'FIRST 1 (lax)',
    }
    ...
    • May 22 2019, 5:22 PM
    • 10 Lines
  • root@MISC m1[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | db2078 |
    ...
    • May 22 2019, 9:43 AM
    • 57 Lines
  • root@db1086:~# mysql -e "show slave status\G"
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db1062.eqiad.wmnet
    Master_User: repl
    ...
    • May 22 2019, 5:42 AM
    • 49 Lines
  • 4 mw1348.eqiad.wmnet
    4 mw1345.eqiad.wmnet
    4 mw1343.eqiad.wmnet
    4 mw1342.eqiad.wmnet
    4 mw1282.eqiad.wmnet
    ...
    • May 21 2019, 2:57 PM
    • 84 Lines
  • root@db1089.eqiad.wmnet[enwiki]> explain SELECT /* ApiQueryRevisions::run */ rev_id, rev_page, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1, comment_rev_comment.comment_text AS `rev_comment_text`, comment_rev_comment.comment_data AS `rev_comment_data`, comment_rev_comment.comment_id AS `rev_comment_cid`, actor_rev_user.actor_user AS `rev_user`, actor_rev_user.actor_name AS `rev_user_text`, temp_rev_user.revactor_actor AS `rev_actor`, page_namespace, page_title, page_id, page_latest, page_is_redirect, page_len, user_name FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `revision_actor_temp` `temp_rev_user` ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_page = '35159700' ORDER BY rev_timestamp DESC, rev_id DESC LIMIT 2 /* d4b1615c1ca7cc6e58b19616c200b731 db1118 enwiki 4s */;
    +------+-------------+---------------------+--------+--------------------------------------------------------+---------------+---------+-----------------------------------------------+-------+-------------+
    | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
    +------+-------------+---------------------+--------+--------------------------------------------------------+---------------+---------+-----------------------------------------------+-------+-------------+
    | 1 | SIMPLE | revision | index | PRIMARY,page_timestamp,page_user_timestamp,rev_page_id | rev_timestamp | 16 | NULL | 12088 | Using where |
    ...
    • May 21 2019, 1:41 PM
    • 30 Lines
  • P8548 s2 slave
    root@db2041:~# mysql -e "show slave status\G"
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db2035.codfw.wmnet
    Master_User: repl
    ...
    • May 21 2019, 6:30 AM
    • 49 Lines
  • [Sat Mar 30 17:32:54 2019] [<ffffffffb4185cca>] ? oom_kill_process+0x21a/0x3e0
    [Sat Mar 30 17:32:54 2019] Task in /mediawiki/job/1330 killed as a result of limit of /mediawiki/job/1330
    [Sat Mar 30 17:32:54 2019] Memory cgroup out of memory: Kill process 1334 (identify) score 1376 or sacrifice child
    [Sat Mar 30 17:32:54 2019] Killed process 1334 (identify) total-vm:1841912kB, anon-rss:1044580kB, file-rss:395336kB, shmem-rss:0kB
    [Sat Mar 30 17:32:55 2019] identify invoked oom-killer: gfp_mask=0x24000c0(GFP_KERNEL), nodemask=0-1, order=0, oom_score_adj=0
    ...
    • May 21 2019, 6:20 AM
    • 929 Lines
  • root@db2040:~# mysql -e "show slave status\G"
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db2047.codfw.wmnet
    Master_User: repl
    ...
    • May 21 2019, 5:17 AM
    • 49 Lines
  • root@db2046:~# mysql -e "show slave status\G"
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db2039.codfw.wmnet
    Master_User: repl
    ...
    • May 20 2019, 5:12 AM
    • 49 Lines
  • #!/bin/bash
    git log \
    --invert-grep --author='<l10n-bot@translatewiki.net>' \
    --no-merges \
    --name-only --pretty=format: \
    ...
    • May 19 2019, 5:26 PM
    • 27 Lines
    • Bash Scripting
  • == Personnel ==
    {| class="toccolours" style="text-align: left;"
    ! colspan="7" style="background: #681A32; color: #FFFFFF; -moz-box-shadow: inset 2px 2px 0 #D12030, inset -2px -2px 0 #D12030; -webkit-box-shadow: inset 2px 2px 0 #D12030, inset -2px -2px 0 #D12030; box-shadow: inset 2px 2px 0 #D12030, inset -2px -2px 0 #D12030;;" |<div style="text-align:center; position:relative; white-space:nowrap; color:#FFFFFF;"> État-major des commandants de San Antonio </div>
    |-
    | colspan="7" style="text-align:right;" |
    ...
    • May 19 2019, 3:54 PM
    • 50 Lines
  • root@cloudcontrol2001-dev:~# puppet agent -tv
    Warning: Downgrading to PSON for future requests
    Info: Using configured environment 'production'
    Info: Retrieving pluginfacts
    Info: Retrieving plugin
    ...
    • May 19 2019, 3:23 PM
    • 93 Lines
  • 23:55:45 | lvs1013.eqiad.wmnet | WARNING: unable to verify that BIOS boot parameters are back to normal, got:
    Boot parameter version: 1
    Boot parameter 5 is valid/unlocked
    Boot parameter data: 8000020000
    Boot Flags :
    ...
    • May 18 2019, 11:59 PM
    • 13 Lines
  • let wrap = function ( obj, field, cb ) { let oldcb = obj[field]; obj[field] = function ( ...args) { console.log( field + ' -> ' + args ); return cb.call( obj, oldcb.bind( obj ), ...args ); }; };
    let delay = function ( time, value ) { let d = $.Deferred(); setTimeout( function() { d.resolve( value ); }, time ); return d.promise(); }
    wrap( mw.mmv.viewer.imageProvider, 'get', function( oldcb, ...args ) { return delay( 200, oldcb( ...args ) ); } );
    • May 18 2019, 8:59 PM
    • 3 Lines
    • Javascript
  • 3976: Improvement
    3975: Improvement
    3974: No significant change
    3973: Improvement
    3972: No significant change
    ...
    • May 18 2019, 10:48 AM
    • 164 Lines
  • #!/usr/bin/env python
    # -*- coding: utf-8 -*-
    """
    usage: mwgrep [-h] [--max-results N] [--timeout N] [--user | --module]
    [--title TITLE | --etitle REGEX] regex
    ...
    • May 17 2019, 2:30 PM
    • 200 Lines
    • Python
  • s4:
    host: 'db1102.eqiad.wmnet'
    port: 3314
    stop_slave: True
    destination: 'dbprov1001.eqiad.wmnet'
    ...
    • May 17 2019, 10:18 AM
    • 7 Lines
  • root@db1083:~# mysql -e "show slave status\G"
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db1067.eqiad.wmnet
    Master_User: repl
    ...
    • May 17 2019, 5:21 AM
    • 49 Lines
  • root@db1104:~# mysql -e "show slave status\G"
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db1071.eqiad.wmnet
    Master_User: repl
    ...
    • May 16 2019, 5:34 AM
    • 49 Lines
  • P8532 nmap
    ##### normal output #####
    $ sudo nmap -p80,443 --script=./ripestat.nse www.wikimedia.org
    ....
    Host script results:
    | ripestat:
    ...
    • May 15 2019, 5:48 PM
    • 134 Lines
  • SELECT
    IF( uri_query RLIKE 'revision=', 1, 0) as revisionParam,
    IF( uri_query RLIKE 'oldid=', 1, 0 ) as oldidParam,
    COUNT(*) AS requests
    FROM wmf.webrequest
    ...
    • May 15 2019, 4:45 PM
    • 14 Lines
  • {
    "project": "4",
    "logger": "javascript",
    "platform": "javascript",
    "request": {
    ...
    • May 15 2019, 4:15 PM
    • 63 Lines
    • JSON
  • 116.202.0.0/16
    116.203.0.0/16
    136.243.0.0/16
    138.201.0.0/16
    144.76.0.0/16
    ...
    • May 15 2019, 1:06 PM
    • 61 Lines
  • //Query top language pairs
    var request = require("request"); // check https://www.npmjs.com/package/request
    let url ='https://en.wikipedia.org/w/api.php?action=query&list=contenttranslationstats&format=json';
    let numResults = 15; // Results to display
    ...
    • May 15 2019, 11:23 AM
    • 36 Lines
    • Javascript
  • krenair@deployment-docker-citoid01:~$ sudo docker exec -it a nodejs
    > var a = require('request')({url:'https://journals.plos.org'});
    undefined
    > Error: unable to get local issuer certificate
    at TLSSocket.onConnectSecure (_tls_wrap.js:1055:34)
    ...
    • May 14 2019, 11:34 PM
    • 8 Lines
  • SELECT
    IF( uri_query RLIKE 'revision=', 'revision', IF( uri_query RLIKE 'oldid=', 'oldid', 'none' )),
    COUNT(*) AS requests
    FROM wmf.webrequest
    WHERE uri_host = 'www.wikidata.org'
    ...
    • May 14 2019, 5:29 PM
    • 13 Lines
  • root@traffic-upload-stretch:/etc/trafficserver# ls -l records.config
    -r-------- 1 trafficserver trafficserver 3119 May 13 15:27 records.config
    root@traffic-upload-stretch:/etc/trafficserver# traffic_ctl config get proxy.config.http.cache.required_headers
    proxy.config.http.cache.required_headers: 2
    root@traffic-upload-stretch:/etc/trafficserver# sed -i 's/proxy.config.http.cache.required_headers INT 2/proxy.config.http.cache.required_headers INT 1/' records.config
    ...
    • May 13 2019, 3:29 PM
    • 10 Lines
  • ===== NODE GROUP =====
    (1) ms-be2043.codfw.wmnet
    ----- OUTPUT of 'grep ^#LABEL /etc/fstab ; true' -----
    #LABEL=swift-sdd1 /srv/swift-storage/sdd1 xfs nofail,noatime,nodiratime,nobarrier,logbufs=8 0 0
    ===== NODE GROUP =====
    ...
    • May 13 2019, 12:38 PM
    • 14 Lines
  • ===== NODE GROUP =====
    (1) ms-be2013.codfw.wmnet
    ----- OUTPUT of 'ls -l /srv/swift.../dev/null ; true' -----
    ls: cannot access '/srv/swift-storage/sdb1': Input/output error
    ================
    • May 13 2019, 12:38 PM
    • 5 Lines
  • vgutierrez@cloudvirt1024:~$ cat /etc/network/interfaces
    # This file describes the network interfaces available on your system
    # and how to activate them. For more information, see interfaces(5).
    source /etc/network/interfaces.d/*
    ...
    • May 13 2019, 10:23 AM
    • 37 Lines
    • Bash Scripting
  • /#/dashboard/?title=Commits+By+Project&Starred=owner:self+is:open+is:starred+limit:10&
    Dumps=owner:self+is:open+project:operations/dumps+branch:master+-hashtag:low+-is:starred+limit:5&
    mwbzutils=owner:self+is:open+project:operations/dumps/mwbzutils+branch:master+-hashtag:low+-is:starred+limit:5&
    Puppet=owner:self+is:open+project:operations/puppet+branch:production+-hashtag:low+-is:starred+limit:5&
    Ops+Software=owner:self+is:open+project:operations/software+branch:master+-hashtag:low+-is:starred+limit:5&
    ...
    • May 13 2019, 5:43 AM
    • 7 Lines
  • https://analytics.gerrithub.io/kibana/s/gerritcodereview/app/kibana#/dashboard/gerritcodereview-11?_g=(refreshInterval:(pause:!t,value:0),time:(from:now-10y,mode:relative,to:now))&_a=(description:'',filters:!(('':(store:appState),'$state':(store:appState),meta:(alias:!n,disabled:!f,index:gerritcodereview-10,key:is_merge,negate:!f,params:(query:!f,type:phrase),type:phrase,value:false),query:(match:(is_merge:(query:!f,type:phrase)))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:gerritcodereview-10,key:branches.keyword,negate:!f,params:(query:master,type:phrase),type:phrase,value:master),query:(match:(branches.keyword:(query:master,type:phrase)))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index:gerritcodereview-10,key:project.keyword,negate:!t,params:(query:GerritCodeReview%2Fgitblit,type:phrase),type:phrase,value:GerritCodeReview%2Fgitblit),query:(match:(project.keyword:(query:GerritCodeReview%2Fgitblit,type:phrase)))),('$state':(store:appState),meta:(alias:!n,disabled:!f,index...
    • May 10 2019, 9:20 PM
    • 1 Line
  • +--------------+--------------------------------------------------+------------+
    | table_schema | table_name | row_format |
    +--------------+--------------------------------------------------+------------+
    | enwiki | abuse_filter | Compressed |
    | enwiki | abuse_filter_action | Compressed |
    ...
    • May 10 2019, 6:40 PM
    • 169 Lines
  • ArchivedFile LocalRepo
    RevDelList RevisionDeleter
    OldLocalFile LocalFile
    PrefixSearch StringPrefixSearch
    LinkBatch LinkCache
    ...
    • May 10 2019, 4:10 PM
    • 292 Lines
  • local p = {}
    function p.parse( frame )
    values = {
    "C0101" = 8,
    ...
    • May 10 2019, 2:12 PM
    • 4,519 Lines
    • Lua
  • from locust import HttpLocust, TaskSet
    def info(l):
    l.client.get('/_info')
    ...
    • May 10 2019, 1:10 PM
    • 30 Lines
    • Python
  • diff --git a/Wikidiff2.h b/Wikidiff2.h
    index 805e610..c32f76d 100644
    --- a/Wikidiff2.h
    +++ b/Wikidiff2.h
    @@ -101,6 +101,7 @@ inline bool Wikidiff2::AllowPrintMovedLineDiff::operator () (StringDiff & linedi
    ...
    • May 10 2019, 11:58 AM
    • 25 Lines
    • Diff
  • an-coord1001 ~ % sudo su - hdfs [11:05:53]
    hdfs@an-coord1001:~$ /srv/deployment/analytics/refinery/bin/saltrotate -p '3 months' -b '50 days' /etc/refinery/salts/eventlogging_sanitization && hdfs dfs -rm -r /user/hdfs/salts/eventlogging_sanitization && hdfs dfs -put /etc/refinery/salts/eventlogging_sanitization /user/hdfs/salts
    2019-05-10T11:06:15 INFO Unit tests passed
    2019-05-10T11:06:15 INFO Running saltrotate
    2019-05-10T11:06:15 INFO Looking for existing salts that need deletion
    ...
    • May 10 2019, 11:12 AM
    • 12 Lines
  • root@db1115.eqiad.wmnet[zarcillo]> select file_path, file_name, round(size/1024/1024/1024) as GB FROM backup_files where backup_id=1311 order by size desc LIMIT 20;
    +--------------+------------------------------------------------------+------+
    | file_path | file_name | GB |
    +--------------+------------------------------------------------------+------+
    | wikidatawiki | wb_terms.ibd | 476 |
    ...
    • May 10 2019, 6:25 AM
    • 26 Lines
  • # Original 200
    $ curl -v -H "Host: upload.wikimedia.org" http://deployment-ms-fe03.deployment-prep.eqiad.wmflabs/wikipedia/deployment/c/ce/27px-Gnome-devel.png -o /dev/null 2>&1 | grep '<'
    < HTTP/1.1 200 OK
    < Content-Length: 1986
    < X-Object-Meta-Sha1Base36: 344qdhgimy9tp3m3nberc7qv65foe99
    ...
    • May 10 2019, 6:07 AM
    • 57 Lines
  • mysql:root@localhost [(none)]> select @@hostname; show slave status\G
    +------------+
    | @@hostname |
    +------------+
    | db1100 |
    ...
    • May 10 2019, 5:08 AM
    • 56 Lines
  • with apr_active_eds as (
    select
    event_user_text,
    count(*) as content_edits
    from wmf.mediawiki_history mwh
    ...
    • May 10 2019, 4:54 AM
    • 32 Lines
  • {"exception":{"stacktrace":"com.google.gerrit.server.auth.NoSuchUserException: No such user: test\n\tat com.google.gerrit.server.auth.ldap.Helper.findAccount(Helper.java:254)\n\tat com.google.gerrit.server.auth.ldap.LdapRealm.authenticate(LdapRealm.java:242)\n\tat com.google.gerrit.server.account.AccountManager.authenticate(AccountManager.java:131)\n\tat com.google.gerrit.httpd.auth.ldap.LdapLoginServlet.doPost(LdapLoginServlet.java:123)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\n\tat com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)\n\tat com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)\n\tat com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)\n\tat com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)\n\tat com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation....
    • May 10 2019, 12:27 AM
    • 1 Line
  • varnishkafka_broker_int_latency_average_microseconds{broker="ssl://kafka-jumbo1001.eqiad.wmnet:9093/1001",source="webrequest"} 500921.0
    varnishkafka_broker_int_latency_average_microseconds{broker="ssl://kafka-jumbo1002.eqiad.wmnet:9093/1002",source="webrequest"} 511614.0
    varnishkafka_broker_int_latency_average_microseconds{broker="ssl://kafka-jumbo1003.eqiad.wmnet:9093/1003",source="webrequest"} 510515.0
    varnishkafka_broker_int_latency_average_microseconds{broker="ssl://kafka-jumbo1004.eqiad.wmnet:9093/1004",source="webrequest"} 508193.0
    varnishkafka_broker_int_latency_average_microseconds{broker="ssl://kafka-jumbo1005.eqiad.wmnet:9093/1005",source="webrequest"} 508212.0
    ...
    • May 9 2019, 3:11 PM
    • 583 Lines
  • 13:57:43 ema@cp1079.eqiad.wmnet:~
    $ curl docker-registry.svc.eqiad.wmnet:81
    curl: (7) Failed to connect to docker-registry.svc.eqiad.wmnet port 81: Connection refused
    13:57:47 ema@cp1079.eqiad.wmnet:~
    $ curl docker-registry.svc.codfw.wmnet:81
    ...
    • May 9 2019, 1:58 PM
    • 6 Lines
  • root@db1081.eqiad.wmnet[(none)]> select @@hostname;
    +------------+
    | @@hostname |
    +------------+
    | db1081 |
    ...
    • May 9 2019, 10:44 AM
    • 57 Lines
  • root@db2104.codfw.wmnet[mysql]> select @@hostname; show slave status\G
    +------------+
    | @@hostname |
    +------------+
    | db2104 |
    ...
    • May 9 2019, 6:41 AM
    • 56 Lines
  • root@db2098.codfw.wmnet[(none)]> show slave status\G
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db2035.codfw.wmnet
    Master_User: repl
    ...
    • May 9 2019, 5:30 AM
    • 49 Lines
  • root@PRODUCTION s2 slave[(none)]> select @@hostname ; show slave status\G
    +------------+
    | @@hostname |
    +------------+
    | db1076 |
    ...
    • May 9 2019, 5:26 AM
    • 56 Lines
  • cdanis@evebox.local ~/work/gits/swift-ring % make
    swift-ring-builder codfw-prod/object-1.builder rebalance ; [ $? -le 1 ] || exit 2
    Reassigned 4485 (6.84%) partitions. Balance is now 999.99. Dispersion is now 0.15
    -------------------------------------------------------------------------------
    NOTE: Dispersion of 0.149536 indicates some parts are not
    ...
    • May 8 2019, 7:10 PM
    • 40 Lines
  • Before:
    /usr/local/bin/apache-fast-test gerrit.url 'https'
    testing 4 urls on 1 servers, totalling 4 requests
    spawning threads..
    ...
    • May 8 2019, 6:37 PM
    • 29 Lines
  • 190508 11:11:01 >> log scanned up to (49866212841978)
    190508 11:11:02 >> log scanned up to (49866212841978)
    190508 11:11:03 >> log scanned up to (49866212841978)
    /opt/wmf-mariadb101/bin/mariabackup: Error writing file 'UNKNOWN' (Errcode: 32 "Broken pipe")
    xb_stream_write_data() failed.
    ...
    • May 8 2019, 12:48 PM
    • 24 Lines
  • root@db2097.codfw.wmnet[(none)]> show slave status\G
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db2048.codfw.wmnet
    Master_User: repl
    ...
    • May 8 2019, 9:47 AM
    • 49 Lines
  • root@db1115.eqiad.wmnet[zarcillo]> select name, IF(LOCATE('eqiad', source), 'eqiad', 'codfw') as dc, section, timediff(end_date, start_date) as duration FROM backups WHERE start_date > now() - INTERVAL 1 day and `type` = 'dump' ORDER BY dc, section;
    +-----------------------------------+-------+---------+----------+
    | name | dc | section | duration |
    +-----------------------------------+-------+---------+----------+
    | dump.m1.2019-05-07--20-00-29 | codfw | m1 | 00:31:08 |
    ...
    • May 8 2019, 8:24 AM
    • 33 Lines
  • mysql:root@localhost [(none)]> show slave status\G
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db2045.codfw.wmnet
    Master_User: repl
    ...
    • May 8 2019, 6:22 AM
    • 49 Lines
  • root@PRODUCTION s6 slave[(none)]> show slave status\G
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db1061.eqiad.wmnet
    Master_User: repl
    ...
    • May 8 2019, 5:28 AM
    • 50 Lines
  • mysql:root@localhost [(none)]> show slave status\G
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db1069.eqiad.wmnet
    Master_User: repl
    ...
    • May 8 2019, 5:01 AM
    • 50 Lines
  • curl -I https://gerrit.wikimedia.org/r/#/c/operations/software/gerrit/plugins/MassBranchCreation/+/502883/
    HTTP/1.1 200 OK
    Date: Tue, 07 May 2019 21:02:19 GMT
    Server: Apache
    Strict-Transport-Security: max-age=106384710; includeSubDomains; preload
    ...
    • May 7 2019, 9:02 PM
    • 12 Lines
  • https://gerrit.wikimedia.org/r/mediawiki/core
    https://gerrit.wikimedia.org/r/mediawiki/core/info/refs?service=git-upload-pack
    https://gerrit.wikimedia.org/r/p/mediawiki/core
    https://gerrit.wikimedia.org/r/p/mediawiki/core/info/refs?service=git-upload-pack
    https://gerrit.wikimedia.org/r/#/c/operations/software/gerrit/plugins/MassBranchCreation/+/502883/
    ...
    • May 7 2019, 7:01 PM
    • 7 Lines
  • <?xml version="1.0" encoding="UTF-8"?>
    <!--<Configuration status="INFO">-->
    <Configuration packages="com.google.gerrit.sshd">
    <Appenders>
    <Console name="Console" target="SYSTEM_ERR">
    ...
    • May 7 2019, 3:53 PM
    • 110 Lines
  • root@db1140.eqiad.wmnet[(none)]> show slave status\G
    *************************** 1. row ***************************
    Slave_IO_State:
    Master_Host: db1069.eqiad.wmnet
    Master_User: repl
    ...
    • May 7 2019, 12:09 PM
    • 49 Lines
  • diff -Nru prometheus-trafficserver-exporter-0.2.0/.bumpversion.cfg prometheus-trafficserver-exporter-0.2.3/.bumpversion.cfg
    --- prometheus-trafficserver-exporter-0.2.0/.bumpversion.cfg 2018-10-30 04:10:29.000000000 +0100
    +++ prometheus-trafficserver-exporter-0.2.3/.bumpversion.cfg 2019-05-03 15:54:32.000000000 +0200
    @@ -1,5 +1,5 @@
    [bumpversion]
    ...
    • May 7 2019, 10:13 AM
    • 205 Lines
  • These look the same, or at least render the same, but only one of them returns results:
    ```
    a: Oзон
    b: Озон
    ...
    • May 6 2019, 11:25 PM
    • 11 Lines
  • public static String[] tokenizeString(String query, String lang) {
    GlentTokenizer tokenizer;
    if ("ko".equalTo(lang)) {
    tokenizer = Tokenizers.korean();
    } else if ("ja".equalTo(lang)) {
    ...
    • May 6 2019, 6:37 PM
    • 13 Lines
  • OK: puppet-merge on rhodium.eqiad.wmnet succeeded
    Fetching new commits from https://gerrit.wikimedia.org/r/p/operations/puppet
    error: cannot lock ref 'refs/remotes/origin/production': is at 73820b7f34685628be58c2166da5baf16c3830fe but expected da491ce740b81ddfdd43166ab3583dc646c5a89e
    From https://gerrit.wikimedia.org/r/p/operations/puppet
    ! da491ce740..73820b7f34 production -> origin/production (unable to update local ref)
    ...
    • May 6 2019, 10:43 AM
    • 81 Lines
  • DRINGGGGGGGGGGGGGGGGGGGGGG!!!!!!!!!!!!!!!!!
    5:00 PM meeting officially starts :)
    5:00 PM welcome everyone to the AWMD irc meeting
    5:01 PM here we discuss things related to contributions of code to mediawiki code and its extension. or generally to any wikimedia related software
    5:02 PM → Eugene233 joined (uid268461@gateway/web/irccloud.com/x-jeqskusprfimxzus)
    ...
    • May 5 2019, 5:04 PM
    • 164 Lines
  • ~23:20 -> 00:15, period of 5xx spam alerts off and on from icinga
    502 cp1086
    655 cp1080
    657 cp1084
    ...
    • May 5 2019, 12:20 AM
    • 18 Lines
  • > $langCodes = array_keys(MediaWiki\Languages\Data\Names::$names);
    > foreach ( $langCodes as $langCode ) { echo "$langCode: " . Language::factory($langCode)->getDateFormatString('both', 'default') . "\n"; }
    aa: H:i, j F Y
    ab: H:i, j xg Y
    ...
    • May 3 2019, 9:04 PM
    • 446 Lines
  • )]}'
    {
    "id": "operations%2Fpuppet~production~I20b57f33dfc7fb36569ee8bb9b6f0e5eac632ea5",
    "project": "operations/puppet",
    "branch": "production",
    • May 3 2019, 6:05 PM
    • 5 Lines
  • willikins:trafficserver_exporter vgutierrez$ python /tmp/parse_collector.py /Users/vgutierrez/github.com/gdvalle/trafficserver_exporter/trafficserver_exporter/collector.py
    trafficserver_client_requests_invalid_total:
    documentation: Invalid client requests.
    type: counter
    values:
    ...
    • May 3 2019, 3:30 PM
    • 181 Lines
    • YAML
  • {
    "eqiad": {
    "sectionLoads": {
    "DEFAULT": {
    "db1075": 0,
    ...
    • May 3 2019, 12:34 PM
    • 670 Lines
  • ** << BeReq >> 103216703
    -- Begin bereq 103216702 fetch
    -- Timestamp Start: 1556863275.544447 0.000000 0.000000
    -- BereqMethod GET
    -- BereqURL /w/index.php?title=Image:Geneva_Conventions_1864-1949.svg&action=render&uselang=fa
    ...
    • May 3 2019, 6:33 AM
    • 51 Lines
  • ** << BeReq >> 136981818
    -- Begin bereq 136981817 fetch
    -- Timestamp Start: 1556863124.720243 0.000000 0.000000
    -- BereqMethod GET
    -- BereqURL /wiki/Historical_present
    ...
    • May 3 2019, 6:13 AM
    • 63 Lines
  • Cloning without the redirects:
    git clone "https://gerrit.git.wmflabs.org/r/p/Backend"
    Cloning into 'Backend'...
    fatal: https://gerrit.git.wmflabs.org/r/p/Backend/info/refs not valid: is this a git repository?
    ...
    • May 2 2019, 4:46 PM
    • 22 Lines
  • painting by T.G. l' Herminez 23
    painting by W. Yo Bwan Tjong 22
    painting by W.H.F. Boers 18
    painting by J.J.M. Ongenae 15
    painting by J. Miedema 15
    ...
    • May 2 2019, 8:56 AM
    • 300 Lines
  • (/^ヮ^)/*:・゚✧ curl -XDELETE --user 'wikitechgerritaccountbot' "https://gerrit.wikimedia.org/r/a/accounts/thciprianiblockaccount1/active"
    Enter host password for user 'wikitechgerritaccountbot':
    ~ 5s
    (/^ヮ^)/*:・゚✧ curl --user 'wikitechgerritaccountbot' "https://gerrit.wikimedia.org/r/a/accounts/thciprianiblockaccount1/active"
    Enter host password for user 'wikitechgerritaccountbot':
    ...
    • May 1 2019, 3:15 PM
    • 15 Lines
  • Based on a short but probably-representative sample, these are all the hostnames that rounded to >=1% of all address (A/AAAA) queries. All samples were collected during one brief window of time. Probably the prevelance of language subdomains follows the sun, but that's not the kind of data we're looking for here (more like domain roots and common targets vs all the project/lang entries). Between them they totaled ~57%, leaving ~43% for the long tail:
    1% pt.wikipedia.org.
    1% ja.wikipedia.org.
    1% es.wikipedia.org.
    ...
    • May 1 2019, 1:38 PM
    • 18 Lines
  • /foo
    /bar
    /*
    Found conflict in template /* with existing template /bar/
    /baz
    ...
    • May 1 2019, 2:11 AM
    • 22 Lines
  • <?php
    class Templates {
    private $treesByLength = [];
    ...
    • May 1 2019, 2:10 AM
    • 88 Lines
    • PHP
  • SELECT ?item WHERE {
    ?item wdt:P31 wd:Q11879590 .
    FILTER NOT EXISTS {
    ?item wdt:P31 wd:Q4167410
    }
    ...
    • Apr 30 2019, 11:09 PM
    • 202 Lines
  • [
    {
    "_index": "wikidatawiki_content_first",
    "_type": "page",
    "_id": "5",
    ...
    • Apr 30 2019, 10:09 PM
    • 40 Lines
  • {
    "description": "full_text search for 'inlabel:foo'",
    "path": "wikidatawiki_content\/page\/_search",
    "params": {
    "timeout": "20s",
    ...
    • Apr 30 2019, 9:53 PM
    • 187 Lines
  • # Disable puppet
    sudo cumin A:all 'disable-puppet "T220987: global kafaka log shipping - staged rollout (jbond)"'
    # Apply change 505737
    https://gerrit.wikimedia.org/r/c/operations/puppet/+/505737
    ...
    • Apr 30 2019, 2:01 PM
    • 18 Lines
  • P8458 latest
    def latest(self, metric: str, host: str, timeperiod: Optional[str] = '2m') -> float:
    """Get the latest prometheous metric
    Arguments:
    metric (str): name of the prometheous metric
    ...
    • Apr 30 2019, 10:57 AM
    • 26 Lines
    • Python
  • aa: 3
    ab: 158
    abs: 1
    ace: 5
    ady: 0
    ...
    • Apr 29 2019, 8:50 PM
    • 442 Lines
  • 2019-04-25T20:34:01 1161913 10.64.16.22 proxy-server/503 299 GET http://grafana.wikimedia.org/api/datasources/proxy/6/api/v1/query_range?query=kafka_server_ReplicaManager_LeaderCount%7Bcluster%3D%22eventbus%22%2Ckafka_cluster%3D%22main-eqiad%22%2Cinstance%3D~%22.*.*%22%7D&start=1548446400&end=1556236800&step=14400 - text/html https://grafana.wikimedia.org/d/000000027/kafka?refresh=5m&orgId=1&var-datasource=eqiad%20prometheus%2Fops&var-kafka_cluster=main-eqiad&var-cluster=eventbus&var-kafka_broker=All&var-disk_device=sdb&from=now-90d&to=now
    2019-04-25T20:34:01 1161941 10.64.32.67 proxy-server/503 299 GET http://grafana.wikimedia.org/api/datasources/proxy/6/api/v1/query_range?query=irate(kafka_server_ReplicaManager_IsrShrinks_total%7Bcluster%3D%22eventbus%22%2Ckafka_cluster%3D%22main-eqiad%22%2Cinstance%3D~%22.*.*%22%7D%20%5B5m%5D)&start=1548446400&end=1556236800&step=14400 - text/html https://grafana.wikimedia.org/d/000000027/kafka?refresh=5m&orgId=1&var-datasource=eqiad%20prometheus%2Fops&var-kafka_cluster=main-eqiad&var-cluster=eventbus&var-kafka_broker=All&var-disk_device=sdb&from=now-90d&to=now
    2019-04-25T20:34:00 1164188 10.64.16.24 proxy-server/503 299 GET http://grafana.wikimedia.org/api/datasources/proxy/6/api/v1/query_range?query=sort_desc(topk(3%2C%20sum(irate(kafka_server_BrokerTopicMetrics_MessagesIn_total%7Bkafka_cluster%3D%22main-eqiad%22%2C%20instance%3D~%22.*.*%22%2C%20topic%3D~%22.%2B%22%7D%5B5m%5D))%20by%20(topic)))&start=1548446400&end=1556229600&step=7200 - text/html https://grafana.wikimedia.org/d/000000027/kafka?refresh=5m&orgId=1&var-datasource=eqiad%20prometheus%2Fops&var-kafka_cluster=main-eqiad&var-cluster=eventbus&var-kafka_broker=All&var-disk_device=sdb&from=now-90d&to=now
    2019-04-25T20:34:01 1164666 10.64.48.101 proxy-server/503 299 GET http://grafana.wikimedia.org/api/datasources/proxy/6/api/v1/query_range?query=sum(irate(kafka_server_BrokerTopicMetrics_MessagesIn_total%7Bcluster%3D%22eventbus%22%2Ckafka_cluster%3D%22main-eqiad%22%2Cinstance%3D~%22.*.*%22%2Ctopic%3D%22%22%7D%20%5B5m%5D))&start=1548446400&end=1556236800&step=14400 - text/html https://grafana.wikimedia.org/d/000000027/kafka?refresh=5m&orgId=1&var-datasource=eqiad%20prometheus%2Fops&var-kafka_cluster=main-eqiad&var-cluster=eventbus&var-kafka_broker=All&var-disk_device=sdb&from=now-90d&to=now
    2019-04-25T20:34:01 1168981 10.64.0.132 proxy-server/503 299 GET http://grafana.wikimedia.org/api/datasources/proxy/6/api/v1/query_range?query=kafka_server_ReplicaManager_PartitionCount%7Bcluster%3D%22eventbus%22%2Ckafka_cluster%3D%22main-eqiad%22%2Cinstance%3D~%22.*.*%22%7D&start=1548446400&end=1556236800&step=14400 - text/html https://grafana.wikimedia.org/d/000000027/kafka?refresh=5m&orgId=1&var-datasource=eqiad%20prometheus%2Fops&var-kafka_cluster=main-eqiad&var-cluster=eventbus&var-kafka_broker=All&var-disk_device=sdb&from=now-90d&to=now
    ...
    • Apr 29 2019, 7:39 PM
    • 100 Lines
  • 2019-04-25T20:34:15 1135318 208.80.154.84 proxy-server/200 102 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=scalar%28varnish_mgt_child_start%7Binstance%3D~%22cp1084%3A.%2A%22%2Clayer%3D%22backend%22%7D%29 - application/json -
    2019-04-25T20:36:43 1282154 208.80.154.84 proxy-server/200 121 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=sum%28increase%28node_edac_correctable_errors_total%7Binstance%3D%22es1019%3A9100%22%7D%5B4d%5D%29%29 - application/json -
    2019-04-25T20:36:43 1299501 208.80.154.84 proxy-server/200 101 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=scalar%28varnish_mgt_child_start%7Binstance%3D~%22cp1089%3A.%2A%22%2Clayer%3D%22frontend%22%7D%29 - application/json -
    2019-04-25T20:36:43 1311716 208.80.154.84 proxy-server/200 103 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=scalar%28varnish_mgt_child_start%7Binstance%3D~%22cp1076%3A.%2A%22%2Clayer%3D%22frontend%22%7D%29 - application/json -
    2019-04-25T20:36:36 1397910 208.80.154.84 proxy-server/200 103 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=scalar%28varnish_mgt_child_start%7Binstance%3D~%22cp1079%3A.%2A%22%2Clayer%3D%22backend%22%7D%29 - application/json -
    ...
    • Apr 29 2019, 2:59 PM
    • 100 Lines
  • 2019-04-25T20:35:11 1000334 208.80.154.84 proxy-server/503 299 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=sum%28increase%28edac_events%7Bhostname%3D%22ores1008%22%7D%5B4d%5D%29%29 - text/html -
    2019-04-25T20:35:29 1000335 208.80.153.74 proxy-server/503 299 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=sum%28increase%28edac_events%7Bhostname%3D%22analytics1053%22%7D%5B4d%5D%29%29 - text/html -
    2019-04-25T20:35:06 1000336 208.80.154.84 proxy-server/503 299 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=scalar%28100+%2A+rate%28node_netstat_Udp_InErrors%7Binstance%3D~%22graphite1004.%2A%22%7D%5B5m%5D%29+%2F+rate%28node_netstat_Udp_InDatagrams%7Binstance%3D~%22graphite1004.%2A%22%7D%5B5m%5D%29%29 - text/html -
    2019-04-25T20:35:28 1000336 208.80.154.84 proxy-server/503 299 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=scalar%28sum%28avg_over_time%28kafka_producer_producer_metrics_record_send_rate%7Bmirror_name%3D%22main-codfw_to_main-eqiad%22%7D+%5B30m%5D%29%29%29 - text/html -
    2019-04-25T20:34:14 1000337 208.80.154.84 proxy-server/503 299 GET http://prometheus.svc.eqiad.wmnet/ops/api/v1/query?query=scalar%28max%28max_over_time%28kafka_burrow_partition_lag%7Bgroup%3D%22kafka-mirror-main-eqiad_to_main-codfw%22%2Ctopic%21~%22%22%7D+%5B10m%5D%29%29%29 - text/html -
    ...
    • Apr 29 2019, 2:57 PM
    • 100 Lines
  • {
    "type": "item",
    "id": "Q988695",
    "labels": {
    "hu": {
    ...
    • Apr 29 2019, 7:58 AM
    • 148 Lines
    • JSON
  • {
    "type": "item",
    "id": "Q988695",
    "labels": {
    "hu": {
    ...
    • Apr 29 2019, 7:57 AM
    • 146 Lines
    • JSON