influxdata / influxdata/influxdb
'ERR: no data received' after 'SELECT * INTO ...'
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
__Steps to reproduce:__
List the minimal actions needed to reproduce the behavior.
As suggested here: https://docs.influxdata.com/influxdb/v1.7/administration/backup_and_restore/#restore-examples
1. influxd backup -portable -database telegraf -host analytics-dev:8088 -start 2019-10-12T00:00:00Z -end 2019-10-12T12:00:00Z /backup/influx_backup_telegraf_`date +%Y%m%d-%H%M-%S`
2. influxd restore -portable -db telegraf -newdb telegraf_bak influx_backup_telegraf_20191015-1539-53
3.
```
> use telegraf_bak
Using database telegraf_bak
> SELECT * INTO telegraf..:MEASUREMENT FROM /.*/ GROUP BY *
ERR: no data received
> show databases
ERR: Post http://localhost:8086/query?chunked=true&db=telegraf_bak&epoch=ns&q=show+databases: dial tcp 127.0.0.1:8086: connect: connection refused
```
__Expected behavior:__
I expected the data recovery to ingest to the database.
__Actual behavior:__
The database crashes temporarily (too busy to accept connections) and the data recovery is not ingested.
__Environment info:__
* System info: Run Linux 4.14.138-114.102.amzn2.x86_64 x86_64
* InfluxDB version: InfluxDB v1.7.8 (git: 1.7 ff383cdc0420217e3460dabe17db54f8557d95b6)
* Other relevant environment details: config out of box
__Config:__
config out of box
__Logs:__
Include snippet of errors in log.
__Performance:__
Generate profiles with the following commands for bugs related to performance, locking, out of memory (OOM), etc.
```sh
# Commands should be run when the bug is actively.
# Note: This command will run for at least 30 seconds.
curl -o profiles.tar.gz "http://localhost:8086/debug/pprof/all?cpu=true"
curl -o vars.txt "http://localhost:8086/debug/vars"
iostat -xd 1 30 > iostat.txt
# Attach the `profiles.tar.gz`, `vars.txt`, and `iostat.txt` output files.
```
Contributor guide
Assessment
This issue has not been assessed yet.