Faustin Lammler
added a comment - - edited Daniel,
trying to reproduce this, here seems to be the problem:
root@113a7d5eb63a:~# apt install mariadb-server-10.2
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
mariadb-server-10.2 : Depends: iproute but it is not installable or
iproute but it is not installable
Recommends: libhtml-template-perl but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
This is really wired as iproute2 is available on bionic and if I am correct, the dependency is on either iproute or iproute2 https://github.com/MariaDB/server/commit/9f848da640dd6c3f44d56eae18204370ae7f835c
Digging a bit further, https://ci.mariadb.org/22519/aarch64-ubuntu-1804-deb-autobake/debs/mariadb-server-10.2_10.2.44%2Bmaria~bionic_arm64.deb seems to have removed the iproute2 dependency:
❮ wget https://ci.mariadb.org/22519/aarch64-ubuntu-1804-deb-autobake/debs/mariadb-server-10.2_10.2.44%2Bmaria~bionic_arm64.deb
--2022-02-22 18:06:57-- https://ci.mariadb.org/22519/aarch64-ubuntu-1804-deb-autobake/debs/mariadb-server-10.2_10.2.44%2Bmaria~bionic_arm64.deb
Resolving ci.mariadb.org (ci.mariadb.org)... 135.181.143.118
Connecting to ci.mariadb.org (ci.mariadb.org)|135.181.143.118|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3956192 (3.8M) [application/octet-stream]
Saving to: ‘mariadb-server-10.2_10.2.44+maria~bionic_arm64.deb’
mariadb-server-10.2_10.2.44+maria~b 100%[================================================================>] 3.77M 4.60MB/s in 0.8s
2022-02-22 18:06:58 (4.60 MB/s) - ‘mariadb-server-10.2_10.2.44+maria~bionic_arm64.deb’ saved [3956192/3956192]
❯ ar x mariadb-server-10.2_10.2.44+maria\~bionic_arm64.deb
❯ tar -xvf control.tar.xz
./
./conffiles
./config
./control
./md5sums
./postinst
./postrm
./preinst
./prerm
./templates
./triggers
❯ grep iproute control
Depends: bsdutils, coreutils, findutils, galera-3 (>= 25.3), gawk, iproute | iproute, libdbi-perl, lsb-base (>= 3.0-10), lsof, mariadb-client-10.2 (>= 1:10.2.44+maria~bionic), mariadb-server-core-10.2 (>= 1:10.2.44+maria~bionic), passwd, perl (>= 5.6), psmisc, rsync, socat, debconf (>= 0.5) | debconf-2.0, libc6 (>= 2.17), libpam0g (>= 0.99.7.1), libssl1.1 (>= 1.1.1), libstdc++6 (>= 5.2), zlib1g (>= 1:1.2.0)
Dependency is on:
iproute | iproute
instead of:
iproute | iproute2
Not sure why but this is the pb I guess.
Daniel Black
added a comment - Because the cache on the container image doesn't contain iproute2, its removed
https://github.com/MariaDB/server/blob/10.2/debian/autobake-deb.sh#L46-L49
Did you fix something? https://buildbot.mariadb.org/#/grid?branch=10.2 appears to have come good
https://quay.io/repository/mariadb-foundation/mariadb-devel?tab=history 10.2 releases there
Faustin Lammler
added a comment - > Because the cache on the container image doesn't contain iproute2, its removed
> https://github.com/MariaDB/server/blob/10.2/debian/autobake-deb.sh#L46-L49
But it should not for bionic:
❯ podman run -it ubuntu:bionic bash -c "apt-get update && apt-cache madison iproute2 | grep 'iproute2 *|'"
...
Reading package lists... Done
iproute2 | 4.18.0-1ubuntu2~ubuntu18.04.1 | http://archive.ubuntu.com/ubuntu bionic-backports/main amd64 Packages
iproute2 | 4.15.0-2ubuntu1.3 | http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages
iproute2 | 4.15.0-2ubuntu1.1 | http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages
iproute2 | 4.15.0-2ubuntu1 | http://archive.ubuntu.com/ubuntu bionic/main amd64 Packages
> Did you fix something? https://buildbot.mariadb.org/#/grid?branch=10.2 appears to have come good
> https://quay.io/repository/mariadb-foundation/mariadb-devel?tab=history 10.2 releases there
Nope
$ podman run --rm quay.io/mariadb-foundation/bb-worker@sha256:1e9c765bd358c8f4e0b1ce1f7727dd670d679f80882b10d3741d0ef0eeaecd33 apt-cache madison iproute2
Trying to pull quay.io/mariadb-foundation/bb-worker@sha256:1e9c765bd358c8f4e0b1ce1f7727dd670d679f80882b10d3741d0ef0eeaecd33...
And if this is a requirement to not clean the apt cache, then it was a smart move. There is still a problem with that approach: I am not sure how long apt will trust it's cache (/var/lib/apt/lists) but if the image is too old, an apt-get update may be needed for this to work as expected.
Faustin Lammler
added a comment - So, this might be the reason:
https://github.com/MariaDB/mariadb.org-tools/commit/cbc21ab61d51a16a0f6d4668218140d20999d964#diff-cf2e76e32cae86bc87bbdc519d110a6ab361fce8911ebe2996100fc573346bc0L76-L78
And if this is a requirement to not clean the apt cache, then it was a smart move. There is still a problem with that approach: I am not sure how long apt will trust it's cache (/var/lib/apt/lists) but if the image is too old, an apt-get update may be needed for this to work as expected.
package updates but the time you include all the build dependencies, probably monthly, just enough to get updates, and enough to ensure the ccache can be stable based on dependencies pulled in. github actions on a schedule maybe?
Daniel Black
added a comment - Eventually I think I'd like the debian/autobake-deb.sh to build based on actual distro rather than cache contents.
The Debian base image is updated about monthly https://github.com/docker-library/repo-info/commits/master/repos/debian/remote
package updates but the time you include all the build dependencies, probably monthly, just enough to get updates, and enough to ensure the ccache can be stable based on dependencies pulled in. github actions on a schedule maybe?
Definitively! But not before we have a better solution for MDBF-336.
Also, ideally we should have an automatic rollback mechanism on BB if new images breaks the builds.
Faustin Lammler
added a comment - > github actions on a schedule maybe?
Definitively! But not before we have a better solution for MDBF-336 .
Also, ideally we should have an automatic rollback mechanism on BB if new images breaks the builds.
Daniel Black
added a comment - Seems the aarch64 version from bionic may have been used last release looking at https://doi-janky.infosiftr.net/job/multiarch/job/arm64v8/job/mariadb/
I don't suppose there's an easy work around on released packages?
https://github.com/MariaDB/server/pull/2040 as a cleanup item in testing.
People
Faustin Lammler
Daniel Black
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
Resolved:
Time Tracking
Estimated:
Not Specified
Remaining:
0d
Logged:
1h
{"report":{"fcp":623.8999996185303,"ttfb":153.5999984741211,"pageVisibility":"visible","entityId":108167,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"11abd3eb-a80b-49e3-9496-618dc7632929","navigationType":0,"readyForUser":759.5999984741211,"redirectCount":0,"resourceLoadedEnd":643.3999996185303,"resourceLoadedStart":158.29999923706055,"resourceTiming":[{"duration":5.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":158.29999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":163.79999923706055,"responseStart":0,"secureConnectionStart":0},{"duration":5.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":158.5999984741211,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.5999984741211,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":164.0999984741211,"responseStart":0,"secureConnectionStart":0},{"duration":65.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/b09d0d077992e4331b5f9ec0d3ec448c-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":158.69999885559082,"connectEnd":158.69999885559082,"connectStart":158.69999885559082,"domainLookupEnd":158.69999885559082,"domainLookupStart":158.69999885559082,"fetchStart":158.69999885559082,"redirectEnd":0,"redirectStart":0,"requestStart":158.69999885559082,"responseEnd":224.19999885559082,"responseStart":224.0999984741211,"secureConnectionStart":158.69999885559082},{"duration":158.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/6c569cbf8087ab04e40d0bef98627457-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":158.79999923706055,"connectEnd":158.79999923706055,"connectStart":158.79999923706055,"domainLookupEnd":158.79999923706055,"domainLookupStart":158.79999923706055,"fetchStart":158.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":158.79999923706055,"responseEnd":317.6999988555908,"responseStart":317.6999988555908,"secureConnectionStart":158.79999923706055},{"duration":155.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/b47ab3df14096803b180217eb8482517-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":158.79999923706055,"connectEnd":158.79999923706055,"connectStart":158.79999923706055,"domainLookupEnd":158.79999923706055,"domainLookupStart":158.79999923706055,"fetchStart":158.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":158.79999923706055,"responseEnd":313.8999996185303,"responseStart":313.8999996185303,"secureConnectionStart":158.79999923706055},{"duration":159.19999885559082,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":159,"connectEnd":159,"connectStart":159,"domainLookupEnd":159,"domainLookupStart":159,"fetchStart":159,"redirectEnd":0,"redirectStart":0,"requestStart":159,"responseEnd":318.1999988555908,"responseStart":318.1999988555908,"secureConnectionStart":159},{"duration":160,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":159.0999984741211,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":159.0999984741211,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":319.0999984741211,"responseStart":0,"secureConnectionStart":0},{"duration":159.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":159.0999984741211,"connectEnd":159.0999984741211,"connectStart":159.0999984741211,"domainLookupEnd":159.0999984741211,"domainLookupStart":159.0999984741211,"fetchStart":159.0999984741211,"redirectEnd":0,"redirectStart":0,"requestStart":159.0999984741211,"responseEnd":318.5999984741211,"responseStart":318.5999984741211,"secureConnectionStart":159.0999984741211},{"duration":160.10000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":159.29999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":159.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":319.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":159.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":159.29999923706055,"connectEnd":159.29999923706055,"connectStart":159.29999923706055,"domainLookupEnd":159.29999923706055,"domainLookupStart":159.29999923706055,"fetchStart":159.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":159.29999923706055,"responseEnd":319,"responseStart":318.8999996185303,"secureConnectionStart":159.29999923706055},{"duration":160.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":159.39999961853027,"connectEnd":159.39999961853027,"connectStart":159.39999961853027,"domainLookupEnd":159.39999961853027,"domainLookupStart":159.39999961853027,"fetchStart":159.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":159.39999961853027,"responseEnd":319.5,"responseStart":319.5,"secureConnectionStart":159.39999961853027},{"duration":444,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":173.39999961853027,"connectEnd":173.39999961853027,"connectStart":173.39999961853027,"domainLookupEnd":173.39999961853027,"domainLookupStart":173.39999961853027,"fetchStart":173.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":173.39999961853027,"responseEnd":617.3999996185303,"responseStart":617.3999996185303,"secureConnectionStart":173.39999961853027},{"duration":437.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":180.79999923706055,"connectEnd":180.79999923706055,"connectStart":180.79999923706055,"domainLookupEnd":180.79999923706055,"domainLookupStart":180.79999923706055,"fetchStart":180.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":180.79999923706055,"responseEnd":618.3999996185303,"responseStart":618.3999996185303,"secureConnectionStart":180.79999923706055},{"duration":219.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":381.5,"connectEnd":381.5,"connectStart":381.5,"domainLookupEnd":381.5,"domainLookupStart":381.5,"fetchStart":381.5,"redirectEnd":0,"redirectStart":0,"requestStart":381.5,"responseEnd":601,"responseStart":601,"secureConnectionStart":381.5},{"duration":6.100000381469727,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":616.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":616.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":623,"responseStart":0,"secureConnectionStart":0},{"duration":3.3999996185302734,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":640,"connectEnd":640,"connectStart":640,"domainLookupEnd":640,"domainLookupStart":640,"fetchStart":640,"redirectEnd":0,"redirectStart":0,"requestStart":640,"responseEnd":643.3999996185303,"responseStart":643.3999996185303,"secureConnectionStart":640}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":22,"responseStart":154,"responseEnd":181,"domLoading":157,"domInteractive":848,"domContentLoadedEventStart":848,"domContentLoadedEventEnd":909,"domComplete":1086,"loadEventStart":1086,"loadEventEnd":1086,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":803.5999984741211},{"name":"bigPipe.sidebar-id.end","time":804.2999992370605},{"name":"bigPipe.activity-panel-pipe-id.start","time":804.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":808.8999996185303},{"name":"activityTabFullyLoaded","time":925.8999996185303}],"measures":[],"correlationId":"884b107f89b027","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":83,"dbReadsTimeInMs":13,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Daniel,
trying to reproduce this, here seems to be the problem:
root@113a7d5eb63a:~# apt install mariadb-server-10.2
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies:
mariadb-server-10.2 : Depends: iproute but it is not installable or
iproute but it is not installable
Recommends: libhtml-template-perl but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
This is really wired as iproute2 is available on bionic and if I am correct, the dependency is on either iproute or iproute2 https://github.com/MariaDB/server/commit/9f848da640dd6c3f44d56eae18204370ae7f835c
Digging a bit further, https://ci.mariadb.org/22519/aarch64-ubuntu-1804-deb-autobake/debs/mariadb-server-10.2_10.2.44%2Bmaria~bionic_arm64.deb seems to have removed the iproute2 dependency:
❮ wget https://ci.mariadb.org/22519/aarch64-ubuntu-1804-deb-autobake/debs/mariadb-server-10.2_10.2.44%2Bmaria~bionic_arm64.deb
--2022-02-22 18:06:57-- https://ci.mariadb.org/22519/aarch64-ubuntu-1804-deb-autobake/debs/mariadb-server-10.2_10.2.44%2Bmaria~bionic_arm64.deb
Resolving ci.mariadb.org (ci.mariadb.org)... 135.181.143.118
Connecting to ci.mariadb.org (ci.mariadb.org)|135.181.143.118|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3956192 (3.8M) [application/octet-stream]
Saving to: ‘mariadb-server-10.2_10.2.44+maria~bionic_arm64.deb’
mariadb-server-10.2_10.2.44+maria~b 100%[================================================================>] 3.77M 4.60MB/s in 0.8s
2022-02-22 18:06:58 (4.60 MB/s) - ‘mariadb-server-10.2_10.2.44+maria~bionic_arm64.deb’ saved [3956192/3956192]
❯ ar x mariadb-server-10.2_10.2.44+maria\~bionic_arm64.deb
❯ tar -xvf control.tar.xz
./
./conffiles
./config
./control
./md5sums
./postinst
./postrm
./preinst
./prerm
./templates
./triggers
❯ grep iproute control
Depends: bsdutils, coreutils, findutils, galera-3 (>= 25.3), gawk, iproute | iproute, libdbi-perl, lsb-base (>= 3.0-10), lsof, mariadb-client-10.2 (>= 1:10.2.44+maria~bionic), mariadb-server-core-10.2 (>= 1:10.2.44+maria~bionic), passwd, perl (>= 5.6), psmisc, rsync, socat, debconf (>= 0.5) | debconf-2.0, libc6 (>= 2.17), libpam0g (>= 0.99.7.1), libssl1.1 (>= 1.1.1), libstdc++6 (>= 5.2), zlib1g (>= 1:1.2.0)
Dependency is on:
iproute | iproute
instead of:
iproute | iproute2
Not sure why but this is the pb I guess.