[Qa-jenkins-scm] Build failed in Jenkins: reproducible_html_live_status #402589

[jenkins at jenkins.debian.net]

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

Changes:


------------------------------------------
Started by timer
Running as SYSTEM
[EnvInject] - Loading node environment variables.
Building on master in workspace <https://jenkins.debian.net/job/reproducible_html_live_status/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins6190983869330732411.sh
+ /srv/jenkins/bin/reproducible_html_live_status.py
[2021-05-14 08:39:57] INFO: Starting at 2021-05-14 08:39:57.265299
[2021-05-14 08:39:57] INFO: Building the schedule index page for amd64...
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 536, in do_execute
    cursor.execute(statement, parameters)
psycopg2.OperationalError: 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 980, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
    distilled_params,
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1458, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 276, in reraise
    raise value.with_traceback(tb)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 536, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) 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 \nFROM stats_build \nWHERE 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 \nFROM sources JOIN schedule ON sources.id = schedule.package_id LEFT OUTER JOIN results ON sources.id = results.package_id \nWHERE 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/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
[2021-05-14 08:41:50] INFO: Finished at 2021-05-14 08:41:50.625382, took: 0:01:53.360099
Build step 'Execute shell' marked build as failure