[prev in list] [next in list] [prev in thread] [next in thread]
List: mediawiki-l
Subject: Re: [MediaWiki-l] php-fpm worker crashes when editing article
From: "Greg Rundlett (freephile)" <greg () freephile ! com>
Date: 2019-04-19 22:15:17
Message-ID: CANaytccLOKmcWgpmVNJe_N9P8sTOM77apRgjS_yYEaH7=bVuZw () mail ! gmail ! com
[Download RAW message or body]
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_authe \
> nticated,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_enabl \
> e_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_enabl \
> e_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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic