1603380 - Search broken when filtering for more than one string status

Status: RESOLVED FIXED

(Webtools Graveyard :: Pontoon, defect, P1)

Description

[Francesco Lodolo [:flod]]

This search (translated+missing) doesn't load
https://pontoon.mozilla.org/it/firefox-monitor-website/recommendations.ftl/?status=translated%2Cmissing&string=206083

If I limit it to translated it works correctly
https://pontoon.mozilla.org/it/firefox-monitor-website/recommendations.ftl/?status=translated&string=206083

Comment 1

[Jarek Śmiejczak [:jotes]]

This looks like a performance issue. The frontend tries to fetch entities (via /get-entities/) and the backend throw an HTTP 503 error after 30 seconds of waiting.
Unfortunately, I don't know what's the root cause of that bottleneck (my first picks: a missing database index, a strange ORM query?). I'll investigate it over the next 2-3 days.

Comment 2

[Jarek Śmiejczak [:jotes]]

Okay, may current notes:

• The problem is fully reproducible on Staging (which is good, because it's safer to enable all debug stuff there)
• Translate.next doesn't currently handle the case on which the server doesn't respond or returns an error
  • :mathjazz :adrian: Do you have an idea how to solve this from the UI perspective?
• Does Pontoon sends reports about such errors (that are affecting the UI) to New Relic? It could detect such issues sooner.

Comment 3

[Matjaz Horvat [:mathjazz]]

https://github.com/mozilla/pontoon/commit/76e6110196d05e4f7209b445abe6f7d604a0e837