Hi Hemant,

If your final goal is to delete the attachment entries in the cinder DB, we have attachment APIs to perform these tasks. The command useful for you is attachment list[1] and attachment delete[2].
Make sure you pass the right microversion i.e. 3.27 to be able to execute these operations.

Eg:
cinder --os-volume-api-version 3.27 attachment-list

[1] https://docs.openstack.org/python-cinderclient/latest/cli/details.html#cinder-attachment-list
[2] https://docs.openstack.org/python-cinderclient/latest/cli/details.html#cinder-attachment-delete

On Fri, Nov 25, 2022 at 5:44 PM Hemant Sonawane <hemant.sonawane@itera.io> wrote:
Hello  
I am using wallaby release openstack and having  issues with cinder volumes as once I try to delete, resize or unshelve the shelved vms the volume_attachement entries do not get deleted in cinder db and therefore the above mentioned operations fail every time. I have to delete these volume_attachement entries manually then it works. Is there any way to fix this issue ?

nova-compute logs:

cinderclient.exceptions.ClientException: Unable to update attachment.(Invalid volume: duplicate connectors detected on volume

Help will be really appreciated Thanks !
--
Thanks and Regards,

Hemant Sonawane