Open Stack

On 10/22/2018 11:25 AM, Sergio A. de Carvalho Jr. wrote:
> While troubleshooting a production issue we identified that the Nova 
> metadata API is fetching a lot more raw data from the database than 
> seems necessary. The problem appears to be caused by the SQL query used 
> to fetch instance data that joins the "instance" table with, among 
> others, two metadata tables: "instance_metadata" and 
> "instance_system_metadata". Below is a simplified version of this query 
> (I've added the full query at the end of this message for reference):

Coming back on this thread [1], I've got a partial fix up which I'm 
hoping will help:

https://review.openstack.org/#/c/624778/

That will avoid joining on some other tables depending on your 
configuration. It would be great if you could see if that helps resolve 
your issue. I think you just reverted 
https://review.openstack.org/#/c/276861/ as a workaround but it would be 
good to know if a more permanent fix (mine) gets you similar, or at 
least satisfactory, results.

[1] 
http://lists.openstack.org/pipermail/openstack-dev/2018-October/thread.html#135941

-- 

Thanks,

Matt