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.