MySQL: Out of sort memory

[veneliniliev]

• Laravel Version: 7.18.0
• PHP Version: 7.4.7
• Database Driver & Version: mysql Ver 8.0.20-0ubuntu0.20.04.1

Description:

When make sorting (on two fields) with eloquent on table with json field (many base64 items), mysql return error "Out of sort memory, consider increasing server sort buffer size" but eloquent don't throw/show any exeption :(

Returned value is NULL.

When increase sort_buffer_size=2M working perfectliy but... the problem is quite difficult to find...

Steps To Reproduce:

• make db table with json field
• insert many rows with big content in json field
• sort on 2 or more fields
• eloquent "->paginate()" return null value