[MDEV-13776] mysqld got signal 11 on delete returning - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2.8, 10.0(EOL), 10.1(EOL), 10.2(EOL)
Fix Version/s: 10.0.33
Component/s: Data Manipulation - Delete
Labels:
None
Environment:
Debian 9.1
mariadb-server-10.2
mariadb-plugin-connect 10.2

Description

MariaDB 10.2.8 got Signal 11 while executing DELETE RETURNING * query.

Test Case
========

CREATE TABLE t1 (id INT);

CREATE TABLE t2 (id INT);

INSERT INTO t1 VALUE(1);

INSERT INTO t1 VALUE(2);

INSERT INTO t1 VALUE(3);

INSERT INTO t2 VALUE(3);

INSERT INTO t2 VALUE(4);

INSERT INTO t2 VALUE(5);

DELETE  FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *;

I have attached the error log. Would be happy to provide any other info, if required.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

error.log
3 kB
2017-09-09 11:04
my.cnf
6 kB
2017-09-11 09:41

Issue Links

relates to

MDEV-9477 delete_returning.test fails in mdev8646 tree

Closed

Activity

Ascending order - Click to sort in descending order

Mohit Chandel created issue - 2017-09-09 11:05

Mohit Chandel made changes - 2017-09-09 11:05

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-9477~~ [ ~~MDEV-9477~~ ]

Mohit Chandel made changes - 2017-09-09 11:05

Description

MariaDB 10.2.8 got Signal 11 while executing DELETE RETURNING * query.

Test Case
========
{noformat}
CREATE TABLE t1 (id INT);
CREATE TABLE t2 (id INT);
CREATE TABLE t3 (id INT);

INSERT INTO t1 VALUE(1);
INSERT INTO t1 VALUE(2);
INSERT INTO t1 VALUE(3);

INSERT INTO t2 VALUE(3);
INSERT INTO t2 VALUE(4);
INSERT INTO t2 VALUE(5);

DELETE FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *;
{noformat}

I have attached the error log. Would be happy to provide any other info, if required.

MariaDB 10.2.8 got Signal 11 while executing DELETE RETURNING * query.

Test Case
========
{noformat}
CREATE TABLE t1 (id INT);
CREATE TABLE t2 (id INT);

INSERT INTO t1 VALUE(1);
INSERT INTO t1 VALUE(2);
INSERT INTO t1 VALUE(3);

INSERT INTO t2 VALUE(3);
INSERT INTO t2 VALUE(4);
INSERT INTO t2 VALUE(5);

DELETE FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *;
{noformat}

I have attached the error log. Would be happy to provide any other info, if required.

Alice Sherepa added a comment - 2017-09-11 09:27

can not reproduce it so far. tried ubuntu 16.04, os x 10.12.6, docker images of debian 9.1 and 8.7

MariaDB [test]> CREATE TABLE t1 (id INT);

Query OK, 0 rows affected (0.19 sec)

MariaDB [test]> CREATE TABLE t2 (id INT);

Query OK, 0 rows affected (0.21 sec)

MariaDB [test]> INSERT INTO t1 VALUE(1);

Query OK, 1 row affected (0.03 sec)

MariaDB [test]> INSERT INTO t1 VALUE(2);

Query OK, 1 row affected (0.03 sec)

MariaDB [test]> INSERT INTO t1 VALUE(3);

Query OK, 1 row affected (0.08 sec)

MariaDB [test]> INSERT INTO t2 VALUE(3);

Query OK, 1 row affected (0.02 sec)

MariaDB [test]> INSERT INTO t2 VALUE(4);

Query OK, 1 row affected (0.02 sec)

MariaDB [test]> INSERT INTO t2 VALUE(5);

Query OK, 1 row affected (0.08 sec)

MariaDB [test]> DELETE  FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *;

+------+

| id   |

+------+

|    1 |

|    2 |

+------+

2 rows in set (0.17 sec)

MariaDB [test]> \! cat /etc/debian_version

9.1

please provide your .cnf file?

Alice Sherepa added a comment - 2017-09-11 09:27 can not reproduce it so far. tried ubuntu 16.04, os x 10.12.6, docker images of debian 9.1 and 8.7 MariaDB [test]> CREATE TABLE t1 (id INT ); Query OK, 0 rows affected (0.19 sec) MariaDB [test]> CREATE TABLE t2 (id INT ); Query OK, 0 rows affected (0.21 sec) MariaDB [test]> INSERT INTO t1 VALUE(1); Query OK, 1 row affected (0.03 sec) MariaDB [test]> INSERT INTO t1 VALUE(2); Query OK, 1 row affected (0.03 sec) MariaDB [test]> INSERT INTO t1 VALUE(3); Query OK, 1 row affected (0.08 sec) MariaDB [test]> INSERT INTO t2 VALUE(3); Query OK, 1 row affected (0.02 sec) MariaDB [test]> INSERT INTO t2 VALUE(4); Query OK, 1 row affected (0.02 sec) MariaDB [test]> INSERT INTO t2 VALUE(5); Query OK, 1 row affected (0.08 sec) MariaDB [test]> DELETE FROM t1 WHERE id NOT IN ( SELECT id FROM t2) returning *; + ------+ | id | + ------+ | 1 | | 2 | + ------+ 2 rows in set (0.17 sec) MariaDB [test]> \! cat /etc/debian_version 9.1 please provide your .cnf file?

