[udd] Blends query runs into: terminating connection due to administrator command

[Andreas Tille <andreas@an3as.eu>]

Hi,

since some time the Debian Med packages are not updated any more.  The
output of the job can be found in the logfile[1]:


Traceback (most recent call last):
  File "./tasks.py", line 28, in <module>
    tasks.GetAllDependencies()
  File "/srv/blends.debian.org/webtools/blendstasktools.py", line 937, in GetAllDependencies
    if td.GetTaskDependencies(source):
  File "/srv/blends.debian.org/webtools/blendstasktools.py", line 1380, in GetTaskDependencies
    _execute_udd_query(query)
  File "/srv/blends.debian.org/webtools/blendstasktools.py", line 307, in _execute_udd_query
    curs.execute(query)
psycopg2.OperationalError: terminating connection due to administrator command
CONTEXT:  SQL function "blends_query_packages" statement 1
SSL connection has been closed unexpectedly


I admit the query is a bit complex and deals with a couple of data.
Is there any chance to bump the performance of the database server
to deal with this kind of queries?  Any other idea how to solve the
issue would be really welcome.

I'm observing this issue since about one week - not really sure about
the exact time.

Kind regards

     Andreas.


[1] https://blends.debian.org/_logs/debian-med.err

-- 
http://fam-tille.de