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

Server Crash (Segfault) on CREATE ROLE when mysql.procs_priv has an invalid structure

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      Hello, I found that the server crashes when CREATE ROLE is executed after the mysql.procs_priv table has been modified.
      Even though changing a system table isn't a standard operation, it would be much safer if the server returned an error about the table's invalid state instead of crashing. This would make the server more resilient to unexpected configurations.

      How to repeat

      ALTER TABLE mysql.servers DROP COLUMN Owner;
      		 
      INSERT INTO mysql.servers VALUES (0,0,0,0,0,0,0,0);
      		 
      FLUSH PRIVILEGES ;
      		 
      ALTER TABLE mysql.plugin DROP COLUMN dl;
      		 
      INSTALL SONAME "ha_example" ;
      		 
      CREATE OR REPLACE TABLE mysql.procs_priv (id INT );
      		 
      INSERT INTO mysql.procs_priv VALUES (0);
      		 
      CREATE ROLE r;

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28482 SIGSEGV in get_access_value_from_val_int

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24193 UBSAN: sql/sql_acl.cc:9985:29: runtime error: member access within null pointer of type 'struct TABLE' , ASAN: use-after-poison in handle_grant_table

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35622 SEGV, ASAN use-after-poison when reading system table with less than expected number of columns

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              imchifan 刘启帆
              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.