[MDEV-22422] Assertion `! is_set()' failed in Diagnostics_area::set_eof_status - 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
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9
Component/s: Variables
Labels:
- affects-tests

Description

SET max_session_mem_used = 50000;

help 'it is going to crash';

help 'it is going to crash';

help 'it is going to crash';

help 'it is going to crash';

help 'it is going to crash';  # Crashes

help 'it crashed';

Leads to:

10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f
mysqld: /test/10.5_dbg/sql/sql_error.cc:375: void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.

10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f
Core was generated by `/test/MD210420-mariadb-10.5.3-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
[Current thread is 1 (Thread 0x7f8234e7c700 (LWP 561173))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1 0x000055c78332903d in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
#2 0x000055c782aced7b in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:329
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007f82335c0801 in __GI_abort () at abort.c:79
#6 0x00007f82335b039a in __assert_fail_base (fmt=0x7f82337377d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD)") at assert.c:92
#7 0x00007f82335b0412 in __GI___assert_fail (assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD)") at assert.c:101
#8 0x000055c7827da737 in Diagnostics_area::set_eof_status (this=0x7f820701ab88, thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_error.cc:375
#9 0x000055c782c9bc95 in my_eof (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_class.h:5166
#10 mysqld_help_internal (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:844
#11 0x000055c782c9c1bb in mysqld_help (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:860
#12 0x000055c782824a58 in mysql_execute_command (thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:3938
#13 0x000055c782831f2b in mysql_parse (thd=thd@entry=0x7f8207015088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f8234e7b450, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7957
#14 0x000055c78281dc45 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8207015088, packet=packet@entry=0x7f8207067089 "", packet_length=packet_length@entry=27, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1839
#15 0x000055c78281c49b in do_command (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:1358
#16 0x000055c782977415 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7f8212fc53a8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1422
#17 0x000055c782977744 in handle_one_connection (arg=arg@entry=0x7f8212fc53a8) at /test/10.5_dbg/sql/sql_connect.cc:1319
#18 0x000055c782dd7fb0 in pfs_spawn_thread (arg=0x7f8232845b08) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
#19 0x00007f82342a36db in start_thread (arg=0x7f8234e7c700) at pthread_create.c:463
#20 0x00007f82336a188f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Bug confirmed present in:
MariaDB: 10.1.45 (dbg), 10.2.32 (dbg), 10.3.23 (dbg), 10.4.13 (dbg), 10.5.2 (dbg), 10.5.3 (dbg)

Bug confirmed not present in:
MariaDB: 10.1.45 (opt), 10.2.32 (opt), 10.3.23 (opt), 10.4.13 (opt), 10.5.2 (opt), 10.5.3 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

Attachments

Issue Links

relates to

MDEV-13011 Server crashes in THD::handle_condition or Assertion `! is_set() || m_can_overwrite_status' fails upon attempt to connect with max_session_mem_used = 8192

Closed

MDEV-13179 main.errors fails in buildbot and outside with wrong errno 1290

Closed

MDEV-22708 Assertion `!mysql_bin_log.is_open() || thd.is_current_stmt_binlog_format_row()' failed in Delayed_insert::handle_inserts and in Diagnostics_area::set_eof_status

Closed

MDEV-25735 Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed in Diagnostics_area::set_eof_status

Confirmed

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar created issue - 2020-04-30 05:19

Roel Van de Paar made changes - 2020-04-30 05:27

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

Roel Van de Paar made changes - 2020-04-30 05:27

Link

This issue relates to ~~MDEV-13011~~ [ ~~MDEV-13011~~ ]

Roel Van de Paar made changes - 2020-04-30 05:29

Description

{noformat}
SET max_session_mem_used = 50000;
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
{noformat}

Leads to:

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
mysqld: /test/10.5_dbg/sql/sql_error.cc:375: void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.
{noformat}

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
Core was generated by `/test/MD210420-mariadb-10.5.3-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
[Current thread is 1 (Thread 0x7f8234e7c700 (LWP 561173))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1 0x000055c78332903d in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
#2 0x000055c782aced7b in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:329
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007f82335c0801 in __GI_abort () at abort.c:79
#6 0x00007f82335b039a in __assert_fail_base (fmt=0x7f82337377d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:92
#7 0x00007f82335b0412 in __GI___assert_fail (assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:101
#8 0x000055c7827da737 in Diagnostics_area::set_eof_status (this=0x7f820701ab88, thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_error.cc:375
#9 0x000055c782c9bc95 in my_eof (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_class.h:5166
#10 mysqld_help_internal (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:844
#11 0x000055c782c9c1bb in mysqld_help (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:860
#12 0x000055c782824a58 in mysql_execute_command (thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:3938
#13 0x000055c782831f2b in mysql_parse (thd=thd@entry=0x7f8207015088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f8234e7b450, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7957
#14 0x000055c78281dc45 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8207015088, packet=packet@entry=0x7f8207067089 "", packet_length=packet_length@entry=27, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1839
#15 0x000055c78281c49b in do_command (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:1358
#16 0x000055c782977415 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7f8212fc53a8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1422
#17 0x000055c782977744 in handle_one_connection (arg=arg@entry=0x7f8212fc53a8) at /test/10.5_dbg/sql/sql_connect.cc:1319
#18 0x000055c782dd7fb0 in pfs_spawn_thread (arg=0x7f8232845b08) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
#19 0x00007f82342a36db in start_thread (arg=0x7f8234e7c700) at pthread_create.c:463
#20 0x00007f82336a188f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
{noformat}

Bug confirmed present in:
MariaDB: 10.1.45 (dbg), 10.2.32 (dbg), 10.3.23 (dbg), 10.4.13 (dbg), 10.5.2 (dbg), 10.5.3 (dbg)

Bug confirmed not present in:
MariaDB: 10.1.45 (opt), 10.2.32 (opt), 10.3.23 (opt), 10.4.13 (opt), 10.5.2 (opt), 10.5.3 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

{noformat}
SET max_session_mem_used = 50000;
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash'; # Crashes
help 'it is going to crash';
{noformat}

Leads to:

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
mysqld: /test/10.5_dbg/sql/sql_error.cc:375: void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.
{noformat}

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
Core was generated by `/test/MD210420-mariadb-10.5.3-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
[Current thread is 1 (Thread 0x7f8234e7c700 (LWP 561173))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1 0x000055c78332903d in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
#2 0x000055c782aced7b in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:329
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007f82335c0801 in __GI_abort () at abort.c:79
#6 0x00007f82335b039a in __assert_fail_base (fmt=0x7f82337377d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:92
#7 0x00007f82335b0412 in __GI___assert_fail (assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:101
#8 0x000055c7827da737 in Diagnostics_area::set_eof_status (this=0x7f820701ab88, thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_error.cc:375
#9 0x000055c782c9bc95 in my_eof (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_class.h:5166
#10 mysqld_help_internal (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:844
#11 0x000055c782c9c1bb in mysqld_help (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:860
#12 0x000055c782824a58 in mysql_execute_command (thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:3938
#13 0x000055c782831f2b in mysql_parse (thd=thd@entry=0x7f8207015088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f8234e7b450, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7957
#14 0x000055c78281dc45 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8207015088, packet=packet@entry=0x7f8207067089 "", packet_length=packet_length@entry=27, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1839
#15 0x000055c78281c49b in do_command (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:1358
#16 0x000055c782977415 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7f8212fc53a8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1422
#17 0x000055c782977744 in handle_one_connection (arg=arg@entry=0x7f8212fc53a8) at /test/10.5_dbg/sql/sql_connect.cc:1319
#18 0x000055c782dd7fb0 in pfs_spawn_thread (arg=0x7f8232845b08) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
#19 0x00007f82342a36db in start_thread (arg=0x7f8234e7c700) at pthread_create.c:463
#20 0x00007f82336a188f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
{noformat}

Bug confirmed present in:
MariaDB: 10.1.45 (dbg), 10.2.32 (dbg), 10.3.23 (dbg), 10.4.13 (dbg), 10.5.2 (dbg), 10.5.3 (dbg)

Bug confirmed not present in:
MariaDB: 10.1.45 (opt), 10.2.32 (opt), 10.3.23 (opt), 10.4.13 (opt), 10.5.2 (opt), 10.5.3 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

Roel Van de Paar made changes - 2020-04-30 05:30

Description

{noformat}
SET max_session_mem_used = 50000;
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash'; # Crashes
help 'it is going to crash';
{noformat}

Leads to:

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
mysqld: /test/10.5_dbg/sql/sql_error.cc:375: void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.
{noformat}

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
Core was generated by `/test/MD210420-mariadb-10.5.3-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
[Current thread is 1 (Thread 0x7f8234e7c700 (LWP 561173))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1 0x000055c78332903d in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
#2 0x000055c782aced7b in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:329
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007f82335c0801 in __GI_abort () at abort.c:79
#6 0x00007f82335b039a in __assert_fail_base (fmt=0x7f82337377d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:92
#7 0x00007f82335b0412 in __GI___assert_fail (assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:101
#8 0x000055c7827da737 in Diagnostics_area::set_eof_status (this=0x7f820701ab88, thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_error.cc:375
#9 0x000055c782c9bc95 in my_eof (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_class.h:5166
#10 mysqld_help_internal (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:844
#11 0x000055c782c9c1bb in mysqld_help (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:860
#12 0x000055c782824a58 in mysql_execute_command (thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:3938
#13 0x000055c782831f2b in mysql_parse (thd=thd@entry=0x7f8207015088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f8234e7b450, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7957
#14 0x000055c78281dc45 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8207015088, packet=packet@entry=0x7f8207067089 "", packet_length=packet_length@entry=27, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1839
#15 0x000055c78281c49b in do_command (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:1358
#16 0x000055c782977415 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7f8212fc53a8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1422
#17 0x000055c782977744 in handle_one_connection (arg=arg@entry=0x7f8212fc53a8) at /test/10.5_dbg/sql/sql_connect.cc:1319
#18 0x000055c782dd7fb0 in pfs_spawn_thread (arg=0x7f8232845b08) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
#19 0x00007f82342a36db in start_thread (arg=0x7f8234e7c700) at pthread_create.c:463
#20 0x00007f82336a188f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
{noformat}

Bug confirmed present in:
MariaDB: 10.1.45 (dbg), 10.2.32 (dbg), 10.3.23 (dbg), 10.4.13 (dbg), 10.5.2 (dbg), 10.5.3 (dbg)

Bug confirmed not present in:
MariaDB: 10.1.45 (opt), 10.2.32 (opt), 10.3.23 (opt), 10.4.13 (opt), 10.5.2 (opt), 10.5.3 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

{noformat}
SET max_session_mem_used = 50000;
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash';
help 'it is going to crash'; # Crashes
help 'it crashed';
{noformat}

Leads to:

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
mysqld: /test/10.5_dbg/sql/sql_error.cc:375: void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.
{noformat}

{noformat:title=10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f}
Core was generated by `/test/MD210420-mariadb-10.5.3-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
[Current thread is 1 (Thread 0x7f8234e7c700 (LWP 561173))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1 0x000055c78332903d in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
#2 0x000055c782aced7b in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:329
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007f82335c0801 in __GI_abort () at abort.c:79
#6 0x00007f82335b039a in __assert_fail_base (fmt=0x7f82337377d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:92
#7 0x00007f82335b0412 in __GI___assert_fail (assertion=assertion@entry=0x55c7834972cd "! is_set()", file=file@entry=0x55c783497140 "/test/10.5_dbg/sql/sql_error.cc", line=line@entry=375, function=function@entry=0x55c783497c80 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:101
#8 0x000055c7827da737 in Diagnostics_area::set_eof_status (this=0x7f820701ab88, thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_error.cc:375
#9 0x000055c782c9bc95 in my_eof (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_class.h:5166
#10 mysqld_help_internal (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:844
#11 0x000055c782c9c1bb in mysqld_help (thd=thd@entry=0x7f8207015088, mask=<optimized out>) at /test/10.5_dbg/sql/sql_help.cc:860
#12 0x000055c782824a58 in mysql_execute_command (thd=thd@entry=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:3938
#13 0x000055c782831f2b in mysql_parse (thd=thd@entry=0x7f8207015088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f8234e7b450, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7957
#14 0x000055c78281dc45 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8207015088, packet=packet@entry=0x7f8207067089 "", packet_length=packet_length@entry=27, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1839
#15 0x000055c78281c49b in do_command (thd=0x7f8207015088) at /test/10.5_dbg/sql/sql_parse.cc:1358
#16 0x000055c782977415 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7f8212fc53a8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1422
#17 0x000055c782977744 in handle_one_connection (arg=arg@entry=0x7f8212fc53a8) at /test/10.5_dbg/sql/sql_connect.cc:1319
#18 0x000055c782dd7fb0 in pfs_spawn_thread (arg=0x7f8232845b08) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
#19 0x00007f82342a36db in start_thread (arg=0x7f8234e7c700) at pthread_create.c:463
#20 0x00007f82336a188f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
{noformat}

Bug confirmed present in:
MariaDB: 10.1.45 (dbg), 10.2.32 (dbg), 10.3.23 (dbg), 10.4.13 (dbg), 10.5.2 (dbg), 10.5.3 (dbg)

Bug confirmed not present in:
MariaDB: 10.1.45 (opt), 10.2.32 (opt), 10.3.23 (opt), 10.4.13 (opt), 10.5.2 (opt), 10.5.3 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

Roel Van de Paar made changes - 2020-05-21 23:42

Labels

affects-tests

Oleksandr Byelkin made changes - 2020-07-20 13:31

Assignee

Oleksandr Byelkin [ sanja ]

Rucha Deodhar [ rucha174 ]

Rucha Deodhar made changes - 2020-09-01 11:34

Status

Open [ 1 ]

In Progress [ 3 ]

Rucha Deodhar made changes - 2020-09-22 11:52

Assignee	Rucha Deodhar [ rucha174 ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2020-10-21 17:56

Assignee	Sergei Golubchik [ serg ]	Rucha Deodhar [ rucha174 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Roel Van de Paar made changes - 2020-11-03 04:51

Link

This issue relates to ~~MDEV-22708~~ [ ~~MDEV-22708~~ ]

Roel Van de Paar made changes - 2020-11-03 05:14

Affects Version/s

10.6 [ 24028 ]

Roel Van de Paar made changes - 2020-11-03 05:14

Fix Version/s		10.6 [ 24028 ]
Fix Version/s	10.1 [ 16100 ]

Roel Van de Paar made changes - 2020-11-03 08:03

Comment

[ Great. When will it be pushed? ]

Sergei Golubchik made changes - 2020-11-10 13:53

Fix Version/s

10.6 [ 24028 ]

Rucha Deodhar made changes - 2020-12-15 07:35

Fix Version/s		10.2.37 [ 25112 ]
Fix Version/s		10.3.28 [ 25111 ]
Fix Version/s		10.4.18 [ 25110 ]
Fix Version/s		10.5.9 [ 25109 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Roel Van de Paar made changes - 2021-05-20 00:08

Link

This issue relates to MDEV-25735 [ MDEV-25735 ]

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

Workflow

MariaDB v3 [ 108004 ]

MariaDB v4 [ 157699 ]

People

Assignee:: Rucha Deodhar

Reporter:: Roel Van de Paar

Votes:: 1 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2020-04-30 05:19

Updated:: 2021-05-20 00:08

Resolved:: 2020-12-15 07:35

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration