[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #26047
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Tue Dec 3 07:32:16 GMT 2019
See <https://jenkins.debian.net/job/reproducible_scheduler/26047/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/jenkins14471680589130221053.sh
+ /srv/jenkins/bin/reproducible_scheduler.py
/srv/jenkins/bin/reproducible_scheduler.py:15: DeprecationWarning: please use 'debian.deb822' instead
import deb822
[2019-12-03 07:23:04] INFO: Starting at 2019-12-03 07:23:04.808244
[2019-12-03 07:23:05] INFO: Updating sources tables for all suites.
[2019-12-03 07:23:05] INFO: Downloading sources file for stretch: http://deb.debian.org/debian/dists/stretch/main/source/Sources.xz
[2019-12-03 07:23:06] 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-03 07:23:30] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:23:39] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:23:39] INFO: DB update done for stretch/amd64 done at 2019-12-03 07:23:39.
[2019-12-03 07:23:39] INFO: Updating sources db for stretch/i386...
[2019-12-03 07:23:58] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:24:06] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:24:06] INFO: DB update done for stretch/i386 done at 2019-12-03 07:24:06.
[2019-12-03 07:24:06] INFO: Updating sources db for stretch/arm64...
[2019-12-03 07:24:26] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:24:35] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:24:35] INFO: DB update done for stretch/arm64 done at 2019-12-03 07:24:35.
[2019-12-03 07:24:35] INFO: Updating sources db for stretch/armhf...
[2019-12-03 07:24:53] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:25:01] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:25:01] INFO: DB update done for stretch/armhf done at 2019-12-03 07:25:01.
[2019-12-03 07:25:01] INFO: Sources for suite stretch done at 2019-12-03 07:25:01.
[2019-12-03 07:25:01] INFO: Downloading sources file for buster: http://deb.debian.org/debian/dists/buster/main/source/Sources.xz
[2019-12-03 07:25:03] INFO: Updating sources db for buster/amd64...
[2019-12-03 07:25:25] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:25:38] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:25:38] INFO: DB update done for buster/amd64 done at 2019-12-03 07:25:38.
[2019-12-03 07:25:38] INFO: Updating sources db for buster/i386...
[2019-12-03 07:25:59] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:26:12] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:26:12] INFO: DB update done for buster/i386 done at 2019-12-03 07:26:12.
[2019-12-03 07:26:12] INFO: Updating sources db for buster/arm64...
[2019-12-03 07:26:35] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:26:47] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:26:47] INFO: DB update done for buster/arm64 done at 2019-12-03 07:26:47.
[2019-12-03 07:26:47] INFO: Updating sources db for buster/armhf...
[2019-12-03 07:27:07] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:27:20] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:27:21] INFO: DB update done for buster/armhf done at 2019-12-03 07:27:21.
[2019-12-03 07:27:21] INFO: Sources for suite buster done at 2019-12-03 07:27:21.
[2019-12-03 07:27:21] INFO: Downloading sources file for bullseye: http://deb.debian.org/debian/dists/bullseye/main/source/Sources.xz
[2019-12-03 07:27:22] INFO: Updating sources db for bullseye/amd64...
[2019-12-03 07:27:45] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:27:57] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:27:57] INFO: DB update done for bullseye/amd64 done at 2019-12-03 07:27:57.
[2019-12-03 07:27:57] INFO: Updating sources db for bullseye/i386...
[2019-12-03 07:28:19] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:28:31] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:28:32] INFO: DB update done for bullseye/i386 done at 2019-12-03 07:28:32.
[2019-12-03 07:28:32] INFO: Updating sources db for bullseye/arm64...
[2019-12-03 07:28:53] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:29:05] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:29:05] INFO: DB update done for bullseye/arm64 done at 2019-12-03 07:29:05.
[2019-12-03 07:29:05] INFO: Updating sources db for bullseye/armhf...
[2019-12-03 07:29:28] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:29:39] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:29:40] INFO: DB update done for bullseye/armhf done at 2019-12-03 07:29:40.
[2019-12-03 07:29:40] INFO: Sources for suite bullseye done at 2019-12-03 07:29:40.
[2019-12-03 07:29:40] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2019-12-03 07:29:41] INFO: Updating sources db for unstable/amd64...
[2019-12-03 07:30:04] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:30:17] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:30:18] INFO: DB update done for unstable/amd64 done at 2019-12-03 07:30:18.
[2019-12-03 07:30:18] INFO: Updating sources db for unstable/i386...
[2019-12-03 07:30:41] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:30:54] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:30:54] INFO: DB update done for unstable/i386 done at 2019-12-03 07:30:54.
[2019-12-03 07:30:54] INFO: Updating sources db for unstable/arm64...
[2019-12-03 07:31:17] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:31:31] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:31:31] INFO: DB update done for unstable/arm64 done at 2019-12-03 07:31:31.
[2019-12-03 07:31:31] INFO: Updating sources db for unstable/armhf...
[2019-12-03 07:31:55] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:32:08] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:32:08] INFO: DB update done for unstable/armhf done at 2019-12-03 07:32:08.
[2019-12-03 07:32:08] INFO: Sources for suite unstable done at 2019-12-03 07:32:08.
[2019-12-03 07:32:08] INFO: Downloading sources file for experimental: http://deb.debian.org/debian/dists/experimental/main/source/Sources.xz
[2019-12-03 07:32:08] INFO: Updating sources db for experimental/amd64...
[2019-12-03 07:32:09] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:32:09] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:32:09] INFO: DB update done for experimental/amd64 done at 2019-12-03 07:32:09.
[2019-12-03 07:32:09] INFO: Updating sources db for experimental/i386...
[2019-12-03 07:32:10] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:32:10] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:32:10] INFO: DB update done for experimental/i386 done at 2019-12-03 07:32:10.
[2019-12-03 07:32:10] INFO: Updating sources db for experimental/arm64...
[2019-12-03 07:32:10] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:32:10] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:32:10] INFO: DB update done for experimental/arm64 done at 2019-12-03 07:32:10.
[2019-12-03 07:32:10] INFO: Updating sources db for experimental/armhf...
[2019-12-03 07:32:11] INFO: Pushing 0 updated packages to the database...
[2019-12-03 07:32:11] INFO: Now deleting 0 removed packages: []
[2019-12-03 07:32:11] INFO: DB update done for experimental/armhf done at 2019-12-03 07:32:11.
[2019-12-03 07:32:11] INFO: Sources for suite experimental done at 2019-12-03 07:32:11.
[2019-12-03 07:32:11] INFO: Removing old pages from stretch/amd64.
[2019-12-03 07:32:11] INFO: Removing old pages from stretch/amd64/diffoscope-results/.
[2019-12-03 07:32:11] INFO: Removing old pages from stretch/i386.
[2019-12-03 07:32:12] INFO: Removing old pages from stretch/i386/diffoscope-results/.
[2019-12-03 07:32:12] INFO: Removing old pages from stretch/arm64.
[2019-12-03 07:32:12] INFO: Removing old pages from stretch/arm64/diffoscope-results/.
[2019-12-03 07:32:12] INFO: Removing old pages from stretch/armhf.
[2019-12-03 07:32:12] INFO: Removing old pages from stretch/armhf/diffoscope-results/.
[2019-12-03 07:32:12] INFO: Removing old pages from buster/amd64.
[2019-12-03 07:32:12] INFO: Removing old pages from buster/amd64/diffoscope-results/.
[2019-12-03 07:32:13] INFO: Removing old pages from buster/i386.
[2019-12-03 07:32:13] INFO: Removing old pages from buster/i386/diffoscope-results/.
[2019-12-03 07:32:13] INFO: Removing old pages from buster/arm64.
[2019-12-03 07:32:13] INFO: Removing old pages from buster/arm64/diffoscope-results/.
[2019-12-03 07:32:13] INFO: Removing old pages from buster/armhf.
[2019-12-03 07:32:13] INFO: Removing old pages from buster/armhf/diffoscope-results/.
[2019-12-03 07:32:13] INFO: Removing old pages from bullseye/amd64.
[2019-12-03 07:32:14] INFO: Removing old pages from bullseye/amd64/diffoscope-results/.
[2019-12-03 07:32:14] INFO: Removing old pages from bullseye/i386.
[2019-12-03 07:32:14] INFO: Removing old pages from bullseye/i386/diffoscope-results/.
[2019-12-03 07:32:14] INFO: Removing old pages from bullseye/arm64.
[2019-12-03 07:32:14] INFO: Removing old pages from bullseye/arm64/diffoscope-results/.
[2019-12-03 07:32:14] INFO: Removing old pages from bullseye/armhf.
[2019-12-03 07:32:15] INFO: Removing old pages from bullseye/armhf/diffoscope-results/.
[2019-12-03 07:32:15] INFO: Removing old pages from unstable/amd64.
[2019-12-03 07:32:15] INFO: Removing old pages from unstable/amd64/diffoscope-results/.
[2019-12-03 07:32:15] INFO: Removing old pages from unstable/i386.
[2019-12-03 07:32:15] INFO: Removing old pages from unstable/i386/diffoscope-results/.
[2019-12-03 07:32:15] INFO: Removing old pages from unstable/arm64.
[2019-12-03 07:32:16] INFO: Removing old pages from unstable/arm64/diffoscope-results/.
[2019-12-03 07:32:16] INFO: Removing old pages from unstable/armhf.
[2019-12-03 07:32:16] INFO: Removing old pages from unstable/armhf/diffoscope-results/.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/amd64.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/amd64/diffoscope-results/.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/i386.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/i386/diffoscope-results/.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/arm64.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/arm64/diffoscope-results/.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/armhf.
[2019-12-03 07:32:16] INFO: Removing old pages from experimental/armhf/diffoscope-results/.
[2019-12-03 07:32:16] INFO: Scheduling for amd64...
[2019-12-03 07:32:16] INFO: 2062 packages already scheduled for amd64, probably scheduling some more...
[2019-12-03 07:32:16] INFO: ==============================================================
[2019-12-03 07:32:16] INFO: Currently scheduled packages in all suites on amd64: 2062
[2019-12-03 07:32:16] INFO: 2062 packages already scheduled, only scheduling new versions.
[2019-12-03 07:32:16] 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-03 07:32:16] INFO: Finished at 2019-12-03 07:32:16.762680, took: 0:09:11.954443
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list