[Wikidata-bugs] [Maniphest] T298847: Access to Watchlist in Wikidata returns a Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (due to too many objects?)

[M2k_dewiki]

M2k_dewiki closed this task as "Resolved".

TASK DETAIL
  https://phabricator.wikimedia.org/T298847

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: M2k_dewiki
Cc: iamrunner, Marostegui, Zabe, RhinosF1, Ladsgroup, Aklapper, M2k_dewiki, 
Astuthiodit_1, Lmlmljs, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, 
Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, 
_jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T298847: Access to Watchlist in Wikidata returns a Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (due to too many objects?)

[Ladsgroup]

Ladsgroup added a comment.


  This is part of the bigger problem of recentchanges table in wikidata (= 
T239192 ). I try to write some notes 
there.

TASK DETAIL
  https://phabricator.wikimedia.org/T298847

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Ladsgroup
Cc: Marostegui, Zabe, RhinosF1, Ladsgroup, Aklapper, M2k_dewiki, Invadibot, 
maantietaja, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T298847: Access to Watchlist in Wikidata returns a Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (due to too many objects?)

[Marostegui]

Marostegui added a comment.


  I just ran that query manually and it took 71 seconds. (this can change 
depending on the server load too).
  Keep in mind that we have a query killer that kills queries after 60 seconds, 
so even without the work around done at T297708 
 (which is something we really 
need), the query would have never finished anyways, as the other query killer 
would have caught it.
  
  The only way is either optimize this query (not sure if that can be done 
really) or split it into smaller but faster queries and then combine the result.

TASK DETAIL
  https://phabricator.wikimedia.org/T298847

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: Marostegui, Zabe, RhinosF1, Ladsgroup, Aklapper, M2k_dewiki, Invadibot, 
maantietaja, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T298847: Access to Watchlist in Wikidata returns a Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (due to too many objects?)

[Zabe]

Zabe added a comment.


  Like @RhinosF1, I would say this is occurring due to T297708 
 and yes, it is due to the very high 
number of items in your watchlist.

TASK DETAIL
  https://phabricator.wikimedia.org/T298847

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Zabe
Cc: Zabe, RhinosF1, Ladsgroup, Aklapper, M2k_dewiki, Invadibot, maantietaja, 
Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T298847: Access to Watchlist in Wikidata returns a Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (due to too many objects?)

[RhinosF1]

RhinosF1 added subscribers: Ladsgroup, RhinosF1.
RhinosF1 added a project: Data-Persistence (Consultation).
RhinosF1 added a comment.


  @Ladsgroup: This looks like a side effect of your work.

TASK DETAIL
  https://phabricator.wikimedia.org/T298847

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: RhinosF1
Cc: RhinosF1, Ladsgroup, Aklapper, M2k_dewiki, Invadibot, maantietaja, 
Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, Marostegui, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T298847: Access to Watchlist in Wikidata returns a Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (due to too many objects?)

[Zabe]

Zabe updated the task description.

TASK DETAIL
  https://phabricator.wikimedia.org/T298847

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Zabe
Cc: Aklapper, M2k_dewiki, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T298847: Access to Watchlist in Wikidata returns a Fatal exception of type "Wikimedia\Rdbms\DBQueryError" (due to too many objects?)

[M2k_dewiki]

M2k_dewiki created this task.
M2k_dewiki added a project: Wikidata.
Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION
  Hello,
  
  for some days, when i try to access to the URL
  
  https://www.wikidata.org/wiki/Special:Watchlist
  
  I get one of the following two error messages (either the one or the other):
  
  Althoug, this message does not appear for every access to the watchlist.
  
  Maybe 9 of 10 times, the access returns the error, 
  while every 10th time the result of the watchlist is returned, 
  which shows, that there are currently 346.663 objects in my watchlist.
  
  -
  
  MediaWiki internal error.
  
  Original exception: [894813ea-7b49-436e-9691-314372f95db4] 2022-01-09 
12:48:42: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"
  
  Exception caught inside exception handler.
  
  Set $wgShowExceptionDetails = true; at the bottom of LocalSettings.php to 
show detailed debugging information.
  
  -
  
  Es ist ein Datenbankabfragefehler aufgetreten. Dies könnte auf einen Fehler 
in der Software hindeuten.
  
  [0c73f969-b853-4cb5-9904-9c201a76fc8e] 2022-01-09 12:51:02: Fataler 
Ausnahmefehler des Typs „Wikimedia\Rdbms\DBQueryError“
  
  -
  
  Thanks a lot!
  
  Kind regards,
  M2k~dewiki

TASK DETAIL
  https://phabricator.wikimedia.org/T298847

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: M2k_dewiki
Cc: Aklapper, M2k_dewiki, Invadibot, maantietaja, Akuckartz, Nandana, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, 
Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org