Recover installation after OS reinstall

InfluxDB 2
1

Hi there. I’m using InfluxDB v2.7.1 on Linux.

Up until yesterday morning, I was running on a Centos 8 Stream distro, with InfluxDb installed via rpm/dnf. But then, unrelated to InfluxDb, I borked my OS. Instead of reinstalling Centos, I took the opportunity to switch to AlmaLinux.

Unfortunately, when I reinstalled InfluxDb, I found that everything was wiped out: Historical data, API tokens, logins, and saved dashboards.

I’m hoping with the right filesystem manipulation, it’d be possible to recover at least some of the old state, especially since it’s the same exact InfluxDb code that’s being run.

I lost my root filesystem in the OS reinstall, but I didn’t lose other filesystems.

Kept:
/etc
/var/lib/influxdb/engine

Lost:
/var/lib/influxdb/influxd.bolt
/var/lib/influxdb/influxd.sqlite

My attempts to utilize my old /etc/influxdb and /var/lib/influxdb/engine directories didn’t work as expected. Is this because of those two files I lost? Is there another place I should be looking?

2

Hello @ssuchter,
The unfortunate reality is that by losing /var/lib/influxdb/influxd.bolt and /var/lib/influxdb/influxd.sqlite , you’ve lost some crucial components for InfluxDB v2.

  1. /var/lib/influxdb/influxd.bolt: This file is the metadata database for InfluxDB v2, and it contains critical configuration data, including user accounts, orgs, buckets, and API tokens.
  2. /var/lib/influxdb/influxd.sqlite: This is for stored queries and tasks, so losing this means any stored tasks or saved Flux queries are gone.
  3. /var/lib/influxdb/engine: This directory actually holds the time series data. So, if you’ve retained this directory, your historical time series data is still there, but without the metadata (buckets, organizations, tokens), accessing it can be challenging.

You can check the following to see if data is still there:

/var/lib/influxdb/engine/data/{orgID}/{bucketID}/autogen/{shardID}

You can try the following:

Recovery Steps:

  1. Reinitialize InfluxDB: Start by reinitializing InfluxDB (which will recreate the .bolt and .sqlite files) and set up a user, organization, and bucket.
  2. Accessing Historical Data: The real challenge is accessing the old data in /var/lib/influxdb/engine. The directory structure inside engine will look something like:

bashCopy code

/var/lib/influxdb/engine/data/{orgID}/{bucketID}/autogen/{shardID}
  • orgID is the unique identifier for the organization.
  • bucketID is the unique identifier for the bucket.
  • shardID is the unique identifier for the data shard.The issue is that the orgID and bucketID are stored in the .bolt file, which you’ve lost. However, you can try to recover by:a. Taking note of the new orgID and bucketID after you’ve reinitialized InfluxDB. b. Shut down InfluxDB. c. Rename the directory structure in /var/lib/influxdb/engine/data to match the new orgID and bucketID. d. Restart InfluxDB.This may allow InfluxDB to see the old data as belonging to the new bucket.
  1. Restore Configuration: Unfortunately, for API tokens, logins, dashboards, etc., unless you had an external backup, those are lost due to the missing .bolt file. You’ll need to recreate them manually.

But I’m not sure if it’ll work because I haven’t tried it.

3

Thanks so much for this answer. I’m going to make sure my future installs keep the .bolt and .sqlite files on a more permanent filesystem, and back them up to another.

4

Hi @Anaisdg ,
It’s so lucky for me to see this issue, I am also experiencing this issue, however I using windows, before I reinstall new influxdb, I already copy everything from .influxdbv2 including engine, .bolt, and .sqilte.
Can you please help me how to restore my queries, tasks and data?
Thank you so much for your help.

p/s: how I reinstall is I delete the .influxdbv2 in /User/user/.influxdb2

5

Hello @vinh_lee,
did the steps above help you at all?