sorry, I don't know what the problem is Greg Rundlett https://eQuality-Tech.com https://freephile.org
On Fri, Apr 19, 2019 at 4:17 PM Mike Brown <[email protected]> wrote: > On Fri, Apr 19, 2019 at 07:31:42AM -0400, Greg Rundlett (freephile) wrote: > > Is the PCRE version 8+? > > Yes, it's 8.43, as I mentioned. > > Is there an easy way to figure out where in the MediaWiki code the queries > are running? Maybe there will be a clue there. > > 2019-04-19T20:00:41.166828Z 2501 Connect offset@localhost on > OffsetDB using Socket > 2019-04-19T20:00:41.168849Z 2501 Init DB offsetdb > 2019-04-19T20:00:41.170499Z 2501 Query SET group_concat_max_len = > 262144, sql_mode = '' > 2019-04-19T20:00:41.181845Z 2501 Query BEGIN /* > Wikimedia\Rdbms\Database::query (User::loadFromDatabase) */ > 2019-04-19T20:00:41.184828Z 2501 Query SELECT /* > User::loadFromDatabase */ > user_id,user_name,user_real_name,user_email,user_touched,user_token,user_email_authenticated,user_email_token,user_email_token_expires,user_registration,user_editcount > FROM `mw_user` WHERE user_id = '2' LIMIT 1 > 2019-04-19T20:00:41.199361Z 2501 Query SELECT /* > UserGroupMembership::getMembershipsForUser */ ug_user,ug_group,ug_expiry > FROM `mw_user_groups` WHERE ug_user = '2' > 2019-04-19T20:00:41.210905Z 2501 Query SELECT /* > User::loadOptions */ up_property,up_value FROM `mw_user_properties` > WHERE up_user = '2' > 2019-04-19T20:00:41.227391Z 2502 Connect offset@localhost on > OffsetDB using Socket > 2019-04-19T20:00:41.229184Z 2502 Init DB offsetdb > 2019-04-19T20:00:41.230537Z 2502 Query SET group_concat_max_len = > 262144, sql_mode = '' > 2019-04-19T20:00:41.234579Z 2502 Query SHOW /* > Wikimedia\Rdbms\DatabaseMysqlBase::serverIsReadOnly */ GLOBAL VARIABLES > LIKE 'read_only' > 2019-04-19T20:00:41.258097Z 2502 Query SELECT /* > SqlBagOStuff::getMulti */ keyname,value,exptime FROM `mw_objectcache` > WHERE keyname = 'OffsetDB-mw_:MWSession:pbefr5e4bhrj5ek7lenuqq4vqv1bjg98' > 2019-04-19T20:00:41.303730Z 2501 Query SELECT /* LCStoreDB::get > */ lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = > 'deps' LIMIT 1 > 2019-04-19T20:00:41.312750Z 2501 Query SELECT /* LCStoreDB::get > */ lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = > 'list' LIMIT 1 > 2019-04-19T20:00:41.366572Z 2501 Query SELECT /* LCStoreDB::get > */ lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = > 'preload' LIMIT 1 > 2019-04-19T20:00:41.380583Z 2501 Query SELECT /* LCStoreDB::get > */ lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = > 'preload' LIMIT 1 > 2019-04-19T20:00:41.388089Z 2501 Query SELECT /* LCStoreDB::get > */ lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = > 'messages:title-invalid-empty' LIMIT 1 > 2019-04-19T20:00:41.408978Z 2501 Query SELECT /* Block::newLoad > */ > 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_reason > AS `ipb_reason_text`,NULL AS `ipb_reason_data`,NULL AS > `ipb_reason_cid`,ipb_by,ipb_by_text,NULL AS `ipb_by_actor` FROM > `mw_ipblocks` WHERE ipb_address = 'Mjb' > 2019-04-19T20:00:41.425947Z 2501 Query SELECT /* > WikiPage::pageData */ > page_id,page_namespace,page_title,page_restrictions,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 = '2' AND page_title = > 'Mjb/FreeBSD_on_BeagleBone_Black/Additional_software' LIMIT 1 > 2019-04-19T20:00:41.433949Z 2501 Query SELECT /* LCStoreDB::get > */ lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = > 'namespaceGenderAliases' LIMIT 1 > 2019-04-19T20:00:41.442378Z 2501 Query SELECT /* > Title::loadRestrictions */ pr_type,pr_expiry,pr_level,pr_cascade FROM > `mw_page_restrictions` WHERE pr_page = '1206' > 2019-04-19T20:00:41.464948Z 2501 Query SELECT /* > MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds */ > rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_comment > AS `rev_comment_text`,NULL AS `rev_comment_data`,NULL AS > `rev_comment_cid`,rev_user,rev_user_text,NULL AS > `rev_actor`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name > FROM `mw_revision` INNER JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN > `mw_user` ON ((rev_user != 0) AND (user_id = rev_user)) WHERE rev_page = > '1206' AND page_id = '1206' AND rev_id = '3940' LIMIT 1 > 2019-04-19T20:00:41.480834Z 2501 Query SELECT /* > MediaWiki\Revision\RevisionStore::loadSlotRecords */ > slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model > FROM `mw_slots` INNER JOIN `mw_content` ON ((slot_content_id = > content_id)) WHERE slot_revision_id = '3940' > 2019-04-19T20:00:41.488519Z 2501 Query SELECT /* > MediaWiki\Storage\NameTableStore::loadTable */ role_id AS `id`,role_name > AS `name` FROM `mw_slot_roles` ORDER BY id > 2019-04-19T20:00:41.495793Z 2501 Query SELECT /* > MediaWiki\Storage\NameTableStore::loadTable */ model_id AS > `id`,model_name AS `name` FROM `mw_content_models` ORDER BY id > 2019-04-19T20:00:41.531263Z 2501 Query SELECT /* > Title::getCascadeProtectionSources */ > pr_page,page_namespace,page_title,pr_expiry,pr_type,pr_level FROM > `mw_templatelinks`,`mw_page_restrictions`,`mw_page` WHERE tl_namespace = > '2' AND tl_title = 'Mjb/FreeBSD_on_BeagleBone_Black/Additional_software' > AND (tl_from=pr_page) AND pr_cascade = '1' AND (page_id=pr_page) > 2019-04-19T20:00:41.546515Z 2501 Query SELECT /* Block::newLoad > */ > 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_reason > AS `ipb_reason_text`,NULL AS `ipb_reason_data`,NULL AS > `ipb_reason_cid`,ipb_by,ipb_by_text,NULL AS `ipb_by_actor` FROM > `mw_ipblocks` WHERE ipb_address = 'Mjb' > 2019-04-19T20:00:41.557840Z 2501 Query SELECT /* > MediaWiki\Storage\SqlBlobStore::fetchBlob */ old_text,old_flags FROM > `mw_text` WHERE old_id = '3895' LIMIT 1 > 2019-04-19T20:00:41.574169Z 2501 Query SELECT /* > WikiPage::pageData */ > page_id,page_namespace,page_title,page_restrictions,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 = '2' AND page_title = > 'Mjb/FreeBSD_on_BeagleBone_Black/Additional_software' LIMIT 1 > 2019-04-19T20:00:41.583145Z 2501 Query SELECT /* > WikiPage::pageData */ > page_id,page_namespace,page_title,page_restrictions,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 = '2' AND page_title = > 'Mjb/FreeBSD_on_BeagleBone_Black/Additional_software' LIMIT 1 > 2019-04-19T20:00:41.594411Z 2501 Query SELECT /* > MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds */ > rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_comment > AS `rev_comment_text`,NULL AS `rev_comment_data`,NULL AS > `rev_comment_cid`,rev_user,rev_user_text,NULL AS > `rev_actor`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name > FROM `mw_revision` INNER JOIN `mw_page` ON ((page_id = rev_page)) LEFT JOIN > `mw_user` ON ((rev_user != 0) AND (user_id = rev_user)) WHERE rev_page = > '1206' AND page_id = '1206' AND rev_id = '3940' LIMIT 1 > 2019-04-19T20:00:41.606978Z 2501 Query SELECT /* > MediaWiki\Revision\RevisionStore::loadSlotRecords */ > slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model > FROM `mw_slots` INNER JOIN `mw_content` ON ((slot_content_id = > content_id)) WHERE slot_revision_id = '3940' > 2019-04-19T20:00:41.625565Z 2501 Query SELECT /* LCStoreDB::get > */ lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = > 'magicWords' LIMIT 1 > > This is the point where it crashed. If it hadn't crashed, the next line > would > have looked like this (with different datestamp & PID of course): > > 2019-04-19T19:56:42.461414Z 2479 Query SELECT /* > WikiPage::pageData */ > page_id,page_namespace,page_title,page_restrictions,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 = '2' AND page_title = > 'Mjb/FreeBSD_on_BeagleBone_Black/Additional_software' LIMIT 1 > > _______________________________________________ > MediaWiki-l mailing list > To unsubscribe, go to: > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
