ER_OUT_OF_SORTMEMORY: increase sort buffer size

Questions and Answers
1
System Information
  • Strapi Version: 4.24.4
  • Operating System: Ubuntu 22.04.5 LTS
  • Database: MySQL v.8
  • Node Version: 18.20.4
  • NPM Version: 10.7.0

Hello,

I’m encountering an error when attempting to start a production build:

select * from strapi_database_schemaorder bytime DESC limit 1 - ER_OUT_OF_SORTMEMORY: Out of sort memory, consider increasing server sort buffer size

I managed to resolve this issue by following the solution provided in this ticket.
However, I’m wondering if there is a plan for an official core fix to address this problem permanently?