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

Assertion `granted_role->is_role()' fails on granting role with empty name

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.8
    • Fix Version/s: 10.0.9
    • Component/s: None
    • Labels:
      None

      Description

      grant '' to foo@localhost;
      
      10.0/sql/sql_acl.cc:5884: bool mysql_grant_role(THD*, List<st_lex_user>&, bool): Assertion `granted_role->is_role()' failed.
      140213  2:16:11 [ERROR] mysqld got signal 6 ;
      
      #6  0x00007f3387722621 in *__GI___assert_fail (assertion=0xfd23be "granted_role->is_role()", file=<optimized out>, line=5884, function=0xfd4920 "bool mysql_grant_role(THD*, List<st_lex_user>&, bool)") at assert.c:81
      #7  0x00000000005f3bf2 in mysql_grant_role (thd=0x7f338173d070, list=..., revoke=false) at 10.0/sql/sql_acl.cc:5884
      #8  0x0000000000671691 in mysql_execute_command (thd=0x7f338173d070) at 10.0/sql/sql_parse.cc:4252
      #9  0x0000000000676f9b in mysql_parse (thd=0x7f338173d070, rawbuf=0x7f337e859088 "grant '' to foo@localhost", length=25, parser_state=0x7f3388f34630) at 10.0/sql/sql_parse.cc:6447
      #10 0x0000000000669d69 in dispatch_command (command=COM_QUERY, thd=0x7f338173d070, packet=0x7f3381733071 "grant '' to foo@localhost", packet_length=25) at 10.0/sql/sql_parse.cc:1308
      #11 0x000000000066910b in do_command (thd=0x7f338173d070) at 10.0/sql/sql_parse.cc:1005
      #12 0x0000000000783371 in do_handle_one_connection (thd_arg=0x7f338173d070) at 10.0/sql/sql_connect.cc:1379
      #13 0x00000000007830c4 in handle_one_connection (arg=0x7f338173d070) at 10.0/sql/sql_connect.cc:1293
      #14 0x0000000000aab665 in pfs_spawn_thread (arg=0x7f3380a5c090) at 10.0/storage/perfschema/pfs.cc:1853
      #15 0x00007f3388c82b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #16 0x00007f33877d1a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
      
      revision-id: monty@askmonty.org-20140211220644-syb0sqr4sg3vwlx1
      revno: 4002
      branch-nick: 10.0
      

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 20 minutes
                  20m