Import from other channels - Constantly getting "Failed to load search results"

[pcenov]

Observed behavior

I'm constantly getting a "Failed to load search results" regardless of the search term that I've entered. There's a 524 error in the console followed by other timeout errors.

Expected behavior

Fully operational Search functionality.

Steps to reproduce the issue

1. Go to https://hotfixes.studio.learningequality.org/en/accounts/#/ and sign in.
2. Click on a channel to open the channel editor.
3. Click Add and select Import from channels.
4. Enter a search term like 'math' and click the Search button.

Additional information

Errors and logs

Failed to load resource: the server responded with a status of 524 ()

Usage Details

• OS: Windows 10
• Browser: Chrome, Firefox
• URL: https://hotfixes.studio.learningequality.org/en/

[radinamatic]

Experiencing the same issue consistently, search for resources to import into channels does not work.

Note that searching the Content Library directly works without issues.

[pcenov]

Retested today and this issue is still happening at both hotfixes and https://studio.learningequality.org

https://learningequality.testquality.com defect D7.

[bjester]

@vkWeb @d0sadata Another search related issue that's more actionable is #3181

[bjester]

Note the request is timing out due to the amount of data and our database performance in production and staging (hotfixes), so this isn't a "bug" per se but a need for optimization.

[vkWeb]

@bjester how do you suggest we should go about optimizing this?

[bjester]

@vkWeb Please take a look at implementing #3181 first. I'm offline next week but we can collaborate on this afterwards.

[rtibbles]

One initial suggestion I had given for this was to create a separate search endpoint purely for the public channels - this might help reduce the query complexity by removing some of the permissions checking logic from these searches. However, I have not validated whether removing those aspects of the queries would resolve this issue.

[vkWeb]

@bjester okay, we'll look into this when you return.

@rtibbles we'll definitely try that as well to see if perf improves.

[ozer550]

I would like to help @vkWeb on this.

[vkWeb]

I had a talk with @d0sadata about this, he's fine with me and @ozer550 handling this.

[ozer550]

I and @vkWeb tried to look into this but got lost on our way looking into SearchContentNodeViewSet. Can you provide some pointers on how should we proceed? @bjester @rtibbles