Maria 10.1 [Travis-CI] [Easy]

[Incognito]

Related to: #1541 , #1552

Travis-CI is unable to install MariaDB 10.1, it should be possible to manually install these via apt, but this is only a few months before it reaches EOL (17 Oct 2020).

[Incognito]

Error from asking travis to install 10.1

mariadb
Installing MariaDB version 10.1
Executing: /tmp/apt-key-gpghome.e1s5VbXLRp/gpg.1.sh --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xf1656f24c74cd1d8
gpg: key F1656F24C74CD1D8: 7 signatures not checked due to missing keys
gpg: key F1656F24C74CD1D8: public key "MariaDB Signing Key <signing-key@mariadb.org>" imported
gpg: Total number processed: 1
gpg:               imported: 1
Hit:1 http://security.ubuntu.com/ubuntu bionic-security InRelease
Get:2 http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu bionic InRelease [6,247 B]
Get:3 http://archive.ubuntu.com/ubuntu bionic InRelease [242 kB]
Get:4 http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu bionic/main amd64 Packages [11.2 kB]
Hit:5 http://apt.postgresql.org/pub/repos/apt bionic-pgdg InRelease
Get:6 http://archive.ubuntu.com/ubuntu bionic-updates InRelease [88.7 kB]
Get:7 http://archive.ubuntu.com/ubuntu bionic-backports InRelease [74.6 kB]
Get:8 http://archive.ubuntu.com/ubuntu bionic/main Sources [1,063 kB]
Get:9 http://archive.ubuntu.com/ubuntu bionic/universe Sources [11.5 MB]
Get:10 http://archive.ubuntu.com/ubuntu bionic/restricted Sources [5,823 B]
Get:11 http://archive.ubuntu.com/ubuntu bionic/multiverse Sources [216 kB]
Get:12 http://archive.ubuntu.com/ubuntu bionic/main amd64 Packages [1,344 kB]
Get:13 http://archive.ubuntu.com/ubuntu bionic/main i386 Packages [1,328 kB]
Get:14 http://archive.ubuntu.com/ubuntu bionic/main Translation-en [729 kB]
Get:15 http://archive.ubuntu.com/ubuntu bionic/restricted amd64 Packages [13.5 kB]
Get:16 http://archive.ubuntu.com/ubuntu bionic/restricted i386 Packages [13.5 kB]
Get:17 http://archive.ubuntu.com/ubuntu bionic/restricted Translation-en [3,719 B]
Get:18 http://archive.ubuntu.com/ubuntu bionic/universe i386 Packages [11.3 MB]
Get:19 http://archive.ubuntu.com/ubuntu bionic/universe amd64 Packages [11.3 MB]
Get:20 http://archive.ubuntu.com/ubuntu bionic/universe Translation-en [7,122 kB]
Get:21 http://archive.ubuntu.com/ubuntu bionic/multiverse amd64 Packages [186 kB]
Get:22 http://archive.ubuntu.com/ubuntu bionic/multiverse i386 Packages [177 kB]
Get:23 http://archive.ubuntu.com/ubuntu bionic/multiverse Translation-en [134 kB]
Get:24 http://archive.ubuntu.com/ubuntu bionic-updates/main Sources [411 kB]
Get:25 http://archive.ubuntu.com/ubuntu bionic-updates/multiverse Sources [6,203 B]
Get:26 http://archive.ubuntu.com/ubuntu bionic-updates/universe Sources [372 kB]
Get:27 http://archive.ubuntu.com/ubuntu bionic-updates/restricted Sources [9,368 B]
Get:28 http://archive.ubuntu.com/ubuntu bionic-updates/main i386 Packages [907 kB]
Get:29 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages [1,270 kB]
Get:30 http://archive.ubuntu.com/ubuntu bionic-updates/main Translation-en [476 kB]
Get:31 http://archive.ubuntu.com/ubuntu bionic-updates/restricted amd64 Packages [93.9 kB]
Get:32 http://archive.ubuntu.com/ubuntu bionic-updates/restricted i386 Packages [15.9 kB]
Get:33 http://archive.ubuntu.com/ubuntu bionic-updates/restricted Translation-en [21.1 kB]
Get:34 http://archive.ubuntu.com/ubuntu bionic-updates/universe amd64 Packages [1,398 kB]
Get:35 http://archive.ubuntu.com/ubuntu bionic-updates/universe i386 Packages [1,315 kB]
Get:36 http://archive.ubuntu.com/ubuntu bionic-updates/universe Translation-en [474 kB]
Get:37 http://archive.ubuntu.com/ubuntu bionic-updates/multiverse amd64 Packages [13.4 kB]
Get:38 http://archive.ubuntu.com/ubuntu bionic-updates/multiverse i386 Packages [7,775 B]
Get:39 http://archive.ubuntu.com/ubuntu bionic-updates/multiverse Translation-en [5,169 B]
Get:40 http://archive.ubuntu.com/ubuntu bionic-backports/main Sources [4,301 B]
Get:41 http://archive.ubuntu.com/ubuntu bionic-backports/universe Sources [3,566 B]
Get:42 http://archive.ubuntu.com/ubuntu bionic-backports/main amd64 Packages [8,286 B]
Get:43 http://archive.ubuntu.com/ubuntu bionic-backports/main i386 Packages [8,277 B]
Get:44 http://archive.ubuntu.com/ubuntu bionic-backports/main Translation-en [4,858 B]
Get:45 http://archive.ubuntu.com/ubuntu bionic-backports/universe i386 Packages [8,139 B]
Get:46 http://archive.ubuntu.com/ubuntu bionic-backports/universe amd64 Packages [8,158 B]
Get:47 http://archive.ubuntu.com/ubuntu bionic-backports/universe Translation-en [4,522 B]
Fetched 53.8 MB in 5s (11.1 MB/s)
Reading package lists... Done
N: Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu bionic InRelease' doesn't support architecture 'i386'
$ travis_apt_get_update
$ PACKAGES='mariadb-server-10.1'
$ if [[ $(lsb_release -cs) = 'precise' ]]; then PACKAGES="${PACKAGES} libmariadbclient-dev"; fi
0.60s$ sudo apt-get install -y -o Debug::pkgProblemResolver=yes -o Dpkg::Options::='--force-confnew' $PACKAGES
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Starting pkgProblemResolver with broken count: 1
Starting 2 pkgProblemResolver with broken count: 1
Investigating (0) mariadb-server-10.1:amd64 < none -> 1:10.1.45+maria-1~bionic @un puN Ib >
Broken mariadb-server-10.1:amd64 Depends on mariadb-client-10.1:amd64 < none | 1:10.1.45+maria-1~bionic @un uH > (>= 1:10.1.45+maria-1~bionic)
  Considering mariadb-client-10.1:amd64 0 as a solution to mariadb-server-10.1:amd64 9999
  Re-Instated mariadb-client-core-10.1:amd64
  Re-Instated mariadb-client-10.1:amd64
