Memory allocation error: 1038 Out of sort memory

My guess here is that you have json fields in your table, and you are sorting on a none json column. I really suggest the you don't use json at all in the database, it is bad practice.

https://tray2.se/posts/database-design

Changing the sorting buffer size can cause other performance issues, so it's not recommended.

I do agree with @tray2 about avoiding JSON columns...they seem like a great tool, and are in many ways, in our company we've used them a fair bit...but generally try to avoid them if possible.

The solution for us getting around this issue is to ->select() only the columns you need for the query and NOT the JSON columns. If you add that to your Eloquent query, we've found that error is resolve I believe in all cases.