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

ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist inconsistency/regression (on optimized builds)

Details

    Description

      SELECT user,host FROM mysql.user;
      SELECT USER(),CURRENT_USER();
      DELETE FROM mysql.user WHERE user like '%';
      SELECT user,host FROM mysql.user;
      FLUSH PRIVILEGES;  
      SELECT USER(),CURRENT_USER();
      # Following query will produce ERROR 1449 on 10.4.14 and 10.5.4 (opt+dbg on both), 
      # And "OK" on 10.1.46, 10.2.33, and 10.3.24 (dbg+opt both tested on all) and MySQL 5.5.62, 5.6.47, 5.7.29, and 8.0.19 (opt tested on all)
      SELECT * FROM mysql.user;  
      

      10.5.4 4080e3acefd7e58d88c2f3539fb6a0fb359cf057

      10.5.4>SELECT * FROM mysql.user;  
      ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist
      

      Attachments

        Activity

          History/possibly related: MDEV-22542, MDEV-22477, MDEV-19650, MDEV-22683, (DBAAS-3699), (TODO-2339), (TODO-2372)

          Roel Roel Van de Paar added a comment - History/possibly related: MDEV-22542 , MDEV-22477 , MDEV-19650 , MDEV-22683 , (DBAAS-3699), (TODO-2339), (TODO-2372)

          mysql.user is a view, its definer is mariadb.sys@localhost user. You delete this user — the view becomes not accessible. This is expected.

          serg Sergei Golubchik added a comment - mysql.user is a view, its definer is mariadb.sys@localhost user. You delete this user — the view becomes not accessible. This is expected.

          serg Understood. How about the differences between the versions?

          Roel Roel Van de Paar added a comment - serg Understood. How about the differences between the versions?

          The difference is due to the fact that 10.4 uses mysql.global_priv and older versions use mysql.user to store user information

          serg Sergei Golubchik added a comment - The difference is due to the fact that 10.4 uses mysql.global_priv and older versions use mysql.user to store user information

          Aha, understood. Thank you for the input.

          Roel Roel Van de Paar added a comment - Aha, understood. Thank you for the input.

          People

            serg Sergei Golubchik
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.