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

Server crashes on REVOKE ... from CURRENT_ROLE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0.5
    • Component/s: None
    • Labels:
      None

      Description

      It doesn't matter whether the current role is set and whether it has the grants we attempt to revoke.

      revoke all on db.* from current_role;

      #3  <signal handler called>
      #4  0x00000000005c1aad in is_acl_user (host=0xa5a5a5a5a5a5a5a5 <Address 0xa5a5a5a5a5a5a5a5 out of bounds>, user=0xfc2503 "*current_role") at 10.0/sql/sql_acl.cc:2680
      #5  0x000000000064ae40 in mysql_execute_command (thd=0x7f6741ff5070) at 10.0/sql/sql_parse.cc:4105
      #6  0x0000000000650e00 in mysql_parse (thd=0x7f6741ff5070, rawbuf=0x7f674243b088 "revoke all on db.* from current_role", length=36, parser_state=0x7f675f0a14b0) at 10.0/sql/sql_parse.cc:6365
      #7  0x000000000064377b in dispatch_command (command=COM_QUERY, thd=0x7f6741ff5070, packet=0x7f67427f5071 "revoke all on db.* from current_role", packet_length=36) at 10.0/sql/sql_parse.cc:1289
      #8  0x0000000000642b7e in do_command (thd=0x7f6741ff5070) at 10.0/sql/sql_parse.cc:994
      #9  0x0000000000761411 in do_handle_one_connection (thd_arg=0x7f6741ff5070) at 10.0/sql/sql_connect.cc:1379
      #10 0x0000000000761164 in handle_one_connection (arg=0x7f6741ff5070) at 10.0/sql/sql_connect.cc:1293
      #11 0x00000000009f8f4b in pfs_spawn_thread (arg=0x7f674231e2b0) at 10.0/storage/perfschema/pfs.cc:1853
      #12 0x00007f675e025e9a in start_thread (arg=0x7f675f0a2700) at pthread_create.c:308
      #13 0x00007f675d540cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      revision-id: bar@mnogosearch.org-20131031102424-373xqcw7iki4zlqt
      revno: 3873
      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: