Build failed in Jenkins: reproducible_html_notes #15087
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Sat Mar 21 00:01:17 GMT 2026
See <https://jenkins.debian.net/job/reproducible_html_notes/15087/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.47.3'
> 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 0d1fab865340146cde98f645f7d4fda80c725d7a (origin/master)
> git config core.sparsecheckout # timeout=10
> git checkout -f 0d1fab865340146cde98f645f7d4fda80c725d7a # timeout=10
Commit message: "Remove archived bugs"
> git rev-list --no-walk 185b3af4e299a1a5c01a99541775c1b02a86f934 # timeout=10
[workspace] $ /bin/sh -xe /tmp/jenkins14610564773275002864.sh
+ /srv/jenkins/bin/reproducible_notes.py
[2026-03-21 00:01:05] INFO: Starting at 2026-03-21 00:01:05.470761
[2026-03-21 00:01:07] INFO: Notes loaded. There are 7718 packages listed.
[2026-03-21 00:01:13] INFO: Notes checked. There are 7718 packages listed.
[2026-03-21 00:01:14] INFO: Issues loaded. There are 434 issues listed.
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2115, in _exec_insertmany_context
dialect.do_execute(
~~~~~~~~~~~~~~~~~~^
cursor,
^^^^^^^
...<2 lines>...
context,
^^^^^^^^
)
^
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 945, in do_execute
cursor.execute(statement, parameters)
~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.ForeignKeyViolation: insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL: Key (package_id)=(6958031) 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 1416, in execute
return meth(
self,
distilled_parameters,
execution_options or NO_OPTIONS,
)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 523, in _execute_on_connection
return connection._execute_clauseelement(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
self, distilled_params, execution_options
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement
ret = self._execute_context(
dialect,
...<8 lines>...
cache_hit=cache_hit,
)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1841, in _execute_context
return self._exec_insertmany_context(dialect, context)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2123, in _exec_insertmany_context
self._handle_dbapi_exception(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
e,
^^
...<4 lines>...
is_sub_exec=True,
^^^^^^^^^^^^^^^^^
)
^
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2352, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2115, in _exec_insertmany_context
dialect.do_execute(
~~~~~~~~~~~~~~~~~~^
cursor,
^^^^^^^
...<2 lines>...
context,
^^^^^^^^
)
^
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 945, in do_execute
cursor.execute(statement, parameters)
~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
sqlalchemy.exc.IntegrityError: (psycopg2.errors.ForeignKeyViolation) insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL: Key (package_id)=(6958031) is not present in table "sources".
[SQL: INSERT INTO notes (package_id, version, issues, bugs, comments) VALUES (%(package_id__0)s, %(version__0)s, %(issues__0)s, %(bugs__0)s, %(comments__0)s), (%(package_id__1)s, %(version__1)s, %(issues__1)s, %(bugs__1)s, %(comments__1)s), (%(package_id__ ... 91169 characters truncated ... __998)s), (%(package_id__999)s, %(version__999)s, %(issues__999)s, %(bugs__999)s, %(comments__999)s)]
[parameters: {'issues__0': '["pdf_id_varying_due_to_build_path"]', 'package_id__0': 6305878, 'version__0': '3.13+ds-1', 'comments__0': None, 'bugs__0': '[]', 'issues__1': '["pdf_id_varying_due_to_build_path"]', 'package_id__1': 5652862, 'version__1': '3.13+ds-1', 'comments__1': None, 'bugs__1': '[]', 'issues__2': '["pdf_id_varying_due_to_build_path"]', 'package_id__2': 5652870, 'version__2': '3.13+ds-1', 'comments__2': None, 'bugs__2': '[]', 'issues__3': '["pdf_id_varying_due_to_build_path"]', 'package_id__3': 6396792, 'version__3': '3.13+ds-1', 'comments__3': None, 'bugs__3': '[]', 'issues__4': '["pdf_id_varying_due_to_build_path"]', 'package_id__4': 6396793, 'version__4': '3.13+ds-1', 'comments__4': None, 'bugs__4': '[]', 'issues__5': '["pdf_id_varying_due_to_build_path"]', 'package_id__5': 4186, 'version__5': '4.4.6+ds-2', 'comments__5': None, 'bugs__5': '[]', 'issues__6': '["pdf_id_varying_due_to_build_path"]', 'package_id__6': 221245, 'version__6': '4.4.6+ds-2', 'comments__6': None, 'bugs__6': '[]', 'issues__7': '["pdf_id_varying_due_to_build_path"]', 'package_id__7': 27950, 'version__7': '4.4.6+ds-2', 'comments__7': None, 'bugs__7': '[]', 'issues__8': '["pdf_id_varying_due_to_build_path"]', 'package_id__8': 53006, 'version__8': '4.4.6+ds-2', 'comments__8': None, 'bugs__8': '[]', 'issues__9': '["pdf_id_varying_due_to_build_path"]', 'package_id__9': 112397, 'version__9': '4.4.6+ds-2', 'comments__9': None, 'bugs__9': '[]' ... 4900 parameters truncated ... 'issues__990': '["gcc_captures_build_path"]', 'package_id__990': 6382966, 'version__990': '0.4.0-1', 'comments__990': None, 'bugs__990': '[]', 'issues__991': '["gcc_captures_build_path"]', 'package_id__991': 6407358, 'version__991': '0.4.0-1', 'comments__991': None, 'bugs__991': '[]', 'issues__992': '["gcc_captures_build_path"]', 'package_id__992': 4283, 'version__992': '0.4.0-1', 'comments__992': None, 'bugs__992': '[]', 'issues__993': '["nondeterministic_devhelp_documentation_generated_by_gtk_doc"]', 'package_id__993': 4286, 'version__993': '2.42.6+dfsg-2', 'comments__993': None, 'bugs__993': '[]', 'issues__994': '["nondeterministic_devhelp_documentation_generated_by_gtk_doc"]', 'package_id__994': 136241, 'version__994': '2.42.6+dfsg-2', 'comments__994': None, 'bugs__994': '[]', 'issues__995': '["nondeterministic_devhelp_documentation_generated_by_gtk_doc"]', 'package_id__995': 75430, 'version__995': '2.42.6+dfsg-2', 'comments__995': None, 'bugs__995': '[]', 'issues__996': '["nondeterministic_devhelp_documentation_generated_by_gtk_doc"]', 'package_id__996': 2569536, 'version__996': '2.42.6+dfsg-2', 'comments__996': None, 'bugs__996': '[]', 'issues__997': '["nondeterministic_devhelp_documentation_generated_by_gtk_doc"]', 'package_id__997': 2569533, 'version__997': '2.42.6+dfsg-2', 'comments__997': None, 'bugs__997': '[]', 'issues__998': '["nondeterministic_devhelp_documentation_generated_by_gtk_doc"]', 'package_id__998': 4106211, 'version__998': '2.42.6+dfsg-2', 'comments__998': None, 'bugs__998': '[]', 'issues__999': '["nondeterministic_devhelp_documentation_generated_by_gtk_doc"]', 'package_id__999': 4110053, 'version__999': '2.42.6+dfsg-2', 'comments__999': None, 'bugs__999': '[]'}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)
[2026-03-21 00:01:16] INFO: Finished at 2026-03-21 00:01:16.398329, took: 0:00:10.927572
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list