Do you know why your snapshot creation failed? Do you have logs with the error?
On paper the situation does not look too bad, as the only discrepancy
between the database and vdsm is the status of the image, and since
it's legal on vdsm, changing it legal in database should work (image
status 1)
Active Image is not the same image that has a parentid of all 00000
Can you elaborate on this? The image with the empty parent is usually
the base image (the first active image), the active image will usually
be the leaf (unless the VM is in preview or something similar)
Of course do not make any changes without backing up first