mysql 8 - linux 安装后 java 调用报错 SQLException: Temporary file write failure

完整报错

Cause: java.sql.SQLException: Temporary file write failure. ; uncategorized SQLException; SQL state
 [HY000]; error code [1878]; Temporary file write failure.; nested exception is java.sql.SQLException: Temporary file write failure.

解决

不要作用在指定表，应该执行在最外层

set global join_buffer_size = 1024*1024*1024;

show VARIABLES like '%join_buffer%';