java.sql.SQLException: Sort aborted

java.sql.SQLException: Sort aborted:

it was a problem with the cache configuration of the mysql

increasing the buffer to a value like this (it was really low, like 256K before) makes the tables load normally on startup

code: 1: sort_buffer_size = 32M

# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.
sort_buffer_size=256K