Searches for workspaces never return

[meysholdt]

Bug description

When searching for a workspaceID (e.g. 0a88a641-6bfb-4fe1-8924-84c7e98bff07) on https://gitpod.io/admin/workspaces, the icon (magnification glass) keeps spinning for 10min+ and I never get search results.

Steps to reproduce

(see above)

Workspace affected

No response

Expected behavior

The search should return in less than a second.

Example repository

No response

Anything else?

Is there maybe an index on the DB missing? I assume this would need to be a full-text index over multiple columns. Not sure if MySQL can do that or if this has other unwanted side-effects.

[laushinka]

Yes, currently we search on the contextURL and we have no index there. We should work on this soon as this problem was raised multiple times. @jldec

[laushinka]

Current Honeycomb duration tracing[1] (thanks, @mads-hartmann!)

[laushinka]

Comparison tracing[1]