[Bug]: Unknown error - NextCloud collapses Too many connection - MYSQL queries are not completed

christianbunge commented 5 months ago

⚠️ 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 OR Nextcloud Community Forum (I've searched it).
[X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
[X] I agree to follow Nextcloud's Code of Conduct.

Bug description

We have a simple Nextcloud installation with 60 users. The cloud collapses after an unknown amount of time. After consulting in the forum, we were able to narrow down the errors to the OCS-API. The API creates entries in the oc_authtoken table. Shortly before the server collapsed I was able to take the screenshot. The processes are not terminated. Please check this error. I would be happy to provide you with any further information. The person who wrote his own API couldn't explain to me what he does/queries.

Steps to reproduce

1. NextcloudKunde

2. 3.

Expected behavior

The cloud is gradually becoming slower and working is no longer possible. We increased the MYSQL processes to 1000, but that wasn't the solution.

Installation method

Other Community project

Nextcloud Server version

28

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Updated from a MINOR version (ex. 22.1 to 22.2)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

[X] Default user-backend (database)
[ ] LDAP/ Active Directory
[ ] SSO - SAML
[ ] Other

Configuration report

I am not allowed to make log files publicly available due to data protection regulations.

List of activated Apps

I am not allowed to make log files publicly available due to data protection regulations.

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

I am not allowed to make log files publicly available due to data protection regulations.

Additional info

Please see my entry from the help forum: https://help.nextcloud.com/t/unbekannter-fehler-cloud-bricht-zusammen-too-many-connection/185571

solracsf commented 5 months ago

This might help/or fix it, but it is v29 only: https://github.com/nextcloud/server/pull/43057

Backports to 28 and 27 are ongoing.

mmaxwell5 commented 2 months ago

I am having the same issue.

Nextcloud Hub 8 (29.0.1) Running in Docker on Ubuntu 22.04 LTS

nextcloud / server