Page MenuHomePhabricator
Paste Active Pastes
  • enwiki
    wikidatawiki
    commonswiki
    jawiki
    glwiki
    ...
    • Mar 27 2019, 1:58 PM
    • 34 Lines
  • ~
    ▶ cd Desktop
    ~/Desktop
    ▶ mkcd tr
    ...
    • Mar 27 2019, 12:11 PM
    • 79 Lines
  • $data = {
    'bar' => {
    'regr' => 'BAR',
    'directory' => "BARDIR"
    },
    ...
    • Mar 27 2019, 11:37 AM
    • 28 Lines
  • 02:54:06 1 ✗ zhuyifei1999@tools-sgebastion-08: ~$ (ulimit -v $(( (1<<20) * 2 )); strace -e mmap,munmap,brk -f java -Xmx1G -version)
    brk(NULL) = 0x561dc983d000
    mmap(NULL, 105680, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f12f27e3000
    mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f12f27e1000
    mmap(NULL, 2200072, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f12f23c0000
    ...
    • Mar 27 2019, 2:56 AM
    • 307 Lines
  • ===== NODE GROUP =====
    (33) elastic[2025-2026,2028,2031,2034,2037-2038,2041-2042,2045-2047,2050-2052].codfw.wmnet,elastic[1017-1020,1022-1023,1028-1034,1036-1038,1040-1041].eqiad.wmnet
    ----- OUTPUT of 'curl -s http://l...verything | jq .' -----
    parse error: Invalid numeric literal at line 1, column 5
    ================
    • Mar 26 2019, 10:13 PM
    • 5 Lines
  • ===== NODE GROUP =====
    (33) elastic[2025-2026,2028,2031,2034,2037-2038,2041-2042,2045-2047,2050-2052].codfw.wmnet,elastic[1017-1020,1022-1023,1028-1034,1036-1038,1040-1041].eqiad.wmnet
    ----- OUTPUT of 'curl -s http://l...verything | jq .' -----
    parse error: Invalid numeric literal at line 1, column 5
    ================
    • Mar 26 2019, 10:13 PM
    • 5 Lines
  • ===== NODE GROUP =====
    (33) elastic[2025-2026,2028,2031,2034,2037-2038,2041-2042,2045-2047,2050-2052].codfw.wmnet,elastic[1017-1020,1022-1023,1028-1034,1036-1038,1040-1041].eqiad.wmnet
    ----- OUTPUT of 'curl -s http://l...verything | jq .' -----
    {
    "error": {
    ...
    • Mar 26 2019, 10:13 PM
    • 25 Lines
  • ===== NODE GROUP =====
    (65) elastic[2025-2054].codfw.wmnet,elastic[1017-1020,1022-1052].eqiad.wmnet
    ----- OUTPUT of 'curl -s http://l...verything | jq .' -----
    parse error: Invalid numeric literal at line 1, column 5
    ================
    • Mar 26 2019, 10:13 PM
    • 5 Lines
  • ===== NODE GROUP =====
    (65) elastic[2025-2054].codfw.wmnet,elastic[1017-1020,1022-1052].eqiad.wmnet
    ----- OUTPUT of 'curl -s http://l...verything | jq .' -----
    {
    "error": {
    ...
    • Mar 26 2019, 10:11 PM
    • 25 Lines
  • ===== NODE GROUP =====
    (35) elastic[1017-1020,1022-1052].eqiad.wmnet
    ----- OUTPUT of 'curl -s http://l...er|cluster_name'' -----
    "cluster_name" : "production-search-eqiad",
    "number" : "6.5.4",
    ...
    • Mar 26 2019, 9:47 PM
    • 16 Lines
  • ===== NODE GROUP =====
    (1) elastic1034.eqiad.wmnet
    ----- OUTPUT of 'curl -s http://localhost:9200/' -----
    {
    "name" : "elastic1034-production-search-eqiad",
    ...
    • Mar 26 2019, 9:47 PM
    • 1,249 Lines
  • ===== NODE GROUP =====
    (13) elastic[2031,2033-2036,2045,2047,2049-2054].codfw.wmnet
    ----- OUTPUT of 'curl -s http://l...0/ | grep number' -----
    "number" : "5.6.14",
    ===== NODE GROUP =====
    ...
    • Mar 26 2019, 9:46 PM
    • 9 Lines
  • package main
    import (
    "encoding/json"
    "flag"
    ...
    • Mar 26 2019, 5:27 PM
    • 152 Lines
  • * How long have you professionally known or worked with the candidate?
    * What was your working relationship with xyz candidate, how you interfaced, what sorts of projects you worked closely on...?
    * The Wikimedia Foundation is unusually collaborative in nature: how do you think the candidate would do in this environment?
    * How does candidate accept constructive criticism? How do they communicate a difficult message?
    * What would you say makes candidate stand out among their peers?
    ...
    • Mar 26 2019, 4:47 PM
    • 8 Lines
  • cdanis@icinga2001.wikimedia.org ~ % ps ax | grep 'nsc[a]'
    4323 ? SL 0:00 /usr/sbin/nsca --daemon -c /etc/nsca.cfg
    4353 ? SL 0:00 /usr/sbin/nsca --daemon -c /etc/nsca.cfg
    4354 ? SL 0:00 /usr/sbin/nsca --daemon -c /etc/nsca.cfg
    4360 ? SL 0:00 /usr/sbin/nsca --daemon -c /etc/nsca.cfg
    ...
    • Mar 26 2019, 1:03 PM
    • 255 Lines
  • <div class="">
    <br><br><br><br><br><br>
    <h1>vars</h1>
    <table>
    <tr>
    ...
    • Mar 26 2019, 10:17 AM
    • 50 Lines
    • PHP
  • // Line 8406 is case CLIENT_TRANSACTION_RESULT_ERROR_ABORT
    // $s:struct State* $total_time:ink_hrtime $client_transaction_result:enum ClientTransactionResult_t $total_msec:ink_hrtime
    probe process("/usr/bin/traffic_server").statement("client_result_stat@./proxy/http/HttpTransact.cc:8406")
    {
    ui = $s->unmapped_url->m_url_impl
    ...
    • Mar 26 2019, 10:12 AM
    • 17 Lines
  • Mar 26 00:38:05 wikitech-static import-wikitech.sh[18977]: --2019-03-26 00:38:05-- https://wikitech.wikimedia.org/dumps/labswiki-20190326.xml.gz
    Mar 26 00:38:05 wikitech-static import-wikitech.sh[18977]: Resolving wikitech.wikimedia.org (wikitech.wikimedia.org)... 208.80.153.224
    Mar 26 00:38:05 wikitech-static import-wikitech.sh[18977]: Connecting to wikitech.wikimedia.org (wikitech.wikimedia.org)|208.80.153.224|:443... connected.
    Mar 26 00:38:05 wikitech-static import-wikitech.sh[18977]: HTTP request sent, awaiting response... 404 Not Found
    Mar 26 00:38:05 wikitech-static import-wikitech.sh[18977]: 2019-03-26 00:38:05 ERROR 404: Not Found.
    ...
    • Mar 26 2019, 12:38 AM
    • 63 Lines
  • Mar 26 00:01:21 wikitech-static systemd[1]: Starting Certbot...
    Mar 26 00:01:31 wikitech-static systemd[1]: Stopping The Apache HTTP Server...
    Mar 26 00:01:32 wikitech-static systemd[1]: Stopped The Apache HTTP Server.
    Mar 26 00:01:38 wikitech-static systemd[1]: Starting The Apache HTTP Server...
    Mar 26 00:01:38 wikitech-static apachectl[17256]: httpd (pid 17234) already running
    ...
    • Mar 26 2019, 12:16 AM
    • 9 Lines
  • COMMAND PID TID USER FD TYPE DEVICE SIZE/OFF NODE NAME
    systemd 1 root cwd DIR 254,3 4096 2 /
    systemd 1 root rtd DIR 254,3 4096 2 /
    systemd 1 root txt REG 254,3 1120968 1061554 /lib/systemd/systemd
    systemd 1 root mem REG 254,3 19008 1048737 /lib/x86_64-linux-gnu/libuuid.so.1.3.0
    ...
    • Mar 25 2019, 9:58 PM
    • 26,900 Lines
  • Fri Mar 22 00:33:13 2019
    Fri Mar 22 00:33:14 2019
    Fri Mar 22 00:33:14 2019
    Fri Mar 22 00:33:15 2019
    Fri Mar 22 00:33:15 2019
    ...
    • Mar 25 2019, 8:45 PM
    • 2,405 Lines
  • <tr><td class='dataVar'>Program Version:</td><td class='dataVal'>1.13.4</td></tr>
    <tr><td class='dataVar'>Program Start Time:</td><td class='dataVal'>2019-03-25 19:44:53</td></tr>
    <tr><td class='dataVar'>Total Running Time:</td><td class='dataVal'>0d 0h 10m 17s</td></tr>
    <tr><td class='dataVar'>Last External Command Check:</td><td class='dataVal'>2019-03-25 19:54:55</td></tr>
    <tr><td class='dataVar'>Last Log File Rotation:</td><td class='dataVal'>N/A</td></tr>
    ...
    • Mar 25 2019, 7:55 PM
    • 17 Lines
  • #!/bin/bash
    host=labsdb1011
    case $host in \
    ...
    • Mar 25 2019, 2:11 PM
    • 23 Lines
  • extracts_props n
    limit|intro|plaintext 9035373
    intro 7421959
    intro|plaintext 6027851
    chars|limit|intro|plaintext 4985313
    ...
    • Mar 22 2019, 7:43 PM
    • 86 Lines
    • SQL
  • vagrant@contrib-stretch:~/src/wmf/release$ scap task-series blockers --count 26 --date 2019-04-15 1.34.0-wmf.1
    1.34.0-wmf.1 : 2019-04-15 00:00:00, 1555286400
    20:23:11 Unhandled error:
    Traceback (most recent call last):
    File "/vagrant/scap/scap/cli.py", line 327, in run
    ...
    • Mar 21 2019, 8:23 PM
    • 16 Lines
  • [21-Mar-2019 15:03:17 UTC] 2019-03-21 3:03:17 PM [SGNL] Overseer ("13403") received signal 1 ("SIGHUP").
    [21-Mar-2019 15:03:58 UTC] 2019-03-21 3:03:58 PM [SGNL] Overseer ("13403") received signal 1 ("SIGHUP").
    [21-Mar-2019 15:04:28 UTC] 2019-03-21 3:04:28 PM [SGNL] Overseer ("13403") received signal 1 ("SIGHUP").
    [21-Mar-2019 15:05:50 UTC] 2019-03-21 3:05:50 PM [SGNL] Overseer ("13403") received signal 1 ("SIGHUP").
    [21-Mar-2019 15:05:50 UTC] 2019-03-21 3:05:50 PM [SGNL] Overseer ("13403") received signal 2 ("SIGINT").
    ...
    • Mar 21 2019, 3:40 PM
    • 7 Lines
  • #on centralauth db
    # Find users that are in the wikidata staff group
    select user_name from user_groups INNER JOIN user ON ug_user = user_id where ug_group = "wikidata-staff";
    ...
    • Mar 21 2019, 2:37 PM
    • 9 Lines
  • -----------------test2wiki-------------------------
    MariaDB [test2wiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
    +---------+---------------+----------+------------+
    | pp_page | pp_propname | pp_value | pp_sortkey |
    ...
    • Mar 21 2019, 9:19 AM
    • 154 Lines
  • /*
    probe process("/usr/bin/traffic_server").function("new_connection@./proxy/http/HttpServerSession.cc:61") {
    println("HttpServerSession::new_connection")
    print_ubacktrace()
    }
    ...
    • Mar 21 2019, 8:40 AM
    • 29 Lines
  • (((ᅥݡЁ͡ձ$you set the value really high and it still stopped. My guess is you might havemprove this question
    asked Apr 2 '13 at 23:40
    TooCooL
    6,79062237
    ...
    • Mar 21 2019, 7:53 AM
    • 13 Lines
  • 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