Page MenuHomePhabricator

"Fatal exception of type "Wikimedia\Rdbms\DBQueryError" when trying to see watchlist in Commons
Closed, DuplicatePublic

Description

Hello,

I keep getting this ""Fatal exception of type "Wikimedia\Rdbms\DBQueryError"" whenever I try to see my watchlist in Commons:

In the beginning, maybe a week ago, it only happened occasionally, but now it happens all the time.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 17 2017, 5:47 PM

Thanks.
For future reference, please always paste text as text. I have no idea if that is an I or an L in WZW2UApAIDkAAAeXpBAAAAAK or WZW2UApAlDkAAAeXpBAAAAAK...
In any case, I cannot find any of those exception_id's in Logstash to look up the stacktrace behind. Not sure why. Meh.

So this could be T164059, T142329, T171898, T171027, or something else.

Potential workarounds you can try are in T171898#3481750 and T171366#3462659.

HI Aklapper,

It still happens all the time I try to see my watchlist:

A database query error has occurred. This may indicate a bug in the software.[WZ2D4wpAADoAAGtWm@cAAADT] 2017-08-23 13:33:19: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

I must say I should have an huge number of files there, but it worked fine until some weeks ago.

Thanks! Looking up WZ2D4wpAADoAAGtWm@cAAADT:

Query: SELECT  rc_id,rc_timestamp,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,wl_notificationtimestamp,page_latest,(SELECT  GROUP_CONCAT(ct_tag SEPARATOR ',')  FROM `change_tag`    WHERE ct_rc_id=rc_id  ) AS `ts_tags`  FROM `recentchanges` INNER JOIN `watchlist` ON (wl_user = '571008' AND (wl_namespace=rc_namespace) AND (wl_title=rc_title)) LEFT JOIN `page` ON ((rc_cur_id=page_id))   WHERE (rc_type != '6') AND (rc_source != 'wb') AND (rc_timestamp > '20170816133219') AND ((rc_this_oldid=page_latest) OR rc_type IN ('3','142') ) AND ((rc_type != 3) OR ((rc_deleted & 9) != 9))  ORDER BY rc_timestamp DESC LIMIT 250  
Function: SpecialWatchlist::doMainQuery
Error: 2062 Read timeout is reached (10.64.0.87)

this seems to be the same problem as T171027. Hence merging.

mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:10 PM