Comment 1 for bug 1536509

the reason of this problem because reported pci devices's "status" is "none" when saved to pci_devices

2016-01-21 16:49:15.830 DEBUG oslo_concurrency.lockutils [req-a2b7a457-c473-4bff-92b1-ef15b3d63b4a None None] Lock "compute_resources" released by "nova.compute.resource_tracker._update_available_resource" :: held 0.159s inner /usr/local/lib/python2.7/dist-packages/oslo_concurrency/lockutils.py:282
2016-01-21 16:49:15.830 ERROR nova.compute.manager [req-a2b7a457-c473-4bff-92b1-ef15b3d63b4a None None] Error updating resources for node shci-pci-1.
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager Traceback (most recent call last):
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/opt/stack/nova/nova/compute/manager.py", line 6300, in update_available_resource
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager rt.update_available_resource(context)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/opt/stack/nova/nova/compute/resource_tracker.py", line 492, in update_available_resource
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager self._update_available_resource(context, resources)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/usr/local/lib/python2.7/dist-packages/oslo_concurrency/lockutils.py", line 271, in inner
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager return f(*args, **kwargs)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/opt/stack/nova/nova/compute/resource_tracker.py", line 554, in _update_available_resource
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager self._update(context)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/opt/stack/nova/nova/compute/resource_tracker.py", line 664, in _update
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager self.pci_tracker.save(context)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/opt/stack/nova/nova/pci/manager.py", line 87, in save
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager dev.save()
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/usr/local/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 205, in wrapper
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager ctxt, self, fn.__name__, args, kwargs)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/opt/stack/nova/nova/conductor/rpcapi.py", line 246, in object_action
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager objmethod=objmethod, args=args, kwargs=kwargs)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/client.py", line 158, in call
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager retry=self.retry)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/transport.py", line 90, in _send
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager timeout=timeout, retry=retry)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 464, in send
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager retry=retry)
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py", line 455, in _send
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager raise result
2016-01-21 16:49:15.830 796 ERROR nova.compute.manager RemoteError: Remote error: DBError (pymysql.err.IntegrityError) (1048, u"Column 'status' cannot be null") [SQL: u'INSERT INTO pci_devices (created_at, updated_at, deleted_at, deleted, compute_node_id, address, vendor_id, product_id, dev_type, dev_id, label, status, request_id, extra_info, instance_uuid, numa_node, parent_addr) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(deleted)s, %(compute_node_id)s, %(address)s, %(vendor_id)s, %(product_id)s, %(dev_type)s, %(dev_id)s, %(label)s, %(status)s, %(request_id)s, %(extra_info)s, %(instance_uuid)s, %(numa_node)s, %(parent_addr)s)'] [parameters: {'status': None, 'dev_id': u'pci_0000_04_10_0', 'product_id': u'1520', 'deleted': 0, 'numa_node': 0, 'created_at': datetime.datetime(2016, 1, 21, 8, 49, 15, 824047), 'vendor_id': u'8086', 'updated_at': None, 'label': u'label_8086_1520', 'dev_type': u'type-VF', 'request_id': None, 'extra_info': '{"phys_function": "0000:04:00.0"}', 'compute_node_id': 1, 'address': u'0000:04:10.0', 'deleted_at': None, 'instance_uuid': None, 'parent_addr': u'0000:04:00.0'}]