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 mike@hyperreal.org 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