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

mysql_upgrade is not executed on package upgrade on Debian

Details

    Description

      It seems that mysql_upgrade is not (always?) executed automatically anymore on packages upgrade on recent Debian using the MariaDB repositories.

      For example, on two fresh Debian Stretch (using systemd), upgrading from MariaDB 10.1.37 (from the Debian repository) to a 10.2.23 (from the MariaDB repository) did need to manually execute mysql_upgrade after the packages upgrade ended and the servers were running for a few minutes (the debian-start script was not running anymore).

      I recall having a similar issue on upgrade from 10.0 to 10.1 on Debian Jessie (both from the MariaDB repository).

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12576 Upgrade MariaDB 10.0 from Distro to 10.1 from MariaDB Repo does not happen

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14622 Running mysql_upgrade in background upon package installation or upgrade causes deadlocks and other side-effects

          • Major - Major loss of function.
          • Closed

          Activity

            elenst Elena Stepanova added a comment -

            Yes, there is a notorious race condition around mysql_upgrade on deb-based systems, which unfortunately remains unresolved so far.
            Here are a couple of open issues about it: MDEV-14622 MDEV-12576 , possibly there are even more.

            elenst Elena Stepanova added a comment - Yes, there is a notorious race condition around mysql_upgrade on deb-based systems, which unfortunately remains unresolved so far. Here are a couple of open issues about it: MDEV-14622 MDEV-12576 , possibly there are even more.

            People

              Unassigned Unassigned
              jb-boin Jean Weisbuch
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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