[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #17034
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Mon Oct 17 14:34:55 UTC 2016
https://jenkins.debian.net/job/reproducible_scheduler/17034/------------------------------------------
Started by timer
Started by timer
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/hudson8293743643591548210.sh
+ /srv/jenkins/bin/reproducible_scheduler.py
INFO: Starting at 2016-10-17 12:00:08.319022
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-10-17 12:23:25.869720.
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-10-17 12:47:04.992844.
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-10-17 13:11:11.455080.
INFO: Sources for suite testing done at 2016-10-17 13:11:11.470400.
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-10-17 13:38:57.905091.
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-10-17 14:06:09.105715.
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-10-17 14:34:12.618535.
INFO: Sources for suite unstable done at 2016-10-17 14:34:12.629250.
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-10-17 14:34:17.241783.
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-10-17 14:34:21.741530.
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-10-17 14:34:25.966151.
INFO: Sources for suite experimental done at 2016-10-17 14:34:25.966482.
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: 1579 packages already scheduled for amd64, probably scheduling some more...
INFO: ==============================================================
INFO: Currently scheduled packages in all suites on amd64: 1579
INFO: 1579 packages already scheduled, only scheduling new versions.
INFO: Requesting 100 new versions in testing/amd64...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: testing/amd64
INFO: Amount: 0
INFO: Packages:
INFO: Received 0 new packages in testing/amd64 to schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 150 new versions in unstable/amd64...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: unstable/amd64
INFO: Amount: 6
INFO: Packages: libhmsbeagle django-polymorphic zita-ajbridge ruby-handlebars-assets zookeeper starpy
INFO: Received 6 new packages in unstable/amd64 to schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 50 new versions in experimental/amd64...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: experimental/amd64
INFO: Amount: 0
INFO: Packages:
INFO: Received 0 new packages in experimental/amd64 to schedule.
INFO: --------------------------------------------------------------
INFO: The following 6 source packages have been queued up for scheduling at 2016-10-17 02:34: libhmsbeagle django-polymorphic zita-ajbridge ruby-handlebars-assets zookeeper starpy
INFO: Building the schedule index page for amd64...
INFO: Page generated at https://tests.reproducible-builds.org/debian/index_amd64_scheduled.html
INFO: Scheduling for architecture amd64 done.
INFO: --------------------------------------------------------------
INFO: Arch amd64 scheduled at 2016-10-17 14:34:52.522229.
INFO: Scheduling for i386...
INFO: 1371 packages already scheduled for i386, probably scheduling some more...
INFO: ==============================================================
INFO: Currently scheduled packages in all suites on i386: 1371
INFO: 1371 packages already scheduled, only scheduling new versions.
INFO: Requesting 100 new versions in testing/i386...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: testing/i386
INFO: Amount: 0
INFO: Packages:
INFO: Received 0 new packages in testing/i386 to schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 150 new versions in unstable/i386...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: unstable/i386
INFO: Amount: 2
INFO: Packages: ruby-handlebars-assets starpy
INFO: Received 2 new packages in unstable/i386 to schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 50 new versions in experimental/i386...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: experimental/i386
INFO: Amount: 0
INFO: Packages:
INFO: Received 0 new packages in experimental/i386 to schedule.
INFO: --------------------------------------------------------------
INFO: The following 2 source packages have been queued up for scheduling at 2016-10-17 02:34: ruby-handlebars-assets starpy
INFO: Building the schedule index page for i386...
INFO: Page generated at https://tests.reproducible-builds.org/debian/index_i386_scheduled.html
INFO: Scheduling for architecture i386 done.
INFO: --------------------------------------------------------------
INFO: Arch i386 scheduled at 2016-10-17 14:34:54.518276.
INFO: Scheduling for armhf...
INFO: 540 packages already scheduled for armhf, probably scheduling some more...
INFO: ==============================================================
INFO: Currently scheduled packages in all suites on armhf: 540
INFO: 540 packages already scheduled, scheduling some more...
INFO: Requesting 440 untested packages in testing/armhf...
INFO: Criteria: not tested before, randomly sorted
INFO: Suite/Arch: testing/armhf
INFO: Amount: 11
INFO: Packages: gli fitsh aiodns ironic-ui commonmark-bkrs node-source-map-support zaqar-ui bbpager pymoc ruby-rgfa python-watcherclient
INFO: Received 11 untested packages in testing/armhfto schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 440 untested packages in unstable/armhf...
INFO: Criteria: not tested before, randomly sorted
INFO: Suite/Arch: unstable/armhf
INFO: Amount: 0
INFO: Packages:
INFO: Received 0 untested packages in unstable/armhfto schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 440 untested packages in experimental/armhf...
INFO: Criteria: not tested before, randomly sorted
INFO: Suite/Arch: experimental/armhf
INFO: Amount: 186
INFO: Packages: haskell-safecopy haskell-netwire haskell-basic-prelude haskell-tasty-kat haskell-terminal-progress-bar haskell-exception-transformers haskell-with-location haskell-blaze-textual haskell-arrows haskell-finite-field haskell-monad-par haskell-glob haskell-aeson haskell-blaze-html haskell-shake haskell-regex-applicative haskell-bindings-nettle haskell-http haskell-static-hash haskell-diagrams-lib haskell-retry haskell-regex-applicative-text haskell-dbus haskell-quickcheck-instances haskell-incremental-parser uuagc haskell-sdl haskell-stringprep haskell-pem haskell-mueval haskell-diagrams-svg haskell-map-syntax c2hs haskell-ixset-typed haskell-djinn-ghc haskell-x11 haskell-quickcheck-simple haskell-language-javascript haskell-bytestring-progress haskell-relational-query haskell-hxt-http haskell-acid-state haskell-temporary haskell-hledger haskell-hmatrix-gsl haskell-process-extras haskell-tasty-th haskell-iso8601-time haskell-reform-happstack haskell-text-icu haskell-lucid gnome-applets haskell-dynamic-state haskell-math-functions haskell-skein haskell-oeis haskell-derive lhs2tex haskell-numbers haskell-listlike haskell-hsx2hs haskell-persistable-record haskell-hxt-relaxng haskell-ghc-mtl haskell-sdl-gfx haskell-mime-mail haskell-double-conversion haskell-word-trie haskell-relational-schemas haskell-presburger haskell-lambdabot-trusted haskell-language-c haskell-io-choice haskell-word8 haskell-stream haskell-quickcheck-safe haskell-recursion-schemes haskell-random-source haskell-src-meta haskell-deepseq-generics haskell-raaz haskell-cairo haskell-system-filepath tmux haskell-logging-facade haskell-hjsmin haskell-svg-builder haskell-glib haskell-monad-unlift haskell-concurrent-output haskell-vty haskell-bytestring-handle haskell-vector-binary-instances haskell-should-not-typecheck haskell-tasty-golden haskell-blaze-svg haskell-recaptcha haskell-graphviz haskell-monad-loops haskell-polynomial haskell-base64-bytestring haskell-rvar haskell-hxt-tagsoup haskell-text-postgresql bnfc haskell-cgi agda libapache2-mod-perl2 haskell-uniplate haskell-psqueues haskell-load-env haskell-configfile haskell-resource-pool haskell-mockery haskell-js-flot haskell-lifted-async haskell-dpkg haskell-edison-core haskell-hsh haskell-juicypixels haskell-chell-quickcheck2 haskell-data-hash haskell-hourglass haskell-hledger-lib gtk2hs-buildtools haskell-ekg-core haskell-test-framework-th haskell-constraints haskell-equivalence haskell-hspec-contrib haskell-happstack-hsp haskell-sbv haskell-ixset haskell-gloss-rendering haskell-gloss haskell-fdo-notify haskell-hashmap haskell-ncurses haskell-reform-hsp haskell-xmlhtml haskell-hxt haskell-happstack-server haskell-vector-th-unbox missingh haskell-diagrams-core haskell-xml-types haskell-path-pieces frown haskell-network-protocol-xmpp haskell-language-python haskell-hgettext haskell-interpolate haskell-gnuidn ftphs haskell-idna haskell-pipes-safe haskell-enclosed-exceptions haskell-applicative-quoters haskell-lucid-svg haskell-fsnotify haskell-hint haskell-charset haskell-vault haskell-repa highlighting-kate haskell-asn1-types haskell-microlens-platform haskell-cabal-helper haskell-hslua haskell-cryptonite haskell-reactive-banana haskell-diagrams haskell-test-framework-th-prime haskell-bytestring-lexing haskell-sql-words haskell-blaze-markup haskell-expiring-cache-map haskell-text-zipper firejail haskell-file-location haskell-iospec haskell-hmatrix haskell-bloomfilter haskell-hashtables haskell-readargs haskell-dimensional
INFO: Received 186 untested packages in experimental/armhfto schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 50 new versions in testing/armhf...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: testing/armhf
INFO: Amount: 9
INFO: Packages: python-nine xfce4-radio-plugin csync2 kdepimlibs libpar-perl knot-resolver sahara-dashboard cinder sphinx-testing
INFO: Received 9 new packages in testing/armhf to schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 75 new versions in unstable/armhf...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: unstable/armhf
INFO: Amount: 2
INFO: Packages: ruby-handlebars-assets starpy
INFO: Received 2 new packages in unstable/armhf to schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 25 new versions in experimental/armhf...
INFO: Criteria: tested before, new version available, sorted by last build date
INFO: Suite/Arch: experimental/armhf
INFO: Amount: 0
INFO: Packages:
INFO: Received 0 new packages in experimental/armhf to schedule.
INFO: --------------------------------------------------------------
INFO: Requesting 20 old ftbfs packages in testing/armhf...
CRITICAL: Error executing 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: JOIN notes AS n ON n.package_id=s.id
CRITICAL: WHERE s.suite='testing' AND s.architecture='armhf'
CRITICAL: AND r.status='FTBFS'
CRITICAL: AND ( n.bugs = '[]' OR n.bugs IS NULL )
CRITICAL: AND r.build_date < 2016-10-14 14:34
CRITICAL: AND s.id NOT IN (SELECT schedule.package_id FROM schedule)
CRITICAL: ORDER BY r.build_date
CRITICAL: LIMIT 20
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)
sqlite3.OperationalError: near "14": syntax error
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/srv/jenkins/bin/reproducible_scheduler.py", line 700, in <module>
message += scheduler(arch)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 626, in scheduler
old_ftbfs, msg_old_ftbfs = schedule_old_ftbfs_versions(arch, total+len(untested)+len(new))
File "/srv/jenkins/bin/reproducible_scheduler.py", line 534, in schedule_old_ftbfs_versions
packages[suite] = query_old_ftbfs_versions(suite, arch, old_ftbfs)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 428, in query_old_ftbfs_versions
packages = query_db(query)
File "/srv/jenkins/bin/reproducible_common.py", line 387, 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.OperationalError: (OperationalError) near "14": syntax error "SELECT DISTINCT s.id, s.name\n FROM sources AS s JOIN results AS r ON s.id = r.package_id\n JOIN notes AS n ON n.package_id=s.id\n WHERE s.suite='testing' AND s.architecture='armhf'\n AND r.status='FTBFS'\n AND ( n.bugs = '[]' OR n.bugs IS NULL )\n AND r.build_date < 2016-10-14 14:34\n AND s.id NOT IN (SELECT schedule.package_id FROM schedule)\n ORDER BY r.build_date\n LIMIT 20" ()
INFO: Finished at 2016-10-17 14:34:55.448631, took: 2:34:47.129621
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list