Issue: dqlite recovery does not preserve server roles

Issue: dqlite recovery does not preserve server roles: a task in LegoFlow-SWE (Harbor dataset). When a dqlite cluster is recovered after a majority loss, the current dqlite node recover function rebuilds the cluster configuration but treats every node as a voter. This means any original role…

The task

When a dqlite cluster is recovered after a majority loss, the current `dqlite_node_recover` function rebuilds the cluster configuration but treats every node as a voter. This means any original role assignments (voter, standby, or spare) are lost, which can break the cluster’s intended topology and promotion rules.

Part of Lego-X/LegoFlow-SWE.