info_instance_caches table

There are some bugs floating around which is causing the instance_ info_cache table to be have the network_info field will be populated with a super helpful []. And nova being the badass as it is, relies on a table containing the word “cache” to function properly …..

After digging around, trying to hack in ways to get nova to regenerate this field and ended up recreating it manually. The format is fairly straight forward, but if you have a lot of fixed IPs attached to an instance, this is going to be a bitch. Here is what I ended up needing to manually recreate. Post picture related.

1
[{"profile": {}, "ovs_interfaceid": null, "network": {"bridge": "brqe2d86ec5-aa", "subnets": [{"ips": [{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.16.169"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.16.17"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.17.22"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.17.34"}], "version": 4, "meta": {}, "dns": [], "routes": [], "cidr": "192.168.16.0/23", "gateway": {"meta": {}, "version": 4, "type": "gateway", "address": "192.168.16.1"}}, {"ips": [{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.121"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.119"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.144"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.149"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.61"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.177.10"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.177.20"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.177.25"}], "version": 4, "meta": {}, "dns": [], "routes": [], "cidr": "192.168.177.0/23", "gateway": {"meta": {}, "version": 4, "type": "gateway", "address": "192.168.176.1"}}, {"ips": [{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.22.203"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.22.209"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.22.214"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.23.92"}, {"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.23.92"}], "version": 4, "meta": {}, "dns": [], "routes": [], "cidr": "192.168.22.0/23", "gateway": {"meta": {}, "version": 4, "type": "gateway", "address": "192.168.22.1"}}], "meta": {"injected": false, "tenant_id": "8ec07362a659476ab4d60f87235bc6a6", "should_create_bridge": true}, "id": "e2d86ec5-aa96-4fea-86df-703c6fb18fc3", "label": "shared_public"}, "devname": "tapf97ce23c-08", "vnic_type": "normal", "qbh_params": null, "meta": {}, "details": {"port_filter": true}, "address": "fa:ke:sh:it:00:f2", "active": true, "type": "bridge", "id": "f97ce23c-0868-45e6-b90b-2c45184de069", "qbg_params": null}]

So, for future reference, this is the basic layout

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
[{"profile": {}, "ovs_interfaceid": null, "network": {"bridge": "brqe2d86ec5-aa", "subnets":
[{"ips": [
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.16.169"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.16.17"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.17.22"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.17.34"}],
"version": 4, "meta": {}, "dns": [], "routes": [], "cidr": "192.168.16.0/23", "gateway": {"meta": {}, "version": 4, "type": "gateway", "address": "192.168.16.1"}},

{"ips": [
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.121"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.119"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.144"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.149"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.176.61"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.177.10"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.177.20"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.177.25"}],
"version": 4, "meta": {}, "dns": [], "routes": [], "cidr": "192.168.177.0/23", "gateway": {"meta": {}, "version": 4, "type": "gateway", "address": "192.168.176.1"}},
{"ips": [
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.22.203"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.22.209"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.22.214"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.23.92"},
{"meta": {}, "version": 4, "type": "fixed", "floating_ips": [], "address": "192.168.23.92"}],
"version": 4, "meta": {}, "dns": [], "routes": [], "cidr": "192.168.22.0/23", "gateway": {"meta": {}, "version": 4, "type": "gateway", "address": "192.168.22.1"}}],

"meta": {"injected": false, "tenant_id": "8ec07362a659476ab4d60f87235bc6a6", "should_create_bridge": true}, "id": "e2d86ec5-aa96-4fea-86df-703c6fb18fc3", "label": "shared_public"}, "devname": "tapf97ce23c-08", "vnic_type": "normal", "qbh_params": null, "meta": {}, "details": {"port_filter": true}, "address": "fa:ke:sh:it:00:f2", "active": true, "type": "bridge", "id": "f97ce23c-0868-45e6-b90b-2c45184de069", "qbg_params": null}]