Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5.5
-
None
Description
The server is crashing while executing the view creation in the following files:
```
root@tntnatbry-2:/home# mysql < base.sql
root@tntnatbry-2:/home# mysql < view.sql
ERROR 2013 (HY000) at line 3: Lost connection to MySQL server during query
```
Attachments
Issue Links
- duplicates
-
-
- Closed
-
Activity
Thanks a lot! I reproduced the case on 10.5.5, 10.2-10.5
It appears to be the same problem as MDEV-22781.
200930 10:40:21 [ERROR] mysqld got signal 11 ;
|
|
|
Server version: 10.5.5-MariaDB
|
|
|
strings/strnmov.c:41(strnmov)[0x562fc2552bca]
|
sql/sql_acl.cc:3508(acl_get(char const*, char const*, char const*, char const*, char))[0x562fc2553f4f]
|
sql/privilege.h:197(operator|)[0x562fc267f952]
|
sql/sql_view.cc:293(create_view_precheck(THD*, TABLE_LIST*, TABLE_LIST*, enum_view_create_mode))[0x562fc267fb98]
|
sql/sql_view.cc:426(mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode))[0x562fc25d0e8d]
|
sql/sql_parse.cc:5760(mysql_execute_command(THD*))[0x562fc25d565c]
|
sql/sql_parse.cc:7994(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562fc25d76d2]
|
sql/sql_parse.cc:1927(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562fc25d8b5b]
|
sql/sql_parse.cc:1353(do_command(THD*))[0x562fc26c0b92]
|
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x562fc26c0e44]
|
sql/sql_connect.cc:1318(handle_one_connection)[0x562fc2a3e02d]
|
nptl/pthread_create.c:463(start_thread)[0x7f9b1e2a86db]
|
x86_64/clone.S:97(clone)[0x7f9b1d064a3f]
|
|
10.2 842616532a76cd078ba1d5 |
Server version: 10.2.34-MariaDB-debug-log
|
|
|
strings/strnmov.c:41(strnmov)[0x563a170b6dd4]
|
sql/sql_acl.cc:3046(acl_get(char const*, char const*, char const*, char const*, char))[0x563a165ad1e5]
|
sql/sql_acl.cc:11850(fill_effective_table_privileges(THD*, st_grant_info*, char const*, char const*))[0x563a165c9367]
|
sql/sql_view.cc:292(create_view_precheck(THD*, TABLE_LIST*, TABLE_LIST*, enum_view_create_mode))[0x563a16741243]
|
sql/sql_view.cc:427(mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode))[0x563a16741563]
|
sql/sql_parse.cc:5788(mysql_execute_command(THD*))[0x563a16650210]
|
sql/sql_parse.cc:7733(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563a16655ba7]
|
sql/sql_parse.cc:1826(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x563a16643eb3]
|
sql/sql_parse.cc:1377(do_command(THD*))[0x563a16642930]
|
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x563a16798ed9]
|
sql/sql_connect.cc:1242(handle_one_connection)[0x563a16798c44]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x563a16fad45d]
|
nptl/pthread_create.c:463(start_thread)[0x7f234af156db]
|
x86_64/clone.S:97(clone)[0x7f234a2ffa3f]
|
|
|
|
|
..............
|
[^view.sql] [^base.sql]
Attached are the .sql files used in the issue description.