Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9584 Upgrading MariaDB 5.5 to 10.1.11 fails with RPM
  3. MDEV-9805

After upgrade from distro's mariadb on CentOS 7 fails to restart

    XMLWordPrintable

Details

    • Technical task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • 10.1
    • Packaging
    • None
    • 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.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.