From 2e043a5a785b452f8f7fcb104b12c0746ca4a513 Mon Sep 17 00:00:00 2001
From: Gary Kotton <gkotton@redhat.com>
Date: Sun, 9 Dec 2012 06:33:13 +0000
Subject: [PATCH] Prevent unnecessary database read by l3 agent

Fixes bug 1088129

Change-Id: I887facf321f3267c16c101a1448827f6c046bb2c
---
 quantum/db/l3_db.py | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/quantum/db/l3_db.py b/quantum/db/l3_db.py
index 10a51a4c2..04a7a8f22 100644
--- a/quantum/db/l3_db.py
+++ b/quantum/db/l3_db.py
@@ -864,6 +864,8 @@ class L3_NAT_db_mixin(l3.RouterPluginBase):
             my_ports = subnet_id_ports_dict.get(fixed_ip['subnet_id'], [])
             my_ports.append(port)
             subnet_id_ports_dict[fixed_ip['subnet_id']] = my_ports
+        if not subnet_id_ports_dict:
+            return
         filters = {'id': subnet_id_ports_dict.keys()}
         fields = ['id', 'cidr', 'gateway_ip']
         subnet_dicts = self.get_subnets(context, filters, fields)
-- 
2.45.2