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

[jenkins at jenkins.debian.net]

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

Changes:

[Mattia Rizzolo] remove now reproducible package

------------------------------------------
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 773d99de2c900d2a5f192ee9160f5d11d7e7603d (origin/master)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f 773d99de2c900d2a5f192ee9160f5d11d7e7603d
Commit message: "remove now reproducible package"
 > git rev-list --no-walk 2dfa0945b87bff697a3fbfab41396db1290369cb # timeout=10
[workspace] $ /bin/sh -xe /tmp/jenkins2418868804040790495.sh
+ /srv/jenkins/bin/reproducible_notes.py
[2018-11-05 12:47:25] INFO: Starting at 2018-11-05 12:47:25.339872
[2018-11-05 12:51:16] INFO: notes loaded. There are 6296 packages listed
[2018-11-05 12:55:09] INFO: Warning: This query produces no results: SELECT s.id, s.version, s.suite
                FROM results AS r JOIN sources AS s ON r.package_id=s.id
                WHERE s.name='xview' AND r.status != ''
This means there is no tested package with the name xview
[2018-11-05 12:55:27] INFO: notes checked. There are 6295 packages listed
[2018-11-05 12:55:49] 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)=(2932) 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)=(2932) 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: ({'issues': '["gcc_captures_build_path"]', 'package_id': 1, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}, {'issues': '["gcc_captures_build_path"]', 'package_id': 401851, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}, {'issues': '["gcc_captures_build_path"]', 'package_id': 70813, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}, {'issues': '["gcc_captures_build_path"]', 'package_id': 131387, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}, {'issues': '["gcc_captures_build_path"]', 'package_id': 213430, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}, {'issues': '["gcc_captures_build_path"]', 'package_id': 171058, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}, {'issues': '["gcc_captures_build_path"]', 'package_id': 171079, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}, {'issues': '["gcc_captures_build_path"]', 'package_id': 171100, 'comments': None, 'version': '0.0.20-2', 'bugs': '[]'}  ... displaying 10 of 67671 total bound parameter sets ...  {'issues': '[]', 'package_id': 131384, 'comments': None, 'version': '0.1.2-2', 'bugs': '[797027]'}, {'issues': '[]', 'package_id': 195654, 'comments': None, 'version': '0.1.2-2', 'bugs': '[797027]'})]
[2018-11-05 13:02:41] INFO: Finished at 2018-11-05 13:02:41.315627, took: 0:15:15.977083
Build step 'Execute shell' marked build as failure