influxdata / influxdata/influxdb

'ERR: no data received' after 'SELECT * INTO ...'

Open
#15,433 7 comments 3 reactions 1 assignee Claimed by @dgnorton View on GitHub
1.x kind/bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.