Is there an existing issue for this?

• There is no existing issue for this bug

Is this happening on an up to date version of Incus?

• This is happening on a supported version of Incus

Incus system details

Error: The incus daemon doesn't appear to be started (socket path: /var/lib/incus/unix.socket)

Can't start incus, but it is 6.15.

Instance details

No response

Instance log

No response

Current behavior

After a somewhat failed lxd-to-incus migration, I'm unable to start incusd with the following error:

Error: Failed to initialize global database: Failed to prepare statements: "\nDELETE FROM projects WHERE name = ?\n": no such table: main.auth_groups_permission

I read through this discussion, but I'm still unable to start incusd. I did not try to delete the database or recover lxd yet.

Here is the migration log lxd-to-incus.14651.log

Here is the incusd start log

Expected behavior

No response

Steps to reproduce

1. Fail a lxd-to-incus migration
2. Try to start incusd