-
Notifications
You must be signed in to change notification settings - Fork 87
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
Huge load on maintenance task related to GP, following upgrade NC19 -> NC20, forcing to disable GP #1361
Comments
We are seeing similar huge query statements, and many long running mysql requests that often include group-folders. |
Hi, |
That duplicate is not a duplicate. It involves php unnecessarily/inefficiently processing a long list of files in the trashcan. |
Just to be clear, when i pubished this issue, by saying maintenance issue with GroupFolders i did not mean maintenance mode at all, but maintenance task run by cron or whatever. |
@pierfu do you still have issues? Maybe an update fixed it? |
I got no answer on this issue, and it happened on a big production instance, so the only thing i'm sure about is that i won't take that risk to just try and mybe break everything. Sorry :/ Is this extension planned on beeing merged in Nextcloud core ? I can see on https://apps.nextcloud.com/apps/groupfolders that Nextcloud GMBH is now editor. That could maybe help on maintaining this app more efficiently. |
What do you mean nextcloud core? So if you have support with Nextcloud GMBH, they will gladly help you. |
Thanks for your answer. I missed this supported-apps page, and this possibility of asking support to Nextcloud GMBH. So i can't just try again GP and see if it crashes. |
I understand. |
Thanks Pierre,
I think we can close even if not resolved. |
There is a somehow related issue here: As you want feel free to close or not, your call :) |
OK, il leave it opened. |
This was mainly fixed by 57cf151 |
Hi,
a few days after upgrading Nextcloud from 19 to 20.0.7, we had to face a critical issue on a production server, ands it seamed directly related to GroupFolders.
huge lines in NC log, like ~5.000.000 characters, of failed requests, with :
1/ recurring pattern : An exception occurred while executing 'DELETE FROM "oc_filecache_extended" WHERE "fileid" IN (?...?) ' with params [id1,... idN] :\n\nSQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535", ,"class":"Doctrine\DBAL\Driver\PDOException"},"DELETE FROM "oc_filecache_extended" WHERE "fileid" IN (?...?) ", [19017890,19537170,19459948,18911007,15822686,"And 89981 more entries
2/ GroupFolders appears many times in these huge log lines : {"file":"/var/www/nextcloud/nextcloud-20.0.7/apps/groupfolders/lib/ACL/ACLManager.php","line":75, "function":"getRootStorageId","class":"OCA\GroupFolders\ACL\ACLManager","type":"->","args":[]}
problem was solved first times wirth "php occ maintenance:repair", that seamed to kill the job responsible for blocking everything, but never in a long-term way
the only long-term workaroud was to disable groupfolders completely
So,
I join an excerpt of the log.
tail_-n1_nextcloud_abbr.log
The text was updated successfully, but these errors were encountered: