[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #38116

[jenkins at jenkins.debian.net]

See <https://jenkins.debian.net/job/reproducible_scheduler/38116/display/redirect>

Changes:


------------------------------------------
Started by timer
Started by timer
Started by timer
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/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins3575501165246277905.sh
+ /srv/jenkins/bin/reproducible_scheduler.py
/srv/jenkins/bin/reproducible_scheduler.py:15: DeprecationWarning: please use 'debian.deb822' instead
  import deb822
[2023-03-22 02:40:36] INFO: Starting at 2023-03-22 02:40:36.214022
[2023-03-22 02:40:38] INFO: Updating sources tables for all suites.
[2023-03-22 02:40:38] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2023-03-22 02:40:42] 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-03-22 02:41:16] INFO: Pushing 11 updated packages to the database...
[2023-03-22 02:42:12] INFO: Now deleting 6 removed packages: ['sendpage', 'sqlite', 'kannel-sqlbox', 'tootle', 'ruby-jeweler', 'ruby-github-api']
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1256, in _execute_context
    self.dialect.do_executemany(
  File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 898, 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)=(7077) 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 781, in <module>
    update_sources(suite)
  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 404, in update_sources_db
    conn_db.execute(delete_sources_query, rmed_pkgs_id)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    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 1256, in _execute_context
    self.dialect.do_executemany(
  File "/usr/lib/python3/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 898, 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)=(7077) is still referenced from table "notes".

[SQL: DELETE FROM sources WHERE sources.id = %(deleteid)s]
[parameters: ({'deleteid': 18400}, {'deleteid': 18940}, {'deleteid': 7077}, {'deleteid': 391842}, {'deleteid': 102871}, {'deleteid': 164688})]
(Background on this error at: http://sqlalche.me/e/13/gkpj)
[2023-03-22 02:42:20] INFO: Finished at 2023-03-22 02:42:20.628031, took: 0:01:44.414017
Build step 'Execute shell' marked build as failure