Upgrading MariaDB 5.5 to 10.1.11 fails with RPM (MDEV-9584)

[MDEV-9805] After upgrade from distro's mariadb on CentOS 7 fails to restart Created: 2016-03-28  Updated: 2020-04-22

Status: Open
Project: MariaDB Server
Component/s: Packaging
Affects Version/s: N/A
Fix Version/s: 10.1

Type: Technical task Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-22329 Packages issues when upgrading Open
Relates
relates to MDEV-9766 Testing for MDEV-9584 (Relaxed rules ... Stalled
Sprint: 10.1.14

 Description   

CentOS 7 has mariadb-server and mariadb. Both get upgraded to MariaDB-server and MariaDB-client via yum upgrade or install; but the old server keeps running.

According to logs, an attempt to stop the old server and even kill it is made, but somehow it fails:

Install and start mariadb from distro

 
Mar 28 12:16:57 localhost yum[4161]: Installed: 1:mariadb-libs-5.5.44-2.el7.centos.x86_64
 
Mar 28 12:17:02 localhost yum[4161]: Installed: 1:mariadb-5.5.44-2.el7.centos.x86_64
 
Mar 28 12:17:02 localhost yum[4161]: Installed: perl-DBD-MySQL-4.023-5.el7.x86_64
 
Mar 28 12:17:09 localhost yum[4161]: Installed: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
 
Mar 28 12:17:52 localhost systemd: Starting MariaDB database server...
 
Mar 28 12:17:52 localhost mariadb-prepare-db-dir: Initializing MySQL database
 
Mar 28 12:17:52 localhost mariadb-prepare-db-dir: Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
 
Mar 28 12:17:52 localhost mariadb-prepare-db-dir: 160328 12:17:52 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 4284 ...
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: OK
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: Filling help tables...
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: 160328 12:17:54 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 4292 ...
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: OK
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: To start mysqld at boot time you have to copy
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: support-files/mysql.server to the right place for your system
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: To do so, start the server, then issue the following commands:
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: '/usr/bin/mysqladmin' -u root password 'new-password'
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: '/usr/bin/mysqladmin' -u root -h localhost.localdomain password 'new-password'
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: Alternatively you can run:
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: '/usr/bin/mysql_secure_installation'
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: which will also give you the option of removing the test
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: databases and anonymous user created by default.  This is
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: strongly recommended for production servers.
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: See the MariaDB Knowledgebase at http://mariadb.com/kb or the
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: MySQL manual for more instructions.
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: You can start the MariaDB daemon with:
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql'
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: You can test the MariaDB daemon with mysql-test-run.pl
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: cd '/usr/mysql-test' ; perl mysql-test-run.pl
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: Please report any problems at http://mariadb.org/jira
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: The latest information about MariaDB is available at http://mariadb.org/.
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: You can find additional information about the MySQL part at:
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: http://dev.mysql.com
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: Support MariaDB development by buying support/new features from MariaDB
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: Corporation Ab. You can contact us about this at sales@mariadb.com.
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: Alternatively consider joining our community based development effort:
 
Mar 28 12:17:54 localhost mariadb-prepare-db-dir: http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
 
Mar 28 12:17:54 localhost mysqld_safe: 160328 12:17:54 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
 
Mar 28 12:17:54 localhost mysqld_safe: 160328 12:17:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
 
Mar 28 12:17:58 localhost systemd: Started MariaDB database server.

install new MariaDB packages

 
Mar 28 12:24:39 localhost yum[4725]: Installed: MariaDB-common-10.1.13-1.el7.centos.x86_64
 
Mar 28 12:25:00 localhost yum[4725]: Installed: MariaDB-client-10.1.13-1.el7.centos.x86_64
 
Mar 28 12:25:41 localhost yum[4725]: Installed: MariaDB-server-10.1.13-1.el7.centos.x86_64
 
Mar 28 12:25:42 localhost yum[4725]: Installed: MariaDB-shared-10.1.13-1.el7.centos.x86_64
 
Mar 28 12:25:43 localhost systemd: Stopping MariaDB database server...
 
Mar 28 12:27:13 localhost systemd: mariadb.service stopping timed out. Skipping SIGKILL.
 
Mar 28 12:27:13 localhost systemd: Stopped MariaDB database server.
 
Mar 28 12:27:13 localhost systemd: Unit mariadb.service entered failed state.
 
Mar 28 12:27:13 localhost yum[4725]: Erased: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
 
Mar 28 12:27:14 localhost yum[4725]: Erased: 1:mariadb-5.5.44-2.el7.centos.x86_64
 
Mar 28 12:27:15 localhost yum[4725]: Erased: 1:mariadb-libs-5.5.44-2.el7.centos.x86_64

So, there was a kill attempt at 12:27:13. But the old server is still running, and if we look at the uptime, we'll see that it's been running since 12:17 when it was started:

MariaDB [(none)]> show status like 'uptime';
 
+---------------+-------+
 
| Variable_name | Value |
 
+---------------+-------+
 
| Uptime        | 874   |
 
+---------------+-------+
 
1 row in set (0.00 sec)
 
 
 
MariaDB [(none)]> exit
 
Bye
 
[elenst@localhost ~]$ date
 
Mon Mar 28 12:32:31 MSK 2016

If we further try to restart the service manually, it fails to stop the server (it does not know it's still running), and thus fails to start the new one.



 Comments   
Comment by Anel Husakovic [ 2020-04-21 ]

elenst is this worth to be tested now for fresh centos7?

# rpm -qav|grep -i mariadb
 
mariadb-libs-5.5.64-1.el7.x86_64

Generated at Thu Feb 08 07:37:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.