[influxdb] Regenerating meta.db

[r***@gmail.com]

We've recently upgraded our 0.10.3 single node to 0.11.0 and followed the directions for upgrading to tsm1 shards. In the process we erroneously removed the existing meta directory. We replaced the meta directory from a snapshot that was a few weeks old and have "lost" all the data inbetween. I am thinking that the data is still on disk but the meta.db has no idea how or where to locate thed data??? If that is the case, is there anyway to rebuild/regenerate a fresh meta.db from the data that is available on disk? Thanks.

- Rob

[r***@gmail.com]

Post by r***@gmail.com
We've recently upgraded our 0.10.3 single node to 0.11.0 and followed the directions for upgrading to tsm1 shards. In the process we erroneously removed the existing meta directory. We replaced the meta directory from a snapshot that was a few weeks old and have "lost" all the data inbetween. I am thinking that the data is still on disk but the meta.db has no idea how or where to locate thed data??? If that is the case, is there anyway to rebuild/regenerate a fresh meta.db from the data that is available on disk? Thanks.
- Rob

Ill take anything suggestions.. even if i have to manually map a couple dozen shards

[r***@gmail.com]

I'll take any suggestions.. even if that means manually mapping the shards

[r***@gmail.com]

Sean,

If there is a way to do it via the source I am happy doing it that way. Just point me in the right direction. No hand-holding tools required.

- Rob

Rob,
With the current architecture, if the metastore is gone there is no way to rebuild the database. It might be possible to export it from the files and re-import. I don't know if we have a tool that can read the shards and dump out line protocol or some other format. I'll ask.
I'll take any suggestions.. even if that means manually mapping the shards
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups "InfluxDB" group.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/db060358-68a7-4389-a1ba-12af91ba5b8c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Sean Beckett
Director of Support and Professional Services
InfluxDB

[b***@gmail.com]

Command for exporting data from influxdb tsm file is

$influx_inspect export -database dbname -datadir path -waldir path -out exportfile

For importing back to influxdb

$influx -import -path=exportfile