Page MenuHomeMiraheze

Searching for "abc-+def" on electowiki gives results in fatal exception of type "Wikimedia\Rdbms\DBQueryError"
Closed, InvalidPublic

Description

A bug has been reported on electowiki on my talk page by User:Kristomun (as "#Database query bug"):

It seems that some search patterns makes the database consistently err. For instance, try to search for "abc- def" without quotes (https://electowiki.org/w/index.php?search=abc-+def&title=Special%3ASearch&go=Go). This produces an exception of type "Wikimedia\Rdbms\DBQueryError". I'm not sure where to submit this bug report, so here it goes :-) [[User:Kristomun|Kristomun]] ([[User talk:Kristomun|talk]]) 19:00, 24 November 2021 (UTC)

The URL provided in the report demonstrates the bug for me as well, showing an error page with the following error message:

A database query error has occurred. This may indicate a bug in the software.

[78afeb232e73667532ef18bc] 2021-11-25 08:44:18: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Event Timeline

You can't have a - in a search.

It's a known forever bug upstream.

For what it's worth, the same search ("abc-+def") works on wikipedia.org

I suppose that's probably a product of them using Extension:CirrusSearch (and the Elastic Search cluster behind that). I wasn't able to find the old "forever bug" in the cursory search for the bug over in https://phabricator.wikimedia.org , but I don't doubt you (@RhinosF1) that it's findable if I look hard enough. You wouldn't happen to know what the bug number is, would you?

CirrusSearchif I am not mistaken is indeed what makes this not an issue for the WMF, but at this time we don't have the resources for that however it may potentially be integrated in the future

Perfectly summed up by Reception and Universal Omega while I was in lesson. Yes, WMF uses CirrusSearch.

I realize that moving to CirrusSearch would be an enormous endeavor (especially related to the minor severity of this bug). Having the upstream bug number helps me nudge upstream (as appropriate) and let User:Kristomun know the prognosis. Your responses have been incredibly helpful, so thank you all!

John triaged this task as Normal priority.Nov 28 2021, 16:51