// Build details commit: 348792f557bf6d66fc8e794b938c4bb9b917fa5e date: 2015-01-28 16:35:09 +0100 build-date: 2015-01-28 17:07:08 +0100 short: 348792f branch: mysql-trunk MySQL source 5.7.6 // Start up bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/75736 -v bin/mysqld-debug --no-defaults --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/75736 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --innodb_buffer_pool_size=5242880 --innodb_buffer_pool_instances=1 --innodb_old_blocks_time=1000 --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 --log-error=/export/umesh/mysql-5.7.6/75736/log.err 2>&1 & // Attachment: 1422599810_bug_bundle.tar.gz // Run below script [umshastr@hod03]/export/umesh/mysql-5.7.6: while(true); do bin/mysql -uroot --binary-mode --force -S/tmp/mysql_ushastry.sock < tmp/1422599810.sql; done 0 + (10=16) 0 ERROR 1146 (42S02) at line 5: Table 'test.t4' doesn't exist 0 + (10=16) 0 ERROR 1146 (42S02) at line 5: Table 'test.t4' doesn't exist 0 + (10=16) 0 ERROR 1146 (42S02) at line 5: Table 'test.t4' doesn't exist ERROR 2013 (HY000) at line 9: Lost connection to MySQL server during query ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_ushastry.sock' (111) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_ushastry.sock' (111) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_ushastry.sock' (111) 2015-02-03T06:20:49.451732Z 0 [Note] bin/mysqld-debug: ready for connections. Version: '5.7.6-m16-enterprise-commercial-advanced-debug' socket: '/tmp/mysql_ushastry.sock' port: 15000 MySQL Enterprise Server - Advanced Edition Debug (Commercial) 2015-02-03T06:20:49.451758Z 1 [Note] Event Scheduler: scheduler thread started with id 1 ######################################## DEADLOCK of threads detected! rw-lock 0x7fe86ac33018 --Thread 140635147335424 has waited at ibuf0ibuf.cc line 4580 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x7fe86ac33018 created in file buf0buf.cc line 1216 a writer (thread id 140636182595328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: ffffffffe0000000 Last time read locked in file ibuf0ibuf.cc line 3452 Last time write locked in file /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc line 1830 Locked: thread 140636182595328 file /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc line 1830 X-LOCK rw-lock 0x7fe86ac44458 --Thread 140636182595328 has waited at btr0cur.cc line 1830 for 0.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7fe86ac44458 created in file buf0buf.cc line 1216 a writer (thread id 140636182595328) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file ibuf0ibuf.cc line 4580 Last time write locked in file /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/include/mtr0mtr.ic line 153 Locked: thread 140635147335424 file /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/ibuf/ibuf0ibuf.cc line 4580 S-LOCK Locked: thread 140635147335424 file /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/ibuf/ibuf0ibuf.cc line 4580 S-LOCK 2015-02-03T06:21:07.540230Z 5 [ERROR] [FATAL] InnoDB: ######################################## Deadlock Detected! 2015-02-03 07:21:07 0x7fe869b4c700 InnoDB: Assertion failure in thread 140636182595328 in file ut0ut.cc line 904 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 06:21:07 UTC - mysqld got signal 6 ; (gdb) bt #0 0x00007fe8803c6771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000012bc5f8 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247 #2 0x0000000000b3254e in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:220 #3 #4 0x00007fe87efcc5c9 in raise () from /lib64/libc.so.6 #5 0x00007fe87efcdcd8 in abort () from /lib64/libc.so.6 #6 0x00000000015a98fb in ut_dbg_assertion_failed (expr=0x0, file=0x1bd0878 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0ut.cc", line=904) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67 #7 0x00000000015ae0f0 in ib::fatal::~fatal (this=0x7fe869b421f0, __in_chrg=) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/ut/ut0ut.cc:904 #8 0x000000000155c71b in sync_array_wait_event (arr=0x3f63a20, cell=@0x7fe869b423a8: 0x7fe8806000e0) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/sync/sync0arr.cc:433 #9 0x000000000155f983 in rw_lock_x_lock_wait_func (lock=0x7fe86ac44458, pass=0, threshold=0, file_name=0x1bdaed0 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc", line=1830) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/sync/sync0rw.cc:509 #10 0x000000000155fa87 in rw_lock_x_lock_low (lock=0x7fe86ac44458, pass=0, file_name=0x1bdaed0 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc", line=1830) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/sync/sync0rw.cc:556 #11 0x000000000155fead in rw_lock_x_lock_func (lock=0x7fe86ac44458, pass=0, file_name=0x1bdaed0 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc", line=1830) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/sync/sync0rw.cc:721 #12 0x00000000015fd720 in pfs_rw_lock_x_lock_func (lock=0x7fe86ac44458, pass=0, file_name=0x1bdaed0 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc", line=1830) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/include/sync0rw.ic:736 #13 0x000000000160bf5a in buf_page_get_gen (page_id=..., page_size=..., rw_latch=2, guess=0x0, mode=10, file=0x1bdaed0 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc", line=1830, mtr=0x7fe869b45a10, dirty_with_no_latch=false) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/buf/buf0buf.cc:4411 #14 0x00000000015d1b4e in btr_block_get_func (page_id=..., page_size=..., mode=2, file=0x1bdaed0 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc", line=1830, index=0x40de8f8, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/include/btr0btr.ic:63 #15 0x00000000015d74e6 in btr_cur_search_to_nth_level (index=0x40de8f8, level=2, tuple=0x7fe7f4031b78, mode=PAGE_CUR_LE, latch_mode=34, cursor=0x7fe869b43a80, has_search_latch=0, file=0x1bd5560 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc", line=2297, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:1830 #16 0x00000000015c210d in btr_insert_on_non_leaf_level_func (flags=7, index=0x40de8f8, level=2, tuple=0x7fe7f4031b78, file=0x1bd5560 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc", line=2297, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2144 #17 0x00000000015c2885 in btr_attach_half_pages (flags=7, index=0x40de8f8, block=0x7fe86ac32ec0, split_rec=0x7fe7f40386bd "", new_block=0x7fe86ac39040, direction=111, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2297 #18 0x00000000015c3b94 in btr_page_split_and_insert (flags=7, cursor=0x7fe869b44990, offsets=0x7fe869b454a8, heap=0x7fe869b454b0, tuple=0x7fe7f402ac88, n_ext=0, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2699 #19 0x00000000015db147 in btr_cur_pessimistic_insert (flags=7, cursor=0x7fe869b44990, offsets=0x7fe869b454a8, heap=0x7fe869b454b0, entry=0x7fe7f402ac88, rec=0x7fe869b454b8, big_rec=0x7fe869b454c0, n_ext=0, thr=0x0, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:3418 #20 0x00000000015c228c in btr_insert_on_non_leaf_level_func (flags=3, index=0x40de8f8, level=1, tuple=0x7fe7f402ac88, file=0x1bd5560 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc", line=2297, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2176 #21 0x00000000015c2885 in btr_attach_half_pages (flags=3, index=0x40de8f8, block=0x7fe86ac42900, split_rec=0x7fe7f4017bbc "", new_block=0x7fe86ac3f1c0, direction=111, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2297 #22 0x00000000015c3b94 in btr_page_split_and_insert (flags=3, cursor=0x7fe869b45920, offsets=0x7fe869b46448, heap=0x7fe869b46450, tuple=0x7fe7f405afe8, n_ext=0, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0btr.cc:2699 #23 0x00000000015db147 in btr_cur_pessimistic_insert (flags=3, cursor=0x7fe869b45920, offsets=0x7fe869b46448, heap=0x7fe869b46450, entry=0x7fe7f405afe8, rec=0x7fe869b46438, big_rec=0x7fe869b46458, n_ext=0, thr=0x7fe7f4027858, mtr=0x7fe869b45a10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:3418 #24 0x000000000141bd62 in ibuf_insert_low (mode=32801, op=IBUF_OP_INSERT, no_counter=0, entry=0x7fe7f40176c0, entry_size=16, index=0x7fe7f40153b8, page_id=..., page_size=..., thr=0x7fe7f4027858) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/ibuf/ibuf0ibuf.cc:3625 #25 0x000000000141c36a in ibuf_insert (op=IBUF_OP_INSERT, entry=0x7fe7f40176c0, index=0x7fe7f40153b8, page_id=..., page_size=..., thr=0x7fe7f4027858) ---Type to continue, or q to quit--- at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/ibuf/ibuf0ibuf.cc:3814 #26 0x00000000015d565e in btr_cur_search_to_nth_level (index=0x7fe7f40153b8, level=0, tuple=0x7fe7f40176c0, mode=PAGE_CUR_LE, latch_mode=2, cursor=0x7fe869b47620, has_search_latch=0, file=0x1b98640 "/export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc", line=2844, mtr=0x7fe869b479d0) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/btr/btr0cur.cc:1109 #27 0x00000000014cb327 in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7fe7f40153b8, offsets_heap=0x7fe7f4077a10, heap=0x7fe7f402a320, entry=0x7fe7f40176c0, trx_id=0, thr=0x7fe7f4027858, dup_chk_only=false) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:2844 #28 0x00000000014cc554 in row_ins_sec_index_entry (index=0x7fe7f40153b8, entry=0x7fe7f40176c0, thr=0x7fe7f4027858, dup_chk_only=false) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3252 #29 0x00000000014cc6d0 in row_ins_index_entry (index=0x7fe7f40153b8, entry=0x7fe7f40176c0, thr=0x7fe7f4027858) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3298 #30 0x00000000014ccb2c in row_ins_index_entry_step (node=0x7fe7f4027610, thr=0x7fe7f4027858) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3437 #31 0x00000000014ccec0 in row_ins (node=0x7fe7f4027610, thr=0x7fe7f4027858) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3579 #32 0x00000000014cd4c5 in row_ins_step (thr=0x7fe7f4027858) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0ins.cc:3762 #33 0x00000000014e9997 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7fe7f402c160 , prebuilt=0x7fe7f4027118) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:1675 #34 0x00000000014e9ec5 in row_insert_for_mysql (mysql_rec=0x7fe7f402c160 , prebuilt=0x7fe7f4027118) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/row/row0mysql.cc:1786 #35 0x00000000013c9af3 in ha_innobase::write_row (this=0x7fe7f402be90, record=0x7fe7f402c160 ) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:6685 #36 0x0000000000ba68f6 in handler::ha_write_row (this=0x7fe7f402be90, buf=0x7fe7f402c160 ) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/handler.cc:7323 #37 0x00000000011b141d in write_record (thd=0x7fe7f4011c10, table=0x7fe7f402b510, info=0x7fe869b49880, update=0x7fe869b49900) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:1676 #38 0x00000000011aedb1 in mysql_insert (thd=0x7fe7f4011c10, table_list=0x7fe7f4064338, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/sql_insert.cc:704 #39 0x0000000000fda4ae in mysql_execute_command (thd=0x7fe7f4011c10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:3297 #40 0x0000000000fe03eb in mysql_parse (thd=0x7fe7f4011c10, parser_state=0x7fe869b4ae50) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5356 #41 0x0000000000fd517b in dispatch_command (command=COM_QUERY, thd=0x7fe7f4011c10, packet=0x7fe7f4007841 "INSERT INTO t1 VALUES (CONVERT(_ucs2 0x064A062706310634062706370631 USING utf8))", packet_length=80) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1203 #42 0x0000000000fd3eca in do_command (thd=0x7fe7f4011c10) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:789 #43 0x00000000010df974 in handle_connection (arg=0x40e7950) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298 #44 0x0000000001348de3 in pfs_spawn_thread (arg=0x42377f0) at /export/home/pb2/build/sb_0-14236670-1422462446.39/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137 #45 0x00007fe8803c1df3 in start_thread () from /lib64/libpthread.so.0 #46 0x00007fe87f08d47d in clone () from /lib64/libc.so.6