This error occurs when the buffer size required for executing a query is larger than the sort_buffer_size value configured for the MySQL server. Cause of the Mysql Error Error " Out of memory, consider increasing server sort buffer size · Method to Fix this Issue: In order to fix. In this blog post i will give this title of the error and give the Mysql Out of sort memory, consider increasing server sort buffer size.
Out of sort buffer memory error (
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.
Steps to reproduce
- start nextcloud
- try logging in
I should be able to login, as I've been for years with the very same instance.
Even if increasing the sort memory at backend:
it didn't help. But as I got hinted to disable circles app, which immediately fixed the login error. So with circles being enbled I get error page after login, and this super long log, basically saying sql has run out of sort buffer. See logs part below.
nextcloud:latest from dockerhub
HAproxy in front of docker image which has apache built in.
Nextcloud version: (see Nextcloud admin page)
Updated from an older Nextcloud/ownCloud or fresh install:
Update, I've been running this instance for years successfully.
Where did you install Nextcloud from:
List of activated apps:
Order by operation failed with error "Out of sort memory, consider increasing server sort buffer size"
Last updated on JUNE 29,
Applies to:MySQL Server - Version and later
Information in this document applies to any platform.
Order by operation failed with error "Out of sort memory, consider increasing server sort buffer size".
Usually, it means sort_buffer_size is small for the workload. You can check this document to adjust it.
When the table is small and there are JSON columns involved. Order by will fail due to Bug
Upgrade the database to
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit sprers.eu