Build failed in Jenkins: reproducible_scheduler_amd64 #28

jenkins at jenkins.debian.net jenkins at jenkins.debian.net
Mon Jul 10 21:04:36 BST 2023 

See <https://jenkins.debian.net/job/reproducible_scheduler_amd64/28/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_amd64/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins11571631791709230856.sh
+ /srv/jenkins/bin/reproducible_scheduler.py amd64
/srv/jenkins/bin/reproducible_scheduler.py:15: DeprecationWarning: please use 'debian.deb822' instead
  import deb822
[2023-07-10 20:00:00] INFO: Starting at 2023-07-10 20:00:00.537438
[2023-07-10 20:00:00] INFO: Updating sources tables for all suites.
[2023-07-10 20:00:00] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2023-07-10 20:00:02] INFO: Updating sources db for unstable/amd64...
/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 20:00:31] INFO: Pushing 0 updated packages to the database...
[2023-07-10 20:01:03] INFO: Now deleting 0 removed packages: []
[2023-07-10 20:01:03] INFO: DB update done for unstable/amd64 done at 2023-07-10 20:01:03.
[2023-07-10 20:01:03] INFO: Sources for suite unstable/amd64 updated at 2023-07-10 20:01:03.
[2023-07-10 20:01:03] INFO: Removing old pages from unstable/amd64.
[2023-07-10 20:01:03] INFO: Removing old pages from unstable/amd64/diffoscope-results/.
[2023-07-10 20:01:03] INFO: Downloading sources file for trixie: http://deb.debian.org/debian/dists/trixie/main/source/Sources.xz
[2023-07-10 20:01:05] INFO: Updating sources db for trixie/amd64...
[2023-07-10 20:01:30] INFO: Pushing 0 updated packages to the database...
[2023-07-10 20:02:03] INFO: Now deleting 0 removed packages: []
[2023-07-10 20:02:03] INFO: DB update done for trixie/amd64 done at 2023-07-10 20:02:03.
[2023-07-10 20:02:03] INFO: Sources for suite trixie/amd64 updated at 2023-07-10 20:02:03.
[2023-07-10 20:02:03] INFO: Removing old pages from trixie/amd64.
[2023-07-10 20:02:04] INFO: Removing old pages from trixie/amd64/diffoscope-results/.
[2023-07-10 20:02:04] INFO: Downloading sources file for bookworm: http://deb.debian.org/debian/dists/bookworm/main/source/Sources.xz
[2023-07-10 20:02:05] INFO: Updating sources db for bookworm/amd64...
[2023-07-10 20:02:31] INFO: Pushing 0 updated packages to the database...
[2023-07-10 20:03:03] INFO: Now deleting 0 removed packages: []
[2023-07-10 20:03:03] INFO: DB update done for bookworm/amd64 done at 2023-07-10 20:03:03.
[2023-07-10 20:03:03] INFO: Sources for suite bookworm/amd64 updated at 2023-07-10 20:03:03.
[2023-07-10 20:03:03] INFO: Removing old pages from bookworm/amd64.
[2023-07-10 20:03:03] INFO: Removing old pages from bookworm/amd64/diffoscope-results/.
[2023-07-10 20:03:03] INFO: Downloading sources file for bullseye: http://deb.debian.org/debian/dists/bullseye/main/source/Sources.xz
[2023-07-10 20:03:05] INFO: Updating sources db for bullseye/amd64...
[2023-07-10 20:03:27] INFO: Pushing 0 updated packages to the database...
[2023-07-10 20:03:51] INFO: Now deleting 0 removed packages: []
[2023-07-10 20:03:51] INFO: DB update done for bullseye/amd64 done at 2023-07-10 20:03:51.
[2023-07-10 20:03:51] INFO: Sources for suite bullseye/amd64 updated at 2023-07-10 20:03:51.
[2023-07-10 20:03:51] INFO: Removing old pages from bullseye/amd64.
[2023-07-10 20:03:51] INFO: Removing old pages from bullseye/amd64/diffoscope-results/.
[2023-07-10 20:03:51] INFO: Downloading sources file for buster: http://deb.debian.org/debian/dists/buster/main/source/Sources.xz
[2023-07-10 20:03:52] INFO: Updating sources db for buster/amd64...
[2023-07-10 20:04:14] INFO: Pushing 0 updated packages to the database...
[2023-07-10 20:04:33] INFO: Now deleting 0 removed packages: []
[2023-07-10 20:04:33] INFO: DB update done for buster/amd64 done at 2023-07-10 20:04:33.
[2023-07-10 20:04:33] INFO: Sources for suite buster/amd64 updated at 2023-07-10 20:04:33.
[2023-07-10 20:04:33] INFO: Removing old pages from buster/amd64.
[2023-07-10 20:04:34] INFO: Removing old pages from buster/amd64/diffoscope-results/.
[2023-07-10 20:04:34] INFO: Downloading sources file for experimental: http://deb.debian.org/debian/dists/experimental/main/source/Sources.xz
[2023-07-10 20:04:34] INFO: Updating sources db for experimental/amd64...
[2023-07-10 20:04:35] INFO: Pushing 0 updated packages to the database...
[2023-07-10 20:04:35] INFO: Now deleting 0 removed packages: []
[2023-07-10 20:04:35] INFO: DB update done for experimental/amd64 done at 2023-07-10 20:04:35.
[2023-07-10 20:04:35] INFO: Sources for suite experimental/amd64 updated at 2023-07-10 20:04:35.
[2023-07-10 20:04:35] INFO: Removing old pages from experimental/amd64.
[2023-07-10 20:04:35] INFO: Removing old pages from experimental/amd64/diffoscope-results/.
[2023-07-10 20:04:35] INFO: Scheduling for amd64...
[2023-07-10 20:04:35] INFO: 1855 packages already scheduled for amd64, probably scheduling some more...
[2023-07-10 20:04:36] INFO: ==============================================================
[2023-07-10 20:04:36] INFO: Currently scheduled packages in all suites on amd64: 1855
[2023-07-10 20:04:36] INFO: 1855 packages already scheduled, scheduling some more...
[2023-07-10 20:04:36] INFO: Requesting 255 untested packages in unstable/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.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='amd64'
                    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 20:04:36] INFO: Finished at 2023-07-10 20:04:36.035718, took: 0:04:35.498284
Build step 'Execute shell' marked build as failure

More information about the Qa-jenkins-scm mailing list