Nextcloud gives MySQL "Memory allocation error: 1038 Out of sort memory"

I seem to have solved this, at least for now, by increasing the sort_buffer_size even further, to 2M. Now I can access the web GUI and I’m no longer receiving the error 1038.

Sources I followed included:

There are some suggestions that the Circles app (in Nextcloud) may also be a culprit. I did not do anything to disable it in this case, but I’m pointing it out in case that is helpful to others in a similar predicament.

1 Like