Bug #76925 | handle_fatal_signal (sig=11) in ha_innobase::store_key_val_for_row | ||
---|---|---|---|
Submitted: | 4 May 2015 10:37 | Modified: | 4 May 2015 11:18 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.6.23, 5.6.25 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[4 May 2015 10:37]
Ramesh Sivaraman
[4 May 2015 10:38]
Ramesh Sivaraman
Testcase bundle
Attachment: 1430715139_bug_bundle.tar.gz (application/gzip, text), 1012.28 KiB.
[4 May 2015 11:18]
MySQL Verification Team
Hello Ramesh Sivaraman, Thank you for the report and test case. Observed that 5.6.25 debug builds affected. Thanks, Umesh
[4 May 2015 11:19]
MySQL Verification Team
// 5.6.25 // Start up and build details scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/76925 bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/export/umesh/server/binaries/mysql-5.6.25/76925 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.25/76925/log.err --innodb_file_per_table=1 --innodb_flush_method=O_DIRECT --log-bin=binlog --binlog_format=MIXED --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY 2>&1 & commit: 2cb773b3eaae2a452644fefd0bc683211669f9c7 date: 2015-05-01 07:15:24 +0530 build-date: 2015-05-01 04:02:35 +0200 short: 2cb773b branch: mysql-5.6 MySQL source 5.6.25 Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/mysql-5.'. Program terminated with signal 11, Segmentation fault. #0 0x00007fe6b96ba771 in pthread_kill () from /lib64/libpthread.so.0 Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.0.4.el7_0.1.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2-1.el7_0.x86_64 (gdb) bt #0 0x00007fe6b96ba771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ae1aa7 in my_write_core (sig=11) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/mysys/stacktrace.c:422 #2 0x000000000074611e in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x0000000000baa6f1 in ha_innobase::store_key_val_for_row (this=0x7fe65801e7b0, keynr=64, buff=0x7fe65801fb38 "", buff_len=29, record=0x7fe65801ea78 "\377\200") at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/storage/innobase/handler/ha_innodb.cc:5717 #5 0x0000000000baaee6 in ha_innobase::position (this=0x7fe65801e7b0, record=0x7fe65801ea78 "\377\200") at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/storage/innobase/handler/ha_innodb.cc:8392 #6 0x00000000009d1eb4 in JOIN_CACHE_BNL::join_matching_records (this=0x7fe6580770e8, skip_last=false) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_join_buffer.cc:1868 #7 0x00000000009d0b45 in JOIN_CACHE::join_records (this=0x7fe6580770e8, skip_last=false) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_join_buffer.cc:1708 #8 0x00000000009d55e2 in JOIN_CACHE::end_send (this=0x7fe6580770e8) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_join_buffer.h:457 #9 0x00000000007ce584 in sub_select_op (join=0x7fe658006b28, join_tab=0x7fe658076c78, end_of_records=true) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_executor.cc:1053 #10 0x00000000007ce0c1 in sub_select (join=0x7fe658006b28, join_tab=0x7fe658076978, end_of_records=true) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_executor.cc:1209 #11 0x00000000007cfbd5 in do_select (join=0x7fe658006b28) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_executor.cc:935 #12 0x00000000007d04b7 in JOIN::exec (this=0x7fe658006b28) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_executor.cc:194 #13 0x000000000083313a in mysql_execute_select (thd=0x3eff0c0, select_lex=0x3f01588, free_join=true) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_select.cc:1100 #14 0x0000000000833af9 in mysql_select (thd=0x3eff0c0, tables=0x7fe658005208, wild_num=0, fields=..., conds=0x7fe6580068b8, order=0x3f01750, group=0x3f01688, having=0x0, select_options=2147748608, result=0x7fe658006b00, unit=0x3f00f40, select_lex=0x3f01588) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_select.cc:1221 #15 0x0000000000833cf5 in handle_select (thd=0x3eff0c0, result=0x7fe658006b00, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_select.cc:110 #16 0x00000000007f9aa8 in execute_sqlcom_select (thd=0x3eff0c0, all_tables=0x7fe658005208) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_parse.cc:5134 #17 0x00000000007fafd3 in mysql_execute_command (thd=0x3eff0c0) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_parse.cc:2656 #18 0x00000000008025de in mysql_parse (thd=0x3eff0c0, rawbuf=0x7fe658004fd0 "SELECT c1 FROM t1 WHERE c1 IN(SELECT c2 FROM t1)", length=48, parser_state=0x7fe68ef30700) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_parse.cc:6386 #19 0x0000000000804202 in dispatch_command (command=COM_QUERY, thd=0x3eff0c0, packet=0x3fe2591 "", packet_length=48) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1340 #20 0x0000000000805a8e in do_command (thd=0x3eff0c0) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_parse.cc:1037 #21 0x00000000007bb4c1 in do_handle_one_connection (thd_arg=0x3eff0c0) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_connect.cc:982 #22 0x00000000007bb587 in handle_one_connection (arg=0x3eff0c0) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/sql/sql_connect.cc:898 #23 0x0000000000b93588 in pfs_spawn_thread (arg=0x3f53700) at /export/home/pb2/build/sb_0-15183613-1430447075.13/mysqlcom-pro-5.6.25/storage/perfschema/pfs.cc:1860 #24 0x00007fe6b96b5df3 in start_thread () from /lib64/libpthread.so.0 #25 0x00007fe6b838147d in clone () from /lib64/libc.so.6 (gdb)