Paste Active Pastes
  • 1​This worked, in the end:
    2​root@deployment-puppetmaster03:/var/lib/puppet# rm -rf ssl server/ssl
    3​root@deployment-puppetmaster03:/var/lib/puppet# puppet cert list
    4​Notice: Signed certificate request for ca
    5​root@deployment-puppetmaster03:/var/lib/puppet# puppet cert generate deployment-puppetmaster03.deployment-prep.eqiad.wmflabs
    6...
    • Sat, May 26, 8:50 PM
    • 16 Lines
  • 1​#####################################################################
    2​##### THIS FILE IS MANAGED BY PUPPET
    3​##### as template('base/puppet.conf.d/10-main.conf.erb')
    4​######################################################################
    5
    6...
    • Sat, May 26, 4:48 PM
    • 48 Lines
  • 1​root@deployment-puppetmaster03:/var/lib/puppet# puppet agent -tv
    2​Info: Creating a new SSL key for deployment-puppetmaster03.deployment-prep.eqiad.wmflabs
    3​Info: Caching certificate for ca
    4​Info: csr_attributes file loading from /etc/puppet/csr_attributes.yaml
    5​Info: Creating a new SSL certificate request for deployment-puppetmaster03.deployment-prep.eqiad.wmflabs
    6...
    • Sat, May 26, 4:44 PM
    • 18 Lines
  • 1​DejaVu Sans Bold
    2​DejaVu Sans Bold Oblique
    3​DejaVu Sans Book
    4​DejaVu Sans Condensed
    5​DejaVu Sans Condensed Bold
    6...
    • Fri, May 25, 10:26 PM
    • 101 Lines
    • Plain Text
  • 1​<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
    2​<html lang="en">
    3
    4​<head>
    5​ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    6...
    • Fri, May 25, 9:01 PM
    • 444 Lines
  • 1​while read host port; do echo "$host $port"; mysql -h $host -P $port -e "SELECT @@global."; echo "print '$(dig +short $host)'.split('.').inject(0) {|total,value| (total << 8 ) + value.to_i}" | ruby; echo; done < x1.hosts
    • Fri, May 25, 3:20 PM
    • 1 Line
  • 1​root@neodymium:/home/marostegui# for i in db1102 db1120 db1125; do echo "==$i==" ; /home/jynus/mysql.py -h$i -P3316 -e "select count(*) from ruwiki.user;" -BN ;done
    2​==db1102==
    3​2303811
    4​==db1120==
    5​2303811
    6...
    • Fri, May 25, 2:30 PM
    • 7 Lines
  • 1$ ./mysql.py -h db1092 sys -e "SELECT * FROM statement_analysis LIMIT 10"
    2+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
    3| query | db | full_scan | exec_count | err_count | warn_count | total_latency | max_latency | avg_latency | lock_latency | rows_sent | rows_sent_avg | rows_examined | rows_examined_avg | rows_affected | rows_affected_avg | tmp_tables | tmp_disk_tables | rows_sorted | sort_merge_passes | digest | first_seen | last_seen |
    4+-------------------------------------------------------------------+--------------+-----------+------------+-----------+------------+---------------+-------------+-------------+--------------+------------+---------------+---------------+-------------------+---------------+-------------------+------------+-----------------+-------------+-------------------+----------------------------------+---------------------+---------------------+
    5| SELECT `chd_site` FROM `wb_cha ... DER BY `chd_seen` ASC LIMIT ? | wikidatawiki | * | 2091637 | 0 | 0 | 5.02 w | 34.40 s | 1.45 s | 2.44 m | 31369835 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7c5ab9603647a7a91a3dc928be60c3b7 | 2018-01-16 16:33:10 | 2018-05-25 08:39:38 |
    6
    7...
    • Fri, May 25, 11:09 AM
    • 15 Lines
  • 1​2
    2​*************************** 1. row ***************************
    3​ Slave_IO_State:
    4​ Master_Host: db1074.eqiad.wmnet
    5​ Master_User: repl
    6...
    • Fri, May 25, 8:45 AM
    • 196 Lines
  • 1​ day hour count
    2​1 0 24697
    3​1 1 26527
    4​1 2 26782
    5​1 3 25987
    6...
    • Fri, May 25, 5:36 AM
    • 502 Lines
  • 1​root@db1116:~# for i in 1 3 5 8; do echo $i; mysql --skip-ssl -S /run/mysqld/mysqld.s$i.sock -e "show slave status\G" ; done
    2​1
    3​*************************** 1. row ***************************
    4​ Slave_IO_State:
    5​ Master_Host: db1106.eqiad.wmnet
    6...
    • Fri, May 25, 5:27 AM
    • 197 Lines
  • 1$ irb
    2irb(main):001:0> require 'puppet'
    3=> true
    4irb(main):002:0> require 'puppet/network/format_support'
    5=> false
    6
    7...
    • Thu, May 24, 10:53 PM
    • 12 Lines
  • 1​https://es.wikipedia.org/wiki/Plantilla:Commons has the following problematic output
    2
    3​Wikitext example:
    4
    5​{{Commons|Tectonic plate}}
    6...
    • Thu, May 24, 10:59 AM
    • 26 Lines
  • 1​Enable microcode updates for the following servers (one app server/API per server batch)):
    2
    3​app servers:
    4​mw1261, mw1319, mw1258
    5
    6...
    • Thu, May 24, 9:29 AM
    • 35 Lines
  • 1​May 22 18:57:22 maps-test2001 systemd[1]: tilerator.service holdoff time over, scheduling restart.
    2​May 22 18:57:22 maps-test2001 systemd[1]: Stopping "tilerator service"...
    3​May 22 18:57:22 maps-test2001 systemd[1]: Starting "tilerator service"...
    4​May 22 18:57:22 maps-test2001 systemd[1]: Started "tilerator service".
    5​May 22 18:57:22 maps-test2001 tilerator[5152]: Reading profile /etc/firejail/default.profile
    6...
    • Tue, May 22, 6:58 PM
    • 17 Lines
  • 1​gehel@maps1001:~$ curl -s localhost:9187/metrics
    2# HELP go_gc_duration_seconds A summary of the GC invocation durations.
    3# TYPE go_gc_duration_seconds summary
    4​go_gc_duration_seconds{quantile="0"} 0.00033880300000000004
    5​go_gc_duration_seconds{quantile="0.25"} 0.000519107
    6...
    • Tue, May 22, 3:50 PM
    • 902 Lines
    • Shell
  • 1​eevans@maps1001:~$ sudo -u cassandra ./estimated_droppable_tombstones.sh
    2​Estimated droppable tombstones: 0.42646843331757806
    3​Estimated droppable tombstones: 0.3620106904928384
    4​Estimated droppable tombstones: 0.33225075308925944
    5​Estimated droppable tombstones: 0.31065393657937873
    6...
    • Tue, May 22, 9:27 AM
    • 17 Lines
  • 1@mock.patch('pybal.monitors.proxyfetch.reactor', new_callable=twisted.test.proto_helpers.MemoryReactor)
    2def testGetProxyPageHTTP(self, mock_reactor):
    3testURL = "http://en.wikipedia.org/"
    4host = "cp1001.eqiad.wmnet"
    5port = 80
    6...
    • Mon, May 21, 4:04 PM
    • 13 Lines
    • Python
  • 1​krenair@deployment-certcentral:~$ sudo -u www-data /usr/bin/uwsgi --die-on-term --ini /etc/uwsgi/apps-enabled/le-central.ini
    2​[uWSGI] getting INI configuration from /etc/uwsgi/apps-enabled/le-central.ini
    3​*** Starting uWSGI 2.0.14-debian (64bit) on [Sun May 20 16:47:15 2018] ***
    4​compiled with version: 6.3.0 20170516 on 17 March 2018 15:41:47
    5​os: Linux-4.9.0-5-amd64 #1 SMP Debian 4.9.65-3+deb9u2 (2018-01-04)
    6...
    • Sun, May 20, 4:49 PM
    • 189 Lines
  • 1Traceback (most recent call last):
    2File "/usr/local/lib/python3.5/dist-packages/le-central/le-central.py", line 72, in certificate_management
    3signedCert = acme_tiny.get_crt('/etc/certcentral/acct.key', csr, '/etc/certcentral/http_challenges')
    4File "/usr/local/sbin/acme_tiny.py", line 107, in get_crt
    5"agreement": "https://letsencrypt.org/documents/LE-SA-v1.2-November-15-2017.pdf",
    6...
    • Sun, May 20, 11:48 AM
    • 26 Lines
    • Python
  • 1​0 1 * * * /usr/local/bin/foreachwiki extensions/SecurePoll/cli/purgePrivateVoteData.php >/dev/null 2>&1
    2​42 20 * * * /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblists/pageassessments.dblist extensions/PageAssessments/maintenance/purgeUnusedProjects.php > /dev/null
    3​15 1 * * 1 /usr/local/bin/foreachwiki extensions/AbuseFilter/maintenance/purgeOldLogIPData.php >/var/log/mediawiki/purge_abusefilter.log 2>&1
    4​0 5 */3 * * flock -n /var/lock/update-special-pages /usr/local/bin/foreachwiki updateSpecialPages.php > /var/log/mediawiki/updateSpecialPages.log 2>&1
    5​0 0 * * * /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblists/echo.dblist extensions/Echo/maintenance/processEchoEmailBatch.php >/dev/null
    6...
    • Sun, May 20, 11:19 AM
    • 10 Lines
    • Fri, May 18, 7:58 PM
    • 1 Line
  • 1​root@db1120:~# for i in 2 4 6 7; do echo $i; mysql --skip-ssl -S /run/mysqld/mysqld.s$i.sock -e "show slave status\G" ; done
    2​2
    3​*************************** 1. row ***************************
    4​ Slave_IO_State:
    5​ Master_Host: db1074.eqiad.wmnet
    6...
    • Fri, May 18, 5:37 AM
    • 197 Lines
  • 1​Donald Trump: Donald J Trump
    2​Donald Trump: DJ Trump
    3​Donald Trump: Donnie Trump
    4​Donald J Trump: Donald Trump
    5​Donald J Trump: DJ Trump
    6...
    • Wed, May 16, 4:05 PM
    • 12 Lines
  • 1​SHOW MASTER STATUS:
    2​ Log: db1102-bin.000931
    3​ Pos: 617540736
    4​ GTID:0-180359185-3359637071,171966555-171966555-302,171970590-171970590-196280066,171978764-171978764-35,171978767-171978767-2010544792,180359185-180359185-71998080
    5
    6...
    • Wed, May 16, 3:31 PM
    • 11 Lines
  • 1​[{"o":[1,["",["D","o"," ","t","h","i","s",":"," ",["h",["h7801d5c59271eac8"]],["t",["h7801d5c59271eac8"]],["t",["h7801d5c59271eac8"]],["p",["h7801d5c59271eac8"]],["s",["h7801d5c59271eac8"]],[":",["h7801d5c59271eac8"]],["/",["h7801d5c59271eac8"]],["/",["h7801d5c59271eac8"]],["w",["h7801d5c59271eac8"]],["w",["h7801d5c59271eac8"]],["w",["h7801d5c59271eac8"]],[".",["h7801d5c59271eac8"]],["m",["h7801d5c59271eac8"]],["e",["h7801d5c59271eac8"]],["d",["h7801d5c59271eac8"]],["i",["h7801d5c59271eac8"]],["a",["h7801d5c59271eac8"]],["w",["h7801d5c59271eac8"]],["i",["h7801d5c59271eac8"]],["k",["h7801d5c59271eac8"]],["i",["h7801d5c59271eac8"]],[".",["h7801d5c59271eac8"]],["o",["h7801d5c59271eac8"]],["r",["h7801d5c59271eac8"]],["g",["h7801d5c59271eac8"]],["/",["h7801d5c59271eac8"]],["w",["h7801d5c59271eac8"]],["i",["h7801d5c59271eac8"]],["k",["h7801d5c59271eac8"]],["i",["h7801d5c59271eac8"]],["/",["h7801d5c59271eac8"]],["U",["h7801d5c59271eac8"]],["s",["h7801d5c59271eac8"]],["e",["h7801d5c59271eac8"]],["r"...
    • Wed, May 16, 9:02 AM
    • 1 Line
  • 1​2
    2​*************************** 1. row ***************************
    3​ Slave_IO_State:
    4​ Master_Host: db1074.eqiad.wmnet
    5​ Master_User: repl
    6...
    • Wed, May 16, 8:21 AM
    • 196 Lines
  • 1#!/usr/bin/env python3
    2
    3from collections import defaultdict
    4import glob
    5import json
    6...
    • Tue, May 15, 5:48 PM
    • 29 Lines
  • 1​2018-05-11 16:12:25 <r054l13> Hi everyone
    2​2018-05-11 16:12:49 <r054l13> Please sory for being late for the meeting. Internet issues :(
    3​2018-05-11 16:13:10 <r054l13> I can see Eugene233 and africanhope :)
    4​2018-05-11 16:13:44 ** r054l13_ joined channel
    5​2018-05-11 16:13:44 <r054l13> I think the meeting can start if we are all present
    6...
    • Tue, May 15, 3:33 PM
    • 148 Lines
  • 1​The monthly article quality predictions have proven very useful. However, re-generating the data for new dumps is a time-consuming and highly manual process. There should be a job that runs periodically on the Analytics Cluster to keep this dataset up to date.
    2
    3​Here's the one-off dataset:
    4​https://figshare.com/articles/Monthly_Wikipedia_article_quality_predictions/3859800
    5
    6...
    • Tue, May 15, 10:44 AM
    • 7 Lines
  • 1​root@tools-bastion-05:~# qhost -j -h tools-exec-1414
    2​HOSTNAME ARCH NCPU LOAD MEMTOT MEMUSE SWAPTO SWAPUS
    3​-------------------------------------------------------------------------------
    4​global - - - - - - -
    5​tools-exec-1414.tools.eqiad.wmflabs lx26-amd64 4 - 7.8G - 23.9G -
    6...
    • Tue, May 15, 4:12 AM
    • 54 Lines
  • 1​From - Fri Feb 02 01:25:14 2018
    2​X-Mozilla-Status: 0001
    3​X-Mozilla-Status2: 00800000
    4​X-Mozilla-Keys:
    5​To: wikitech-l <wikitech-l@lists.wikimedia.org>
    6...
    • Tue, May 15, 1:35 AM
    • 83 Lines
  • 1/**
    2 * Load the styles of one or more ResourceLoader modules on this page.
    3 *
    4 * Module styles added through this function will be loaded as a stylesheet,
    5 * using a standard `<link rel=stylesheet>` HTML tag, rather than as a combined
    6...
    • Mon, May 14, 7:28 PM
    • 50 Lines
    • PHP
  • 1​FROM ubuntu:trusty
    2​RUN apt-get update && apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF && \
    3​ apt-get install -y apt-transport-https && \
    4​ echo "deb https://download.mono-project.com/repo/ubuntu stable-trusty main" | tee /etc/apt/sources.list.d/mono-official-stable.list && \
    5​ apt-get update && apt-get install -y mono-devel
    6...
    • Mon, May 14, 3:41 PM
    • 13 Lines
  • 1​s1
    2
    3​enwiki
    4​30
    5​74
    6...
    • Mon, May 14, 5:36 AM
    • 179 Lines
  • 1​```
    2​vagrant@mcr:/vagrant/mediawiki$ sudo strace mwscript shell.php
    3​execve("/usr/local/bin/mwscript", ["mwscript", "shell.php"], [/* 17 vars */]) = 0
    4​brk(NULL) = 0x55902ac9a000
    5​access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
    6...
    • Sat, May 12, 1:35 PM
    • 1,005 Lines
  • 1​tgr@terbium:~$ strace mwscript shell.php enwiki
    2​execve("/usr/local/bin/mwscript", ["mwscript", "shell.php", "enwiki"], [/* 19 vars */]) = 0
    3​brk(0) = 0x805000
    4​access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
    5​mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f3eef61d000
    6...
    • Sat, May 12, 1:32 PM
    • 229 Lines
  • 1import hashlib
    2import urllib
    3import cv2
    4from sklearn.metrics.pairwise import cosine_similarity
    5import numpy as np
    6...
    • Fri, May 11, 6:20 PM
    • 94 Lines
    • Python
  • 1​~/Documents/gerrit/mediawiki/vagrant/mediawiki$ which git-review
    2​/usr/local/bin/git-review
    3
    4​~/Documents/gerrit/mediawiki/vagrant/mediawiki$ git-review --version
    5​git-review version 1.26.0
    6...
    • Fri, May 11, 4:30 PM
    • 13 Lines
  • 1from ast import *
    2
    3parsed = parse('''def _altlang(lang):
    4 # Akan
    5 if lang in ['ak', 'tw']:
    6...
    • Fri, May 11, 7:01 AM
    • 231 Lines
    • Python
  • 1​[WvRQBwpEEj4AAD@La-cAAAAQ] /wiki/Special:CentralLogin/start?token=TOKEN Exception from line 85 of /srv/mediawiki/php-master/extensions/CentralAuth/includes/specials/SpecialCentralLogin.php: User 'Rxy' exists locally but is not attached.
    2
    3​Backtrace:
    4
    5​#0 /srv/mediawiki/php-master/extensions/CentralAuth/includes/specials/SpecialCentralLogin.php(98): Closure$SpecialCentralLogin::doLoginStart(CentralAuthUser, User, array)
    6...
    • Thu, May 10, 1:59 PM
    • 14 Lines
  • 1​awight@ores1001:/srv/deployment/ores/deploy$ git diff
    2​diff --git a/.gitmodules b/.gitmodules
    3​index ae8dfbe..b4dc493 100644
    4​--- a/.gitmodules
    5​+++ b/.gitmodules
    6...
    • Wed, May 9, 10:19 PM
    • 32 Lines
  • 1interface Foo {
    2function frob($x); // should become frob($x, $y = '')
    3}
    4
    5class MyFoo implements Foo { // in an extension
    6...
    • Wed, May 9, 10:12 PM
    • 92 Lines
    • PHP
  • 1​17:00 < kchapman> #startmeeting RFC meeting
    2​17:00 < kchapman> #topic Come up with a strategy for handling interface changes https://phabricator.wikimedia.org/T193613
    3​17:00 -!- dmaza [uid298049@gateway/web/irccloud.com/x-lnicfitvzvwcmtgg] has quit [Client Quit]
    4​17:01 -!- ccogdill [~ccogdill@tan241.corp.wikimedia.org] has quit [Quit: ccogdill]
    5​17:01 < kchapman> does the bot needed to be kicked? For some reason I remember it responding after the telling it to start the meeting (I may have remembered wrong)
    6...
    • Wed, May 9, 10:04 PM
    • 178 Lines
  • 1​ modified: Flask-0.10.1-cp35-none-any.whl
    2​ modified: Flask_Jsonpify-1.5.0-cp35-none-any.whl
    3​ modified: MarkupSafe-1.0-cp35-cp35m-linux_x86_64.whl
    4​ new file: PyMySQL-0.8.1-py2.py3-none-any.whl
    5​ modified: PyYAML-3.11-cp35-cp35m-linux_x86_64.whl
    6...
    • Wed, May 9, 9:21 PM
    • 22 Lines
  • 1​page_namespace page_title
    2​1 Q1
    3​1 Q10000
    4​1 Q10000000
    5​1 Q10009180
    6...
    • Wed, May 9, 5:45 PM
    • 19,016 Lines
  • 1​select user, css, js, json, css/(css+js) css_ratio from (select user, sum(case when ext = 'css' then cnt else 0 end) css, sum(case when ext = 'js' then cnt else 0 end) js, sum(case when ext = 'json' then cnt else 0 end) json from (select substr(regexp_substr(page_title, '\.(css|js|json)$'), 2) ext, rev_user_text user, count(*) cnt from page straight_join revision on rev_page = page_id where page_namespace = 8 and page_title rlike '^.*\.(css|js|json)$' group by user, ext) edits group by user) edits2 where css + js > 20 order by css + js desc;
    2
    3​enwiki:
    4​+----------------------------------+------+------+------+-----------+
    5​| user | css | js | json | css_ratio |
    6...
    • Wed, May 9, 1:26 PM
    • 200 Lines
  • 1<?php
    2
    3$json = file_get_contents( 'extension.json' );
    4$data = json_decode( $json, true );
    5$modules = $data[ 'ResourceModules' ];
    6...
    • Wed, May 9, 12:57 PM
    • 18 Lines
    • PHP
  • 1​2018-05-09 12:13:31,380: gnt-node add pid=1759 client:142 DEBUG Starting request <ganeti.http.client.HttpClientRequest 10.192.0.38:1811 POST /version at 0x7ff01c8cbe90>
    2​2018-05-09 12:13:31,443: gnt-node add pid=1759 client:228 DEBUG Request <ganeti.http.client.HttpClientRequest 10.192.0.38:1811 POST /version at 0x7ff01c8cbe90> finished, errmsg=None
    3​2018-05-09 12:13:32,893: gnt-node add pid=1759 cli:1225 ERROR Error during command processing
    4​Traceback (most recent call last):
    5​ File "/usr/share/ganeti/2.15/ganeti/cli.py", line 1221, in GenericMain
    6...
    • Wed, May 9, 12:43 PM
    • 27 Lines
  • 1​1
    2​*************************** 1. row ***************************
    3​ Slave_IO_State:
    4​ Master_Host: db1106.eqiad.wmnet
    5​ Master_User: repl
    6...
    • Wed, May 9, 5:25 AM
    • 196 Lines
  • 1​mysql:root@localhost [(none)]> show slave status\G
    2​*************************** 1. row ***************************
    3​ Slave_IO_State:
    4​ Master_Host: db1072.eqiad.wmnet
    5​ Master_User: repl
    6...
    • Wed, May 9, 5:19 AM
    • 49 Lines
  • 1​root@tools-worker-1001:~# systemctl cat docker.service
    2​# /lib/systemd/system/docker.service
    3​[Unit]
    4​Description=Docker Application Container Engine
    5​Documentation=https://docs.docker.com
    6...
    • Tue, May 8, 11:39 PM
    • 78 Lines
  • 1​chad@derpy ~/git/ops/gerrit (stable-2.14) $ ./deploy_artifacts.py --version=2.14.8 gerrit.war
    2​mvn deploy:deploy-file -DrepositoryId=wikimedia.releases -DgroupId=com.googlesource -DartifactId=gerrit -Dversion=2.14.8 -Dpackaging=war -Dfile=gerrit.war -Durl=https://archiva.wikimedia.org/repository/releases/ -DgeneratePom=false
    3​[INFO] Scanning for projects...
    4​[INFO]
    5​[INFO] ------------------< org.apache.maven:standalone-pom >-------------------
    6...
    • Tue, May 8, 10:41 PM
    • 21 Lines
  • 1​chad@derpy ~/gerrit-workspace/gerrit (wmf/stable-2.14) $ git diff
    2​diff --git a/.gitignore b/.gitignore
    3​index 4dfd6f268e..45147a901e 100644
    4​--- a/.gitignore
    5​+++ b/.gitignore
    6...
    • Tue, May 8, 5:24 PM
    • 21 Lines
  • 1​$namespaceNames = array( $namespaceNames = array( 47
    2​48 » NS_MEDIA => 'माध्यमम्', » NS_MEDIA => 'माध्यमम्', 48
    3​49 » NS_SPECIAL => 'विशेषः', » NS_SPECIAL => 'विशेषः', 49
    4​50 » NS_TALK => 'सम्भाषणम्', » NS_TALK => 'सम्भाषणम्', 50
    5​51 » NS_USER => 'सदस्यः', » NS_USER => 'सदस्यः', 51
    6...
    • Tue, May 8, 10:55 AM
    • 256 Lines
  • 1​=== shard 1 ===
    2​*************************** 1. row ***************************
    3​ Slave_IO_State:
    4​ Master_Host: db1106.eqiad.wmnet
    5​ Master_User: repl
    6...
    • Tue, May 8, 8:05 AM
    • 196 Lines
  • 1​zhuyifei1999@toolsbeta-worker-1001:~$ curl https://toolsbeta-flannel-etcd-01.toolsbeta.eqiad.wmflabs:2379/v2/keys/?recursive=true; echo
    2​{"action":"get","node":{"dir":true}}
    3
    4​[A long time of digging around...]
    5​zhuyifei1999@toolsbeta-worker-1001:~$ curl https://toolsbeta-flannel-etcd-01.toolsbeta.eqiad.wmflabs:2379/v2/keys/coreos.com/network/config -XPUT -d value='{ "Network": "192.168.128.0/17", "Backend": { "Type": "vxlan" } }'
    6...
    • Tue, May 8, 2:20 AM
    • 72 Lines
  • 1​toolsbeta.admin@toolsbeta-bastion-01:~$ webservice --backend kubernetes php5.6 start
    2​Starting webservice..
    3​toolsbeta.admin@toolsbeta-bastion-01:~$ kubectl get pods
    4​NAME READY STATUS RESTARTS AGE
    5​admin-1850377006-x00n5 1/1 Running 0 7s
    6...
    • Mon, May 7, 9:54 PM
    • 38 Lines
  • 1Traceback (most recent call last):
    2File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1836, in __call__
    3return self.wsgi_app(environ, start_response)
    4File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1820, in wsgi_app
    5response = self.make_response(self.handle_exception(e))
    6...
    • Mon, May 7, 9:00 PM
    • 26 Lines
    • Python
  • 1​root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1102 -P3312 -e "show slave status\G"
    2​*************************** 1. row ***************************
    3​ Slave_IO_State: Waiting for master to send event
    4​ Master_Host: db1060.eqiad.wmnet
    5​ Master_User: repl
    6...
    • Mon, May 7, 7:22 AM
    • 49 Lines
  • 1​s1
    2​enwiki
    3​af_id
    4​3
    5​4
    6...
    • Mon, May 7, 6:16 AM
    • 4,065 Lines
  • 1​s1
    2​enwiki
    3​af_id
    4​30
    5​74
    6...
    • Mon, May 7, 6:07 AM
    • 359 Lines
  • 1​04:30:01 PHPUnit 6.5.8 by Sebastian Bergmann and contributors.
    2​04:30:01
    3​04:30:01 EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE 55 / 55 (100%)
    4​04:30:01
    5​04:30:01 Time: 53 ms, Memory: 4.00MB
    6...
    • Sun, May 6, 4:35 AM
    • 282 Lines
  • 1​zhuyifei1999@toolsbeta-k8s-master-01:~$ sudo kubectl delete namespace test test2 admin toolschecker
    2​namespace "test" deleted
    3​namespace "test2" deleted
    4​namespace "admin" deleted
    5​namespace "toolschecker" deleted
    6...
    • Sat, May 5, 8:34 PM
    • 42 Lines
  • 1​{'talk_page_title': 'Dragon_Ball_Z:_Sagas', 'talk_page_id': 12447632, 'cache': {'feature_vector.revision.text.google_news_vector_mean': [0.0]}, 'templates': ['Template:WikiProject Anime and manga', 'Template:WikiProject Anime and manga/B check', 'Template:WikiProject Anime and manga/class', 'Template:WikiProject Anime and manga/type check', 'Template:WikiProject Video games', 'Template:WikiProject Video games/class', 'Template:WikiProject Video games/importance'], 'title': 'Dragon_Ball_Z:_Sagas', 'rev_id': 58621232, 'mid_level_categories': ['Culture.Entertainment', 'Culture.Visual arts']}
    2​{'talk_page_title': 'Skanda_Upanishad', 'talk_page_id': 45132118, 'cache': {'feature_vector.revision.text.google_news_vector_mean': [0.0]}, 'templates': ['Template:WikiProjectBannerShell', 'Template:WikiProject Hinduism', 'Template:WikiProject India', 'Template:WikiProject India/class', 'Template:WikiProject Philosophy', 'Template:WikiProject Philosophy/class', 'Template:WikiProject Religious texts', 'Template:WikiProject banner shell'], 'title': 'Skanda_Upanishad', 'rev_id': 642448963, 'mid_level_categories': ['Culture.Language and literature', 'Culture.Philosophy and religion', 'Geography.Countries']}
    3​{'talk_page_title': 'Kevatta_Sutta', 'talk_page_id': 10226226, 'cache': {'feature_vector.revision.text.google_news_vector_mean': [0.0]}, 'templates': ['Template:WikiProject Buddhism', 'Template:WikiProject Buddhism/class', 'Template:WikiProject Religious texts'], 'title': 'Kevatta_Sutta', 'rev_id': 112290628, 'mid_level_categories': ['Culture.Language and literature', 'Culture.Philosophy and religion']}
    4​{'talk_page_title': 'Bravo_(5566_album)', 'talk_page_id': 28333112, 'cache': {'feature_vector.revision.text.google_news_vector_mean': [0.0]}, 'templates': ['Template:WikiProject Albums', 'Template:WikiProject Albums/class'], 'title': 'Bravo_(5566_album)', 'rev_id': 184419607, 'mid_level_categories': ['Culture.Performing arts']}
    5​{'talk_page_title': 'Jōmon_Venus', 'talk_page_id': 52437355, 'cache': {'feature_vector.revision.text.google_news_vector_mean': [0.0]}, 'templates': ['Template:WikiProject Archaeology', 'Template:WikiProject Japan', 'Template:WikiProject Japan/class', 'Template:WikiProject Visual arts', "Template:WikiProject Women's History", "Template:WikiProject Women's history", 'Template:WikiProject banner shell'], 'title': 'Jōmon_Venus', 'rev_id': 749444131, 'mid_level_categories': ['Geography.Countries', 'STEM.Science', 'Culture.Visual arts']}
    6...
    • Fri, May 4, 8:21 PM
    • 9 Lines
  • 1​chad@derpy ~/git/scappish/scap (master) $ python3 -m pytest
    2​Test session starts (platform: darwin, Python 3.6.5, pytest 3.5.1, pytest-sugar 0.9.1)
    3​rootdir: /Users/chad/git/scappish/scap, inifile: tox.ini
    4​plugins: sugar-0.9.1, leaks-0.2.2, cov-2.5.1
    5
    6...
    • Fri, May 4, 7:47 PM
    • 162 Lines
  • 1​ct=# \d
    2​ List of relations
    3​ Schema | Name | Type | Owner
    4​--------+---------------------------+-------+---------
    5​ public | addresses_point | table | sbisson
    6...
    • Fri, May 4, 4:43 PM
    • 51 Lines
  • 1​root@PRODUCTION s1 slave[(none)]> select @@hostname;
    2​+------------+
    3​| @@hostname |
    4​+------------+
    5​| db1066 |
    6...
    • Fri, May 4, 6:44 AM
    • 55 Lines
  • 1<html>
    2<head>
    3<script>
    4​document.addEventListener("DOMContentLoaded", function () {
    5​ console.info('DOMContentLoaded');
    6...
    • Thu, May 3, 8:54 PM
    • 21 Lines
    • HTML
  • 1​ERROR 1: ERROR: could not load library "/usr/local/lib/postgresql/postgis-2.4.so": dlopen(/usr/local/lib/postgresql/postgis-2.4.so, 10): Library not loaded: /usr/local/opt/proj/lib/libproj.12.dylib
    2​ Referenced from: /usr/local/lib/postgresql/postgis-2.4.so
    3​ Reason: image not found
    4
    5​ERROR 1: ERROR: could not load library "/usr/local/lib/postgresql/postgis-2.4.so": dlopen(/usr/local/lib/postgresql/postgis-2.4.so, 10): Library not loaded: /usr/local/opt/proj/lib/libproj.12.dylib
    6...
    • Thu, May 3, 7:42 PM
    • 30 Lines
  • 1​INFO:root:Checking table simplified_ocean_polygons
    2​DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): data.openstreetmapdata.com
    3​DEBUG:urllib3.connectionpool:http://data.openstreetmapdata.com:80 "GET /simplified-water-polygons-complete-3857.zip HTTP/1.1" 200 23613797
    4​DEBUG:root:running ogr2ogr -f PostgreSQL -lco GEOMETRY_NAME=way -lco SPATIAL_INDEX=FALSE -lco EXTRACT_SCHEMA_FROM_LAYER_NAME=YES -nln loading.simplified_ocean_polygons PG:dbname=ct data/simplified_ocean_polygons/simplified-water-polygons-complete-3857/simplified_water_polygons.shp
    5​CRITICAL:root:ogr2ogr returned 1 with layer simplified_ocean_polygons
    6...
    • Thu, May 3, 7:40 PM
    • 25 Lines
  • 1​AaronSchulz | greg-g: a bit distracted at the moment. Something like https://gerrit.wikimedia.org/r/#/c/430273/ might help. I was looking into this
    2​ | area yesterday due some wikibase test failures.
    • Thu, May 3, 5:34 PM
    • 2 Lines
  • 1​Traceback (most recent call last):
    2​ File "/usr/local/bin/varnishtlsinspector", line 73, in <module>
    3​ VarnishTLSInspector(sys.argv[1:]).main()
    4​ File "/usr/local/lib/python3.4/dist-packages/wikimedia_varnishlogconsumer.py", line 188, in main
    5​ line = p.stdout.readline().rstrip('\n')
    6...
    • Thu, May 3, 3:18 PM
    • 6 Lines
  • 1​vgutierrez@neodymium:~$ sudo cumin cp*.esams.wmnet "systemctl status varnish-frontend-tlsinspector |grep Active |cut -f2 -d':' |cut -d' ' -f1-3"
    2​26 hosts will be targeted:
    3​cp[3004-3008,3010,3030-3049].esams.wmnet
    4​Confirm to continue [y/n]? y
    5​===== NODE GROUP =====
    6...
    • Thu, May 3, 3:11 PM
    • 17 Lines
  • 1​asw-c-eqiad:
    2​ interface-range LVS-balancer {
    3​ member-range xe-8/0/23 to xe-8/0/25;
    4​ unit 0 {
    5​ family ethernet-switching {
    6...
    • Thu, May 3, 2:00 PM
    • 26 Lines
  • 1​FIXED: db1063 m1 master - fail it manually and replace
    2​db1064 s4 slave - ack and replace it only when failed
    3​db1066 s1 slave - ack and replace it only when failed
    4​FIXED: db1073 m5 master - fail it manually and replace
    5​dbstore1002 - talk to analytics (but possibly replace it only when failed)
    • Thu, May 3, 12:29 PM
    • 5 Lines
  • 1​May 03 04:03:16 toolsbeta-k8s-master-01 systemd[1]: Starting Kubernetes API Server...
    2​-- Subject: Unit kube-apiserver.service has begun with start-up
    3​-- Defined-By: systemd
    4​-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    5​--
    6...
    • Thu, May 3, 4:06 AM
    • 20 Lines
  • 1​May 03 01:03:29 toolsbeta-proxy-01 systemd[1]: Starting A high performance web server and a reverse proxy server...
    2​-- Subject: Unit nginx.service has begun with start-up
    3​-- Defined-By: systemd
    4​-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    5​--
    6...
    • Thu, May 3, 1:04 AM
    • 18 Lines
  • 1​May 03 00:46:26 toolsbeta-k8s-etcd-01 systemd[1]: Starting etcd...
    2​-- Subject: Unit etcd.service has begun with start-up
    3​-- Defined-By: systemd
    4​-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    5​--
    6...
    • Thu, May 3, 1:02 AM
    • 41 Lines
  • 1​ 155 2018-05-02 23:28:48 sudo puppet agent -tv
    2​ 156 2018-05-02 23:29:51 qstat -f
    3​ 157 2018-05-02 23:29:53 sudo puppet agent -tv
    4​ 171 2018-05-02 23:31:17 qstat -f
    5​ 172 2018-05-02 23:32:10 host toolsbeta-grid-master.toolsbeta.eqiad.wmflabs
    6...
    • Thu, May 3, 12:44 AM
    • 85 Lines
  • 1MariaDB [metawiki_p]> describe user;
    2+--------------------------+-----------------+------+-----+---------+-------+
    3| Field | Type | Null | Key | Default | Extra |
    4+--------------------------+-----------------+------+-----+---------+-------+
    5| user_id | int(5) unsigned | NO | | 0 | |
    6...
    • Wed, May 2, 8:19 PM
    • 22 Lines
    • MySQL
  • 1-webkit-align-content: value;
    2-webkit-box-align: value;
    3-webkit-align-items: value;
    4-webkit-align-self: value;
    5-webkit-animation: value;
    6...
    • Tue, May 1, 10:22 PM
    • 106 Lines
    • CSS
  • 1​ /{domain:1209.miraheze.org}:
    2​ x-modules:
    3​ - path: /srv/restbase/projects/example.yaml
    4​ options:
    5​ action:
    6...
    • Tue, May 1, 7:23 PM
    • 21 Lines
  • 1​| e76864c4-14ef-4a5f-86f3-d28bddd222d7 | bastion-01 | bastion | ACTIVE | - | Running | public=10.68.17.232, 208.80.155.129 |
    2​| d0fbda52-c292-45a8-a8d2-0374cd3328c2 | bastion-02 | bastion | ACTIVE | - | Running | public=10.68.18.65, 208.80.155.153 |
    3​| 1dc6c5d8-a5bd-4c12-98dd-0062651866b7 | bastion-restricted-01 | bastion | ACTIVE | - | Running | public=10.68.18.66, 208.80.155.155 |
    4​| 20804f7d-5b5b-4937-b32a-faf1b33d0575 | ceph-3 | services | ACTIVE | - | Running | public=10.68.23.121 |
    5​| 3ae0bcec-5dda-4598-891e-01ad707f47d1 | cvn-app8 | cvn | ACTIVE | - | Running | public=10.68.22.2, 208.80.155.230 |
    6...
    • Tue, May 1, 2:45 PM
    • 104 Lines
  • 1​There were 17 errors:
    2
    3​1) MediaWiki\Tests\Storage\SqlBlobStoreTest::testSimpleStoreGetBlobSimpleRoundtripWindowsLegacyEncodingGzip with data set #1 ('someText')
    4​gzinflate(): data error
    5
    6...
    • Tue, May 1, 2:38 PM
    • 482 Lines
  • 1​nobody@20db68baccc8:/quibble$ pg_virtualenv python3 -m quibble.cmd --run phpunit --db postgres
    2​install: cannot change owner and permissions of ‘/tmp/pg_virtualenv.HpXjnt/postgresql/9.6’: Operation not permitted
    3​Creating new cluster 9.6/regress ...
    4​ config /tmp/pg_virtualenv.HpXjnt/postgresql/9.6/regress
    5​ data /tmp/pg_virtualenv.HpXjnt/data/9.6/regress
    6...
    • Tue, May 1, 5:28 AM
    • 477 Lines
  • 1​~/dns/templates$ ls -hals | grep parking | cut -d " " -f17,18,19
    2​border-wikipedia.de -> parking
    3​donatetowikipedia.com -> parking
    4​donatetowikipedia.org -> parking
    5​indiawikipedia.com -> parking
    6...
    • Mon, Apr 30, 8:26 PM
    • 77 Lines
  • 1​awight@tin:/srv/deployment/ores/deploy$ scap deploy-log -f scap/log/scap-sync-2018-04-26-0001-2-g46824bb.log
    2​18:04:57 [tin] Started deploy [ores/deploy@46824bb]
    3​18:04:57 [tin] Deploying Rev: HEAD = 46824bb18f206674272ebcf250532d0debab2d9e
    4​18:04:57 [tin] Started deploy [ores/deploy@46824bb]: Canary-only test deployment for ORES + git-lfs, T181678 (take 2)
    5​18:04:57 [tin]
    6...
    • Mon, Apr 30, 6:11 PM
    • 45 Lines
  • 1from collections import OrderedDict
    2import copy
    3import json
    4import logging
    5from pprint import pprint
    6...
    • Mon, Apr 30, 4:55 PM
    • 418 Lines
    • Python
  • 1​I am doing something like this (this is not actual data; otherwise it would be private. I changed the values):
    2
    3​research_prod@db1108.eqiad.wmnet(log)>select
    4​ -> concat(wiki, ': ', event_title) as title,
    5​ -> event_token,
    6...
    • Mon, Apr 30, 10:04 AM
    • 31 Lines
  • 1​root@db1116:/srv/tmp.s3/s3# cat metadata.partial | grep -A3 "s3"
    2​ Connection name: s3
    3​ Host: db1072.eqiad.wmnet
    4​ Log: db1072-bin.000824
    5​ Pos: 563546348
    • Mon, Apr 30, 8:27 AM
    • 5 Lines
  • 1​root@db1095[(none)]> show slave 's3' status\G
    2​*************************** 1. row ***************************
    3​ Slave_IO_State:
    4​ Master_Host: db1072.eqiad.wmnet
    5​ Master_User: repl
    6...
    • Mon, Apr 30, 7:04 AM
    • 49 Lines
  • 1​km@km-pt:/srv/mediawiki/php/wikidiff2$ phpize
    2​Configuring for:
    3​PHP Api Version: 20170718
    4​Zend Module Api No: 20170718
    5​Zend Extension Api No: 320170718
    6...
    • Sun, Apr 29, 9:22 PM
    • 171 Lines
  • 1#!/bin/bash
    2
    3USAGE="Usage: "$(basename $0)" <sourcefile> <width>"
    4
    5if [ ! -f "$1" ]; then
    6...
    • Sun, Apr 29, 4:02 AM
    • 29 Lines
    • Bash Scripting
  • 1​core2 $ cat dist/pipeline/blubber.yaml
    2​version: v1
    3​base: docker-registry.wikimedia.org/wikimedia-stretch
    4​apt:
    5​ packages:
    6...
    • Fri, Apr 27, 11:02 PM
    • 130 Lines
    • Fri, Apr 27, 10:24 PM
    • 1 Line
  • 1​name updated_at created_at
    2​cp1008.wikimedia.org 2018-04-27 14:41:03+00:00 2015-03-09 18:07:18+00:00
    3​cp1008.wikimedia.org 2018-04-27 14:41:03+00:00 2017-11-29 14:30:49+00:00
    4​cp1061.eqiad.wmnet 2018-04-27 14:49:01+00:00 2015-03-11 20:07:02+00:00
    5​cp1061.eqiad.wmnet 2018-04-27 14:49:01+00:00 2017-11-08 16:36:21+00:00
    6...
    • Fri, Apr 27, 2:59 PM
    • 76 Lines
  • 1​gjg@integration-slave-jessie-1001:/srv/jenkins-workspace/workspace$ du -sh *
    2​511M analytics-refinery-release
    3​4.0K analytics-refinery-release@tmp
    4​422M analytics-refinery-update-jars
    5​4.0K analytics-refinery-update-jars@tmp
    6...
    • Apr 26 2018, 4:48 PM
    • 34 Lines
  • 1commons_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds_data:
    2statement: |
    3ALTER TABLE "commons_T_mobile__ng3HeqOXXmkYfPizz4RPUR4OLXLds".data WITH default_time_to_live = 15552000
    4
    5commons_T_mobile__ngR6XB1sh6_FFo_mfX4oZA56vpD_w_data:
    6...
    • Apr 25 2018, 5:52 PM
    • 64 Lines
    • YAML
  • 1​16:50:36 greg-g | thcipriani: marx<tab>: so, should we remove those "add X support to blubber" goals from Q4? Since we might get to the same kind of
    2​ | place without that and their very implementation detail specific?
    3​16:52:13 thcipriani | maybe. I want dan's take on it when he joins, too. I think "Build MediaWiki base containers upon branch cut at master branch point
    4​ | from core" might even be "implementation" at this point as well, honestly.
    5​16:52:44 * | greg-g nods
    6...
    • Apr 25 2018, 5:43 PM
    • 8 Lines