[Qa-jenkins-scm] Build failed in Jenkins: reproducible_scheduler #38515
jenkins at jenkins.debian.net
jenkins at jenkins.debian.net
Fri May 12 09:01:10 BST 2023
See <https://jenkins.debian.net/job/reproducible_scheduler/38515/display/redirect>
Changes:
------------------------------------------
[...truncated 3.01 KB...]
[2023-05-12 06:55:12] INFO: Updating sources db for bookworm/i386...
[2023-05-12 06:55:41] INFO: Pushing 0 updated packages to the database...
[2023-05-12 06:56:20] INFO: Now deleting 0 removed packages: []
[2023-05-12 06:56:20] INFO: DB update done for bookworm/i386 done at 2023-05-12 06:56:20.
[2023-05-12 06:56:20] INFO: Sources for suite bookworm done at 2023-05-12 06:56:20.
[2023-05-12 06:56:20] INFO: Downloading sources file for bullseye: http://deb.debian.org/debian/dists/bullseye/main/source/Sources.xz
[2023-05-12 06:56:21] INFO: Updating sources db for bullseye/amd64...
[2023-05-12 06:56:48] INFO: Pushing 0 updated packages to the database...
[2023-05-12 06:57:18] INFO: Now deleting 0 removed packages: []
[2023-05-12 06:57:18] INFO: DB update done for bullseye/amd64 done at 2023-05-12 06:57:18.
[2023-05-12 06:57:18] INFO: Updating sources db for bullseye/arm64...
[2023-05-12 06:57:45] INFO: Pushing 0 updated packages to the database...
[2023-05-12 06:58:14] INFO: Now deleting 0 removed packages: []
[2023-05-12 06:58:14] INFO: DB update done for bullseye/arm64 done at 2023-05-12 06:58:14.
[2023-05-12 06:58:14] INFO: Updating sources db for bullseye/armhf...
[2023-05-12 06:58:39] INFO: Pushing 0 updated packages to the database...
[2023-05-12 06:59:09] INFO: Now deleting 0 removed packages: []
[2023-05-12 06:59:09] INFO: DB update done for bullseye/armhf done at 2023-05-12 06:59:09.
[2023-05-12 06:59:09] INFO: Updating sources db for bullseye/i386...
[2023-05-12 06:59:35] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:00:04] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:00:04] INFO: DB update done for bullseye/i386 done at 2023-05-12 07:00:04.
[2023-05-12 07:00:04] INFO: Sources for suite bullseye done at 2023-05-12 07:00:04.
[2023-05-12 07:00:04] INFO: Downloading sources file for buster: http://deb.debian.org/debian/dists/buster/main/source/Sources.xz
[2023-05-12 07:00:07] INFO: Updating sources db for buster/amd64...
[2023-05-12 07:00:30] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:00:55] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:00:55] INFO: DB update done for buster/amd64 done at 2023-05-12 07:00:55.
[2023-05-12 07:00:55] INFO: Updating sources db for buster/arm64...
[2023-05-12 07:01:19] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:01:46] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:01:46] INFO: DB update done for buster/arm64 done at 2023-05-12 07:01:46.
[2023-05-12 07:01:46] INFO: Updating sources db for buster/armhf...
[2023-05-12 07:02:12] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:02:39] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:02:40] INFO: DB update done for buster/armhf done at 2023-05-12 07:02:40.
[2023-05-12 07:02:40] INFO: Updating sources db for buster/i386...
[2023-05-12 07:03:08] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:03:35] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:03:35] INFO: DB update done for buster/i386 done at 2023-05-12 07:03:35.
[2023-05-12 07:03:35] INFO: Sources for suite buster done at 2023-05-12 07:03:35.
[2023-05-12 07:03:35] INFO: Downloading sources file for experimental: http://deb.debian.org/debian/dists/experimental/main/source/Sources.xz
[2023-05-12 07:03:36] INFO: Updating sources db for experimental/amd64...
[2023-05-12 07:03:38] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:03:38] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:03:38] INFO: DB update done for experimental/amd64 done at 2023-05-12 07:03:38.
[2023-05-12 07:03:38] INFO: Updating sources db for experimental/arm64...
[2023-05-12 07:03:40] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:03:40] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:03:40] INFO: DB update done for experimental/arm64 done at 2023-05-12 07:03:40.
[2023-05-12 07:03:40] INFO: Updating sources db for experimental/armhf...
[2023-05-12 07:03:42] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:03:42] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:03:43] INFO: DB update done for experimental/armhf done at 2023-05-12 07:03:43.
[2023-05-12 07:03:43] INFO: Updating sources db for experimental/i386...
[2023-05-12 07:03:45] INFO: Pushing 0 updated packages to the database...
[2023-05-12 07:03:45] INFO: Now deleting 0 removed packages: []
[2023-05-12 07:03:45] INFO: DB update done for experimental/i386 done at 2023-05-12 07:03:45.
[2023-05-12 07:03:45] INFO: Sources for suite experimental done at 2023-05-12 07:03:45.
[2023-05-12 07:03:45] INFO: Removing old pages from unstable/amd64.
[2023-05-12 07:03:45] INFO: Removing old pages from unstable/amd64/diffoscope-results/.
[2023-05-12 07:03:45] INFO: Removing old pages from unstable/arm64.
[2023-05-12 07:03:46] INFO: Removing old pages from unstable/arm64/diffoscope-results/.
[2023-05-12 07:03:46] INFO: Removing old pages from unstable/armhf.
[2023-05-12 07:03:46] INFO: Removing old pages from unstable/armhf/diffoscope-results/.
[2023-05-12 07:03:46] INFO: Removing old pages from unstable/i386.
[2023-05-12 07:03:47] INFO: Removing old pages from unstable/i386/diffoscope-results/.
[2023-05-12 07:03:47] INFO: Removing old pages from bookworm/amd64.
[2023-05-12 07:03:47] INFO: Removing old pages from bookworm/amd64/diffoscope-results/.
[2023-05-12 07:03:47] INFO: Removing old pages from bookworm/arm64.
[2023-05-12 07:03:48] INFO: Removing old pages from bookworm/arm64/diffoscope-results/.
[2023-05-12 07:03:48] INFO: Removing old pages from bookworm/armhf.
[2023-05-12 07:03:48] INFO: Removing old pages from bookworm/armhf/diffoscope-results/.
[2023-05-12 07:03:48] INFO: Removing old pages from bookworm/i386.
[2023-05-12 07:03:48] INFO: Removing old pages from bookworm/i386/diffoscope-results/.
[2023-05-12 07:03:48] INFO: Removing old pages from bullseye/amd64.
[2023-05-12 07:03:49] INFO: Removing old pages from bullseye/amd64/diffoscope-results/.
[2023-05-12 07:03:49] INFO: Removing old pages from bullseye/arm64.
[2023-05-12 07:03:49] INFO: Removing old pages from bullseye/arm64/diffoscope-results/.
[2023-05-12 07:03:49] INFO: Removing old pages from bullseye/armhf.
[2023-05-12 07:03:50] INFO: Removing old pages from bullseye/armhf/diffoscope-results/.
[2023-05-12 07:03:50] INFO: Removing old pages from bullseye/i386.
[2023-05-12 07:03:50] INFO: Removing old pages from bullseye/i386/diffoscope-results/.
[2023-05-12 07:03:50] INFO: Removing old pages from buster/amd64.
[2023-05-12 07:03:51] INFO: Removing old pages from buster/amd64/diffoscope-results/.
[2023-05-12 07:03:51] INFO: Removing old pages from buster/arm64.
[2023-05-12 07:03:51] INFO: Removing old pages from buster/arm64/diffoscope-results/.
[2023-05-12 07:03:51] INFO: Removing old pages from buster/armhf.
[2023-05-12 07:03:51] INFO: Removing old pages from buster/armhf/diffoscope-results/.
[2023-05-12 07:03:51] INFO: Removing old pages from buster/i386.
[2023-05-12 07:03:52] INFO: Removing old pages from buster/i386/diffoscope-results/.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/amd64.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/amd64/diffoscope-results/.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/arm64.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/arm64/diffoscope-results/.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/armhf.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/armhf/diffoscope-results/.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/i386.
[2023-05-12 07:03:52] INFO: Removing old pages from experimental/i386/diffoscope-results/.
[2023-05-12 07:03:52] INFO: Scheduling for amd64...
[2023-05-12 07:03:52] INFO: 2005 packages already scheduled for amd64, probably scheduling some more...
[2023-05-12 07:03:53] INFO: ==============================================================
[2023-05-12 07:03:53] INFO: Currently scheduled packages in all suites on amd64: 2005
[2023-05-12 07:03:53] INFO: 2005 packages already scheduled, only scheduling new versions.
[2023-05-12 07:03:53] INFO: Requesting 250 new versions in unstable/amd64...
[2023-05-12 07:03:53] INFO: Criteria: tested before, new version available, sorted by last build date
[2023-05-12 07:03:53] INFO: Suite/Arch: unstable/amd64
[2023-05-12 07:03:53] INFO: Amount: 0
[2023-05-12 07:03:53] INFO: Packages:
[2023-05-12 07:03:53] INFO: Received 0 new packages in unstable/amd64 to schedule.
[2023-05-12 07:03:53] INFO: --------------------------------------------------------------
[2023-05-12 07:03:53] INFO: Requesting 150 new versions in bookworm/amd64...
[2023-05-12 07:03:53] INFO: Criteria: tested before, new version available, sorted by last build date
[2023-05-12 07:03:53] INFO: Suite/Arch: bookworm/amd64
[2023-05-12 07:03:53] INFO: Amount: 0
[2023-05-12 07:03:53] INFO: Packages:
[2023-05-12 07:03:53] INFO: Received 0 new packages in bookworm/amd64 to schedule.
[2023-05-12 07:03:53] INFO: --------------------------------------------------------------
[2023-05-12 07:03:53] INFO: Requesting 150 new versions in bullseye/amd64...
[2023-05-12 07:03:54] INFO: Criteria: tested before, new version available, sorted by last build date
[2023-05-12 07:03:54] INFO: Suite/Arch: bullseye/amd64
[2023-05-12 07:03:54] INFO: Amount: 0
[2023-05-12 07:03:54] INFO: Packages:
[2023-05-12 07:03:54] INFO: Received 0 new packages in bullseye/amd64 to schedule.
[2023-05-12 07:03:54] INFO: --------------------------------------------------------------
[2023-05-12 07:03:54] INFO: Requesting 100 new versions in buster/amd64...
[2023-05-12 07:03:54] INFO: Criteria: tested before, new version available, sorted by last build date
[2023-05-12 07:03:54] INFO: Suite/Arch: buster/amd64
[2023-05-12 07:03:54] INFO: Amount: 0
[2023-05-12 07:03:54] INFO: Packages:
[2023-05-12 07:03:54] INFO: Received 0 new packages in buster/amd64 to schedule.
[2023-05-12 07:03:54] INFO: --------------------------------------------------------------
[2023-05-12 07:03:54] INFO: Requesting 50 new versions in experimental/amd64...
[2023-05-12 07:03:54] INFO: Criteria: tested before, new version available, sorted by last build date
[2023-05-12 07:03:54] INFO: Suite/Arch: experimental/amd64
[2023-05-12 07:03:54] INFO: Amount: 0
[2023-05-12 07:03:54] INFO: Packages:
[2023-05-12 07:03:54] INFO: Received 0 new packages in experimental/amd64 to schedule.
[2023-05-12 07:03:54] INFO: --------------------------------------------------------------
[2023-05-12 07:03:55] INFO: Building the schedule index page for amd64...
[2023-05-12 07:03:57] INFO: Finding out which usertagged bugs have been closed or at least have patches
[2023-05-12 07:03:58] INFO: Page generated at https://tests.reproducible-builds.org/debian/index_amd64_scheduled.html
[2023-05-12 07:03:58] INFO: Scheduling for architecture amd64 done.
[2023-05-12 07:03:58] INFO: --------------------------------------------------------------
[2023-05-12 07:03:58] INFO: Arch amd64 scheduled at 2023-05-12 07:03:58.
[2023-05-12 07:03:58] INFO: Scheduling for arm64...
[2023-05-12 07:03:58] INFO: 1723 packages already scheduled for arm64, probably scheduling some more...
[2023-05-12 07:03:58] INFO: ==============================================================
[2023-05-12 07:03:58] INFO: Currently scheduled packages in all suites on arm64: 1723
[2023-05-12 07:03:58] INFO: 1723 packages already scheduled, scheduling some more...
[2023-05-12 07:03:58] INFO: Requesting 255 untested packages in unstable/arm64...
[2023-05-12 07:22:14] INFO: Criteria: not tested before, randomly sorted
[2023-05-12 07:22:14] INFO: Suite/Arch: unstable/arm64
[2023-05-12 07:22:14] INFO: Amount: 0
[2023-05-12 07:22:14] INFO: Packages:
[2023-05-12 07:22:14] INFO: Received 0 untested packages in unstable/arm64 to schedule.
[2023-05-12 07:22:14] INFO: --------------------------------------------------------------
[2023-05-12 07:22:14] INFO: Requesting 255 untested packages in bookworm/arm64...
[2023-05-12 07:44:43] INFO: Criteria: not tested before, randomly sorted
[2023-05-12 07:44:43] INFO: Suite/Arch: bookworm/arm64
[2023-05-12 07:44:43] INFO: Amount: 0
[2023-05-12 07:44:43] INFO: Packages:
[2023-05-12 07:44:43] INFO: Received 0 untested packages in bookworm/arm64 to schedule.
[2023-05-12 07:44:43] INFO: --------------------------------------------------------------
[2023-05-12 07:44:43] INFO: Requesting 255 untested packages in bullseye/arm64...
[2023-05-12 07:59:40] INFO: Criteria: not tested before, randomly sorted
[2023-05-12 07:59:40] INFO: Suite/Arch: bullseye/arm64
[2023-05-12 07:59:40] INFO: Amount: 0
[2023-05-12 07:59:40] INFO: Packages:
[2023-05-12 07:59:40] INFO: Received 0 untested packages in bullseye/arm64 to schedule.
[2023-05-12 07:59:40] INFO: --------------------------------------------------------------
[2023-05-12 07:59:40] INFO: Requesting 255 untested packages in buster/arm64...
[2023-05-12 08:01:07] CRITICAL: Error executing this query:
[2023-05-12 08:01:07] CRITICAL: SELECT DISTINCT *
[2023-05-12 08:01:07] CRITICAL: FROM (
[2023-05-12 08:01:07] CRITICAL: SELECT sources.id, sources.name FROM sources
[2023-05-12 08:01:07] CRITICAL: WHERE sources.suite='buster' AND sources.architecture='arm64'
[2023-05-12 08:01:07] CRITICAL: AND sources.id NOT IN
[2023-05-12 08:01:07] CRITICAL: (SELECT schedule.package_id FROM schedule WHERE build_type='ci_build')
[2023-05-12 08:01:07] CRITICAL: AND sources.id NOT IN
[2023-05-12 08:01:07] CRITICAL: (SELECT results.package_id FROM results)
[2023-05-12 08:01:07] CRITICAL: ORDER BY random()
[2023-05-12 08:01:07] CRITICAL: ) AS tmp
[2023-05-12 08:01:07] 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 793, in <module>
message += scheduler(arch)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 717, in scheduler
untested, msg_untested = schedule_untested_packages(arch, total)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 587, in schedule_untested_packages
packages[suite] = query_untested_packages(suite, arch, many_untested)
File "/srv/jenkins/bin/reproducible_scheduler.py", line 475, 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='arm64'
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)
[2023-05-12 08:01:07] INFO: Finished at 2023-05-12 08:01:07.193950, took: 1:14:04.994376
Build step 'Execute shell' marked build as failure
More information about the Qa-jenkins-scm
mailing list