2018-03-20 10:52:46 |
Dimitri John Ledkov |
bug |
|
|
added bug |
2018-03-20 10:52:58 |
Dimitri John Ledkov |
mariadb-10.1 (Ubuntu): importance |
Undecided |
Critical |
|
2018-03-20 10:53:17 |
Dimitri John Ledkov |
summary |
Security update 10.1.30-0ubuntu0.17.10.1 regresses smoke test |
Security update 10.1.30-0ubuntu0.17.10.1 regresses smoke test, mariadb not started upon install |
|
2018-03-20 10:53:23 |
Dimitri John Ledkov |
information type |
Public |
Public Security |
|
2018-03-20 10:53:59 |
Dimitri John Ledkov |
bug |
|
|
added subscriber Canonical Server Team |
2018-03-20 17:46:19 |
Dimitri John Ledkov |
nominated for series |
|
Ubuntu Artful |
|
2018-03-20 17:46:19 |
Dimitri John Ledkov |
bug task added |
|
mariadb-10.1 (Ubuntu Artful) |
|
2018-03-21 00:00:20 |
Dimitri John Ledkov |
attachment added |
|
lp1757107.diff https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1757107/+attachment/5085457/+files/lp1757107.diff |
|
2018-03-21 00:00:36 |
Dimitri John Ledkov |
bug |
|
|
added subscriber Ubuntu Security Sponsors Team |
2018-03-21 00:04:54 |
Dimitri John Ledkov |
description |
10.1.30-0ubuntu0.17.10.1 upload of mariadb-10.1 regresses autopkgtest smoke test like so:
Setting up mariadb-server-core-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Setting up mariadb-client-core-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Setting up mariadb-client-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Setting up mariadb-server-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Created symlink /etc/systemd/system/mysql.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /lib/systemd/system/mariadb.service.
Setting up autopkgtest-satdep (0) ...
Processing triggers for libc-bin (2.26-0ubuntu2.1) ...
Processing triggers for systemd (234-2ubuntu12.3) ...
(Reading database ... 69452 files and directories currently installed.)
Removing autopkgtest-satdep (0) ...
autopkgtest [00:52:38]: test smoke: [-----------------------
+ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
autopkgtest [00:52:39]: test smoke: -----------------------]
autopkgtest [00:52:39]: test smoke: - - - - - - - - - - results - - - - - - - - - -
smoke FAIL non-zero exit status 1
Looks like the server is not started ?
It appears so, at least reproducible in lxd container. There are maintainer scripts to start init.d script, however that is not done for systemd. I do not se for example deb-systemd-helper start mariadb.service at all. Possibly regression due to using a new/different debhelper during package build. |
[Impact]
- In debian/rules, -pie introduced, yet previously the build was fully hardened. (I believe this is cosmetic, as supposedly the build system defaults to pie anyway)
- There used to be a default client socket set, but not anymore.
- Most importantly, the dh_systemd_start workarounds were dropped; yet are still needed on artful, as otherwise after server installation the unit is not started / not running
- Due to last one, autopkgtests are failing - see http://autopkgtest.ubuntu.com/packages/mariadb-10.1 and thus blocking releasing other SRUs, e.g. systemd one.
[Solution]
- perform partial revert of packaging changes, back to what it was before (all the hacks & workarounds included)
[Testcase]
- autopkgtests should pass for mariadb-10.1 package, specifically the smoke test case
[Regression Potential]
Reverting packaging changes introduced in the last update; back to what they were before and what they are in the release pocket. This revert may have been done incorrectly, thus yielding more maintainer script bugs, but interactive testing of this revert appears to be functioning correctly.
[Original Bug report]
10.1.30-0ubuntu0.17.10.1 upload of mariadb-10.1 regresses autopkgtest smoke test like so:
Setting up mariadb-server-core-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Setting up mariadb-client-core-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Setting up mariadb-client-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Setting up mariadb-server-10.1 (10.1.30-0ubuntu0.17.10.1) ...
Created symlink /etc/systemd/system/mysql.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /lib/systemd/system/mariadb.service.
Setting up autopkgtest-satdep (0) ...
Processing triggers for libc-bin (2.26-0ubuntu2.1) ...
Processing triggers for systemd (234-2ubuntu12.3) ...
(Reading database ... 69452 files and directories currently installed.)
Removing autopkgtest-satdep (0) ...
autopkgtest [00:52:38]: test smoke: [-----------------------
+ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
autopkgtest [00:52:39]: test smoke: -----------------------]
autopkgtest [00:52:39]: test smoke: - - - - - - - - - - results - - - - - - - - - -
smoke FAIL non-zero exit status 1
Looks like the server is not started ?
It appears so, at least reproducible in lxd container. There are maintainer scripts to start init.d script, however that is not done for systemd. I do not se for example deb-systemd-helper start mariadb.service at all. Possibly regression due to using a new/different debhelper during package build. |
|
2018-03-21 00:34:38 |
Seth Arnold |
bug |
|
|
added subscriber Otto Kekäläinen |
2018-03-26 12:36:22 |
Francis Ginther |
tags |
adt-fail artful regression-update |
adt-fail artful id-5ab3c4d27fa5364dd97ee6d2 regression-update |
|
2018-04-15 05:26:11 |
Simon Quigley |
removed subscriber Ubuntu Security Sponsors Team |
|
|
|
2018-06-28 21:56:21 |
Launchpad Janitor |
mariadb-10.1 (Ubuntu): status |
New |
Confirmed |
|
2018-06-28 21:56:21 |
Launchpad Janitor |
mariadb-10.1 (Ubuntu Artful): status |
New |
Confirmed |
|
2018-07-03 16:54:24 |
Dimitri John Ledkov |
mariadb-10.1 (Ubuntu): importance |
Critical |
Undecided |
|
2018-07-03 16:54:37 |
Dimitri John Ledkov |
mariadb-10.1 (Ubuntu): assignee |
|
Otto Kekäläinen (otto) |
|
2019-05-16 01:06:44 |
Steve Beattie |
mariadb-10.1 (Ubuntu Artful): status |
Confirmed |
Won't Fix |
|
2019-05-16 05:13:27 |
Mathew Hodson |
mariadb-10.1 (Ubuntu): status |
Confirmed |
Fix Released |
|