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

[jenkins at jenkins.debian.net]

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

Changes:

[ab4309] Tag qbittorrent and dogecoin with random_order_in_tarball

[ab4309] tag ruby-prometheus-client-mmap with gcc_captures_build_path

------------------------------------------
Started by an SCM change
[EnvInject] - Loading node environment variables.
Building on master in workspace <https://jenkins.debian.net/job/reproducible_html_notes/ws/>
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 fetch --tags --progress https://salsa.debian.org/reproducible-builds/reproducible-notes.git +refs/heads/*:refs/remotes/origin/*
 > 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
 > git config remote.origin.url https://salsa.debian.org/reproducible-builds/reproducible-notes.git # timeout=10
Fetching upstream changes from https://salsa.debian.org/reproducible-builds/reproducible-notes.git
 > git fetch --tags --progress https://salsa.debian.org/reproducible-builds/reproducible-notes.git +refs/heads/*:refs/remotes/origin/*
 > git rev-parse origin/master^{commit} # timeout=10
Checking out Revision 58e953bf6357af26b2e470a4e5b0be351b7e1c5a (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f 58e953bf6357af26b2e470a4e5b0be351b7e1c5a
Commit message: "tag ruby-prometheus-client-mmap with gcc_captures_build_path"
 > git rev-list --no-walk abc505fe6ff126c239f3b7c46e85b886c580490d # timeout=10
[workspace] $ /bin/sh -xe /tmp/jenkins5043101574645948772.sh
+ /srv/jenkins/bin/reproducible_notes.py
[2018-11-05 16:47:26] INFO: Starting at 2018-11-05 16:47:26.210615
[2018-11-05 16:51:40] INFO: notes loaded. There are 6298 packages listed
[2018-11-05 16:54:22] INFO: notes checked. There are 6298 packages listed
[2018-11-05 16:54:36] INFO: Issues loaded. There are 317 issues
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1116, in _execute_context
    context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 447, in do_executemany
    cursor.executemany(statement, parameters)
psycopg2.IntegrityError: insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL:  Key (package_id)=(279773) 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 182, in <module>
    store_notes()
  File "/srv/jenkins/bin/reproducible_notes.py", line 174, in store_notes
    conn_db.execute(notes_table.insert(), to_insert)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 185, in reraise
    raise value.with_traceback(tb)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1116, in _execute_context
    context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 447, in do_executemany
    cursor.executemany(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) insert or update on table "notes" violates foreign key constraint "notes_package_id_fkey"
DETAIL:  Key (package_id)=(279773) 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: ({'version': '0.0.20-2', 'package_id': 1, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}, {'version': '0.0.20-2', 'package_id': 401851, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}, {'version': '0.0.20-2', 'package_id': 70813, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}, {'version': '0.0.20-2', 'package_id': 131387, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}, {'version': '0.0.20-2', 'package_id': 213430, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}, {'version': '0.0.20-2', 'package_id': 171058, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}, {'version': '0.0.20-2', 'package_id': 171079, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}, {'version': '0.0.20-2', 'package_id': 171100, 'comments': None, 'bugs': '[]', 'issues': '["gcc_captures_build_path"]'}  ... displaying 10 of 67620 total bound parameter sets ...  {'version': '0.1.2-2', 'package_id': 131384, 'comments': None, 'bugs': '[797027]', 'issues': '[]'}, {'version': '0.1.2-2', 'package_id': 195654, 'comments': None, 'bugs': '[797027]', 'issues': '[]'})]
[2018-11-05 17:02:09] INFO: Finished at 2018-11-05 17:02:09.539129, took: 0:14:43.330884
Build step 'Execute shell' marked build as failure