Build failed in Jenkins: reproducible_scheduler_arm64 #3282

Mon Apr 7 01:02:11 BST 2025

See <https://jenkins.debian.net/job/reproducible_scheduler_arm64/3282/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_arm64/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins1685807194873271550.sh
+ /srv/jenkins/bin/reproducible_scheduler.py arm64
/srv/jenkins/bin/reproducible_scheduler.py:15: DeprecationWarning: please use 'debian.deb822' instead
  import deb822
[2025-04-07 00:00:03] INFO: Starting at 2025-04-07 00:00:03.102397
[2025-04-07 00:00:03] INFO: Updating sources tables for all suites.
[2025-04-07 00:00:03] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2025-04-07 00:00:04] INFO: Updating sources db for unstable/arm64...
/usr/lib/python3/dist-packages/debian/deb822.py:734: UserWarning: Parsing of Deb822 data with python3-apt's apt_pkg was requested but this cannot be done on non-file input.
  warnings.warn(msg)
[2025-04-07 00:00:23] INFO: Pushing 65 updated packages to the database...
[2025-04-07 00:00:23] INFO: Now inserting 1 new sources in the database: [{'name': 'boost1.88', 'version': '1.88.0~beta1-1', 'suite': 'unstable', 'architecture': 'arm64'}]
[2025-04-07 00:01:15] INFO: Now deleting 0 removed packages: []
[2025-04-07 00:01:15] INFO: Building pages for the new packages
[2025-04-07 00:01:15] INFO: Generating the pages of 1 package(s)
[2025-04-07 00:01:15] INFO: DB update done for unstable/arm64 done at 2025-04-07 00:01:15.
[2025-04-07 00:01:15] INFO: Sources for suite unstable/arm64 updated at 2025-04-07 00:01:15.
[2025-04-07 00:01:15] INFO: Removing old pages from unstable/arm64.
[2025-04-07 00:01:16] INFO: Removing old pages from unstable/arm64/diffoscope-results/.
[2025-04-07 00:01:16] INFO: Downloading sources file for trixie: http://deb.debian.org/debian/dists/trixie/main/source/Sources.xz
[2025-04-07 00:01:17] INFO: Updating sources db for trixie/arm64...
[2025-04-07 00:01:35] INFO: Pushing 5 updated packages to the database...
[2025-04-07 00:01:35] INFO: Now inserting 5 new sources in the database: [{'name': 'antpm', 'version': '1.24-1', 'suite': 'trixie', 'architecture': 'arm64'}, {'name': 'denemo', 'version': '2.6.39-0.1', 'suite': 'trixie', 'architecture': 'arm64'}, {'name': 'lamassemble', 'version': '1.7.2-2', 'suite': 'trixie', 'architecture': 'arm64'}, {'name': 'last-align', 'version': '1609-1', 'suite': 'trixie', 'architecture': 'arm64'}, {'name': 'procdump', 'version': '2.2-4', 'suite': 'trixie', 'architecture': 'arm64'}]
[2025-04-07 00:02:10] INFO: Now deleting 5 removed packages: ['ruby-opentracing', 'ruby-thrift', 'libbson-xs-perl', 'rust-sequoia-keyring-linter', 'ruby-appraisal']
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1880, in _execute_context
    self.dialect.do_executemany(
  File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 1000, in do_executemany
    cursor.executemany(statement, parameters)
psycopg2.errors.ForeignKeyViolation: update or delete on table "sources" violates foreign key constraint "notes_package_id_fkey" on table "notes"
DETAIL:  Key (id)=(4033264) is still referenced from table "notes".

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

Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 830, in <module>
    update_sources(suite, arch)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 284, in update_sources
    update_sources_db(suite, arch, sources)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 408, in update_sources_db
    conn_db.execute(delete_sources_query, rmed_pkgs_id)
  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 1880, in _execute_context
    self.dialect.do_executemany(
  File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 1000, in do_executemany
    cursor.executemany(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.errors.ForeignKeyViolation) update or delete on table "sources" violates foreign key constraint "notes_package_id_fkey" on table "notes"
DETAIL:  Key (id)=(4033264) is still referenced from table "notes".

[SQL: DELETE FROM sources WHERE sources.id = %(deleteid)s]
[parameters: ({'deleteid': 4033131}, {'deleteid': 4033264}, {'deleteid': 4053898}, {'deleteid': 4034083}, {'deleteid': 4039201})]
(Background on this error at: https://sqlalche.me/e/14/gkpj)
[2025-04-07 00:02:11] INFO: Finished at 2025-04-07 00:02:11.157410, took: 0:02:08.055022
Build step 'Execute shell' marked build as failure