[MDEV-20516] Assertion `!lex->proc_list.first && !lex->result && !lex->param_list.elements' failed in mysql_create_view - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Fix Version/s: 10.2.42, 10.3.33, 10.4.23, 10.5.14, 10.6.6, 10.7.2, 10.8.1
Component/s: Prepared Statements
Labels:
None

Description

to reproduce run with --cursor-protocol:

create table t1 (a int);

create view v1 as select * from t1;

10.1 0e38cd37c7be46ac2b5
#3 <signal handler called>
#4 0x00007f271a4b6428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#5 0x00007f271a4b802a in __GI_abort () at abort.c:89
#6 0x00007f271a4aebd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5639ead5eed0 "!lex->proc_list.first && !lex->result && !lex->param_list.elements", file=file@entry=0x5639ead5ee40 "/10.1/sql/sql_view.cc", line=line@entry=410, function=function@entry=0x5639ead5f460 <mysql_create_view(THD, TABLE_LIST, enum_view_create_mode)::__PRETTY_FUNCTION__> "bool mysql_create_view(THD, TABLE_LIST, enum_view_create_mode)") at assert.c:92
#7 0x00007f271a4aec82 in __GI___assert_fail (assertion=0x5639ead5eed0 "!lex->proc_list.first && !lex->result && !lex->param_list.elements", file=0x5639ead5ee40 "/10.1/sql/sql_view.cc", line=410, function=0x5639ead5f460 <mysql_create_view(THD, TABLE_LIST, enum_view_create_mode)::__PRETTY_FUNCTION__> "bool mysql_create_view(THD, TABLE_LIST, enum_view_create_mode)") at assert.c:101
#8 0x00005639ea4d08e0 in mysql_create_view (thd=0x7f27127f2070, views=0x7f27108fb668, mode=VIEW_CREATE_NEW) at /10.1/sql/sql_view.cc:409
#9 0x00005639ea3f0b85 in mysql_execute_command (thd=0x7f27127f2070) at /10.1/sql/sql_parse.cc:5266
#10 0x00005639ea79a8e4 in mysql_open_cursor (thd=0x7f27127f2070, result=0x7f2710986528, pcursor=0x7f2710986590) at /10.1/sql/sql_cursor.cc:141
#11 0x00005639ea411003 in Prepared_statement::execute (this=0x7f2710986470, expanded_query=0x7f271c938ea0, open_cursor=true) at /10.1/sql/sql_prepare.cc:4342
#12 0x00005639ea40ff1f in Prepared_statement::execute_loop (this=0x7f2710986470, expanded_query=0x7f271c938ea0, open_cursor=true, packet=0x7f27147f107a "", packet_end=0x7f27147f107a "") at /10.1/sql/sql_prepare.cc:3994
#13 0x00005639ea40dcd0 in mysqld_stmt_execute (thd=0x7f27127f2070, packet_arg=0x7f27147f1071 "\002", packet_length=9) at /10.1/sql/sql_prepare.cc:3023
#14 0x00005639ea3e4f94 in dispatch_command (command=COM_STMT_EXECUTE, thd=0x7f27127f2070, packet=0x7f27147f1071 "\002", packet_length=9) at /10.1/sql/sql_parse.cc:1443
#15 0x00005639ea3e4060 in do_command (thd=0x7f27127f2070) at /10.1/sql/sql_parse.cc:1131
#16 0x00005639ea521d3d in do_handle_one_connection (thd_arg=0x7f27127f2070) at /10.1/sql/sql_connect.cc:1331
#17 0x00005639ea521a77 in handle_one_connection (arg=0x7f27127f2070) at /10.1/sql/sql_connect.cc:1242
#18 0x00005639eac2fbe8 in pfs_spawn_thread (arg=0x7f2718c15ef0) at /10.1/storage/perfschema/pfs.cc:1861
#19 0x00007f271aedd6ba in start_thread (arg=0x7f271c93a700) at pthread_create.c:333
#20 0x00007f271a58841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Attachments

Issue Links

duplicates

MDEV-25941 Assertion `!lex->proc_list.first && !lex->result && !lex->param_list.elements' failed in mysql_create_view

Closed

Activity

Ascending order - Click to sort in descending order

Alice Sherepa created issue - 2019-09-06 14:19

Alice Sherepa made changes - 2019-09-06 14:20

Field	Original Value	New Value
Assignee		Oleksandr Byelkin [ sanja ]

Alice Sherepa made changes - 2019-09-06 14:20

Status

Open [ 1 ]

Confirmed [ 10101 ]

Julien Fritsch made changes - 2020-12-01 12:40

Fix Version/s

10.1 [ 16100 ]

Sergei Golubchik made changes - 2021-12-06 21:36

Workflow

MariaDB v3 [ 99483 ]

MariaDB v4 [ 144167 ]

Elena Stepanova made changes - 2022-01-09 17:43

Link

This issue duplicates ~~MDEV-25941~~ [ ~~MDEV-25941~~ ]

Elena Stepanova made changes - 2022-01-09 17:45

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.7 [ 24805 ]
Assignee	Oleksandr Byelkin [ sanja ]	Dmitry Shulga [ JIRAUSER47315 ]

Dmitry Shulga made changes - 2022-01-19 04:35

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Dmitry Shulga made changes - 2022-01-20 15:25

Assignee	Dmitry Shulga [ JIRAUSER47315 ]	Oleksandr Byelkin [ sanja ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Oleksandr Byelkin made changes - 2022-01-21 18:04

Assignee	Oleksandr Byelkin [ sanja ]	Dmitry Shulga [ JIRAUSER47315 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Dmitry Shulga made changes - 2022-01-22 06:14

Component/s		Prepared Statements [ 10804 ]
Fix Version/s		10.2.42 [ 26803 ]
Fix Version/s		10.3.33 [ 26805 ]
Fix Version/s		10.4.23 [ 26807 ]
Fix Version/s		10.5.14 [ 26809 ]
Fix Version/s		10.6.6 [ 26811 ]
Fix Version/s		10.7.2 [ 26813 ]
Fix Version/s		10.8.1 [ 26815 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.7 [ 24805 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

People

Assignee:: Dmitry Shulga

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2019-09-06 14:19

Updated:: 2022-01-23 11:44

Resolved:: 2022-01-22 06:14

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server