Mohit Chandel made changes - 2017-09-11 09:41

Attachment

my.cnf [ 44189 ]

Mohit Chandel added a comment - 2017-09-11 09:42

Hi Alice,

my.cnf attached.

Mohit Chandel added a comment - 2017-09-11 09:42 Hi Alice, my.cnf attached.

Alice Sherepa added a comment - 2017-09-11 11:27

Thanks for the report.
Reproducible with sql_mode=ONLY_FULL_GROUP_BY on 10.0,10.1,10.2,10.3

set sql_mode='ONLY_FULL_GROUP_BY';

CREATE TABLE t1 (id INT);

CREATE TABLE t2 (id INT);

INSERT INTO t1 VALUE(1),(2),(3);

INSERT INTO t2 VALUE(3),(4),(5);

DELETE  FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *;

stack trace (10.2.9 commit a544225d0a772bd4b67c96f5861ecc0ef7e69bba)

Thread 1 (Thread 0x7f0538afe700 (LWP 9988)):

#0  0x0000003f1d5b37d2 in base_list::push_back (this=0x18, info=0x7f04c8054700) at /home/alice/git/10.2/sql/sql_list.h:207

#1  0x0000003f1d7651c3 in List<Item_field>::push_back (this=0x18, a=0x7f04c8054700) at /home/alice/git/10.2/sql/sql_list.h:525

#2  0x0000003f1d75dbde in Field_iterator_table::create_item (this=0x7f0538afb838, thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/table.cc:5715

#3  0x0000003f1d5f4118 in Field_iterator_table_ref::create_item (this=0x7f0538afb810, thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/table.h:2521

#4  0x0000003f1d5f02d7 in insert_fields (thd=0x7f04c8000a98, context=0x7f04c8004de0, db_name=0x0, table_name=0x0, it=0x7f0538afbc20, any_privileges=false) at /home/alice/git/10.2/sql/sql_base.cc:7514

#5  0x0000003f1d5eeb87 in setup_wild (thd=0x7f04c8000a98, tables=0x7f04c801e320, fields=..., sum_func_list=0x0, wild_num=1) at /home/alice/git/10.2/sql/sql_base.cc:6946

#6  0x0000003f1da5feec in mysql_prepare_delete (thd=0x7f04c8000a98, table_list=0x7f04c801e320, wild_num=1, field_list=..., conds=0x7f0538afbd88) at /home/alice/git/10.2/sql/sql_delete.cc:763

#7  0x0000003f1da5e2c6 in mysql_delete (thd=0x7f04c8000a98, table_list=0x7f04c801e320, conds=0x7f04c801f090, order_list=0x7f04c8005028, limit=18446744073709551615, options=0, result=0x7f04c8014b00) at /home/alice/git/10.2/sql/sql_delete.cc:277

#8  0x0000003f1d65931c in mysql_execute_command (thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/sql_parse.cc:4612

#9  0x0000003f1d663b29 in mysql_parse (thd=0x7f04c8000a98, rawbuf=0x7f04c8052260 "DELETE  FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *", length=63, parser_state=0x7f0538afd240, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:7886

#10 0x0000003f1d65184b in dispatch_command (command=COM_QUERY, thd=0x7f04c8000a98, packet=0x7f04c8007e89 "DELETE  FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *", packet_length=63, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:1812

#11 0x0000003f1d6501be in do_command (thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/sql_parse.cc:1360

#12 0x0000003f1d79cb66 in do_handle_one_connection (connect=0x3f20c76f18) at /home/alice/git/10.2/sql/sql_connect.cc:1354

#13 0x0000003f1d79c8e6 in handle_one_connection (arg=0x3f20c76f18) at /home/alice/git/10.2/sql/sql_connect.cc:1260

#14 0x00007f053cacf6ba in start_thread (arg=0x7f0538afe700) at pthread_create.c:333

#15 0x00007f053bf643dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

error log

Server version: 10.2.9-MariaDB-debug

Thread pointer: 0x7f04c8000a98

