Page MenuHomePhabricator
Create Task
Maniphest T353738

Various AphrontQueryTimeoutQueryException in global search when setting a Tag (does not happen without tag)
Open, LowPublic
Actions

Description

Unhandled Exception ("PhutilAggregateException")
All of the configured Fulltext Search services failed.

  • AphrontQueryTimeoutQueryException: Query timed out after 30 second(s)!

Some examples:

https://phabricator.wikimedia.org/search/query/4kx89Dvs6pj1/: Query set to "srsearch", Tags set to Discovery-Search
https://phabricator.wikimedia.org/search/query/EGsieSwd6Jb4/: Query set to "custom message", Tags set to Notifications

Note:

  • If I do not set Tags, no timeout will happen
  • If I set Document Types to Task, no timeout will happen

Related Objects

Event Timeline

Bugreporter created this task.Dec 19 2023, 5:21 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 19 2023, 5:21 PM
Bugreporter updated the task description. (Show Details)Dec 19 2023, 5:22 PM
Aklapper added a comment.Dec 19 2023, 10:10 PM

The less specific the search query and the bigger our Phabricator database over time, the more likely broad search queries will hit the query limit, basically.

Could you elaborate which behavior you would have expected instead? If you expected lots of search results, then this task is likely "declined" though...

Aklapper edited projects, added Phabricator (Search); removed Phabricator.Dec 19 2023, 10:10 PM
Bugreporter added a comment.Dec 20 2023, 2:36 AM

Do not think there are many search results. Also there are no problem if we set another tag (e.g. srsearch with CirrusSearch).

Aklapper added a comment.Dec 20 2023, 2:45 AM

Do not think there are many search results.

The amount of results is not the issue. The amount of data to search through is the issue. Could you answer my last question, please?

Also there are no problem if we set another tag

Setting a tag reduces the amount of data to search through probably by >99% as you limit the search scope.

Bugreporter added a comment.EditedDec 20 2023, 2:46 AM

No issue if we only use a keyword and no tag, such as https://phabricator.wikimedia.org/search/query/JGEWQr3x7.VC/, provided the keyword is not a common one (cf T258803).

Aklapper added a comment.Dec 20 2023, 2:49 AM

Could you please answer my question?:

Could you elaborate which behavior you would have expected instead? If you expected lots of search results, then this task is likely "declined" though...

Aklapper renamed this task from Various AphrontQueryTimeoutQueryException in Phabricator global search to Various AphrontQueryTimeoutQueryException in global search when setting a Tag (does not happen without tag).Dec 20 2023, 2:53 AM
Aklapper triaged this task as Low priority.
Bugreporter added a comment.EditedDec 20 2023, 2:53 AM

The expected search result should be the same as https://phabricator.wikimedia.org/search/query/TKNMNOSJLu3e/, since we do not use tags on commits.

  • If we use keyword only - no time out and I am able to browse all results
  • use keyword and tag - timeout
  • use keyword, tag and type - no timeout
Aklapper added a comment.Dec 20 2023, 2:53 AM

Ah, I think I understand now. Sorry!

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL