Hi,
I have a LXD server with LXD installed twice, with apt and snap.
I don’t remember how it came up, everything was working fine until this morning when my server reboot
None of my container started up and I can’t see them (lxc ls
) but they are still here (I hope) in /var/snap/lxd/common/lxd/containers/
I know that I must run lxd.migrate
to finish the migration process but it doesn’t works :
error: Unable to connect to the destination LXD: Get "http://unix.socket/1.0": dial unix /var/snap/lxd/common/lxd/unix.socket: connect: connection refused
When I look into /var/snap/lxd/common/lxd/logs/lxd.log
I can see this error :
t=2021-10-05T09:22:09+0200 lvl=eror msg="Failed to start the daemon: Failed to open cluster database: failed to ensure schema: failed to apply update 43: Failed adding unique index to storage_pools_config and networks_config tables: UNIQUE constraint failed: index 'networks_unique_network_id_node_id_key'"
I Loged into sqlite (sudo sqlite3 /var/snap/lxd/common/lxd/database/global/db.bin
) and effectivly I have two entries for ipv4.address
select * from networks_config;
1|1||ipv4.address|10.145.193.1/24
5|1||ipv4.address|10.1.1.1/24
6|1||ipv4.nat|true
7|1||ipv6.address|fd42:25ab:cf3a:d599::1/64
8|1||ipv6.nat|true
If I delete one (id = 1) , it came back over and over
What can I do ?
How can I finish my migration process ?
Thanks a lot