Database error: "sql: transaction has already been committed or rolled back"

sudo snap set lxd daemon.debug=true; sudo systemctl reload snap.lxd.daemon

Then the contents of /var/snap/lxd/common/lxd/logs/lxd.log please