Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21793

The mariadb.service unit not enabled after MDB set up (enabled commands to start at boot)

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4.12, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
    • 10.4(EOL)
    • Scripts & Clients, Server
    • None

    Description

      Hello Folks,

      Any reason for the mariadb.service unit not be enabled to start at OS boot for the MariaDB Server 10.4.12, as it is for the 10.3?

      [BIANCHI LABS] root@opmdb01: ~ # systemctl is-enabled mariadb.service
      		 
      disabled
      		 
       
      		 
      [BIANCHI LABS] root@opmdb01: ~ # mysqld --version
      		 
      mysqld  Ver 10.4.12-MariaDB-log for Linux on x86_64 (MariaDB Server)
      		 
       
      		 
      [BIANCHI LABS] root@opmdb01: ~ # rpm -qa | grep -i mariadb
      		 
      MariaDB-client-10.4.12-1.el7.centos.x86_64
      		 
      MariaDB-common-10.4.12-1.el7.centos.x86_64
      		 
      MariaDB-backup-10.4.12-1.el7.centos.x86_64
      		 
      MariaDB-compat-10.4.12-1.el7.centos.x86_64
      		 
      MariaDB-server-10.4.12-1.el7.centos.x86_64

      Thanks!

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19432 Systemd service does not get re-enabled after upgrade

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            wagnerbianchi Wagner Bianchi (Inactive) created issue -
            wagnerbianchi Wagner Bianchi (Inactive) made changes -
            Field Original Value New Value
            Summary The mariadb.service unit not enabled after set up (enabled commands to start at boot) The mariadb.service unit not enabled after MDB set up (enabled commands to start at boot)
            wagnerbianchi Wagner Bianchi (Inactive) made changes -
            Description Hello Folks,

            Any reason for the mariadb.service unit not be enabled to start at OS boot for the MariaDB Server 10.4.12, as it is for the 10.3?

            {code:java}
            [BIANCHI LABS] root@opmdb01: ~ # systemctl is-enabled mariadb.service
            disabled
            [BIANCHI LABS] root@opmdb01: ~ # mysqld --version
            mysqld Ver 10.4.12-MariaDB-log for Linux on x86_64 (MariaDB Server)
            [BIANCHI LABS] root@opmdb01: ~ # rpm -qa | grep -i mariadb
            MariaDB-client-10.4.12-1.el7.centos.x86_64
            MariaDB-common-10.4.12-1.el7.centos.x86_64
            MariaDB-backup-10.4.12-1.el7.centos.x86_64
            MariaDB-compat-10.4.12-1.el7.centos.x86_64
            MariaDB-server-10.4.12-1.el7.centos.x86_64
            {code}

            Thanks!             		Hello Folks,

            Any reason for the mariadb.service unit not be enabled to start at OS boot for the MariaDB Server 10.4.12, as it is for the 10.3?

            {code:java}
            [BIANCHI LABS] root@opmdb01: ~ # systemctl is-enabled mariadb.service
            disabled

            [BIANCHI LABS] root@opmdb01: ~ # mysqld --version
            mysqld Ver 10.4.12-MariaDB-log for Linux on x86_64 (MariaDB Server)

            [BIANCHI LABS] root@opmdb01: ~ # rpm -qa | grep -i mariadb
            MariaDB-client-10.4.12-1.el7.centos.x86_64
            MariaDB-common-10.4.12-1.el7.centos.x86_64
            MariaDB-backup-10.4.12-1.el7.centos.x86_64
            MariaDB-compat-10.4.12-1.el7.centos.x86_64
            MariaDB-server-10.4.12-1.el7.centos.x86_64
            {code}

            Thanks!
            wagnerbianchi Wagner Bianchi (Inactive) added a comment -

            Or we enable that during the setup of the package:

            [BIANCHI LABS] root@opmdb01: ~ # systemctl --now enable mariadb.service
            		 
            Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/mariadb.service.
            		 
            Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/mariadb.service.
            		 
            Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
            		 
             
            		 
            [BIANCHI LABS] root@opmdb01: ~ # systemctl is-enabled mariadb.service
            		 
            enabled

            Or we add the above the installation documentation.

            wagnerbianchi Wagner Bianchi (Inactive) added a comment - Or we enable that during the setup of the package: [BIANCHI LABS] root @opmdb01 : ~ # systemctl --now enable mariadb.service Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/mariadb.service. Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/mariadb.service. Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.   [BIANCHI LABS] root @opmdb01 : ~ # systemctl is-enabled mariadb.service enabled Or we add the above the installation documentation.
            elenst Elena Stepanova added a comment -

            I assume by "as it is for the 10.3" you mean either 10.3.18 or earlier, or an upgrade from a previous version.

            The difference apparently came with MDEV-19432. 

            commit 8fce180765b2ede9fb9f0f7ee6ffcda3386050bf
            		 
            Author: Sergei Golubchik <serg@mariadb.org>
            		 
            Date:   Wed Oct 30 09:50:52 2019 +0100
            		 
             
            		 
                MDEV-19432 Systemd service does not get re-enabled after upgrade
            		 
                
                following Fedora recommendations (see %systemd_post macro in FC29)
            		 
                let's do `systemctl preset` on the first installation of the server

            The postin script did and still does enable the service, but then /usr/bin/systemctl preset mariadb.service disables it again – at least on CentOS, for new installations.

            elenst Elena Stepanova added a comment - I assume by "as it is for the 10.3" you mean either 10.3.18 or earlier, or an upgrade from a previous version. The difference apparently came with MDEV-19432 . commit 8fce180765b2ede9fb9f0f7ee6ffcda3386050bf Author: Sergei Golubchik <serg@mariadb.org> Date: Wed Oct 30 09:50:52 2019 +0100   MDEV-19432 Systemd service does not get re-enabled after upgrade following Fedora recommendations (see %systemd_post macro in FC29) let's do `systemctl preset` on the first installation of the server The postin script did and still does enable the service, but then /usr/bin/systemctl preset mariadb.service disables it again – at least on CentOS, for new installations.
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Component/s Scripts & Clients [ 11002 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Affects Version/s 10.1 [ 16100 ]
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            Assignee Sergei Golubchik [ serg ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 104195 ] MariaDB v4 [ 144229 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.2 [ 14601 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]

            People

              serg Sergei Golubchik
              wagnerbianchi Wagner Bianchi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.