Build failed in Jenkins: reproducible_html_notes #14421

Fri Mar 14 00:01:46 GMT 2025

See <https://jenkins.debian.net/job/reproducible_html_notes/14421/display/redirect?page=changes>

Changes:

[Mattia Rizzolo] Remove archived bugs

------------------------------------------
Started by an SCM change
Running as SYSTEM
[EnvInject] - Loading node environment variables.
Building on the built-in node in workspace <https://jenkins.debian.net/job/reproducible_html_notes/ws/>
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 <https://jenkins.debian.net/job/reproducible_html_notes/ws/> # 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.5'
 > 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 8216a9b9ba0d8822ba115fc99be4c78bb7cd9e28 (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f 8216a9b9ba0d8822ba115fc99be4c78bb7cd9e28 # timeout=10
Commit message: "Remove archived bugs"
 > git rev-list --no-walk b1305064e560fc609b4e550763186f14b0ac7933 # timeout=10
[workspace] $ /bin/sh -xe /tmp/jenkins9757416749758126218.sh
+ /srv/jenkins/bin/reproducible_notes.py
[2025-03-14 00:01:26] INFO: Starting at 2025-03-14 00:01:26.345261
[2025-03-14 00:01:30] INFO: Notes loaded. There are 7519 packages listed.
[2025-03-14 00:01:38] INFO: Notes checked. There are 7519 packages listed.
[2025-03-14 00:01:38] 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)=(4262497) 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)=(4262497) 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 132894 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)
[2025-03-14 00:01:45] INFO: Finished at 2025-03-14 00:01:45.245342, took: 0:00:18.900088
Build step 'Execute shell' marked build as failure