Changeset 302 for trunk/packages

Timestamp:

Mar 28, 2008, 10:19:05 PM (17 years ago)

Author:

ecprice

Message:

Work around stale database connections (#4) in the DNS server

File:

• trunk/packages/sipb-xen-dns/code/dnsserver.py (modified) (2 diffs)

trunk/packages/sipb-xen-dns/code/dnsserver.py

@@ -8 +8 @@
 
 import sipb_xen_database
+import psycopg2
+import sqlalchemy
+import time
 
 class DatabaseAuthority(common.ResolverBase):
@@ -24 +27 @@
                                   expire=3600000, minimum=21600, ttl=3600)
     def _lookup(self, name, cls, type, timeout = None):
+        for i in range(3):
+            try:
+                value = self._lookup_unsafe(name, cls, type, timeout = None)
+            except (psycopg2.OperationalError, sqlalchemy.exceptions.SQLError):
+                if i == 2:
+                    raise
+                print "Reloading database"
+                time.sleep(0.5)
+                continue
+            else:
+                return value
+
+    def _lookup_unsafe(self, name, cls, type, timeout):
         sipb_xen_database.clear_cache()
         if not (name.lower() == self.domain or