Restore data after replace influxd.bolt

InfluxDB 2
1

Hello.
I am using version 2.4.0
Location data influx is /data/influx/

influxd.bolt
influxd.bolt.pre-v2.4.0-upgrade.backup
engine
influxd.sqlite
influxd.sqlite.pre-v2.4.0-upgrade.backup
influxd.bolt.pre-2.1.1-upgrade.backup
influxd.pid
  1. 15.09.2022 I accidentally replaced the influx.bolt file from the /var/lib/influxdb/influx.bolt folder.
  2. Then restarted influxd.
  3. After restarting influxd, influx start window message appeared in the web interface.
  4. Then I decided to restore influxd.bolt from a backup dated 17.05.2022. Influx version for this date is 2.1.1
  5. After restarting influx, there is no data from 17.05.2022 to 15.09.2022. And also there are no buckets that were created after 17.05.2022.
    How to recover data and bucket in this interval?
2

Hello @Sandre,
What did you replace the bolt file with?
Do you still have wal files that correspond to that data?

3

Hello @Anaisdg.
I copied and changed from /var/lib/influxdb/influx.bolt to /data/influx/influx.bolt.
/data/influx/ - working directory.
/var/lib/influxdb/influx.bolt - this is a clean file, i.e. the default when installing influx.
Then I restored influx.bolt from a backup on 05/15/2022.

Yes, I have wal files to that data.

/data/influxdb/engine/wal# tree
.
├── 19fc1d304759714c
│   └── autogen
│       ├── 1039
│       ├── 1088
│       ├── 1137
│       ├── 1186
│       ├── 126
│       ├── 1365
│       │   └── _00124.wal
│       ├── 1413
│       │   ├── _01231.wal
│       │   ├── _01232.wal
│       │   ├── _01233.wal
│       │   └── _01234.wal
│       ├── 174
│       ├── 222
│       ├── 270
│       ├── 3
│       ├── 318
│       ├── 366
│       ├── 38
│       ├── 4
│       ├── 414
│       ├── 462
│       ├── 510
│       ├── 558
│       ├── 606
│       ├── 654
│       ├── 702
│       ├── 750
│       ├── 77
│       ├── 798
│       ├── 8
│       ├── 846
│       ├── 894
│       ├── 942
│       └── 990
4

Hello @Sandre,
Hmm I don’t know how to regenerate a bolt file. I’m asking around.

5

Hello @Anaisdg.
I’d appreciate it.
Thanks.

6

Hi,
i have a similar problem. After update , I couldn’t login to GUI and Grafana couldn’t connect to bucket.
I find newly creted influx.bolt and influx.sqlite in /var/lib/influxdb . So I replace with old file from /var/lib/influxdb/.influxdbv2 and reboot .After that I see my old bucket, I can log in over GUI and Grafana can connect to bucket.
But can not see old data .
root@graft:/var/lib/influxdb/.influxdbv2/engine/data# du -d 1 -h
78G ./d6ca63c482905160

image
image1369×428 21.2 KB

image
image1593×433 19 KB

7

anything worked for you?