[MDEV-23847] Server crash during view creation Created: 2020-09-29  Updated: 2020-10-08  Resolved: 2020-09-30

Status: Closed
Project: MariaDB Server
Component/s: Optimizer - CTE
Affects Version/s: 10.5.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Gagan Goel (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-22781 CREATE VIEW containing WITH clause Si... Closed

 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
```



 Comments   
Comment by Gagan Goel (Inactive) [ 2020-09-29 ]

[^view.sql] [^base.sql]

Attached are the .sql files used in the issue description.

Comment by Alice Sherepa [ 2020-09-30 ]

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]
 
 
..............

Generated at Thu Feb 08 09:25:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.