Broken mariadb-server-10.1:amd64 Depends on mariadb-server-core-10.1:amd64 < none | 1:10.1.45+maria-1~bionic @un uH > (>= 1:10.1.45+maria-1~bionic)
  Considering mariadb-server-core-10.1:amd64 0 as a solution to mariadb-server-10.1:amd64 9999
  Re-Instated mariadb-server-core-10.1:amd64
Investigating (0) mysql-client-core-5.7:amd64 < 5.7.29-0ubuntu0.18.04.1 -> 5.7.30-0ubuntu0.18.04.1 @ii umU Ib >
Broken mysql-client-core-5.7:amd64 Conflicts on mysql-client-5.5:amd64 < none @un H >
  Conflicts//Breaks against version 1:10.1.43+maria-1~bionic for mariadb-client-10.1 but that is not InstVer, ignoring
  Conflicts//Breaks against version 1:10.1.44+maria-1~bionic for mariadb-client-10.1 but that is not InstVer, ignoring
  Considering mariadb-client-10.1:amd64 0 as a solution to mysql-client-core-5.7:amd64 2
  Added mariadb-client-10.1:amd64 to the remove list
Broken mysql-client-core-5.7:amd64 Conflicts on mysql-client-core-5.5:amd64 < none @un H >
  Conflicts//Breaks against version 1:10.1.43+maria-1~bionic for mariadb-client-core-10.1 but that is not InstVer, ignoring
  Conflicts//Breaks against version 1:10.1.44+maria-1~bionic for mariadb-client-core-10.1 but that is not InstVer, ignoring
  Considering mariadb-client-core-10.1:amd64 0 as a solution to mysql-client-core-5.7:amd64 2
  Added mariadb-client-core-10.1:amd64 to the remove list
