On Fri, Apr 19, 2019 at 4:17 PM Mike Brown <mike(a)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