632436 - "Query has timed out." when searching Firefox beta with empty/inclusive start/end dates

Status: RESOLVED WORKSFORME

(Input :: General, defect, P1)

Description

[Stephen Donner [:stephend] Not actively reading bugmail]

http://input.stage.mozilla.com/en-US/beta/search?product=firefox&version=--&date_start=&date_end is throwing a "Search unavailable" error:

"Query has timed out."

Comment 1

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

We should block the release for now.

Bugs like this on launch day are bad.  I can probably fix these today or tomorrow.  I'm kind of in a black hole stuck inside a cave here, without a flashlight... in regards to this bug.

Comment 2

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

http://github.com/fwenzel/reporter/commit/1e5ca57


Fixed, sorting was too slow... I suspect we might have more issues so I still stand by my let's delay this release and QA the **** out of this.

Comment 3

[Stephen Donner [:stephend] Not actively reading bugmail]

Sadly, still happening; maybe need to do something with IT to get this resolved/updated?

Comment 4

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Bumping this - I think this is ultimately a sphinx limitation/configuration issue.

This may change when we get our own staging hardware for Sphinx.  Bumping for now.

When we're looking at less than 1M documents we should be okay, so it shouldn't be too bad.

Downgrading from critical - no data loss/corruption, just loss of functionality

Comment 7

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

sigh

http://github.com/fwenzel/reporter/commit/82a5915


So the way it works is you see about 60 days back.

Comment 8

[Matt Brandt [:mbrandt]]

Automation has been re-enabled and is passing.  All green again. QA verified.

Comment 9

[Siddhartha Dugar [:sdrocking]]

I still get the "Query has timed out." message.

Comment 10

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Via what URL?

Comment 11

[Siddhartha Dugar [:sdrocking]]

I see this on selecting version as All from the beta input dashboard. The URL that I get is http://input.mozilla.com/en-US/beta/search?product=firefox&version=--&date_start=&date_end=

Comment 12

[Matt Brandt [:mbrandt]]

sdrocking ~ good find however that is our production environment. Checkout the latest fix on stage at http://input.stage.mozilla.com/en-US/beta/search?product=firefox&version=--&date_start=&date_end

see comment 1

Comment 15

[Matt Brandt [:mbrandt]]

I'm gonna close this one since both manual & automated tests (re-enabled last week) are all passing.

QA verified.

Comment 16

[Matt Brandt [:mbrandt]]

Sorry to reopen this yet again. It has begun happening consistently on stage again. Our automation caught and alerted us to it.

http://input.stage.mozilla.com/en-US/beta/search?product=firefox&version=--&date_start=&date_end=

Comment 17

[Matt Brandt [:mbrandt]]

http://qa-selenium.mv.mozilla.com:8080/job/input%20stage/435/artifact/input.stage.mozilla.com_1299780246.png

Comment 18

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

(In reply to comment #17)
> http://qa-selenium.mv.mozilla.com:8080/job/input%20stage/435/artifact/input.stage.mozilla.com_1299780246.png

This is just a screenshot of the Query Timeout for those of you not in MV or on the office VPN.

So yes, we're aware of what the error looks like - there is a dependent bug for IT - other than that we're stuck unless we want to further cripple the product.

Comment 19

[Fred Wenzel [:wenzel]]

Deferring this one to 3.4. I don't like how this keeps reappearing, but it (luckily) doesn't impact the front page, so I am not going to delay tonight's push about it.

That being said, as Dave noted, this is a high priority because it'll get worse as data grows.

Comment 20

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

This requires ElasticSearch which won't be in place until after this iteration, bumping to 4.0

Comment 21

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Favoring API over this for now, and I don't want to do more than one big thing per release.

Comment 22

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Moving things dependent on ES to FUTURE.

Comment 23

[Stephen Donner [:stephend] Not actively reading bugmail]

Happy to report that, post-fix bug 627568, http://input.allizom.org/en-US/search?product=firefox&version=--&date_start=&date_end is working fine again.

Comment 24

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

(In reply to comment #23)
> Happy to report that, post-fix bug 627568,
> http://input.allizom.org/en-US/search?product=firefox&version=--
> &date_start=&date_end is working fine again.

Lol, I think that's because not everything is being shown :)

Comment 25

[Will Kahn-Greene [:willkg] ET needinfo? me]

This isn't an issue anymore with the new Input. Marking as WORKSFORME.