yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1998083] [NEW] volume_attachement entries are not getting deleted from DB

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Launchpad Bug Tracker <1998083@xxxxxxxxxxxxxxxxxx>
Date: Wed, 07 Dec 2022 11:47:24 -0000
Reply-to: Bug 1998083 <1998083@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
You have been subscribed to a public bug:

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 to make it work.

For e.g I shelved some instance via openstack horizon to reproduce the
same scenario.

Here are the detailed attachment entries you can see for the shelved
instance.

+--------------------------------------+--------------------------------------+--------------------------+--------------------------------------+---------------+-----------------------------------------│·

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
│·

| id                                   | volume_id
| attached_host            | instance_uuid                        |
attach_status | connector                               │·

|             │·

+--------------------------------------+--------------------------------------+--------------------------+--------------------------------------+---------------+-----------------------------------------│·

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
│·

| 8daddacc-8fc8-4d2b-a738-d05deb20049f |
67ea3a39-78b8-4d04-a280-166acdc90b8a | nfv1compute43 |
9266a2d7-9721-4994-a6b5-6b3290862dc6 | attached      | {"platform":
"x86_64", "os_type": "linux│·

", "ip": "10.42.168.87", "host": "nfv1compute43", "multipath": false,
"do_local_attach": false, "system uuid": "65917e4f-c8c4-a2af-
ec11-fe353e13f4dd", "mountpoint": "/dev/vda"} |             │·

| d3278543-4920-42b7-b217-0858e986fcce |
67ea3a39-78b8-4d04-a280-166acdc90b8a | NULL                     |
9266a2d7-9721-4994-a6b5-6b3290862dc6 | reserved      | NULL
│·

|             │·

+--------------------------------------+--------------------------------------+--------------------------+--------------------------------------+---------------+-----------------------------------------│·

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
│·

2 rows in set (0.00 sec)

If I would like to unshelve this instance it wont work as it has a
duplicate entry in cinder db for the attachment. So i have to delete it
manually from db or via cli.

root@master01:/home/hemant# cinder --os-volume-api-version 3.27
attachment-list --all | grep 67ea3a39-78b8-4d04-a280-166acdc90b8a
│·

| 8daddacc-8fc8-4d2b-a738-d05deb20049f |
67ea3a39-78b8-4d04-a280-166acdc90b8a | attached |
9266a2d7-9721-4994-a6b5-6b3290862dc6 |
│·

| d3278543-4920-42b7-b217-0858e986fcce |
67ea3a39-78b8-4d04-a280-166acdc90b8a | reserved |
9266a2d7-9721-4994-a6b5-6b3290862dc6 |

cinder --os-volume-api-version 3.27 attachment-delete
8daddacc-8fc8-4d2b-a738-d05deb20049f

I could only gather logs from nova-compute

nova-compute logs:

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

This is the only choice I have if I would like to unshelve vm. But this
is not a good approach for production env to delete duplicate volume
attachments entries every time for every vm.

Is there any way to fix this issue ?

** Affects: nova
     Importance: Medium
         Status: New

** Affects: cinder/wallaby
     Importance: Medium
         Status: New


** Tags: horizon
-- 
volume_attachement entries are not getting deleted from DB
https://bugs.launchpad.net/bugs/1998083
You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova).