Build failed in Jenkins: reproducible_html_live_status #473726

[jenkins at jenkins.debian.net]

See <https://jenkins.debian.net/job/reproducible_html_live_status/473726/display/redirect>

Changes:


------------------------------------------
Started by timer
Running as SYSTEM
[EnvInject] - Loading node environment variables.
Building on the built-in node in workspace <https://jenkins.debian.net/job/reproducible_html_live_status/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins17479400511406424011.sh
+ /srv/jenkins/bin/reproducible_html_live_status.py
[2023-07-22 15:52:00] INFO: Starting at 2023-07-22 15:52:00.695784
[2023-07-22 15:52:01] INFO: Building the schedule index page for amd64...
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.AdminShutdown: terminating connection due to administrator command
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/srv/jenkins/bin/rblib/__init__.py", line 43, in query_db
    result = conn_db.execute(query, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.errors.AdminShutdown) terminating connection due to administrator command
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

[SQL: SELECT schedule.date_scheduled, sources.suite, sources.architecture, sources.name, results.status, results.build_duration, (SELECT coalesce(avg(CAST(stats_build.build_duration AS INTEGER)), %(coalesce_2)s) AS coalesce_1 
FROM stats_build 
WHERE stats_build.status IN (%(status_1)s, %(status_2)s) AND stats_build.name = sources.name AND stats_build.suite = sources.suite AND stats_build.architecture = sources.architecture) AS anon_1 
FROM sources JOIN schedule ON sources.id = schedule.package_id LEFT OUTER JOIN results ON sources.id = results.package_id 
WHERE schedule.date_build_started IS NULL AND sources.architecture = %(arch)s ORDER BY schedule.date_scheduled]
[parameters: {'coalesce_2': 0, 'status_1': 'reproducible', 'status_2': 'FTBR', 'arch': 'amd64'}]
(Background on this error at: http://sqlalche.me/e/13/e3q8)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_html_live_status.py", line 210, in <module>
    generate_schedule(arch)
  File "/srv/jenkins/bin/reproducible_html_live_status.py", line 80, in generate_schedule
    rows = query_db(query.params({'arch': arch}))
  File "/srv/jenkins/bin/rblib/__init__.py", line 45, in query_db
    print_critical_message('Error executing this query:\n' + query)
TypeError: can only concatenate str (not "Select") to str
[2023-07-22 15:53:40] INFO: Finished at 2023-07-22 15:53:40.432141, took: 0:01:39.736366
Build step 'Execute shell' marked build as failure