MySQL Forums
Forum List  »  InnoDB

ERROR 1114 (HY000): The table /var/folder/... is full
Posted by: Vinay Reddy
Date: October 24, 2021 08:49PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1114 (HY000): The table /var/folder/... is full
116
October 24, 2021 08:49PM


Sorry, only registered users may post in this forum.

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.