MySQL Bugs: #74678: Assertion `host_length <= 60' failed in set_setup_actor

Bug #74678	Assertion `host_length <= 60' failed in set_setup_actor_key
Submitted:	4 Nov 2014 8:28	Modified:	4 Nov 2014 9:04
Reporter:	Ramesh Sivaraman	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S3 (Non-critical)
Version:	5.6.20-debug, 5.6.22, 5.7.6	OS:	Linux (CentOS 7)
Assigned to:		CPU Architecture:	Any

Description:
mysqld: /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs_setup_actor.cc:140: void set_setup_actor_key(PFS_setup_actor_key*, const char*, uint, co
nst char*, uint, const char*, uint): Assertion `host_length <= 60' failed.
06:20:42 UTC - mysqld got signal 6 ;

*** GDB info

#0  0x00007f2ad6f56771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a9035e in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000723688 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f2ad5d625c9 in raise () from /lib64/libc.so.6
#5  0x00007f2ad5d63cd8 in abort () from /lib64/libc.so.6
#6  0x00007f2ad5d5b536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f2ad5d5b5e2 in __assert_fail () from /lib64/libc.so.6
#8  0x0000000000ab47d8 in set_setup_actor_key (key=0x7f2ad3fef104, user=0x7f2a43babcc5 "m祳畳敲", ' ' <repeats 38 times>, "浹牯汥", ' ' <repeats 39 times>, user_length=22, host=0x7f2a43babc11 "浹桯獴", ' ' <repeats 171 times>, "m祳畳敲", ' ' <repeats 38 times>, "浹牯汥", ' ' <repeats 39 times>, host_length=66, role=0x7f2a43babcf5 "浹牯汥", ' ' <repeats 39 times>, role_length=22) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs_setup_actor.cc:140
#9  0x0000000000ab49e6 in insert_setup_actor (user=0x7f2ad754c760, host=0x7f2ad754c780, role=0x7f2ad754c7a0) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs_setup_actor.cc:189
#10 0x0000000000acb370 in table_setup_actors::write_row (table=0x7f2a43bb2c00, buf=0x7f2a43babc10 "\377浹桯獴", ' ' <repeats 171 times>, "m祳畳敲", ' ' <repeats 38 times>, "浹牯汥", ' ' <repeats 39 times>, fields=0x7f2a43baba78) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/table_setup_actors.cc:111
#11 0x0000000000aa664b in PFS_engine_table_share::write_row (this=0x1510240 <table_setup_actors::m_share>, table=0x7f2a43bb2c00, buf=0x7f2a43babc10 "\377
浹桯獴", ' ' <repeats 171 times>, "m祳畳敲", ' ' <repeats 38 times>, "浹牯汥", ' ' <repeats 39 times>, fields=0x7f2a43baba60) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs_engine_table.cc:287
#12 0x0000000000aa1ee8 in ha_perfschema::write_row (this=0x7f2a43bab810, buf=0x7f2a43babc10 "\377浹桯獴", ' ' <repeats 171 times>, "m祳畳敲", ' ' <repeats 38 times>, "浹牯汥", ' ' <repeats 39 times>) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/ha_perfschema.cc:248
#13 0x0000000000641f86 in handler::ha_write_row (this=0x7f2a43bab810, buf=0x7f2a43babc10 "\377浹桯獴", ' ' <repeats 171 times>, "m祳畳敲", ' ' <repeats 38 times>, "浹牯汥", ' ' <repeats 39 times>) at /ssd/ramesh/mysql-server/mysql-5.6/sql/handler.cc:7273
#14 0x00000000007b14e8 in write_record (thd=0x7f2a43b24000, table=0x7f2a43bb2c00, info=0x7f2ad754cb00, update=0x7f2ad754cb80) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_insert.cc:1921
#15 0x00000000007af379 in mysql_insert (thd=0x7f2a43b24000, table_list=0x7f2a39c1f190, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_insert.cc:1072
#16 0x00000000007d159f in mysql_execute_command (thd=0x7f2a43b24000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:3443
#17 0x00000000007d8fa4 in mysql_parse (thd=0x7f2a43b24000, rawbuf=0x7f2a39c1f010 "insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole')", length=82, parser_state=0x7f2ad754de70) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:6245
#18 0x00000000007cc557 in dispatch_command (command=COM_QUERY, thd=0x7f2a43b24000, packet=0x7f2a43b62001 "insert into performance_schema.setup_actors values ('myhost', 'mysuser', 'myrole')", packet_length=82) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1332
#19 0x00000000007cb646 in do_command (thd=0x7f2a43b24000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_parse.cc:1034
#20 0x0000000000793a61 in do_handle_one_connection (thd_arg=0x7f2a43b24000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:982
#21 0x000000000079354a in handle_one_connection (arg=0x7f2a43b24000) at /ssd/ramesh/mysql-server/mysql-5.6/sql/sql_connect.cc:898
#22 0x0000000000ad4b5c in pfs_spawn_thread (arg=0x7f2ad33feb00) at /ssd/ramesh/mysql-server/mysql-5.6/storage/perfschema/pfs.cc:1860
#23 0x00007f2ad6f51df3 in start_thread () from /lib64/libpthread.so.0
#24 0x00007f2ad5e2301d in clone () from /lib64/libc.so.6

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
set names binary;
set @@collation_connection=utf16_czech_ci;
set @@sql_mode=cast(pow(2,32)-1 as unsigned INT);
insert into performance_schema.setup_actors values('myhost','mysuser','myrole');

Hello Ramesh Sivaraman,

Thank you for the bug report and test case.
Confirmed the issue with debug build of 5.6.22/5.76.

Thanks,
Umesh

// 5.6.22 debug build

(gdb) bt
#0  0x0000003deb00c8ac in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000b0011b in my_write_core (sig=6) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/mysys/stacktrace.c:422
#2  0x000000000077ecb8 in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x0000003deac32625 in raise () from /lib64/libc.so.6
#5  0x0000003deac33e05 in abort () from /lib64/libc.so.6
#6  0x0000003deac2b74e in __assert_fail_base () from /lib64/libc.so.6
#7  0x0000003deac2b810 in __assert_fail () from /lib64/libc.so.6
#8  0x0000000000e44133 in set_setup_actor_key (key=0x29e2944, user=0x31d2bb5 "m???", ' ' <repeats 38 times>, "???", ' ' <repeats 39 times>, user_length=22,
    host=0x31d2b01 "???", ' ' <repeats 171 times>, "m???          "..., host_length=66, role=0x31d2be5 "???", ' ' <repeats 39 times>, role_length=22)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/pfs_setup_actor.cc:140
#9  0x0000000000e44340 in insert_setup_actor (user=0x7f6e2c791a60, host=0x7f6e2c791a40, role=0x7f6e2c791a20)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/pfs_setup_actor.cc:189
#10 0x0000000000e5b1d4 in table_setup_actors::write_row (table=0x31d1e20, buf=0x31d2b00 "\377???", ' ' <repeats 171 times>, "m???         "..., fields=0x31d2978)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/table_setup_actors.cc:111
#11 0x0000000000e35c63 in PFS_engine_table_share::write_row (this=0x16a1840, table=0x31d1e20, buf=0x31d2b00 "\377???", ' ' <repeats 171 times>, "m???         "..., fields=0x31d2960)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/pfs_engine_table.cc:287
#12 0x0000000000e316f2 in ha_perfschema::write_row (this=0x31d2710, buf=0x31d2b00 "\377???", ' ' <repeats 171 times>, "m???         "...)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/ha_perfschema.cc:248
#13 0x0000000000699b8b in handler::ha_write_row (this=0x31d2710, buf=0x31d2b00 "\377???", ' ' <repeats 171 times>, "m???         "...)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/handler.cc:7273
#14 0x000000000080f414 in write_record (thd=0x312ebf0, table=0x31d1e20, info=0x7f6e2c791e80, update=0x7f6e2c791e00)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_insert.cc:1921
#15 0x000000000080d21b in mysql_insert (thd=0x312ebf0, table_list=0x7f6e00005148, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false)
    at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_insert.cc:1072
#16 0x000000000082fe71 in mysql_execute_command (thd=0x312ebf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:3443
#17 0x00000000008380e1 in mysql_parse (thd=0x312ebf0, rawbuf=0x7f6e00004fd0 "insert into performance_schema.setup_actors values('myhost','mysuser','myrole')", length=79,
    parser_state=0x7f6e2c793680) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:6357
#18 0x000000000082aa63 in dispatch_command (command=COM_QUERY, thd=0x312ebf0, packet=0x325e541 "insert into performance_schema.setup_actors values('myhost','mysuser','myrole')",
    packet_length=79) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1332
#19 0x0000000000829ac8 in do_command (thd=0x312ebf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_parse.cc:1034
#20 0x00000000007f0f17 in do_handle_one_connection (thd_arg=0x312ebf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:982
#21 0x00000000007f09e8 in handle_one_connection (arg=0x312ebf0) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/sql/sql_connect.cc:898
#22 0x0000000000e64c25 in pfs_spawn_thread (arg=0x3221c70) at /pb2/build/sb_0-13562263-1414689457.82/mysqlcom-pro-5.6.22/storage/perfschema/pfs.cc:1860
#23 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#24 0x0000003deace89dd in clone () from /lib64/libc.so.6

// 5.7.6 debug build

(gdb) bt
#0  0x0000003deb00c8ac in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000f990a1 in my_write_core (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247
#2  0x000000000092d7cc in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x0000003deac32625 in raise () from /lib64/libc.so.6
#5  0x0000003deac33e05 in abort () from /lib64/libc.so.6
#6  0x0000003deac2b74e in __assert_fail_base () from /lib64/libc.so.6
#7  0x0000003deac2b810 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000013a56e9 in set_setup_actor_key (key=0x3a6c844, user=0x4713e75 "m???", ' ' <repeats 38 times>, "???", ' ' <repeats 39 times>, user_length=22,
    host=0x4713dc1 "???", ' ' <repeats 171 times>, "m???          "..., host_length=66, role=0x4713ea5 "???", ' ' <repeats 39 times>, role_length=22)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs_setup_actor.cc:141
#9  0x00000000013a592d in insert_setup_actor (user=0x7fc16e1d08b0, host=0x7fc16e1d0890, role=0x7fc16e1d0870)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs_setup_actor.cc:190
#10 0x00000000013c653b in table_setup_actors::write_row (table=0x4713020, buf=0x4713dc0 "\377???", ' ' <repeats 171 times>, "m???         "..., fields=0x4713c80)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/table_setup_actors.cc:110
#11 0x0000000001392a35 in PFS_engine_table_share::write_row (this=0x2053a40, table=0x4713020, buf=0x4713dc0 "\377???", ' ' <repeats 171 times>, "m???         "..., fields=0x4713c68)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs_engine_table.cc:342
#12 0x00000000013806e4 in ha_perfschema::write_row (this=0x47139c0, buf=0x4713dc0 "\377???", ' ' <repeats 171 times>, "m???         "...)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/ha_perfschema.cc:254
#13 0x000000000099f380 in handler::ha_write_row (this=0x47139c0, buf=0x4713dc0 "\377???", ' ' <repeats 171 times>, "m???         "...)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.cc:7443
#14 0x0000000000e92911 in write_record (thd=0x7fc12c000cf0, table=0x4713020, info=0x7fc16e1d0ca0, update=0x7fc16e1d0c20)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:1680
#15 0x0000000000e901a1 in mysql_insert (thd=0x7fc12c000cf0, table_list=0x7fc12c005e10, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR)
    at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:708
#16 0x0000000000cb6855 in mysql_execute_command (thd=0x7fc12c000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:3338
#17 0x0000000000cbce6a in mysql_parse (thd=0x7fc12c000cf0, parser_state=0x7fc16e1d2660) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5397
#18 0x0000000000cb0f2c in dispatch_command (command=COM_QUERY, thd=0x7fc12c000cf0, packet=0x7fc12c009a21 "insert into performance_schema.setup_actors values('myhost','mysuser','myrole')",
    packet_length=79) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#19 0x0000000000cafbd4 in do_command (thd=0x7fc12c000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#20 0x0000000000dbe89c in handle_connection (arg=0x48d3600) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#21 0x000000000138347f in pfs_spawn_thread (arg=0x4729c10) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#22 0x0000003deb0079d1 in start_thread () from /lib64/libpthread.so.0
#23 0x0000003deace89dd in clone () from /lib64/libc.so.6