0

I was trying to join 2 views. First, it worked, created a view even. Then I changed something that gave this "table is full" error and now however I try to join these views, I only get the same error. Joining each to any other view/table works.

I don't know if it matters but one of them has ~125K rows, the other has ~15K but even inner join won't run. I had no problem running a query that yields 280K+ rows after this error. I don't know why it can't join these two. I don't really understand how this works, I tried to look up solutions.

I restarted DataGrip, restarted the MySQL service, rebooted my PC. I have almost 100G free disk space and it's a 64-bit Windows.

innodb_data_file_path is ibdata1:12M:autoextend. I read that you can set a max but leaving it at autoextend is also good.

I edited my.ini (formerly, it only had tmp_table_size=33M, max_heap_table_size wasn't in it):

tmp_table_size=2G
max_heap_table_size=2G

And restarted MySQL. Same error.

Emcs
  • 3
  • 4
  • 1
    Have you read this thread https://stackoverflow.com/questions/730579/1114-hy000-the-table-is-full ? Here are a lot of useful tips. It's definitely something wrong with MySQL server configuration. – Yuri Win Apr 22 '22 at 10:50

0 Answers0