[Qa-jenkins-scm] Build failed in Jenkins: reproducible_opensuse_import_json #60

[jenkins at jenkins.debian.net]

See <https://jenkins.debian.net/job/reproducible_opensuse_import_json/60/display/redirect>

Changes:


------------------------------------------
Started by timer
Running as SYSTEM
[EnvInject] - Loading node environment variables.
Building on master in workspace <https://jenkins.debian.net/job/reproducible_opensuse_import_json/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins5382175949403043575.sh
+ cd /srv/jenkins/bin/
+ ./reproducible_opensuse_import_json.py
[2019-12-30 11:58:01] INFO: Starting at 2019-12-30 11:58:01.229914
[2019-12-30 11:58:01] INFO: Downloading status file…
[2019-12-30 11:58:01] INFO: Dropping old data…
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 536, in do_execute
    cursor.execute(statement, parameters)
psycopg2.IntegrityError: update or delete on table "sources" violates foreign key constraint "schedule_tmp_package_id_fkey" on table "schedule"
DETAIL:  Key (id)=(1182104) is still referenced from table "schedule".


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "./reproducible_opensuse_import_json.py", line 62, in <module>
    query_db(d)
  File "/srv/jenkins/bin/rblib/__init__.py", line 43, in query_db
    result = conn_db.execute(query, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 980, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
    distilled_params,
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1458, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 276, in reraise
    raise value.with_traceback(tb)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 536, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) update or delete on table "sources" violates foreign key constraint "schedule_tmp_package_id_fkey" on table "schedule"
DETAIL:  Key (id)=(1182104) is still referenced from table "schedule".
 [SQL: 'DELETE FROM sources WHERE sources.distribution = %(distribution_1)s'] [parameters: {'distribution_1': 2}] (Background on this error at: http://sqlalche.me/e/gkpj)
[2019-12-30 11:58:02] INFO: Finished at 2019-12-30 11:58:02.548265, took: 0:00:01.318358
Build step 'Execute shell' marked build as failure