Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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
- is part of
-
MDEV-31542 Add multi-tenancy catalogs to MariaDB
- Stalled