Page MenuHomePhabricator
Paste Active Pastes
  • commit abe51c977df423f44513a0e5a860ec5d3b539917 (benchmark-tokenizer)
    Author: Tim Starling <tstarling@wikimedia.org>
    Date: Fri Dec 18 08:51:48 2015 +1100
    Benchmark tokenizer
    ...
    • Mar 21 2019, 4:10 AM
    • 121 Lines
  • diff --git a/modules/ext.pageTriage.views.toolbar/ext.pageTriage.toolbarView.js b/modules/ext.pageTriage.views.toolbar/ext.pageTriage.toolbarView.js
    index c5e3761..0fa8bd8 100644
    --- a/modules/ext.pageTriage.views.toolbar/ext.pageTriage.toolbarView.js
    +++ b/modules/ext.pageTriage.views.toolbar/ext.pageTriage.toolbarView.js
    @@ -127,20 +127,19 @@ $( function () {
    ...
    • Mar 21 2019, 2:28 AM
    • 72 Lines
    • Diff
  • root@deployment-acme-chief03:~# openssl x509 -in /var/lib/acme-chief/certs/unified/live/rsa-2048.crt -noout -text
    Certificate:
    Data:
    Version: 3 (0x2)
    Serial Number:
    ...
    • Mar 20 2019, 6:55 PM
    • 99 Lines
  • year month day hour sugg_requested sugg_provided
    2019 3 18 0 1248647 360646
    2019 3 18 1 1239919 352674
    2019 3 18 10 987285 277958
    2019 3 18 11 1097645 308659
    ...
    • Mar 20 2019, 6:01 PM
    • 49 Lines
  • Forcing to use the ECDSA TLS certificate by setting the cipher to ECDHE-ECDSA-AES256-GCM-SHA384 we still get the OCSP response for the RSA one:
    willikins:certs vgutierrez$ echo | openssl s_client -connect localhost:3129 -servername pinkunicorn.wikimedia.org -status -cipher ECDHE-ECDSA-AES256-GCM-SHA384 2>/dev/null |openssl x509 -noout -serial
    serial=03948087E0D3AD8134158060E3D0DA9FAC67
    ...
    • Mar 20 2019, 3:25 PM
    • 34 Lines
  • git review
    remote: Branch refs/heads/master:
    remote: You need 'Push' rights to upload code review requests.
    remote: Verify that you are pushing to the right branch.
    remote: User: marostegui
    ...
    • Mar 20 2019, 6:15 AM
    • 11 Lines
  • ---
    apiVersion: tekton.dev/v1alpha1
    kind: PipelineResource
    metadata:
    name: blubber-master-branch
    ...
    • Mar 19 2019, 10:30 PM
    • 61 Lines
  • Create a new group, Trusted Users, who are allowed to read refs/*
    This effectively makes all projects hidden to users who are logged
    in (Registered Users) but who are not in the Trusted User group.
    ...
    • Mar 19 2019, 10:08 PM
    • 8 Lines
  • #!/usr/bin/env python
    import itertools
    import subprocess
    import requests
    ...
    • Mar 19 2019, 9:08 PM
    • 85 Lines
    • Python
  • From yesterday:
    /hikebike
    2934572 "-"
    247470 www.gaiagps.com
    ...
    • Mar 19 2019, 9:06 PM
    • 72 Lines
  • [thcipriani@deploy1001 VisualEditor (master u=)]$ cat .gitmodules
    [submodule "lib/ve"]
    path = lib/ve
    url = https://gerrit.wikimedia.org/r/p/VisualEditor/VisualEditor.git
    • Mar 19 2019, 3:58 PM
    • 4 Lines
  • Mar 19 15:02:33 acmechief1001 acme-chief-backend[9078]: Missing/invalid DNS zone updater CMD timeout, using the default one: 60.00
    Mar 19 15:02:34 acmechief1001 acme-chief-backend[9078]: Number of certificates per status: Counter({'VALID': 26, 'NEEDS_RENEWAL': 2})
    Mar 19 15:02:38 acmechief1001 acme-chief-backend[9078]: Handling new certificate event for librenms / ec-prime256v1
    Mar 19 15:02:38 acmechief1001 acme-chief-backend[9078]: Creating new certificate version 6beb218837f8413d9c5c228691bd9fd8 for librenms
    Mar 19 15:02:39 acmechief1001 acme-chief-backend[9078]: Triggering DNS zone update...
    ...
    • Mar 19 2019, 3:05 PM
    • 42 Lines
  • krenair@deployment-acme-chief03:~$ sudo -i
    root@deployment-acme-chief03:~# cd /var/lib/puppet; mv ssl ssl_old; rm /usr/local/share/ca-certificates/Puppet_Internal_CA.crt; nano /usr/local/share/ca-certificates/Puppet_Internal_CA.crt; update-ca-certificates --fresh; puppet agent -tv
    Clearing symlinks in /etc/ssl/certs...
    done.
    Updating certificates in /etc/ssl/certs...
    ...
    • Mar 18 2019, 11:23 PM
    • 442 Lines
  • public Dataset<Row> buildPairsForM0Prep(Dataset<Row> df, Dataset<Row> dfOld, GlentParams params) {
    dfOld = dfOld
    .where(col("part").equalTo(params.glentDfM0PrepPartOld)) // limit to previous portion of M0Prep dataframe
    .drop(col("part"));
    ...
    • Mar 18 2019, 4:46 PM
    • 41 Lines
  • wikiadmin@10.64.32.115(enwiki)> SELECT user_name FROM user WHERE user_name IN ( select pl_title from pagelinks where pl_from = 57597719 AND pl_namespace = 3 ) AND user_touched > '20140301000000';
    +----------------------+
    | user_name |
    +----------------------+
    | Aarky |
    ...
    • Mar 18 2019, 3:28 PM
    • 230 Lines
    • SQL
  • Info: Using configured environment 'production'
    Info: Retrieving pluginfacts
    Info: Retrieving plugin
    Info: Loading facts
    Info: Caching catalog for integration-slave-docker-1051.integration.eqiad.wmflabs
    ...
    • Mar 18 2019, 11:24 AM
    • 232 Lines
  • --- /etc/haproxy/conf.d/db-master.cfg 2019-03-18 10:00:32.167405320 +0000
    +++ db-master.cfg 2019-03-18 10:00:17.562538476 +0000
    @@ -8,4 +8,4 @@
    option tcpka
    option mysql-check user haproxy
    ...
    • Mar 18 2019, 10:00 AM
    • 8 Lines
  • .overlay {
    position: absolute;
    top: 10em;
    left: 10em;
    ...
    • Mar 18 2019, 6:17 AM
    • 43 Lines
  • nfo: Using configured environment 'production'
    Info: Retrieving pluginfacts
    Info: Retrieving plugin
    Info: Loading facts
    Info: Caching catalog for tools-worker-1018.tools.eqiad.wmflabs
    ...
    • Mar 17 2019, 5:30 PM
    • 168 Lines
  • select
    event_entity,
    year,
    name_status,
    count(*) as rows
    ...
    • Mar 16 2019, 4:35 AM
    • 169 Lines
  • P8209 nscd rh
    NSCD is not caching LDAP users reliably
    SOLUTION VERIFIED - Updated August 6 2015 at 12:49 PM - English
    Environment
    Red Hat Enterprise Linux 5
    Red Hat Enterprise Linux 6
    ...
    • Mar 15 2019, 5:32 PM
    • 45 Lines
  • xrandr --setprovideroutputsource 1 0 && \
    xrandr --setprovideroutputsource 2 0 && \
    xrandr --output DVI-I-2-2 --auto --pos 1920x0 --rotate normal --output DVI-I-1-1 --auto --pos 3840x0 --rotate normal
    • Mar 15 2019, 4:19 PM
    • 3 Lines
  • ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIK4utj9osWuPYu5lxsbNoWMaae6K7rtabeoUDRkBw8Rs 2019-03-15-new-ubuntu-prod
    • Mar 15 2019, 2:31 PM
    • 1 Line
  • # Selenium tests
    For more information see https://www.mediawiki.org/wiki/Selenium
    ## Setup
    ...
    • Mar 15 2019, 12:41 PM
    • 21 Lines
    • Plain Text
  • #!/usr/bin/python3 -OO
    import os
    import sys
    import psutil
    ...
    • Mar 15 2019, 10:33 AM
    • 46 Lines
  • git config --global alias.st status
    git config --global alias.co checkout
    git config --global alias.ci commit
    git config --global alias.br branch
    git config --global alias.lg log --graph --abbrev-commit --decorate --format=format:'%C(bold blue)%h%C(reset) - %C(bold green)(%ar)%C(reset) %C(white)%s%C(reset) %C(dim white)- %an%C(reset)%C(bold yellow)%d%C(reset)' --all
    ...
    • Mar 14 2019, 8:46 PM
    • 14 Lines
  • git config alias.st status
    git config alias.co checkout
    git config alias.ci commit
    git config alias.br branch
    git config alias.lg log --graph --abbrev-commit --decorate --format=format:'%C(bold blue)%h%C(reset) - %C(bold green)(%ar)%C(reset) %C(white)%s%C(reset) %C(dim white)- %an%C(reset)%C(bold yellow)%d%C(reset)' --all
    ...
    • Mar 14 2019, 8:29 PM
    • 14 Lines
  • ssh -6 paladox@2620::861:3:208:80:154:85 -p 29418
    **** Welcome to Gerrit Code Review ****
    Hi Paladox, you have successfully connected over SSH.
    ...
    • Mar 14 2019, 7:31 PM
    • 12 Lines
  • import subprocess
    input_file = '/mnt/data/xmldatadumps/public/svwiki/20190301/svwiki-20190301-pages-meta-history.xml.bz2'
    output = subprocess.check_output(['getlastidinbz2xml', '-f', input_file, '--type', 'page'])
    ...
    • Mar 14 2019, 4:17 PM
    • 31 Lines
    • Python
  • maurelio@deployment-deploy01:~$ sql deploymentwiki;
    Fatal error: Uncaught RuntimeException: RedisConnectionPool requires a Redis client library. See https://www.mediawiki.org/wiki/Redis#Setup in /srv/mediawiki-staging/php-master/includes/libs/redis/RedisConnectionPool.php:80
    Stack trace:
    ...
    • Mar 14 2019, 1:56 PM
    • 11 Lines
  • kartik@deploy1001:/srv/mediawiki-staging/php-1.33.0-wmf.21/skins$ git status
    On branch wmf/1.33.0-wmf.21
    Your branch is ahead of 'origin/wmf/1.33.0-wmf.21' by 7 commits.
    (use "git push" to publish your local commits)
    Changes not staged for commit:
    ...
    • Mar 14 2019, 11:20 AM
    • 11 Lines
  • enwiki:
    root@db1114[sys]> select * FROM schema_auto_increment_columns LIMIT 4 \G
    *************************** 1. row ***************************
    table_schema: enwiki
    ...
    • Mar 14 2019, 10:10 AM
    • 97 Lines
  • varnishtest "304 update headers of cached object"
    server s1 {
    rxreq
    txresp -hdr "X-Banana: true" -hdr "X-Tomato: true" -hdr "Last-Modified: Thu, 26 Jun 2008 12:00:01 GMT" -body "Ciao prova"
    ...
    • Mar 14 2019, 7:26 AM
    • 34 Lines
  • $ sudo cumin --force 'name:docker' 'zgrep -c php.*segfault /var/log/kern.log*'
    14 hosts will be targeted:
    integration-slave-docker-[1021,1034,1037,1040-1041,1043,1045-1046,1048-1053].integration.eqiad.wmflabs
    FORCE mode enabled, continuing without confirmation
    ===== NODE GROUP =====
    ...
    • Mar 13 2019, 8:25 PM
    • 106 Lines
  • sudo cumin --force 'name:docker' 'zgrep php.*segfault /var/log/kern.log*'
    14 hosts will be targeted:
    integration-slave-docker-[1021,1034,1037,1040-1041,1043,1045-1046,1048-1053].integration.eqiad.wmflabs
    ...
    • Mar 13 2019, 8:24 PM
    • 282 Lines
  • root@deployment-elastic05:/etc/elasticsearch/beta-search# puppet agent -tv
    Warning: Unable to fetch my node definition, but the agent run will continue:
    Warning: SSL_connect returned=1 errno=0 state=error: certificate verify failed: [self signed certificate in certificate chain for /CN=Puppet CA: puppet]
    Info: Retrieving pluginfacts
    Error: /File[/var/lib/puppet/facts.d]: Failed to generate additional resources using 'eval_generate': SSL_connect returned=1 errno=0 state=error: certificate verify failed: [self signed certificate in certificate chain for /CN=Puppet CA: puppet]
    ...
    • Mar 13 2019, 6:14 PM
    • 15 Lines
  • select CAST( SUBSTR(dt, 0, 4) AS int ) as year, SUM(value)
    from wmf.mediawiki_metrics
    where wiki_db = 'wikidatawiki'
    and metric = 'daily_edits'
    and snapshot = '2021-08'
    ...
    • Mar 13 2019, 4:59 PM
    • 8 Lines
  • Traceback (most recent call last):
    File "/usr/lib/python3/dist-packages/cumin/grammar.py", line 132, in _import_backend
    keyword = backend.GRAMMAR_PREFIX
    AttributeError: module 'cumin.backends.openstack' has no attribute 'GRAMMAR_PREFIX'
    ...
    • Mar 13 2019, 8:35 AM
    • 33 Lines
  • ema@tools-bastion-03:~$ sudo -i become wikibugs
    Please set git user and e-mail *in your own $HOME* before running git
    in this project. In addition, make sure this tool user can read your
    /data/project/wikibugs/.gitconfig.
    ...
    • Mar 13 2019, 7:02 AM
    • 13 Lines
  • apache
    ```
    ab -n 1000 -c 10 http://kafes.local/index.php/Special:Blankpage
    This is ApacheBench, Version 2.3 <$Revision: 1843412 $>
    ...
    • Mar 13 2019, 1:14 AM
    • 118 Lines
  • $ mwscript maintenance/namespaceDupes.php --wiki=angwiki
    id=15903 ns=0 dbk=Wicipǣdia:Fulgōdra_gewrita_teohhunga *** dest title exists and --add-prefix not specified
    id=16230 ns=0 dbk=Wicipǣdia:Gemǣnscipe_Ingang *** dest title exists and --add-prefix not specified
    id=11984 ns=0 dbk=Ƿicipǣdia:Bēne_tō_Bewitendhāda *** dest title exists and --add-prefix not specified
    id=15917 ns=0 dbk=Ƿicipǣdia:Sceortpæþ *** dest title exists and --add-prefix not specified
    ...
    • Mar 12 2019, 9:51 PM
    • 29 Lines
    • Shell
  • CREATE TABLE `ebernhardson.glent_m0run` (
    `query` string,
    `dym` int,
    `suggCount` string,
    `q2q2LevenDist` double,
    ...
    • Mar 12 2019, 9:30 PM
    • 17 Lines
  • ---TRANSACTION 233947338, ACTIVE 22550 sec
    MySQL thread id 3674410, OS thread handle 0x7f1d6aed5b00, query id 1622520235 10.64.36.112 superset
    Trx read view will not see trx with id >= 233947339, sees < 233944925
    Trx #rec lock waits 0 #table lock waits 0
    Trx total rec lock wait time 0 SEC
    ...
    • Mar 12 2019, 2:41 PM
    • 48 Lines
  • So far I have only seen usage issues when trying dumps:
    - I would like to get an usage when I run backup_mariadb.py without options
    ...
    • Mar 12 2019, 11:28 AM
    • 88 Lines
  • root@es2001:/tmp# sudo -u dump /home/marostegui/puppet/modules/profile/files/mariadb/backup_mariadb.py --config-file /home/marostegui/backups.cnf
    root@es2001:/tmp#
    • Mar 12 2019, 8:16 AM
    • 2 Lines
  • openapi: 3.0.1
    info:
    title: Content translation service
    description: Content translation service for translating mediawiki pages between
    languages.
    ...
    • Mar 12 2019, 7:19 AM
    • 544 Lines
    • YAML
  • MediaWiki:Lang/aa
    MediaWiki:Lang/ab
    MediaWiki:Lang/ace
    MediaWiki:Lang/ae
    MediaWiki:Lang/af
    ...
    • Mar 11 2019, 7:58 PM
    • 368 Lines
  • --- a/cookbooks/sre/hosts/ipmi-password-reset.py
    +++ b/cookbooks/sre/hosts/ipmi-password-reset.py
    @@ -37,11 +37,14 @@ def argument_parser():
    def run(args, spicerack):
    ...
    • Mar 11 2019, 5:17 PM
    • 12 Lines
  • --- a/cookbooks/sre/hosts/ipmi-password-reset.py
    +++ b/cookbooks/sre/hosts/ipmi-password-reset.py
    @@ -41,7 +41,6 @@ def run(args, spicerack):
    ipmi = spicerack.ipmi()
    mgmt = spicerack.management()
    ...
    • Mar 11 2019, 5:10 PM
    • 20 Lines
  • import os
    import shutil
    import uuid
    from acme_chief.acme_chief import CERTIFICATE_TYPES, KEY_TYPES, ACMEChief
    ...
    • Mar 11 2019, 3:32 PM
    • 50 Lines
    • Python
  • bash-4.4# ./loadData.sh -n wdq -d /home/sparql/mungeOut
    Processing wikidump-000000001.ttl.gz
    SPARQL-UPDATE: updateStr=LOAD <file:///home/sparql/mungeOut/wikidump-000000001.ttl.gz>
    java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: org.openrdf.query.UpdateExecutionException: java.lang.RuntimeException: Could not load: url=file:///home/sparql/mungeOut/wikidump-000000001.ttl.gz, cause=java.io.EOFException: Unexpected end of ZLIB input stream
    at java.util.concurrent.FutureTask.report(FutureTask.java:122)
    ...
    • Mar 11 2019, 1:35 PM
    • 65 Lines
  • cdanis@bast1002.wikimedia.org ~ % for HOST in maps200{1,2,3,4}.codfw.wmnet maps100{1,2,3,4}.eqiad.wmnet ; do echo $HOST; curl -v --resolve maps.wikimedia.org:443:$(dig +short $HOST) 'https://maps.wikimedia.org/geoshape?getgeojson=1&ids=Q3145754' |& egrep 'HTTP/2 [2345]|x-powered' ; echo ; done
    maps2001.codfw.wmnet
    < HTTP/2 200
    < x-powered-by: kartotherian: 0.0.38 (c49f37c39515675d95d3dd7da09ca535ec0d448b)
    ...
    • Mar 8 2019, 3:59 PM
    • 33 Lines
  • varnishtest "Normalize Thumbnail URL"
    # In prod prefix is /wikipedia/commons/thumb
    server s1 {
    ...
    • Mar 8 2019, 3:57 PM
    • 97 Lines
  • 16:09:48 stopping test server
    16:09:48 1) "after all" hook
    16:09:48
    16:09:48 137 passing (3s)
    16:09:48 1 failing
    ...
    • Mar 8 2019, 10:47 AM
    • 13 Lines
  • [pid 543] 00:52:01 epoll_wait(4, [{EPOLLRDNORM, {u32=14, u64=14}}], 100, 29976) = 1
    [pid 543] 00:52:04 accept4(14, NULL, NULL, SOCK_NONBLOCK) = 16
    [pid 543] 00:52:04 epoll_ctl(4, EPOLL_CTL_ADD, 16, {EPOLLRDNORM, {u32=16, u64=16}}) = 0
    [pid 543] 00:52:04 epoll_wait(4, [{EPOLLRDNORM, {u32=16, u64=16}}], 100, 29964) = 1
    [pid 543] 00:52:04 epoll_ctl(4, EPOLL_CTL_DEL, 16, NULL) = 0
    ...
    • Mar 8 2019, 12:54 AM
    • 197 Lines
  • ----------Cell 1----------------------------------------------------------------------
    val df = spark.read.parquet("/user/joal/wmf/data/wmf/mediawiki/wikidata_parquet/20190204")
    val base_rdd = df.select("labels", "descriptions", "aliases").rdd
    ...
    • Mar 7 2019, 10:03 AM
    • 43 Lines
  • Pushed https://gerrit.wikimedia.org/r/#/c/test/gerrit-ping/+/482886/
    b997259..c7cedd0 master -> master
    That caused Gerrit 2.15 to emit the following events:
    ...
    • Mar 6 2019, 7:19 PM
    • 19 Lines
  • Running conftool-sync on /etc/conftool/data
    2019-03-06 14:13:00 [INFO] conftool::yaml_log_error: Error parsing yaml file /etc/conftool/etcdrc: [Errno 2] No such file or directory: '/etc/conftool/etcdrc'
    2019-03-06 14:13:00 [INFO] conftool::load_files: Loading data for entity node from /etc/conftool/data
    2019-03-06 14:13:00 [INFO] conftool::load_files: Parsing file /etc/conftool/data/node/eqsin.yaml
    2019-03-06 14:13:00 [INFO] conftool::load_files: Parsing file /etc/conftool/data/node/codfw.yaml
    ...
    • Mar 6 2019, 2:13 PM
    • 45 Lines
  • /**
    * CSS in this file is used by *all* skins (that have any CSS at all). Be
    * careful what you put in here, since what looks good in one skin may not in
    * another, but don't ignore the poor pre-Monobook users either.
    *
    ...
    • Mar 6 2019, 12:00 AM
    • 746 Lines
    • CSS
  • mysql:research@dbstore1004.eqiad.wmnet [loginwiki]> select cul_user_text, count(*) from cu_log where cul_timestamp like '201902%' group by 1 order by 1 limit 100;
    +-----------------+----------+
    | cul_user_text | count(*) |
    +-----------------+----------+
    | -revi | 23 |
    ...
    • Mar 5 2019, 10:15 PM
    • 38 Lines
  • ❯ docker-pkg --debug -c dockerfiles/config.yaml dockerfiles/java8-sonar-scanner/
    2019-03-05 13:32:05,566 [docker-pkg-build] DEBUG - Trying paths: ['/Users/kharlan/.docker/config.json', '/Users/kharlan/.dockercfg'] (auth.py:234)
    2019-03-05 13:32:05,575 [docker-pkg-build] DEBUG - Found file at path: /Users/kharlan/.docker/config.json (auth.py:238)
    2019-03-05 13:32:05,576 [docker-pkg-build] DEBUG - Couldn't find 'auths' or 'HttpHeaders' sections (auth.py:296)
    2019-03-05 13:32:05,576 [docker-pkg-build] DEBUG - Config entry for key stackOrchestrator is not auth config (auth.py:180)
    ...
    • Mar 5 2019, 6:32 PM
    • 40 Lines
  • kartik@deploy1001:/srv/mediawiki-staging$ git push origin HEAD:refs/for/master/revert-07818435a60d55b512f981ccbb5638d38746e94d
    Username for 'https://gerrit.wikimedia.org': kartik
    Password for 'https://kartik@gerrit.wikimedia.org':
    Counting objects: 4, done.
    Delta compression using up to 32 threads.
    ...
    • Mar 5 2019, 12:29 PM
    • 20 Lines
  • from (
    select
    year,
    month,
    day,
    ...
    • Mar 5 2019, 10:59 AM
    • 19 Lines
  • SELECT
    dt, sequence, cache_status, response_size, x_cache
    FROM wmf.webrequest
    WHERE uri_host = 'www.wikidata.org'
    AND year = 2019
    ...
    • Mar 5 2019, 10:57 AM
    • 8 Lines
  • dt sequence cache_status response_size x_cache
    X 2019-02-13T09:13:43 3421889674 miss 753664 cp1087 pass, cp3041 miss, cp3040 miss
    10 2019-02-13T09:15:36 3422739696 hit-local 594787 cp1087 pass, cp3041 hit/1, cp3040 miss
    2 2019-02-13T09:17:54 3423779520 hit-local 551123 cp1087 pass, cp3041 hit/2, cp3040 miss
    ...
    • Mar 5 2019, 10:35 AM
    • 19 Lines
  • Mar 05 07:01:26 labsdb1011 mysqld[1857]: 2019-03-05 7:01:26 140250766415616 [Note] Master 's3': Slave SQL thread exiting, replication stopped in log 'db1124-bin.000946' at position 170348950
    Mar 05 07:01:26 labsdb1011 mysqld[1857]: 2019-03-05 7:01:26 140250766620416 [Note] Master 's3': Slave I/O thread exiting, read up to log 'db1124-bin.000946', position 335133336
    Mar 05 07:01:26 labsdb1011 mysqld[1857]: 2019-03-05 7:01:26 140250766006016 [Note] Master 's4': Slave SQL thread exiting, replication stopped in log 'db1125-bin.002083' at position 968173492
    Mar 05 07:01:26 labsdb1011 mysqld[1857]: 2019-03-05 7:01:26 140250766210816 [Note] Master 's4': Slave I/O thread exiting, read up to log 'db1125-bin.002083', position 1002235439
    Mar 05 07:01:26 labsdb1011 mysqld[1857]: 2019-03-05 7:01:26 140250765596416 [Note] Master 's5': Slave SQL thread exiting, replication stopped in log 'db1124-bin.000615' at position 502782848
    ...
    • Mar 5 2019, 8:14 AM
    • 16 Lines
  • mysql> SELECT argos_revision.*, HEX(rev_sha1) FROM argos_page JOIN argos_revision ON (rev_id = page_latest) WHERE page_namespace=6 AND page_title='ModelServer_documentation.pdf';
    +--------+----------+-------------+---------------------------------------------------------------------+----------+---------------+----------------+----------------+-------------+---------+---------------+---------------------------------+--------------------+-------------------+----------------------------------------------------------------+
    | rev_id | rev_page | rev_text_id | rev_comment | rev_user | rev_user_text | rev_timestamp | rev_minor_edit | rev_deleted | rev_len | rev_parent_id | rev_sha1 | rev_content_format | rev_content_model | HEX(rev_sha1) |
    +--------+----------+-------------+---------------------------------------------------------------------+----------+---------------+----------------+----------------+-------------+---------+---------------+---------------------------------+--------------------+-------------------+----------------------------------------------------------------+
    ...
    • Mar 4 2019, 5:41 PM
    • 17 Lines
  • SELECT term_full_entity_id, term_type, term_language, term_text
    FROM wb_terms
    WHERE term_entity_type = 'item'
    AND term_type = 'label'
    AND ( term_full_entity_id = 'Q64' OR term_full_entity_id = 'Q1234' OR term_full_entity_id = 'Q999' OR term_full_entity_id = 'Q1000000' )
    ...
    • Mar 4 2019, 5:04 PM
    • 20 Lines
  • SELECT term_full_entity_id FROM wb_terms
    WHERE term_text = 'Berlin'
    AND term_entity_type = 'item'
    AND (term_type = 'label' OR term_type = 'alias')
    AND term_language = 'en';
    ...
    • Mar 4 2019, 5:03 PM
    • 19 Lines
  • SELECT wb_page_to_entity.entity_id as entityId, wb_entity_term_type.type as type, wb_term_search_langs.language as language, wb_term_search_strings.term_text as text
    FROM wb_page_to_entity
    INNER JOIN page ON wb_page_to_entity.page_id = page.page_id
    INNER JOIN wb_entity_terms_2 ON wb_page_to_entity.page_id = wb_entity_terms_2.page_id
    ...
    • Mar 4 2019, 4:38 PM
    • 15 Lines
  • SELECT term_full_entity_id, term_type, term_language, term_text
    FROM wb_terms
    WHERE term_entity_type = 'item'
    AND term_type = 'label'
    AND term_full_entity_id IN ('Q18609040', 'Q21099935', 'Q140', 'Q34687', 'Q22914698', 'Q22914704', 'Q22914703', 'Q21502838', 'Q2382443', 'Q5', 'Q19474404', 'Q21502410', 'Q3613', 'Q15483', 'Q15490', 'Q20808', 'Q21130', 'Q27736', 'Q28101', 'Q28915', 'Q38822', 'Q44789', 'Q46109', 'Q59798', 'Q59888', 'Q60319', 'Q60320', 'Q82685', 'Q83175', 'Q88736', 'Q114264', 'Q114906', 'Q115850', 'Q115924', 'Q116209', 'Q116312', 'Q117944', 'Q118979', 'Q123279', 'Q130918', 'Q131224', 'Q131492', 'Q131726', 'Q131986', 'Q132102', 'Q132231', 'Q132229', 'Q132593', 'Q132647', 'Q132650', 'Q132712', 'Q132967', 'Q133101', 'Q133289', 'Q133340', 'Q133422', 'Q133726', 'Q133759', 'Q133781', 'Q133789', 'Q133831', 'Q133840', 'Q133932', 'Q133985', 'Q139316', 'Q134036', 'Q134170', 'Q134249', 'Q134459', 'Q134723', 'Q135362', 'Q135584', 'Q135769', 'Q135848', 'Q135990', 'Q136216', 'Q136774', 'Q136941', 'Q136985', 'Q137039', 'Q137054', 'Q137309', 'Q137318', 'Q137465', 'Q137605', 'Q138435', 'Q138470', 'Q138488', 'Q138647', 'Q139521', 'Q140563', 'Q140812', 'Q140970', 'Q141042', 'Q141245', 'Q141307', 'Q141397', 'Q141575', 'Q141684', 'Q142326', 'Q142492', 'Q142507', 'Q142916', 'Q143072', 'Q143142', 'Q143254', 'Q143760', 'Q144014', 'Q144428', 'Q145429', 'Q144576', 'Q145872', 'Q145936', 'Q146095', 'Q146983', 'Q147035', 'Q147044', 'Q147348', 'Q148304', 'Q148336', 'Q148652', 'Q148938', 'Q149031', 'Q149459', 'Q149508', 'Q149774', 'Q149886', 'Q149909', 'Q149927', 'Q149949', 'Q150436', 'Q150604', 'Q150667', 'Q156533', 'Q156692', 'Q156694', 'Q156901', 'Q157389', 'Q157503', 'Q157505', 'Q157665', 'Q157786', 'Q158009', 'Q158032', 'Q158086', 'Q158217', 'Q158341', 'Q158391', 'Q158826', 'Q159372', 'Q160046', 'Q161308', 'Q161577', 'Q162097', 'Q162143', 'Q162865', 'Q162902', 'Q163137', 'Q164167', 'Q165260', 'Q161675', 'Q163915', 'Q203648', 'Q206998', 'Q210320', 'Q212032', 'Q216113', 'Q218482', 'Q220150', 'Q223302', 'Q238258', 'Q247641', 'Q247836', 'Q248838', 'Q252831', 'Q253870', 'Q256304', 'Q265684', 'Q267766', 'Q268597', 'Q275737', 'Q286142', 'Q286775', 'Q288279', 'Q288311', 'Q288827', 'Q290354', 'Q290676', 'Q290763', 'Q291548', 'Q291636', 'Q291743', 'Q291778', 'Q292074', 'Q292341', 'Q292351', 'Q295372', 'Q296910', 'Q309499', 'Q309858', 'Q310074', 'Q310368', 'Q310438', 'Q310591', 'Q310745', 'Q310882', 'Q310927', 'Q310977', 'Q311086', 'Q311148', 'Q311373', 'Q311463', 'Q311714', 'Q311790', 'Q312194', 'Q312349', 'Q336963', 'Q343251', 'Q354257', 'Q368955', 'Q378135', 'Q389935', 'Q429405', 'Q469636', 'Q472943', 'Q490401', 'Q508616', 'Q510296', 'Q514417', 'Q514515', 'Q515830', 'Q520014', 'Q526640', 'Q529584', 'Q529976', 'Q532358', 'Q536675', 'Q542456', 'Q537894', 'Q541917', 'Q542488', 'Q545108', 'Q547143', 'Q548227', 'Q559018', 'Q573055', 'Q577619', 'Q578571', 'Q579187', 'Q581971', 'Q583378', 'Q585776', 'Q589790', 'Q591966', 'Q594051', 'Q596457', 'Q602788', 'Q607399', 'Q607912', 'Q608275', 'Q609717', 'Q630333', 'Q637716', 'Q642055', 'Q646860', 'Q647507', 'Q650106', 'Q650703', 'Q656319', 'Q659774', 'Q660147', 'Q662202', 'Q669771', 'Q683090', 'Q688916', 'Q716132', 'Q720501', 'Q724176', 'Q726614', 'Q729037', 'Q732394', 'Q736378', 'Q747421', 'Q748899', 'Q749412', 'Q753490', 'Q756181', 'Q764799', 'Q765547', 'Q765930', 'Q773896', 'Q775899', 'Q776109', 'Q777327', 'Q780406', 'Q786018', 'Q809586', 'Q811624', 'Q831376', 'Q840423', 'Q841027', 'Q842030', 'Q842663', 'Q843914', 'Q847194', 'Q850491', 'Q858772', 'Q860112', 'Q867395', 'Q873584', 'Q877147', 'Q892657', 'Q910110', 'Q914039', 'Q922335', 'Q928224', 'Q931930', 'Q937405', 'Q938266', 'Q938830', 'Q939613', 'Q940523', 'Q941485', 'Q945272', 'Q952089', 'Q955407', 'Q955567', 'Q957567', 'Q959222', 'Q960200', 'Q971690', 'Q972822', 'Q973187', 'Q973314', 'Q975998', 'Q977223', 'Q986182', 'Q1001350', 'Q1017217', 'Q1024187', 'Q1027410', 'Q1039125', 'Q1039531', 'Q1056752', 'Q1058732', 'Q1060039', 'Q1061117', 'Q1065926', 'Q1075697', 'Q1080907', 'Q1082208', 'Q1092517', 'Q1093641', 'Q1117674', 'Q1135685', 'Q1143109', 'Q1163100', 'Q1171483', 'Q1172479', 'Q1205104', 'Q1226326', 'Q1227267', 'Q1241332', 'Q1227674', 'Q1301202', 'Q1301809', 'Q1303731', 'Q1303760', 'Q1304192', 'Q1304844', 'Q1306244', 'Q1308636', 'Q1308482', 'Q1309997', 'Q1311833', 'Q1314162', 'Q1316092', 'Q1316915', 'Q1318931', 'Q1319276', 'Q1319337', 'Q1319524', 'Q1323497', 'Q1323513', 'Q1328868', 'Q1328886', 'Q1335129', 'Q1336872', 'Q1338922', 'Q1339065', 'Q1343178', 'Q1361452', 'Q1361642', 'Q1362672', 'Q1367265', 'Q1368348', 'Q1384525', 'Q1383511', 'Q1404299', 'Q1449392', 'Q1452895', 'Q1460935', 'Q1461699', 'Q1482244', 'Q1497039', 'Q1506945', 'Q1532434', 'Q1548736', 'Q1556014', 'Q1572326', 'Q1587099', 'Q1596059', 'Q1601345', 'Q1607561', 'Q1610174', 'Q1611574', 'Q1611947', 'Q1629444', 'Q1655422', 'Q1659441', 'Q1708308', 'Q1766426', 'Q1739062', 'Q1740751', 'Q1756153', 'Q1756728', 'Q1757681', 'Q1757714', 'Q1757756', 'Q1758258', 'Q1758637', 'Q1761019', 'Q1761605', 'Q1762051', 'Q1763493', 'Q1764182', 'Q1765838', 'Q1767132', 'Q1767570', 'Q1768585', 'Q1755146', 'Q1817604', 'Q1820184', 'Q1826576', 'Q1828247', 'Q1856753', 'Q1866158', 'Q1876697', 'Q1885044', 'Q1886599', 'Q1896675', 'Q1911170', 'Q1914222', 'Q1920672', 'Q1932304', 'Q1932400', 'Q1934172', 'Q1934283', 'Q1935943', 'Q1936196', 'Q1936276', 'Q1936309', 'Q1938012', 'Q1938278', 'Q1940601', 'Q1941136', 'Q1946085', 'Q1946598', 'Q1949178', 'Q1949541', 'Q1951530', 'Q1952376', 'Q1952379', 'Q1954952', 'Q1958756', 'Q1960850', 'Q1964247', 'Q1964338', 'Q1989603', 'Q2003393', 'Q2012645', 'Q2014752', 'Q2015133', 'Q2016157', 'Q2019809', 'Q2019812', 'Q2031123', 'Q2031606', 'Q2031925', 'Q2036404', 'Q2039140', 'Q2041055', 'Q2053716', 'Q2062535', 'Q2063031', 'Q2065116', 'Q2067686', 'Q2068837', 'Q2072302', 'Q2084764', 'Q2086405', 'Q2087279', 'Q2089264', 'Q2096035', 'Q2112222', 'Q2147082', 'Q2158843', 'Q2171188', 'Q2183754', 'Q2184397', 'Q2186198', 'Q2217975', 'Q2234141', 'Q2234462', 'Q2234786', 'Q2234832', 'Q2235255', 'Q2236142', 'Q2248627', 'Q2253277', 'Q2253527', 'Q2260275', 'Q2267687', 'Q2286111', 'Q2290216', 'Q2296480', 'Q2299558', 'Q2302897', 'Q2317783', 'Q2333853', 'Q2338910', 'Q2339987', 'Q2341570', 'Q2352961', 'Q2356320', 'Q2358106', 'Q2364622', 'Q2367487', 'Q2367663', 'Q2371001', 'Q2377398', 'Q2378417', 'Q2383656', 'Q2391385', 'Q2393841', 'Q2398374', 'Q2413478', 'Q2413669', 'Q2414970', 'Q2417381', 'Q2426272', 'Q2433471', 'Q2436802', 'Q2441005', 'Q2452808', 'Q2456301', 'Q2465131', 'Q2473735', 'Q2479682', 'Q2482833', 'Q2487233', 'Q2495248', 'Q2505064', 'Q2506863', 'Q2510483', 'Q2524440', 'Q2532431', 'Q2533831', 'Q2547920', 'Q2566619', 'Q2568982', 'Q2569205', 'Q2570239', 'Q2576670', 'Q2579542', 'Q2580374', 'Q2585316', 'Q2593152', 'Q2597964', 'Q2608565', 'Q2612158', 'Q2615285', 'Q2619215', 'Q2623321', 'Q2627457', 'Q2628493', 'Q2648955', 'Q2655455', 'Q2656953', 'Q2662997', 'Q2666273', 'Q2670134', 'Q2671368', 'Q2673646', 'Q2673653', 'Q2688882', 'Q2697211', 'Q2697922', 'Q2697235', 'Q2697396', 'Q2698575', 'Q2698783', 'Q2700686', 'Q2702870', 'Q2703245', 'Q2704426', 'Q2705131', 'Q2706479', 'Q2706640', 'Q2706745', 'Q2708290', 'Q2708315', 'Q2708411', 'Q2708462', 'Q2708701', 'Q2709263', 'Q2709465', 'Q2709663', 'Q2709676', 'Q2709804', 'Q2710470', 'Q2710965', 'Q2710975', 'Q2711260', 'Q2711319', 'Q2711739', 'Q2713145', 'Q2714202', 'Q2715464', 'Q2716146', 'Q2717836', 'Q2720003', 'Q2731014', 'Q2732846', 'Q2742139', 'Q2791293', 'Q2803063', 'Q2810933', 'Q2813943', 'Q2822947', 'Q2830631', 'Q2830659', 'Q2832077', 'Q2834855', 'Q2837705', 'Q2839724', 'Q2842851', 'Q2851430', 'Q2861228', 'Q2868401', 'Q2872596', 'Q2875136', 'Q2880447', 'Q2883028', 'Q2886902', 'Q2889177', 'Q2890026', 'Q2894193', 'Q2899106', 'Q2900744', 'Q2917807', 'Q2918700', 'Q2918890', 'Q2918873', 'Q2934237', 'Q2943924', 'Q2964420', 'Q2398348', 'Q2993514', 'Q2996592', 'Q2998753', 'Q3007739', 'Q3007828', 'Q3007993', 'Q3009515', 'Q3012775', 'Q3013613', 'Q3013288', 'Q3013768', 'Q3017028', 'Q3018540', 'Q3022328', 'Q3024494', 'Q3046817', 'Q3054377', 'Q3055695', 'Q3061809', 'Q3072816', 'Q3075678', 'Q3082293', 'Q3090671', 'Q3115760', 'Q3137293', 'Q3139083', 'Q3139737', 'Q3141828', 'Q3153643', 'Q3162785', 'Q3169613', 'Q3171274', 'Q3172773', 'Q3175608', 'Q3182415', 'Q3185543', 'Q3195486', 'Q3198953', 'Q3201833', 'Q3232424', 'Q3232897', 'Q3240999', 'Q3241818', 'Q3263703', 'Q3236804', 'Q3280428', 'Q3286539', 'Q3291991', 'Q3294028', 'Q3309492', 'Q3310244', 'Q3310354', 'Q3310599', 'Q3310749', 'Q3311055', 'Q3314230', 'Q3314243', 'Q3315778', 'Q3320241', 'Q3322781', 'Q3335408', 'Q3359354', 'Q3360755', 'Q3369339', 'Q3368007', 'Q3385410', 'Q3392032', 'Q3395540', 'Q3395635', 'Q3406453', 'Q3409973', 'Q3431772', 'Q3437894', 'Q3442095', 'Q3456208', 'Q3456452', 'Q3437200', 'Q3472523', 'Q3489113', 'Q3495779', 'Q3495891', 'Q3502306', 'Q3503422', 'Q3523518', 'Q3545503', 'Q3545695', 'Q3575728', 'Q3595950', 'Q3603920', 'Q3638913', 'Q3692647', 'Q3694977', 'Q3698486', 'Q3698683', 'Q3699819', 'Q3701740', 'Q3703964', 'Q3705489', 'Q3705571', 'Q3706132', 'Q3715785', 'Q3716278', 'Q3719975', 'Q3731685', 'Q3734125', 'Q3740972', 'Q3753479', 'Q3755532', 'Q3759393', 'Q3759620', 'Q3760359', 'Q3764156', 'Q3267992', 'Q3726463', 'Q3775758', 'Q3785152', 'Q3786728', 'Q3802353', 'Q3804892', 'Q3821981', 'Q3840985', 'Q3841040', 'Q3856985', 'Q3862782', 'Q3893680', 'Q3896039', 'Q3906176', 'Q3916931', 'Q3895189', 'Q3906225', 'Q3906251', 'Q3932182', 'Q3934682', 'Q3953427', 'Q3966621', 'Q3966622', 'Q3978390', 'Q3999088', 'Q4000424', 'Q4001082', 'Q4005738', 'Q4008718', 'Q4009419', 'Q4010080', 'Q4021752', 'Q4024164', 'Q4035717', 'Q4037290', 'Q4037311', 'Q4039580', 'Q4040817', 'Q4042791', 'Q4043459', 'Q4044027', 'Q4046490', 'Q4047603', 'Q4049129', 'Q4050178', 'Q4051684', 'Q4066520', 'Q4068983', 'Q4115399', 'Q4115637', 'Q4118972', 'Q4119036', 'Q4119088', 'Q4119182', 'Q4119274', 'Q4119328', 'Q4119549', 'Q4119983', 'Q4120302', 'Q4121093', 'Q4140826', 'Q4172516', 'Q4172524', 'Q4179839', 'Q4181786', 'Q4182058', 'Q4184339', 'Q4194453', 'Q4219141', 'Q4246983', 'Q4286257', 'Q4290323', 'Q4291877', 'Q4292542', 'Q4300417', 'Q4304477', 'Q4306468', 'Q4308480', 'Q4308504', 'Q4347716', 'Q4352304', 'Q4352642', 'Q4355400', 'Q4371546', 'Q4386113', 'Q4409914', 'Q4414480', 'Q4418458', 'Q4476425', 'Q4485926', 'Q4488696', 'Q4492001', 'Q4528410', 'Q4546969', 'Q4547324', 'Q4568539', 'Q4658728', 'Q4673501', 'Q4674609', 'Q4676397', 'Q4676980', 'Q4681933', 'Q4682081', 'Q4692851', 'Q4726703', 'Q4726221', 'Q4734355', 'Q4739493', 'Q4742417', 'Q4747668', 'Q4765454', 'Q4769853', 'Q4774634', 'Q4774903', 'Q4780161', 'Q4780587', 'Q4789202', 'Q4792042', 'Q4806098', 'Q4810740', 'Q4810745', 'Q4811178', 'Q4815749', 'Q4817492', 'Q4844347', 'Q4845211', 'Q4865430', 'Q4878791', 'Q4883994', 'Q4913764', 'Q4918455', 'Q4919867', 'Q4926345', 'Q4938963', 'Q4939996', 'Q4947231', 'Q4982415', 'Q4982603', 'Q4991585', 'Q4996990', 'Q5002691', 'Q5017039', 'Q5017506', 'Q5018540', 'Q5024481', 'Q5024697', 'Q5026880', 'Q5028572', 'Q5031648', 'Q5032175', 'Q5032268', 'Q5047079', 'Q5045746', 'Q5047738', 'Q5053564', 'Q5055080', 'Q5063331', 'Q5063777', 'Q5063823', 'Q5064220', 'Q5065497', 'Q5066732', 'Q5101280', 'Q5101422', 'Q5102904', 'Q5103212', 'Q5109183', 'Q5119958', 'Q5124937', 'Q5125929', 'Q5136812', 'Q5137103', 'Q5137139', 'Q5140323', 'Q5149019', 'Q5149255', 'Q5162147', 'Q5162652', 'Q5173748', 'Q5159189', 'Q5184096', 'Q5185776', 'Q5158719', 'Q5164814', 'Q5182461', 'Q5187280', 'Q5190560', 'Q5190759', 'Q5190953', 'Q5190966', 'Q5190987', 'Q5194800', 'Q5195876', 'Q5198943', 'Q5215777', 'Q5219416', 'Q5220183', 'Q5220575', 'Q5220957', 'Q5221043', 'Q5221598', 'Q5222240', 'Q5222331', 'Q5222932', 'Q5224598', 'Q5224926', 'Q5226000', 'Q5227610', 'Q5228004', 'Q5228980', 'Q5232022', 'Q5232320', 'Q5234471', 'Q5235855', 'Q5235884', 'Q5236092', 'Q5239918', 'Q5257104', 'Q5264629', 'Q5266972', 'Q5272271', 'Q5272406', 'Q5281454', 'Q5281672', 'Q5283372', 'Q5283625', 'Q5289068', 'Q5294311', 'Q5294329', 'Q5304627', 'Q5311274', 'Q5315968', 'Q5318402', 'Q5359158', 'Q5372508', 'Q5376558', 'Q5376577', 'Q5381459', 'Q5382158', 'Q5385040', 'Q5390592', 'Q5398416', 'Q5403677', 'Q5405867', 'Q5409802', 'Q5405988', 'Q5409999', 'Q5447162', 'Q5444497', 'Q5455302', 'Q5455439', 'Q5462303', 'Q5479329', 'Q5517202', 'Q5518303', 'Q5518423', 'Q5527608', 'Q5531569', 'Q5535531', 'Q5548703', 'Q5555801', 'Q5560184', 'Q5562421', 'Q5571097', 'Q5572188', 'Q5573515', 'Q5577582', 'Q5592163', 'Q5593430', 'Q5605054', 'Q5615137', 'Q5621943', 'Q5643365', 'Q5646974', 'Q5652015', 'Q5663218', 'Q5676344', 'Q5677738', 'Q5696096', 'Q5697241', 'Q5697562', 'Q5697676', 'Q5703880', 'Q5709655', 'Q5711459', 'Q5712528', 'Q5746891', 'Q5767723', 'Q5768321', 'Q5790169', 'Q5797241', 'Q5797313', 'Q5840670', 'Q5846494', 'Q5883765', 'Q5884802', 'Q5891296', 'Q5905868', 'Q5906582', 'Q5909177', 'Q5919763', 'Q5945494', 'Q5955306', 'Q5958153', 'Q5959520', 'Q5962422', 'Q5973328', 'Q5978229', 'Q5985046', 'Q6003906', 'Q6050428', 'Q6059062', 'Q6060923', 'Q6080777', 'Q6085034', 'Q6086392', 'Q6086436', 'Q6107750', 'Q6126853', 'Q6134055', 'Q6136775', 'Q6140260', 'Q6143659', 'Q6146910', 'Q6153868', 'Q6169282', 'Q6179988', 'Q6301970', 'Q6312757', 'Q6370165', 'Q6380766', 'Q6395474', 'Q6427378', 'Q6429010', 'Q6438926', 'Q6443507', 'Q6445327', 'Q6449094', 'Q6450255', 'Q6462386', 'Q6481328', 'Q6482541', 'Q6488174', 'Q6488923', 'Q6493327', 'Q6502666', 'Q6505143', 'Q6512474', 'Q6527975', 'Q6527992', 'Q6527998', 'Q6528222', 'Q6528306', 'Q6532546', 'Q6534246', 'Q6550172', 'Q6553241', 'Q6564427', 'Q6663800', 'Q6723368', 'Q6753152', 'Q6774264', 'Q6744244', 'Q6792179', 'Q6794466', 'Q6795513', 'Q6801770', 'Q6809287', 'Q6811426', 'Q6811493', 'Q6829557', 'Q6838980', 'Q6839016', 'Q6839367', 'Q6839963', 'Q6840352', 'Q6843857', 'Q6850345', 'Q6862034', 'Q6897844', 'Q6898938', 'Q6909326', 'Q6911948', 'Q6911949', 'Q6981096', 'Q7077923', 'Q7078480', 'Q7086521', 'Q7088251', 'Q7094395', 'Q7104902', 'Q7104940', 'Q7105018', 'Q7107696', 'Q7108746', 'Q7108850', 'Q7115977', 'Q7115993', 'Q7116113', 'Q7122160', 'Q7126401', 'Q7126873', 'Q7128388', 'Q7130497', 'Q7133992', 'Q7134644', 'Q7136012', 'Q7164994', 'Q7168518', 'Q7180310', 'Q7193825', 'Q7194308', 'Q7200488', 'Q7200522', 'Q7200941', 'Q7204752', 'Q7204819', 'Q7204859', 'Q7226453', 'Q7226585', 'Q7226996', 'Q7228327', 'Q7230301', 'Q7242327', 'Q7254004', 'Q7254827', 'Q7255666', 'Q7256796', 'Q7259790', 'Q7262021', 'Q7262922', 'Q7263371', 'Q7272903', 'Q7302305', 'Q7306191', 'Q7309899', 'Q7313268', 'Q7319692', 'Q7320000', 'Q7320768', 'Q7321207', 'Q7321420', 'Q7321424', 'Q7321691', 'Q7322017', 'Q7331101', 'Q7331103', 'Q7357471', 'Q7357621', 'Q7370476', 'Q7395966', 'Q7406122', 'Q7409051', 'Q7416130', 'Q7425776', 'Q7431176', 'Q7459264', 'Q7462749', 'Q7498237', 'Q7576531', 'Q7576634', 'Q7576582', 'Q7578186', 'Q7581940', 'Q7606660', 'Q7606895', 'Q7608482', 'Q7616493', 'Q7617621', 'Q7618558', 'Q7625319', 'Q7661406', 'Q7661952', 'Q7678934', 'Q7680688', 'Q7683222', 'Q7685210', 'Q7685940', 'Q7690221', 'Q7705646', 'Q7705678', 'Q7706272', 'Q7706644', 'Q7706667', 'Q7709546', 'Q7783456', 'Q7798771', 'Q7798616', 'Q7799651', 'Q7826244', 'Q7836175', 'Q7840782', 'Q7841063', 'Q7841361', 'Q7850807', 'Q7847926', 'Q7851405', 'Q7881381', 'Q7897850', 'Q7900289', 'Q7922599', 'Q7928682', 'Q7933846', 'Q7983072', 'Q2984595', 'Q7990394', 'Q7996050', 'Q8009371', 'Q8042595', 'Q8043571', 'Q8045499', 'Q8066186', 'Q8074590', 'Q8184783', 'Q8186572', 'Q8187698', 'Q8202430', 'Q8209051', 'Q8242593', 'Q8248824', 'Q8249697', 'Q8251477', 'Q8251496', 'Q8252278', 'Q8253738', 'Q8253278', 'Q8253279', 'Q8346928', 'Q8352318', 'Q8346914', 'Q8464689', 'Q8465247', 'Q8479821', 'Q8559840', 'Q8768491', 'Q8776990', 'Q8777337', 'Q8843741', 'Q8963781', 'Q8963789', 'Q8964714', 'Q9002367', 'Q9002396', 'Q9002798', 'Q9003378', 'Q9004824', 'Q9005036', 'Q9005364', 'Q9010142', 'Q9010795', 'Q9010802', 'Q9017751', 'Q9020914', 'Q9022481', 'Q9027501', 'Q9028376', 'Q9030852', 'Q9031794', 'Q9032445', 'Q9034810', 'Q9035252', 'Q9049701', 'Q9053384', 'Q9054116', 'Q9054846', 'Q9055681', 'Q9059180', 'Q9059215', 'Q9061322', 'Q9063776', 'Q9068622', 'Q9068692', 'Q9069137', 'Q9075167', 'Q9077437', 'Q9080014', 'Q9089835', 'Q9090198', 'Q9081721', 'Q9089650', 'Q9089768', 'Q9090078', 'Q9297219', 'Q9298059', 'Q9298620', 'Q9334269', 'Q9613453', 'Q9654519', 'Q9697512', 'Q10260548', 'Q10264780', 'Q10272012', 'Q10273546', 'Q10281136', 'Q10281141', 'Q10282775', 'Q10284356', 'Q10288358', 'Q10293926', 'Q10295209', 'Q10295328', 'Q10298968', 'Q10313945', 'Q10314407', 'Q10316234', 'Q10316826', 'Q10322879', 'Q10323002', 'Q10329612', 'Q10335470', 'Q10335808', 'Q10337410', 'Q10341267', 'Q10342694', 'Q10346420', 'Q10348377', 'Q10348543', 'Q10349191', 'Q10349887', 'Q10355348', 'Q10358532', 'Q10360433', 'Q10361339', 'Q10364027', 'Q10366688', 'Q10369482', 'Q10372428', 'Q10382280', 'Q10383989', 'Q10384798', 'Q10393551', 'Q10393653', 'Q10394046', 'Q10394326', 'Q10400375', 'Q10411490', 'Q10413723', 'Q10420904', 'Q10428811', 'Q10439800', 'Q10450291', 'Q10458733', 'Q10458950', 'Q10459924', 'Q10461681', 'Q10462009', 'Q10466286', 'Q10481115', 'Q10503756', 'Q10507869', 'Q10509048', 'Q10517377', 'Q10521176', 'Q10521895', 'Q10523231', 'Q10523774', 'Q10523804', 'Q10524991', 'Q10527870', 'Q10539549', 'Q10543799', 'Q10548669', 'Q10555463', 'Q10558377', 'Q10562501', 'Q10568141', 'Q10573546', 'Q10577987', 'Q10578463', 'Q10579693', 'Q10583427', 'Q10583945', 'Q10584302', 'Q10584305', 'Q10585292', 'Q10587583', 'Q10589117', 'Q10590566', 'Q10592109', 'Q10603721', 'Q10605965', 'Q10608771', 'Q10616544', 'Q10618443', 'Q10621659', 'Q10621802', 'Q10627166', 'Q10623728', 'Q10629827', 'Q10630291', 'Q10631820', 'Q10632934', 'Q10634678', 'Q10636868', 'Q10637193', 'Q10641458', 'Q10643832', 'Q10645546', 'Q10646700', 'Q10647059', 'Q10657238', 'Q10657654', 'Q10657905', 'Q10662444', 'Q10663139', 'Q10663241', 'Q10663518', 'Q10663673', 'Q10675024', 'Q10675083', 'Q10677846', 'Q10681601', 'Q10682573', 'Q10690561', 'Q10697444', 'Q10712177', 'Q10716655', 'Q10721946', 'Q10725452', 'Q10724077', 'Q10762095', 'Q10773103', 'Q10787205', 'Q10792303', 'Q10794587', 'Q10794248', 'Q10798536', 'Q10805562', 'Q10812327', 'Q10819953', 'Q10826825', 'Q11152871', 'Q11682095', 'Q11688817', 'Q11844549', 'Q11847616', 'Q12723971', 'Q12858588', 'Q13077189', 'Q13080875', 'Q13222440', 'Q13429575', 'Q13458222', 'Q13489005', 'Q13568724', 'Q13571068', 'Q13583103', 'Q13614984', 'Q13728554', 'Q13756402', 'Q13765499', 'Q13846219', 'Q13847289', 'Q13863677', 'Q13900127', 'Q14027417', 'Q14072134', 'Q14089833', 'Q14089912', 'Q14148226', 'Q14229093', 'Q14289494', 'Q14413043', 'Q14437383', 'Q14476900', 'Q14497567', 'Q14505543', 'Q14510016', 'Q14510792', 'Q14512311', 'Q14524047', 'Q14537748', 'Q14544093', 'Q14556518', 'Q14558955', 'Q14563153', 'Q14593427', 'Q14593928', 'Q14613121', 'Q14619716', 'Q14626007', 'Q14626464', 'Q14627310', 'Q14660135', 'Q14694213', 'Q14694936', 'Q14759694', 'Q14817227', 'Q14888567', 'Q14923676', 'Q14927235', 'Q14932298', 'Q14933570', 'Q14944408', 'Q14955045', 'Q15111312', 'Q15122277', 'Q15148054', 'Q15211446', 'Q15221071', 'Q15263826', 'Q15281513', 'Q15290282', 'Q15297638', 'Q15401614', 'Q15442785', 'Q15530684', 'Q10559410', 'Q15637212', 'Q15644700', 'Q15685838', 'Q15710788', 'Q15711508', 'Q15733479', 'Q15738396', 'Q15756262', 'Q15930525', 'Q15930699', 'Q15930784', 'Q15940376', 'Q15940645', 'Q15940966', 'Q15941332', 'Q15947099', 'Q15949781', 'Q15963889', 'Q15964042', 'Q15972195', 'Q15974985', 'Q16078996', 'Q16262821', 'Q16324555', 'Q16726069', 'Q16738158', 'Q16889114', 'Q16920987', 'Q16934603', 'Q16948627', 'Q16964187', 'Q16983012', 'Q16984738', 'Q16992917', 'Q17135679', 'Q17166772', 'Q17275656', 'Q17276677', 'Q17278777', 'Q17280721', 'Q17280725', 'Q17280796', 'Q17283222', 'Q17287175', 'Q17283198', 'Q17285612', 'Q17285862', 'Q17286364', 'Q17286905', 'Q17298469', 'Q17302116', 'Q17302985', 'Q17315724', 'Q17348489', 'Q17376180', 'Q17378178', 'Q17378199', 'Q17379701', 'Q17379707', 'Q17389389', 'Q17396674', 'Q17410335', 'Q17420135', 'Q17458540', 'Q17489262', 'Q17518808', 'Q17522626', 'Q17561501', 'Q18000478', 'Q18100136', 'Q18100231', 'Q18105679', 'Q18106744', 'Q18169036', 'Q18169086', 'Q18390588', 'Q18177268', 'Q18335750', 'Q18394916', 'Q18520202', 'Q18521004', 'Q18583914', 'Q18585855', 'Q18586254', 'Q18586697', 'Q18592118', 'Q18594596', 'Q18596708', 'Q18606052', 'Q18607120', 'Q19647130', 'Q20722233', 'Q20751435', 'Q21213712', 'Q21215104', 'Q21218574', 'Q21220293', 'Q21224955', 'Q21228116', 'Q21229528', 'Q21345006', 'Q21364230', 'Q21396981', 'Q21399992', 'Q21439169', 'Q21439954', 'Q21441246', 'Q21441461', 'Q21446045', 'Q21491951', 'Q21705099', 'Q21998059', 'Q22771018', 'Q23012617', 'Q23012671', 'Q23045816', 'Q23070885', 'Q23760931', 'Q23767328', 'Q23838784', 'Q23840487', 'Q23892239', 'Q24175353', 'Q25366022', 'Q25366265', 'Q25367879', 'Q25661540', 'Q25792213', 'Q25912935', 'Q29053614', 'Q30160684', 'Q502030', 'Q510129', 'Q937914', 'Q1832620', 'Q1934026', 'Q1938302', 'Q2000625', 'Q2030539', 'Q2096492', 'Q2118603', 'Q2198078', 'Q2206133', 'Q2309051', 'Q2373568', 'Q2436088', 'Q2457426', 'Q2470099', 'Q2491792', 'Q2512062', 'Q2513886', 'Q2599422', 'Q2664199', 'Q2705909', 'Q2791719', 'Q2955866', 'Q3720302', 'Q3721709', 'Q3721801', 'Q3753368', 'Q3767504', 'Q3925171', 'Q4247492', 'Q4652146', 'Q4636591', 'Q4648985', 'Q4634156', 'Q5527833', 'Q5652022', 'Q5657686', 'Q5775212', 'Q7607216', 'Q7787299', 'Q10314139', 'Q10487511', 'Q10515586', 'Q10600580', 'Q10631751', 'Q10663119', 'Q10703568', 'Q13433763', 'Q14515049', 'Q14602336', 'Q14492055', 'Q15408508', 'Q15451634', 'Q15461592', 'Q15683105', 'Q17201158', 'Q17132790', 'Q17581908', 'Q22364', 'Q25397', 'Q30359', 'Q39275', 'Q46076', 'Q60205', 'Q75073', 'Q80684', 'Q81039', 'Q83625', 'Q131567', 'Q133521', 'Q135262', 'Q174322', 'Q184067', 'Q199251', 'Q203649', 'Q221073', 'Q221381', 'Q244133', 'Q246808', 'Q252533', 'Q268608', 'Q276595', 'Q281124', 'Q284816', 'Q286026', 'Q287351', 'Q297215', 'Q310911', 'Q312154', 'Q339937', 'Q372731', 'Q384345', 'Q385877', 'Q468544', 'Q468603', 'Q481653', 'Q517079', 'Q518880', 'Q527744', 'Q556324', 'Q581284', 'Q599385', 'Q608576', 'Q609460', 'Q654494', 'Q682178', 'Q683647', 'Q693015', 'Q736473', 'Q748448', 'Q770093', 'Q772346', 'Q774536', 'Q787096', 'Q827257', 'Q916924', 'Q912096', 'Q912976', 'Q920945', 'Q929986', 'Q941160', 'Q943474', 'Q943215', 'Q949450', 'Q953559', 'Q961413', 'Q977517', 'Q1009621', 'Q1004346', 'Q1009624', 'Q1034100', 'Q1035905', 'Q1064620', 'Q1071167', 'Q1094704', 'Q1179958', 'Q1189557', 'Q1189609', 'Q1211267', 'Q1280997', 'Q1302332', 'Q1307373', 'Q1340206', 'Q1369893', 'Q1382545', 'Q1442513', 'Q1478025', 'Q1540893', 'Q1653127', 'Q1754819', 'Q1756087', 'Q1757703', 'Q1816886', 'Q1859722', 'Q1877389', 'Q1925920', 'Q1921685', 'Q1927027', 'Q1944939', 'Q1945822', 'Q1953659', 'Q1981007', 'Q2056201', 'Q2082228', 'Q2086371', 'Q2156839', 'Q2311936', 'Q2346039', 'Q2362306', 'Q2441214', 'Q2703837', 'Q2806221', 'Q2822475', 'Q2822503', 'Q2822504', 'Q2946366', 'Q3023308', 'Q3147412', 'Q3200507', 'Q3203049', 'Q3280744', 'Q3461459', 'Q3472461', 'Q3553235', 'Q3570206', 'Q4035949', 'Q3734585', 'Q3808855', 'Q3841274', 'Q4038127', 'Q4051743', 'Q4282961', 'Q4674502', 'Q4748324', 'Q4771312', 'Q4786861', 'Q4825663', 'Q5147824', 'Q5185996', 'Q5022908', 'Q5062985', 'Q5261336', 'Q5262681', 'Q5359419', 'Q5414381', 'Q5509505', 'Q5558926', 'Q5591896', 'Q5607349', 'Q6076603', 'Q6994195', 'Q7095030', 'Q7878653', 'Q8043893', 'Q8075955', 'Q8962085', 'Q8963374', 'Q10457964', 'Q10607969', 'Q10671994', 'Q10708565', 'Q10755090', 'Q11962240', 'Q12265405', 'Q13429509', 'Q14469651', 'Q14532695', 'Q14738505', 'Q14898092', 'Q15041215', 'Q15148518', 'Q15690079', 'Q15732861', 'Q15872063', 'Q16516911', 'Q16557062', 'Q18520310', 'Q18521314', 'Q19772374', 'Q19803233', 'Q19826010', 'Q19953353', 'Q19960718', 'Q20857704', 'Q20877829', 'Q20886449', 'Q21214922', 'Q21231692', 'Q21440872', 'Q5191', 'Q7391', 'Q10872', 'Q10876', 'Q18952', 'Q22708', 'Q25833', 'Q26214', 'Q26308', 'Q28960', 'Q53636', 'Q54950', 'Q80066', 'Q102778', 'Q106345', 'Q130515', 'Q130942', 'Q131393', 'Q131810', 'Q143441', 'Q147877', 'Q152228', 'Q173612', 'Q178235', 'Q193006', 'Q203547', 'Q209602', 'Q221563', 'Q241151', 'Q249907', 'Q292332', 'Q430301', 'Q607044', 'Q615290', 'Q623256', 'Q721722', 'Q743422', 'Q771526', 'Q823931', 'Q841641', 'Q914888', 'Q921647', 'Q1134438', 'Q1135987', 'Q1185781', 'Q1197160', 'Q1226966', 'Q1300407', 'Q1765819', 'Q1947035', 'Q2254408', 'Q2866420', 'Q3024630', 'Q3004758', 'Q3055705', 'Q3175675', 'Q3257299', 'Q3264619', 'Q3361697', 'Q3392049', 'Q3393217', 'Q3395756', 'Q3429854', 'Q3556237', 'Q3675396', 'Q3828260', 'Q3831105', 'Q4123974', 'Q4141140', 'Q4303297', 'Q4515446', 'Q4998033', 'Q5169430', 'Q5361179', 'Q5625164', 'Q5884387', 'Q6525920', 'Q6580400', 'Q6723361', 'Q7068314', 'Q7171646', 'Q7226196', 'Q7439587', 'Q7456120', 'Q7507704', 'Q10328362', 'Q10384753', 'Q12054093', 'Q12901395', 'Q14262202', 'Q14565729', 'Q14608344', 'Q14873650', 'Q14885022', 'Q14894448', 'Q15622027', 'Q15711568', 'Q16592019', 'Q16641932', 'Q17275429', 'Q17280823', 'Q18520653', 'Q18523434', 'Q18582973', 'Q18583954', 'Q18674857', 'Q19896399', 'Q19896462', 'Q21229853', 'Q21360812', 'Q21440083', 'Q21440100', 'Q21440195', 'Q21440556', 'Q21441164', 'Q21446175', 'Q23070890', 'Q24143310', 'Q8316', 'Q28449', 'Q21716', 'Q55475', 'Q187014', 'Q217478', 'Q221094', 'Q324132', 'Q655316', 'Q688840', 'Q1392053', 'Q18674113', 'Q1314424', 'Q1544130', 'Q2789954', 'Q14565141', 'Q17634328', 'Q16828495', 'Q21503247', 'Q21503250', 'Q16521', 'Q21503252', 'Q21510851', 'Q32583891')
    ...
    • Mar 4 2019, 4:35 PM
    • 7 Lines
  • time curl -X GET "https://search.svc.codfw.wmnet:9243/wikidatawiki_content_1537474902/_mget?_source=labels" -H 'Content-Type: application/json' -d'
    {"ids": [
    "2529806","2533557","2534508","29731","2553386","2559294","257508","2560669","2566092","2567140","2568968","2572477","2573593","2575550","2575556","259388","260135","260145","2588786","2595783","2595801","2595919","2596326","2596824","2596992","2598515","2600250","2600559","2601024","2601500","2602044","2602665","2603127","2603254","2603341","2604583","2604605","2604686","950878","953823","959056","959059","966617","973512","11565293","11569449","11576621","11578161","976686","105389","11585767","11585772","11587422","11589017","11593026","11598643","11599968","11600093","11603723","11618730","11618923","11619181","11620980","11621548","11627584","11627709","11633129","11634382","11640128","11640457","11642029","983364","11645865","11647267","11650958","11652942","11653104","11653734","11654421","11659842","11663025","985164","11664909","11665843"...
    • Mar 4 2019, 3:51 PM
    • 5 Lines
  • *************************** 1. row ***************************
    Name: revision
    Engine: InnoDB
    Version: 10
    Row_format: Compact
    ...
    • Mar 4 2019, 10:56 AM
    • 19 Lines
  • -- Special:Log type filter
    CREATE INDEX /*i*/type_time ON /*_*/logging (log_type, log_timestamp);
    -- Special:Log performer filter
    CREATE INDEX /*i*/user_time ON /*_*/logging (log_user, log_timestamp);
    ...
    • Mar 4 2019, 8:17 AM
    • 29 Lines
  • includes/Views/AbuseFilterView.php:166 PhanTypeMismatchArgument Argument 1 (config) is array{name:'wpFilterBuilder',inputId:'wpFilterBuilder',options:array} but \OOUI\DropdownInputWidget::__construct() takes array[] defined at ../../vendor/oojs/oojs-ui/php/widgets/DropdownInputWidget.php:22
    includes/Views/AbuseFilterView.php:187 PhanTypeMismatchArgument Argument 1 (config) is array{items:array{0:\OOUI\AccessKeyedElement|\OOUI\ButtonElement|\OOUI\ButtonWidget|\OOUI\Element|\OOUI\FlaggedElement|\OOUI\IconElement|\OOUI\IndicatorElement|\OOUI\LabelElement|\OOUI\TabIndexedElement|\OOUI\Tag|\OOUI\TitledElement|\OOUI\Widget|string,1:\OOUI\AccessKeyedElement|\OOUI\ButtonElement|\OOUI\ButtonWidget|\OOUI\Element|\OOUI\FlaggedElement|\OOUI\IconElement|\OOUI\IndicatorElement|\OOUI\LabelElement|\OOUI\TabIndexedElement|\OOUI\Tag|\OOUI\TitledElement|\OOUI\Widget|string}} but \OOUI\HorizontalLayout::__construct() takes \OOUI\Layout[]|\OOUI\Widget[] defined at ../../vendor/oojs/oojs-ui/php/layouts/HorizontalLayout.php:17
    includes/Views/AbuseFilterView.php:196 PhanTypeMismatchArgument Argument 1 (config) is array{items:array<int,\OOUI\Element>|array<int,\OOUI\FieldLayout>|array<int,\OOUI\LabelElement>|array<int,\OOUI\Layout>|array<int,\OOUI\Tag>|array<int,\OOUI\TitledElement>|array<int,string>|array{0:\OOUI\Element|\OOUI\FieldLayout|\OOUI\LabelElement|\OOUI\Layout|\OOUI\Tag|\OOUI\TitledElement|string},classes:array{0:'mw-abusefilter-edit-buttons',1:'mw-abusefilter-javascript-tools'}} but \OOUI\FieldsetLayout::__construct() takes \OOUI\FieldLayout[] defined at ../../vendor/oojs/oojs-ui/php/layouts/FieldsetLayout.php:26
    ...
    • Feb 28 2019, 2:30 PM
    • 27 Lines
  • Disk /dev/sda: 11.7 TiB, 12802299617280 bytes, 25004491440 sectors
    Units: sectors of 1 * 512 = 512 bytes
    Sector size (logical/physical): 512 bytes / 4096 bytes
    I/O size (minimum/optimal): 262144 bytes / 2097152 bytes
    Disklabel type: gpt
    ...
    • Feb 28 2019, 6:48 AM
    • 17 Lines
  • (/^ヮ^)/*:・゚✧ docker run --rm -it --entrypoint /bin/bash docker-registry.wikimedia.org/wikimedia-stretch:20102017
    Unable to find image 'docker-registry.wikimedia.org/wikimedia-stretch:20102017' locally
    20102017: Pulling from wikimedia-stretch
    dea2308223aa: Already exists
    Digest: sha256:7e69b67e4c0137292706b3bf9c1d404019dbde2d592c358f042eba4acbfae767
    ...
    • Feb 27 2019, 11:10 PM
    • 10 Lines
  • {
    "submodules": [
    "extensions/3D",
    "extensions/AbuseFilter",
    "extensions/ActiveAbstract",
    ...
    • Feb 27 2019, 6:10 PM
    • 195 Lines
    • JSON
  • gerrit@capella:~$ java -jar gerrit_testsite/bin/gerrit.war LocalUsernamesToLowerCase -d gerrit_testsite
    [2019-02-27 16:20:07,026] [main] INFO com.google.gerrit.server.git.LocalDiskRepositoryManager : Defaulting core.streamFileThreshold to 121m
    Exception in thread "main" com.google.inject.ConfigurationException: Guice configuration errors:
    1) No implementation for com.google.gerrit.server.change.ChangeJson$AssistedFactory was bound.
    ...
    • Feb 27 2019, 4:21 PM
    • 56 Lines
  • #!/bin/bash
    if [ $# -ne 1 ]; then
    echo "Usage: $0 <fqdn>"
    exit 1
    ...
    • Feb 27 2019, 2:54 PM
    • 13 Lines
    • Bash Scripting
  • top - 10:59:32 up 1 day, 23:44, 2 users, load average: 4.87, 5.12, 4.84
    Tasks: 866 total, 9 running, 856 sleeping, 0 stopped, 1 zombie
    %Cpu(s): 11.4 us, 55.8 sy, 0.0 ni, 17.1 id, 8.1 wa, 0.0 hi, 1.4 si, 6.1 st
    KiB Mem: 8179168 total, 7949804 used, 229364 free, 118400 buffers
    KiB Swap: 523260 total, 0 used, 523260 free. 1618296 cached Mem
    ...
    • Feb 27 2019, 10:59 AM
    • 11 Lines
  • root@db1115:~$ cat /etc/nagios/nrpe.d/check_mariadb_backup_m1_codfw.cfg
    # File generated by puppet. DO NOT edit by hand
    command[check_mariadb_backup_m1_codfw]=/usr/local/bin/check_mariadb_backups.py --section='m1' --datacenter='codfw'
    root@db1115:~$ /usr/local/bin/check_mariadb_backups.py --section='m1' --datacenter='codfw'
    We could not connect to the backup metadata database
    ...
    • Feb 27 2019, 10:52 AM
    • 22 Lines
  • root@tools-k8s-master-01:~# kubectl get nodes
    NAME STATUS AGE
    tools-worker-1001.tools.eqiad.wmflabs Ready 2y
    tools-worker-1002.tools.eqiad.wmflabs Ready,SchedulingDisabled 2y
    tools-worker-1003.tools.eqiad.wmflabs Ready 2y
    ...
    • Feb 26 2019, 8:20 PM
    • 324 Lines
  • bblack@haliax:~$ mtr --report text-lb.eqiad.wikimedia.org
    Start: Tue Feb 26 15:01:29 2019
    HOST: haliax Loss% Snt Last Avg Best Wrst StDev
    1.|-- 192.168.42.1 0.0% 10 3.1 2.3 1.3 4.7 1.2
    2.|-- 192.168.1.254 0.0% 10 3.1 3.4 2.3 5.5 0.9
    ...
    • Feb 26 2019, 3:03 PM
    • 36 Lines
  • #!/usr/bin/python
    ''' Need to set RESULT_STORAGE = None (so not to save output to swift)'''
    import logging
    import sys
    ...
    • Feb 26 2019, 1:04 PM
    • 125 Lines
    • Python
  • +---------------------------------------+----------+---------+---------+------------+---------+
    | CONCAT(table_schema, '.', table_name) | rows | DATA | idx | total_size | idxfrac |
    +---------------------------------------+----------+---------+---------+------------+---------+
    | wikidatawiki.wb_terms | 1959.93M | 141.58G | 269.64G | 411.22G | 1.90 |
    | wikidatawiki.revision | 806.64M | 77.87G | 92.02G | 169.89G | 1.18 |
    ...
    • Feb 26 2019, 10:43 AM
    • 14 Lines
  • jbond@cloudservices1003:~$ apt-cache policy pdns-recursor
    pdns-recursor:
    Installed: 4.0.4-1+deb9u3~bpo8+1
    Candidate: 4.0.4-1+deb9u3~bpo8+1
    Package pin: 4.0.4-1+deb9u3~bpo8+1
    ...
    • Feb 25 2019, 9:54 AM
    • 17 Lines
    • Feb 23 2019, 1:22 AM
    • 1 Line
  • banana potato
    • Feb 22 2019, 7:28 PM
    • 1 Line
  • diff --git a/src/MediaWiki/SchemaEditAction.php b/src/MediaWiki/SchemaEditAction.php
    index c216e5e..83473bc 100644
    --- a/src/MediaWiki/SchemaEditAction.php
    +++ b/src/MediaWiki/SchemaEditAction.php
    @@ -3,12 +3,21 @@
    ...
    • Feb 22 2019, 5:17 PM
    • 131 Lines
  • Current smart-data-dump.py:
    device_smart_offline_uncorrectable{device="sda"} 0.0
    device_smart_offline_uncorrectable{device="sdb"} 0.0
    device_smart_udma_crc_error_count{device="sda"} 0.0
    ...
    • Feb 21 2019, 10:19 PM
    • 143 Lines
  • {"submitter":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"refUpdate":{"oldRev":"fcb6c573af0aba4700b46c801e1e110f68570f89","newRev":"abfa32f42bf72dbe4c42301c77fce83885054136","refName":"refs/changes/21/2421/meta","project":"2222"},"type":"ref-updated","eventCreatedOn":1550778073}
    {"changer":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"patchSet":{"number":1,"revision":"f03eab9d63f52d8d8a32688f3b0be0a33b61d836","parents":["331f7a51196d0e54d28ef3c342ee8649c206d95f"],"ref":"refs/changes/21/2421/1","uploader":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"createdOn":1550777985,"author":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"kind":"REWORK","sizeInsertions":0,"sizeDeletions":0},"change":{"project":"2222","branch":"master","id":"I9e9ccf2cc242f4b485ee4d9b672f3827ab55f1ac","number":2421,"subject":"test","owner":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"url":"http://gerrit....
    • Feb 21 2019, 7:42 PM
    • 2 Lines
  • {"submitter":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"refUpdate":{"oldRev":"c9980ef6064475ca8fe2a69158ec98238fbdfaa1","newRev":"fcb6c573af0aba4700b46c801e1e110f68570f89","refName":"refs/changes/21/2421/meta","project":"2222"},"type":"ref-updated","eventCreatedOn":1550778020}
    {"changer":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"patchSet":{"number":1,"revision":"f03eab9d63f52d8d8a32688f3b0be0a33b61d836","parents":["331f7a51196d0e54d28ef3c342ee8649c206d95f"],"ref":"refs/changes/21/2421/1","uploader":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"createdOn":1550777985,"author":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"kind":"REWORK","sizeInsertions":0,"sizeDeletions":0},"change":{"project":"2222","branch":"master","id":"I9e9ccf2cc242f4b485ee4d9b672f3827ab55f1ac","number":2421,"subject":"test","owner":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"url":"http://gerrit....
    • Feb 21 2019, 7:42 PM
    • 3 Lines
  • {"refUpdate":{"oldRev":"00a0492bc79e0a14dd761ca9b9567956fcb23a14","newRev":"cbf5e3e198ce5bc246a8b0466dfbee28b1883db2","refName":"refs/sequences/changes","project":"All-Projects"},"type":"ref-updated","eventCreatedOn":1550777985}
    {"submitter":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"refUpdate":{"oldRev":"0000000000000000000000000000000000000000","newRev":"f03eab9d63f52d8d8a32688f3b0be0a33b61d836","refName":"refs/changes/21/2421/1","project":"2222"},"type":"ref-updated","eventCreatedOn":1550777986}
    {"submitter":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"refUpdate":{"oldRev":"0000000000000000000000000000000000000000","newRev":"c9980ef6064475ca8fe2a69158ec98238fbdfaa1","refName":"refs/changes/21/2421/meta","project":"2222"},"type":"ref-updated","eventCreatedOn":1550777986}
    {"uploader":{"name":"Administrator","email":" xxx@gamil.com","username":"admin"},"patchSet":{"number":1,"revision":"f03eab9d63f52d8d8a32688f3b0be0a33b61d836","parents"...
    • Feb 21 2019, 7:41 PM
    • 4 Lines
  • root@db2092.codfw.wmnet[enwiki]> select count(*),hour(rc_timestamp) as hour from recentchanges where hour(rc_timestamp)<24 group by hour(rc_timestamp);
    +----------+------+
    | count(*) | hour |
    +----------+------+
    | 334803 | 0 |
    ...
    • Feb 21 2019, 3:39 PM
    • 30 Lines
  • jynus@sangai:/media/home/jynus/wmfmariadbpy$ ssh clouddb1001.clouddb-services.eqiad.wmflabs
    Linux clouddb1001 4.9.0-8-amd64 #1 SMP Debian 4.9.144-3 (2019-02-02) x86_64
    Debian GNU/Linux 9.8 (stretch)
    clouddb1001 is role::wmcs::db::toolsdb_primary
    The last Puppet run was at Thu Feb 21 08:34:33 UTC 2019 (13 minutes ago).
    ...
    • Feb 21 2019, 8:54 AM
    • 15 Lines
  • aawiki
    aawikibooks
    aawiktionary
    abwiki
    abwiktionary
    ...
    • Feb 20 2019, 11:48 PM
    • 896 Lines
  • aawiki,aa
    aawikibooks,aa
    aawiktionary,aa
    abwiki,ab
    abwiktionary,ab
    ...
    • Feb 20 2019, 11:34 PM
    • 941 Lines
  • Feb 20 20:18:22 deployment-db03 mysqld[24655]: 190220 20:18:22 [Note] /opt/wmf-mariadb10/bin/mysqld (mysqld 10.0.34-MariaDB) starting as process 24654 ...
    Feb 20 20:18:22 deployment-db03 mysqld[24655]: 190220 20:18:22 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used; This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=deployment-db03' or '--log-bin=deployment-db03-bin' to avoid this problem.
    Feb 20 20:18:22 deployment-db03 mysqld[24655]: 190220 20:18:22 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    Feb 20 20:18:22 deployment-db03 mysqld[24655]: 190220 20:18:22 [Note] InnoDB: The InnoDB memory heap is disabled
    Feb 20 20:18:22 deployment-db03 mysqld[24655]: 190220 20:18:22 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    ...
    • Feb 20 2019, 8:22 PM
    • 238 Lines
  • smalyshev@stat1007:/srv/home/mkroetzsch/querydata/export/anonymization$ ls -lR
    .:
    total 8
    drwxr-xr-x 2 15336 wikidev 4096 Oct 13 22:11 I1-I3
    drwxr-xr-x 2 15336 wikidev 4096 Oct 13 23:12 I4-I7
    ...
    • Feb 20 2019, 6:36 PM
    • 32 Lines