[Qa-jenkins-scm] Build failed in Jenkins: reproducible_html_notes #11637

[jenkins at jenkins.debian.net]

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

Changes:

[Mattia Rizzolo] Remove archived bugs

[Mattia Rizzolo] Add missing usertagged bugs

[Mattia Rizzolo] --fix-deterministic

[Mattia Rizzolo] remove fixed packages

[lamby] Tag python-doc8 with sphinxdoc_translations

[lamby] Tag python-doc8 with randomness_in_documentation_generated_by_sphinx


------------------------------------------
Started by an SCM change
Started by an SCM change
Started by an SCM change
Started by an SCM change
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_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.30.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 ee73d0429d8b302ca020dd96a654c0190c9f2e7f (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f ee73d0429d8b302ca020dd96a654c0190c9f2e7f # timeout=10
Commit message: "Tag python-doc8 with randomness_in_documentation_generated_by_sphinx"
 > git rev-list --no-walk 6a3bae402b7dbd16a64c831153bba2b1e824b198 # timeout=10
[workspace] $ /bin/sh -xe /tmp/jenkins16801421031926420108.sh
+ /srv/jenkins/bin/reproducible_notes.py
[2021-12-31 10:53:50] INFO: Starting at 2021-12-31 10:53:50.210706
/srv/jenkins/bin/reproducible_notes.py:40: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
  original = yaml.load(fd)
[2021-12-31 10:53:57] INFO: Notes loaded. There are 7143 packages listed.
[2021-12-31 10:54:06] INFO: Notes checked. There are 7143 packages listed.
/srv/jenkins/bin/reproducible_notes.py:111: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details.
  issues = yaml.load(fd)
[2021-12-31 10:54:07] INFO: Issues loaded. There are 401 issues listed.
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: insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL:  Key (package_id)=(2479207) 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 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) insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL:  Key (package_id)=(2479207) 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 112176 total bound parameter sets ...  {'package_id': 2585407, 'version': '0+git20190810-1', 'issues': '["captures_build_path_via_assert"]', 'bugs': '[]', 'comments': None}, {'package_id': 2585408, 'version': '0+git20190810-1', 'issues': '["captures_build_path_via_assert"]', 'bugs': '[]', 'comments': None})]
(Background on this error at: http://sqlalche.me/e/13/gkpj)
[2021-12-31 10:54:32] INFO: Finished at 2021-12-31 10:54:32.186183, took: 0:00:41.975489
Build step 'Execute shell' marked build as failure