stack_bottom = 0x7f0538afdec0 thread_stack 0x49000

/data/bld/10.2/bin/mysqld(my_print_stacktrace+0x38)[0x3f1e036a15]

/data/bld/10.2/bin/mysqld(handle_fatal_signal+0x3a3)[0x3f1d8c325e]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f053cad9390]

/data/bld/10.2/bin/mysqld(+0x5087d2)[0x3f1d5b37d2]

/data/bld/10.2/bin/mysqld(_ZN4ListI10Item_fieldE9push_backEPS0_+0x23)[0x3f1d7651c3]

mysys/stacktrace.c:267(my_print_stacktrace)[0x3f1d75dbde]

/data/bld/10.2/bin/mysqld(_ZN24Field_iterator_table_ref11create_itemEP3THD+0x3c)[0x3f1d5f4118]

/data/bld/10.2/bin/mysqld(_Z13insert_fieldsP3THDP23Name_resolution_contextPKcS4_P13List_iteratorI4ItemEb+0x3c6)[0x3f1d5f02d7]

/data/bld/10.2/bin/mysqld(_Z10setup_wildP3THDP10TABLE_LISTR4ListI4ItemEPS5_j+0x298)[0x3f1d5eeb87]

/data/bld/10.2/bin/mysqld(_Z20mysql_prepare_deleteP3THDP10TABLE_LISTjR4ListI4ItemEPPS4_+0x13c)[0x3f1da5feec]

/data/bld/10.2/bin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x3d2)[0x3f1da5e2c6]

/data/bld/10.2/bin/mysqld(_Z21mysql_execute_commandP3THD+0x4cc7)[0x3f1d65931c]

/data/bld/10.2/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2a2)[0x3f1d663b29]

sql/sql_list.h:207(base_list::push_back(void*))[0x3f1d65184b]

sql/sql_parse.cc:7886(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x3f1d6501be]

sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x3f1d79cb66]

sql/sql_connect.cc:1261(handle_one_connection)[0x3f1d79c8e6]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f053cacf6ba]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f053bf643dd]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x7f04c8052260): DELETE  FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *

Connection ID (thread ID): 8

Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

