Started by an SCM change
Running as SYSTEM
[EnvInject] - Loading node environment variables.
Building on the built-in node in workspace /var/lib/jenkins/jobs/reproducible_html_notes/workspace
The recommended git tool is: NONE
No credentials specified
Wiping out workspace first.
Cloning the remote Git repository
Cloning repository https://salsa.debian.org/reproducible-builds/reproducible-notes.git
 > git init /var/lib/jenkins/jobs/reproducible_html_notes/workspace # timeout=10
Fetching upstream changes from https://salsa.debian.org/reproducible-builds/reproducible-notes.git
 > git --version # timeout=10
 > git --version # 'git version 2.39.2'
 > git fetch --tags --force --progress -- https://salsa.debian.org/reproducible-builds/reproducible-notes.git +refs/heads/*:refs/remotes/origin/* # timeout=10
 > git config remote.origin.url https://salsa.debian.org/reproducible-builds/reproducible-notes.git # timeout=10
 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10
Avoid second fetch
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision 53d0e8eecc966f815df9265a73f8288bd978fb87 (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f 53d0e8eecc966f815df9265a73f8288bd978fb87 # timeout=10
Commit message: "Add patch for fastfetch"
 > git rev-list --no-walk 6b6ca1112a33e4a9c02bda40665502fcba9792a3 # timeout=10
[workspace] $ /bin/sh -xe /tmp/jenkins6482595376594666849.sh
+ /srv/jenkins/bin/reproducible_notes.py
[2024-06-24 15:56:37] INFO: Starting at 2024-06-24 15:56:37.763546
[2024-06-24 15:56:42] INFO: Notes loaded. There are 7504 packages listed.
[2024-06-24 15:56:50] INFO: Notes checked. There are 7504 packages listed.
[2024-06-24 15:56:51] INFO: Issues loaded. There are 430 issues listed.
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 982, in do_executemany
    context._psycopg2_fetched_rows = xtras.execute_values(
                                     ^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 1299, in execute_values
    cur.execute(b''.join(parts))
psycopg2.errors.ForeignKeyViolation: insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL:  Key (package_id)=(4703810) is not present in table "sources".


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

Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_notes.py", line 187, in <module>
    store_notes()
  File "/srv/jenkins/bin/reproducible_notes.py", line 179, in store_notes
    conn_db.execute(notes_table.insert(), to_insert)
  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 982, in do_executemany
    context._psycopg2_fetched_rows = xtras.execute_values(
                                     ^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 1299, in execute_values
    cur.execute(b''.join(parts))
sqlalchemy.exc.IntegrityError: (psycopg2.errors.ForeignKeyViolation) insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL:  Key (package_id)=(4703810) is not present in table "sources".

[SQL: INSERT INTO notes (package_id, version, issues, bugs, comments) VALUES (%(package_id)s, %(version)s, %(issues)s, %(bugs)s, %(comments)s)]
[parameters: ({'package_id': 1, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}, {'package_id': 70813, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}, {'package_id': 131387, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}, {'package_id': 213430, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}, {'package_id': 171058, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}, {'package_id': 171079, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}, {'package_id': 171100, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}, {'package_id': 184295, 'version': '0.0.20-2', 'issues': '["gcc_captures_build_path"]', 'bugs': '[]', 'comments': None}  ... displaying 10 of 134708 total bound parameter sets ...  {'package_id': 4058603, 'version': '0.13.72+dfsg.1-1.1', 'issues': '["cmake_rpath_contains_build_path"]', 'bugs': '[]', 'comments': 'rpath issue fixed by -DCMAKE_BUILD_RPATH_USE_ORIGIN=ON, but unable\nto verify effect on test suite due to nondeterministic failures.\n'}, {'package_id': 4071428, 'version': '0.13.72+dfsg.1-1.1', 'issues': '["cmake_rpath_contains_build_path"]', 'bugs': '[]', 'comments': 'rpath issue fixed by -DCMAKE_BUILD_RPATH_USE_ORIGIN=ON, but unable\nto verify effect on test suite due to nondeterministic failures.\n'})]
(Background on this error at: https://sqlalche.me/e/14/gkpj)
[2024-06-24 15:56:59] INFO: Finished at 2024-06-24 15:56:59.202052, took: 0:00:21.438515
Build step 'Execute shell' marked build as failure
Sending e-mails to: jenkins+reproducible-changes@jenkins.debian.net qa-jenkins-scm@lists.alioth.debian.org
Finished: FAILURE