j-ed
June 27, 2024, 12:33pm
5
Due to the fact that a missing index has been addressed last week in the following ticket, I assume that the field is still required:
opened 02:48PM - 20 Jun 24 UTC
bug
0. Needs triage
performance 🚀
29-feedback
### ⚠️ This issue respects the following points: ⚠️
- [X] This is a **bug**, … not a question or a configuration/webserver/proxy issue.
- [X] This issue is **not** already reported on [Github](https://github.com/nextcloud/server/issues?q=is%3Aopen+is%3Aissue+label%3Abug) OR [Nextcloud Community Forum](https://help.nextcloud.com/) _(I've searched it)_.
- [X] Nextcloud Server **is** up to date. See [Maintenance and Release Schedule](https://github.com/nextcloud/server/wiki/Maintenance-and-Release-Schedule) for supported versions.
- [X] I agree to follow Nextcloud's [Code of Conduct](https://nextcloud.com/contribute/code-of-conduct/).
### Bug description
The query
```sql
SELECT
`appid`,
`configkey`,
`configvalue`,
`type`
FROM
`oc_appconfig`
WHERE
`lazy` = 0
```
does not use an index. It's executed often.
Query id 43744e10e8843e7dff44336c2481d8ad
### Steps to reproduce
1. ???
### Expected behavior
Fast queries
### Installation method
None
### Nextcloud Server version
29
### Operating system
None
### PHP engine version
None
### Web server
None
### Database engine version
None
### Is this bug present after an update or on a fresh install?
None
### Are you using the Nextcloud Server Encryption module?
None
### What user-backends are you using?
- [ ] Default user-backend _(database)_
- [ ] LDAP/ Active Directory
- [ ] SSO - SAML
- [ ] Other
### Configuration report
_No response_
### List of activated Apps
_No response_
### Nextcloud Signing status
_No response_
### Nextcloud Logs
_No response_
### Additional info
_No response_
Have you tried to add the missing field manually to get rid of the error message?
Nevertheless it might be worth to open an issue ticket in the Github repository to get it fixed in the docker image: