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

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.5
    • 10.5
    • Server
    • None

    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

          split from

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35557 SIGSEGV in get_server_from_table_to_cache | servers_load, UBSAN null pointer passed as argument 1, which is declared to never be null

          • Major - Major loss of function.
          • In Review

          Activity

            People

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