Activity log for bug #1703488

Date Who What changed Old value New value Message
2017-07-11 01:08:56 Eddie Yen bug added bug
2017-07-27 14:13:09 Sean Dague nova: status New Confirmed
2017-07-27 14:13:12 Sean Dague nova: importance Undecided Low
2017-07-27 14:14:26 Sean Dague tags db pci db low-hanging-fruit pci
2017-07-28 00:27:25 Eddie Yen description Hi, this is my 1st time write this report at Launchpad. ===Description=== I'm using Mitaka installed by Fuel 9.2, and I meet a issue that the info didn't remove at pci_devices table in Nova Database after I removed one of the device from compute node and nova.conf ===How did I reproduce?=== 1. Plug two different model PCI devices and add two PCI devices information into nova.conf in target compute node and each control node by following format: 2. Restart nova-api, nova-scheduler, and nova-compute. Compute node only shows the last device I add. But if I do some actions on instance with the flavor contained PCI passthrough info, it will be normal. And database info is correct. 3. Remove one of the PCI device info from nova.conf (included target compute and controllers), restart services, shutdown the compute node and unplug the device. (Note: The card ID of what I remove is 1002:68c8) Power on the compute code and check nova-compute log, the report is correct. ===Expected result=== The info of removed device should be deleted or stayed at "DELETED" status in Nova DB. ===Actual result=== The info of removed device still exist and stayed at "AVAILABLE" status in Nova DB. ===Log and configs=== [1] Format of pci_alias and pci_passthrough_whitelist in nova.conf http://paste.openstack.org/show/614973/ [2] Nova-compute log after added info and restart service http://paste.openstack.org/show/z015rYGXaxYhVoafKdbx/ [3] Nova-compute log after doing few actions on instance contained with PCI http://paste.openstack.org/show/614658/ [4] Pci_devices table info in Nova DB after add devices http://paste.openstack.org/show/8JS0i6BMitjeBVRJTkRo/ [5] Nova-compute log after remove one of the device and restart service http://paste.openstack.org/show/qUCOX09jyeMydoYHc8Oz/ [6] Pci_devices table info in Nova DB after remove one of the device http://paste.openstack.org/show/SnJ8AzJYD6wCo7jslIc2/ Hi, this is my 1st time write this report at Launchpad. ===Description=== I'm using Mitaka installed by Fuel 9.2, and I meet a issue that the info didn't remove at pci_devices table in Nova Database after I removed one of the device from compute node and nova.conf ===How did I reproduce?=== 1. Plug two different model PCI devices and add two PCI devices information into nova.conf in target compute node and each control node by following format: 2. Restart nova-api, nova-scheduler, and nova-compute. Compute node only shows the last device I add. But if I do some actions on instance with the flavor contained PCI passthrough info, it will be normal. And database info is correct. 3. Remove one of the PCI device info from nova.conf (included target compute and controllers), restart services, shutdown the compute node and unplug the device. (Note: The card ID of what I remove is 1002:68c8) Power on the compute code and check nova-compute log, the report is correct. But data from pci_devices table seems wrong. ===Expected result=== The info of removed device should be deleted or stayed at "DELETED" status in Nova DB. ===Actual result=== The info of removed device still exist and stayed at "AVAILABLE" status in Nova DB. ===Log and configs=== [1] Format of pci_alias and pci_passthrough_whitelist in nova.conf http://paste.openstack.org/show/614973/ [2] Nova-compute log after added info and restart service http://paste.openstack.org/show/z015rYGXaxYhVoafKdbx/ [3] Nova-compute log after doing few actions on instance contained with PCI http://paste.openstack.org/show/614658/ [4] Pci_devices table info in Nova DB after add devices http://paste.openstack.org/show/8JS0i6BMitjeBVRJTkRo/ [5] Nova-compute log after remove one of the device and restart service http://paste.openstack.org/show/qUCOX09jyeMydoYHc8Oz/ [6] Pci_devices table info in Nova DB after remove one of the device http://paste.openstack.org/show/SnJ8AzJYD6wCo7jslIc2/
2017-08-22 18:59:41 Lakshman Ganesh Rajamani nova: assignee Lakshman Ganesh Rajamani (ganlaksh)