时间戳

首页 > 解决方案 > MySQL 8 错误 #14 EE_CANT_CHSIZE

mysql - MySQL 8 错误 #14 EE_CANT_CHSIZE

问题描述

我在 MySQL 中找不到有关此错误的任何信息。任何人都知道 MySQL 正在尝试做什么，也许为什么这会引发错误？

code: 'EE_CANT_CHSIZE', errno: 14, sqlMessage: 'Can\'t change size of file (OS errno 28 - No space left on device)', sqlState: 'HY000', index: 0,

这是mysql错误日志中的错误。 Timestamp, Thread, Type, Details 2018-07-08 11:57:23.365761, 41607, ERROR] [MY-013132] [Server, The table '/data1/mysql8/tmp/#sql3435f_a287_2' is full! 2018-07-08 11:57:23.365764, 41605, ERROR] [MY-013132] [Server, The table '/data1/mysql8/tmp/#sql3435f_a285_1' is full! 2018-07-08 11:59:00.670292, 41627, ERROR] [MY-013132] [Server, The table '/data1/mysql8/tmp/#sql3435f_a29b_0' is full! 2018-07-08 11:59:00.670293, 41629, ERROR] [MY-013132] [Server, The table '/data1/mysql8/tmp/#sql3435f_a29d_0' is full! 2018-07-08 11:59:00.670291, 41608, ERROR] [MY-013132] [Server, The table '/data1/mysql8/tmp/#sql3435f_a288_1' is full! 2018-07-08 11:59:00.670294, 41619, ERROR] [MY-013132] [Server, The table '/data1/mysql8/tmp/#sql3435f_a293_0' is full!

这似乎是一个配置问题。我的 tmp 文件大小是否需要大于运行的任何查询结果？

标签： mysql

解决方案

推荐阅读