B!B!E! Tech Meeting 2022.10.20
Agenda
- bikebike.org SMTP & spam
- What do we want to talk about at B!B!E!?
- Jitsi simultaneous interpretation update
Start request GET /wiki/index.php?direction=next&oldid=49331&title=B%21B%21E%21_Tech_Meeting_2022.10.20
IP: 172.18.0.2
HTTP HEADERS:
COOKIE: bikebike_mw__session=s4f0hkqu6vl32p62u2ftsikt1m749ec2
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?direction=next&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.140
X-REAL-IP: 216.73.216.140
CONNECTION: close
HOST: wiki2.bikelover.org
CONTENT-LENGTH:
CONTENT-TYPE:
(end headers)[session] SessionManager using store APCUBagOStuff[localisation] LocalisationCache using store LCStoreCDB[session] Session "s4f0hkqu6vl32p62u2ftsikt1m749ec2" requested without UserID cookie[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0s] 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] 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 [0s] 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 [0s] 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[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 ASC,rev_id ASC LIMIT 1[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 = 49332 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 rcache[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0s] 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 = 49332 LIMIT 1Unstubbing $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 [0.001s] 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 < '20221019232025' OR (rev_timestamp = '20221019232025' AND rev_id < 49332 )) ORDER BY rev_timestamp DESC,rev_id DESC LIMIT 1[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0s] 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[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0s] database_staging: SET group_concat_max_len = 262144, `sql_mode` = ''[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: opened new connection for localAutoCommit/0[DBQuery] SqlBagOStuff::fetchBlobs [0.001s] database_staging: SELECT keyname,value,exptime FROM `mw_objectcache` WHERE keyname = 'bikebike-mw_:pcache:idoptions:12277' AND (exptime >= '20260228142141')[ParserCache] ParserOutput metadata cache missArticle::generateContentOutput: doing uncached parse[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for localAutoCommit/0[DBQuery] SqlBagOStuff::fetchBlobs [0s] database_staging: SELECT keyname,value,exptime FROM `mw_objectcache` WHERE keyname = 'bikebike-mw_:pcache:idoptions:12277' AND (exptime >= '20260228142141')[ParserCache] ParserOutput metadata cache miss[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 = 49332[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 = 49055[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for localAutoCommit/0[DBQuery] SqlBagOStuff::modifyTableSpecificBlobsForSet [0.004s] database_staging: REPLACE INTO `mw_objectcache` (keyname,value,exptime) VALUES ('bikebike-mw_:pcache:idhash:12277-0!canonical','�Vmo�6��+����Hr�4��au��E^��]?4E�Hg�3E\n$e\'���w�^������������=�����I7�/t�O�ƴ?��M�$I�3�{���s`����)�)����L�==+?�n�Y?[Őrk �\\I��� ������2�dN��,�3��Q� �N�`�\n��p#�v���!&v/�8��~�����u�����dD~eY��`\"Y�������͙%�\"+ +&-��X&��=������1���ɉ�Y!,��\nC���s\r��}�y�,�)�Ċ�������{�������� f�4�j<�)O�U�\ZO��P��K���m���1.����XU�e����sH8�՚����2��aZ����g.`�L\'���m�2_<!����u����_�\r�\r��e�h<e�@�^���oԟL���k �mh!�B]����5�����������_�f�ya/����ƴD��Q����P���K@~����h�ytr��R�8�E��\Z-!��L��j��J�,҃+�CU��u����lAM����A�2�̕^/�鍴�A�F7������\nAԉ&�cQ�8t�� <����C�d��no���*�.ё�<y.���I��?g���&JCl���m�T1�@\"p��^2�����W����;ȕ�u,�Lڛ� �\0�Ex� ��3�����hǝ�Kn��T��������~�\0����O�LD�`���������$�E;x[)��Ud ��}h�V\n���y��9J�0-�WV�\n��F}�.�����:�[��H�[o�֑>�W�Ք;�}���R���������m��y��\',��z�QL�£(<r���Zw8��� ��hG���(��ܖ�궵�e�G�^xo��G��Bx�K&\nDD���Z������9A3��6��/��N�����J�^a�^N����,6`���k(��\"y�*���S�l��=A��n�A���l0�h̖�b_�7�6��_������<������C�{g��93s\\,:9i�� �JbC���M�$�v�ީ���7O��i��u0�[x����xɽx��fNNp�^�v���k9���ۉzG��髻��QH;�ku�7K��]�Ս���f���c�:Y7M��a��M�c�lm�,Xӧ�s��M���,�)�e!Ė}�l�ӯ�\Z�]�צQ�s:�x��O�@��~�,��sΗ���)��������4��pG����5�����ay��^���r����������Rl9�{����ؔ%k �vS��.3��dmJ�qmpPJ��,A��������[osf������^���Ĭ�(�Vk�����p�)��RZo��w��p��l������(W/�2�~��','20260314142141')[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for localAutoCommit/0[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for localAutoCommit/0[DBQuery] SqlBagOStuff::modifyTableSpecificBlobsForSet [0.002s] database_staging: REPLACE INTO `mw_objectcache` (keyname,value,exptime) VALUES ('bikebike-mw_:pcache:idoptions:12277',']��N�0�D�e�9$N�Qs� U*4�p���M-%��CJ��)m��Vz��;C</K����#|\'Tk��`���z1-���7����̴�_������G�\'+�z@�w��kѯ�i�h�7���B�3�����u�5�ꂔ&���g�b|�#:� o�F��ҍ��ECz�S?�����t���?����D?�@%��c����3�.�4=�F�1-���)cwY�\"���/��b��,���[�Dǯ����','20260314142141')[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for localAutoCommit/0[ParserCache] Saved in parser cache[DBQuery] MediaWiki::preOutputCommit [0s] database_staging: COMMITMediaWiki::preOutputCommit: primary transaction round committed[DeferredUpdates] DeferredUpdates::run: started MWCallableUpdate_WikiPage->doViewUpdates #708[DeferredUpdates] DeferredUpdates::run: ended MWCallableUpdate_WikiPage->doViewUpdates #708, processing time: 0.00011014938354492MediaWiki::preOutputCommit: pre-send deferred updates completedMediaWiki::preOutputCommit: session changes committed[DBReplication] Wikimedia\Rdbms\ChronologyProtector::stageSessionReplicationPosition: DEFAULT (database_staging) has no replication[DBReplication] Wikimedia\Rdbms\ChronologyProtector::persistSessionReplicationPositions: saved primary positions/timestamp for DB cluster(s) DEFAULT[DBReplication] Wikimedia\Rdbms\LBFactory::shutdown: finished ChronologyProtector shutdown[DBReplication] LBFactory shutdown completed[cookie] setcookie: "cpPosIndex", "1@1772288501#00aba87f0d2b34d22fa7da60bd405aff", "1772288511", "/", "", "1", "1", ""OutputPage::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 20260228142141 vs 20251210094819[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] LinkBatch::doQuery (for Skin::preloadExistence) [0.001s] 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