*** 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

Reply via email to