[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #7285
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Fri Jul 31 10:45:20 UTC 2015
See <https://jenkins.debian.net/job/reproducible_scheduler/7285/>
------------------------------------------
Started by timer
Building in workspace <https://jenkins.debian.net/job/reproducible_scheduler/ws/>
[workspace] $ /bin/sh -xe /tmp/hudson1742285547969027004.sh
+ /srv/jenkins/bin/reproducible_scheduler.py
INFO: Starting at 2015-07-31 10:42:56.539426
INFO: finding out which usertagged bugs have been closed or at least have patches
INFO: Updating schroots and sources tables for all suites.
Get:1 http://ftp.de.debian.org testing InRelease [129 kB]
Hit http://reproducible.alioth.debian.org ./ InRelease
Hit http://reproducible.alioth.debian.org ./ Sources
Get:2 http://ftp.de.debian.org testing/main Sources/DiffIndex [7876 B]
Hit http://reproducible.alioth.debian.org ./ Packages
Get:3 http://ftp.de.debian.org testing/main amd64 Packages/DiffIndex [7876 B]
Get:4 http://ftp.de.debian.org testing/main Translation-en/DiffIndex [7876 B]
Ign http://reproducible.alioth.debian.org ./ Translation-en
Fetched 152 kB in 2s (75.3 kB/s)
Reading package lists...
INFO: Downloading sources file for testing: http://ftp.de.debian.org/debian/dists/testing/main/source/Sources.xz
INFO: Pushing 0 updated packages to the database...
INFO: Now inserting 0 new sources in the database: []
INFO: Now deleting 0 removed packages: []
Get:1 http://ftp.de.debian.org unstable InRelease [200 kB]
Hit http://reproducible.alioth.debian.org ./ InRelease
Hit http://reproducible.alioth.debian.org ./ Sources
Get:2 http://ftp.de.debian.org unstable/main Sources/DiffIndex [7876 B]
Hit http://reproducible.alioth.debian.org ./ Packages
Get:3 http://ftp.de.debian.org unstable/main amd64 Packages/DiffIndex [7876 B]
Get:4 http://ftp.de.debian.org unstable/main Translation-en/DiffIndex [7876 B]
Get:5 http://ftp.de.debian.org unstable/main 2015-07-31-0848.40.pdiff [10.1 kB]
Get:6 http://ftp.de.debian.org unstable/main amd64 2015-07-31-0848.40.pdiff [61.6 kB]
Get:7 http://ftp.de.debian.org unstable/main 2015-07-31-0848.40.pdiff [10.1 kB]
Get:8 http://ftp.de.debian.org unstable/main 2015-07-31-0848.40.pdiff [617 B]
Ign http://reproducible.alioth.debian.org ./ Translation-en
Get:9 http://ftp.de.debian.org unstable/main amd64 2015-07-31-0848.40.pdiff [61.6 kB]
Get:10 http://ftp.de.debian.org unstable/main 2015-07-31-0848.40.pdiff [617 B]
Fetched 296 kB in 6s (47.7 kB/s)
Reading package lists...
INFO: Downloading sources file for unstable: http://ftp.de.debian.org/debian/dists/unstable/main/source/Sources.xz
INFO: Pushing 17 updated packages to the database...
INFO: Now inserting 0 new sources in the database: []
INFO: Now deleting 0 removed packages: []
Get:1 http://ftp.de.debian.org sid InRelease [200 kB]
Hit http://reproducible.alioth.debian.org ./ InRelease
Get:2 http://ftp.de.debian.org experimental InRelease [152 kB]
Get:3 http://ftp.de.debian.org sid/main Sources/DiffIndex [7876 B]
Get:4 http://ftp.de.debian.org sid/main amd64 Packages/DiffIndex [7876 B]
Get:5 http://ftp.de.debian.org sid/main Translation-en/DiffIndex [7876 B]
Hit http://reproducible.alioth.debian.org ./ Sources
Hit http://reproducible.alioth.debian.org ./ Packages
Get:6 http://ftp.de.debian.org sid/main 2015-07-31-0848.40.pdiff [10.1 kB]
Get:7 http://ftp.de.debian.org sid/main 2015-07-31-0848.40.pdiff [10.1 kB]
Get:8 http://ftp.de.debian.org experimental/main Sources/DiffIndex [7819 B]
Get:9 http://ftp.de.debian.org experimental/main amd64 Packages/DiffIndex [7819 B]
Get:10 http://ftp.de.debian.org experimental/main Translation-en/DiffIndex [7819 B]
Get:11 http://ftp.de.debian.org sid/main amd64 2015-07-31-0848.40.pdiff [61.6 kB]
Get:12 http://ftp.de.debian.org sid/main 2015-07-31-0848.40.pdiff [617 B]
Ign http://reproducible.alioth.debian.org ./ Translation-en
Get:13 http://ftp.de.debian.org experimental/main 2015-07-31-0848.40.pdiff [119 B]
Get:14 http://ftp.de.debian.org experimental/main amd64 2015-07-31-0848.40.pdiff [33 B]
Get:15 http://ftp.de.debian.org experimental/main 2015-07-31-0848.40.pdiff [33 B]
Get:16 http://ftp.de.debian.org sid/main amd64 2015-07-31-0848.40.pdiff [61.6 kB]
Get:17 http://ftp.de.debian.org sid/main 2015-07-31-0848.40.pdiff [617 B]
Get:18 http://ftp.de.debian.org experimental/main 2015-07-31-0848.40.pdiff [119 B]
Get:19 http://ftp.de.debian.org experimental/main amd64 2015-07-31-0848.40.pdiff [33 B]
Get:20 http://ftp.de.debian.org experimental/main 2015-07-31-0848.40.pdiff [33 B]
Fetched 471 kB in 6s (68.5 kB/s)
Reading package lists...
INFO: Downloading sources file for experimental: http://ftp.de.debian.org/debian/dists/experimental/main/source/Sources.xz
INFO: Pushing 0 updated packages to the database...
INFO: Now inserting 0 new sources in the database: []
INFO: Now deleting 1 removed packages: ['gcc-defaults']
INFO: Removing old pages from testing/amd64.
INFO: Removing old pages from unstable/amd64.
INFO: Removing old pages from experimental/amd64.
INFO: There is no package named gcc-defaults from experimental/amd64 in the database. Removing old page.
INFO: 695 packages already scheduled, scheduling some more...
INFO: Currently scheduled packages in all suites: 695
INFO: 695 packages already scheduled, scheduling some more...
INFO: ==============================================================
INFO: Requesting 444 untested packages in testing...
INFO: --------------------------------------------------------------
INFO: Criteria: not tested before, randomly sorted
INFO: Suite: testing
INFO: Amount: 33
INFO: Packages: libmsiecf sflphone hunt libmime-lite-tt-html-perl palabos golang-github-peterh-liner python-imaplib2 polymake madness libregf golang-gopkg-mgo.v2 calibre libvmdk libsmdev libesedb haildb libsmraw golang-github-boltdb-bolt libqcow libfwsi multimon libevtx python-mapnik r-cran-qvcalc libvhdi golang-gopkg-tomb.v2 libvshadow libevt liblnk libolecf redmine-plugin-local-avatars rdp-classifier montage
INFO: Received 33 untested packages in testing to schedule.
INFO: Requesting 444 untested packages in unstable...
INFO: --------------------------------------------------------------
INFO: Criteria: not tested before, randomly sorted
INFO: Suite: unstable
INFO: Amount: 2
INFO: Packages: pytest-localserver jeepyb
INFO: Received 2 untested packages in unstable to schedule.
INFO: Requesting 444 untested packages in experimental...
INFO: --------------------------------------------------------------
INFO: Criteria: not tested before, randomly sorted
INFO: Suite: experimental
INFO: Amount: 8
INFO: Packages: python-mistralclient python-os-brick python-keystonemiddleware python-taskflow ruby-arel tor keystone python-yaql
INFO: Received 8 untested packages in experimental to schedule.
INFO: ==============================================================
INFO: Requesting 150 new versions in testing...
INFO: --------------------------------------------------------------
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite: testing
INFO: Amount: 77
INFO: Packages: cpl-plugin-sinfo cpl-plugin-uves cpl-plugin-muse cpl-plugin-visir libjide-oss-java meld python-oauth2client cubemap v4l2loopback supertuxkart python-odf alien libvisio mapcache bbswitch bmake python-googleapi fiona runawk isdnutils liburi-find-perl octave-dataframe mk-configure network-console libxml-libxml-simple-perl clock-setup grub-installer debian-installer-utils hw-detect evtest deheader installation-report main-menu mdcfg iso-scan lvmcfg localechooser live-installer qtcreator net-retriever lilo-installer media-retriever kcalc libautodie-perl gnat-4.9 twisted console-setup xen-tools newt mapnik partman-basicfilesystems partman-auto code-saturne openldap exabgp mapserver libb-hooks-parser-perl pyserial bumblebee fcgiwrap libgraph-readwrite-perl s390-netdevice zipl-installer s390-dasd primus gcc-4.9 cross-gcc nobootloader padevchooser chromium-browser nlopt octave-splines libdata-random-perl cpl-plugin-fors cpl-plugin-kmos cpl-plugin-giraf cpl-plugin-amber
INFO: Received 77 new packages in testing to schedule.
INFO: Requesting 150 new versions in unstable...
INFO: --------------------------------------------------------------
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite: unstable
INFO: Amount: 64
INFO: Packages: canl-java goffice libgsf gnumeric libcpan-sqlite-perl conkeror mutagen quodlibet libgit-wrapper-perl libmath-gmp-perl haskell-conduit-extra cwidget i3-wm gcc-5-cross python3.4 mlt apt-cacher-ng sympa eventstat kinit libtest-tempdir-perl tasksel gcc-5 openafs systemtap flwm pyspatialite rake ruby-netcdf r-cran-bayesm php-log s3cmd bilibop datanommer.consumer eweouz libtest-spec-perl gcc-defaults xfsprogs datanommer.commands libtest-version-perl motion nikola libmodule-starter-perl ryu waagent wapiti gem2deb apertium-es-ro apertium-eu-es php-nette sound-icons netcdf4-python dnsmasq thefuck opam libcec-platform perceptualdiff wcsaxes stress-ng autofdo nim apertium-fr-ca apertium-fr-es r-cran-scales
INFO: Received 64 new packages in unstable to schedule.
INFO: Requesting 150 new versions in experimental...
INFO: --------------------------------------------------------------
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite: experimental
INFO: Amount: 12
INFO: Packages: python-oslotest python-oslo.db libvigraimpex python-oslo.vmware python-oslo.middleware python-os-client-config python-oslo.utils python-oslo.messaging grass knot netcdf4-python golang-raft
INFO: Received 12 new packages in experimental to schedule.
INFO: ==============================================================
INFO: Requesting 0 old ftbfs packages in testing...
CRITICAL: Error execting this query:
CRITICAL: SELECT DISTINCT s.id, s.name
CRITICAL: FROM sources AS s JOIN results AS r ON s.id = r.package_id
CRITICAL: OUTER JOIN notes AS n ON n.package_id=s.id
CRITICAL: WHERE s.suite='testing'
CRITICAL: AND r.status = 'FTBFS'
CRITICAL: AND ( n.bugs = '[]' OR n.bugs IS NULL )
CRITICAL: AND r.build_date < datetime('now', '-10 day')
CRITICAL: AND s.id NOT IN (SELECT schedule.package_id FROM schedule)
CRITICAL: ORDER BY r.build_date
CRITICAL: LIMIT 0
Traceback (most recent call last):
File "/srv/jenkins/bin/reproducible_scheduler.py", line 412, in <module>
scheduler()
File "/srv/jenkins/bin/reproducible_scheduler.py", line 346, in scheduler
old_ftbfs, msg_old_ftbfs = schedule_old_ftbfs_versions(total+len(untested)+len(new))
File "/srv/jenkins/bin/reproducible_scheduler.py", line 294, in schedule_old_ftbfs_versions
packages[suite] = query_old_ftbfs_versions(suite, old_ftbfs)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 226, in query_old_ftbfs_versions
packages = query_db(query)
File "/srv/jenkins/bin/reproducible_common.py", line 303, in query_db
cursor.execute(query)
sqlite3.OperationalError: RIGHT and FULL OUTER JOINs are not currently supported
INFO: Finished at 2015-07-31 10:45:20.570522, took: 0:02:24.031112
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list