influxdata / influxdata/influxdb

Continuous Queries not restored

Open
#21,494 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

__Steps to reproduce:__

1. Create an influx backup from an instance with retention policies, continuous queries, data, etc.
```
influxd backup -portable testbackup
```

2. Restore that backup to a new instance
```
influxd restore -portable testbackup
```

3. Check for Continuous Queries, which are now missing, and retention policies, which were restored successfully.

```
influx
InfluxDB shell version: 1.8.5
> use yourDatabase
Using database yourDatabase
> show retention policies
name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
autogen 15120h0m0s 168h0m0s 1 false
two_hours 2h0m0s 1h0m0s 1 true
ten_days 240h0m0s 24h0m0s 1 false
one_year 8760h0m0s 168h0m0s 1 false

> show continuous queries
name: yourDatabase
name query
---- -----

__Expected behavior:__

Continuous Queries are restored.

__Actual behavior:__

Continuous Queries are not restored,

__Environment info:__

* System info: Linux a2ce56e2c98b 4.14.231-173.360.amzn2.x86_64
* InfluxDB version: InfluxDB v1.8.5 (git: 1.8 3d16c6318cf5)
* Other relevant environment details: Running docker using the official influxdb image

Contributor guide

Open the contributing guide

Research direction

Reproduce the issue with the documented `influxd backup -portable` and `influxd restore -portable` commands, then inspect the backup and restore entry points. Verify the result with `show retention policies` and `show continuous queries`; done means continuous queries are present after restoring a portable backup.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.