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

jenkins at jenkins.debian.net jenkins at jenkins.debian.net
Fri Nov 12 13:48:11 GMT 2021


See <https://jenkins.debian.net/job/reproducible_scheduler/34173/display/redirect>

Changes:


------------------------------------------
[...truncated 12.39 KB...]
[2021-11-12 13:44:01] INFO: Removing old pages from experimental/armhf.
[2021-11-12 13:44:01] INFO: Removing old pages from experimental/armhf/diffoscope-results/.
[2021-11-12 13:44:01] INFO: Scheduling for amd64...
[2021-11-12 13:44:01] INFO: 2199 packages already scheduled for amd64, probably scheduling some more...
[2021-11-12 13:44:02] INFO: ==============================================================
[2021-11-12 13:44:02] INFO: Currently scheduled packages in all suites on amd64: 2199
[2021-11-12 13:44:02] INFO: 2199 packages already scheduled, only scheduling new versions.
[2021-11-12 13:44:02] INFO: Requesting 100 new versions in stretch/amd64...
[2021-11-12 13:44:02] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:02] INFO: Suite/Arch: stretch/amd64
[2021-11-12 13:44:02] INFO: Amount:     0
[2021-11-12 13:44:02] INFO: Packages:   
[2021-11-12 13:44:02] INFO: Received 0 new packages in stretch/amd64 to schedule.
[2021-11-12 13:44:02] INFO: --------------------------------------------------------------
[2021-11-12 13:44:02] INFO: Requesting 100 new versions in buster/amd64...
[2021-11-12 13:44:02] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:02] INFO: Suite/Arch: buster/amd64
[2021-11-12 13:44:02] INFO: Amount:     0
[2021-11-12 13:44:02] INFO: Packages:   
[2021-11-12 13:44:02] INFO: Received 0 new packages in buster/amd64 to schedule.
[2021-11-12 13:44:02] INFO: --------------------------------------------------------------
[2021-11-12 13:44:02] INFO: Requesting 150 new versions in bullseye/amd64...
[2021-11-12 13:44:03] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:03] INFO: Suite/Arch: bullseye/amd64
[2021-11-12 13:44:03] INFO: Amount:     0
[2021-11-12 13:44:03] INFO: Packages:   
[2021-11-12 13:44:03] INFO: Received 0 new packages in bullseye/amd64 to schedule.
[2021-11-12 13:44:03] INFO: --------------------------------------------------------------
[2021-11-12 13:44:03] INFO: Requesting 150 new versions in bookworm/amd64...
[2021-11-12 13:44:03] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:03] INFO: Suite/Arch: bookworm/amd64
[2021-11-12 13:44:03] INFO: Amount:     0
[2021-11-12 13:44:03] INFO: Packages:   
[2021-11-12 13:44:03] INFO: Received 0 new packages in bookworm/amd64 to schedule.
[2021-11-12 13:44:03] INFO: --------------------------------------------------------------
[2021-11-12 13:44:03] INFO: Requesting 250 new versions in unstable/amd64...
[2021-11-12 13:44:03] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:03] INFO: Suite/Arch: unstable/amd64
[2021-11-12 13:44:03] INFO: Amount:     0
[2021-11-12 13:44:03] INFO: Packages:   
[2021-11-12 13:44:03] INFO: Received 0 new packages in unstable/amd64 to schedule.
[2021-11-12 13:44:03] INFO: --------------------------------------------------------------
[2021-11-12 13:44:03] INFO: Requesting 50 new versions in experimental/amd64...
[2021-11-12 13:44:03] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:03] INFO: Suite/Arch: experimental/amd64
[2021-11-12 13:44:03] INFO: Amount:     0
[2021-11-12 13:44:03] INFO: Packages:   
[2021-11-12 13:44:03] INFO: Received 0 new packages in experimental/amd64 to schedule.
[2021-11-12 13:44:03] INFO: --------------------------------------------------------------
[2021-11-12 13:44:04] INFO: Building the schedule index page for amd64...
[2021-11-12 13:44:06] INFO: Finding out which usertagged bugs have been closed or at least have patches
[2021-11-12 13:44:09] INFO: Page generated at https://tests.reproducible-builds.org/debian/index_amd64_scheduled.html
[2021-11-12 13:44:09] INFO: Scheduling for architecture amd64 done.
[2021-11-12 13:44:09] INFO: --------------------------------------------------------------
[2021-11-12 13:44:09] INFO: Arch amd64 scheduled at 2021-11-12 13:44:09.
[2021-11-12 13:44:09] INFO: Scheduling for i386...
[2021-11-12 13:44:09] INFO: 1730 packages already scheduled for i386, probably scheduling some more...
[2021-11-12 13:44:09] INFO: ==============================================================
[2021-11-12 13:44:09] INFO: Currently scheduled packages in all suites on i386: 1730
[2021-11-12 13:44:09] INFO: 1730 packages already scheduled, only scheduling new versions.
[2021-11-12 13:44:09] INFO: Requesting 100 new versions in stretch/i386...
[2021-11-12 13:44:09] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:09] INFO: Suite/Arch: stretch/i386
[2021-11-12 13:44:09] INFO: Amount:     0
[2021-11-12 13:44:09] INFO: Packages:   
[2021-11-12 13:44:09] INFO: Received 0 new packages in stretch/i386 to schedule.
[2021-11-12 13:44:09] INFO: --------------------------------------------------------------
[2021-11-12 13:44:09] INFO: Requesting 100 new versions in buster/i386...
[2021-11-12 13:44:10] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:10] INFO: Suite/Arch: buster/i386
[2021-11-12 13:44:10] INFO: Amount:     0
[2021-11-12 13:44:10] INFO: Packages:   
[2021-11-12 13:44:10] INFO: Received 0 new packages in buster/i386 to schedule.
[2021-11-12 13:44:10] INFO: --------------------------------------------------------------
[2021-11-12 13:44:10] INFO: Requesting 150 new versions in bullseye/i386...
[2021-11-12 13:44:10] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:10] INFO: Suite/Arch: bullseye/i386
[2021-11-12 13:44:10] INFO: Amount:     0
[2021-11-12 13:44:10] INFO: Packages:   
[2021-11-12 13:44:10] INFO: Received 0 new packages in bullseye/i386 to schedule.
[2021-11-12 13:44:10] INFO: --------------------------------------------------------------
[2021-11-12 13:44:10] INFO: Requesting 150 new versions in bookworm/i386...
[2021-11-12 13:44:10] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:10] INFO: Suite/Arch: bookworm/i386
[2021-11-12 13:44:10] INFO: Amount:     0
[2021-11-12 13:44:10] INFO: Packages:   
[2021-11-12 13:44:10] INFO: Received 0 new packages in bookworm/i386 to schedule.
[2021-11-12 13:44:10] INFO: --------------------------------------------------------------
[2021-11-12 13:44:10] INFO: Requesting 250 new versions in unstable/i386...
[2021-11-12 13:44:11] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:11] INFO: Suite/Arch: unstable/i386
[2021-11-12 13:44:11] INFO: Amount:     0
[2021-11-12 13:44:11] INFO: Packages:   
[2021-11-12 13:44:11] INFO: Received 0 new packages in unstable/i386 to schedule.
[2021-11-12 13:44:11] INFO: --------------------------------------------------------------
[2021-11-12 13:44:11] INFO: Requesting 50 new versions in experimental/i386...
[2021-11-12 13:44:11] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:11] INFO: Suite/Arch: experimental/i386
[2021-11-12 13:44:11] INFO: Amount:     0
[2021-11-12 13:44:11] INFO: Packages:   
[2021-11-12 13:44:11] INFO: Received 0 new packages in experimental/i386 to schedule.
[2021-11-12 13:44:11] INFO: --------------------------------------------------------------
[2021-11-12 13:44:12] INFO: Building the schedule index page for i386...
[2021-11-12 13:44:14] INFO: Page generated at https://tests.reproducible-builds.org/debian/index_i386_scheduled.html
[2021-11-12 13:44:14] INFO: Scheduling for architecture i386 done.
[2021-11-12 13:44:14] INFO: --------------------------------------------------------------
[2021-11-12 13:44:14] INFO: Arch i386 scheduled at 2021-11-12 13:44:14.
[2021-11-12 13:44:14] INFO: Scheduling for arm64...
[2021-11-12 13:44:14] INFO: 2741 packages already scheduled for arm64, probably scheduling some more...
[2021-11-12 13:44:14] INFO: ==============================================================
[2021-11-12 13:44:14] INFO: Currently scheduled packages in all suites on arm64: 2741
[2021-11-12 13:44:14] INFO: 2741 packages already scheduled, only scheduling new versions.
[2021-11-12 13:44:14] INFO: Requesting 50 new versions in stretch/arm64...
[2021-11-12 13:44:14] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:14] INFO: Suite/Arch: stretch/arm64
[2021-11-12 13:44:14] INFO: Amount:     0
[2021-11-12 13:44:14] INFO: Packages:   
[2021-11-12 13:44:14] INFO: Received 0 new packages in stretch/arm64 to schedule.
[2021-11-12 13:44:14] INFO: --------------------------------------------------------------
[2021-11-12 13:44:14] INFO: Requesting 50 new versions in buster/arm64...
[2021-11-12 13:44:14] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:14] INFO: Suite/Arch: buster/arm64
[2021-11-12 13:44:14] INFO: Amount:     0
[2021-11-12 13:44:14] INFO: Packages:   
[2021-11-12 13:44:14] INFO: Received 0 new packages in buster/arm64 to schedule.
[2021-11-12 13:44:14] INFO: --------------------------------------------------------------
[2021-11-12 13:44:14] INFO: Requesting 150 new versions in bullseye/arm64...
[2021-11-12 13:44:15] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:15] INFO: Suite/Arch: bullseye/arm64
[2021-11-12 13:44:15] INFO: Amount:     0
[2021-11-12 13:44:15] INFO: Packages:   
[2021-11-12 13:44:15] INFO: Received 0 new packages in bullseye/arm64 to schedule.
[2021-11-12 13:44:15] INFO: --------------------------------------------------------------
[2021-11-12 13:44:15] INFO: Requesting 150 new versions in bookworm/arm64...
[2021-11-12 13:44:15] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:15] INFO: Suite/Arch: bookworm/arm64
[2021-11-12 13:44:15] INFO: Amount:     0
[2021-11-12 13:44:15] INFO: Packages:   
[2021-11-12 13:44:15] INFO: Received 0 new packages in bookworm/arm64 to schedule.
[2021-11-12 13:44:15] INFO: --------------------------------------------------------------
[2021-11-12 13:44:15] INFO: Requesting 125 new versions in unstable/arm64...
[2021-11-12 13:44:16] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:16] INFO: Suite/Arch: unstable/arm64
[2021-11-12 13:44:16] INFO: Amount:     0
[2021-11-12 13:44:16] INFO: Packages:   
[2021-11-12 13:44:16] INFO: Received 0 new packages in unstable/arm64 to schedule.
[2021-11-12 13:44:16] INFO: --------------------------------------------------------------
[2021-11-12 13:44:16] INFO: Requesting 25 new versions in experimental/arm64...
[2021-11-12 13:44:16] INFO: Criteria:   tested before, new version available, sorted by last build date
[2021-11-12 13:44:16] INFO: Suite/Arch: experimental/arm64
[2021-11-12 13:44:16] INFO: Amount:     0
[2021-11-12 13:44:16] INFO: Packages:   
[2021-11-12 13:44:16] INFO: Received 0 new packages in experimental/arm64 to schedule.
[2021-11-12 13:44:16] INFO: --------------------------------------------------------------
[2021-11-12 13:44:16] INFO: Building the schedule index page for arm64...
[2021-11-12 13:44:20] INFO: Page generated at https://tests.reproducible-builds.org/debian/index_arm64_scheduled.html
[2021-11-12 13:44:20] INFO: Scheduling for architecture arm64 done.
[2021-11-12 13:44:20] INFO: --------------------------------------------------------------
[2021-11-12 13:44:20] INFO: Arch arm64 scheduled at 2021-11-12 13:44:20.
[2021-11-12 13:44:20] INFO: Scheduling for armhf...
[2021-11-12 13:44:20] INFO: 1598 packages already scheduled for armhf, probably scheduling some more...
[2021-11-12 13:44:20] INFO: ==============================================================
[2021-11-12 13:44:20] INFO: Currently scheduled packages in all suites on armhf: 1598
[2021-11-12 13:44:20] INFO: 1598 packages already scheduled, scheduling some more...
[2021-11-12 13:44:20] INFO: Requesting 255 untested packages in stretch/armhf...
[2021-11-12 13:47:02] INFO: Criteria:   not tested before, randomly sorted
[2021-11-12 13:47:02] INFO: Suite/Arch: stretch/armhf
[2021-11-12 13:47:02] INFO: Amount:     0
[2021-11-12 13:47:02] INFO: Packages:   
[2021-11-12 13:47:02] INFO: Received 0 untested packages in stretch/armhf to schedule.
[2021-11-12 13:47:02] INFO: --------------------------------------------------------------
[2021-11-12 13:47:02] INFO: Requesting 255 untested packages in buster/armhf...
[2021-11-12 13:48:10] CRITICAL: Error executing this query:
[2021-11-12 13:48:10] CRITICAL: SELECT DISTINCT *
[2021-11-12 13:48:10] CRITICAL:                FROM (
[2021-11-12 13:48:10] CRITICAL:                     SELECT sources.id, sources.name FROM sources
[2021-11-12 13:48:10] CRITICAL:                     WHERE sources.suite='buster' AND sources.architecture='armhf'
[2021-11-12 13:48:10] CRITICAL:                     AND sources.id NOT IN
[2021-11-12 13:48:10] CRITICAL:                        (SELECT schedule.package_id FROM schedule WHERE build_type='ci_build')
[2021-11-12 13:48:10] CRITICAL:                     AND sources.id NOT IN
[2021-11-12 13:48:10] CRITICAL:                        (SELECT results.package_id FROM results)
[2021-11-12 13:48:10] CRITICAL:                     ORDER BY random()
[2021-11-12 13:48:10] CRITICAL:                 ) AS tmp
[2021-11-12 13:48:10] CRITICAL:                 LIMIT 255








Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.AdminShutdown: terminating connection due to administrator command
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.


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

Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 813, in <module>
    message += scheduler(arch)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 737, in scheduler
    untested, msg_untested = schedule_untested_packages(arch, total)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 607, in schedule_untested_packages
    packages[suite] = query_untested_packages(suite, arch, many_untested)
  File "/srv/jenkins/bin/reproducible_scheduler.py", line 495, in query_untested_packages
    packages = 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 1003, in execute
    return self._execute_text(object_, multiparams, params)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1172, in _execute_text
    ret = self._execute_context(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.errors.AdminShutdown) terminating connection due to administrator command
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

[SQL: SELECT DISTINCT *
               FROM (
                    SELECT sources.id, sources.name FROM sources
                    WHERE sources.suite='buster' AND sources.architecture='armhf'
                    AND sources.id NOT IN
                       (SELECT schedule.package_id FROM schedule WHERE build_type='ci_build')
                    AND sources.id NOT IN
                       (SELECT results.package_id FROM results)
                    ORDER BY random()
                ) AS tmp
                LIMIT 255]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
[2021-11-12 13:48:10] INFO: Finished at 2021-11-12 13:48:10.813318, took: 0:25:08.556488
Build step 'Execute shell' marked build as failure



More information about the Qa-jenkins-scm mailing list