Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Missing index for systemtag_object_mapping.objectid #45301

Open
4 of 8 tasks
ChristophWurst opened this issue May 14, 2024 · 0 comments · May be fixed by #45306
Open
4 of 8 tasks

[Bug]: Missing index for systemtag_object_mapping.objectid #45301

ChristophWurst opened this issue May 14, 2024 · 0 comments · May be fixed by #45306

Comments

@ChristophWurst
Copy link
Member

⚠️ This issue respects the following points: ⚠️

Bug description

The following query runs a lot on 27 installations but does not use an index:

DELETE FROM
  `oc_systemtag_object_mapping`
WHERE
  `objectid` = ?

Steps to reproduce

  1. Install Nextcloud

Expected behavior

Fast queries

Installation method

None

Nextcloud Server version

27

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

@ChristophWurst ChristophWurst added bug 1. to develop Accepted and waiting to be taken care of performance 🚀 labels May 14, 2024
@ChristophWurst ChristophWurst added 3. to review Waiting for reviews and removed 1. to develop Accepted and waiting to be taken care of labels May 14, 2024
@ChristophWurst ChristophWurst self-assigned this May 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: 🏗️ In progress
Development

Successfully merging a pull request may close this issue.

2 participants