Slow login with long running query and timeouts

[miaulalala]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

---

The long running query is
SELECT user_id, display_name FROM oc_user_oidc u LEFT JOIN oc_preferences p ON (userid = user_id) AND (appid = 'settings') AND (configkey = 'email') WHERE (user_id LIKE '%userid%') OR (display_name LIKE '%userid%') OR (configvalue LIKE '%userid%') ORDER BY LOWER(user_id) ASC 59

Either in \OCA\UserOIDC\Db\UserMapper::findDisplayNames

or \OCA\UserOIDC\Db\UserMapper::find

Server configuration

Web server: Nginx

Database: MySQL

PHP version: 8.1/8.2/8.3

Nextcloud version: 29.0.10