I had an issue importing VMs from an export domain I was trying out. The template would fail to copy over, and be stuck in a "paused" state where I could not delete or modify the VM. I was able to fix this by dropping into the SQL database and running:

psql engine -c "SELECT vm_guid, vm_name from vm_static WHERE vm_name = 'VM_Name_Here';"

psql engine -c "update vm_dynamic SET status=0 where vm_guid='LongStringFromFirstCommand;"

This was able to set the status to a state where I could delete the VM, but now I still see the "import" task in the task log.

I did some more database diving and found that if i ran:

SELECT * FROM audit_log WHERE vm_name = 'VM_Template_Name_Here';

These entries seem to correspond with the audit entries. Can I simply delete these entries from "audit_log"? Or would this cause problems?

Or perhaps, to be safe, I should just see if I can set them to "Completed"

As always, thanks!