Re: [udd] Blends query runs into: terminating connection due to administrator command
Hi,
On 22/11/21 at 10:24 +0100, Andreas Tille wrote:
> 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.
Can you clarify if it's about UDD or the mirror?
Lucas
Reply to: