Hey everyone! I hope this is the right place to ask my question. If not, please tell me.
So I have a production instance of Strapi running with SQLite database. I want to migrate to MySQL to improve its performance. I’ve tried import/export and also transfer methods. No matter which method I use, I get the below error when starting the instance. Now the interesting part is that the mentioned table has one single row! How can I solve this issue? I’ve also tried increasing sort_buffer_size variable but it didn’t help.
[2024-11-05 18:15:02.329] error: select * from strapi_database_schema order by time DESC limit 1 - Out of sort memory, consider increasing server sort buffer size
Error: select * from strapi_database_schema order by time DESC limit 1 - Out of sort memory, consider increasing server sort buffer size
at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:738:17)
at Query.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/app/node_modules/mysql2/lib/connection.js:481:34)
at PacketParser.onPacket (/app/node_modules/mysql2/lib/connection.js:97:12)
at PacketParser.executeStart (/app/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket. (/app/node_modules/mysql2/lib/connection.js:104:25)
at Socket.emit (node:events:514:28)
at Socket.emit (node:domain:488:12)
at addChunk (node:internal/streams/readable:545:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:495:3)
This topic has been created from a Discord post (1303425314046611456) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord