[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #26042
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Mon Dec 2 21:32:17 GMT 2019
See <https://jenkins.debian.net/job/reproducible_scheduler/26042/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/jenkins14515194848924014319.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 21:23:03] INFO: Starting at 2019-12-02 21:23:03.340175
[2019-12-02 21:23:03] INFO: Updating sources tables for all suites.
[2019-12-02 21:23:03] INFO: Downloading sources file for stretch: http://deb.debian.org/debian/dists/stretch/main/source/Sources.xz
[2019-12-02 21:23:05] 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 21:23:24] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:23:33] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:23:33] INFO: DB update done for stretch/amd64 done at 2019-12-02 21:23:33.
[2019-12-02 21:23:33] INFO: Updating sources db for stretch/i386...
[2019-12-02 21:23:51] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:23:59] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:23:59] INFO: DB update done for stretch/i386 done at 2019-12-02 21:23:59.
[2019-12-02 21:23:59] INFO: Updating sources db for stretch/arm64...
[2019-12-02 21:24:19] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:24:28] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:24:28] INFO: DB update done for stretch/arm64 done at 2019-12-02 21:24:28.
[2019-12-02 21:24:28] INFO: Updating sources db for stretch/armhf...
[2019-12-02 21:24:49] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:24:58] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:24:59] INFO: DB update done for stretch/armhf done at 2019-12-02 21:24:59.
[2019-12-02 21:24:59] INFO: Sources for suite stretch done at 2019-12-02 21:24:59.
[2019-12-02 21:24:59] INFO: Downloading sources file for buster: http://deb.debian.org/debian/dists/buster/main/source/Sources.xz
[2019-12-02 21:25:00] INFO: Updating sources db for buster/amd64...
[2019-12-02 21:25:23] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:25:35] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:25:35] INFO: DB update done for buster/amd64 done at 2019-12-02 21:25:35.
[2019-12-02 21:25:35] INFO: Updating sources db for buster/i386...
[2019-12-02 21:25:58] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:26:11] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:26:11] INFO: DB update done for buster/i386 done at 2019-12-02 21:26:11.
[2019-12-02 21:26:11] INFO: Updating sources db for buster/arm64...
[2019-12-02 21:26:33] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:26:45] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:26:45] INFO: DB update done for buster/arm64 done at 2019-12-02 21:26:45.
[2019-12-02 21:26:45] INFO: Updating sources db for buster/armhf...
[2019-12-02 21:27:07] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:27:22] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:27:22] INFO: DB update done for buster/armhf done at 2019-12-02 21:27:22.
[2019-12-02 21:27:22] INFO: Sources for suite buster done at 2019-12-02 21:27:22.
[2019-12-02 21:27:22] INFO: Downloading sources file for bullseye: http://deb.debian.org/debian/dists/bullseye/main/source/Sources.xz
[2019-12-02 21:27:23] INFO: Updating sources db for bullseye/amd64...
[2019-12-02 21:27:44] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:27:56] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:27:56] INFO: DB update done for bullseye/amd64 done at 2019-12-02 21:27:56.
[2019-12-02 21:27:56] INFO: Updating sources db for bullseye/i386...
[2019-12-02 21:28:17] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:28:29] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:28:30] INFO: DB update done for bullseye/i386 done at 2019-12-02 21:28:30.
[2019-12-02 21:28:30] INFO: Updating sources db for bullseye/arm64...
[2019-12-02 21:28:50] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:29:02] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:29:02] INFO: DB update done for bullseye/arm64 done at 2019-12-02 21:29:02.
[2019-12-02 21:29:02] INFO: Updating sources db for bullseye/armhf...
[2019-12-02 21:29:24] INFO: Pushing 0 updated packages to the database...
[2019-12-02 21:29:34] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:29:34] INFO: DB update done for bullseye/armhf done at 2019-12-02 21:29:34.
[2019-12-02 21:29:34] INFO: Sources for suite bullseye done at 2019-12-02 21:29:34.
[2019-12-02 21:29:34] INFO: Downloading sources file for unstable: http://deb.debian.org/debian/dists/unstable/main/source/Sources.xz
[2019-12-02 21:29:36] INFO: Updating sources db for unstable/amd64...
[2019-12-02 21:29:59] INFO: Pushing 20 updated packages to the database...
[2019-12-02 21:30:00] INFO: Now inserting 1 new sources in the database: [{'name': 'ruby-atlassian-jwt', 'version': '0.2.0-2', 'suite': 'unstable', 'architecture': 'amd64'}]
[2019-12-02 21:30:14] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:30:14] INFO: Building pages for the new packages
[2019-12-02 21:30:14] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:30:14] INFO: DB update done for unstable/amd64 done at 2019-12-02 21:30:14.
[2019-12-02 21:30:14] INFO: Updating sources db for unstable/i386...
[2019-12-02 21:30:38] INFO: Pushing 20 updated packages to the database...
[2019-12-02 21:30:38] INFO: Now inserting 1 new sources in the database: [{'name': 'ruby-atlassian-jwt', 'version': '0.2.0-2', 'suite': 'unstable', 'architecture': 'i386'}]
[2019-12-02 21:30:51] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:30:51] INFO: Building pages for the new packages
[2019-12-02 21:30:51] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:30:51] INFO: DB update done for unstable/i386 done at 2019-12-02 21:30:51.
[2019-12-02 21:30:51] INFO: Updating sources db for unstable/arm64...
[2019-12-02 21:31:15] INFO: Pushing 20 updated packages to the database...
[2019-12-02 21:31:15] INFO: Now inserting 1 new sources in the database: [{'name': 'ruby-atlassian-jwt', 'version': '0.2.0-2', 'suite': 'unstable', 'architecture': 'arm64'}]
[2019-12-02 21:31:29] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:31:29] INFO: Building pages for the new packages
[2019-12-02 21:31:29] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:31:29] INFO: DB update done for unstable/arm64 done at 2019-12-02 21:31:29.
[2019-12-02 21:31:29] INFO: Updating sources db for unstable/armhf...
[2019-12-02 21:31:53] INFO: Pushing 20 updated packages to the database...
[2019-12-02 21:31:53] INFO: Now inserting 1 new sources in the database: [{'name': 'ruby-atlassian-jwt', 'version': '0.2.0-2', 'suite': 'unstable', 'architecture': 'armhf'}]
[2019-12-02 21:32:07] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:32:07] INFO: Building pages for the new packages
[2019-12-02 21:32:07] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:32:07] INFO: DB update done for unstable/armhf done at 2019-12-02 21:32:07.
[2019-12-02 21:32:07] INFO: Sources for suite unstable done at 2019-12-02 21:32:07.
[2019-12-02 21:32:07] INFO: Downloading sources file for experimental: http://deb.debian.org/debian/dists/experimental/main/source/Sources.xz
[2019-12-02 21:32:08] INFO: Updating sources db for experimental/amd64...
[2019-12-02 21:32:08] INFO: Pushing 1 updated packages to the database...
[2019-12-02 21:32:08] INFO: Now inserting 1 new sources in the database: [{'name': 'spyder-kernels', 'version': '1.8.0-1', 'suite': 'experimental', 'architecture': 'amd64'}]
[2019-12-02 21:32:08] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:32:08] INFO: Building pages for the new packages
[2019-12-02 21:32:08] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:32:09] INFO: DB update done for experimental/amd64 done at 2019-12-02 21:32:09.
[2019-12-02 21:32:09] INFO: Updating sources db for experimental/i386...
[2019-12-02 21:32:09] INFO: Pushing 1 updated packages to the database...
[2019-12-02 21:32:09] INFO: Now inserting 1 new sources in the database: [{'name': 'spyder-kernels', 'version': '1.8.0-1', 'suite': 'experimental', 'architecture': 'i386'}]
[2019-12-02 21:32:09] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:32:09] INFO: Building pages for the new packages
[2019-12-02 21:32:09] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:32:10] INFO: DB update done for experimental/i386 done at 2019-12-02 21:32:10.
[2019-12-02 21:32:10] INFO: Updating sources db for experimental/arm64...
[2019-12-02 21:32:10] INFO: Pushing 1 updated packages to the database...
[2019-12-02 21:32:10] INFO: Now inserting 1 new sources in the database: [{'name': 'spyder-kernels', 'version': '1.8.0-1', 'suite': 'experimental', 'architecture': 'arm64'}]
[2019-12-02 21:32:10] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:32:10] INFO: Building pages for the new packages
[2019-12-02 21:32:10] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:32:10] INFO: DB update done for experimental/arm64 done at 2019-12-02 21:32:10.
[2019-12-02 21:32:10] INFO: Updating sources db for experimental/armhf...
[2019-12-02 21:32:11] INFO: Pushing 1 updated packages to the database...
[2019-12-02 21:32:11] INFO: Now inserting 1 new sources in the database: [{'name': 'spyder-kernels', 'version': '1.8.0-1', 'suite': 'experimental', 'architecture': 'armhf'}]
[2019-12-02 21:32:11] INFO: Now deleting 0 removed packages: []
[2019-12-02 21:32:11] INFO: Building pages for the new packages
[2019-12-02 21:32:11] INFO: Generating the pages of 1 package(s)
[2019-12-02 21:32:11] INFO: DB update done for experimental/armhf done at 2019-12-02 21:32:11.
[2019-12-02 21:32:11] INFO: Sources for suite experimental done at 2019-12-02 21:32:11.
[2019-12-02 21:32:11] INFO: Removing old pages from stretch/amd64.
[2019-12-02 21:32:11] INFO: Removing old pages from stretch/amd64/diffoscope-results/.
[2019-12-02 21:32:11] INFO: Removing old pages from stretch/i386.
[2019-12-02 21:32:12] INFO: Removing old pages from stretch/i386/diffoscope-results/.
[2019-12-02 21:32:12] INFO: Removing old pages from stretch/arm64.
[2019-12-02 21:32:12] INFO: Removing old pages from stretch/arm64/diffoscope-results/.
[2019-12-02 21:32:12] INFO: Removing old pages from stretch/armhf.
[2019-12-02 21:32:12] INFO: Removing old pages from stretch/armhf/diffoscope-results/.
[2019-12-02 21:32:12] INFO: Removing old pages from buster/amd64.
[2019-12-02 21:32:13] INFO: Removing old pages from buster/amd64/diffoscope-results/.
[2019-12-02 21:32:13] INFO: Removing old pages from buster/i386.
[2019-12-02 21:32:13] INFO: Removing old pages from buster/i386/diffoscope-results/.
[2019-12-02 21:32:13] INFO: Removing old pages from buster/arm64.
[2019-12-02 21:32:13] INFO: Removing old pages from buster/arm64/diffoscope-results/.
[2019-12-02 21:32:13] INFO: Removing old pages from buster/armhf.
[2019-12-02 21:32:14] INFO: Removing old pages from buster/armhf/diffoscope-results/.
[2019-12-02 21:32:14] INFO: Removing old pages from bullseye/amd64.
[2019-12-02 21:32:14] INFO: Removing old pages from bullseye/amd64/diffoscope-results/.
[2019-12-02 21:32:14] INFO: Removing old pages from bullseye/i386.
[2019-12-02 21:32:14] INFO: Removing old pages from bullseye/i386/diffoscope-results/.
[2019-12-02 21:32:14] INFO: Removing old pages from bullseye/arm64.
[2019-12-02 21:32:15] INFO: Removing old pages from bullseye/arm64/diffoscope-results/.
[2019-12-02 21:32:15] INFO: Removing old pages from bullseye/armhf.
[2019-12-02 21:32:15] INFO: Removing old pages from bullseye/armhf/diffoscope-results/.
[2019-12-02 21:32:15] INFO: Removing old pages from unstable/amd64.
[2019-12-02 21:32:15] INFO: Removing old pages from unstable/amd64/diffoscope-results/.
[2019-12-02 21:32:15] INFO: Removing old pages from unstable/i386.
[2019-12-02 21:32:16] INFO: Removing old pages from unstable/i386/diffoscope-results/.
[2019-12-02 21:32:16] INFO: Removing old pages from unstable/arm64.
[2019-12-02 21:32:16] INFO: Removing old pages from unstable/arm64/diffoscope-results/.
[2019-12-02 21:32:16] INFO: Removing old pages from unstable/armhf.
[2019-12-02 21:32:17] INFO: Removing old pages from unstable/armhf/diffoscope-results/.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/amd64.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/amd64/diffoscope-results/.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/i386.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/i386/diffoscope-results/.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/arm64.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/arm64/diffoscope-results/.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/armhf.
[2019-12-02 21:32:17] INFO: Removing old pages from experimental/armhf/diffoscope-results/.
[2019-12-02 21:32:17] INFO: Scheduling for amd64...
[2019-12-02 21:32:17] INFO: 2143 packages already scheduled for amd64, probably scheduling some more...
[2019-12-02 21:32:17] INFO: ==============================================================
[2019-12-02 21:32:17] INFO: Currently scheduled packages in all suites on amd64: 2143
[2019-12-02 21:32:17] INFO: 2143 packages already scheduled, only scheduling new versions.
[2019-12-02 21:32:17] 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 21:32:17] INFO: Finished at 2019-12-02 21:32:17.450770, took: 0:09:14.110604
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list