Broken mysql-client-core-5.7:amd64 Conflicts on virtual-mysql-client-core:amd64 < none @un H >
  Conflicts//Breaks against version 1:10.1.43+maria-1~bionic for mariadb-client-core-10.1 but that is not InstVer, ignoring
  Conflicts//Breaks against version 1:10.1.44+maria-1~bionic for mariadb-client-core-10.1 but that is not InstVer, ignoring
  Considering mariadb-client-core-10.1:amd64 0 as a solution to mysql-client-core-5.7:amd64 2
  Added mariadb-client-core-10.1:amd64 to the remove list
  Conflicts//Breaks against version 1:10.1.44-0ubuntu0.18.04.1 for mariadb-client-core-10.1 but that is not InstVer, ignoring
  Conflicts//Breaks against version 1:10.1.29-6 for mariadb-client-core-10.1 but that is not InstVer, ignoring
  Fixing mysql-client-core-5.7:amd64 via keep of mariadb-client-10.1:amd64
  Fixing mysql-client-core-5.7:amd64 via keep of mariadb-client-core-10.1:amd64
  Fixing mysql-client-core-5.7:amd64 via keep of mariadb-client-core-10.1:amd64
Investigating (0) mysql-server-core-5.7:amd64 < 5.7.29-0ubuntu0.18.04.1 -> 5.7.30-0ubuntu0.18.04.1 @ii umU Ib >
Broken mysql-server-core-5.7:amd64 Conflicts on mysql-server-core-5.5:amd64 < none @un H >
  Conflicts//Breaks against version 1:10.1.43+maria-1~bionic for mariadb-server-core-10.1 but that is not InstVer, ignoring
  Conflicts//Breaks against version 1:10.1.44+maria-1~bionic for mariadb-server-core-10.1 but that is not InstVer, ignoring
  Considering mariadb-server-core-10.1:amd64 0 as a solution to mysql-server-core-5.7:amd64 0
  Re-Instated mysql-server-core-5.7:amd64
Investigating (0) mariadb-server-core-10.1:amd64 < none -> 1:10.1.45+maria-1~bionic @un uN Ib >
Broken mariadb-server-core-10.1:amd64 Conflicts on virtual-mysql-server-core:amd64 < none @un H >
  Conflicts//Breaks against version 5.7.29-0ubuntu0.18.04.1 for mysql-server-core-5.7 but that is not InstVer, ignoring
  Conflicts//Breaks against version 5.7.20-29.24-0ubuntu2.1 for percona-xtradb-cluster-server-5.7 but that is not InstVer, ignoring
  Considering mysql-server-core-5.7:amd64 0 as a solution to mariadb-server-core-10.1:amd64 0
  Holding Back mariadb-server-core-10.1:amd64 rather than change virtual-mysql-server-core:amd64
Investigating (1) mariadb-server-10.1:amd64 < none -> 1:10.1.45+maria-1~bionic @un puN Ib >
Broken mariadb-server-10.1:amd64 Depends on mariadb-client-10.1:amd64 < none | 1:10.1.45+maria-1~bionic @un uH > (>= 1:10.1.45+maria-1~bionic)
  Considering mariadb-client-10.1:amd64 0 as a solution to mariadb-server-10.1:amd64 9999
Broken mariadb-server-10.1:amd64 Depends on mariadb-server-core-10.1:amd64 < none | 1:10.1.45+maria-1~bionic @un uH > (>= 1:10.1.45+maria-1~bionic)
  Considering mariadb-server-core-10.1:amd64 0 as a solution to mariadb-server-10.1:amd64 9999
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.1 : Depends: mariadb-client-10.1 (>= 1:10.1.45+maria-1~bionic) but it is not going to be installed
                       Depends: mariadb-server-core-10.1 (>= 1:10.1.45+maria-1~bionic) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
Starting MariaDB v10.1
0.04s$ sudo systemctl start mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
$ mysql --version
mysql  Ver 14.14 Distrib 5.7.29, for Linux (x86_64) using  EditLine wrapper

Important part:

Starting MariaDB v10.1
0.04s$ sudo systemctl start mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.

Maria 10.x was also broken and fixed in travis-ci/travis-build#1774

[Incognito]

Dbal fixed this by using a dockerized build, it might be worth migrating to a fully docker-oriented system in the future given the ratio of edge-case to surface-case when with this build system.

doctrine/dbal#3527

There's an open PR against travis that highlights the infra issue a bit more travis-ci/travis-cookbooks#1057

[Incognito]

@dereuromark this issue isn't resolved unless the PR is merged.

[dereuromark]

Yes, the PR will resolve this. Just closing to keep only one of them open.