Page MenuHomeMiraheze
Paste Active Pastes
  • root@mw5:/var/log# mtr --report ns1.miraheze.org
    Start: 2020-07-25T13:56:36+0000
    HOST: mw5 Loss% Snt Last Avg Best Wrst StDev
    1.|-- 2001:41d0:800:10ff:ff:ff: 0.0% 10 1.2 1.3 0.9 2.0 0.4
    2.|-- vl15.lon1-eri1-sdagg4b-a7 0.0% 10 0.3 0.3 0.2 0.5 0.1
    ...
    • Sat, Jul 25, 13:58
    • 20 Lines
  • 9b6twiki
    a320wiki
    abrigadawiki
    aeiawiki
    aibowiki
    ...
    • Mon, Jul 20, 19:09
    • 180 Lines
  • refreshLinksDynamic
    refreshLinksPrioritized
    htmlCacheUpdate
    recentChangesUpdate
    activityUpdateJob
    ...
    • Mon, Jul 20, 15:00
    • 13 Lines
  • jobrunner1.miraheze.org:
    mw7.miraheze.org:
    htmlCacheUpdate
    recentChangesUpdate
    refreshLinksDynamic
    ...
    • Mon, Jul 20, 14:44
    • 8,075 Lines
  • root@puppet2:/home/paladox# salt-ssh -E "(mw.*|jobrunner.*)" cmd.run "cat /var/log/mediawiki/debug*/exception.log | grep categoryMembershipChange | awk '{print \$4}'"
    mw7.miraheze.org:
    csydeswiki:
    thefinalrumblewiki:
    csydeswiki:
    ...
    • Mon, Jul 20, 13:56
    • 112 Lines
  • #!/bin/bash
    while read line; do
    mysql -e "use mhglobal; update cw_wikis set wiki_dbcluster = 'c2' where wiki_dbname = '${line}';"
    done < /home/paladox/db9-migration-closed-July11-2020/wikis_batch_1
    • Tue, Jul 14, 23:15
    • 4 Lines
  • root@puppet2:/etc/puppetlabs/puppet/environments/production# ls -lah
    total 8.0K
    drwxrwxr-x 2 root root 4.0K Feb 9 03:44 .
    drwxrwxr-x 3 root root 4.0K Feb 9 03:44 ..
    lrwxrwxrwx 1 root root 32 Feb 9 02:25 manifests -> /etc/puppetlabs/puppet/manifests
    ...
    • Tue, Jul 14, 21:44
    • 7 Lines
  • root@puppet2:/etc/puppetlabs/puppet# ls -lah
    total 112K
    drwxr-xr-x 13 root root 4.0K Jun 4 13:59 .
    drwxr-xr-x 7 root root 4.0K Apr 11 17:38 ..
    -rw-r--r-- 1 root root 5.4K Feb 9 02:13 auth.conf
    ...
    • Tue, Jul 14, 21:44
    • 24 Lines
  • var_> var_dump($wgAutopromote);
    array(6) {
    ["autoconfirmed"]=>
    array(3) {
    [0]=>
    ...
    • Sat, Jul 11, 20:54
    • 51 Lines
  • Traceback (most recent call last):
    File "/srv/mediawiki/w/extensions/MirahezeMagic/py/generateSitemapIndex.py", line 57, in <module>
    xmlfile.write('\n\t<sitemap>{0}{1}\n\t</sitemap>'.format(str(loc), str(lastmod)))
    OSError: [Errno 9] Bad file descriptor
    ...
    • Fri, Jul 10, 14:16
    • 15 Lines
  • # Pastebin zAvbOxq0
    # $OpenBSD: sshd_config,v 1.103 2018/04/09 20:41:22 tj Exp $
    # This is the sshd server system-wide configuration file. See
    # sshd_config(5) for more information.
    ...
    • Jun 29 2020, 23:09
    • 122 Lines
  • MariaDB [mhglobal]> select * from globaluser where gu_name = 'zalgo';
    Empty set (0.001 sec)
    MariaDB [mhglobal]> select * from localuser where lu_name = 'zalgo';
    Empty set (0.001 sec)
    ...
    • Jun 19 2020, 17:58
    • 14 Lines
    • Plain Text
  • DELETE FROM catalog_resources WHERE certname_id = (SELECT id FROM certnames where certname = 'dbt1.miraheze.org');
    DELETE FROM catalog_resources WHERE title LIKE '%dbt1.miraheze.org%';
    DELETE FROM resource_params WHERE value LIKE '%dbt1.miraheze.org%';
    DELETE FROM factsets WHERE certname LIKE '%dbt1.miraheze.org%';
    • Jun 11 2020, 18:48
    • 4 Lines
  • protected function pickFromDatabase() {
    global $wgRandomImageStrict;
    $dbr = wfGetDB( DB_REPLICA );
    ...
    • May 24 2020, 20:50
    • 31 Lines
  • DROP DATABASE 2035wikiwiki;
    DROP DATABASE 2035wikiwiki;
    DROP DATABASE abayedavwiki;
    DROP DATABASE aberrantencyclopediawiki;
    DROP DATABASE abysmalrobotmasterswiki;
    ...
    • May 10 2020, 18:51
    • 37 Lines
  • > var_dump($wgAddGroups);
    array(2) {
    ["bureaucrat"]=>
    array(8) {
    [0]=>
    ...
    • May 5 2020, 20:36
    • 37 Lines
  • 2020-05-05 16:24:32 test2 atrociousyoutuberswiki: [c9eb069fc9c54491f4bcee2f] /wiki/Special:RecentChanges Flow\Exception\InvalidDataException from line 57 of /srv/mediawiki/w/extensions/Flow/includes/Model/UserTuple.php: User has both id and ip
    #0 /srv/mediawiki/w/extensions/Flow/includes/Model/UserTuple.php(86): Flow\Model\UserTuple->__construct(string, integer, string)
    #1 /srv/mediawiki/w/extensions/Flow/includes/Model/AbstractRevision.php(172): Flow\Model\UserTuple::newFromArray(array, string)
    #2 /srv/mediawiki/w/extensions/Flow/includes/Model/PostRevision.php(123): Flow\Model\AbstractRevision::fromStorageRow(array, Flow\Model\PostRevision)
    #3 /srv/mediawiki/w/extensions/Flow/includes/Data/Mapper/CachingObjectMapper.php(89): Flow\Model\PostRevision::fromStorageRow(array, NULL)
    ...
    • May 5 2020, 16:27
    • 35 Lines
  • $dbw->delete(
    'logging',
    [
    'log_action' => 'rename',
    'log_title' => $oldName,
    ...
    • May 2 2020, 17:59
    • 8 Lines
  • <?php
    /**
    * This program is free software; you can redistribute it and/or modify
    * it under the terms of the GNU General Public License as published by
    ...
    • May 1 2020, 14:41
    • 319 Lines
  • > $test = [ 'flow_revision' => [ 'fields' => [ 'test1' => '' ] ], 'flow_revision' => [ 'fields' => [ 'test2' => '' ] ] ];
    > print_r($test);
    Array
    (
    ...
    • May 1 2020, 14:23
    • 15 Lines
  • $extensionUpdates = [
    'flow_revision' = [
    'fields' => [
    'rev_mod_user_ip' => '',
    ],
    ...
    • May 1 2020, 13:21
    • 18 Lines
  • $extensionUpdates['flow_revision'] = [
    'table' => 'flow_revision',
    'fields' => [
    'rev_mod_user_ip' => '',
    ...
    • May 1 2020, 13:17
    • 19 Lines
  • SELECT Comment_Username,Comment_IP,Comment_Text,Comment_Date,Comment_Date AS timestamp,CommentID,Comment_Parent_ID,vote1.Comment_Vote_Score AS current_vote,SUM(vote2.Comment_Vote_Score) AS comment_score, stats_total_points FROM `Comments`, `user_stats` LEFT JOIN `Comments_Vote` `vote1` ON ((vote1.Comment_Vote_ID = CommentID)) LEFT JOIN `Comments_Vote` `vote2` ON ((vote2.Comment_Vote_ID = CommentID)) LEFT JOIN `Comments` `Comments` ON ((Comment_actor = stats_actor)) WHERE Comment_Page_ID = '22891' GROUP BY CommentID
    • Apr 30 2020, 16:55
    • 1 Line
  • GlobalBlocking/sql/globalblocks.sql:12:)
    GlobalBlocking/sql/global_block_whitelist.sql:8:)
    GlobalBlocking/sql/global_block_whitelist.sql:10:CREATE
    Flow/flow.sql:17:)
    Flow/flow.sql:27:)
    ...
    • Apr 29 2020, 18:51
    • 268 Lines
  • $this->recacheJson();
    foreach ( (array)$this->tables as $table => $selector ) {
    $this->cwdb->update(
    $table,
    ...
    • Apr 18 2020, 16:20
    • 13 Lines
  • <?php
    require_once __DIR__ . '/../../../maintenance/Maintenance.php';
    class hackScript extends Maintenance {
    ...
    • Apr 17 2020, 01:02
    • 47 Lines
  • Apr 15 20:01:36 jobrunner1 jobrunner[31595]: nice -15 php /srv/mediawiki/w/maintenance/runJobs.php --wiki='nihongowiki' --type='LocalGlobalUserPageCacheUpdateJob' --maxtime='60' --memory-limit='192M' --result=json STDERR:
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: #011PHP Warning: count(): Parameter must be an array or an object that implements Countable in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 57
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: Warning: count(): Parameter must be an array or an object that implements Countable in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 57
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: PHP Notice: Undefined index: domains in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 67
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: Notice: Undefined index: domains in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 67
    ...
    • Apr 15 2020, 20:11
    • 19 Lines
  • root@mw4:/srv/mediawiki/w/maintenance# sudo -u www-data php eval.php --wiki=awfulmovieswiki
    > var_dump($wgNamespaceAliases);
    array(3) {
    [""]=>
    int(275)
    ...
    • Apr 15 2020, 18:34
    • 10 Lines
  • "namespacealiases": [
    {
    "id": 6,
    "*": "Image"
    },
    ...
    • Apr 15 2020, 18:30
    • 14 Lines
  • [08-Apr-2020 17:36:09] [pool www] pid 1021
    script_filename = /srv/mediawiki/w/index.php
    [0x00007efecb01ff10] curl_exec() /srv/mediawiki/w/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php:40
    [0x00007efecb01fe70] __invoke() /srv/mediawiki/w/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php:28
    [0x00007efecb01fdc0] GuzzleHttp\Handler\{closure}() /srv/mediawiki/w/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php:51
    ...
    • Apr 8 2020, 17:49
    • 22 Lines
  • > var_dump($wgContentHandlers);
    array(9) {
    ["JsonSchema"]=>
    string(24) "JsonSchemaContentHandler"
    ["Scribunto"]=>
    ...
    • Apr 7 2020, 02:09
    • 21 Lines
  • [06-Apr-2020 00:10:22 UTC] wgRelatedArticlesFooterWhitelistedSkins
    2020-04-06 00:10:22 test2 test2wiki: [510a5ab26fd4e519adfd961c] /wiki/Special:ManageWiki/settings ErrorException from line 232 of /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php: PHP Warning: error_log() expects parameter 1 to be string, array given
    #0 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array)
    #1 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(232): error_log(array, integer)
    #2 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(21): ManageWikiFormFactoryBuilder::buildDescriptorSettings(string, boolean, RequestContext, RemoteWiki)
    ...
    • Apr 6 2020, 00:24
    • 17 Lines
  • [06-Apr-2020 00:10:22 UTC] wgAbuseFilterActions
    2020-04-06 00:10:22 test2 test2wiki: [510a5ab26fd4e519adfd961c] /wiki/Special:ManageWiki/settings ErrorException from line 232 of /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php: PHP Warning: error_log() expects parameter 1 to be string, array given
    #0 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array)
    #1 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(232): error_log(array, integer)
    #2 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(21): ManageWikiFormFactoryBuilder::buildDescriptorSettings(string, boolean, RequestContext, RemoteWiki)
    ...
    • Apr 6 2020, 00:22
    • 388 Lines
  • DROP DATABASE 2a2pwiki;
    DROP DATABASE 2b2tmcpewiki;
    DROP DATABASE 5rmmwiki;
    DROP DATABASE 7b7twiki;
    DROP DATABASE abootwikiwiki;
    ...
    • Apr 5 2020, 13:04
    • 1,072 Lines
  • {
    "timestamp": 0,
    "database": "metawiki",
    "created": "20150802185000",
    "dbcluster": "c1",
    ...
    • Mar 30 2020, 18:28
    • 8,651 Lines
    • JSON
  • File: databases.json
    ----
    {
    "timestamp": "20200329000000",
    "databases": [
    ...
    • Mar 29 2020, 19:59
    • 97 Lines
  • DELETE FROM catalog_resources WHERE certname_id = (SELECT id FROM certnames where certname = 'ns1.miraheze.org');
    DELETE FROM catalog_resources WHERE title LIKE '%ns1.miraheze.org%';
    DELETE FROM resource_params WHERE value LIKE '%ns1.miraheze.org%';
    DELETE FROM factsets WHERE certname LIKE '%ns1.miraheze.org%';
    • Mar 29 2020, 16:42
    • 4 Lines
  • 131parkhurstwiki
    200xwiki
    220biblewiki
    2boffy2tpswiki
    2builders2toolswiki
    ...
    • Mar 28 2020, 16:46
    • 1,818 Lines
  • <?php
    /**
    * This program is free software; you can redistribute it and/or modify
    * it under the terms of the GNU General Public License as published by
    * the Free Software Foundation; either version 2 of the License, or
    ...
    • Mar 28 2020, 16:40
    • 67 Lines
  • This is ApacheBench, Version 2.3 <$Revision: 1843412 $>
    Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
    Licensed to The Apache Software Foundation, http://www.apache.org/
    Benchmarking test2.miraheze.org (be patient)
    ...
    • Mar 24 2020, 02:22
    • 57 Lines
  • This is ApacheBench, Version 2.3 <$Revision: 1843412 $>
    Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
    Licensed to The Apache Software Foundation, http://www.apache.org/
    Benchmarking test2.miraheze.org (be patient)
    ...
    • Mar 24 2020, 02:21
    • 56 Lines
  • {{Server
    | name = xxx
    | location =
    | host = xxx.miraheze.org
    | usage =
    ...
    • Mar 19 2020, 21:23
    • 16 Lines
  • root@db4:/home/paladox# sed -n '501,1001p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_2
    root@db4:/home/paladox# sed -n '1002,1502p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_2
    root@db4:/home/paladox# sed -n '1503,2003p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_4
    root@db4:/home/paladox# sed -n '1002,1502p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_3
    root@db4:/home/paladox# sed -n '2004,2504p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_5
    ...
    • Mar 8 2020, 13:13
    • 9 Lines
  • My plan for the migrations will consist of setting the wiki into read only mode, backing up the db (by copying it to the new db host), restoring the db from the import on the new db server, switching the wiki to use the new db server and making the wiki use the new cache proxy.
    The below is a guide on the steps i will take to migrate wikis to the new infrastructure (note that not all steps have to be followed, but should be evauluated depending on size).
    1. Set the wiki into read only, you can do this by setting wgReadOnly in LocalSettings to 'Wiki being migrated to the new infrastructure'.
    ...
    • Feb 19 2020, 02:43
    • 10 Lines
  • root@db7:/home/paladox# fio --ioengine=libaio --size=1024m --filename=$HOME/tempfile --direct=1 --loops=5 --name=test --bs=1024m --rw=write --zero_buffers=1
    test: (g=0): rw=write, bs=(R) 1024MiB-1024MiB, (W) 1024MiB-1024MiB, (T) 1024MiB-1024MiB, ioengine=libaio, iodepth=1
    fio-3.12
    Starting 1 process
    test: Laying out IO file (1 file / 1024MiB)
    ...
    • Feb 17 2020, 21:43
    • 30 Lines
  • root@db7:/home/paladox# sudo stress-ng --cpu 4 --io 4 --vm 1 --vm-bytes 1G --timeout 60s --metrics-brief
    stress-ng: info: [32330] dispatching hogs: 4 cpu, 4 io, 1 vm
    stress-ng: info: [32330] successful run completed in 60.18s (1 min, 0.18 secs)
    stress-ng: info: [32330] stressor bogo ops real time usr time sys time bogo ops/s bogo ops/s
    stress-ng: info: [32330] (secs) (secs) (secs) (real time) (usr+sys time)
    ...
    • Feb 17 2020, 21:21
    • 8 Lines
  • root@misc2:/home/paladox# ping mw2.miraheze.org
    PING mw2.miraheze.org(2a00:d880:5:799::2 (2a00:d880:5:799::2)) 56 data bytes
    64 bytes from 2a00:d880:5:799::2 (2a00:d880:5:799::2): icmp_seq=1 ttl=62 time=1.40 ms
    64 bytes from 2a00:d880:5:799::2 (2a00:d880:5:799::2): icmp_seq=2 ttl=62 time=0.518 ms
    64 bytes from 2a00:d880:5:799::2 (2a00:d880:5:799::2): icmp_seq=3 ttl=62 time=7.51 ms
    ...
    • Feb 17 2020, 17:06
    • 24 Lines
    • Plain Text
  • # This file describes the network interfaces available on your system
    # and how to activate them. For more information, see interfaces(5).
    source /etc/network/interfaces.d/*
    ...
    • Feb 11 2020, 23:54
    • 18 Lines
  • 100.00% 249.777 1 - main()
    94.72% 236.597 1 - MediaWiki::run
    94.57% 236.215 1 - MediaWiki::main
    56.24% 140.481 1 - MediaWiki::{closure}
    56.24% 140.478 1 - OutputPage::output
    ...
    • Feb 11 2020, 17:50
    • 297 Lines
  • 100.00% 702.744 1 - main()
    97.81% 687.324 1 - MediaWiki::run
    96.71% 679.596 1 - MediaWiki::main
    87.38% 614.072 1 - MediaWiki::performRequest
    87.19% 612.692 1 - MediaWiki::performAction
    ...
    • Feb 11 2020, 17:45
    • 436 Lines
  • root@db6:/home/paladox# df -h
    Filesystem Size Used Avail Use% Mounted on
    udev 12G 0 12G 0% /dev
    tmpfs 2.3G 25M 2.3G 2% /run
    /dev/sda1 637G 2.9G 602G 1% /
    ...
    • Feb 10 2020, 14:08
    • 10 Lines
  • /usr/bin/ssh -v -e none -T -o BatchMode=yes cloud2.miraheze.org /usr/sbin/qm vncproxy 104
    OpenSSH_7.9p1 Debian-10+deb10u2, OpenSSL 1.1.1d 10 Sep 2019
    debug1: Reading configuration data /root/.ssh/config
    debug1: Reading configuration data /etc/ssh/ssh_config
    debug1: /etc/ssh/ssh_config line 19: Applying options for *
    ...
    • Feb 9 2020, 23:33
    • 30 Lines
  • Creating a cluster:
    1. Run the following `ssh -L 8006:127.0.0.1:8006 <user>@<cloud_host>.miraheze.org`
    2. Go to https://localhost:8006
    3. Enter login details, click on “Datacenter” then “Cluster”.
    ...
    • Feb 9 2020, 20:47
    • 15 Lines
  • Creating a cluster:
    1. Run the following `ssh -L 8006:127.0.0.1:8006 <user>@<cloud_host>.miraheze.org`
    2. Go to https://localhost:8006
    3. Enter login details, click on “Datacenter” then “Cluster”.
    ...
    • Feb 8 2020, 20:23
    • 15 Lines
  • IPV6 setup:
    1. Go to https://ca.ovh.com/manager/#/configuration/ip?tab=ip
    2. Select the host you want to configure the ipv6 address for, from the dropdown.
    3. You should see a ipv6 looking address in the list
    4. Click on it to expand the list
    ...
    • Feb 7 2020, 18:03
    • 131 Lines
    • Plain Text
  • iface vmbr0 inet6 static
    address 2001:41d0:800:1056::2
    netmask 64
    post-up /sbin/ip -f inet6 route add 2001:41D0:800:10FF:FF:FF:FF:FF dev vmbr0
    post-up /sbin/ip -f inet6 route add default via 2001:41D0:800:10FF:FF:FF:FF:FF
    ...
    • Feb 7 2020, 17:18
    • 7 Lines
  • # This file describes the network interfaces available on your system
    # and how to activate them. For more information, see interfaces(5).
    # The loopback network interface
    auto lo
    ...
    • Feb 7 2020, 16:12
    • 38 Lines
  • allow-hotplug eth0
    iface eth0 inet dhcp
    iface eth0 inet6 manual
    pre-up sleep 5
    up dhclient -6 -nw -v eth0
    ...
    • Feb 3 2020, 23:48
    • 18 Lines
  • allow-hotplug eth0
    #iface eth0 inet dhcp
    iface eth0 inet manual
    iface eth0 inet6 manual
    pre-up sleep 5
    ...
    • Feb 3 2020, 23:45
    • 17 Lines
  • cloud1:
    cp6
    db6
    gluster1
    jobrunner1
    ...
    • Feb 3 2020, 15:42
    • 20 Lines
    • Plain Text
  • 2020-01-31 20:00:56 test1.miraheze.org test1wiki: [287c1c1dd09621846fdd3f68] /wiki/Special:Random Wikimedia\Rdbms\DBQueryError from line 1603 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
    Query: SELECT page_title,page_namespace FROM `page` LEFT JOIN `page_props` `disambig_props` ON ((page_id = disambig_props.pp_page) AND disambig_props.pp_propname = 'disambiguation') LEFT JOIN `page_props` ON ((page_id = pp_page) AND pp_propname = 'softredirect') WHERE page_namespace IN ('4','0','250','252') AND page_is_redirect = '0' AND (page_random >= 0.540213465924) AND disambig_props.pp_page IS NULL AND pp_page IS NULL ORDER BY page_random LIMIT 1
    Function: RandomPage::selectRandomPageFromDB
    Error: 1052 Column 'pp_page' in where clause is ambiguous (mediawiki-internal-db-master.miraheze.org)
    • Jan 31 2020, 20:07
    • 4 Lines
  • /wiki/Special:Random Wikimedia\Rdbms\DBQueryError from line 1603 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
    Query: SELECT page_title,page_namespace FROM `page` LEFT JOIN `page_props` ON ((page_id = pp_page) AND pp_propname = 'softredirect') LEFT JOIN `page_props` ON ((page_id = pp_page) AND pp_propname = 'softredirect') WHERE page_namespace IN ('4','0','250','252') AND page_is_redirect = '0' AND (page_random >= 0.275534197787) AND pp_page IS NULL ORDER BY page_random LIMIT 1
    Function: RandomPage::selectRandomPageFromDB
    Error: 1066 Not unique table/alias: 'page_props' (mediawiki-internal-db-master.miraheze.org)
    • Jan 31 2020, 19:38
    • 4 Lines
  • varnish> backend.list
    200
    Backend name Admin Probe Last change
    boot.misc2 probe healthy Thu, 30 Jan 2020 20:49:05 GMT
    boot.lizardfs6 probe 5/5 good Thu, 30 Jan 2020 21:02:19 GMT
    ...
    • Jan 30 2020, 23:03
    • 14 Lines
  • varnish> backend.list
    200
    Backend name Admin Probe Last updated
    boot.misc2 probe Healthy (no probe) Sun, 19 Jan 2020 20:48:23 GMT
    boot.lizardfs6 probe Healthy 5/5 Thu, 30 Jan 2020 21:02:21 GMT
    ...
    • Jan 30 2020, 23:02
    • 13 Lines
  • LIZARDFS6:
    root@lizardfs6:/home/paladox# dd if=/dev/zero of=/tmp/test1.img bs=1G count=1 oflag=dsync
    1+0 records in
    1+0 records out
    ...
    • Jan 27 2020, 22:39
    • 34 Lines
  • root@misc2:/home/paladox# ping6 2a00:d880:6:786::2
    PING 2a00:d880:6:786::2(2a00:d880:6:786::2) 56 data bytes
    64 bytes from 2a00:d880:6:786::2: icmp_seq=1 ttl=62 time=0.538 ms
    64 bytes from 2a00:d880:6:786::2: icmp_seq=2 ttl=62 time=0.674 ms
    64 bytes from 2a00:d880:6:786::2: icmp_seq=3 ttl=62 time=0.647 ms
    ...
    • Jan 22 2020, 13:49
    • 17 Lines
  • Categoría:Personas de Aguascalientes
    Categoría:Personas de Alemania
    Categoría:Personas de Andorra
    Categoría:Personas de Angola
    Categoría:Personas de Anguila
    ...
    • Jan 19 2020, 21:09
    • 166 Lines
  • Categoría:Fallecidos en 1700
    Categoría:Fallecidos en 1701
    Categoría:Fallecidos en 1702
    Categoría:Fallecidos en 1703
    Categoría:Fallecidos en 1704
    ...
    • Jan 19 2020, 17:24
    • 614 Lines
  • DROP DATABASE abortopediawiki;
    DROP DATABASE adhdwiki;
    DROP DATABASE adsnota10wiki;
    DROP DATABASE agroecowiki;
    DROP DATABASE airportexpresslinewiki;
    ...
    • Jan 11 2020, 14:58
    • 35 Lines
  • Redis page load times (10 times, under meta):
    Using hard refresh + empty cache and then another reload (also under chrome)
    * 300ms (PHP5 at test1.miraheze.org)
    * 343ms (PHP5 at test1.miraheze.org)
    ...
    • Jan 11 2020, 00:18
    • 27 Lines
  • if ( $wiki == 'default' ) {
    // If wiki is default, we mean it but we can't use RM this way
    $remoteWiki = RemoteWiki::newFromName( $wgCreateWikiGlobalWiki );
    } else {
    ...
    • Jan 3 2020, 21:17
    • 11 Lines
  • Step 1:
    For the first step this is quite important, you need to remove `127.0.1.1` from /etc/hosts.
    You also then need to add <main_ip> cloud[num].miraheze.org cloud[num].
    ...
    • Dec 26 2019, 20:02
    • 87 Lines
  • /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sqlite.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql
    ...
    • Dec 21 2019, 16:23
    • 436 Lines
  • /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sqlite.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql
    ...
    • Dec 21 2019, 16:19
    • 451 Lines
  • MediaWiki update:
    During upgrade window:
    /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/sql.php /srv/mediawiki/w/maintenance/archives/patch-rename-mysql-user_newtalk-indexes.sql
    ...
    • Dec 21 2019, 15:58
    • 40 Lines
  • [22-Nov-2019 18:18:13 UTC] {"code":0,"reason":"","headers":{"server":"nginx\/1.16.1","date":"Fri, 22 Nov 2019 18:18:13 GMT","content-type":"text\/html; charset=utf-8; profile=\"https:\/\/www.mediawiki.org\/wiki\/Specs\/HTML\/2.0.0\"","content-length":"25495","x-powered-by":"Express","access-control-allow-origin":"*","cache-control":"private,no-cache,s-maxage=0","content-revision-id":"89991","content-language":"en","vary":"Accept, Accept-Encoding","etag":"W\/\"6397-Uu3bqrLulNLVITCjLJwnfpwc7hc\"","strict-transport-security":"max-age=15768000; includeSubDomains; preload"},"body":"<!DOCTYPE html>\n<html prefix=\"dc: http:\/\/purl.org\/dc\/terms\/ mw: http:\/\/mediawiki.org\/rdf\/\" about=\"https:\/\/meta.miraheze.org\/wiki\/Special:Redirect\/revision\/89991\"><head prefix=\"mwr: https:\/\/meta.miraheze.org\/wiki\/Special:Redirect\/\"><meta charset=\"utf-8\"\/><meta property=\"mw:pageNamespace\" content=\"0\"\/><meta property=\"mw:pageId\" content=\"28\"\/><link rel=\"dc:replaces\" resource=\"mwr...
    • Nov 22 2019, 20:46
    • 1 Line
  • root@lizardfs6:/mnt/mediawiki-static-new# fio --randrepeat=1 --ioengine=libaio --direct=1 --gtod_reduce=1 --name=test --filename=random_read_write.fio --bs=4k --iodepth=64 --size=100M --readwrite=randrw --rwmixread=75
    test: (g=0): rw=randrw, bs=(R) 4096B-4096B, (W) 4096B-4096B, (T) 4096B-4096B, ioengine=libaio, iodepth=64
    fio-3.12
    Starting 1 process
    test: Laying out IO file (1 file / 100MiB)
    ...
    • Nov 13 2019, 00:18
    • 23 Lines
  • root@lizardfs6:/mnt/mediawiki-static# fio --randrepeat=1 --ioengine=libaio --direct=1 --gtod_reduce=1 --name=test --filename=random_read_write.fio --bs=4k --iodepth=64 --size=100M --readwrite=randrw --rwmixread=75
    test: (g=0): rw=randrw, bs=(R) 4096B-4096B, (W) 4096B-4096B, (T) 4096B-4096B, ioengine=libaio, iodepth=64
    fio-3.12
    Starting 1 process
    test: Laying out IO file (1 file / 100MiB)
    ...
    • Nov 13 2019, 00:11
    • 23 Lines
  • DROP DATABASE 99pdwikiwiki;
    DROP DATABASE addicteddadswiki;
    DROP DATABASE administrationatxingxiwiki;
    DROP DATABASE aegiswiki;
    DROP DATABASE aetronomiconwiki;
    ...
    • Nov 11 2019, 08:25
    • 113 Lines
  • 100.00% 369.829 1 - main()
    90.12% 333.274 1 - MediaWiki::run
    89.91% 332.497 1 - MediaWiki::main
    55.88% 206.646 1 - MediaWiki::{closure}
    55.88% 206.642 1 - OutputPage::output
    ...
    • Oct 29 2019, 22:00
    • 103 Lines
  • [29-Sep-2019 22:36:01] [pool www] pid 12288
    script_filename = /srv/mediawiki/w/index.php
    [0x00007fc3ca61e330] is_file() /srv/mediawiki/w/includes/libs/filebackend/FSFileBackend.php:563
    [0x00007fc3ca61e270] doGetFileStat() /srv/mediawiki/w/includes/libs/filebackend/FileBackendStore.php:662
    [0x00007fc3ca61e1a0] getFileStat() /srv/mediawiki/w/includes/libs/filebackend/FileBackendStore.php:604
    ...
    • Sep 29 2019, 22:47
    • 22 Lines
  • Template:Infobox_project
    Template:Collapsed_infobox_section_end
    Template:Collapsed_infobox_section_begin
    Template:Infobox3cols
    Template:Infobox_exoskeleton
    ...
    • Sep 20 2019, 22:07
    • 1,999 Lines
  • Module:Anchor
    Module:Arguments
    Module:Arguments/doc
    Module:Authority control
    Module:Authority control/doc
    ...
    • Sep 18 2019, 22:34
    • 117 Lines
  • DROP DATABASE agoldenbraidwiki;
    DROP DATABASE animatedfemalemusclewiki;
    DROP DATABASE anotheredentwwiki;
    DROP DATABASE bikepedbuspdxwiki;
    DROP DATABASE blobcatwiki;
    ...
    • Sep 18 2019, 21:03
    • 47 Lines
  • addicteddadswiki
    agoldenbraidwiki
    aimuviwiki
    alcideswiki
    amkt20wiki
    ...
    • Sep 18 2019, 20:39
    • 140 Lines
  • +---------------------------------+
    | wiki_dbname |
    +---------------------------------+
    | abysmalrobloxgameswiki |
    | alduriawiki |
    ...
    • Sep 11 2019, 07:08
    • 144 Lines
  • ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQDEnUGYdeuyt6ECHwNvbeSvgjT8wyHmppzMqAtdm6SczfhFENTrnJ721ap9NVm9UbuF/VUQxuy5HErU4s+Z+QCYFELPcE4pc3MJ066rIkNLgXBFlqENQgLUbUCd+9CfZZbtW1LeTnH1ZvrPDdvNgeypHysSUXuS2Wy5mGF59zeVrTlGiS4QQwRio1YagyedNMoWXj8jLEqq/ZAUqKknq3ScrlqKZFJMMxHLQ8vcCuIxM6sMelX5KMGp293K8Ur7KebPJMO+Zec9wzEP51SuuEdayQKRjmBmXsgdbAsF7WtwEb/WRQpiYwQY6dFiAMC2E+B8DFJXAmRk/DBkjxOPFqEWqRjZ45YChphQaeMJGCoh+xKFprIFwmjwKFgcXSc9U7MuzE9iD9TKp200peAHUlk2Ku6US0WpLHVVEU8g+BcZqIzS+7nwd6EwTpheuAKfEEyaSbmDP5QUtp6eTvGiNihduq97+ncyzH31UG5bcBFQ0L/Lz6i+4htGvSMvma/2bR5uxFOu4ePnxrKuZw07SmZaxnx0sJBWE28ivm5ollEn2rkK9qU9qYntf3fS2x3jiJ879VD6uN40GL1ToHTXWkEqBJPG3pfoCax5ydweHLBldAZsxHN222Z8UEZPBgrzv/jczTN/cjg5toBpkP500zrkbF8/iN88ZJ9UPPDsMztQGQ== samuelkirwin@Samuels-Air
    • Sep 9 2019, 17:18
    • 1 Line
  • Function: User::saveSettings
    Error: 1048 Column 'user_email' cannot be null (mediawiki-internal-db-master.miraheze.org)
    #0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
    #1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
    ...
    • Aug 30 2019, 23:06
    • 18 Lines
  • #! /bin/bash
    # Miraheze server installation script. This script installs the mandatory
    # software to behave as a puppet agent.
    # See: https://meta.miraheze.org/wiki/Tech:Puppet
    ...
    • Aug 17 2019, 14:57
    • 27 Lines
  • https://phabricator.wikimedia.org/T223824
    • Aug 12 2019, 19:22
    • 1 Line
  • 1.7G 0
    1.7G 1
    1.6G 2
    1.7G 3
    1.6G 4
    ...
    • Aug 3 2019, 22:50
    • 24 Lines
  • script_filename = /srv/matomo/piwik.php
    [0x00007fb4c4e1dea0] execute() /srv/matomo/core/Tracker/Db/Pdo/Mysql.php:231
    [0x00007fb4c4e1dda0] query() /srv/matomo/core/Tracker/Db/Pdo/Mysql.php:198
    [0x00007fb4c4e1dce0] fetch() /srv/matomo/core/Tracker/Model.php:410
    [0x00007fb4c4e1dc00] fetchVisitor() /srv/matomo/core/Tracker/Model.php:392
    ...
    • Jul 22 2019, 16:38
    • 18 Lines
  • apt-get install ca-certificates
    apt-get install sudo
    sudo apt-get install lsb-release
    ...
    • Jul 17 2019, 22:02
    • 25 Lines
  • root@test1:/srv/mediawiki/w/extensions/MirahezeMagic/maintenance# sudo -u www-data php populateWikibaseSitesTable.php --wiki=test1wiki
    [34db20f4e14fe6d068dd8501] [no req] Wikimedia\Rdbms\DBQueryError from line 1587 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
    Query: INSERT INTO `sites` (site_global_key,site_type,site_group,site_source,site_language,site_protocol,site_domain,site_data,site_forward,site_config) VALUES ('designingforfinancialserviceswiki','mediawiki','en','local','2025298179en','','gro.ezeharim.secivreslaicnanifrofgningised.','a:1:{s:5:\"paths\";a:2:{s:9:\"file_path\";s:49:\"//designingforfinancialservices.miraheze.org/w/$1\";s:9:\"page_path\";s:52:\"//designingforfinancialservices.miraheze.org/wiki/$1\";}}','0','a:0:{}')
    Function: DBSiteStore::saveSites
    Error: 1406 Data too long for column 'site_global_key' at row 1 (mediawiki-internal-db-master.miraheze....
    • Jul 15 2019, 17:54
    • 5 Lines
  • absolutetruthwiki
    absurdopediawiki
    adrithiachronicleswiki
    aerowiki
    agilebookwiki
    ...
    • Jul 13 2019, 19:46
    • 116 Lines
  • cat varnish*.log | cut -d '"' -f3 | cut -d ' ' -f2 | sort | uniq -c | sort -rn
    2295348 200
    35449 304
    29314 404
    27505 204
    ...
    • Jun 27 2019, 22:53
    • 18 Lines
  • cat access.log | cut -d '"' -f3 | cut -d ' ' -f2 | sort | uniq -c | sort -rn
    692843 200
    16998 404
    13589 204
    12673 302
    ...
    • Jun 27 2019, 22:39
    • 15 Lines
  • /**
    * Gets basic information on the calling user, e.g name, username, email.
    * Also gets basic CentralAuth data if installed.
    * @param User $user
    * @return array
    ...
    • Jun 20 2019, 21:45
    • 38 Lines
  • array(2) {
    ["autoconfirmed"]=>
    array(3) {
    [0]=>
    string(1) "&"
    ...
    • Jun 16 2019, 20:43
    • 48 Lines
  • Jun 8 17:10:58 misc4 parsoid[4871]: {"name":"parsoid","hostname":"misc4","pid":4881,"level":60,"logType":"fatal/request","wiki":"wiki$562","title":"Main_Page","oldId":null,"reqId":null,"userAgent":"VisualEditor-MediaWiki/1.33.0-rc.0","msg":"API response Error for TemplateRequest: request=; error={\"code\":\"internal_api_error_Error\",\"info\":\"[6eb70c61c47d393206ca7ece] Caught exception of type Error\",\"errorclass\":\"Error\"}","stack":"Error: API response Error for TemplateRequest: request=; error={\"code\":\"internal_api_error_Error\",\"info\":\"[6eb70c61c47d393206ca7ece] Caught exception of type Error\",\"errorclass\":\"Error\"}\n at TemplateRequest.ApiRequest._errorObj (/srv/parsoid/lib/mw/ApiRequest.js:345:9)\n at TemplateRequest._handleJSON (/srv/parsoid/lib/mw/ApiRequest.js:557:16)\n at TemplateRequest.ApiRequest._logWarningsAndHandleJSON (/srv/parsoid/lib/mw/ApiRequest.js:450:7)\n at TemplateRequest.ApiRequest._handleBody (/srv/parsoid/lib/mw/ApiRequest.js:486:7)\n at TemplateRequest....
    • Jun 8 2019, 17:11
    • 1 Line