ERR: no data received, TCP connection refused, high CPU and memory usage

1

Running InfluxDB 1.7.4 on Debian buster/sid
Kernel: Linux 4.19.0-3-amd64 #1 SMP Debian 4.19.20-1 (2019-02-11) x86_64 GNU/Linux

All was working fine until now, a simple SELECT on a measurement fails like this:

> select count(*) from my_measurement
ERR: no data received
> select count(*) from my_measurement
ERR: Post http://localhost:8086/query?chunked=true&db=test&epoch=ns&q=select+count%28%2A%29+from+my_measurement: dial tcp 127.0.0.1:8086: connect: connection refused
> select count(*) from my_measurement
ERR: Post http://localhost:8086/query?chunked=true&db=test&epoch=ns&q=select+count%28%2A%29+from+my_measurement: dial tcp 127.0.0.1:8086: connect: connection refused
> select count(*) from my_measurement
ERR: no data received

At the same time, CPU usage reaches 200%, and memory usage also grows:

PID   USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND 
21836 influxdb  20   0 8022072   6.0g 828588 S 200.0  79.1   2:07.78 influxd

I opened an issue on GitHub just in case.

1 Like
2

Similar problem: after trying to SELECT INTO a few millions of points just to rename a measurement, I’m getting

ERR: no data received

on SELECT COUNT(*) FROM measurement.

InfluxDB 1.7.7 on Ubuntu 18 with XFS. Rebooting didn’t help. Looks like the database got corrupted. :-1: