ERROR 1114 (HY000): The table /var/folder/... is full
Hello, I installed mysql on my macbook air M1 via homebrew. When I run a join with a few different tables (with about 2GB of total data size) I get the following error:
ERROR 1114 (HY000): The table '/var/folders/xy/q9ts4czd5rv6l22g2l06_gc80000gn/T/#sql1b12_8_2' is full
I have plenty of space on disk (over 512GB of free space). I tried adding innodb_data_file_path = ibdata1:10M:autoextend:max:10G to /opt/homebrew/etc/my.cnf but that did not fix the issue. Any ideas on what I can do so mysql use all the temporary storage it needs?
Best,
Vinay
Subject
Views
Written By
Posted
ERROR 1114 (HY000): The table /var/folder/... is full
1277
October 24, 2021 08:49PM
622
October 24, 2021 10:52PM
504
October 25, 2021 11:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.