Hi!
Maybe the partition use for spooling has not enough size
Note, not only the "data", but the "metadata" partition can return other error:
Mysql example:
tmpdir = /tmp/ (default)
tmpdir = /var/tmp/mysql (in my case, for large backups)
In your case, be sure having >255Gb for that purpose
Best regards!