reproducible: common.py: catch psycopg2.OperationalError when the connection timeouts in start_udd_connection to output a useful error message

1 files changed, 9 insertions, 0 deletions

diff --git a/bin/reproducible_common.py b/bin/reproducible_common.py
index c1475117..6ddcf398 100755
--- a/bin/reproducible_common.py
+++ b/bin/reproducible_common.py
@@ -328,6 +328,15 @@ def start_udd_connection():
             password=password,
             connect_timeout=5,
         )
+    except psycopg2.OperationalError as err:
+        if str(err) == 'timeout expired\n':
+            log.error('Connection to the UDD database replice timed out. '
+                      'Probably the machine is offline or just unavailable.')
+            log.error('Failing nicely anyway, all queries will return an '
+                      'empty response.')
+            return None
+        else:
+            raise
     except:
         log.error('Erorr connecting to the UDD database replica.' +
                   'The full error is:')