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.
Description
Description
Related Objects
Related Objects
- Mentioned Here
- T142329: Can't access large watchlist on nlwiki: 503 error
T164059: MediaWiki\Linker\LinkRenderer::makeKnownLink() must implement interface MediaWiki\Linker\LinkTarget, null given on Special:Watchlist
T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis
T171366: Watchlist is not viewable
T171898: Deleting large watchlist takes > 4 seconds causing rollback due to write time limit
Event Timeline
Comment Actions
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.
Comment Actions
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.
Comment Actions
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.