### // 5.6.30 rm -rf 81033 scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.30 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033 bin/mysqld --log-bin --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.30 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033/log.err 2>&1 & -- Started provisioning some datadir and run flush logs in between [umshastr@hod03]~/bugs/sysbench: sysbench/sysbench --test=/home/umshastr/bugs/sysbench/sysbench/tests/db/update_index.lua --report-interval=10 --oltp-table-size=1000000 --max-time=0 --oltp-read-only=off --max-requests=0 --num-threads=1000 --db-driver=mysql --mysql-socket=/tmp/mysql_ushastry.sock --mysql-db=test --mysql-user=root run ### Edited index file, inserted newline (in vi O) [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.30-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show master logs; Empty set (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> show master logs; Empty set (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> flush logs; *** Error in `bin/mysqld': free(): corrupted unsorted chunks: 0x00007f6740010ab0 *** ======= Backtrace: ========= /lib64/libc.so.6(+0x7d1fd)[0x7f677f6d81fd] bin/mysqld(end_io_cache+0x58)[0x92e908] bin/mysqld(_ZN13MYSQL_BIN_LOG5closeEj+0x77)[0x8edad7] bin/mysqld(_ZN13MYSQL_BIN_LOG13new_file_implEbP28Format_description_log_event+0x463)[0x8f3743] bin/mysqld(_ZN13MYSQL_BIN_LOG6rotateEbPb+0x3e)[0x8f3a4e] bin/mysqld(_ZN13MYSQL_BIN_LOG16rotate_and_purgeEP3THDb+0x8a)[0x8f60aa] bin/mysqld(_Z20reload_acl_and_cacheP3THDmP10TABLE_LISTPi+0x6ba)[0x74083a] bin/mysqld(_Z21mysql_execute_commandP3THD+0x7a1)[0x7256a1] bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x338)[0x72bfa8] bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc60)[0x72d380] bin/mysqld(_Z10do_commandP3THD+0xd7)[0x72f177] bin/mysqld(_Z24do_handle_one_connectionP3THD+0x116)[0x6f6236] bin/mysqld(handle_one_connection+0x45)[0x6f6315] bin/mysqld(pfs_spawn_thread+0x126)[0xb123c6] /lib64/libpthread.so.0(+0x7df5)[0x7f6780a85df5] /lib64/libc.so.6(clone+0x6d)[0x7f677f75160d] ======= Memory map: ======== 00400000-010aa000 r-xp 00000000 08:01 17635624573 /export/umesh/server/binaries/mysql-advanced-5.6.30/bin/mysqld 012a9000-0147d000 rw-p 00ca9000 08:01 17635624573 /export/umesh/server/binaries/mysql-advanced-5.6.30/bin/mysqld 0147d000-014d3000 rw-p 00000000 00:00 0 02fe3000-037b2000 rw-p 00000000 00:00 0 [heap] 7f673c000000-7f673c021000 rw-p 00000000 00:00 0 7f673c021000-7f6740000000 ---p 00000000 00:00 0 7f6740000000-7f6740027000 rw-p 00000000 00:00 0 7f6740027000-7f6744000000 ---p 00000000 00:00 0 7f6744000000-7f6744021000 rw-p 00000000 00:00 0 7f6744021000-7f6748000000 ---p 00000000 00:00 0 7f6748000000-7f6748021000 rw-p 00000000 00:00 0 7f6748021000-7f674c000000 ---p 00000000 00:00 0 7f674c000000-7f674c02c000 rw-p 00000000 00:00 0 7f674c02c000-7f6750000000 ---p 00000000 00:00 0 7f6750590000-7f6750591000 ---p 00000000 00:00 0 7f6750591000-7f6750f91000 rw-p 00000000 00:00 0 [stack:17105] 7f6750f91000-7f6750f92000 ---p 00000000 00:00 0 7f6750f92000-7f6751992000 rw-p 00000000 00:00 0 [stack:17104] 7f6751992000-7f6751993000 ---p 00000000 00:00 0 7f6751993000-7f6752393000 rw-p 00000000 00:00 0 [stack:17103] 7f6752393000-7f6752394000 ---p 00000000 00:00 0 7f6752394000-7f6752d94000 rw-p 00000000 00:00 0 [stack:17102] 7f6752d94000-7f6752d95000 ---p 00000000 00:00 0 7f6752d95000-7f6753795000 rw-p 00000000 00:00 0 [stack:17101] 7f6753795000-7f6753796000 ---p 00000000 00:00 0 7f6753796000-7f6754196000 rw-p 00000000 00:00 0 [stack:17099] 7f6754196000-7f6754197000 ---p 00000000 00:00 0 7f6754197000-7f6754b97000 rw-p 00000000 00:00 0 [stack:17098] 7f6754b97000-7f6754b98000 ---p 00000000 00:00 0 7f6754b98000-7f6755598000 rw-p 00000000 00:00 0 [stack:17097] 7f6755598000-7f6755599000 ---p 00000000 00:00 0 7f6755599000-7f6756226000 rw-p 00000000 00:00 0 [stack:17100] 7f67565c2000-7f67565c3000 ---p 00000000 00:00 0 7f67565c3000-7f6756603000 rw-p 00000000 00:00 0 [stack:17109] 7f6756603000-7f6756604000 ---p 00000000 00:00 0 7f6756604000-7f6756644000 rw-p 00000000 00:00 0 [stack:17106] 7f6756644000-7f6756645000 ---p 00000000 00:00 0 7f6756645000-7f6757045000 rw-p 00000000 00:00 0 [stack:17095] 7f6757045000-7f6757046000 ---p 00000000 00:00 0 7f6757046000-7f6757a46000 rw-p 00000000 00:00 0 [stack:17094] 7f6757a46000-7f6757a47000 ---p 00000000 00:00 0 7f6757a47000-7f6758447000 rw-p 00000000 00:00 0 [stack:17093] 7f6758447000-7f6758448000 ---p 00000000 00:00 0 7f6758448000-7f6758e48000 rw-p 00000000 00:00 0 [stack:17092] 7f6758e48000-7f6758e49000 ---p 00000000 00:00 0 7f6758e49000-7f6759849000 rw-p 00000000 00:00 0 [stack:17091] 7f6759849000-7f675984a000 ---p 00000000 00:00 0 7f675984a000-7f675a24a000 rw-p 00000000 00:00 0 [stack:17090] 7f675a24a000-7f675a24b000 ---p 00000000 00:00 0 7f675a24b000-7f675ac4b000 rw-p 00000000 00:00 0 [stack:17089] 7f675ac4b000-7f675ac4c000 ---p 00000000 00:00 0 7f675ac4c000-7f675b64c000 rw-p 00000000 00:00 0 [stack:17088] 7f675b64c000-7f675b64d000 ---p 00000000 00:00 0 7f675b64d000-7f675c04d000 rw-p 00000000 00:00 0 [stack:17087] 7f675c04d000-7f675c04e000 ---p 00000000 00:00 0 7f675c04e000-7f677f458000 rw-p 00000000 00:00 0 [stack:17086] 7f677f458000-7f677f45a000 r-xp 00000000 08:12 100665757 /usr/lib64/libfreebl3.so 7f677f45a000-7f677f659000 ---p 00002000 08:12 100665757 /usr/lib64/libfreebl3.so 7f677f659000-7f677f65a000 r--p 00001000 08:12 100665757 /usr/lib64/libfreebl3.so 7f677f65a000-7f677f65b000 rw-p 00002000 08:12 100665757 /usr/lib64/libfreebl3.so 7f677f65b000-7f677f80f000 r-xp 00000000 08:12 100664792 /usr/lib64/libc-2.17.so 7f677f80f000-7f677fa0f000 ---p 001b4000 08:12 100664792 /usr/lib64/libc-2.17.so 7f677fa0f000-7f677fa13000 r--p 001b4000 08:12 100664792 /usr/lib64/libc-2.17.so 7f677fa13000-7f677fa15000 rw-p 001b8000 08:12 100664792 /usr/lib64/libc-2.17.so 7f677fa15000-7f677fa1a000 rw-p 00000000 00:00 0 7f677fa1a000-7f677fa2f000 r-xp 00000000 08:12 103049851 /usr/lib64/libgcc_s-4.8.3-20140911.so.1 7f677fa2f000-7f677fc2e000 ---p 00015000 08:12 103049851 /usr/lib64/libgcc_s-4.8.3-20140911.so.1 7f677fc2e000-7f677fc2f000 r--p 00014000 08:12 103049851 /usr/lib64/libgcc_s-4.8.3-20140911.so.1 7f677fc2f000-7f677fc30000 rw-p 00015000 08:12 103049851 /usr/lib64/libgcc_s-4.8.3-20140911.so.1 7f677fc30000-7f677fd31000 r-xp 00000000 08:12 100666144 /usr/lib64/libm-2.17.so 7f677fd31000-7f677ff30000 ---p 00101000 08:12 100666144 /usr/lib64/libm-2.17.so 7f677ff30000-7f677ff31000 r--p 00100000 08:12 100666144 /usr/lib64/libm-2.17.so 7f677ff31000-7f677ff32000 rw-p 00101000 08:12 100666144 /usr/lib64/libm-2.17.so 7f677ff32000-7f678001b000 r-xp 00000000 08:12 100666515 /usr/lib64/libstdc++.so.6.0.19 7f678001b000-7f678021a000 ---p 000e9000 08:12 100666515 /usr/lib64/libstdc++.so.6.0.19 7f678021a000-7f6780222000 r--p 000e8000 08:12 100666515 /usr/lib64/libstdc++.so.6.0.19 7f6780222000-7f6780224000 rw-p 000f0000 08:12 100666515 /usr/lib64/libstdc++.so.6.0.19 7f6780224000-7f6780239000 rw-p 00000000 00:00 0 7f6780239000-7f678023c000 r-xp 00000000 08:12 100666142 /usr/lib64/libdl-2.17.so 7f678023c000-7f678043b000 ---p 00003000 08:12 100666142 /usr/lib64/libdl-2.17.so 7f678043b000-7f678043c000 r--p 00002000 08:12 100666142 /usr/lib64/libdl-2.17.so 7f678043c000-7f678043d000 rw-p 00003000 08:12 100666142 /usr/lib64/libdl-2.17.so 7f678043d000-7f6780445000 r-xp 00000000 08:12 100666140 /usr/lib64/libcrypt-2.17.so 7f6780445000-7f6780644000 ---p 00008000 08:12 100666140 /usr/lib64/libcrypt-2.17.so 7f6780644000-7f6780645000 r--p 00007000 08:12 100666140 /usr/lib64/libcrypt-2.17.so 7f6780645000-7f6780646000 rw-p 00008000 08:12 100666140 /usr/lib64/libcrypt-2.17.so 7f6780646000-7f6780674000 rw-p 00000000 00:00 0 7f6780674000-7f678067b000 r-xp 00000000 08:12 100666168 /usr/lib64/librt-2.17.so 7f678067b000-7f678087a000 ---p 00007000 08:12 100666168 /usr/lib64/librt-2.17.so 7f678087a000-7f678087b000 r--p 00006000 08:12 100666168 /usr/lib64/librt-2.17.so 7f678087b000-7f678087c000 rw-p 00007000 08:12 100666168 /usr/lib64/librt-2.17.so 7f678087c000-7f678087d000 r-xp 00000000 08:12 100669712 /usr/lib64/libaio.so.1.0.1 7f678087d000-7f6780a7c000 ---p 00001000 08:12 100669712 /usr/lib64/libaio.so.1.0.1 7f6780a7c000-7f6780a7d000 r--p 00000000 08:12 100669712 /usr/lib64/libaio.so.1.0.1 7f6780a7d000-7f6780a7e000 rw-p 00001000 08:12 100669712 /usr/lib64/libaio.so.1.0.1 7f6780a7e000-7f6780a94000 r-xp 00000000 08:12 100666163 /usr/lib64/libpthread-2.17.so 7f6780a94000-7f6780c94000 ---p 00016000 08:12 100666163 /usr/lib64/libpthread-2.17.so 7f6780c94000-7f6780c95000 r--p 00016000 08:12 100666163 /usr/lib64/libpthread-2.17.so 7f6780c95000-7f6780c96000 rw-p 00017000 08:12 100666163 /usr/lib64/libpthread-2.17.so 7f6780c96000-7f6780c9a000 rw-p 00000000 00:00 0 7f6780c9a000-7f6780cbb000 r-xp 00000000 08:12 100664785 /usr/lib64/ld-2.17.so 7f6780cc2000-7f6780e9b000 rw-p 00000000 00:00 0 7f6780e9b000-7f6780ebb000 rw-p 00000000 00:00 0 7f6780ebb000-7f6780ebc000 r--p 00021000 08:12 100664785 /usr/lib64/ld-2.17.so 7f6780ebc000-7f6780ebd000 rw-p 00022000 08:12 100664785 /usr/lib64/ld-2.17.so 7f6780ebd000-7f6780ebe000 rw-p 00000000 00:00 0 7ffc87510000-7ffc87531000 rw-p 00000000 00:00 0 [stack] 7ffc875d7000-7ffc875d9000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> \q Bye [1]+ Aborted (core dumped) bin/mysqld --log-bin --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.30 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033/log.err 2>&1 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: ## [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: cat hod03-bin.index ./hod03-bin.000022 ./hod03-bin.000023 ./hod03-bin.000024 ## bt (gdb) bt #0 0x00007f6780a8a771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000006a4faa in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/signal_handler.cc:230 #2 #3 0x00007f677f6905d7 in raise () from /lib64/libc.so.6 #4 0x00007f677f691cc8 in abort () from /lib64/libc.so.6 #5 0x00007f677f6d0e07 in __libc_message () from /lib64/libc.so.6 #6 0x00007f677f6d81fd in _int_free () from /lib64/libc.so.6 #7 0x000000000092e908 in end_io_cache (info=0x14a4228 ) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/mysys/mf_iocache.c:1863 #8 0x00000000008edad7 in MYSQL_BIN_LOG::close (this=0x14a3c80 , exiting=3) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/binlog.cc:6123 #9 0x00000000008f3743 in MYSQL_BIN_LOG::new_file_impl (this=0x14a3c80 , need_lock_log=false, extra_description_event=0x0) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/binlog.cc:4973 #10 0x00000000008f3a4e in MYSQL_BIN_LOG::rotate (this=0x42bd, force_rotate=, check_purge=0x7f67566003bf) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/binlog.cc:5462 #11 0x00000000008f60aa in MYSQL_BIN_LOG::rotate_and_purge (this=0x14a3c80 , thd=, force_rotate=true) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/binlog.cc:5520 #12 0x000000000074083a in reload_acl_and_cache (thd=0x360e320, options=16130, tables=0x0, write_to_binlog=0x7f6756601170) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/sql_reload.cc:167 #13 0x00000000007256a1 in mysql_execute_command (thd=0x360e320) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/sql_parse.cc:4201 #14 0x000000000072bfa8 in mysql_parse (thd=0x360e320, rawbuf=, length=, parser_state=0x360e388) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/sql_parse.cc:6385 #15 0x000000000072d380 in dispatch_command (command=COM_QUERY, thd=0x360e320, packet=, packet_length=10) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/sql_parse.cc:1339 #16 0x000000000072f177 in do_command (thd=0x360e320) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/sql_parse.cc:1036 #17 0x00000000006f6236 in do_handle_one_connection (thd_arg=0x360e320) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/sql_connect.cc:982 #18 0x00000000006f6315 in handle_one_connection (arg=0x360e320) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/sql_connect.cc:898 #19 0x0000000000b123c6 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/storage/perfschema/pfs.cc:1860 #20 0x00007f6780a85df5 in start_thread () from /lib64/libpthread.so.0 #21 0x00007f677f75160d in clone () from /lib64/libc.so.6 (gdb) ## restarted instance, and in the second set of reset master+flush logs [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: bin/mysqld --log-bin --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.30 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033/log.err 2>&1 & [1] 17475 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: 2016-04-14 12:26:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-04-14 12:26:43 0 [Note] bin/mysqld (mysqld 5.6.30-enterprise-commercial-advanced-log) starting as process 17475 ... [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.30-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> show master logs; Empty set (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> show master logs; Empty set (0.00 sec) mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> reset master; ERROR 1373 (HY000): Target log not found in binlog index mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; Query OK, 0 rows affected (0.00 sec) mysql> flush logs; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_ushastry.sock' (111) ERROR: Can't connect to the server mysql> \q Bye [1]+ Segmentation fault (core dumped) bin/mysqld --log-bin --basedir=/export/umesh/server/binaries/mysql-advanced-5.6.30 --datadir=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/mysql-advanced-5.6.30/81033/log.err 2>&1 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: -- extract from error log 2016-04-14 12:29:52 17475 [ERROR] Failed to locate old binlog or relay log files 10:30:12 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68108 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 bin/mysqld(my_print_stacktrace+0x35)[0x9409a5] bin/mysqld(handle_fatal_signal+0x3d8)[0x6a4f88] /lib64/libpthread.so.0(+0xf130)[0x7ff6c43d5130] /lib64/libc.so.6(+0x7e1f6)[0x7ff6c30211f6] /lib64/libc.so.6(__libc_malloc+0x5c)[0x7ff6c302318c] /lib64/libstdc++.so.6(_Znwm+0x1d)[0x7ff6c38d90ad] bin/mysqld(_Z26handle_connections_socketsv+0x32f)[0x5b0e0f] bin/mysqld(_Z11mysqld_mainiPPc+0xbd2)[0x5b6e72] /lib64/libc.so.6(__libc_start_main+0xf5)[0x7ff6c2fc4af5] bin/mysqld(__gxx_personality_v0+0x2d9)[0x5aa6c9] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file (gdb) bt #0 0x00007ff6c43d2771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000006a4faa in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/signal_handler.cc:230 #2 #3 0x00007ff6c30211f6 in _int_malloc () from /lib64/libc.so.6 #4 0x00007ff6c302318c in malloc () from /lib64/libc.so.6 #5 0x00007ff6c38d90ad in operator new(unsigned long) () from /lib64/libstdc++.so.6 #6 0x00000000005b0e0f in handle_connections_sockets () at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/mysqld.cc:6424 #7 0x00000000005b6e72 in mysqld_main (argc=12, argv=0x2f6fcd0) at /export/home/pb2/build/sb_0-18153926-1457020071.96/mysqlcom-pro-5.6.30/sql/mysqld.cc:5689 #8 0x00007ff6c2fc4af5 in __libc_start_main () from /lib64/libc.so.6 #9 0x00000000005aa6c9 in _start () (gdb) [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.30: cat 81033/hod03-bin.index ./hod03-bin.000022 ./hod03-bin.000023 ./hod03-bin.000024 ./hod03-bin.000025 ./hod03-bin.000026 ./hod03-bin.000027 ./hod03-bin.000028 ./hod03-bin.000029 ./hod03-bin.000030 ./hod03-bin.000031 ./hod03-bin.000032 ./hod03-bin.000033 ./hod03-bin.000034 ./hod03-bin.000035 ./hod03-bin.000036 ./hod03-bin.000037 ./hod03-bin.000038 ./hod03-bin.000039 ./hod03-bin.000040 ./hod03-bin.000041 ./hod03-bin.000042 ./hod03-bin.000043 ./hod03-bin.000044 ./hod03-bin.000045 ./hod03-bin.000046 ./hod03-bin.000047 ./hod03-bin.000048 ./hod03-bin.000049 ./hod03-bin.000050 ./hod03-bin.000051 ./hod03-bin.000052 ./hod03-bin.000053 ./hod03-bin.000054 ./hod03-bin.000055 ./hod03-bin.000056