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#... -- Thanks, Matt