Alice Sherepa added a comment - 2017-09-11 11:27 Thanks for the report. Reproducible with sql_mode=ONLY_FULL_GROUP_BY on 10.0,10.1,10.2,10.3 set sql_mode= 'ONLY_FULL_GROUP_BY' ; CREATE TABLE t1 (id INT ); CREATE TABLE t2 (id INT ); INSERT INTO t1 VALUE(1),(2),(3); INSERT INTO t2 VALUE(3),(4),(5); DELETE FROM t1 WHERE id NOT IN ( SELECT id FROM t2) returning *; stack trace (10.2.9 commit a544225d0a772bd4b67c96f5861ecc0ef7e69bba) Thread 1 (Thread 0x7f0538afe700 (LWP 9988)): #0 0x0000003f1d5b37d2 in base_list::push_back (this=0x18, info=0x7f04c8054700) at /home/alice/git/10.2/sql/sql_list.h:207 #1 0x0000003f1d7651c3 in List<Item_field>::push_back (this=0x18, a=0x7f04c8054700) at /home/alice/git/10.2/sql/sql_list.h:525 #2 0x0000003f1d75dbde in Field_iterator_table::create_item (this=0x7f0538afb838, thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/table.cc:5715 #3 0x0000003f1d5f4118 in Field_iterator_table_ref::create_item (this=0x7f0538afb810, thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/table.h:2521 #4 0x0000003f1d5f02d7 in insert_fields (thd=0x7f04c8000a98, context=0x7f04c8004de0, db_name=0x0, table_name=0x0, it=0x7f0538afbc20, any_privileges=false) at /home/alice/git/10.2/sql/sql_base.cc:7514 #5 0x0000003f1d5eeb87 in setup_wild (thd=0x7f04c8000a98, tables=0x7f04c801e320, fields=..., sum_func_list=0x0, wild_num=1) at /home/alice/git/10.2/sql/sql_base.cc:6946 #6 0x0000003f1da5feec in mysql_prepare_delete (thd=0x7f04c8000a98, table_list=0x7f04c801e320, wild_num=1, field_list=..., conds=0x7f0538afbd88) at /home/alice/git/10.2/sql/sql_delete.cc:763 #7 0x0000003f1da5e2c6 in mysql_delete (thd=0x7f04c8000a98, table_list=0x7f04c801e320, conds=0x7f04c801f090, order_list=0x7f04c8005028, limit=18446744073709551615, options=0, result=0x7f04c8014b00) at /home/alice/git/10.2/sql/sql_delete.cc:277 #8 0x0000003f1d65931c in mysql_execute_command (thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/sql_parse.cc:4612 #9 0x0000003f1d663b29 in mysql_parse (thd=0x7f04c8000a98, rawbuf=0x7f04c8052260 "DELETE FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *", length=63, parser_state=0x7f0538afd240, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:7886 #10 0x0000003f1d65184b in dispatch_command (command=COM_QUERY, thd=0x7f04c8000a98, packet=0x7f04c8007e89 "DELETE FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning *", packet_length=63, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:1812 #11 0x0000003f1d6501be in do_command (thd=0x7f04c8000a98) at /home/alice/git/10.2/sql/sql_parse.cc:1360 #12 0x0000003f1d79cb66 in do_handle_one_connection (connect=0x3f20c76f18) at /home/alice/git/10.2/sql/sql_connect.cc:1354 #13 0x0000003f1d79c8e6 in handle_one_connection (arg=0x3f20c76f18) at /home/alice/git/10.2/sql/sql_connect.cc:1260 #14 0x00007f053cacf6ba in start_thread (arg=0x7f0538afe700) at pthread_create.c:333 #15 0x00007f053bf643dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 error log Server version: 10.2.9-MariaDB-debug Thread pointer: 0x7f04c8000a98 stack_bottom = 0x7f0538afdec0 thread_stack 0x49000 /data/bld/10.2/bin/mysqld(my_print_stacktrace+0x38)[0x3f1e036a15] /data/bld/10.2/bin/mysqld(handle_fatal_signal+0x3a3)[0x3f1d8c325e] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f053cad9390] /data/bld/10.2/bin/mysqld(+0x5087d2)[0x3f1d5b37d2] /data/bld/10.2/bin/mysqld(_ZN4ListI10Item_fieldE9push_backEPS0_+0x23)[0x3f1d7651c3] mysys/stacktrace.c:267(my_print_stacktrace)[0x3f1d75dbde] /data/bld/10.2/bin/mysqld(_ZN24Field_iterator_table_ref11create_itemEP3THD+0x3c)[0x3f1d5f4118] /data/bld/10.2/bin/mysqld(_Z13insert_fieldsP3THDP23Name_resolution_contextPKcS4_P13List_iteratorI4ItemEb+0x3c6)[0x3f1d5f02d7] /data/bld/10.2/bin/mysqld(_Z10setup_wildP3THDP10TABLE_LISTR4ListI4ItemEPS5_j+0x298)[0x3f1d5eeb87] /data/bld/10.2/bin/mysqld(_Z20mysql_prepare_deleteP3THDP10TABLE_LISTjR4ListI4ItemEPPS4_+0x13c)[0x3f1da5feec] /data/bld/10.2/bin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x3d2)[0x3f1da5e2c6] /data/bld/10.2/bin/mysqld(_Z21mysql_execute_commandP3THD+0x4cc7)[0x3f1d65931c] /data/bld/10.2/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2a2)[0x3f1d663b29] sql/sql_list.h:207(base_list::push_back(void*))[0x3f1d65184b] sql/sql_parse.cc:7886(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x3f1d6501be] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x3f1d79cb66] sql/sql_connect.cc:1261(handle_one_connection)[0x3f1d79c8e6] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f053cacf6ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f053bf643dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f04c8052260): DELETE FROM t1 WHERE id NOT IN (SELECT id FROM t2) returning * Connection ID (thread ID): 8 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

Alice Sherepa made changes - 2017-09-11 11:28

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2017-09-11 11:28

Affects Version/s		10.0 [ 16000 ]
Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.1 [ 16100 ]

Alice Sherepa made changes - 2017-09-11 12:37

Assignee

Sergei Petrunia [ psergey ]

Alice Sherepa made changes - 2017-09-11 12:37

Fix Version/s		10.0 [ 16000 ]
Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.1 [ 16100 ]

Alice Sherepa made changes - 2017-09-11 13:52

Assignee

Sergei Petrunia [ psergey ]

Igor Babaev [ igor ]

Igor Babaev (Inactive) made changes - 2017-10-23 02:15

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Igor Babaev (Inactive) added a comment - 2017-10-24 03:55 - edited

A fix for the bug was pushed into 10.0 .

Igor Babaev (Inactive) added a comment - 2017-10-24 03:55 - edited A fix for the bug was pushed into 10.0 .

Igor Babaev (Inactive) made changes - 2017-10-24 03:55

Fix Version/s		10.0.33 [ 22552 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.0 [ 16000 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

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

Workflow

MariaDB v3 [ 82518 ]

MariaDB v4 [ 152800 ]

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Mohit Chandel

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2017-09-09 11:05

Updated:: 2017-10-24 04:00

Resolved:: 2017-10-24 03:55

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration