|
http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/5409/steps/test_7/logs/stdio
|
Stack trace from 10.1.11 release
|
#2 <signal handler called>
|
#3 0x00005564f261a1f6 in fix_fields (thd=0x7f49053de008, this=0x7f4900704850, ref=<optimized out>) at /home/buildbot/buildbot/build/sql/item_func.cc:214
|
#4 Item_func::fix_fields (this=0x7f4900704850, thd=0x7f49053de008, ref=<optimized out>) at /home/buildbot/buildbot/build/sql/item_func.cc:175
|
#5 0x00005564f241c133 in setup_fields (thd=0x7f49053de008, ref_pointer_array=0x7f4900705098, fields=..., mark_used_columns=mark_used_columns@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x7f49004c7440, allow_sum_func=allow_sum_func@entry=true) at /home/buildbot/buildbot/build/sql/sql_base.cc:7950
|
#6 0x00005564f249d782 in prepare (unit_arg=0x7f49007030e8, select_lex_arg=0x7f49007037e8, proc_param_init=0x0, having_init=0x0, group_init=0x0, skip_order_by=false, order_init=0x0, og_num=0, conds_init=<optimized out>, wild_num=0, tables_init=<optimized out>, rref_pointer_array=0x7f4900703a60, this=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:795
|
#7 JOIN::prepare (this=<optimized out>, rref_pointer_array=0x7f4900703a60, tables_init=<optimized out>, wild_num=0, conds_init=<optimized out>, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f49007037e8, unit_arg=0x7f49007030e8) at /home/buildbot/buildbot/build/sql/sql_select.cc:686
|
#8 0x00005564f24aa0c4 in mysql_select (thd=thd@entry=0x7f49053de008, rref_pointer_array=rref_pointer_array@entry=0x7f4900703a60, tables=0x7f4900704a70, wild_num=<optimized out>, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=result@entry=0x7f4900705078, unit=unit@entry=0x7f49007030e8, select_lex=select_lex@entry=0x7f49007037e8) at /home/buildbot/buildbot/build/sql/sql_select.cc:3429
|
#9 0x00005564f24ad19d in handle_select (thd=thd@entry=0x7f49053de008, lex=lex@entry=0x7f4900703020, result=result@entry=0x7f4900705078, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:384
|
#10 0x00005564f244fa72 in execute_sqlcom_select (thd=thd@entry=0x7f49053de008, all_tables=0x7f4900704a70) at /home/buildbot/buildbot/build/sql/sql_parse.cc:5903
|
#11 0x00005564f245bce0 in mysql_execute_command (thd=0x7f49053de008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:2962
|
#12 0x00005564f247197a in Prepared_statement::execute (this=this@entry=0x7f4900500288, expanded_query=expanded_query@entry=0x7f490b21a410, open_cursor=open_cursor@entry=false) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:4265
|
#13 0x00005564f2471a6c in Prepared_statement::execute_loop (this=0x7f4900500288, expanded_query=0x7f490b21a410, open_cursor=false, packet_end=<optimized out>, packet=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:3897
|
#14 0x00005564f24727ce in mysqld_stmt_execute (thd=thd@entry=0x7f49053de008, packet_arg=packet_arg@entry=0x7f49047f7009 "\217", packet_length=packet_length@entry=9) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:2974
|
#15 0x00005564f2460bd8 in dispatch_command (command=command@entry=COM_STMT_EXECUTE, thd=thd@entry=0x7f49053de008, packet=0x7f49047f7009 "\217", packet_length=packet_length@entry=9) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1432
|
#16 0x00005564f24620ab in do_command (thd=0x7f49053de008) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1109
|
#17 0x00005564f251d77f in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f49053de008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1349
|
#18 0x00005564f251d8d7 in handle_one_connection (arg=arg@entry=0x7f49053de008) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1261
|
#19 0x00005564f295331d in pfs_spawn_thread (arg=0x7f4908c40a08) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1860
|
#20 0x00007f490a3fa0a4 in start_thread () from /lib64/libpthread.so.0
|
|
Stack trace from 10.1 debug commit 7b14ba63f22e6c98c1982dae8847035ad1b8e155
|
mysqld: /src/10.1/sql/item_cmpfunc.cc:2572: virtual void Item_func_nullif::fix_length_and_dec(): Assertion `args[0] == args[2]' failed.
|
160201 0:47:27 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f7cf507b1d2 in __assert_fail () from /lib64/libc.so.6
|
#8 0x0000560c5602d325 in Item_func_nullif::fix_length_and_dec (this=0x7f7ceb9e7ae0) at /src/10.1/sql/item_cmpfunc.cc:2572
|
#9 0x0000560c560552ba in Item_func::fix_fields (this=0x7f7ceb9e7ae0, thd=0x7f7cf0fc9b30, ref=0x7f7ceb9e7d00) at /src/10.1/sql/item_func.cc:234
|
#10 0x0000560c5605508a in Item_func::fix_fields (this=0x7f7ceb9e7c78, thd=0x7f7cf0fc9b30, ref=0x7f7ceb9e7d38) at /src/10.1/sql/item_func.cc:208
|
#11 0x0000560c55d5ae31 in setup_fields (thd=0x7f7cf0fc9b30, ref_pointer_array=0x7f7ceb9e8428, fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7f7ceb852f68, allow_sum_func=true) at /src/10.1/sql/sql_base.cc:7950
|
#12 0x0000560c55df1ad8 in JOIN::prepare (this=0x7f7ceb852c08, rref_pointer_array=0x7f7ceb9e6b48, tables_init=0x7f7ceb9e7e00, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f7ceb9e68d0, unit_arg=0x7f7ceb9e61d0) at /src/10.1/sql/sql_select.cc:795
|
#13 0x0000560c55dfb232 in mysql_select (thd=0x7f7cf0fc9b30, rref_pointer_array=0x7f7ceb9e6b48, tables=0x7f7ceb9e7e00, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f7ceb9e8408, unit=0x7f7ceb9e61d0, select_lex=0x7f7ceb9e68d0) at /src/10.1/sql/sql_select.cc:3429
|
#14 0x0000560c55df0d89 in handle_select (thd=0x7f7cf0fc9b30, lex=0x7f7ceb9e6108, result=0x7f7ceb9e8408, setup_tables_done_option=0) at /src/10.1/sql/sql_select.cc:384
|
#15 0x0000560c55dc1133 in execute_sqlcom_select (thd=0x7f7cf0fc9b30, all_tables=0x7f7ceb9e7e00) at /src/10.1/sql/sql_parse.cc:5903
|
#16 0x0000560c55db720d in mysql_execute_command (thd=0x7f7cf0fc9b30) at /src/10.1/sql/sql_parse.cc:2962
|
#17 0x0000560c55ddeb97 in Prepared_statement::execute (this=0x7f7ceb89c070, expanded_query=0x7f7cf7345400, open_cursor=false) at /src/10.1/sql/sql_prepare.cc:4265
|
#18 0x0000560c55ddda32 in Prepared_statement::execute_loop (this=0x7f7ceb89c070, expanded_query=0x7f7cf7345400, open_cursor=false, packet=0x7f7cf01c943a "", packet_end=0x7f7cf01c943a "") at /src/10.1/sql/sql_prepare.cc:3897
|
#19 0x0000560c55ddb89b in mysqld_stmt_execute (thd=0x7f7cf0fc9b30, packet_arg=0x7f7cf01c9431 "\200", packet_length=9) at /src/10.1/sql/sql_prepare.cc:2974
|
#20 0x0000560c55db3126 in dispatch_command (command=COM_STMT_EXECUTE, thd=0x7f7cf0fc9b30, packet=0x7f7cf01c9431 "\200", packet_length=9) at /src/10.1/sql/sql_parse.cc:1432
|
#21 0x0000560c55db21a6 in do_command (thd=0x7f7cf0fc9b30) at /src/10.1/sql/sql_parse.cc:1109
|
#22 0x0000560c55ee7798 in do_handle_one_connection (thd_arg=0x7f7cf0fc9b30) at /src/10.1/sql/sql_connect.cc:1349
|
#23 0x0000560c55ee74fc in handle_one_connection (arg=0x7f7cf0fc9b30) at /src/10.1/sql/sql_connect.cc:1261
|
#24 0x0000560c565edbf2 in pfs_spawn_thread (arg=0x7f7cefbb0e70) at /src/10.1/storage/perfschema/pfs.cc:1860
|
#25 0x00007f7cf6fc40a4 in start_thread () from /lib64/libpthread.so.0
|
The problem was introduced by the following revision:
commit ce40ccaf24af2fe395f541cb1079256de8727ccd
|
Author: Alexander Barkov <bar@mariadb.org>
|
Date: Thu Jan 28 13:58:39 2016 +0400
|
|
MDEV-9181 (NULLIF(count(table.col)), 0) gives wrong result on 10.1.x
|
Wrapping args[0] and args[2] into an Item_cache for aggregate functions.
|
|