It works for some namespaces, the error does not occur with all. Here's another failure:
http://en.wikipedia.org/w/index.php?title=Special%3AContributions&target=Redrose64&namespace=7
which I am certain worked in early November.

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.

Also brought up here: https://en.wikipedia.org/w/index.php?title=Wikipedia:Village_pump_%28technical%29&oldid=587376729#Draft_special_page_error

Somewhere between RecentChanges and Database territory.

Sean: is this something you might have knowledge about? specifically, Brad is saying that all of the killed queries are killed at 59 or 60 seconds, suggesting a hard limit somewhere.

Thoughts?

There is a 60s pt-kill job on slaves after query spikes causing outages in November. When the number of slow queries on a slave grows beyond a threshold the slowest one above 60s is sniped to keep the box alive. This only affects wikiuser, not wikiadmin.

However! This particular query should not have been affected as it's already diverted to specific slaves via the load balancer. So, yep, a bug. Will investigate.

Again at [[Wikipedia:Village pump (technical)#Database error in filtered new users' contributions search]]

Again at https://en.wikipedia.org/w/index.php?title=Wikipedia:Village_pump_%28technical%29&oldid=642762551#Database_error

So, yep, a bug. Will investigate.

Wondering if there was any findings

Not the same error as T108782: Special:Contributions: "contributions page filtered for namespace or RevisionDeleted edits" error?

Due to the inactivity of this task and the current scope of work for the Growth-Team, we are depriortizing this task.