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

foreign server "disappears" after ALTERing the servers system table to use innodb and FLUSH PRIVILEGES

Details

    Description

      Not sure if it counts as a bug since system tables are not supposed to be altered by users. Split from MDEV-35557 for tracking / documentation purposes at least:

      CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS (HOST '127.0.0.1');
      ALTER TABLE mysql.servers ENGINE=innodb;
      FLUSH PRIVILEGES;
      drop server s1;
      

      results in

      temp.mdev_35557                          [ fail ]
              Test ended at 2024-12-13 16:28:12
       
      CURRENT_TEST: temp.mdev_35557
      mysqltest: At line 22: query 'drop server s1' failed: 1477: The foreign server name you are trying to reference does not exist. Data source error:  s1
      

      Attachments

        Issue Links

          Activity

            ycp Yuchen Pei added a comment - - edited

            see marko's analysis at https://jira.mariadb.org/browse/MDEV-35557?focusedCommentId=295928&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-295928

            Bringing the call to table->use_all_columns() forward seems to fix the testcase:

            0efc45e922e upstream/bb-10.5-mdev-35641 MDEV-35641 bring call to use_all_columns() forward when reading from mysql.servers
            

            ycp Yuchen Pei added a comment - - edited see marko 's analysis at https://jira.mariadb.org/browse/MDEV-35557?focusedCommentId=295928&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-295928 Bringing the call to table->use_all_columns() forward seems to fix the testcase: 0efc45e922e upstream/bb-10.5-mdev-35641 MDEV-35641 bring call to use_all_columns() forward when reading from mysql.servers
            ycp Yuchen Pei added a comment - - edited

            Hi sanja, ptal thanks

            0efc45e922e upstream/bb-10.5-mdev-35641 MDEV-35641 bring call to use_all_columns() forward when reading from mysql.servers
            

            ycp Yuchen Pei added a comment - - edited Hi sanja , ptal thanks 0efc45e922e upstream/bb-10.5-mdev-35641 MDEV-35641 bring call to use_all_columns() forward when reading from mysql.servers

            OK to push

            sanja Oleksandr Byelkin added a comment - OK to push
            ycp Yuchen Pei added a comment -

            thanks for the review - pushed f862fe8b2bb359e0bbeb48d0d38047a95dc0e43c to 10.5

            ycp Yuchen Pei added a comment - thanks for the review - pushed f862fe8b2bb359e0bbeb48d0d38047a95dc0e43c to 10.5

            People

              ycp Yuchen Pei
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.