[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #26043
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Mon Dec 2 23:44:28 GMT 2019
See <https://jenkins.debian.net/job/reproducible_scheduler/26043/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_scheduler/ws/>
[workspace] $ /bin/sh -xe /tmp/jenkins9949727098471456075.sh
+ /srv/jenkins/bin/reproducible_scheduler.py
/srv/jenkins/bin/reproducible_scheduler.py:15: DeprecationWarning: please use 'debian.deb822' instead
import deb822
[2019-12-02 23:34:21] INFO: Starting at 2019-12-02 23:34:21.663904
[2019-12-02 23:34:24] INFO: Updating sources tables for all suites.
[2019-12-02 23:34:24] INFO: Downloading sources file for stretch: http://deb.debian.org/debian/dists/stretch/main/source/Sources.xz
[2019-12-02 23:34:32] INFO: Updating sources db for stretch/amd64...
/usr/lib/python3/dist-packages/debian/deb822.py:693: UserWarning: Parsing of Deb822 data with python-apt's apt_pkg was requested but this cannot be done on non-file input.
warnings.warn(msg)
[2019-12-02 23:35:12] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:35:22] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:35:22] INFO: DB update done for stretch/amd64 done at 2019-12-02 23:35:22.
[2019-12-02 23:35:22] INFO: Updating sources db for stretch/i386...
[2019-12-02 23:35:44] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:35:54] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:35:54] INFO: DB update done for stretch/i386 done at 2019-12-02 23:35:54.
[2019-12-02 23:35:54] INFO: Updating sources db for stretch/arm64...
[2019-12-02 23:36:15] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:36:24] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:36:24] INFO: DB update done for stretch/arm64 done at 2019-12-02 23:36:24.
[2019-12-02 23:36:24] INFO: Updating sources db for stretch/armhf...
[2019-12-02 23:36:45] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:36:54] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:36:54] INFO: DB update done for stretch/armhf done at 2019-12-02 23:36:54.
[2019-12-02 23:36:54] INFO: Sources for suite stretch done at 2019-12-02 23:36:54.
[2019-12-02 23:36:54] INFO: Downloading sources file for buster: http://deb.debian.org/debian/dists/buster/main/source/Sources.xz
[2019-12-02 23:36:55] INFO: Updating sources db for buster/amd64...
[2019-12-02 23:37:22] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:37:35] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:37:35] INFO: DB update done for buster/amd64 done at 2019-12-02 23:37:35.
[2019-12-02 23:37:35] INFO: Updating sources db for buster/i386...
[2019-12-02 23:37:59] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:38:12] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:38:12] INFO: DB update done for buster/i386 done at 2019-12-02 23:38:12.
[2019-12-02 23:38:12] INFO: Updating sources db for buster/arm64...
[2019-12-02 23:38:35] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:38:47] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:38:48] INFO: DB update done for buster/arm64 done at 2019-12-02 23:38:48.
[2019-12-02 23:38:48] INFO: Updating sources db for buster/armhf...
[2019-12-02 23:39:10] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:39:23] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:39:23] INFO: DB update done for buster/armhf done at 2019-12-02 23:39:23.
[2019-12-02 23:39:23] INFO: Sources for suite buster done at 2019-12-02 23:39:23.
[2019-12-02 23:39:23] INFO: Downloading sources file for bullseye: http://deb.debian.org/debian/dists/bullseye/main/source/Sources.xz
[2019-12-02 23:39:25] INFO: Updating sources db for bullseye/amd64...
[2019-12-02 23:39:47] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:39:59] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:39:59] INFO: DB update done for bullseye/amd64 done at 2019-12-02 23:39:59.
[2019-12-02 23:39:59] INFO: Updating sources db for bullseye/i386...
[2019-12-02 23:40:21] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:40:34] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:40:34] INFO: DB update done for bullseye/i386 done at 2019-12-02 23:40:34.
[2019-12-02 23:40:34] INFO: Updating sources db for bullseye/arm64...
[2019-12-02 23:40:56] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:41:08] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:41:08] INFO: DB update done for bullseye/arm64 done at 2019-12-02 23:41:08.
[2019-12-02 23:41:08] INFO: Updating sources db for bullseye/armhf...
[2019-12-02 23:41:30] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:41:42] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:41:42] INFO: DB update done for bullseye/armhf done at 2019-12-02 23:41:42.
[2019-12-02 23:41:42] INFO: Sources for suite bullseye done at 2019-12-02 23:41:42.
[2019-12-02 23:41:42] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2019-12-02 23:41:44] INFO: Updating sources db for unstable/amd64...
[2019-12-02 23:42:07] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:42:24] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:42:24] INFO: DB update done for unstable/amd64 done at 2019-12-02 23:42:24.
[2019-12-02 23:42:24] INFO: Updating sources db for unstable/i386...
[2019-12-02 23:42:48] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:43:02] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:43:02] INFO: DB update done for unstable/i386 done at 2019-12-02 23:43:02.
[2019-12-02 23:43:02] INFO: Updating sources db for unstable/arm64...
[2019-12-02 23:43:25] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:43:38] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:43:38] INFO: DB update done for unstable/arm64 done at 2019-12-02 23:43:38.
[2019-12-02 23:43:38] INFO: Updating sources db for unstable/armhf...
[2019-12-02 23:44:02] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:44:18] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:44:18] INFO: DB update done for unstable/armhf done at 2019-12-02 23:44:18.
[2019-12-02 23:44:18] INFO: Sources for suite unstable done at 2019-12-02 23:44:18.
[2019-12-02 23:44:18] INFO: Downloading sources file for experimental: http://deb.debian.org/debian/dists/experimental/main/source/Sources.xz
[2019-12-02 23:44:19] INFO: Updating sources db for experimental/amd64...
[2019-12-02 23:44:20] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:44:20] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:44:20] INFO: DB update done for experimental/amd64 done at 2019-12-02 23:44:20.
[2019-12-02 23:44:20] INFO: Updating sources db for experimental/i386...
[2019-12-02 23:44:20] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:44:20] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:44:20] INFO: DB update done for experimental/i386 done at 2019-12-02 23:44:20.
[2019-12-02 23:44:20] INFO: Updating sources db for experimental/arm64...
[2019-12-02 23:44:21] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:44:21] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:44:21] INFO: DB update done for experimental/arm64 done at 2019-12-02 23:44:21.
[2019-12-02 23:44:21] INFO: Updating sources db for experimental/armhf...
[2019-12-02 23:44:22] INFO: Pushing 0 updated packages to the database...
[2019-12-02 23:44:22] INFO: Now deleting 0 removed packages: []
[2019-12-02 23:44:22] INFO: DB update done for experimental/armhf done at 2019-12-02 23:44:22.
[2019-12-02 23:44:22] INFO: Sources for suite experimental done at 2019-12-02 23:44:22.
[2019-12-02 23:44:22] INFO: Removing old pages from stretch/amd64.
[2019-12-02 23:44:22] INFO: Removing old pages from stretch/amd64/diffoscope-results/.
[2019-12-02 23:44:22] INFO: Removing old pages from stretch/i386.
[2019-12-02 23:44:23] INFO: Removing old pages from stretch/i386/diffoscope-results/.
[2019-12-02 23:44:23] INFO: Removing old pages from stretch/arm64.
[2019-12-02 23:44:23] INFO: Removing old pages from stretch/arm64/diffoscope-results/.
[2019-12-02 23:44:23] INFO: Removing old pages from stretch/armhf.
[2019-12-02 23:44:23] INFO: Removing old pages from stretch/armhf/diffoscope-results/.
[2019-12-02 23:44:23] INFO: Removing old pages from buster/amd64.
[2019-12-02 23:44:23] INFO: Removing old pages from buster/amd64/diffoscope-results/.
[2019-12-02 23:44:23] INFO: Removing old pages from buster/i386.
[2019-12-02 23:44:24] INFO: Removing old pages from buster/i386/diffoscope-results/.
[2019-12-02 23:44:24] INFO: Removing old pages from buster/arm64.
[2019-12-02 23:44:24] INFO: Removing old pages from buster/arm64/diffoscope-results/.
[2019-12-02 23:44:24] INFO: Removing old pages from buster/armhf.
[2019-12-02 23:44:25] INFO: Removing old pages from buster/armhf/diffoscope-results/.
[2019-12-02 23:44:25] INFO: Removing old pages from bullseye/amd64.
[2019-12-02 23:44:25] INFO: Removing old pages from bullseye/amd64/diffoscope-results/.
[2019-12-02 23:44:25] INFO: Removing old pages from bullseye/i386.
[2019-12-02 23:44:25] INFO: Removing old pages from bullseye/i386/diffoscope-results/.
[2019-12-02 23:44:25] INFO: Removing old pages from bullseye/arm64.
[2019-12-02 23:44:26] INFO: Removing old pages from bullseye/arm64/diffoscope-results/.
[2019-12-02 23:44:26] INFO: Removing old pages from bullseye/armhf.
[2019-12-02 23:44:26] INFO: Removing old pages from bullseye/armhf/diffoscope-results/.
[2019-12-02 23:44:26] INFO: Removing old pages from unstable/amd64.
[2019-12-02 23:44:26] INFO: Removing old pages from unstable/amd64/diffoscope-results/.
[2019-12-02 23:44:26] INFO: Removing old pages from unstable/i386.
[2019-12-02 23:44:27] INFO: Removing old pages from unstable/i386/diffoscope-results/.
[2019-12-02 23:44:27] INFO: Removing old pages from unstable/arm64.
[2019-12-02 23:44:27] INFO: Removing old pages from unstable/arm64/diffoscope-results/.
[2019-12-02 23:44:27] INFO: Removing old pages from unstable/armhf.
[2019-12-02 23:44:27] INFO: Removing old pages from unstable/armhf/diffoscope-results/.
[2019-12-02 23:44:27] INFO: Removing old pages from experimental/amd64.
[2019-12-02 23:44:27] INFO: Removing old pages from experimental/amd64/diffoscope-results/.
[2019-12-02 23:44:27] INFO: Removing old pages from experimental/i386.
[2019-12-02 23:44:28] INFO: Removing old pages from experimental/i386/diffoscope-results/.
[2019-12-02 23:44:28] INFO: Removing old pages from experimental/arm64.
[2019-12-02 23:44:28] INFO: Removing old pages from experimental/arm64/diffoscope-results/.
[2019-12-02 23:44:28] INFO: Removing old pages from experimental/armhf.
[2019-12-02 23:44:28] INFO: Removing old pages from experimental/armhf/diffoscope-results/.
[2019-12-02 23:44:28] INFO: Scheduling for amd64...
[2019-12-02 23:44:28] INFO: 2073 packages already scheduled for amd64, probably scheduling some more...
[2019-12-02 23:44:28] INFO: ==============================================================
[2019-12-02 23:44:28] INFO: Currently scheduled packages in all suites on amd64: 2073
[2019-12-02 23:44:28] INFO: 2073 packages already scheduled, only scheduling new versions.
[2019-12-02 23:44:28] INFO: Requesting 100 new versions in stretch/amd64...
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.ProgrammingError: syntax error at or near "AND"
LINE 7: ... NOT IN (SELECT schedule.package_id FROM schedule AND build_...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/srv/jenkins/bin/reproducible_scheduler.py", line 794, in <module>
message += scheduler(arch)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 710, in scheduler
new, msg_new = schedule_new_versions(arch, total)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 608, in schedule_new_versions
packages[suite] = query_new_versions(suite, arch, many_new)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 493, in query_new_versions
pkgs = query_db(query)
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 974, in execute
return self._execute_text(object_, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1147, in _execute_text
parameters,
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.ProgrammingError: (psycopg2.ProgrammingError) syntax error at or near "AND"
LINE 7: ... NOT IN (SELECT schedule.package_id FROM schedule AND build_...
^
[SQL: "SELECT s.id, s.name, s.version, r.version, max(r.build_date) max_date\n FROM sources AS s JOIN results AS r ON s.id = r.package_id\n WHERE s.suite='stretch' AND s.architecture='amd64'\n AND s.version != r.version\n AND r.status != 'blacklisted'\n AND s.id IN (SELECT package_id FROM results)\n AND s.id NOT IN (SELECT schedule.package_id FROM schedule AND build_type='ci_build')\n GROUP BY s.id, s.name, s.version, r.version\n ORDER BY max_date\n LIMIT 100"] (Background on this error at: http://sqlalche.me/e/f405)
[2019-12-02 23:44:28] INFO: Finished at 2019-12-02 23:44:28.323500, took: 0:10:06.659610
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list