Build failed in Jenkins: reproducible_html_breakages #4349

[jenkins at jenkins.debian.net]

See <https://jenkins.debian.net/job/reproducible_html_breakages/4349/display/redirect>

Changes:


------------------------------------------
Started by user Holger Levsen
Running as SYSTEM
[EnvInject] - Loading node environment variables.
Building on the built-in node in workspace <https://jenkins.debian.net/job/reproducible_html_breakages/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins14706400350083345626.sh
+ /srv/jenkins/bin/reproducible_html_breakages.py
[2023-11-07 12:11:21] INFO: Starting at 2023-11-07 12:11:21.182783
[2023-11-07 12:11:21] INFO: running unrep_with_dbd_issues check...
--- Logging error ---
Traceback (most recent call last):
  File "/usr/lib/python3.11/logging/__init__.py", line 1110, in emit
    msg = self.format(record)
          ^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.11/logging/__init__.py", line 953, in format
    return fmt.format(record)
           ^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.11/logging/__init__.py", line 687, in format
    record.message = record.getMessage()
                     ^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.11/logging/__init__.py", line 377, in getMessage
    msg = msg % self.args
          ~~~~^~~~~~~~~~~
TypeError: not all arguments converted during string formatting
Call stack:
  File "/srv/jenkins/bin/reproducible_html_breakages.py", line 423, in <module>
    breakages = gen_html()
  File "/srv/jenkins/bin/reproducible_html_breakages.py", line 370, in gen_html
    without_dbd, bad_dbd, sources_without_dbd = unrep_with_dbd_issues()
  File "/srv/jenkins/bin/reproducible_html_breakages.py", line 45, in unrep_with_dbd_issues
    log.info(query, ARCHIVED_SUITES)
Message: "SELECT s.name, r.version, s.suite, s.architecture\n               FROM sources AS s JOIN results AS r ON r.package_id=s.id\n               WHERE r.status='FTBR'\n               AND s.distribution = (SELECT id FROM distributions WHERE name = 'debian')\n               AND s.suite NOT IN (buster, stretch)\n               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC"
Arguments: (['buster', 'stretch'],)
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.errors.UndefinedColumn: column "buster" does not exist
LINE 5:                AND s.suite NOT IN (buster, stretch)
                                           ^
HINT:  Perhaps you meant to reference the column "s.suite".


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

Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_html_breakages.py", line 423, in <module>
    breakages = gen_html()
                ^^^^^^^^^^
  File "/srv/jenkins/bin/reproducible_html_breakages.py", line 370, in gen_html
    without_dbd, bad_dbd, sources_without_dbd = unrep_with_dbd_issues()
                                                ^^^^^^^^^^^^^^^^^^^^^^^
  File "/srv/jenkins/bin/reproducible_html_breakages.py", line 46, in unrep_with_dbd_issues
    results = query_db(query)
              ^^^^^^^^^^^^^^^
  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 1365, in execute
    return self._exec_driver_sql(
           ^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1669, in _exec_driver_sql
    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.ProgrammingError: (psycopg2.errors.UndefinedColumn) column "buster" does not exist
LINE 5:                AND s.suite NOT IN (buster, stretch)
                                           ^
HINT:  Perhaps you meant to reference the column "s.suite".

[SQL: SELECT s.name, r.version, s.suite, s.architecture
               FROM sources AS s JOIN results AS r ON r.package_id=s.id
               WHERE r.status='FTBR'
               AND s.distribution = (SELECT id FROM distributions WHERE name = 'debian')
               AND s.suite NOT IN (buster, stretch)
               ORDER BY s.name ASC, s.suite DESC, s.architecture ASC]
(Background on this error at: https://sqlalche.me/e/14/f405)
[2023-11-07 12:11:21] INFO: Finished at 2023-11-07 12:11:21.269879, took: 0:00:00.087101
Build step 'Execute shell' marked build as failure