Summary

Rebased PR onto latest main and added checkpoint generation capability for RocksDB databases.

Changes

• Added GenerateDBCheckPointCommand to create RocksDB checkpoints for backup/snapshot purposes
• Integrated command into CLI with rooch db generate-db-checkpoint -o <output_dir> subcommand
• Fixed readonly RocksDB initialization to set error_if_exists(false), preventing spurious errors when opening existing databases in readonly mode

Implementation Details

The checkpoint command uses RocksDB's native checkpoint API to create consistent snapshots without blocking writes:

pub async fn execute(self) -> RoochResult<()> {
    let (_root, rooch_db, _start_time) =
        open_rooch_db_readonly(self.base_data_dir.clone(), self.chain_id.clone());
    let rocks_db = rooch_db.moveos_store.node_store.get_store().store().db()
        .expect("Failed to open RocksDB instance")
        .inner();

    let check_point = Checkpoint::new(rocks_db)
        .expect("failed to create Checkpoint object from RocksDB instance.");
    check_point.create_checkpoint(self.output_dir.as_path())
        .map_err(|e| RoochError::from(anyhow::anyhow!(
            "failed to create checkpoint directory at {:?}: {}", self.output_dir, e
        )))?;
    
    Ok(())
}

Opens database in readonly mode to avoid interfering with running nodes.

💬 We'd love your input! Share your thoughts on Copilot coding agent in our 2 minute survey.