B!B!E! Tech Meeting 2022.10.20
Agenda
- bikebike.org SMTP & spam
- What do we want to talk about at B!B!E!?
Start request GET /wiki/index.php?oldid=49331&title=B%21B%21E%21_Tech_Meeting_2022.10.20
IP: 172.18.0.2
HTTP HEADERS:
COOKIE: bikebike_mw__session=hn9d42p8kvn2ps5mbpkknq6jib8kfmo2
ACCEPT-ENCODING: gzip, br, zstd, deflate
USER-AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
ACCEPT: */*
X-ORIGINAL-URI: /wiki/index.php?oldid=49331&title=B%21B%21E%21_Tech_Meeting_2022.10.20
X-FORWARDED-PORT: 443
X-FORWARDED-SSL: on
X-FORWARDED-PROTO: https
X-FORWARDED-FOR: 216.73.216.113
X-REAL-IP: 216.73.216.113
CONNECTION: close
HOST: wiki2.bikelover.org
CONTENT-LENGTH:
CONTENT-TYPE:
(end headers)[session] SessionManager using store APCUBagOStuff[localisation] LocalisationCache using store LCStoreCDB[session] Session "hn9d42p8kvn2ps5mbpkknq6jib8kfmo2" requested without UserID cookie[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0.001s] database_staging: SET group_concat_max_len = 262144, `sql_mode` = ''[DBReplication] Wikimedia\Rdbms\LBFactory::getChronologyProtector: request info {
"IPAddress": "172.18.0.2",
"UserAgent": "Mozilla\/5.0 AppleWebKit\/537.36 (KHTML, like Gecko; compatible; ClaudeBot\/1.0; +claudebot@anthropic.com)",
"ChronologyProtection": false,
"ChronologyPositionIndex": 0,
"ChronologyClientId": false
}[DBReplication] ChronologyProtector using store APCUBagOStuff[DBReplication] ChronologyProtector fetching positions for 00aba87f0d2b34d22fa7da60bd405aff[DBReplication] found position data with index 1[DBReplication] Wikimedia\Rdbms\ChronologyProtector::applySessionReplicationPosition: DEFAULT (database_staging) has no position[DBConnection] Wikimedia\Rdbms\LoadBalancer::lazyLoadReplicationPositions: executed chronology callback.[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: opened new connection for local/0[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds) [0s] database_staging: BEGIN[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0.001s] database_staging: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `mw_revision` JOIN `mw_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `mw_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `mw_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN `mw_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 49331 LIMIT 1[SQLBagOStuff] MainObjectStash using store ReplicatedBagOStuff[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] WikiPage::pageData [0.001s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `mw_page` WHERE page_namespace = 0 AND page_title = 'B!B!E!_Tech_Meeting_2022.10.20' LIMIT 1[ContentHandler] Registered handler for wikitext: WikitextContentHandler[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0.001s] database_staging: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `mw_revision` JOIN `mw_revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `mw_comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `mw_actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN `mw_user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 49331 LIMIT 1[MessageCache] MessageCache using store APCUBagOStuff[MessageCache] MessageCache::loadUnguarded: Loading en... got from local cacheParserFactory: using default preprocessorContextSource::getContext (MediaWiki\Skins\Vector\SkinVector22): called and $context is null. Using RequestContext::getMain()[ParserCache] Creating ParserCache instance for pcache[ParserCache] Creating RevisionOutputCache instance for rcacheUnstubbing $wgLang on call of $wgLang::getDatePreferenceMigrationMap from Language->internalUserTimeAndDate[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Page\PageStore::getPageByNameViaLinkCache [0s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `mw_page` WHERE page_namespace = 2 AND page_title = 'DarinWick' LIMIT 1[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Page\PageStore::getPageByNameViaLinkCache [0s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `mw_page` WHERE page_namespace = 3 AND page_title = 'DarinWick' LIMIT 1[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Revision\RevisionStore::getRelativeRevision [0.001s] database_staging: SELECT rev_id FROM `mw_revision` IGNORE INDEX (rev_timestamp) WHERE rev_page = 12277 AND (rev_timestamp < '20221019231921' OR (rev_timestamp = '20221019231921' AND rev_id < 49331 )) ORDER BY rev_timestamp DESC,rev_id DESC LIMIT 1Article::generateContentOutput: doing uncached parse[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecordsFromDb [0.001s] database_staging: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `mw_slots` JOIN `mw_content` ON ((slot_content_id = content_id)) WHERE slot_revision_id = 49331[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Storage\SqlBlobStore::fetchBlobs [0s] database_staging: SELECT old_id,old_text,old_flags FROM `mw_text` WHERE old_id = 49054[DBQuery] MediaWiki::preOutputCommit [0s] database_staging: COMMITMediaWiki::preOutputCommit: primary transaction round committed[DeferredUpdates] DeferredUpdates::run: started MWCallableUpdate_WikiPage->doViewUpdates #693[DeferredUpdates] DeferredUpdates::run: ended MWCallableUpdate_WikiPage->doViewUpdates #693, processing time: 7.5101852416992E-5MediaWiki::preOutputCommit: pre-send deferred updates completedMediaWiki::preOutputCommit: session changes committed[DBReplication] Wikimedia\Rdbms\ChronologyProtector::persistSessionReplicationPositions: no primary positions/timestamps to save[DBReplication] Wikimedia\Rdbms\LBFactory::shutdown: finished ChronologyProtector shutdown[DBReplication] LBFactory shutdown completedOutputPage::haveCacheVaryCookies: found bikebike_mw__sessionUser::getBlockedStatus: checking blocked status for 172.18.0.2[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (MediaWiki\Block\DatabaseBlock::newLoad) [0s] database_staging: BEGIN[DBQuery] MediaWiki\Block\DatabaseBlock::newLoad [0s] database_staging: SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,ipb_by_actor,ipblocks_actor.actor_user AS `ipb_by`,ipblocks_actor.actor_name AS `ipb_by_text`,comment_ipb_reason.comment_text AS `ipb_reason_text`,comment_ipb_reason.comment_data AS `ipb_reason_data`,comment_ipb_reason.comment_id AS `ipb_reason_cid` FROM `mw_ipblocks` JOIN `mw_actor` `ipblocks_actor` ON ((actor_id=ipb_by_actor)) JOIN `mw_comment` `comment_ipb_reason` ON ((comment_ipb_reason.comment_id = ipb_reason_id)) WHERE ipb_address = '172.18.0.2' OR ((ipb_range_start LIKE 'AC12%' ESCAPE '`' ) AND (ipb_range_start <= 'AC120002') AND (ipb_range_end >= 'AC120002'))[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0MediaWiki\Block\DatabaseBlock::isExpired checking current 20260214095042 vs 20251210094819[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] LinkBatch::doQuery (for Skin::preloadExistence) [0s] database_staging: SELECT page_id,page_namespace,page_title,page_is_redirect,page_is_new,page_latest,page_touched,page_len,page_content_model FROM `mw_page` WHERE (page_namespace = 1 AND page_title = 'B!B!E!_Tech_Meeting_2022.10.20')[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\User\TalkPageNotificationManager::dbCheckNewUserMessages [0s] database_staging: SELECT user_ip FROM `mw_user_newtalk` WHERE user_ip = '172.18.0.2' LIMIT 1[gitinfo] Candidate cacheFile=/var/www/html/w/gitinfo.json for /var/www/html/w[gitinfo] Cache incomplete for /var/www/html/w