Bug #76467 | Assertion `strlen(db) <= (64*3) && strlen(name) <= (64*3)' failed. DROP FUNCTION | ||
---|---|---|---|
Submitted: | 23 Mar 2015 23:26 | Modified: | 24 Mar 2015 8:00 |
Reporter: | Roel Van de Paar | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S1 (Critical) |
Version: | 5.6.22, 5.6.23, 5.6.25 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[23 Mar 2015 23:26]
Roel Van de Paar
[24 Mar 2015 8:00]
MySQL Verification Team
Hello Roel, Thank you for the report. Confirmed that only debug builds of 5.6(5.6.23, 5.6.25) are affected. Thanks, Umesh
[24 Mar 2015 8:01]
MySQL Verification Team
// 5.6.25 scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76467 bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76467 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.6.25/76467/log.err 2>&1 & - build commit: 7f58410b3f11eddb38ff8c57a7a58095f7db2910 date: 2015-03-23 14:34:22 +0530 build-date: 2015-03-23 10:21:42 +0100 short: 7f58410 branch: mysql-5.6 MySQL source 5.6.25 (gdb) bt #0 0x00007f389a195771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae1373 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/mysys/stacktrace.c:422 #2 0x0000000000745fca in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f3898d9b5c9 in raise () from /lib64/libc.so.6 #5 0x00007f3898d9ccd8 in abort () from /lib64/libc.so.6 #6 0x00007f3898d94536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f3898d945e2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000736562 in MDL_key::mdl_key_init (this=0x7f386fa4a840, mdl_namespace=MDL_key::FUNCTION, db=0x7f383c0052b0 "test", name=0x7f383c0051e8 "f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjjjjjjjkk") at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/mdl.h:343 #9 0x000000000073361b in MDL_request::init (this=0x7f386fa4a820, mdl_namespace=MDL_key::FUNCTION, db_arg=0x7f383c0052b0 "test", name_arg=0x7f383c0051e8 "f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjjjjjjjkk", mdl_type_arg=MDL_EXCLUSIVE, mdl_duration_arg=MDL_TRANSACTION) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/mdl.cc:1136 #10 0x000000000096ca34 in lock_object_name (thd=0x2281720, mdl_type=MDL_key::FUNCTION, db=0x7f383c0052b0 "test", name=0x7f383c0051e8 "f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjjjjjjjkk") at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/lock.cc:853 #11 0x00000000007487d3 in sp_drop_routine (thd=0x2281720, type=SP_TYPE_FUNCTION, name=0x7f383c0052b8) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sp.cc:1285 #12 0x0000000000800cf5 in mysql_execute_command (thd=0x2281720) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:4717 #13 0x000000000080229a in mysql_parse (thd=0x2281720, rawbuf=0x7f383c004fd0 "drop function f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjj"..., length=207, parser_state=0x7f386fa4c700) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:6391 #14 0x0000000000803ebe in dispatch_command (command=COM_QUERY, thd=0x2281720, packet=0x23b3521 "drop function f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjj"..., packet_length=207) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1340 #15 0x0000000000805748 in do_command (thd=0x2281720) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1037 #16 0x00000000007bb291 in do_handle_one_connection (thd_arg=0x2281720) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_connect.cc:982 #17 0x00000000007bb357 in handle_one_connection (arg=0x2281720) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_connect.cc:898 #18 0x0000000000b92d9c in pfs_spawn_thread (arg=0x232ada0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/perfschema/pfs.cc:1860 #19 0x00007f389a190df3 in start_thread () from /lib64/libpthread.so.0 #20 0x00007f3898e5c47d in clone () from /lib64/libc.so.6 (gdb)
[24 Mar 2015 8:01]
MySQL Verification Team
// 5.6.23 scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/76467 bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/76467 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.6.23/76467/log.err 2>&1 & - commit: 19ff9770da1307a8b44be40beaa456c4d1149c2a date: 2015-01-19 14:26:20 +0100 build-date: 2015-01-19 14:38:00 +0100 short: 19ff977 branch: mysql-5.6.23-release MySQL source 5.6.23 (gdb) bt #0 0x00007fe2ccb44771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000aacb93 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/mysys/stacktrace.c:422 #2 0x000000000071513e in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007fe2cb74a5c9 in raise () from /lib64/libc.so.6 #5 0x00007fe2cb74bcd8 in abort () from /lib64/libc.so.6 #6 0x00007fe2cb743536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fe2cb7435e2 in __assert_fail () from /lib64/libc.so.6 #8 0x00000000007056d6 in MDL_key::mdl_key_init (this=0x7fe2a250b880, mdl_namespace=MDL_key::FUNCTION, db=0x7fe2780052b0 "test", name=0x7fe2780051e8 "f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjjjjjjjkk") at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/mdl.h:343 #9 0x000000000070279f in MDL_request::init (this=0x7fe2a250b860, mdl_namespace=MDL_key::FUNCTION, db_arg=0x7fe2780052b0 "test", name_arg=0x7fe2780051e8 "f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjjjjjjjkk", mdl_type_arg=MDL_EXCLUSIVE, mdl_duration_arg=MDL_TRANSACTION) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/mdl.cc:1136 #10 0x0000000000939a34 in lock_object_name (thd=0x33fc1d0, mdl_type=MDL_key::FUNCTION, db=0x7fe2780052b0 "test", name=0x7fe2780051e8 "f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjjjjjjjkk") at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/lock.cc:853 #11 0x0000000000717949 in sp_drop_routine (thd=0x33fc1d0, type=SP_TYPE_FUNCTION, name=0x7fe2780052b8) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sp.cc:1282 #12 0x00000000007ced8e in mysql_execute_command (thd=0x33fc1d0) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:4681 #13 0x00000000007d0349 in mysql_parse (thd=0x33fc1d0, rawbuf=0x7fe278004fd0 "drop function f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjj"..., length=207, parser_state=0x7fe2a250d700) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:6357 #14 0x00000000007d1ef3 in dispatch_command (command=COM_QUERY, thd=0x33fc1d0, packet=0x3bd64b1 "drop function f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjj"..., packet_length=207) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:1332 #15 0x00000000007d372d in do_command (thd=0x33fc1d0) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:1034 #16 0x0000000000789521 in do_handle_one_connection (thd_arg=0x33fc1d0) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_connect.cc:982 #17 0x00000000007895e7 in handle_one_connection (arg=0x33fc1d0) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_connect.cc:898 #18 0x0000000000d7a866 in pfs_spawn_thread (arg=0x3bb8260) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/storage/perfschema/pfs.cc:1860 #19 0x00007fe2ccb3fdf3 in start_thread () from /lib64/libpthread.so.0 #20 0x00007fe2cb80b47d in clone () from /lib64/libc.so.6 (gdb)
[24 Mar 2015 8:03]
MySQL Verification Team
// 5.7.8 - not affected(release/debug build complain and doesn't crash) ERROR 1059 (42000): Identifier name 'f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaa' is too long mysql> \q // 5.5.44 - not affected ERROR 1305 (42000): FUNCTION test.f111111111122222222223333333333444444444455555555556666666666777777777788888888889999999999aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeffffffffffgggggggggghhhhhhhhhhiiiiiiiiiijjjjjjjjjjkk does not exist