Description:
Core was generated by `/sda/MS020217-mysql-5.6.35-linux-x86_64-debug/bin/mysqld --no-defaults --core -'.
Program terminated with signal 6, Aborted.
#0 0x00007f7b6e0ff741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007f7b6e0ff741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000a9cf79 in my_write_core (sig=6) at /git/MS-5.6.35_dbg/mysys/stacktrace.c:424
#2 0x000000000072c620 in handle_fatal_signal (sig=6) at /git/MS-5.6.35_dbg/sql/signal_handler.cc:230
#3 <signal handler called>
#4 0x00007f7b6c69b1d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f7b6c69c8c8 in __GI_abort () at abort.c:90
#6 0x00007f7b6c694146 in __assert_fail_base (fmt=0x7f7b6c7e53a8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xe8a646 "! thd->in_sub_stmt",
file=file@entry=0xe89e28 "/git/MS-5.6.35_dbg/sql/sql_parse.cc", line=line@entry=2575,
function=function@entry=0xe8b9a0 <mysql_execute_command(THD*)::__PRETTY_FUNCTION__> "int mysql_execute_command(THD*)") at assert.c:92
#7 0x00007f7b6c6941f2 in __GI___assert_fail (assertion=0xe8a646 "! thd->in_sub_stmt", file=0xe89e28 "/git/MS-5.6.35_dbg/sql/sql_parse.cc", line=2575,
function=0xe8b9a0 <mysql_execute_command(THD*)::__PRETTY_FUNCTION__> "int mysql_execute_command(THD*)") at assert.c:101
#8 0x00000000007d8e1e in mysql_execute_command (thd=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:2575
#9 0x000000000098294c in sp_instr_stmt::exec_core (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38) at /git/MS-5.6.35_dbg/sql/sp_instr.cc:920
#10 0x0000000000981780 in sp_lex_instr::reset_lex_and_exec_core (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38, open_tables=false)
at /git/MS-5.6.35_dbg/sql/sp_instr.cc:399
#11 0x00000000009820bc in sp_lex_instr::validate_lex_and_execute_core (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38, open_tables=false)
at /git/MS-5.6.35_dbg/sql/sp_instr.cc:650
#12 0x00000000009825e0 in sp_instr_stmt::execute (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38) at /git/MS-5.6.35_dbg/sql/sp_instr.cc:827
#13 0x00000000007352c8 in sp_head::execute (this=0x7f7b3955e010, thd=0x7f7b45b87000, merge_da_on_success=false) at /git/MS-5.6.35_dbg/sql/sp_head.cc:648
#14 0x0000000000735ccf in sp_head::execute_trigger (this=0x7f7b3955e010, thd=0x7f7b45b87000, db_name=0x7f7b394985b0, table_name=0x7f7b394985c0, grant_info=0x7f7b6a823b68)
at /git/MS-5.6.35_dbg/sql/sp_head.cc:895
#15 0x000000000086099f in Table_triggers_list::process_triggers (this=0x7f7b6a823a10, thd=0x7f7b45b87000, event=TRG_EVENT_UPDATE, time_type=TRG_ACTION_AFTER,
old_row_is_record1=true) at /git/MS-5.6.35_dbg/sql/sql_trigger.cc:2181
#16 0x000000000086938e in mysql_update (thd=0x7f7b45b87000, table_list=0x7f7b3941f0e8, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551615,
handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f7b6e6f1118, updated_return=0x7f7b6e6f1110) at /git/MS-5.6.35_dbg/sql/sql_update.cc:853
#17 0x00000000007dad1f in mysql_execute_command (thd=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:3361
#18 0x00000000007e2ff8 in mysql_parse (thd=0x7f7b45b87000, rawbuf=0x7f7b3941f010 "UPDATE t1 SET a=2", length=17, parser_state=0x7f7b6e6f1590)
at /git/MS-5.6.35_dbg/sql/sql_parse.cc:6433
#19 0x00000000007d6110 in dispatch_command (command=COM_QUERY, thd=0x7f7b45b87000, packet=0x7f7b45b6b001 "UPDATE t1 SET a=2", packet_length=17)
at /git/MS-5.6.35_dbg/sql/sql_parse.cc:1372
#20 0x00000000007d50d4 in do_command (thd=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:1039
#21 0x000000000079ca7c in do_handle_one_connection (thd_arg=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_connect.cc:982
#22 0x000000000079c7ec in handle_one_connection (arg=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_connect.cc:899
#23 0x0000000000ae9335 in pfs_spawn_thread (arg=0x7f7b6abf46a0) at /git/MS-5.6.35_dbg/storage/perfschema/pfs.cc:1860
#24 0x00007f7b6e0fadc5 in start_thread (arg=0x7f7b6e6f2700) at pthread_create.c:308
#25 0x00007f7b6c75d73d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1( a NATIONAL VARCHAR(16386)) ROW_FORMAT = COMPACT ENGINE=InnoDB;
CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW ALTER USER 'u1'@'localhost' PASSWORD EXPIRE;
INSERT INTO t1 VALUES (CONVERT(_ucs2 0x062A064806270646 USING utf8));
UPDATE t1 SET a=2;
Description: Core was generated by `/sda/MS020217-mysql-5.6.35-linux-x86_64-debug/bin/mysqld --no-defaults --core -'. Program terminated with signal 6, Aborted. #0 0x00007f7b6e0ff741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid), (gdb) bt #0 0x00007f7b6e0ff741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x0000000000a9cf79 in my_write_core (sig=6) at /git/MS-5.6.35_dbg/mysys/stacktrace.c:424 #2 0x000000000072c620 in handle_fatal_signal (sig=6) at /git/MS-5.6.35_dbg/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f7b6c69b1d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007f7b6c69c8c8 in __GI_abort () at abort.c:90 #6 0x00007f7b6c694146 in __assert_fail_base (fmt=0x7f7b6c7e53a8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xe8a646 "! thd->in_sub_stmt", file=file@entry=0xe89e28 "/git/MS-5.6.35_dbg/sql/sql_parse.cc", line=line@entry=2575, function=function@entry=0xe8b9a0 <mysql_execute_command(THD*)::__PRETTY_FUNCTION__> "int mysql_execute_command(THD*)") at assert.c:92 #7 0x00007f7b6c6941f2 in __GI___assert_fail (assertion=0xe8a646 "! thd->in_sub_stmt", file=0xe89e28 "/git/MS-5.6.35_dbg/sql/sql_parse.cc", line=2575, function=0xe8b9a0 <mysql_execute_command(THD*)::__PRETTY_FUNCTION__> "int mysql_execute_command(THD*)") at assert.c:101 #8 0x00000000007d8e1e in mysql_execute_command (thd=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:2575 #9 0x000000000098294c in sp_instr_stmt::exec_core (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38) at /git/MS-5.6.35_dbg/sql/sp_instr.cc:920 #10 0x0000000000981780 in sp_lex_instr::reset_lex_and_exec_core (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38, open_tables=false) at /git/MS-5.6.35_dbg/sql/sp_instr.cc:399 #11 0x00000000009820bc in sp_lex_instr::validate_lex_and_execute_core (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38, open_tables=false) at /git/MS-5.6.35_dbg/sql/sp_instr.cc:650 #12 0x00000000009825e0 in sp_instr_stmt::execute (this=0x7f7b3955fa90, thd=0x7f7b45b87000, nextp=0x7f7b6e6efc38) at /git/MS-5.6.35_dbg/sql/sp_instr.cc:827 #13 0x00000000007352c8 in sp_head::execute (this=0x7f7b3955e010, thd=0x7f7b45b87000, merge_da_on_success=false) at /git/MS-5.6.35_dbg/sql/sp_head.cc:648 #14 0x0000000000735ccf in sp_head::execute_trigger (this=0x7f7b3955e010, thd=0x7f7b45b87000, db_name=0x7f7b394985b0, table_name=0x7f7b394985c0, grant_info=0x7f7b6a823b68) at /git/MS-5.6.35_dbg/sql/sp_head.cc:895 #15 0x000000000086099f in Table_triggers_list::process_triggers (this=0x7f7b6a823a10, thd=0x7f7b45b87000, event=TRG_EVENT_UPDATE, time_type=TRG_ACTION_AFTER, old_row_is_record1=true) at /git/MS-5.6.35_dbg/sql/sql_trigger.cc:2181 #16 0x000000000086938e in mysql_update (thd=0x7f7b45b87000, table_list=0x7f7b3941f0e8, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f7b6e6f1118, updated_return=0x7f7b6e6f1110) at /git/MS-5.6.35_dbg/sql/sql_update.cc:853 #17 0x00000000007dad1f in mysql_execute_command (thd=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:3361 #18 0x00000000007e2ff8 in mysql_parse (thd=0x7f7b45b87000, rawbuf=0x7f7b3941f010 "UPDATE t1 SET a=2", length=17, parser_state=0x7f7b6e6f1590) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:6433 #19 0x00000000007d6110 in dispatch_command (command=COM_QUERY, thd=0x7f7b45b87000, packet=0x7f7b45b6b001 "UPDATE t1 SET a=2", packet_length=17) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:1372 #20 0x00000000007d50d4 in do_command (thd=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_parse.cc:1039 #21 0x000000000079ca7c in do_handle_one_connection (thd_arg=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_connect.cc:982 #22 0x000000000079c7ec in handle_one_connection (arg=0x7f7b45b87000) at /git/MS-5.6.35_dbg/sql/sql_connect.cc:899 #23 0x0000000000ae9335 in pfs_spawn_thread (arg=0x7f7b6abf46a0) at /git/MS-5.6.35_dbg/storage/perfschema/pfs.cc:1860 #24 0x00007f7b6e0fadc5 in start_thread (arg=0x7f7b6e6f2700) at pthread_create.c:308 #25 0x00007f7b6c75d73d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113 How to repeat: DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t1( a NATIONAL VARCHAR(16386)) ROW_FORMAT = COMPACT ENGINE=InnoDB; CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW ALTER USER 'u1'@'localhost' PASSWORD EXPIRE; INSERT INTO t1 VALUES (CONVERT(_ucs2 0x062A064806270646 USING utf8)); UPDATE t1 SET a=2;