Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

错误: Internal error: No space left on device #30156

Open
yuanjava1 opened this issue Mar 13, 2025 · 2 comments
Open

错误: Internal error: No space left on device #30156

yuanjava1 opened this issue Mar 13, 2025 · 2 comments
Assignees
Labels
help wanted Extra attention is needed

Comments

@yuanjava1
Copy link

Sorry,My English is not very good, in order to avoid communication problems, I will ask questions in Chinese。
我有两台Linux设备,CPU:2核心,内存:4G,硬盘:100G,系统centos7.9,td版本3.3.5.8 Community,两台设备都是如此。通过这两台设备组成了集群,通过taosBenchmark创建了3000个子表,每个表500000条数据,每隔100ms写入一次,总共15亿数据量 。
hostname1:td1.com对应Ip:192.168.8.172
hostname2:td2.com对应Ip:192.168.8.171
不执行sql的情况下,磁盘情况如下。
host1

Image

host2

Image

执行sql如下:

Image
该sql提示:[ 2025-03-13 11:12:50 ] 错误: Internal error: No space left on device 全部: 96486ms
执行中我通过df查看,发现host2设备,磁盘占用率出现大量升高的情况,

Image

如下是我的集群基本配置信息:

Image

@yuanjava1 yuanjava1 added the bug Something isn't working label Mar 13, 2025
@yu285
Copy link
Contributor

yu285 commented Mar 13, 2025

logDir dataDir tmpDir 三个参数都要留意磁盘空间大小,tmpDir 可能会有临时文件,导致目录瞬时增大触发报错。

@yu285 yu285 self-assigned this Mar 13, 2025
@yuanjava1
Copy link
Author

logDir dataDir tmpDir 三个参数主要关注磁盘空间大小,tmpDir 可能会有临时文件,导致目录突然增加触发报错。

这三个参数我并没有改,都是默认的,然后主要是,我想知道我该如何确认需要多大的磁盘?比如我目前存了15亿的的数据只用了不到11G磁盘,但是一旦执行sql就磁盘空间不够,足足剩余39G空间还不够执行一个sql,这样在生产环境有风险。下图是错误日志

Image

@yu285 yu285 added help wanted Extra attention is needed and removed bug Something isn't working labels Mar 13, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants