Restore from partition folders

Questdb crashed due to an error in the txn_seq folder of one of our tables.
Now on disk, I can see a bunch of partition folders in there; Is it possible to restore those without the txn_seq folder?

Something like:

  • copy the db
  • drop the table on the original
  • recreate the table in the db
  • move the partition folders from the copy to the new table folder
  • ???
  • have access to the comitted rows from those partitions

Hi @YBrink , please can you share the server logs, with INFO granularity?

Hi @nwoolmer ,
I haven’t had access to the logs in question over the past week (and am not sure if I can retrieve them right now)
This was more a curiosity regarding restoring, rather than a desire to restore a particular table. That is to say, more a question of: Is this at all possible if you only have the partition folders?