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

Segfault when switching to new catalog and manipulating grants

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • N/A
    • N/A
    • None

    Description

      Found during CloudFest Hackathon:

      When doing the following, a segfault will occur:

      1. Start MariaDB Server in catalogs mode
      2. Create a new catalog with mariadb-install-db --catalogs=cat
      3. Log in as super user to the def catalog
      4. USE CATALOG cat
      5. CREATE USER / GRANT / FLUSH PRIVILEGES all crash with related crashes

      If you create the catalog with MariaDB Server not running, or restart MariaDB Server, all is fine.

      Example crash:
      code
      2024-03-17 09:53:58 Thread pointer: 0x7f183c000c68
      2024-03-17 09:53:58 Attempting backtrace. You can use the following information to find out
      2024-03-17 09:53:58 where mysqld died. If you see no messages after this, something went
      2024-03-17 09:53:58 terribly wrong...
      2024-03-17 09:53:58 stack_bottom = 0x7f18e80b7cb8 thread_stack 0x49000
      2024-03-17 09:54:00 mysys/stacktrace.c:217(my_print_stacktrace)[0x55ce888d1dd2]
      2024-03-17 09:54:00 sql/signal_handler.cc:241(handle_fatal_signal)[0x55ce8845bcd3]
      2024-03-17 09:54:00 /lib/x86_64-linux-gnu/libc.so.6(+0x42990)[0x7f18ec3f3990]
      2024-03-17 09:54:01 psi/mysql_thread.h:931(mysql_grant(THD*, char const*, List<LEX_USER>&, privilege_t, bool, bool))[0x55ce881bcaf5]
      2024-03-17 09:54:01 sql/sql_acl.cc:13443(Sql_cmd_grant_table::execute_table_mask(THD*))[0x55ce881bd8ba]
      2024-03-17 09:54:01 sql/sql_parse.cc:6116(mysql_execute_command(THD*, bool))[0x55ce8823599e]
      2024-03-17 09:54:01 sql/sql_parse.cc:8164(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55ce8823a13d]
      2024-03-17 09:54:01 sql/sql_parse.cc:1910(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55ce8823c55d]
      2024-03-17 09:54:01 sql/sql_parse.cc:1418(do_command(THD*, bool))[0x55ce8823d67b]
      2024-03-17 09:54:01 sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x55ce8833dbc7]
      2024-03-17 09:54:01 sql/sql_connect.cc:1319(handle_one_connection)[0x55ce8833df5d]
      2024-03-17 09:54:02 perfschema/pfs.cc:2204(pfs_spawn_thread)[0x55ce8864e5cf]
      2024-03-17 09:54:02 /lib/x86_64-linux-gnu/libc.so.6(+0x97b5a)[0x7f18ec448b5a]
      2024-03-17 09:54:02 /lib/x86_64-linux-gnu/libc.so.6(+0x1285fc)[0x7f18ec4d95fc]
      2024-03-17 09:54:02
      2024-03-17 09:54:02 Trying to get some variables.
      2024-03-17 09:54:02 Some pointers may be invalid and cause the dump to abort.
      2024-03-17 09:54:02 Query (0x7f183c010c10): GRANT ALL PRIVILEGES ON . TO 'user1'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION
      2024-03-17 09:54:02
      code

      Attachments

        Issue Links

          Activity

            People

              TheLinuxJedi Andrew Hutchings
              TheLinuxJedi Andrew Hutchings
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.