Bug #79829 | Assertion `i == (uint16) (*((uint16 *) (part_rec_buf_ptr)))' failed. | ||
---|---|---|---|
Submitted: | 4 Jan 2016 3:59 | Modified: | 4 Jan 2016 5:39 |
Reporter: | Roel Van de Paar | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S6 (Debug Builds) |
Version: | 5.6, 5.5.48, 5.6.28, 5.6.29, 5.7.10, 5.7.11 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[4 Jan 2016 3:59]
Roel Van de Paar
[4 Jan 2016 5:39]
MySQL Verification Team
Hello Roel, Thank you for the report and test case. Observed that 5.5.48, 5.6.28/5.6.29, 5.7.10/5.7.11 debug builds are affected. Thanks, Umesh
[4 Jan 2016 5:40]
MySQL Verification Team
// 5.5.48 only debug build affected scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.5.48 --datadir=/export/umesh/server/binaries/mysql-5.5.48/79829 bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-5.5.48 --datadir=/export/umesh/server/binaries/mysql-5.5.48/79829 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.5.48/79829/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.48: cat docs/INFO_SRC commit: d6a208adc1275aa005cd3707cd1b39713d288f12 date: 2015-12-31 07:31:12 +0530 build-date: 2015-12-31 23:46:15 +0100 short: d6a208a branch: mysql-5.5 MySQL source 5.5.48 (gdb) bt #0 0x00007fb9491b5771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000007ede26 in my_write_core (sig=6) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/mysys/stacktrace.c:433 #2 0x00000000006a5cac in handle_fatal_signal (sig=6) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/signal_handler.cc:247 #3 <signal handler called> #4 0x00007fb9482d85d7 in raise () from /lib64/libc.so.6 #5 0x00007fb9482d9cc8 in abort () from /lib64/libc.so.6 #6 0x00007fb9482d1546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fb9482d15f2 in __assert_fail () from /lib64/libc.so.6 #8 0x00000000009e2036 in ha_partition::handle_ordered_index_scan (this=0x7fb92c00ac70, buf=0x7fb92c00afe8 "\361\001", reverse_order=false) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/ha_partition.cc:5284 #9 0x00000000009e2632 in ha_partition::common_index_read (this=0x7fb92c00ac70, buf=0x7fb92c00afe8 "\361\001", have_start_key=true) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/ha_partition.cc:4627 #10 0x00000000009e28f5 in ha_partition::index_read_map (this=0x7fb92c00ac70, buf=0x7fb92c00afe8 "\361\001", key=0x7fb92c013d40 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/ha_partition.cc:4542 #11 0x000000000071ef41 in subselect_indexsubquery_engine::exec (this=0x7fb92c016f10) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/item_subselect.cc:2424 #12 0x0000000000718ac0 in Item_subselect::exec (this=0x7fb92c006268) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/item_subselect.cc:277 #13 0x0000000000718adc in Item_subselect::exec (this=0x7fb92c006268) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/item_subselect.cc:282 #14 0x00000000007183ff in Item_in_subselect::val_bool (this=0x2b5c) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/item_subselect.cc:878 #15 0x0000000000516b13 in Item::val_bool_result (this=0x2b5c) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/item.h:856 #16 0x00000000006ccd7e in Item_in_optimizer::val_int (this=0x7fb92c006848) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/item_cmpfunc.cc:1939 #17 0x00000000006b2f4e in Item::send (this=0x7fb92c006848, protocol=0x321bf68, buffer=0x7fb944302ff0) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/item.cc:6019 #18 0x00000000005150a2 in Protocol::send_result_set_row (this=0x321bf68, row_items=<optimized out>) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/protocol.cc:847 #19 0x000000000055ec6b in select_send::send_data (this=0x7fb92c006490, items=...) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_class.cc:2240 #20 0x00000000005d0dbf in JOIN::exec (this=0x7fb92c02e4c0) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_select.cc:1892 #21 0x00000000005d345d in mysql_select (thd=0x321bac0, rref_pointer_array=0x321dd20, tables=0x0, wild_num=0, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb92c006490, unit=0x321d518, select_lex=0x321db38) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_select.cc:2619 #22 0x00000000005d3997 in handle_select (thd=0x321bac0, lex=0x321d468, result=0x7fb92c006490, setup_tables_done_option=0) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_select.cc:297 #23 0x000000000058ab64 in execute_sqlcom_select (thd=0x321bac0, all_tables=0x7fb92c005b88) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_parse.cc:4625 #24 0x000000000058e774 in mysql_execute_command (thd=0x321bac0) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_parse.cc:2176 #25 0x0000000000593a1d in mysql_parse (thd=0x321bac0, rawbuf=0x7fb92c004bd0 "SELECT ROW(1,1,'a') IN (SELECT a,b,c FROM t1 WHERE a IS NOT NULL)", length=<optimized out>, parser_state=0x7fb944304c20) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_parse.cc:5780 #26 0x000000000059501e in dispatch_command (command=COM_QUERY, thd=0x321bac0, packet=0x32a0ec1 "", packet_length=65) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_parse.cc:1038 #27 0x0000000000596754 in do_command (thd=0x321bac0) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_parse.cc:773 #28 0x000000000063d046 in do_handle_one_connection (thd_arg=<optimized out>) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_connect.cc:862 #29 0x000000000063d10f in handle_one_connection (arg=<optimized out>) at /pb2/build/sb_0-17490040-1451602833.9/mysql-5.5.48/sql/sql_connect.cc:781 #30 0x00007fb9491b0df5 in start_thread () from /lib64/libpthread.so.0 #31 0x00007fb94839960d in clone () from /lib64/libc.so.6 (gdb)
[4 Jan 2016 5:41]
MySQL Verification Team
// 5.6.28 only debug build affected scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.28 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.28/79829 bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.28 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.28/79829 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.6.28/79829/log.err 2>&1 & (gdb) bt #0 0x00007f320d9c2771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae4697 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/mysys/stacktrace.c:422 #2 0x0000000000747246 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f320c5c85d7 in raise () from /lib64/libc.so.6 #5 0x00007f320c5c9cc8 in abort () from /lib64/libc.so.6 #6 0x00007f320c5c1546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f320c5c15f2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000e517ab in ha_partition::handle_ordered_index_scan (this=0x7f31b801a260, buf=0x7f31b8010dd0 "\361\001", reverse_order=false) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/ha_partition.cc:5977 #9 0x0000000000e5231d in ha_partition::common_index_read (this=0x7f31b801a260, buf=0x7f31b8010dd0 "\361\001", have_start_key=true) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/ha_partition.cc:5320 #10 0x0000000000e52594 in ha_partition::index_read_map (this=0x7f31b801a260, buf=0x7f31b8010dd0 "\361\001", key=0x7f31b8020368 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/ha_partition.cc:5235 #11 0x000000000064ae27 in handler::ha_index_read_map (this=0x7f31b801a260, buf=0x7f31b8010dd0 "\361\001", key=0x7f31b8020368 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/handler.cc:2752 #12 0x0000000000966284 in subselect_indexsubquery_engine::exec (this=0x7f31b80223b0) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item_subselect.cc:3155 #13 0x000000000096aff3 in Item_subselect::exec (this=0x7f31b8006828) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item_subselect.cc:643 #14 0x000000000096b2b1 in Item_in_subselect::exec (this=0x7f31b8006828) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item_subselect.cc:768 #15 0x000000000096b032 in Item_subselect::exec (this=0x7f31b8006828) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item_subselect.cc:648 #16 0x000000000096b2b1 in Item_in_subselect::exec (this=0x7f31b8006828) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item_subselect.cc:768 #17 0x000000000096316f in Item_in_subselect::val_bool (this=0x7f31b8006828) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item_subselect.cc:1401 #18 0x000000000065895a in Item::val_bool_result (this=0x7f31b8006828) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item.h:1190 #19 0x000000000068d7e9 in Item_in_optimizer::val_int (this=0x7f31b801cbb8) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item_cmpfunc.cc:2099 #20 0x0000000000663cac in Item::send (this=0x7f31b801cbb8, protocol=0x28809e8, buffer=0x7f31e32b7960) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/item.cc:6900 #21 0x000000000073e2e4 in Protocol::send_result_set_row (this=0x28809e8, row_items=0x2882b00) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/protocol.cc:847 #22 0x00000000007b1d15 in select_send::send_data (this=0x7f31b8006ac0, items=...) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_class.cc:2531 #23 0x00000000007d254a in JOIN::exec (this=0x7f31b8006ae8) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_executor.cc:149 #24 0x0000000000835502 in mysql_execute_select (thd=0x2880510, select_lex=0x28829e0, free_join=true) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_select.cc:1101 #25 0x0000000000835ec1 in mysql_select (thd=0x2880510, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x2882ba8, group=0x2882ae0, having=0x0, select_options=2147748608, result=0x7f31b8006ac0, unit=0x2882398, select_lex=0x28829e0) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_select.cc:1222 #26 0x00000000008360bd in handle_select (thd=0x2880510, result=0x7f31b8006ac0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_select.cc:110 #27 0x00000000007fbde8 in execute_sqlcom_select (thd=0x2880510, all_tables=0x7f31b80060d0) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_parse.cc:5134 #28 0x00000000007fd313 in mysql_execute_command (thd=0x2880510) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_parse.cc:2656 #29 0x0000000000804922 in mysql_parse (thd=0x2880510, rawbuf=0x7f31b8004fd0 "SELECT ROW(1,1,'a') IN (SELECT a,b,c FROM t1 WHERE a IS NOT NULL)", length=65, parser_state=0x7f31e32b9700) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_parse.cc:6386 #30 0x0000000000806546 in dispatch_command (command=COM_QUERY, thd=0x2880510, packet=0x29b1a31 "", packet_length=65) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_parse.cc:1340 #31 0x0000000000807dd2 in do_command (thd=0x2880510) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_parse.cc:1037 #32 0x00000000007bc9ad in do_handle_one_connection (thd_arg=0x2880510) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_connect.cc:982 #33 0x00000000007bca73 in handle_one_connection (arg=0x2880510) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/sql/sql_connect.cc:898 #34 0x0000000000b96526 in pfs_spawn_thread (arg=0x28a5370) at /export/home/pb2/build/sb_0-17068951-1447696819.05/mysqlcom-pro-5.6.28/storage/perfschema/pfs.cc:1860 #35 0x00007f320d9bddf5 in start_thread () from /lib64/libpthread.so.0 #36 0x00007f320c68960d in clone () from /lib64/libc.so.6 (gdb)
[4 Jan 2016 5:41]
MySQL Verification Team
// 5.6.29 only debug build affected scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.29 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.29/79829 bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.29 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.29/79829 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.6.29/79829/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.29: cat docs/INFO_SRC commit: 116bab1e51a762e6484d400120187bcfe86bf803 date: 2015-12-31 07:32:05 +0530 build-date: 2015-12-31 03:15:55 +0100 short: 116bab1 branch: mysql-5.6 MySQL source 5.6.29 (gdb) bt #0 0x00007f62162ad771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae505f in my_write_core (sig=6) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/mysys/stacktrace.c:422 #2 0x000000000074765e in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f6214eb35d7 in raise () from /lib64/libc.so.6 #5 0x00007f6214eb4cc8 in abort () from /lib64/libc.so.6 #6 0x00007f6214eac546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f6214eac5f2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000e52aed in ha_partition::handle_ordered_index_scan (this=0x7f61bc010530, buf=0x7f61bc018fb0 "\361\001", reverse_order=false) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/ha_partition.cc:5977 #9 0x0000000000e5365f in ha_partition::common_index_read (this=0x7f61bc010530, buf=0x7f61bc018fb0 "\361\001", have_start_key=true) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/ha_partition.cc:5320 #10 0x0000000000e538d6 in ha_partition::index_read_map (this=0x7f61bc010530, buf=0x7f61bc018fb0 "\361\001", key=0x7f61bc0210c8 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/ha_partition.cc:5235 #11 0x000000000064b1f7 in handler::ha_index_read_map (this=0x7f61bc010530, buf=0x7f61bc018fb0 "\361\001", key=0x7f61bc0210c8 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/handler.cc:2752 #12 0x00000000009666ec in subselect_indexsubquery_engine::exec (this=0x7f61bc023110) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item_subselect.cc:3155 #13 0x000000000096b45b in Item_subselect::exec (this=0x7f61bc006828) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item_subselect.cc:643 #14 0x000000000096b719 in Item_in_subselect::exec (this=0x7f61bc006828) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item_subselect.cc:768 #15 0x000000000096b49a in Item_subselect::exec (this=0x7f61bc006828) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item_subselect.cc:648 #16 0x000000000096b719 in Item_in_subselect::exec (this=0x7f61bc006828) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item_subselect.cc:768 #17 0x00000000009635d7 in Item_in_subselect::val_bool (this=0x7f61bc006828) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item_subselect.cc:1401 #18 0x0000000000658d2a in Item::val_bool_result (this=0x7f61bc006828) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item.h:1190 #19 0x000000000068dbf5 in Item_in_optimizer::val_int (this=0x7f61bc01d918) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item_cmpfunc.cc:2099 #20 0x000000000066407c in Item::send (this=0x7f61bc01d918, protocol=0x3df0b98, buffer=0x7f61ebba2960) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/item.cc:6900 #21 0x000000000073e6f0 in Protocol::send_result_set_row (this=0x3df0b98, row_items=0x3df2cb0) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/protocol.cc:844 #22 0x00000000007b1d9d in select_send::send_data (this=0x7f61bc006ac0, items=...) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_class.cc:2538 #23 0x00000000007d266e in JOIN::exec (this=0x7f61bc006ae8) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_executor.cc:149 #24 0x000000000083561e in mysql_execute_select (thd=0x3df06c0, select_lex=0x3df2b90, free_join=true) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_select.cc:1101 #25 0x0000000000835fdd in mysql_select (thd=0x3df06c0, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x3df2d58, group=0x3df2c90, having=0x0, select_options=2147748608, result=0x7f61bc006ac0, unit=0x3df2548, select_lex=0x3df2b90) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_select.cc:1222 #26 0x00000000008361d9 in handle_select (thd=0x3df06c0, result=0x7f61bc006ac0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_select.cc:110 #27 0x00000000007fbf04 in execute_sqlcom_select (thd=0x3df06c0, all_tables=0x7f61bc0060d0) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_parse.cc:5133 #28 0x00000000007fd42f in mysql_execute_command (thd=0x3df06c0) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_parse.cc:2655 #29 0x0000000000804a3e in mysql_parse (thd=0x3df06c0, rawbuf=0x7f61bc004fd0 "SELECT ROW(1,1,'a') IN (SELECT a,b,c FROM t1 WHERE a IS NOT NULL)", length=65, parser_state=0x7f61ebba4700) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_parse.cc:6385 #30 0x0000000000806662 in dispatch_command (command=COM_QUERY, thd=0x3df06c0, packet=0x3f20c31 "", packet_length=65) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_parse.cc:1339 #31 0x0000000000807eee in do_command (thd=0x3df06c0) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_parse.cc:1036 #32 0x00000000007bcad1 in do_handle_one_connection (thd_arg=0x3df06c0) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_connect.cc:982 #33 0x00000000007bcb97 in handle_one_connection (arg=0x3df06c0) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/sql/sql_connect.cc:898 #34 0x0000000000b96ef2 in pfs_spawn_thread (arg=0x3e99b30) at /export/home/pb2/build/sb_0-17486706-1451528727.77/mysqlcom-pro-5.6.29/storage/perfschema/pfs.cc:1860 #35 0x00007f62162a8df5 in start_thread () from /lib64/libpthread.so.0 #36 0x00007f6214f7460d in clone () from /lib64/libc.so.6 (gdb)
[4 Jan 2016 5:41]
MySQL Verification Team
// 5.7.10 only debug build affected( with set sql_mode='') bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.10 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.10/79829 -v bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.10 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.10/79829 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.10/79829/log.err 2>&1 & (gdb) bt #0 0x00007ff5d2b0e771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000188bda1 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/mysys/stacktrace.c:247 #2 0x0000000000eadfe4 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/signal_handler.cc:220 #3 <signal handler called> #4 0x00007ff5d17145d7 in raise () from /lib64/libc.so.6 #5 0x00007ff5d1715cc8 in abort () from /lib64/libc.so.6 #6 0x00007ff5d170d546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007ff5d170d5f2 in __assert_fail () from /lib64/libc.so.6 #8 0x000000000149be36 in Partition_helper::handle_ordered_index_scan (this=0x7ff55c00f050, buf=0x7ff55c00f568 "\361\001") at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/partitioning/partition_handler.cc:3261 #9 0x000000000149a9d4 in Partition_helper::common_index_read (this=0x7ff55c00f050, buf=0x7ff55c00f568 "\361\001", have_start_key=true) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/partitioning/partition_handler.cc:2589 #10 0x000000000149a72e in Partition_helper::ph_index_read_map (this=0x7ff55c00f050, buf=0x7ff55c00f568 "\361\001", key=0x7ff55c949ee8 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/partitioning/partition_handler.cc:2503 #11 0x0000000001d50ea9 in ha_partition::index_read_map (this=0x7ff55c00edf0, buf=0x7ff55c00f568 "\361\001", key=0x7ff55c949ee8 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/storage/partition/ha_partition.h:473 #12 0x0000000000f2bd09 in handler::ha_index_read_map (this=0x7ff55c00edf0, buf=0x7ff55c00f568 "\361\001", key=0x7ff55c949ee8 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/handler.cc:2901 #13 0x000000000142eeeb in subselect_indexsubquery_engine::exec (this=0x7ff55c94aef8) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/item_subselect.cc:3409 #14 0x00000000014265b2 in Item_subselect::exec (this=0x7ff55c006b08) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/item_subselect.cc:582 #15 0x0000000001426ad7 in Item_in_subselect::exec (this=0x7ff55c006b08) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/item_subselect.cc:702 #16 0x00000000014295fc in Item_in_subselect::val_bool (this=0x7ff55c006b08) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/item_subselect.cc:1626 #17 0x0000000000f12e93 in Item::val_bool_result (this=0x7ff55c006b08) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/item.h:1585 #18 0x0000000000f704b7 in Item_in_optimizer::val_int (this=0x7ff55c945850) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/item_cmpfunc.cc:2392 #19 0x0000000000f55ca9 in Item::send (this=0x7ff55c945850, protocol=0x7ff55c001bb0, buffer=0x7ff5a550fbc0) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/item.cc:7535 #20 0x0000000001512352 in THD::send_result_set_row (this=0x7ff55c000b70, row_items=0x7ff55c005728) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_class.cc:4726 #21 0x000000000150cb88 in Query_result_send::send_data (this=0x7ff55c945288, items=...) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_class.cc:2781 #22 0x0000000001523378 in JOIN::exec (this=0x7ff55c9480f8) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_executor.cc:156 #23 0x00000000015bfab6 in handle_query (thd=0x7ff55c000b70, lex=0x7ff55c002cd0, result=0x7ff55c945288, added_options=0, removed_options=0) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_select.cc:184 #24 0x000000000157586a in execute_sqlcom_select (thd=0x7ff55c000b70, all_tables=0x7ff55c944b38) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_parse.cc:5098 #25 0x000000000156e505 in mysql_execute_command (thd=0x7ff55c000b70, first_level=true) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_parse.cc:2748 #26 0x00000000015766c1 in mysql_parse (thd=0x7ff55c000b70, parser_state=0x7ff5a5511690) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_parse.cc:5508 #27 0x000000000156b25e in dispatch_command (thd=0x7ff55c000b70, com_data=0x7ff5a5511e00, command=COM_QUERY) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_parse.cc:1425 #28 0x000000000156a116 in do_command (thd=0x7ff55c000b70) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/sql_parse.cc:993 #29 0x000000000169b713 in handle_connection (arg=0x4d06ad0) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/sql/conn_handler/connection_handler_per_thread.cc:301 #30 0x0000000001917660 in pfs_spawn_thread (arg=0x4fcd340) at /export/home/pb2/build/sb_0-17208442-1448825515.37/mysqlcom-pro-5.7.10/storage/perfschema/pfs.cc:2192 #31 0x00007ff5d2b09df5 in start_thread () from /lib64/libpthread.so.0 #32 0x00007ff5d17d560d in clone () from /lib64/libc.so.6 (gdb)
[4 Jan 2016 5:42]
MySQL Verification Team
// 5.7.11 only debug build affected( with set sql_mode='') bin/mysql_install_db --insecure --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.11 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.11/79829 -v bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-advanced-5.7.11 --datadir=/export/umesh/server/binaries/mysql-advanced-5.7.11/79829 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-advanced-5.7.11/79829/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.11: cat docs/INFO_SRC commit: f47717fd6d981fa29521cbec7f6fda2e7d1aafcb date: 2015-12-31 07:32:48 +0530 build-date: 2015-12-31 03:19:29 +0100 short: f47717f branch: mysql-5.7 MySQL source 5.7.11 (gdb) bt #0 0x00007fc2a20ad771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000018a6701 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/mysys/stacktrace.c:247 #2 0x0000000000ebc4cc in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/signal_handler.cc:220 #3 <signal handler called> #4 0x00007fc2a0cb35d7 in raise () from /lib64/libc.so.6 #5 0x00007fc2a0cb4cc8 in abort () from /lib64/libc.so.6 #6 0x00007fc2a0cac546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fc2a0cac5f2 in __assert_fail () from /lib64/libc.so.6 #8 0x000000000148add2 in Partition_helper::handle_ordered_index_scan (this=0x7fc22c01afe0, buf=0x7fc22c010578 "\361\001") at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/partitioning/partition_handler.cc:3261 #9 0x0000000001489970 in Partition_helper::common_index_read (this=0x7fc22c01afe0, buf=0x7fc22c010578 "\361\001", have_start_key=true) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/partitioning/partition_handler.cc:2589 #10 0x00000000014896ca in Partition_helper::ph_index_read_map (this=0x7fc22c01afe0, buf=0x7fc22c010578 "\361\001", key=0x7fc22c025c28 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/partitioning/partition_handler.cc:2503 #11 0x0000000001d742d9 in ha_partition::index_read_map (this=0x7fc22c01ad80, buf=0x7fc22c010578 "\361\001", key=0x7fc22c025c28 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/storage/partition/ha_partition.h:473 #12 0x0000000000f3a4db in handler::ha_index_read_map (this=0x7fc22c01ad80, buf=0x7fc22c010578 "\361\001", key=0x7fc22c025c28 "", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/handler.cc:2901 #13 0x000000000141db0d in subselect_indexsubquery_engine::exec (this=0x7fc22c026c38) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/item_subselect.cc:3492 #14 0x00000000014150fa in Item_subselect::exec (this=0x7fc22c945aa8) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/item_subselect.cc:620 #15 0x000000000141561f in Item_in_subselect::exec (this=0x7fc22c945aa8) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/item_subselect.cc:740 #16 0x000000000141810a in Item_in_subselect::val_bool (this=0x7fc22c945aa8) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/item_subselect.cc:1663 #17 0x0000000000f21543 in Item::val_bool_result (this=0x7fc22c945aa8) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/item.h:1604 #18 0x0000000000f7f123 in Item_in_optimizer::val_int (this=0x7fc22c006510) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/item_cmpfunc.cc:2392 #19 0x0000000000f646f9 in Item::send (this=0x7fc22c006510, protocol=0x7fc22c013350, buffer=0x7fc274ab2bc0) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/item.cc:7537 #20 0x00000000015104d2 in THD::send_result_set_row (this=0x7fc22c012310, row_items=0x7fc22c9446c8) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_class.cc:4709 #21 0x000000000150ad00 in Query_result_send::send_data (this=0x7fc22c005f48, items=...) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_class.cc:2764 #22 0x0000000001521620 in JOIN::exec (this=0x7fc22c023e38) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_executor.cc:156 #23 0x00000000015bd96e in handle_query (thd=0x7fc22c012310, lex=0x7fc22c014470, result=0x7fc22c005f48, added_options=0, removed_options=0) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_select.cc:184 #24 0x0000000001573693 in execute_sqlcom_select (thd=0x7fc22c012310, all_tables=0x7fc22c0057f8) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_parse.cc:5104 #25 0x000000000156c323 in mysql_execute_command (thd=0x7fc22c012310, first_level=true) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_parse.cc:2754 #26 0x00000000015744eb in mysql_parse (thd=0x7fc22c012310, parser_state=0x7fc274ab4690) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_parse.cc:5514 #27 0x0000000001569008 in dispatch_command (thd=0x7fc22c012310, com_data=0x7fc274ab4e00, command=COM_QUERY) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_parse.cc:1425 #28 0x0000000001567ec0 in do_command (thd=0x7fc22c012310) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/sql_parse.cc:993 #29 0x0000000001699f3f in handle_connection (arg=0x50110c0) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/sql/conn_handler/connection_handler_per_thread.cc:301 #30 0x0000000001c7c834 in pfs_spawn_thread (arg=0x51268c0) at /export/home/pb2/build/sb_0-17486723-1451529264.69/mysqlcom-pro-5.7.11/storage/perfschema/pfs.cc:2192 #31 0x00007fc2a20a8df5 in start_thread () from /lib64/libpthread.so.0 #32 0x00007fc2a0d7460d in clone () from /lib64/libc.so.6 (gdb)