[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #26044
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Tue Dec 3 01:32:46 GMT 2019
See <https://jenkins.debian.net/job/reproducible_scheduler/26044/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/jenkins6974086173080745670.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 01:23:06] INFO: Starting at 2019-12-03 01:23:06.843939
[2019-12-03 01:23:07] INFO: Updating sources tables for all suites.
[2019-12-03 01:23:07] INFO: Downloading sources file for stretch: http://deb.debian.org/debian/dists/stretch/main/source/Sources.xz
[2019-12-03 01:23:08] 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 01:23:28] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:23:37] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:23:37] INFO: DB update done for stretch/amd64 done at 2019-12-03 01:23:37.
[2019-12-03 01:23:37] INFO: Updating sources db for stretch/i386...
[2019-12-03 01:23:57] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:24:07] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:24:07] INFO: DB update done for stretch/i386 done at 2019-12-03 01:24:07.
[2019-12-03 01:24:07] INFO: Updating sources db for stretch/arm64...
[2019-12-03 01:24:27] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:24:35] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:24:35] INFO: DB update done for stretch/arm64 done at 2019-12-03 01:24:35.
[2019-12-03 01:24:35] INFO: Updating sources db for stretch/armhf...
[2019-12-03 01:24:55] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:25:04] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:25:04] INFO: DB update done for stretch/armhf done at 2019-12-03 01:25:04.
[2019-12-03 01:25:04] INFO: Sources for suite stretch done at 2019-12-03 01:25:04.
[2019-12-03 01:25:04] INFO: Downloading sources file for buster: http://deb.debian.org/debian/dists/buster/main/source/Sources.xz
[2019-12-03 01:25:05] INFO: Updating sources db for buster/amd64...
[2019-12-03 01:25:29] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:25:42] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:25:43] INFO: DB update done for buster/amd64 done at 2019-12-03 01:25:43.
[2019-12-03 01:25:43] INFO: Updating sources db for buster/i386...
[2019-12-03 01:26:04] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:26:18] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:26:18] INFO: DB update done for buster/i386 done at 2019-12-03 01:26:18.
[2019-12-03 01:26:18] INFO: Updating sources db for buster/arm64...
[2019-12-03 01:26:41] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:26:54] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:26:54] INFO: DB update done for buster/arm64 done at 2019-12-03 01:26:54.
[2019-12-03 01:26:54] INFO: Updating sources db for buster/armhf...
[2019-12-03 01:27:18] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:27:32] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:27:32] INFO: DB update done for buster/armhf done at 2019-12-03 01:27:32.
[2019-12-03 01:27:32] INFO: Sources for suite buster done at 2019-12-03 01:27:32.
[2019-12-03 01:27:32] INFO: Downloading sources file for bullseye: http://deb.debian.org/debian/dists/bullseye/main/source/Sources.xz
[2019-12-03 01:27:34] INFO: Updating sources db for bullseye/amd64...
[2019-12-03 01:27:57] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:28:11] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:28:11] INFO: DB update done for bullseye/amd64 done at 2019-12-03 01:28:11.
[2019-12-03 01:28:11] INFO: Updating sources db for bullseye/i386...
[2019-12-03 01:28:33] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:28:46] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:28:46] INFO: DB update done for bullseye/i386 done at 2019-12-03 01:28:46.
[2019-12-03 01:28:46] INFO: Updating sources db for bullseye/arm64...
[2019-12-03 01:29:07] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:29:21] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:29:21] INFO: DB update done for bullseye/arm64 done at 2019-12-03 01:29:21.
[2019-12-03 01:29:21] INFO: Updating sources db for bullseye/armhf...
[2019-12-03 01:29:43] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:29:54] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:29:54] INFO: DB update done for bullseye/armhf done at 2019-12-03 01:29:54.
[2019-12-03 01:29:54] INFO: Sources for suite bullseye done at 2019-12-03 01:29:54.
[2019-12-03 01:29:54] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2019-12-03 01:29:56] INFO: Updating sources db for unstable/amd64...
[2019-12-03 01:30:24] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:30:39] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:30:39] INFO: DB update done for unstable/amd64 done at 2019-12-03 01:30:39.
[2019-12-03 01:30:39] INFO: Updating sources db for unstable/i386...
[2019-12-03 01:31:05] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:31:18] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:31:18] INFO: DB update done for unstable/i386 done at 2019-12-03 01:31:18.
[2019-12-03 01:31:18] INFO: Updating sources db for unstable/arm64...
[2019-12-03 01:31:40] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:31:56] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:31:56] INFO: DB update done for unstable/arm64 done at 2019-12-03 01:31:56.
[2019-12-03 01:31:56] INFO: Updating sources db for unstable/armhf...
[2019-12-03 01:32:22] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:32:36] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:32:36] INFO: DB update done for unstable/armhf done at 2019-12-03 01:32:36.
[2019-12-03 01:32:36] INFO: Sources for suite unstable done at 2019-12-03 01:32:36.
[2019-12-03 01:32:36] INFO: Downloading sources file for experimental: http://deb.debian.org/debian/dists/experimental/main/source/Sources.xz
[2019-12-03 01:32:37] INFO: Updating sources db for experimental/amd64...
[2019-12-03 01:32:38] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:32:38] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:32:38] INFO: DB update done for experimental/amd64 done at 2019-12-03 01:32:38.
[2019-12-03 01:32:38] INFO: Updating sources db for experimental/i386...
[2019-12-03 01:32:38] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:32:38] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:32:39] INFO: DB update done for experimental/i386 done at 2019-12-03 01:32:39.
[2019-12-03 01:32:39] INFO: Updating sources db for experimental/arm64...
[2019-12-03 01:32:39] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:32:39] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:32:39] INFO: DB update done for experimental/arm64 done at 2019-12-03 01:32:39.
[2019-12-03 01:32:39] INFO: Updating sources db for experimental/armhf...
[2019-12-03 01:32:40] INFO: Pushing 0 updated packages to the database...
[2019-12-03 01:32:40] INFO: Now deleting 0 removed packages: []
[2019-12-03 01:32:40] INFO: DB update done for experimental/armhf done at 2019-12-03 01:32:40.
[2019-12-03 01:32:40] INFO: Sources for suite experimental done at 2019-12-03 01:32:40.
[2019-12-03 01:32:40] INFO: Removing old pages from stretch/amd64.
[2019-12-03 01:32:41] INFO: Removing old pages from stretch/amd64/diffoscope-results/.
[2019-12-03 01:32:41] INFO: Removing old pages from stretch/i386.
[2019-12-03 01:32:41] INFO: Removing old pages from stretch/i386/diffoscope-results/.
[2019-12-03 01:32:41] INFO: Removing old pages from stretch/arm64.
[2019-12-03 01:32:41] INFO: Removing old pages from stretch/arm64/diffoscope-results/.
[2019-12-03 01:32:41] INFO: Removing old pages from stretch/armhf.
[2019-12-03 01:32:42] INFO: Removing old pages from stretch/armhf/diffoscope-results/.
[2019-12-03 01:32:42] INFO: Removing old pages from buster/amd64.
[2019-12-03 01:32:42] INFO: Removing old pages from buster/amd64/diffoscope-results/.
[2019-12-03 01:32:42] INFO: Removing old pages from buster/i386.
[2019-12-03 01:32:42] INFO: Removing old pages from buster/i386/diffoscope-results/.
[2019-12-03 01:32:42] INFO: Removing old pages from buster/arm64.
[2019-12-03 01:32:42] INFO: Removing old pages from buster/arm64/diffoscope-results/.
[2019-12-03 01:32:42] INFO: Removing old pages from buster/armhf.
[2019-12-03 01:32:43] INFO: Removing old pages from buster/armhf/diffoscope-results/.
[2019-12-03 01:32:43] INFO: Removing old pages from bullseye/amd64.
[2019-12-03 01:32:43] INFO: Removing old pages from bullseye/amd64/diffoscope-results/.
[2019-12-03 01:32:43] INFO: Removing old pages from bullseye/i386.
[2019-12-03 01:32:43] INFO: Removing old pages from bullseye/i386/diffoscope-results/.
[2019-12-03 01:32:43] INFO: Removing old pages from bullseye/arm64.
[2019-12-03 01:32:44] INFO: Removing old pages from bullseye/arm64/diffoscope-results/.
[2019-12-03 01:32:44] INFO: Removing old pages from bullseye/armhf.
[2019-12-03 01:32:44] INFO: Removing old pages from bullseye/armhf/diffoscope-results/.
[2019-12-03 01:32:44] INFO: Removing old pages from unstable/amd64.
[2019-12-03 01:32:44] INFO: Removing old pages from unstable/amd64/diffoscope-results/.
[2019-12-03 01:32:44] INFO: Removing old pages from unstable/i386.
[2019-12-03 01:32:45] INFO: Removing old pages from unstable/i386/diffoscope-results/.
[2019-12-03 01:32:45] INFO: Removing old pages from unstable/arm64.
[2019-12-03 01:32:45] INFO: Removing old pages from unstable/arm64/diffoscope-results/.
[2019-12-03 01:32:45] INFO: Removing old pages from unstable/armhf.
[2019-12-03 01:32:46] INFO: Removing old pages from unstable/armhf/diffoscope-results/.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/amd64.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/amd64/diffoscope-results/.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/i386.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/i386/diffoscope-results/.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/arm64.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/arm64/diffoscope-results/.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/armhf.
[2019-12-03 01:32:46] INFO: Removing old pages from experimental/armhf/diffoscope-results/.
[2019-12-03 01:32:46] INFO: Scheduling for amd64...
[2019-12-03 01:32:46] INFO: 2071 packages already scheduled for amd64, probably scheduling some more...
[2019-12-03 01:32:46] INFO: ==============================================================
[2019-12-03 01:32:46] INFO: Currently scheduled packages in all suites on amd64: 2071
[2019-12-03 01:32:46] INFO: 2071 packages already scheduled, only scheduling new versions.
[2019-12-03 01:32:46] 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 01:32:46] INFO: Finished at 2019-12-03 01:32:46.479930, took: 0:09:39.636004
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list