Bug #76468 | void Item_row::illegal_method_call(const char*): Assertion `0' failed. | ||
---|---|---|---|
Submitted: | 24 Mar 2015 0:06 | Modified: | 25 Mar 2015 5:09 |
Reporter: | Roel Van de Paar | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S1 (Critical) |
Version: | 5.6.22, 5.5.44, 5.6.23, 5.6.25 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[24 Mar 2015 0:06]
Roel Van de Paar
[24 Mar 2015 7:50]
MySQL Verification Team
see my second testcase on: Bug 11764690 - SOME FUNCTIONS CAUSE ASSERTION WHEN GIVEN A ROW CONSTRUCTOR ARGUMENT
[25 Mar 2015 4:57]
MySQL Verification Team
Hello Roel, Thank you for the report and test case. Observed that 5.5.44, 5.6.23/5.6.25 debug builds are affected. 5.7.8, 5.8.0 builds are not affected. Thanks, Umesh
[25 Mar 2015 4:57]
MySQL Verification Team
// 5.5.44 scripts/mysql_install_db --basedir=/export/umesh/mysql-5.5.44 --datadir=/export/umesh/mysql-5.5.44/76468 bin/mysqld-debug --basedir=/export/umesh/mysql-5.5.44 --datadir=/export/umesh/mysql-5.5.44/76468 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.5.44/76468/log.err 2>&1 & - build commit: 68dccc24bf6075d73c2aea854c7c74dfa11c062d date: 2015-03-19 12:50:16 +0100 build-date: 2015-03-19 23:45:48 +0100 short: 68dccc2 branch: mysql-5.5 MySQL source 5.5.44 (gdb) bt #0 0x00007f19be8a4771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000007ec0d6 in my_write_core (sig=6) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/mysys/stacktrace.c:433 #2 0x00000000006a4704 in handle_fatal_signal (sig=6) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/signal_handler.cc:247 #3 <signal handler called> #4 0x00007f19bd9c75c9 in raise () from /lib64/libc.so.6 #5 0x00007f19bd9c8cd8 in abort () from /lib64/libc.so.6 #6 0x00007f19bd9c0536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f19bd9c05e2 in __assert_fail () from /lib64/libc.so.6 #8 0x000000000070759e in Item_row::illegal_method_call (this=<optimized out>, method=0xae75ec "val_str") at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/item_row.cc:63 #9 0x000000000070793e in Item_row::val_str (this=0x7d6e) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/item_row.h:57 #10 0x00000000006cd33c in Item_func_like::fix_fields (this=0x7f19a0004fa0, thd=0x1b7aac0, ref=<optimized out>) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/item_cmpfunc.cc:4821 #11 0x0000000000543c79 in setup_fields (thd=0x1b7aac0, ref_pointer_array=0x7f19a0006980, fields=..., mark_used_columns=<optimized out>, sum_func_list=0x7f19a00067f8, allow_sum_func=true) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_base.cc:7934 #12 0x00000000005bca28 in JOIN::prepare (this=0x7f19a0005220, rref_pointer_array=0x1b7cd18, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1b7cb30, unit_arg=0x1b7c510) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_select.cc:546 #13 0x00000000005cf62e in mysql_select (thd=0x1b7aac0, rref_pointer_array=0x1b7cd18, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f19a0005200, unit=0x1b7c510, select_lex=0x1b7cb30) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_select.cc:2583 #14 0x00000000005d2bf2 in handle_select (thd=0x1b7aac0, lex=0x1b7c460, result=0x7f19a0005200, setup_tables_done_option=0) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_select.cc:297 #15 0x000000000058a2bf in execute_sqlcom_select (thd=0x1b7aac0, all_tables=0x0) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_parse.cc:4625 #16 0x000000000058ded4 in mysql_execute_command (thd=0x1b7aac0) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_parse.cc:2176 #17 0x000000000059316d in mysql_parse (thd=0x1b7aac0, rawbuf=0x7f19a0004bd0 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", length=<optimized out>, parser_state=0x7f19a9931c20) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_parse.cc:5777 #18 0x000000000059476e in dispatch_command (command=COM_QUERY, thd=0x1b7aac0, packet=0x1bffd71 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", packet_length=38) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_parse.cc:1038 #19 0x0000000000595ea4 in do_command (thd=0x1b7aac0) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_parse.cc:773 #20 0x000000000063bba6 in do_handle_one_connection (thd_arg=<optimized out>) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_connect.cc:862 #21 0x000000000063bc6f in handle_one_connection (arg=<optimized out>) at /pb2/build/sb_0-14756656-1426806538.28/mysql-5.5.44/sql/sql_connect.cc:781 #22 0x00007f19be89fdf3 in start_thread () from /lib64/libpthread.so.0 #23 0x00007f19bda8847d in clone () from /lib64/libc.so.6 (gdb)
[25 Mar 2015 4:58]
MySQL Verification Team
// 5.6.23 scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/76468 bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.23 --datadir=/export/umesh/mysql-5.6.23/76468 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.6.23/76468/log.err 2>&1 & - build 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 0x00007f91a285a771 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 0x00007f91a14605c9 in raise () from /lib64/libc.so.6 #5 0x00007f91a1461cd8 in abort () from /lib64/libc.so.6 #6 0x00007f91a1459536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f91a14595e2 in __assert_fail () from /lib64/libc.so.6 #8 0x000000000092b3b5 in Item_row::illegal_method_call (this=0x7f9144005380, method=0xf9bedc "val_str") at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/item_row.cc:87 #9 0x000000000092bb3a in Item_row::val_str (this=0x7f9144005380) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/item_row.h:58 #10 0x0000000000661fb3 in Item_func_like::fix_fields (this=0x7f9144005440, thd=0x2beaa40, ref=0x7f9144005610) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/item_cmpfunc.cc:5336 #11 0x00000000007585c1 in setup_fields (thd=0x2beaa40, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7f9144005950, allow_sum_func=true) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_base.cc:8325 #12 0x00000000007f0759 in JOIN::prepare (this=0x7f9144005708, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, select_lex_arg=0x2bed2b8, unit_arg=0x2becc70) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_resolver.cc:168 #13 0x000000000080126b in mysql_prepare_select (thd=0x2beaa40, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, select_options=2147748608, result=0x7f91440056e0, unit=0x2becc70, select_lex=0x2bed2b8, free_join=0x7f9178221c9b) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_select.cc:1054 #14 0x00000000008013c0 in mysql_select (thd=0x2beaa40, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x2bed480, group=0x2bed3b8, having=0x0, select_options=2147748608, result=0x7f91440056e0, unit=0x2becc70, select_lex=0x2bed2b8) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_select.cc:1177 #15 0x00000000008016eb in handle_select (thd=0x2beaa40, result=0x7f91440056e0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_select.cc:110 #16 0x00000000007c7880 in execute_sqlcom_select (thd=0x2beaa40, all_tables=0x0) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:5103 #17 0x00000000007c8dab in mysql_execute_command (thd=0x2beaa40) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:2649 #18 0x00000000007d0349 in mysql_parse (thd=0x2beaa40, rawbuf=0x7f9144004fd0 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", length=38, parser_state=0x7f9178223700) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:6357 #19 0x00000000007d1ef3 in dispatch_command (command=COM_QUERY, thd=0x2beaa40, packet=0x33c5b71 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", packet_length=38) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:1332 #20 0x00000000007d372d in do_command (thd=0x2beaa40) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_parse.cc:1034 #21 0x0000000000789521 in do_handle_one_connection (thd_arg=0x2beaa40) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_connect.cc:982 #22 0x00000000007895e7 in handle_one_connection (arg=0x2beaa40) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/sql/sql_connect.cc:898 #23 0x0000000000d7a866 in pfs_spawn_thread (arg=0x3359570) at /export/home/pb2/build/sb_0-14135570-1421676610.55/mysql-5.6.23/storage/perfschema/pfs.cc:1860 #24 0x00007f91a2855df3 in start_thread () from /lib64/libpthread.so.0 #25 0x00007f91a152147d in clone () from /lib64/libc.so.6 (gdb)
[25 Mar 2015 4:58]
MySQL Verification Team
// 5.6.25 scripts/mysql_install_db --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76468 bin/mysqld-debug --basedir=/export/umesh/mysql-5.6.25 --datadir=/export/umesh/mysql-5.6.25/76468 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.6.25/76468/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 0x00007f97086e8771 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 0x00007f97072ee5c9 in raise () from /lib64/libc.so.6 #5 0x00007f97072efcd8 in abort () from /lib64/libc.so.6 #6 0x00007f97072e7536 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f97072e75e2 in __assert_fail () from /lib64/libc.so.6 #8 0x000000000095e3b5 in Item_row::illegal_method_call (this=0x7f96ac005380, method=0x1067f84 "val_str") at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/item_row.cc:87 #9 0x000000000095eb3a in Item_row::val_str (this=0x7f96ac005380) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/item_row.h:58 #10 0x0000000000692bc3 in Item_func_like::fix_fields (this=0x7f96ac005440, thd=0x3d7cfc0, ref=0x7f96ac005610) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/item_cmpfunc.cc:5336 #11 0x000000000078a09d in setup_fields (thd=0x3d7cfc0, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7f96ac005950, allow_sum_func=true) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_base.cc:8331 #12 0x0000000000822909 in JOIN::prepare (this=0x7f96ac005708, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, select_lex_arg=0x3d7f480, unit_arg=0x3d7ee38) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_resolver.cc:168 #13 0x000000000083346f in mysql_prepare_select (thd=0x3d7cfc0, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, select_options=2147748608, result=0x7f96ac0056e0, unit=0x3d7ee38, select_lex=0x3d7f480, free_join=0x7f96ddf9dc5b) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_select.cc:1054 #14 0x00000000008335c4 in mysql_select (thd=0x3d7cfc0, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x3d7f648, group=0x3d7f580, having=0x0, select_options=2147748608, result=0x7f96ac0056e0, unit=0x3d7ee38, select_lex=0x3d7f480) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_select.cc:1177 #15 0x00000000008338ef in handle_select (thd=0x3d7cfc0, result=0x7f96ac0056e0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_select.cc:110 #16 0x00000000007f9764 in execute_sqlcom_select (thd=0x3d7cfc0, all_tables=0x0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:5139 #17 0x00000000007fac8f in mysql_execute_command (thd=0x3d7cfc0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:2661 #18 0x000000000080229a in mysql_parse (thd=0x3d7cfc0, rawbuf=0x7f96ac004fd0 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", length=38, parser_state=0x7f96ddf9f700) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:6391 #19 0x0000000000803ebe in dispatch_command (command=COM_QUERY, thd=0x3d7cfc0, packet=0x3eabdb1 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", packet_length=38) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1340 #20 0x0000000000805748 in do_command (thd=0x3d7cfc0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1037 #21 0x00000000007bb291 in do_handle_one_connection (thd_arg=0x3d7cfc0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_connect.cc:982 #22 0x00000000007bb357 in handle_one_connection (arg=0x3d7cfc0) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/sql/sql_connect.cc:898 #23 0x0000000000b92d9c in pfs_spawn_thread (arg=0x3e8db30) at /export/home/pb2/build/sb_0-14777162-1427103432.53/mysqlcom-pro-5.6.25/storage/perfschema/pfs.cc:1860 #24 0x00007f97086e3df3 in start_thread () from /lib64/libpthread.so.0 #25 0x00007f97073af47d in clone () from /lib64/libc.so.6 (gdb)
[25 Mar 2015 5:09]
MySQL Verification Team
Marking this as duplicate of Shane's Bug #57552