https://bugzilla.wikimedia.org/show_bug.cgi?id=58157

Brad Jorsch <bjor...@wikimedia.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bjor...@wikimedia.org

--- Comment #2 from Brad Jorsch <bjor...@wikimedia.org> ---
These errors continue to occur intermittently. When they do, dberror.log logs
messages along these lines:

Thu Dec 19 15:26:13 UTC 2013    mw1169  enwiki  Connection lost and reconnected
after 59.792s, query: SELECT /* IndexPager::buildQueryInfo (contributions page
filtered for namespace or RevisionDeleted edits) Anomie */ 
rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,user_name,page_namespace,page_title,page_is_new,page_latest,page_is_redirect,page_len,(SELECT
 GROUP_CONCAT(ct_tag SEPARATOR ',')  FROM `change_tag`   WHERE ct_rev_id=rev_id
 ) AS ts_tags  FROM `revision` FORCE INDEX (user_timestamp) INNER JOIN `pa
Thu Dec 19 15:26:13 UTC 2013    mw1169  enwiki  IndexPager::buildQueryInfo
(contributions page filtered for namespace or RevisionDeleted edits)
10.64.16.144    0               SELECT 
rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,user_name,page_namespace,page_title,page_is_new,page_latest,page_is_redirect,page_len,(SELECT
 GROUP_CONCAT(ct_tag SEPARATOR ',')  FROM `change_tag`   WHERE ct_rev_id=rev_id
 ) AS ts_tags  FROM `revision` FORCE INDEX (user_timestamp) INNER JOIN `page`
ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id =
rev_user))  WHERE rev_user = '7903804' AND (page_namespace = '4') AND
((rev_deleted & 12) != 12)  ORDER BY rev_timestamp DESC LIMIT 51

This appears to happen for various other queries as well, not only the
IndexPager::buildQueryInfo query quoted here.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to