Page MenuHomePhabricator

Delete some now invalid PhabricatorFeedQuery saved queries in the Phab DB
Closed, ResolvedPublic

Description

Followup to T387479: 'Unhandled Exception ("Error")' displayed when attempting to filter the Phabricator activity feed by IDs/PHIDs.

Potentially delete saved query rows in the DB which now throw the exceptions

  • Call to undefined method PhabricatorFeedQuery::withIDs()
  • Call to undefined method PhabricatorFeedQuery::withPHIDs()

SELECT ssq.* FROM phabricator_search.search_savedquery ssq WHERE ssq.engineClassName = "PhabricatorFeedSearchEngine" AND (ssq.parameters LIKE "%\"phids\":[\"%" OR ssq.parameters LIKE "%\"ids\":[\"%") LIMIT 500;

Looks like no dashboard panels are using those? (cf T414796)

Event Timeline

Aklapper triaged this task as Low priority.
Aklapper claimed this task.
Aklapper moved this task from To Triage to Database fiddling on the Phabricator board.

Deleted 10 rows from the DB, expecting no more Call to undefined method PhabricatorFeedQuery::withIDs() or Call to undefined method PhabricatorFeedQuery::withPHIDs() noise in Logstash in the future:

DELETE FROM phabricator_search.search_savedquery WHERE engineClassName = "PhabricatorFeedSearchEngine" AND (queryKey = "titQZ1GfIzdE" OR queryKey = "fL_uwfbouWsc" OR queryKey = "2pirUz5BqGE7" OR queryKey = "3IoolcCIERxK" OR queryKey = "Mh10a0PaqJuF" OR queryKey = "vzWM2JLygRiZ" OR queryKey = "oVMbkRth9i6G" OR queryKey = "xSPzWqrFGThe" OR queryKey = "ZAXThOTRqzGF" OR queryKey = "1.vqosIc_1sQ");