*** This bug is a duplicate of bug 1737724 *** https://bugs.launchpad.net/bugs/1737724
This is already fixed in cinder, the failure is in the cinder volume side: Dec 14 21:52:09 cld13b9 cinder-volume[13929]: ERROR oslo_db.sqlalchemy.exc_filters Dec 14 21:52:09 cld13b9 cinder- volume[13929]: ERROR oslo_messaging.rpc.server [None req-d6427368-7a5a- 48e5-969a-ff79d27bbf9d admin None] Exception during message handling: DBError: (pymysql.err.InternalError) (1241, u'Operand should contain 1 column(s)') [SQL: u'INSERT INTO attachment_specs (created_at, updated_at, deleted_at, deleted, `key`, value, attachment_id) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(key)s, %(value)s, %(attachment_id)s)'] [parameters: {'attachment_id': '0784d959 -fa1b-45e4-8185-eccbefdafda2', 'deleted': 0, 'created_at': datetime.datetime(2017, 12, 15, 5, 52, 9, 132697), 'updated_at': None, 'value': [u'1000b05ada00fea1', u'1000b05ada00fea9', u'10005cb901c32121', u'10005cb901c32129'], 'key': u'wwpns', 'deleted_at': None}] I'll duplicate it once I find the cinder bug. ** This bug has been marked a duplicate of bug 1737724 FC attachment issue -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1738341 Title: Nova volume-attach shows volume in 'available' status instead of 'In- use' Status in OpenStack Compute (nova): New Bug description: stack@cld13b11:~$ openstack --version openstack 3.13.0 stack@cld13b11:~$ stack@cld13b11:~/devstack$ git branch -a * master remotes/origin/HEAD -> origin/master remotes/origin/master remotes/origin/stable/newton remotes/origin/stable/ocata remotes/origin/stable/pike stack@cld13b11:~/devstack$ Below Steps Followed - Created Instance stack@cld13b11:~/devstack$ git branch -a * master remotes/origin/HEAD -> origin/master remotes/origin/master remotes/origin/stable/newton remotes/origin/stable/ocata remotes/origin/stable/pike stack@cld13b11:~/devstack$ CREATED AN INSTANCE stack@cld13b9:~$ nova boot --image 40ed0df4-2693-4b5e-9d17-666f1763de6c --flavor m1.tiny Instnace1 +--------------------------------------+-----------------------------------------------------------------+ | Property | Value | +--------------------------------------+-----------------------------------------------------------------+ | OS-DCF:diskConfig | MANUAL | | OS-EXT-AZ:availability_zone | | | OS-EXT-SRV-ATTR:host | - | | OS-EXT-SRV-ATTR:hostname | instnace1 | | OS-EXT-SRV-ATTR:hypervisor_hostname | - | | OS-EXT-SRV-ATTR:instance_name | | | OS-EXT-SRV-ATTR:kernel_id | | | OS-EXT-SRV-ATTR:launch_index | 0 | | OS-EXT-SRV-ATTR:ramdisk_id | | | OS-EXT-SRV-ATTR:reservation_id | r-jpn0k95b | | OS-EXT-SRV-ATTR:root_device_name | - | | OS-EXT-SRV-ATTR:user_data | - | | OS-EXT-STS:power_state | 0 | | OS-EXT-STS:task_state | scheduling | | OS-EXT-STS:vm_state | building | | OS-SRV-USG:launched_at | - | | OS-SRV-USG:terminated_at | - | | accessIPv4 | | | accessIPv6 | | | adminPass | nnUwV3XtYJuT | | config_drive | | | created | 2017-12-15T05:35:00Z | | description | - | | flavor:disk | 1 | | flavor:ephemeral | 0 | | flavor:extra_specs | {} | | flavor:original_name | m1.tiny | | flavor:ram | 512 | | flavor:swap | 0 | | flavor:vcpus | 1 | | hostId | | | host_status | | | id | 44856086-1792-43fa-80a8-960535f7f13e | | image | cirros-0.3.5-x86_64-disk (40ed0df4-2693-4b5e-9d17-666f1763de6c) | | key_name | - | | locked | False | | metadata | {} | | name | Instnace1 | | os-extended-volumes:volumes_attached | [] | | progress | 0 | | security_groups | default | | status | BUILD | | tags | [] | | tenant_id | 66985cb4dcaa404a871fda195417c2bb | | updated | 2017-12-15T05:34:59Z | | user_id | 3239b97f87304e1ab1ca225907e8645f | +--------------------------------------+-----------------------------------------------------------------+ stack@cld13b9:~$ nova list +--------------------------------------+-----------+--------+------------+-------------+---------------------------------+ | ID | Name | Status | Task State | Power State | Networks | +--------------------------------------+-----------+--------+------------+-------------+---------------------------------+ | 44856086-1792-43fa-80a8-960535f7f13e | Instnace1 | BUILD | spawning | NOSTATE | public=2001:db8::3, 172.24.4.12 | +--------------------------------------+-----------+--------+------------+-------------+---------------------------------+ CREATED A VOLUME stack@cld13b9:~$ nova boot --image 40ed0df4-2693-4b5e-9d17-666f1763de6c --flavor m1.tiny Instnace1 +--------------------------------------+-----------------------------------------------------------------+ | Property | Value | +--------------------------------------+-----------------------------------------------------------------+ | OS-DCF:diskConfig | MANUAL | | OS-EXT-AZ:availability_zone | | | OS-EXT-SRV-ATTR:host | - | | OS-EXT-SRV-ATTR:hostname | instnace1 | | OS-EXT-SRV-ATTR:hypervisor_hostname | - | | OS-EXT-SRV-ATTR:instance_name | | | OS-EXT-SRV-ATTR:kernel_id | | | OS-EXT-SRV-ATTR:launch_index | 0 | | OS-EXT-SRV-ATTR:ramdisk_id | | | OS-EXT-SRV-ATTR:reservation_id | r-jpn0k95b | | OS-EXT-SRV-ATTR:root_device_name | - | | OS-EXT-SRV-ATTR:user_data | - | | OS-EXT-STS:power_state | 0 | | OS-EXT-STS:task_state | scheduling | | OS-EXT-STS:vm_state | building | | OS-SRV-USG:launched_at | - | | OS-SRV-USG:terminated_at | - | | accessIPv4 | | | accessIPv6 | | | adminPass | nnUwV3XtYJuT | | config_drive | | | created | 2017-12-15T05:35:00Z | | description | - | | flavor:disk | 1 | | flavor:ephemeral | 0 | | flavor:extra_specs | {} | | flavor:original_name | m1.tiny | | flavor:ram | 512 | | flavor:swap | 0 | | flavor:vcpus | 1 | | hostId | | | host_status | | | id | 44856086-1792-43fa-80a8-960535f7f13e | | image | cirros-0.3.5-x86_64-disk (40ed0df4-2693-4b5e-9d17-666f1763de6c) | | key_name | - | | locked | False | | metadata | {} | | name | Instnace1 | | os-extended-volumes:volumes_attached | [] | | progress | 0 | | security_groups | default | | status | BUILD | | tags | [] | | tenant_id | 66985cb4dcaa404a871fda195417c2bb | | updated | 2017-12-15T05:34:59Z | | user_id | 3239b97f87304e1ab1ca225907e8645f | +--------------------------------------+-----------------------------------------------------------------+ stack@cld13b9:~$ nova list +--------------------------------------+-----------+--------+------------+-------------+---------------------------------+ | ID | Name | Status | Task State | Power State | Networks | +--------------------------------------+-----------+--------+------------+-------------+---------------------------------+ | 44856086-1792-43fa-80a8-960535f7f13e | Instnace1 | BUILD | spawning | NOSTATE | public=2001:db8::3, 172.24.4.12 | +--------------------------------------+-----------+--------+------------+-------------+---------------------------------+ ATTACH VOLUME TO AN INSTANCE stack@cld13b9:~$ nova volume-attach 44856086-1792-43fa-80a8-960535f7f13e 257eb707-3264-4539-83eb-57d97781fbbc +----------+--------------------------------------+ | Property | Value | +----------+--------------------------------------+ | device | /dev/vdb | | id | 257eb707-3264-4539-83eb-57d97781fbbc | | serverId | 44856086-1792-43fa-80a8-960535f7f13e | | volumeId | 257eb707-3264-4539-83eb-57d97781fbbc | +----------+--------------------------------------+ WHEN CHECKED CINDER LIST, VOLUME IS SEEN IN AVAILABLE STATUS AND ATTACHED TO FIELD IS EMPTY. NOTE: WITH 3PAR DRIVER, SAME SCENARIO SHOWS VOLUME IN RESERVED STATUS WITH ATTACHED TO FIELD. Attaching c-vol and n-cpu logs captured while attaching. To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1738341/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp