[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #17616

Mon Dec 19 13:00:16 UTC 2016

https://jenkins.debian.net/job/reproducible_scheduler/17616/------------------------------------------
Started by timer
[EnvInject] - Loading node environment variables.
Building on master in workspace <https://jenkins.debian.net/job/reproducible_scheduler/ws/>
[workspace] $ /bin/sh -xe /tmp/hudson3168752716175960085.sh
+ /srv/jenkins/bin/reproducible_scheduler.py
INFO: Starting at 2016-12-19 12:55:04.486345
INFO: finding out which usertagged bugs have been closed or at least have patches
INFO: finding out which usertagged bugs have been closed or at least have patches
INFO: Updating sources tables for all suites.
INFO: Downloading sources file for testing: http://ftp.de.debian.org/debian/dists/testing/main/source/Sources.xz
INFO: Updating sources db for testing/amd64...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for testing/amd64 done at 2016-12-19 12:55:47.864022.
INFO: Updating sources db for testing/i386...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for testing/i386 done at 2016-12-19 12:56:27.523836.
INFO: Updating sources db for testing/armhf...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for testing/armhf done at 2016-12-19 12:57:05.507701.
INFO: Sources for suite testing done at 2016-12-19 12:57:05.513382.
INFO: Downloading sources file for unstable: http://ftp.de.debian.org/debian/dists/unstable/main/source/Sources.xz
INFO: Updating sources db for unstable/amd64...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for unstable/amd64 done at 2016-12-19 12:57:48.145334.
INFO: Updating sources db for unstable/i386...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for unstable/i386 done at 2016-12-19 12:58:31.101178.
INFO: Updating sources db for unstable/armhf...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for unstable/armhf done at 2016-12-19 12:59:15.907615.
INFO: Sources for suite unstable done at 2016-12-19 12:59:15.916948.
INFO: Downloading sources file for experimental: http://ftp.de.debian.org/debian/dists/experimental/main/source/Sources.xz
INFO: Updating sources db for experimental/amd64...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for experimental/amd64 done at 2016-12-19 12:59:16.836252.
INFO: Updating sources db for experimental/i386...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for experimental/i386 done at 2016-12-19 12:59:17.504698.
INFO: Updating sources db for experimental/armhf...
INFO: Pushing 0 updated packages to the database...
INFO: Now deleting 0 removed packages: []
INFO: DB update done for experimental/armhf done at 2016-12-19 12:59:18.166698.
INFO: Sources for suite experimental done at 2016-12-19 12:59:18.167011.
INFO: Removing old pages from testing/amd64.
INFO: Removing old pages from testing/amd64/diffoscope-results/.
INFO: Removing old pages from testing/i386.
INFO: Removing old pages from testing/i386/diffoscope-results/.
INFO: Removing old pages from testing/armhf.
INFO: Removing old pages from testing/armhf/diffoscope-results/.
INFO: Removing old pages from unstable/amd64.
INFO: Removing old pages from unstable/amd64/diffoscope-results/.
INFO: Removing old pages from unstable/i386.
INFO: Removing old pages from unstable/i386/diffoscope-results/.
INFO: Removing old pages from unstable/armhf.
INFO: Removing old pages from unstable/armhf/diffoscope-results/.
INFO: Removing old pages from experimental/amd64.
INFO: Removing old pages from experimental/amd64/diffoscope-results/.
INFO: Removing old pages from experimental/i386.
INFO: Removing old pages from experimental/i386/diffoscope-results/.
INFO: Removing old pages from experimental/armhf.
INFO: Removing old pages from experimental/armhf/diffoscope-results/.
INFO: Scheduling for amd64...
INFO: 0 packages already scheduled for amd64, probably scheduling some more...
INFO: ==============================================================
INFO: Currently scheduled packages in all suites on amd64: 0
INFO: 0 packages already scheduled, scheduling some more...
INFO: Requesting 440 untested packages in testing/amd64...
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
psycopg2.ProgrammingError: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 7:                ORDER BY random()
                                ^

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

Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 720, in <module>
    message += scheduler(arch) + '\n'
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 644, in scheduler
    untested, msg_untested = schedule_untested_packages(arch, total)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 514, in schedule_untested_packages
    packages[suite] = query_untested_packages(suite, arch, many_untested)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 402, in query_untested_packages
    packages = query_db(query)
  File "/srv/jenkins/bin/reproducible_common.py", line 390, in query_db
    result = conn_db.execute(query)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 188, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 181, in reraise
    raise value.with_traceback(tb)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 7:                ORDER BY random()
                                ^
 "SELECT DISTINCT sources.id, sources.name FROM sources\n               WHERE sources.suite='testing' AND sources.architecture='amd64'\n               AND sources.id NOT IN\n                       (SELECT schedule.package_id FROM schedule)\n               AND sources.id NOT IN\n                       (SELECT results.package_id FROM results)\n               ORDER BY random()\n               LIMIT 440" {}
INFO: Finished at 2016-12-19 13:00:15.642673, took: 0:05:11.156348
Build step 'Execute shell' marked build as failure