Database corruption after "lxc move" failure

You will likely benefit from this PR when it gets released that will better propagate migration errors:

Are both servers running LXD 5.2?

Can you show output of lxc config show <instance> --expanded, lxc info <instance> and lxc storage list <pool> please?