Build failed in Jenkins: reproducible_html_live_status #493502

[jenkins at jenkins.debian.net]

See <https://jenkins.debian.net/job/reproducible_html_live_status/493502/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/jenkins7324133728947581411.sh
+ /srv/jenkins/bin/reproducible_html_live_status.py
[2024-03-05 10:37:01] INFO: Starting at 2024-03-05 10:37:01.209511
[2024-03-05 10:37:01] INFO: Building the schedule index page for amd64...
/srv/jenkins/bin/reproducible_html_live_status.py:57: SADeprecationWarning: The SelectBase.as_scalar() method is deprecated and will be removed in a future release.  Please refer to SelectBase.scalar_subquery(). (deprecated since: 1.4)
  ).as_scalar()
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
psycopg2.OperationalError: 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 1380, in execute
    return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
    return connection._execute_clauseelement(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
    util.raise_(
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) 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_1)s, %(status_1_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, 'arch': 'amd64', 'status_1_1': 'reproducible', 'status_1_2': 'FTBR'}]
(Background on this error at: https://sqlalche.me/e/14/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 218, 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
[2024-03-05 10:47:24] INFO: Finished at 2024-03-05 10:47:24.168404, took: 0:10:22.963331
Build step 'Execute shell' marked build as failure