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?oldid=49332&title=B%21B%21E%21_Tech_Meeting_2022.10.20
IP: 172.18.0.2
HTTP HEADERS:
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=49332&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] SessionBackend "qh4pve1nkq6s8fmqac4mfg16iutpi3nn" is unsaved, marking dirty in constructor[session] SessionBackend "qh4pve1nkq6s8fmqac4mfg16iutpi3nn" save: dataDirty=1 metaDirty=1 forcePersist=0[cookie] already deleted setcookie: "bikebike_mw__session", "", "1739526613", "/", "", "1", "1", ""[cookie] already deleted setcookie: "bikebike_mw_UserID", "", "1739526613", "/", "", "1", "1", ""[cookie] already deleted setcookie: "bikebike_mw_Token", "", "1739526613", "/", "", "1", "1", ""[cookie] already deleted setcookie: "forceHTTPS", "", "1739526613", "/", "", "", "1", ""[session] SessionBackend "qh4pve1nkq6s8fmqac4mfg16iutpi3nn" data dirty due to dirty(): MediaWiki\Session\SessionManager->getSessionForRequest/MediaWiki\Session\SessionManager->getInitialSession/MediaWiki\Session\Session->getToken/MediaWiki\Session\Session->set/MediaWiki\Session\SessionBackend->dirty[session] SessionBackend "qh4pve1nkq6s8fmqac4mfg16iutpi3nn" save: dataDirty=1 metaDirty=0 forcePersist=0[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] 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) [0.003s] database_staging: BEGIN[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0.003s] 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[SQLBagOStuff] MainObjectStash using store ReplicatedBagOStuff[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] WikiPage::pageData [0.003s] 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[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\Revision\RevisionStore::fetchRevisionRowFromConds [0.003s] 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[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 = 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.004s] 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 [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[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0.005s] database_staging: SET group_concat_max_len = 262144, `sql_mode` = ''[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: opened new 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 >= '20260214095013')[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 >= '20260214095013')[ParserCache] ParserOutput metadata cache miss[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecordsFromDb [0s] 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 [0.002s] 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.005s] database_staging: REPLACE INTO `mw_objectcache` (keyname,value,exptime) VALUES ('bikebike-mw_:pcache:idhash:12277-0!canonical','�Vmo�6��+����Hr�7��au��E����~h����6g��H�N���H��%N� HL����������Y?��3�£�1�,����3I����f���X*��;Jx��?� SvG�����-8�d��Rn\r$�+Ir6�4�p����L!Y��\0��DA�u ��貲G�p�害��1�v\'��8��~����:J���f:&��,O0�lp��h���-�%�\"k k&-��X&��=���ԕ�����ɉ�Y!,��\nC���s\r��s�y�,�%�c����5����{����������\\i��|$S�0�t5�r+��}�p�]�:�vƸDX~�b����&�?��p&�=!���ev����1�}��G.`�L\'������_>\"����}F��5_�-�gXO���xƄ����)��V2!@?m��m#�Y��F������>5�Of����b5�����{�T��7�%�Uͪ\0��Z��X����h5�]�����%�q.���4JB�p��c5�i��L�LҽK�}���M����ɂ���`փ�e2Y(������k���\ro��ë��5\ZQG���E���9���,�⨇�K�����~�5P�\\�c%x�T:p����,��3M���2=����b4������i�W�Կ8ve�~�\\i[��N����`\n0X4�:A�yD7�5�|K��S���n!�*�8D�0�ߏ=Ce,<\"�S.�Q�1���~�ZQp��{ў�����*2��?̽k�V\n�]�q�6r��`VHϬD��\'��ڸ��j��k�n�7L��z����!�r�f�q�;����_�~n�����m��y��\',Y�f�6�N�(< �zA�r�ch��@|N�`O��8�b���pG���Ƨ��vx�\"��R��᙮�(�\"����Jtp�7�Ь �5U�q�aB�t�>)��T\Z�$����=r��b���X{\r$��$/;)v�J�]r�E��W\r��\r�����M�\nR���#h���=ɚ��Y����{;[�ǹW�<]0��͢~���%L*��U��7i�$�!z��G\",�<%\'g�n����n� >pv�)��采����4:\r���3|^{-�T\Z���ߝ�Nz/��:!��_���,Yr�jV�.���M�L���dS35���ÖbO�+�F�Q��La�.��ȟ/�\Z�4���;�1�9J�\Zh�_��6u���&��~`�����f9����\Z�>��m��q�j+_Tilu�n���9j��4f����M<3�i�I���x}�%���^�l/�eũ۩Z����K6�*�ȱ-3�kd-J�qUpX2�V���7v��z�m��?��X]���^�6k�ʷj\r���x��M/*����xe�\r�Y�����O9��r�/��','20260228095013')[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.006s] database_staging: REPLACE INTO `mw_objectcache` (keyname,value,exptime) VALUES ('bikebike-mw_:pcache:idoptions:12277',']��N�0�D�e�98N��s� U*4�p�L�M-%��CJ��)m��Vz��;C\"�s����#|\'Tk��`���z9-M���o��Ax�0�iU��\n�!���>NV\Z���.�Kע_I���^oh��me��H�S��ET���R��G��E��q��(&��k�OK7*N�\r��O��S0�\\o�{}���m:I��� ���a,���D�Y�3v���cZ�猧�Vܱ4���/��E�e<���[�Dǯ����','20260228095013')[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 #581[DeferredUpdates] DeferredUpdates::run: ended MWCallableUpdate_WikiPage->doViewUpdates #581, processing time: 8.4161758422852E-5MediaWiki::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@1771062613#00aba87f0d2b34d22fa7da60bd405aff", "1771062623", "/", "", "1", "1", ""OutputPage::haveCacheVaryCookies: no cache-varying cookies found[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (LinkBatch::doQuery (for Skin::preloadExistence)) [0.003s] database_staging: BEGIN[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