Jump to content

Bike Collectives Wiki

Some Firefox users may need to log in more than once to log in. It's a known Firefox bug. Check "keep me logged in," it might help.

Es posible que algunxs usuarixs de Firefox tengan que conectarse más de una vez para iniciar sesión. Es un error conocido de Firefox. Marca "keep me logged in" (mantenerme conectado), puede ayudar.

Toggle the table of contents

Tech meeting 2022.07.28: Difference between revisions

From Bike Collectives Wiki

Revision as of 21:23, 25 July 2022

Agenda

Assess tech priorities

some possible priorities

can we get a bug tracker please?

bikecollectives.org

replace background image at bottom of bikecollectives.org
integrate with bikebike.org

wiki

get the wiki running at a usable speed (where it doesn't sometimes take several tries to save edits)

* make it so people can use the visual editor.

Make it easy to add an org

bikebike.org

replace bikebike.org software
contact form

hosting

We need to switch away from shared hosting to a high-availability VPS for bikecollectives.org. - i wrote a whole thing about this in the OCF tech donation page. We can worry about it when we have $$ i guess

Retrieved from "https://wiki2.bikelover.org/wiki/index.php?title=Tech_meeting_2022.07.28&oldid=49113"

Debug data:

Start request GET /wiki/index.php?diff=49113&oldid=prev&title=Tech_meeting_2022.07.28 IP: 172.18.0.2 HTTP HEADERS: COOKIE: bikebike_mw__session=feb41gojltj0iteq370p920qms5qrvmi 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?diff=49113&oldid=prev&title=Tech_meeting_2022.07.28 X-FORWARDED-PORT: 443 X-FORWARDED-SSL: on X-FORWARDED-PROTO: https X-FORWARDED-FOR: 216.73.216.164 X-REAL-IP: 216.73.216.164 CONNECTION: close HOST: wiki2.bikelover.org CONTENT-LENGTH: CONTENT-TYPE: (end headers)
[session] SessionManager using store APCUBagOStuff
[localisation] LocalisationCache using store LCStoreCDB
[session] Session "feb41gojltj0iteq370p920qms5qrvmi" 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] found position data with index 2
[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.002s] 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 = 49113 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 = 'Tech_meeting_2022.07.28' LIMIT 1
[ContentHandler] Registered handler for wikitext: WikitextContentHandler
Article::view: showing diff page
[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 = 49121
DifferenceEngine old '0' new '49113' rcid '0'
[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 = 49113 LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::getRelativeRevision [0s] database_staging: SELECT rev_id FROM `mw_revision` IGNORE INDEX (rev_timestamp) WHERE rev_page = 12252 AND (rev_timestamp < '20220725212326' OR (rev_timestamp = '20220725212326' AND rev_id < 49113 )) 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 = 49111 LIMIT 1
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] DifferenceEngine::loadRevisionData [0s] database_staging: SELECT ct_tag_id AS `value` FROM `mw_change_tag` WHERE ct_rev_id = 49111
[DBQuery] DifferenceEngine::loadRevisionData [0.001s] database_staging: SELECT ct_tag_id AS `value` FROM `mw_change_tag` WHERE ct_rev_id = 49113
[MessageCache] MessageCache using store APCUBagOStuff
[MessageCache] MessageCache::loadUnguarded: Loading en... got from local cache
ParserFactory: using default preprocessor
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::getRelativeRevision [0s] database_staging: SELECT rev_id FROM `mw_revision` IGNORE INDEX (rev_timestamp) WHERE rev_page = 12252 AND (rev_timestamp < '20220725212203' OR (rev_timestamp = '20220725212203' AND rev_id < 49111 )) 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 = 49110 LIMIT 1
Unstubbing $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 = 'Angel' 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 = 'Angel' LIMIT 1
[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 = 49113
[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 = 49111
DifferenceEngine old '0' new '0' rcid '0'
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: reused a connection for local/0
[DBQuery] MediaWiki\Revision\RevisionStore::getRevisionIdsBetween [0.001s] database_staging: SELECT rev_id AS `value` FROM `mw_revision` WHERE rev_page = 12252 AND ((rev_deleted & 1) = 0) AND ((rev_timestamp = '20220725212203' AND rev_id > 49111) OR rev_timestamp > '20220725212203') AND ((rev_timestamp = '20220725212326' AND rev_id < 49113) OR rev_timestamp < '20220725212326') LIMIT 1001
[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 page_namespace = 0 AND page_title = 'Tech_meeting_2022.07.28' AND rev_id = 49113 LIMIT 1
[ParserCache] Creating ParserCache instance for pcache
[ParserCache] Creating RevisionOutputCache instance for rcache
[ParserCache] old-revision cache hit
ContextSource::getContext (MediaWiki\Skins\Vector\SkinVector22): called and $context is null. Using RequestContext::getMain()
[DBQuery] MediaWiki::preOutputCommit [0s] database_staging: COMMIT
MediaWiki::preOutputCommit: primary transaction round committed
[DeferredUpdates] DeferredUpdates::run: started MWCallableUpdate_WikiPage->doViewUpdates #659
[DeferredUpdates] DeferredUpdates::run: ended MWCallableUpdate_WikiPage->doViewUpdates #659, processing time: 0.00014901161193848
MediaWiki::preOutputCommit: pre-send deferred updates completed
MediaWiki::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 completed
OutputPage::haveCacheVaryCookies: found bikebike_mw__session
User::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/0
MediaWiki\Block\DatabaseBlock::isExpired checking current 20251214063011 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 = 'Tech_meeting_2022.07.28')
[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

Revision as of 21:22, 25 July 2022 (view source) Angel (talk \| contribs) m (→‎Agenda) ← Older edit		Revision as of 21:23, 25 July 2022 (view source) Angel (talk \| contribs) m (→‎hosting: https://opencollective.com/bikebike-everywhere/projects/tecnologia-tech) Newer edit →
Line 20:		Line 20:

	==hosting==		==hosting==
	* We need to switch away from shared hosting to a high-availability VPS for bikecollectives.org. - i wrote a whole thing about this in the ~~ocf~~ donation page. we can worry about it when we have $$ i guess		* We need to switch away from shared hosting to a high-availability VPS for bikecollectives.org. - i wrote a whole thing about this in the [https://opencollective.com/bikebike-everywhere/projects/tecnologia-tech OCF tech donation page]. We can worry about it when we have $$ i guess