Build failed in Jenkins: reproducible_scheduler_armhf #23

[jenkins at jenkins.debian.net]

See <https://jenkins.debian.net/job/reproducible_scheduler_armhf/23/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_scheduler_armhf/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins9461676097809055228.sh
+ /srv/jenkins/bin/reproducible_scheduler.py armhf
/srv/jenkins/bin/reproducible_scheduler.py:15: DeprecationWarning: please use 'debian.deb822' instead
  import deb822
[2023-07-10 19:30:00] INFO: Starting at 2023-07-10 19:30:00.662552
[2023-07-10 19:30:00] INFO: Updating sources tables for all suites.
[2023-07-10 19:30:00] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2023-07-10 19:30:02] INFO: Updating sources db for unstable/armhf...
/usr/lib/python3/dist-packages/debian/deb822.py:748: UserWarning: Parsing of Deb822 data with python-apt's apt_pkg was requested but this cannot be done on non-file input.
  warnings.warn(msg)
[2023-07-10 19:30:28] INFO: Pushing 0 updated packages to the database...
[2023-07-10 19:31:02] INFO: Now deleting 0 removed packages: []
[2023-07-10 19:31:02] INFO: DB update done for unstable/armhf done at 2023-07-10 19:31:02.
[2023-07-10 19:31:02] INFO: Sources for suite unstable/armhf updated at 2023-07-10 19:31:02.
[2023-07-10 19:31:02] INFO: Removing old pages from unstable/armhf.
[2023-07-10 19:31:03] INFO: Removing old pages from unstable/armhf/diffoscope-results/.
[2023-07-10 19:31:03] INFO: Downloading sources file for trixie: http://deb.debian.org/debian/dists/trixie/main/source/Sources.xz
[2023-07-10 19:31:04] INFO: Updating sources db for trixie/armhf...
[2023-07-10 19:31:32] INFO: Pushing 0 updated packages to the database...
[2023-07-10 19:32:02] INFO: Now deleting 0 removed packages: []
[2023-07-10 19:32:02] INFO: DB update done for trixie/armhf done at 2023-07-10 19:32:02.
[2023-07-10 19:32:02] INFO: Sources for suite trixie/armhf updated at 2023-07-10 19:32:02.
[2023-07-10 19:32:02] INFO: Removing old pages from trixie/armhf.
[2023-07-10 19:32:02] INFO: Removing old pages from trixie/armhf/diffoscope-results/.
[2023-07-10 19:32:02] INFO: Downloading sources file for bookworm: http://deb.debian.org/debian/dists/bookworm/main/source/Sources.xz
[2023-07-10 19:32:04] INFO: Updating sources db for bookworm/armhf...
[2023-07-10 19:32:29] INFO: Pushing 0 updated packages to the database...
[2023-07-10 19:32:57] INFO: Now deleting 0 removed packages: []
[2023-07-10 19:32:57] INFO: DB update done for bookworm/armhf done at 2023-07-10 19:32:57.
[2023-07-10 19:32:57] INFO: Sources for suite bookworm/armhf updated at 2023-07-10 19:32:57.
[2023-07-10 19:32:57] INFO: Removing old pages from bookworm/armhf.
[2023-07-10 19:32:57] INFO: Removing old pages from bookworm/armhf/diffoscope-results/.
[2023-07-10 19:32:57] INFO: Downloading sources file for bullseye: http://deb.debian.org/debian/dists/bullseye/main/source/Sources.xz
[2023-07-10 19:32:59] INFO: Updating sources db for bullseye/armhf...
[2023-07-10 19:33:21] INFO: Pushing 0 updated packages to the database...
[2023-07-10 19:33:44] INFO: Now deleting 0 removed packages: []
[2023-07-10 19:33:44] INFO: DB update done for bullseye/armhf done at 2023-07-10 19:33:44.
[2023-07-10 19:33:44] INFO: Sources for suite bullseye/armhf updated at 2023-07-10 19:33:44.
[2023-07-10 19:33:44] INFO: Removing old pages from bullseye/armhf.
[2023-07-10 19:33:45] INFO: Removing old pages from bullseye/armhf/diffoscope-results/.
[2023-07-10 19:33:45] INFO: Downloading sources file for buster: http://deb.debian.org/debian/dists/buster/main/source/Sources.xz
[2023-07-10 19:33:46] INFO: Updating sources db for buster/armhf...
[2023-07-10 19:34:08] INFO: Pushing 0 updated packages to the database...
[2023-07-10 19:34:26] INFO: Now deleting 0 removed packages: []
[2023-07-10 19:34:26] INFO: DB update done for buster/armhf done at 2023-07-10 19:34:26.
[2023-07-10 19:34:26] INFO: Sources for suite buster/armhf updated at 2023-07-10 19:34:26.
[2023-07-10 19:34:26] INFO: Removing old pages from buster/armhf.
[2023-07-10 19:34:26] INFO: Removing old pages from buster/armhf/diffoscope-results/.
[2023-07-10 19:34:26] INFO: Downloading sources file for experimental: http://deb.debian.org/debian/dists/experimental/main/source/Sources.xz
[2023-07-10 19:34:26] INFO: Updating sources db for experimental/armhf...
[2023-07-10 19:34:28] INFO: Pushing 0 updated packages to the database...
[2023-07-10 19:34:28] INFO: Now deleting 0 removed packages: []
[2023-07-10 19:34:28] INFO: DB update done for experimental/armhf done at 2023-07-10 19:34:28.
[2023-07-10 19:34:28] INFO: Sources for suite experimental/armhf updated at 2023-07-10 19:34:28.
[2023-07-10 19:34:28] INFO: Removing old pages from experimental/armhf.
[2023-07-10 19:34:28] INFO: Removing old pages from experimental/armhf/diffoscope-results/.
[2023-07-10 19:34:28] INFO: Scheduling for armhf...
[2023-07-10 19:34:28] INFO: 1695 packages already scheduled for armhf, probably scheduling some more...
[2023-07-10 19:34:28] INFO: ==============================================================
[2023-07-10 19:34:28] INFO: Currently scheduled packages in all suites on armhf: 1695
[2023-07-10 19:34:28] INFO: 1695 packages already scheduled, scheduling some more...
[2023-07-10 19:34:28] INFO: Requesting 255 untested packages in unstable/armhf...
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.SyntaxError: syntax error at or near "AND"
LINE 8:                        (SELECT FROM results AND sources.id =...
                                                    ^


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

Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 813, in <module>
    message += scheduler(arch)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 737, in scheduler
    untested, msg_untested = schedule_untested_packages(arch, total)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 607, in schedule_untested_packages
    packages[suite] = query_untested_packages(suite, arch, many_untested)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 495, in query_untested_packages
    packages = 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 1003, in execute
    return self._execute_text(object_, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1172, in _execute_text
    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.ProgrammingError: (psycopg2.errors.SyntaxError) syntax error at or near "AND"
LINE 8:                        (SELECT FROM results AND sources.id =...
                                                    ^

[SQL: SELECT DISTINCT *
               FROM (
                    SELECT sources.id, sources.name FROM sources
                    WHERE sources.suite='unstable' AND sources.architecture='armhf'
                    AND NOT exists
                       (SELECT schedule.package_id FROM schedule WHERE build_type='ci_build' AND sources.id = schedule.package_id )
                    AND NOT exists
                       (SELECT FROM results AND sources.id = results.package_id )
                    ORDER BY random()
                ) AS tmp
                LIMIT 255]
(Background on this error at: http://sqlalche.me/e/13/f405)
[2023-07-10 19:34:28] INFO: Finished at 2023-07-10 19:34:28.503766, took: 0:04:27.841218
Build step 'Execute shell' marked build as failure