• [udd] Blends query runs into: terminating connection due to administrat

    From Andreas Tille@21:1/5 to All on Mon Nov 22 10:30:01 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lucas Nussbaum@21:1/5 to Andreas Tille on Mon Nov 22 11:40:01 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Andreas Tille@21:1/5 to All on Mon Nov 22 13:30:01 2021
    Hi Lucas,

    Am Mon, Nov 22, 2021 at 11:30:08AM +0100 schrieb Lucas Nussbaum:
    Hi,

    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?

    It is against UDD.

    Kind regards

    Andreas.

    --
    http://fam-tille.de

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Andreas Tille@21:1/5 to All on Fri Nov 26 08:30:01 2021
    Am Mon, Nov 22, 2021 at 01:28:24PM +0100 schrieb Andreas Tille:
    Hi Lucas,

    Am Mon, Nov 22, 2021 at 11:30:08AM +0100 schrieb Lucas Nussbaum:
    Hi,

    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?

    It is against UDD.

    Any news about this?

    Kind regards
    Andreas.

    --
    http://fam-tille.de

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Andreas Tille@21:1/5 to All on Thu Dec 2 20:50:01 2021
    Ping,
    we just discussed in our Debian Med video conference whether
    there is some chance to throw money against upgrading the
    hardware of the machine running UDD. What do you think about
    this?
    Kind regards
    Andreas.

    Am Fri, Nov 26, 2021 at 08:22:06AM +0100 schrieb Andreas Tille:
    Am Mon, Nov 22, 2021 at 01:28:24PM +0100 schrieb Andreas Tille:
    Hi Lucas,

    Am Mon, Nov 22, 2021 at 11:30:08AM +0100 schrieb Lucas Nussbaum:
    Hi,

    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?

    It is against UDD.

    Any news about this?

    Kind regards
    Andreas.

    --
    http://fam-tille.de



    --
    http://fam-tille.de

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lucas Nussbaum@21:1/5 to Andreas Tille on Thu Dec 2 21:20:01 2021
    Hi,

    On 02/12/21 at 20:48 +0100, Andreas Tille wrote:
    Ping,
    we just discussed in our Debian Med video conference whether
    there is some chance to throw money against upgrading the
    hardware of the machine running UDD. What do you think about
    this?
    Kind regards
    Andreas.

    You should probably talk to DSA.

    Lucas

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)