23:44: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=1073741824 read_buffer_size=131072 max_used_connections=5 max_threads=500 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 = 1247400 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f81fae59640 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 = 7f8509bf3808 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8cea15] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65e0d4] /lib64/libpthread.so.0[0x3b2160f500] /lib64/libc.so.6(memcpy+0x35)[0x3b21289895] /usr/lib64/mysql/plugin//innodb_engine.so(+0xb879)[0x7f9864613879] /usr/lib64/mysql/plugin//innodb_engine.so(innodb_api_search+0x44a)[0x7f986461490a] /usr/lib64/mysql/plugin//innodb_engine.so(+0x9e4e)[0x7f9864611e4e] /usr/lib64/mysql/plugin/libmemcached.so(+0xdaeb)[0x7f97e532eaeb] /usr/lib64/mysql/plugin/libmemcached.so(+0x15930)[0x7f97e5336930] /usr/lib64/mysql/plugin/libmemcached.so(+0x16dbb)[0x7f97e5337dbb] /usr/lib64/mysql/plugin/libmemcached.so(conn_parse_cmd+0x11)[0x7f97e5338831] /usr/lib64/mysql/plugin/libmemcached.so(+0x9d8c)[0x7f97e532ad8c] /usr/lib64/mysql/plugin/libmemcached.so(event_base_loop+0x286)[0x7f97e533cff6] /usr/lib64/mysql/plugin/libmemcached.so(+0x19a42)[0x7f97e533aa42] /lib64/libpthread.so.0[0x3b21607851] /lib64/libc.so.6(clone+0x6d)[0x3b212e894d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 187464915 Status: NOT_KILLED 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. 131213 17:44:13 mysqld_safe Number of processes running now: 0 131213 17:44:13 mysqld_safe mysqld restarted 2013-12-13 17:44:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 17:44:14 30722 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 17:44:14 7f2e248cd720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 17:44:14 30722 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 17:44:14 30722 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 17:44:14 30722 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 17:44:14 30722 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 17:44:14 30722 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 17:44:18 30722 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 17:44:18 30722 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 17:44:18 30722 [Note] InnoDB: Log scan progressed past the checkpoint lsn 690073164172 2013-12-13 17:44:18 30722 [Note] InnoDB: Database was not shutdown normally! 2013-12-13 17:44:18 30722 [Note] InnoDB: Starting crash recovery. 2013-12-13 17:44:18 30722 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-12-13 17:44:18 30722 [Note] InnoDB: Restoring possible half-written data pages 2013-12-13 17:44:18 30722 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 690078406656 InnoDB: Doing recovery: scanned up to log sequence number 690083649536 InnoDB: Doing recovery: scanned up to log sequence number 690088892416 InnoDB: Doing recovery: scanned up to log sequence number 690094135296 InnoDB: Doing recovery: scanned up to log sequence number 690099378176 InnoDB: Doing recovery: scanned up to log sequence number 690104621056 InnoDB: Doing recovery: scanned up to log sequence number 690109863936 InnoDB: Doing recovery: scanned up to log sequence number 690115106816 InnoDB: Doing recovery: scanned up to log sequence number 690120349696 InnoDB: Doing recovery: scanned up to log sequence number 690125592576 InnoDB: Doing recovery: scanned up to log sequence number 690130835456 InnoDB: Doing recovery: scanned up to log sequence number 690136078336 InnoDB: Doing recovery: scanned up to log sequence number 690141321216 InnoDB: Doing recovery: scanned up to log sequence number 690146564096 InnoDB: Doing recovery: scanned up to log sequence number 690151806976 InnoDB: Doing recovery: scanned up to log sequence number 690157049856 InnoDB: Doing recovery: scanned up to log sequence number 690162292736 InnoDB: Doing recovery: scanned up to log sequence number 690167535616 InnoDB: Doing recovery: scanned up to log sequence number 690172778496 InnoDB: Doing recovery: scanned up to log sequence number 690178021376 InnoDB: Doing recovery: scanned up to log sequence number 690183264256 InnoDB: Doing recovery: scanned up to log sequence number 690188507136 InnoDB: Doing recovery: scanned up to log sequence number 690193750016 InnoDB: Doing recovery: scanned up to log sequence number 690198992896 InnoDB: Doing recovery: scanned up to log sequence number 690204235776 InnoDB: Doing recovery: scanned up to log sequence number 690209478656 InnoDB: Doing recovery: scanned up to log sequence number 690214721536 InnoDB: Doing recovery: scanned up to log sequence number 690219964416 InnoDB: Doing recovery: scanned up to log sequence number 690225207296 InnoDB: Doing recovery: scanned up to log sequence number 690230450176 InnoDB: Doing recovery: scanned up to log sequence number 690235693056 InnoDB: Doing recovery: scanned up to log sequence number 690240935936 InnoDB: Doing recovery: scanned up to log sequence number 690246178816 InnoDB: Doing recovery: scanned up to log sequence number 690251421696 InnoDB: Doing recovery: scanned up to log sequence number 690256664576 InnoDB: Doing recovery: scanned up to log sequence number 690261907456 InnoDB: Doing recovery: scanned up to log sequence number 690267150336 InnoDB: Doing recovery: scanned up to log sequence number 690272393216 InnoDB: Doing recovery: scanned up to log sequence number 690277636096 InnoDB: Doing recovery: scanned up to log sequence number 690282878976 InnoDB: Doing recovery: scanned up to log sequence number 690288121856 InnoDB: Doing recovery: scanned up to log sequence number 690293364736 InnoDB: Doing recovery: scanned up to log sequence number 690298607616 InnoDB: Doing recovery: scanned up to log sequence number 690303850496 InnoDB: Doing recovery: scanned up to log sequence number 690309093376 InnoDB: Doing recovery: scanned up to log sequence number 690314336256 InnoDB: Doing recovery: scanned up to log sequence number 690319579136 InnoDB: Doing recovery: scanned up to log sequence number 690324822016 InnoDB: Doing recovery: scanned up to log sequence number 690330064896 InnoDB: Doing recovery: scanned up to log sequence number 690335307776 InnoDB: Doing recovery: scanned up to log sequence number 690340550656 InnoDB: Doing recovery: scanned up to log sequence number 690345793536 InnoDB: Doing recovery: scanned up to log sequence number 690351036416 InnoDB: Doing recovery: scanned up to log sequence number 690356279296 InnoDB: Doing recovery: scanned up to log sequence number 690361522176 InnoDB: Doing recovery: scanned up to log sequence number 690366765056 InnoDB: Doing recovery: scanned up to log sequence number 690372007936 InnoDB: Doing recovery: scanned up to log sequence number 690377250816 InnoDB: Doing recovery: scanned up to log sequence number 690382493696 InnoDB: Doing recovery: scanned up to log sequence number 690387736576 InnoDB: Doing recovery: scanned up to log sequence number 690392979456 InnoDB: Doing recovery: scanned up to log sequence number 690398222336 InnoDB: Doing recovery: scanned up to log sequence number 690403465216 InnoDB: Doing recovery: scanned up to log sequence number 690408708096 InnoDB: Doing recovery: scanned up to log sequence number 690413950976 InnoDB: Doing recovery: scanned up to log sequence number 690419193856 InnoDB: Doing recovery: scanned up to log sequence number 690424436736 InnoDB: Doing recovery: scanned up to log sequence number 690429679616 InnoDB: Doing recovery: scanned up to log sequence number 690434922496 InnoDB: Doing recovery: scanned up to log sequence number 690440165376 InnoDB: Doing recovery: scanned up to log sequence number 690445408256 InnoDB: Doing recovery: scanned up to log sequence number 690450651136 InnoDB: Doing recovery: scanned up to log sequence number 690455894016 InnoDB: Doing recovery: scanned up to log sequence number 690461136896 InnoDB: Doing recovery: scanned up to log sequence number 690466379776 InnoDB: Doing recovery: scanned up to log sequence number 690471622656 InnoDB: Doing recovery: scanned up to log sequence number 690476865536 InnoDB: Doing recovery: scanned up to log sequence number 690482108416 InnoDB: Doing recovery: scanned up to log sequence number 690487351296 InnoDB: Doing recovery: scanned up to log sequence number 690492594176 InnoDB: Doing recovery: scanned up to log sequence number 690497837056 InnoDB: Doing recovery: scanned up to log sequence number 690503079936 InnoDB: Doing recovery: scanned up to log sequence number 690508322816 InnoDB: Doing recovery: scanned up to log sequence number 690513565696 InnoDB: Doing recovery: scanned up to log sequence number 690518808576 InnoDB: Doing recovery: scanned up to log sequence number 690524051456 InnoDB: Doing recovery: scanned up to log sequence number 690529294336 InnoDB: Doing recovery: scanned up to log sequence number 690534537216 InnoDB: Doing recovery: scanned up to log sequence number 690539780096 InnoDB: Doing recovery: scanned up to log sequence number 690545022976 InnoDB: Doing recovery: scanned up to log sequence number 690550265856 InnoDB: Doing recovery: scanned up to log sequence number 690555508736 InnoDB: Doing recovery: scanned up to log sequence number 690560751616 InnoDB: Doing recovery: scanned up to log sequence number 690565994496 InnoDB: Doing recovery: scanned up to log sequence number 690571237376 InnoDB: Doing recovery: scanned up to log sequence number 690576480256 InnoDB: Doing recovery: scanned up to log sequence number 690581723136 InnoDB: Doing recovery: scanned up to log sequence number 690586966016 InnoDB: Doing recovery: scanned up to log sequence number 690592208896 InnoDB: Doing recovery: scanned up to log sequence number 690597451776 InnoDB: Doing recovery: scanned up to log sequence number 690602694656 InnoDB: Doing recovery: scanned up to log sequence number 690607937536 InnoDB: Doing recovery: scanned up to log sequence number 690613180416 InnoDB: Doing recovery: scanned up to log sequence number 690618423296 InnoDB: Doing recovery: scanned up to log sequence number 690623666176 InnoDB: Doing recovery: scanned up to log sequence number 690628909056 InnoDB: Doing recovery: scanned up to log sequence number 690634151936 InnoDB: Doing recovery: scanned up to log sequence number 690639394816 InnoDB: Doing recovery: scanned up to log sequence number 690644637696 InnoDB: Doing recovery: scanned up to log sequence number 690649880576 InnoDB: Doing recovery: scanned up to log sequence number 690655123456 InnoDB: Doing recovery: scanned up to log sequence number 690660366336 InnoDB: Doing recovery: scanned up to log sequence number 690665609216 InnoDB: Doing recovery: scanned up to log sequence number 690670852096 InnoDB: Doing recovery: scanned up to log sequence number 690676094976 InnoDB: Doing recovery: scanned up to log sequence number 690681337856 InnoDB: Doing recovery: scanned up to log sequence number 690686580736 InnoDB: Doing recovery: scanned up to log sequence number 690691823616 InnoDB: Doing recovery: scanned up to log sequence number 690697066496 InnoDB: Doing recovery: scanned up to log sequence number 690702309376 InnoDB: Doing recovery: scanned up to log sequence number 690707552256 InnoDB: Doing recovery: scanned up to log sequence number 690712795136 InnoDB: Doing recovery: scanned up to log sequence number 690718038016 InnoDB: Doing recovery: scanned up to log sequence number 690723280896 InnoDB: Doing recovery: scanned up to log sequence number 690728523776 InnoDB: Doing recovery: scanned up to log sequence number 690733766656 InnoDB: Doing recovery: scanned up to log sequence number 690739009536 InnoDB: Doing recovery: scanned up to log sequence number 690744252416 InnoDB: Doing recovery: scanned up to log sequence number 690749495296 InnoDB: Doing recovery: scanned up to log sequence number 690754738176 InnoDB: Doing recovery: scanned up to log sequence number 690759981056 InnoDB: Doing recovery: scanned up to log sequence number 690765223936 InnoDB: Doing recovery: scanned up to log sequence number 690770466816 InnoDB: Doing recovery: scanned up to log sequence number 690775709696 InnoDB: Doing recovery: scanned up to log sequence number 690780952576 InnoDB: Doing recovery: scanned up to log sequence number 690786195456 InnoDB: Doing recovery: scanned up to log sequence number 690791438336 InnoDB: Doing recovery: scanned up to log sequence number 690796681216 InnoDB: Doing recovery: scanned up to log sequence number 690801924096 InnoDB: Doing recovery: scanned up to log sequence number 690807166976 InnoDB: Doing recovery: scanned up to log sequence number 690812409856 InnoDB: Doing recovery: scanned up to log sequence number 690817652736 InnoDB: Doing recovery: scanned up to log sequence number 690822895616 InnoDB: Doing recovery: scanned up to log sequence number 690828138496 InnoDB: Doing recovery: scanned up to log sequence number 690833381376 InnoDB: Doing recovery: scanned up to log sequence number 690838624256 InnoDB: Doing recovery: scanned up to log sequence number 690843867136 InnoDB: Doing recovery: scanned up to log sequence number 690849110016 InnoDB: Doing recovery: scanned up to log sequence number 690849228302 2013-12-13 17:44:26 30722 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 362123962, file name DB9-345729-bin-log.001297 2013-12-13 17:48:25 30722 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 17:49:41 30722 [Note] InnoDB: Waiting for purge to start 2013-12-13 17:49:41 30722 [Note] InnoDB: 5.6.14 started; log sequence number 690849228302 2013-12-13 17:49:41 30722 [Note] Recovering after a crash using /srv/mysql/DB9-345729-bin-log 23:49:41 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=1073741824 read_buffer_size=131072 max_used_connections=0 max_threads=500 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1247400 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f18dc12fd00 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 = 7f1ab0a30808 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8cea15] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65e0d4] /lib64/libpthread.so.0[0x3b2160f500] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG19flush_thread_cachesEP3THD+0xdd)[0x887b5d] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG25process_flush_stage_queueEPyPbPP3THD+0x86)[0x887c86] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG14ordered_commitEP3THDbb+0x9d)[0x887edd] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG6commitEP3THDb+0x24e)[0x88848e] /usr/lib64/mysql/plugin//innodb_engine.so(handler_binlog_commit+0x29)[0x7f2e202e6189] /usr/lib64/mysql/plugin//innodb_engine.so(innodb_reset_conn+0xd4)[0x7f2e202e18e4] /usr/lib64/mysql/plugin//innodb_engine.so(innodb_api_cursor_reset+0x50)[0x7f2e202e1a90] /usr/lib64/mysql/plugin//innodb_engine.so(+0x94a6)[0x7f2e202e04a6] /usr/lib64/mysql/plugin/libmemcached.so(conn_nread+0x770)[0x7f2da1377380] /usr/lib64/mysql/plugin/libmemcached.so(+0x9d8c)[0x7f2da136bd8c] /usr/lib64/mysql/plugin/libmemcached.so(event_base_loop+0x286)[0x7f2da137dff6] /usr/lib64/mysql/plugin/libmemcached.so(+0x19a42)[0x7f2da137ba42] /lib64/libpthread.so.0[0x3b21607851] /lib64/libc.so.6(clone+0x6d)[0x3b212e894d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 10 Status: NOT_KILLED 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. 131213 17:49:41 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 17:56:55 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 17:56:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 17:56:56 7387 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 17:56:56 7f9efebbd720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 17:56:56 7387 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 17:56:56 7387 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 17:56:56 7387 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 17:56:56 7387 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 17:56:56 7387 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 17:57:00 7387 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 17:57:00 7387 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 17:57:01 7387 [Note] InnoDB: Log scan progressed past the checkpoint lsn 690073164172 2013-12-13 17:57:01 7387 [Note] InnoDB: Database was not shutdown normally! 2013-12-13 17:57:01 7387 [Note] InnoDB: Starting crash recovery. 2013-12-13 17:57:01 7387 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-12-13 17:57:01 7387 [Note] InnoDB: Restoring possible half-written data pages 2013-12-13 17:57:01 7387 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 690078406656 InnoDB: Doing recovery: scanned up to log sequence number 690083649536 InnoDB: Doing recovery: scanned up to log sequence number 690088892416 InnoDB: Doing recovery: scanned up to log sequence number 690094135296 InnoDB: Doing recovery: scanned up to log sequence number 690099378176 InnoDB: Doing recovery: scanned up to log sequence number 690104621056 InnoDB: Doing recovery: scanned up to log sequence number 690109863936 InnoDB: Doing recovery: scanned up to log sequence number 690115106816 InnoDB: Doing recovery: scanned up to log sequence number 690120349696 InnoDB: Doing recovery: scanned up to log sequence number 690125592576 InnoDB: Doing recovery: scanned up to log sequence number 690130835456 InnoDB: Doing recovery: scanned up to log sequence number 690136078336 InnoDB: Doing recovery: scanned up to log sequence number 690141321216 InnoDB: Doing recovery: scanned up to log sequence number 690146564096 InnoDB: Doing recovery: scanned up to log sequence number 690151806976 InnoDB: Doing recovery: scanned up to log sequence number 690157049856 InnoDB: Doing recovery: scanned up to log sequence number 690162292736 InnoDB: Doing recovery: scanned up to log sequence number 690167535616 InnoDB: Doing recovery: scanned up to log sequence number 690172778496 InnoDB: Doing recovery: scanned up to log sequence number 690178021376 InnoDB: Doing recovery: scanned up to log sequence number 690183264256 InnoDB: Doing recovery: scanned up to log sequence number 690188507136 InnoDB: Doing recovery: scanned up to log sequence number 690193750016 InnoDB: Doing recovery: scanned up to log sequence number 690198992896 InnoDB: Doing recovery: scanned up to log sequence number 690204235776 InnoDB: Doing recovery: scanned up to log sequence number 690209478656 InnoDB: Doing recovery: scanned up to log sequence number 690214721536 InnoDB: Doing recovery: scanned up to log sequence number 690219964416 InnoDB: Doing recovery: scanned up to log sequence number 690225207296 InnoDB: Doing recovery: scanned up to log sequence number 690230450176 InnoDB: Doing recovery: scanned up to log sequence number 690235693056 InnoDB: Doing recovery: scanned up to log sequence number 690240935936 InnoDB: Doing recovery: scanned up to log sequence number 690246178816 InnoDB: Doing recovery: scanned up to log sequence number 690251421696 InnoDB: Doing recovery: scanned up to log sequence number 690256664576 InnoDB: Doing recovery: scanned up to log sequence number 690261907456 InnoDB: Doing recovery: scanned up to log sequence number 690267150336 InnoDB: Doing recovery: scanned up to log sequence number 690272393216 InnoDB: Doing recovery: scanned up to log sequence number 690277636096 InnoDB: Doing recovery: scanned up to log sequence number 690282878976 InnoDB: Doing recovery: scanned up to log sequence number 690288121856 InnoDB: Doing recovery: scanned up to log sequence number 690293364736 InnoDB: Doing recovery: scanned up to log sequence number 690298607616 InnoDB: Doing recovery: scanned up to log sequence number 690303850496 InnoDB: Doing recovery: scanned up to log sequence number 690309093376 InnoDB: Doing recovery: scanned up to log sequence number 690314336256 InnoDB: Doing recovery: scanned up to log sequence number 690319579136 InnoDB: Doing recovery: scanned up to log sequence number 690324822016 InnoDB: Doing recovery: scanned up to log sequence number 690330064896 InnoDB: Doing recovery: scanned up to log sequence number 690335307776 InnoDB: Doing recovery: scanned up to log sequence number 690340550656 InnoDB: Doing recovery: scanned up to log sequence number 690345793536 InnoDB: Doing recovery: scanned up to log sequence number 690351036416 InnoDB: Doing recovery: scanned up to log sequence number 690356279296 InnoDB: Doing recovery: scanned up to log sequence number 690361522176 InnoDB: Doing recovery: scanned up to log sequence number 690366765056 InnoDB: Doing recovery: scanned up to log sequence number 690372007936 InnoDB: Doing recovery: scanned up to log sequence number 690377250816 InnoDB: Doing recovery: scanned up to log sequence number 690382493696 InnoDB: Doing recovery: scanned up to log sequence number 690387736576 InnoDB: Doing recovery: scanned up to log sequence number 690392979456 InnoDB: Doing recovery: scanned up to log sequence number 690398222336 InnoDB: Doing recovery: scanned up to log sequence number 690403465216 InnoDB: Doing recovery: scanned up to log sequence number 690408708096 InnoDB: Doing recovery: scanned up to log sequence number 690413950976 InnoDB: Doing recovery: scanned up to log sequence number 690419193856 InnoDB: Doing recovery: scanned up to log sequence number 690424436736 InnoDB: Doing recovery: scanned up to log sequence number 690429679616 InnoDB: Doing recovery: scanned up to log sequence number 690434922496 InnoDB: Doing recovery: scanned up to log sequence number 690440165376 InnoDB: Doing recovery: scanned up to log sequence number 690445408256 InnoDB: Doing recovery: scanned up to log sequence number 690450651136 InnoDB: Doing recovery: scanned up to log sequence number 690455894016 InnoDB: Doing recovery: scanned up to log sequence number 690461136896 InnoDB: Doing recovery: scanned up to log sequence number 690466379776 InnoDB: Doing recovery: scanned up to log sequence number 690471622656 InnoDB: Doing recovery: scanned up to log sequence number 690476865536 InnoDB: Doing recovery: scanned up to log sequence number 690482108416 InnoDB: Doing recovery: scanned up to log sequence number 690487351296 InnoDB: Doing recovery: scanned up to log sequence number 690492594176 InnoDB: Doing recovery: scanned up to log sequence number 690497837056 InnoDB: Doing recovery: scanned up to log sequence number 690503079936 InnoDB: Doing recovery: scanned up to log sequence number 690508322816 InnoDB: Doing recovery: scanned up to log sequence number 690513565696 InnoDB: Doing recovery: scanned up to log sequence number 690518808576 InnoDB: Doing recovery: scanned up to log sequence number 690524051456 InnoDB: Doing recovery: scanned up to log sequence number 690529294336 InnoDB: Doing recovery: scanned up to log sequence number 690534537216 InnoDB: Doing recovery: scanned up to log sequence number 690539780096 InnoDB: Doing recovery: scanned up to log sequence number 690545022976 InnoDB: Doing recovery: scanned up to log sequence number 690550265856 InnoDB: Doing recovery: scanned up to log sequence number 690555508736 InnoDB: Doing recovery: scanned up to log sequence number 690560751616 InnoDB: Doing recovery: scanned up to log sequence number 690565994496 InnoDB: Doing recovery: scanned up to log sequence number 690571237376 InnoDB: Doing recovery: scanned up to log sequence number 690576480256 InnoDB: Doing recovery: scanned up to log sequence number 690581723136 InnoDB: Doing recovery: scanned up to log sequence number 690586966016 InnoDB: Doing recovery: scanned up to log sequence number 690592208896 InnoDB: Doing recovery: scanned up to log sequence number 690597451776 InnoDB: Doing recovery: scanned up to log sequence number 690602694656 InnoDB: Doing recovery: scanned up to log sequence number 690607937536 InnoDB: Doing recovery: scanned up to log sequence number 690613180416 InnoDB: Doing recovery: scanned up to log sequence number 690618423296 InnoDB: Doing recovery: scanned up to log sequence number 690623666176 InnoDB: Doing recovery: scanned up to log sequence number 690628909056 InnoDB: Doing recovery: scanned up to log sequence number 690634151936 InnoDB: Doing recovery: scanned up to log sequence number 690639394816 InnoDB: Doing recovery: scanned up to log sequence number 690644637696 InnoDB: Doing recovery: scanned up to log sequence number 690649880576 InnoDB: Doing recovery: scanned up to log sequence number 690655123456 InnoDB: Doing recovery: scanned up to log sequence number 690660366336 InnoDB: Doing recovery: scanned up to log sequence number 690665609216 InnoDB: Doing recovery: scanned up to log sequence number 690670852096 InnoDB: Doing recovery: scanned up to log sequence number 690676094976 InnoDB: Doing recovery: scanned up to log sequence number 690681337856 InnoDB: Doing recovery: scanned up to log sequence number 690686580736 InnoDB: Doing recovery: scanned up to log sequence number 690691823616 InnoDB: Doing recovery: scanned up to log sequence number 690697066496 InnoDB: Doing recovery: scanned up to log sequence number 690702309376 InnoDB: Doing recovery: scanned up to log sequence number 690707552256 InnoDB: Doing recovery: scanned up to log sequence number 690712795136 InnoDB: Doing recovery: scanned up to log sequence number 690718038016 InnoDB: Doing recovery: scanned up to log sequence number 690723280896 InnoDB: Doing recovery: scanned up to log sequence number 690728523776 InnoDB: Doing recovery: scanned up to log sequence number 690733766656 InnoDB: Doing recovery: scanned up to log sequence number 690739009536 InnoDB: Doing recovery: scanned up to log sequence number 690744252416 InnoDB: Doing recovery: scanned up to log sequence number 690749495296 InnoDB: Doing recovery: scanned up to log sequence number 690754738176 InnoDB: Doing recovery: scanned up to log sequence number 690759981056 InnoDB: Doing recovery: scanned up to log sequence number 690765223936 InnoDB: Doing recovery: scanned up to log sequence number 690770466816 InnoDB: Doing recovery: scanned up to log sequence number 690775709696 InnoDB: Doing recovery: scanned up to log sequence number 690780952576 InnoDB: Doing recovery: scanned up to log sequence number 690786195456 InnoDB: Doing recovery: scanned up to log sequence number 690791438336 InnoDB: Doing recovery: scanned up to log sequence number 690796681216 InnoDB: Doing recovery: scanned up to log sequence number 690801924096 InnoDB: Doing recovery: scanned up to log sequence number 690807166976 InnoDB: Doing recovery: scanned up to log sequence number 690812409856 InnoDB: Doing recovery: scanned up to log sequence number 690817652736 InnoDB: Doing recovery: scanned up to log sequence number 690822895616 InnoDB: Doing recovery: scanned up to log sequence number 690828138496 InnoDB: Doing recovery: scanned up to log sequence number 690833381376 InnoDB: Doing recovery: scanned up to log sequence number 690838624256 InnoDB: Doing recovery: scanned up to log sequence number 690843867136 InnoDB: Doing recovery: scanned up to log sequence number 690849110016 InnoDB: Doing recovery: scanned up to log sequence number 690849247285 2013-12-13 17:57:10 7387 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 362123962, file name DB9-345729-bin-log.001297 2013-12-13 18:01:06 7387 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 18:01:18 7387 [Note] InnoDB: Waiting for purge to start 2013-12-13 18:01:18 7387 [Note] InnoDB: 5.6.14 started; log sequence number 690849247285 2013-12-13 18:01:18 7387 [Note] Recovering after a crash using /srv/mysql/DB9-345729-bin-log 00:01:18 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=1073741824 read_buffer_size=131072 max_used_connections=0 max_threads=500 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1247400 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f89b014b1f0 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 = 7f8ba4df8808 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8cea15] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65e0d4] /lib64/libpthread.so.0[0x3b2160f500] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG19flush_thread_cachesEP3THD+0xdd)[0x887b5d] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG25process_flush_stage_queueEPyPbPP3THD+0x86)[0x887c86] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG14ordered_commitEP3THDbb+0x9d)[0x887edd] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG6commitEP3THDb+0x24e)[0x88848e] /usr/lib64/mysql/plugin//innodb_engine.so(handler_binlog_commit+0x29)[0x7f9efc3eb189] /usr/lib64/mysql/plugin//innodb_engine.so(innodb_reset_conn+0xd4)[0x7f9efc3e68e4] /usr/lib64/mysql/plugin//innodb_engine.so(innodb_api_cursor_reset+0x50)[0x7f9efc3e6a90] /usr/lib64/mysql/plugin//innodb_engine.so(+0x94a6)[0x7f9efc3e54a6] /usr/lib64/mysql/plugin/libmemcached.so(conn_nread+0x770)[0x7f9e7d336380] /usr/lib64/mysql/plugin/libmemcached.so(+0x9d8c)[0x7f9e7d32ad8c] /usr/lib64/mysql/plugin/libmemcached.so(event_base_loop+0x286)[0x7f9e7d33cff6] /usr/lib64/mysql/plugin/libmemcached.so(+0x19a42)[0x7f9e7d33aa42] /lib64/libpthread.so.0[0x3b21607851] /lib64/libc.so.6(clone+0x6d)[0x3b212e894d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 19 Status: NOT_KILLED 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. 131213 18:01:18 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 18:53:17 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 18:53:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 18:53:18 9768 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 18:53:18 7fe7365ac720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 18:53:18 9768 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 18:53:18 9768 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 18:53:18 9768 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 18:53:18 9768 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 18:53:18 9768 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 18:53:23 9768 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 18:53:23 9768 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 18:53:24 9768 [Note] InnoDB: Log scan progressed past the checkpoint lsn 690073164172 2013-12-13 18:53:24 9768 [Note] InnoDB: Database was not shutdown normally! 2013-12-13 18:53:24 9768 [Note] InnoDB: Starting crash recovery. 2013-12-13 18:53:24 9768 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-12-13 18:53:24 9768 [Note] InnoDB: Restoring possible half-written data pages 2013-12-13 18:53:24 9768 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 690078406656 InnoDB: Doing recovery: scanned up to log sequence number 690083649536 InnoDB: Doing recovery: scanned up to log sequence number 690088892416 InnoDB: Doing recovery: scanned up to log sequence number 690094135296 InnoDB: Doing recovery: scanned up to log sequence number 690099378176 InnoDB: Doing recovery: scanned up to log sequence number 690104621056 InnoDB: Doing recovery: scanned up to log sequence number 690109863936 InnoDB: Doing recovery: scanned up to log sequence number 690115106816 InnoDB: Doing recovery: scanned up to log sequence number 690120349696 InnoDB: Doing recovery: scanned up to log sequence number 690125592576 InnoDB: Doing recovery: scanned up to log sequence number 690130835456 InnoDB: Doing recovery: scanned up to log sequence number 690136078336 InnoDB: Doing recovery: scanned up to log sequence number 690141321216 InnoDB: Doing recovery: scanned up to log sequence number 690146564096 InnoDB: Doing recovery: scanned up to log sequence number 690151806976 InnoDB: Doing recovery: scanned up to log sequence number 690157049856 InnoDB: Doing recovery: scanned up to log sequence number 690162292736 InnoDB: Doing recovery: scanned up to log sequence number 690167535616 InnoDB: Doing recovery: scanned up to log sequence number 690172778496 InnoDB: Doing recovery: scanned up to log sequence number 690178021376 InnoDB: Doing recovery: scanned up to log sequence number 690183264256 InnoDB: Doing recovery: scanned up to log sequence number 690188507136 InnoDB: Doing recovery: scanned up to log sequence number 690193750016 InnoDB: Doing recovery: scanned up to log sequence number 690198992896 InnoDB: Doing recovery: scanned up to log sequence number 690204235776 InnoDB: Doing recovery: scanned up to log sequence number 690209478656 InnoDB: Doing recovery: scanned up to log sequence number 690214721536 InnoDB: Doing recovery: scanned up to log sequence number 690219964416 InnoDB: Doing recovery: scanned up to log sequence number 690225207296 InnoDB: Doing recovery: scanned up to log sequence number 690230450176 InnoDB: Doing recovery: scanned up to log sequence number 690235693056 InnoDB: Doing recovery: scanned up to log sequence number 690240935936 InnoDB: Doing recovery: scanned up to log sequence number 690246178816 InnoDB: Doing recovery: scanned up to log sequence number 690251421696 InnoDB: Doing recovery: scanned up to log sequence number 690256664576 InnoDB: Doing recovery: scanned up to log sequence number 690261907456 InnoDB: Doing recovery: scanned up to log sequence number 690267150336 InnoDB: Doing recovery: scanned up to log sequence number 690272393216 InnoDB: Doing recovery: scanned up to log sequence number 690277636096 InnoDB: Doing recovery: scanned up to log sequence number 690282878976 InnoDB: Doing recovery: scanned up to log sequence number 690288121856 InnoDB: Doing recovery: scanned up to log sequence number 690293364736 InnoDB: Doing recovery: scanned up to log sequence number 690298607616 InnoDB: Doing recovery: scanned up to log sequence number 690303850496 InnoDB: Doing recovery: scanned up to log sequence number 690309093376 InnoDB: Doing recovery: scanned up to log sequence number 690314336256 InnoDB: Doing recovery: scanned up to log sequence number 690319579136 InnoDB: Doing recovery: scanned up to log sequence number 690324822016 InnoDB: Doing recovery: scanned up to log sequence number 690330064896 InnoDB: Doing recovery: scanned up to log sequence number 690335307776 InnoDB: Doing recovery: scanned up to log sequence number 690340550656 InnoDB: Doing recovery: scanned up to log sequence number 690345793536 InnoDB: Doing recovery: scanned up to log sequence number 690351036416 InnoDB: Doing recovery: scanned up to log sequence number 690356279296 InnoDB: Doing recovery: scanned up to log sequence number 690361522176 InnoDB: Doing recovery: scanned up to log sequence number 690366765056 InnoDB: Doing recovery: scanned up to log sequence number 690372007936 InnoDB: Doing recovery: scanned up to log sequence number 690377250816 InnoDB: Doing recovery: scanned up to log sequence number 690382493696 InnoDB: Doing recovery: scanned up to log sequence number 690387736576 InnoDB: Doing recovery: scanned up to log sequence number 690392979456 InnoDB: Doing recovery: scanned up to log sequence number 690398222336 InnoDB: Doing recovery: scanned up to log sequence number 690403465216 InnoDB: Doing recovery: scanned up to log sequence number 690408708096 InnoDB: Doing recovery: scanned up to log sequence number 690413950976 InnoDB: Doing recovery: scanned up to log sequence number 690419193856 InnoDB: Doing recovery: scanned up to log sequence number 690424436736 InnoDB: Doing recovery: scanned up to log sequence number 690429679616 InnoDB: Doing recovery: scanned up to log sequence number 690434922496 InnoDB: Doing recovery: scanned up to log sequence number 690440165376 InnoDB: Doing recovery: scanned up to log sequence number 690445408256 InnoDB: Doing recovery: scanned up to log sequence number 690450651136 InnoDB: Doing recovery: scanned up to log sequence number 690455894016 InnoDB: Doing recovery: scanned up to log sequence number 690461136896 InnoDB: Doing recovery: scanned up to log sequence number 690466379776 InnoDB: Doing recovery: scanned up to log sequence number 690471622656 InnoDB: Doing recovery: scanned up to log sequence number 690476865536 InnoDB: Doing recovery: scanned up to log sequence number 690482108416 InnoDB: Doing recovery: scanned up to log sequence number 690487351296 InnoDB: Doing recovery: scanned up to log sequence number 690492594176 InnoDB: Doing recovery: scanned up to log sequence number 690497837056 InnoDB: Doing recovery: scanned up to log sequence number 690503079936 InnoDB: Doing recovery: scanned up to log sequence number 690508322816 InnoDB: Doing recovery: scanned up to log sequence number 690513565696 InnoDB: Doing recovery: scanned up to log sequence number 690518808576 InnoDB: Doing recovery: scanned up to log sequence number 690524051456 InnoDB: Doing recovery: scanned up to log sequence number 690529294336 InnoDB: Doing recovery: scanned up to log sequence number 690534537216 InnoDB: Doing recovery: scanned up to log sequence number 690539780096 InnoDB: Doing recovery: scanned up to log sequence number 690545022976 InnoDB: Doing recovery: scanned up to log sequence number 690550265856 InnoDB: Doing recovery: scanned up to log sequence number 690555508736 InnoDB: Doing recovery: scanned up to log sequence number 690560751616 InnoDB: Doing recovery: scanned up to log sequence number 690565994496 InnoDB: Doing recovery: scanned up to log sequence number 690571237376 InnoDB: Doing recovery: scanned up to log sequence number 690576480256 InnoDB: Doing recovery: scanned up to log sequence number 690581723136 InnoDB: Doing recovery: scanned up to log sequence number 690586966016 InnoDB: Doing recovery: scanned up to log sequence number 690592208896 InnoDB: Doing recovery: scanned up to log sequence number 690597451776 InnoDB: Doing recovery: scanned up to log sequence number 690602694656 InnoDB: Doing recovery: scanned up to log sequence number 690607937536 InnoDB: Doing recovery: scanned up to log sequence number 690613180416 InnoDB: Doing recovery: scanned up to log sequence number 690618423296 InnoDB: Doing recovery: scanned up to log sequence number 690623666176 InnoDB: Doing recovery: scanned up to log sequence number 690628909056 InnoDB: Doing recovery: scanned up to log sequence number 690634151936 InnoDB: Doing recovery: scanned up to log sequence number 690639394816 InnoDB: Doing recovery: scanned up to log sequence number 690644637696 InnoDB: Doing recovery: scanned up to log sequence number 690649880576 InnoDB: Doing recovery: scanned up to log sequence number 690655123456 InnoDB: Doing recovery: scanned up to log sequence number 690660366336 InnoDB: Doing recovery: scanned up to log sequence number 690665609216 InnoDB: Doing recovery: scanned up to log sequence number 690670852096 InnoDB: Doing recovery: scanned up to log sequence number 690676094976 InnoDB: Doing recovery: scanned up to log sequence number 690681337856 InnoDB: Doing recovery: scanned up to log sequence number 690686580736 InnoDB: Doing recovery: scanned up to log sequence number 690691823616 InnoDB: Doing recovery: scanned up to log sequence number 690697066496 InnoDB: Doing recovery: scanned up to log sequence number 690702309376 InnoDB: Doing recovery: scanned up to log sequence number 690707552256 InnoDB: Doing recovery: scanned up to log sequence number 690712795136 InnoDB: Doing recovery: scanned up to log sequence number 690718038016 InnoDB: Doing recovery: scanned up to log sequence number 690723280896 InnoDB: Doing recovery: scanned up to log sequence number 690728523776 InnoDB: Doing recovery: scanned up to log sequence number 690733766656 InnoDB: Doing recovery: scanned up to log sequence number 690739009536 InnoDB: Doing recovery: scanned up to log sequence number 690744252416 InnoDB: Doing recovery: scanned up to log sequence number 690749495296 InnoDB: Doing recovery: scanned up to log sequence number 690754738176 InnoDB: Doing recovery: scanned up to log sequence number 690759981056 InnoDB: Doing recovery: scanned up to log sequence number 690765223936 InnoDB: Doing recovery: scanned up to log sequence number 690770466816 InnoDB: Doing recovery: scanned up to log sequence number 690775709696 InnoDB: Doing recovery: scanned up to log sequence number 690780952576 InnoDB: Doing recovery: scanned up to log sequence number 690786195456 InnoDB: Doing recovery: scanned up to log sequence number 690791438336 InnoDB: Doing recovery: scanned up to log sequence number 690796681216 InnoDB: Doing recovery: scanned up to log sequence number 690801924096 InnoDB: Doing recovery: scanned up to log sequence number 690807166976 InnoDB: Doing recovery: scanned up to log sequence number 690812409856 InnoDB: Doing recovery: scanned up to log sequence number 690817652736 InnoDB: Doing recovery: scanned up to log sequence number 690822895616 InnoDB: Doing recovery: scanned up to log sequence number 690828138496 InnoDB: Doing recovery: scanned up to log sequence number 690833381376 InnoDB: Doing recovery: scanned up to log sequence number 690838624256 InnoDB: Doing recovery: scanned up to log sequence number 690843867136 InnoDB: Doing recovery: scanned up to log sequence number 690849110016 InnoDB: Doing recovery: scanned up to log sequence number 690849262261 2013-12-13 18:53:39 9768 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 362123962, file name DB9-345729-bin-log.001297 2013-12-13 18:57:37 9768 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 18:57:49 9768 [Note] InnoDB: Waiting for purge to start 2013-12-13 18:57:49 9768 [Note] InnoDB: 5.6.14 started; log sequence number 690849262261 2013-12-13 18:57:49 9768 [Note] Recovering after a crash using /srv/mysql/DB9-345729-bin-log 2013-12-13 18:57:52 9768 [Note] Starting crash recovery... 2013-12-13 18:57:52 9768 [Note] Crash recovery finished. 2013-12-13 18:57:52 9768 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 18:57:52 9768 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 18:57:52 9768 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 18:57:52 9768 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 18:57:52 9768 [ERROR] Slave I/O: error connecting to master 'slave_DB9@192.168.100.90:3306' - retry-time: 60 retries: 1, Error_code: 1045 2013-12-13 18:57:52 9768 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 18:57:52 9768 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000152' at position 105657, relay log '/srv/mysql/DB9-345729-relay-log.000176' position: 292 2013-12-13 18:57:52 9768 [Note] Event Scheduler: Loaded 0 events 2013-12-13 18:57:52 9768 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 18:58:52 9768 [ERROR] Slave I/O: error connecting to master 'slave_DB9@192.168.100.90:3306' - retry-time: 60 retries: 2, Error_code: 1045 2013-12-13 18:59:16 9768 [Note] Error reading relay log event: slave SQL thread was killed 2013-12-13 18:59:16 9768 [Note] Slave I/O thread killed while connecting to master 2013-12-13 18:59:16 9768 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000152', position 105657 2013-12-13 19:00:45 9768 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 19:00:45 9768 [Note] Giving 1 client threads a chance to die gracefully 2013-12-13 19:00:45 9768 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 19:00:45 9768 [Note] Shutting down slave threads 2013-12-13 19:00:47 9768 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 19:00:49 9768 [Note] Binlog end 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'partition' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 19:00:49 9768 [Note] Shutting down plugin 'InnoDB' 2013-12-13 19:00:49 9768 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 19:00:49 9768 [Note] InnoDB: Starting shutdown... 2013-12-13 19:01:05 9768 [Note] InnoDB: Shutdown completed; log sequence number 690852975302 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'CSV' 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'MEMORY' 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'MyISAM' 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'sha256_password' 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 19:01:05 9768 [Note] Shutting down plugin 'binlog' 2013-12-13 19:01:05 9768 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 19:01:10 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 19:01:35 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 19:01:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 19:01:36 16643 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 19:01:36 7f4cbdf3b720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 19:01:36 16643 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 19:01:36 16643 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 19:01:36 16643 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 19:01:36 16643 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 19:01:36 16643 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 19:01:40 16643 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 19:01:40 16643 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 19:01:43 16643 [Note] InnoDB: 5.6.14 started; log sequence number 690852975302 2013-12-13 19:01:43 16643 [Note] InnoDB: !!! innodb_force_recovery is set to 4 !!! 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"innodb_memcache"."containers"' in the cache. Attempting to load the tablespace with space id 37. 2013-12-13 19:01:43 16643 [Warning] InnoDB: Allocated tablespace 37, old maximum was 0 2013-12-13 19:01:43 16643 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 19:01:43 16643 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 19:01:43 16643 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"memcached"."memcached"' in the cache. Attempting to load the tablespace with space id 32. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"memcached"."default"' in the cache. Attempting to load the tablespace with space id 34. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"memcached"."wheels_tires_fitment"' in the cache. Attempting to load the tablespace with space id 33. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"innodb_memcache"."cache_policies"' in the cache. Attempting to load the tablespace with space id 35. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"innodb_memcache"."config_options"' in the cache. Attempting to load the tablespace with space id 36. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2013-12-13 19:01:43 16643 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2013-12-13 19:01:43 16643 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 19:01:43 16643 [ERROR] Slave I/O: error connecting to master 'slave_DB9@192.168.100.90:3306' - retry-time: 60 retries: 1, Error_code: 1045 2013-12-13 19:01:43 16643 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 19:01:43 16643 [Note] Event Scheduler: Loaded 0 events 2013-12-13 19:01:43 16643 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 19:01:43 16643 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000152' at position 105657, relay log '/srv/mysql/DB9-345729-relay-log.000177' position: 4 2013-12-13 19:02:25 16643 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 19:02:25 16643 [Note] Giving 2 client threads a chance to die gracefully 2013-12-13 19:02:25 16643 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 19:02:25 16643 [Note] Shutting down slave threads 2013-12-13 19:02:25 16643 [Note] Error reading relay log event: slave SQL thread was killed 2013-12-13 19:02:25 16643 [Note] Slave I/O thread killed while connecting to master 2013-12-13 19:02:25 16643 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000152', position 105657 2013-12-13 19:02:25 16643 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 19:02:27 16643 [Note] Binlog end 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'partition' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 19:02:27 16643 [Note] Shutting down plugin 'InnoDB' 2013-12-13 19:02:27 16643 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 19:02:27 16643 [Note] InnoDB: Starting shutdown... 2013-12-13 19:02:32 16643 [Note] InnoDB: Shutdown completed; log sequence number 690852975312 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'CSV' 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'MEMORY' 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'MyISAM' 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'sha256_password' 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 19:02:32 16643 [Note] Shutting down plugin 'binlog' 2013-12-13 19:02:32 16643 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 19:02:37 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 19:03:16 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 19:03:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 19:03:16 18374 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 19:03:16 7f268b61c720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 19:03:16 18374 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 19:03:16 18374 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 19:03:16 18374 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 19:03:16 18374 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 19:03:16 18374 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 19:03:21 18374 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 19:03:21 18374 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 19:03:23 18374 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 19:03:23 18374 [Note] InnoDB: Waiting for purge to start 2013-12-13 19:03:23 18374 [Note] InnoDB: 5.6.14 started; log sequence number 690852975312 2013-12-13 19:03:23 18374 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 19:03:23 18374 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 19:03:23 18374 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 19:03:23 18374 [Note] Event Scheduler: Loaded 0 events 2013-12-13 19:03:23 18374 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 19:27:30 18374 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 19:27:30 18374 [Note] Giving 0 client threads a chance to die gracefully 2013-12-13 19:27:30 18374 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 19:27:30 18374 [Note] Shutting down slave threads 2013-12-13 19:27:30 18374 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 19:27:32 18374 [Note] Binlog end 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'partition' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 19:27:32 18374 [Note] Shutting down plugin 'InnoDB' 2013-12-13 19:27:32 18374 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 19:27:32 18374 [Note] InnoDB: Starting shutdown... 2013-12-13 19:28:32 18374 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2013-12-13 19:29:22 18374 [Note] InnoDB: Shutdown completed; log sequence number 691079656219 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'CSV' 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'MEMORY' 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'MyISAM' 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'sha256_password' 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 19:29:22 18374 [Note] Shutting down plugin 'binlog' 2013-12-13 19:29:22 18374 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 3 threads didn't exit 131213 19:29:27 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 19:29:55 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 19:29:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 19:29:56 4969 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 19:29:56 7fb25318d720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 19:29:56 4969 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 19:29:56 4969 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 19:29:56 4969 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 19:29:56 4969 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 19:29:56 4969 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 19:30:01 4969 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 19:30:01 4969 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 19:30:03 4969 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 19:30:03 4969 [Note] InnoDB: Waiting for purge to start 2013-12-13 19:30:03 4969 [Note] InnoDB: 5.6.14 started; log sequence number 691079656219 2013-12-13 19:30:03 4969 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 19:30:03 4969 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 19:30:03 4969 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 19:30:03 4969 [Note] Event Scheduler: Loaded 0 events 2013-12-13 19:30:03 4969 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 19:33:30 4969 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='192.168.100.90', master_port= 3306, master_log_file='DB8-512567-bin-log.000162', master_log_pos= 120, master_bind=''. 2013-12-13 19:33:44 4969 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 19:33:44 4969 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 19:33:44 4969 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000162' at position 120, relay log '/srv/mysql/DB9-345729-relay-log.000001' position: 4 2013-12-13 19:33:44 4969 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000162' at position 120 2013-12-13 19:33:52 4969 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000162, end_log_pos 287848504, Error_code: 1032 2013-12-13 19:33:52 4969 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-13 19:33:52 4969 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000162' position 287847855 2013-12-13 19:34:25 4969 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000164', position 214909945 2013-12-13 19:34:41 4969 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='192.168.100.90', master_port= 3306, master_log_file='DB8-512567-bin-log.000164', master_log_pos= 214909945, master_bind=''. New state master_host='192.168.100.90', master_port= 3306, master_log_file='DB8-512567-bin-log.000162', master_log_pos= 463258232, master_bind=''. 2013-12-13 19:34:51 4969 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 19:34:51 4969 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 19:34:51 4969 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000162' at position 463258232, relay log '/srv/mysql/DB9-345729-relay-log.000001' position: 4 2013-12-13 19:34:51 4969 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000162' at position 463258232 2013-12-13 19:34:51 4969 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.memcached; Can't find record in 'memcached', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000162, end_log_pos 463270203, Error_code: 1032 2013-12-13 19:34:51 4969 [Warning] Slave: Can't find record in 'memcached' Error_code: 1032 2013-12-13 19:34:51 4969 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000162' position 463268965 2013-12-13 19:40:38 4969 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 19:40:38 4969 [Note] Slave I/O thread killed while reading event 2013-12-13 19:40:38 4969 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000165', position 448180227 2013-12-13 19:40:45 4969 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 19:40:45 4969 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000165' at position 448180227 2013-12-13 19:40:45 4969 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 19:40:45 4969 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000162' at position 463268965, relay log '/srv/mysql/DB9-345729-relay-log.000002' position: 11025 2013-12-13 19:40:45 4969 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='/srv/mysql/DB9-345729-relay-log.000002', relay_log_pos='11025', master_log_name='DB8-512567-bin-log.000162', master_log_pos='463268965' and new position at relay_log_file='/srv/mysql/DB9-345729-relay-log.000002', relay_log_pos='12332', master_log_name='DB8-512567-bin-log.000162', master_log_pos='463270272' 2013-12-13 19:40:45 4969 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.memcached; Can't find record in 'memcached', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000162, end_log_pos 463281623, Error_code: 1032 2013-12-13 19:40:45 4969 [Warning] Slave: Can't find record in 'memcached' Error_code: 1032 2013-12-13 19:40:45 4969 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000162' position 463280506 2013-12-13 19:48:32 4969 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 19:48:32 4969 [Note] Giving 1 client threads a chance to die gracefully 2013-12-13 19:48:32 4969 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 19:48:32 4969 [Note] Shutting down slave threads 2013-12-13 19:48:32 4969 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 19:48:32 4969 [Note] Slave I/O thread killed while reading event 2013-12-13 19:48:32 4969 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000165', position 748626384 2013-12-13 19:48:32 4969 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 19:48:34 4969 [Note] Binlog end 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'partition' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 19:48:34 4969 [Note] Shutting down plugin 'InnoDB' 2013-12-13 19:48:34 4969 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 19:48:34 4969 [Note] InnoDB: Starting shutdown... 2013-12-13 19:48:47 4969 [Note] InnoDB: Shutdown completed; log sequence number 691123283541 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'CSV' 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'MEMORY' 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'MyISAM' 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'sha256_password' 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 19:48:47 4969 [Note] Shutting down plugin 'binlog' 2013-12-13 19:48:47 4969 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 19:48:52 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 19:50:30 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 19:50:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 19:50:31 20162 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 19:50:31 7f26c6ac2720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 19:50:31 20162 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 19:50:31 20162 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 19:50:31 20162 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 19:50:31 20162 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 19:50:31 20162 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 19:50:35 20162 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 19:50:35 20162 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 19:50:37 20162 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 19:50:37 20162 [Note] InnoDB: Waiting for purge to start 2013-12-13 19:50:37 20162 [Note] InnoDB: 5.6.14 started; log sequence number 691123283541 2013-12-13 19:50:37 20162 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 19:50:37 20162 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 19:50:37 20162 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 19:50:37 20162 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 19:50:37 20162 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 19:50:37 20162 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000162' at position 463280506, relay log '/srv/mysql/DB9-345729-relay-log.000002' position: 22566 2013-12-13 19:50:37 20162 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000165' at position 748626384 2013-12-13 19:50:37 20162 [Note] Event Scheduler: Loaded 0 events 2013-12-13 19:50:37 20162 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 19:54:32 20162 [Note] Slave SQL thread exiting, replication stopped in log 'DB8-512567-bin-log.000163' at position 26139956 2013-12-13 19:54:32 20162 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 19:54:32 20162 [Note] Slave I/O thread killed while reading event 2013-12-13 19:54:32 20162 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000165', position 970776311 2013-12-13 19:54:49 20162 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 19:54:49 20162 [Note] Giving 0 client threads a chance to die gracefully 2013-12-13 19:54:49 20162 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 19:54:49 20162 [Note] Shutting down slave threads 2013-12-13 19:54:49 20162 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 19:54:51 20162 [Note] Binlog end 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'partition' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 19:54:51 20162 [Note] Shutting down plugin 'InnoDB' 2013-12-13 19:54:51 20162 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 19:54:51 20162 [Note] InnoDB: Starting shutdown... 2013-12-13 19:55:32 20162 [Note] InnoDB: Shutdown completed; log sequence number 691633323568 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'CSV' 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'MEMORY' 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'MyISAM' 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'sha256_password' 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 19:55:32 20162 [Note] Shutting down plugin 'binlog' 2013-12-13 19:55:32 20162 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 19:55:37 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 19:55:42 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 19:55:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 19:55:42 24510 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 19:55:42 7f0e0529d720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 19:55:42 24510 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 19:55:42 24510 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 19:55:42 24510 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 19:55:42 24510 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 19:55:42 24510 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 19:55:47 24510 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 19:55:47 24510 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 19:55:49 24510 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 19:55:49 24510 [Note] InnoDB: Waiting for purge to start 2013-12-13 19:55:49 24510 [Note] InnoDB: 5.6.14 started; log sequence number 691633323568 2013-12-13 19:55:49 24510 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 19:55:49 24510 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 19:55:49 24510 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 19:55:49 24510 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 19:55:49 24510 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000165' at position 970776311 2013-12-13 19:55:49 24510 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 19:55:49 24510 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000163' at position 26139956, relay log '/srv/mysql/DB9-345729-relay-log.000004' position: 26140128 2013-12-13 19:55:49 24510 [Note] Event Scheduler: Loaded 0 events 2013-12-13 19:55:49 24510 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 19:55:50 24510 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000163, end_log_pos 26153369, Error_code: 1032 2013-12-13 19:55:50 24510 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-13 19:55:50 24510 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000163' position 26151125 2013-12-13 19:56:11 24510 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 19:56:11 24510 [Note] Giving 1 client threads a chance to die gracefully 2013-12-13 19:56:11 24510 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 19:56:11 24510 [Note] Shutting down slave threads 2013-12-13 19:56:11 24510 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 19:56:11 24510 [Note] Slave I/O thread killed while reading event 2013-12-13 19:56:11 24510 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000165', position 1030619189 2013-12-13 19:56:11 24510 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 19:56:13 24510 [Note] Binlog end 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'partition' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 19:56:13 24510 [Note] Shutting down plugin 'InnoDB' 2013-12-13 19:56:13 24510 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 19:56:13 24510 [Note] InnoDB: Starting shutdown... 2013-12-13 19:56:17 24510 [Note] InnoDB: Shutdown completed; log sequence number 691633343537 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'CSV' 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'MEMORY' 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'MyISAM' 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'sha256_password' 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 19:56:17 24510 [Note] Shutting down plugin 'binlog' 2013-12-13 19:56:17 24510 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 19:56:22 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 19:56:27 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 19:56:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 19:56:28 26484 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 19:56:28 7fbaca858720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 19:56:28 26484 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 19:56:28 26484 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 19:56:28 26484 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 19:56:28 26484 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 19:56:28 26484 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 19:56:32 26484 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 19:56:32 26484 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 19:56:34 26484 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 19:56:34 26484 [Note] InnoDB: Waiting for purge to start 2013-12-13 19:56:34 26484 [Note] InnoDB: 5.6.14 started; log sequence number 691633343537 2013-12-13 19:56:34 26484 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 19:56:34 26484 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 19:56:34 26484 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 19:56:34 26484 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 19:56:34 26484 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 19:56:34 26484 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000163' at position 26151125, relay log '/srv/mysql/DB9-345729-relay-log.000004' position: 26151297 2013-12-13 19:56:34 26484 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000165' at position 1030619189 2013-12-13 19:56:34 26484 [Note] Event Scheduler: Loaded 0 events 2013-12-13 19:56:34 26484 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:05:14 26484 [Note] Slave SQL thread exiting, replication stopped in log 'DB8-512567-bin-log.000164' at position 191339890 2013-12-13 20:05:14 26484 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 20:05:14 26484 [Note] Slave I/O thread killed while reading event 2013-12-13 20:05:14 26484 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000166', position 294427807 2013-12-13 20:05:24 26484 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:05:24 26484 [Note] Giving 0 client threads a chance to die gracefully 2013-12-13 20:05:24 26484 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:05:24 26484 [Note] Shutting down slave threads 2013-12-13 20:05:24 26484 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 20:05:26 26484 [Note] Binlog end 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'partition' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:05:26 26484 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:05:26 26484 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:05:26 26484 [Note] InnoDB: Starting shutdown... 2013-12-13 20:06:27 26484 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2013-12-13 20:06:58 26484 [Note] InnoDB: Shutdown completed; log sequence number 692736176733 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'CSV' 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:06:58 26484 [Note] Shutting down plugin 'binlog' 2013-12-13 20:06:58 26484 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 20:07:03 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 20:07:12 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:07:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 20:07:13 2308 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:07:13 7fd6cbc0b720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:07:13 2308 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:07:13 2308 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:07:13 2308 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:07:13 2308 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:07:13 2308 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 20:07:17 2308 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:07:17 2308 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:07:19 2308 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:07:19 2308 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:07:19 2308 [Note] InnoDB: 5.6.14 started; log sequence number 692736176733 2013-12-13 20:07:19 2308 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:07:19 2308 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:07:19 2308 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:07:19 2308 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:07:19 2308 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:07:19 2308 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000164' at position 191339890, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 191340062 2013-12-13 20:07:19 2308 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000166' at position 294427807 2013-12-13 20:07:19 2308 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:07:19 2308 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:07:21 2308 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000164, end_log_pos 191553309, Error_code: 1032 2013-12-13 20:07:21 2308 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-13 20:07:21 2308 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000164' position 191550924 2013-12-13 20:12:25 2308 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:12:25 2308 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000164' at position 191550924, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 191551096 2013-12-13 20:12:25 2308 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='/srv/mysql/DB9-345729-relay-log.000007', relay_log_pos='191551096', master_log_name='DB8-512567-bin-log.000164', master_log_pos='191550924' and new position at relay_log_file='/srv/mysql/DB9-345729-relay-log.000007', relay_log_pos='191553550', master_log_name='DB8-512567-bin-log.000164', master_log_pos='191553378' 2013-12-13 20:12:26 2308 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000164, end_log_pos 191934888, Error_code: 1032 2013-12-13 20:12:26 2308 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-13 20:12:26 2308 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000164' position 191934547 2013-12-13 20:16:07 2308 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 20:16:07 2308 [Note] Slave I/O thread killed while reading event 2013-12-13 20:16:07 2308 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000166', position 677661832 2013-12-13 20:16:35 2308 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='192.168.100.90', master_port= 3306, master_log_file='DB8-512567-bin-log.000166', master_log_pos= 677661832, master_bind=''. New state master_host='192.168.100.90', master_port= 3306, master_log_file='DB8-512567-bin-log.000161', master_log_pos= 120, master_bind=''. 2013-12-13 20:16:59 2308 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:16:59 2308 [Note] Giving 1 client threads a chance to die gracefully 2013-12-13 20:16:59 2308 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:16:59 2308 [Note] Shutting down slave threads 2013-12-13 20:17:01 2308 [Note] Forcefully disconnecting 1 remaining clients 2013-12-13 20:17:01 2308 [Warning] /usr/sbin/mysqld: Forcing close of thread 16 user: 'root' 2013-12-13 20:17:03 2308 [Note] Binlog end 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'partition' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:17:03 2308 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:17:03 2308 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:17:03 2308 [Note] InnoDB: Starting shutdown... 2013-12-13 20:17:08 2308 [Note] InnoDB: Shutdown completed; log sequence number 692775591775 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'CSV' 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:17:08 2308 [Note] Shutting down plugin 'binlog' 2013-12-13 20:17:08 2308 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 20:17:13 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 20:17:13 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:17:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 20:17:14 10512 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:17:14 7f64ed170720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:17:14 10512 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:17:14 10512 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:17:14 10512 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:17:14 10512 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:17:14 10512 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 20:17:18 10512 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:17:19 10512 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:17:21 10512 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:17:21 10512 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:17:21 10512 [Note] InnoDB: 5.6.14 started; log sequence number 692775591775 2013-12-13 20:17:21 10512 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:17:21 10512 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:17:21 10512 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:17:21 10512 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:17:21 10512 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:17:21 10512 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000161' at position 120, relay log '/srv/mysql/DB9-345729-relay-log.000001' position: 4 2013-12-13 20:17:21 10512 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000161' at position 120 2013-12-13 20:17:21 10512 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:17:21 10512 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:24:37 10512 [Note] Slave SQL thread exiting, replication stopped in log 'DB8-512567-bin-log.000163' at position 262876186 2013-12-13 20:24:37 10512 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 20:24:37 10512 [Note] Slave I/O thread killed while reading event 2013-12-13 20:24:37 10512 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000166', position 980031697 2013-12-13 20:25:13 10512 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:25:13 10512 [Note] Giving 1 client threads a chance to die gracefully 2013-12-13 20:25:13 10512 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:25:13 10512 [Note] Shutting down slave threads 2013-12-13 20:25:15 10512 [Note] Forcefully disconnecting 1 remaining clients 2013-12-13 20:25:15 10512 [Warning] /usr/sbin/mysqld: Forcing close of thread 30 user: 'root' 2013-12-13 20:25:17 10512 [Note] Binlog end 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'partition' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:25:17 10512 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:25:17 10512 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:25:17 10512 [Note] InnoDB: Starting shutdown... 2013-12-13 20:26:02 10512 [Note] InnoDB: Shutdown completed; log sequence number 693621974542 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'CSV' 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:26:02 10512 [Note] Shutting down plugin 'binlog' 2013-12-13 20:26:02 10512 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 20:26:07 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 20:26:13 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:26:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 20:26:14 17453 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:26:14 7f14a3039720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:26:14 17453 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:26:14 17453 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:26:14 17453 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:26:14 17453 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:26:14 17453 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 20:26:18 17453 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:26:18 17453 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:26:20 17453 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:26:20 17453 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:26:20 17453 [Note] InnoDB: 5.6.14 started; log sequence number 693621974542 2013-12-13 20:26:20 17453 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:26:20 17453 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:26:20 17453 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:26:20 17453 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:26:20 17453 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:26:20 17453 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000163' at position 262876186, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 262876358 2013-12-13 20:26:20 17453 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000166' at position 980031697 2013-12-13 20:26:20 17453 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:26:20 17453 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:26:20 17453 [ERROR] Slave SQL: Could not execute Write_rows event on table memcached.memcached; Duplicate entry 'memc.sess.key.da3beac774138eda2f97a6370127173c' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log DB8-512567-bin-log.000163, end_log_pos 262880020, Error_code: 1062 2013-12-13 20:26:20 17453 [Warning] Slave: Duplicate entry 'memc.sess.key.da3beac774138eda2f97a6370127173c' for key 'PRIMARY' Error_code: 1062 2013-12-13 20:26:20 17453 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000163' position 262879107 2013-12-13 20:26:35 17453 [Note] Slave I/O thread killed while reading event 2013-12-13 20:26:35 17453 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000166', position 1048382584 2013-12-13 20:26:35 17453 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:26:35 17453 [Note] Giving 0 client threads a chance to die gracefully 2013-12-13 20:26:35 17453 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:26:35 17453 [Note] Shutting down slave threads 2013-12-13 20:26:35 17453 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 20:26:37 17453 [Note] Binlog end 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'partition' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:26:37 17453 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:26:37 17453 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:26:37 17453 [Note] InnoDB: Starting shutdown... 2013-12-13 20:26:41 17453 [Note] InnoDB: Shutdown completed; log sequence number 693621981144 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'CSV' 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:26:41 17453 [Note] Shutting down plugin 'binlog' 2013-12-13 20:26:41 17453 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 20:26:46 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 20:26:53 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:26:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 20:26:54 19057 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:26:54 7f033342f720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:26:54 19057 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:26:54 19057 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:26:54 19057 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:26:54 19057 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:26:54 19057 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 20:26:59 19057 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:26:59 19057 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:27:01 19057 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:27:01 19057 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:27:01 19057 [Note] InnoDB: 5.6.14 started; log sequence number 693621981144 2013-12-13 20:27:01 19057 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:27:01 19057 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:27:01 19057 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:27:01 19057 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:27:01 19057 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000166' at position 1048382584 2013-12-13 20:27:01 19057 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:27:01 19057 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000163' at position 262879107, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 262879279 2013-12-13 20:27:01 19057 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:27:01 19057 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:27:01 19057 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000163, end_log_pos 262938189, Error_code: 1032 2013-12-13 20:27:01 19057 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-13 20:27:01 19057 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000163' position 262937672 2013-12-13 20:32:28 19057 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 20:32:28 19057 [Note] Slave I/O thread killed while reading event 2013-12-13 20:32:28 19057 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000167', position 187509821 2013-12-13 20:32:30 19057 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:32:30 19057 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000167' at position 187509821 2013-12-13 20:32:30 19057 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:32:30 19057 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000163' at position 262937672, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 262937844 2013-12-13 20:32:30 19057 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000163, end_log_pos 262938189, Error_code: 1032 2013-12-13 20:32:30 19057 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-13 20:32:30 19057 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000163' position 262937672 2013-12-13 20:33:31 19057 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:33:31 19057 [Note] Slave I/O thread killed while reading event 2013-12-13 20:33:31 19057 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000167', position 226727744 2013-12-13 20:33:31 19057 [Note] Giving 1 client threads a chance to die gracefully 2013-12-13 20:33:31 19057 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:33:31 19057 [Note] Shutting down slave threads 2013-12-13 20:33:31 19057 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 20:33:33 19057 [Note] Binlog end 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'partition' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:33:33 19057 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:33:33 19057 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:33:33 19057 [Note] InnoDB: Starting shutdown... 2013-12-13 20:33:53 19057 [Note] InnoDB: Shutdown completed; log sequence number 693674414205 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'CSV' 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:33:53 19057 [Note] Shutting down plugin 'binlog' 2013-12-13 20:33:53 19057 [Note] /usr/sbin/mysqld: Shutdown complete 131213 20:33:57 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:33:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). Error in my_thread_global_end(): 2 threads didn't exit 2013-12-13 20:33:58 24684 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:33:58 7fba3a3fe720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:33:58 24684 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:33:58 24684 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:33:58 24684 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:33:58 24684 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:33:58 24684 [Note] InnoDB: Initializing buffer pool, size = 70.0G 131213 20:33:58 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 2013-12-13 20:34:02 24684 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:34:02 24684 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:34:05 24684 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:34:05 24684 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:34:05 24684 [Note] InnoDB: 5.6.14 started; log sequence number 693674414205 2013-12-13 20:34:05 24684 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:34:05 24684 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:34:05 24684 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:34:05 24684 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:34:05 24684 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000167' at position 226727744 2013-12-13 20:34:05 24684 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:34:05 24684 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000163' at position 262937672, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 262937844 2013-12-13 20:34:05 24684 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:34:05 24684 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:34:05 24684 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000163, end_log_pos 262938189, Error_code: 1032 2013-12-13 20:34:05 24684 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-13 20:34:05 24684 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000163' position 262937672 2013-12-13 20:37:27 24684 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:37:27 24684 [Note] Giving 2 client threads a chance to die gracefully 2013-12-13 20:37:27 24684 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:37:27 24684 [Note] Shutting down slave threads 2013-12-13 20:37:27 24684 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 20:37:27 24684 [Note] Slave I/O thread killed while reading event 2013-12-13 20:37:27 24684 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000167', position 388003455 2013-12-13 20:37:29 24684 [Note] Forcefully disconnecting 1 remaining clients 2013-12-13 20:37:29 24684 [Warning] /usr/sbin/mysqld: Forcing close of thread 4 user: 'root' 2013-12-13 20:37:31 24684 [Note] Binlog end 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'partition' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:37:31 24684 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:37:31 24684 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:37:31 24684 [Note] InnoDB: Starting shutdown... 2013-12-13 20:37:34 24684 [Note] InnoDB: Shutdown completed; log sequence number 693674414215 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'CSV' 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:37:34 24684 [Note] Shutting down plugin 'binlog' 2013-12-13 20:37:34 24684 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 20:37:40 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 20:37:41 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:37:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 20:37:41 28395 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:37:41 7fe7e3dac720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:37:41 28395 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:37:41 28395 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:37:41 28395 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:37:41 28395 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:37:41 28395 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 20:37:46 28395 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:37:46 28395 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:37:48 28395 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:37:48 28395 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:37:48 28395 [Note] InnoDB: 5.6.14 started; log sequence number 693674414215 2013-12-13 20:37:48 28395 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:37:48 28395 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:37:48 28395 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:37:48 28395 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:37:48 28395 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000167' at position 388003455 2013-12-13 20:37:48 28395 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:37:48 28395 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:37:48 28395 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:37:48 28395 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000163' at position 262937672, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 262937844 2013-12-13 20:49:28 28395 [Note] Slave SQL thread exiting, replication stopped in log 'DB8-512567-bin-log.000165' at position 321400155 2013-12-13 20:49:28 28395 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 20:49:28 28395 [Note] Slave I/O thread killed while reading event 2013-12-13 20:49:28 28395 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000167', position 827793453 2013-12-13 20:49:50 28395 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:49:50 28395 [Note] Giving 0 client threads a chance to die gracefully 2013-12-13 20:49:50 28395 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:49:50 28395 [Note] Shutting down slave threads 2013-12-13 20:49:50 28395 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 20:49:52 28395 [Note] Binlog end 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'partition' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:49:52 28395 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:49:52 28395 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:49:52 28395 [Note] InnoDB: Starting shutdown... 2013-12-13 20:50:53 28395 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2013-12-13 20:50:58 28395 [Note] InnoDB: Shutdown completed; log sequence number 695348392840 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'CSV' 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:50:58 28395 [Note] Shutting down plugin 'binlog' 2013-12-13 20:50:58 28395 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 20:51:03 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 20:51:06 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:51:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 20:51:07 6677 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:51:07 7ff10644d720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:51:07 6677 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:51:07 6677 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:51:07 6677 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:51:07 6677 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:51:07 6677 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 20:51:10 6677 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:51:10 6677 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:51:13 6677 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:51:13 6677 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:51:13 6677 [Note] InnoDB: 5.6.14 started; log sequence number 695348392840 2013-12-13 20:51:13 6677 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:51:13 6677 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:51:13 6677 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:51:13 6677 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:51:13 6677 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000167' at position 827793453 2013-12-13 20:51:13 6677 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:51:13 6677 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000165' at position 321400155, relay log '/srv/mysql/DB9-345729-relay-log.000013' position: 321400327 2013-12-13 20:51:13 6677 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:51:13 6677 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 20:51:20 6677 [Note] Slave SQL thread exiting, replication stopped in log 'DB8-512567-bin-log.000165' at position 325619366 2013-12-13 20:51:20 6677 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-13 20:51:20 6677 [Note] Slave I/O thread killed while reading event 2013-12-13 20:51:20 6677 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000167', position 897989176 2013-12-13 20:51:23 6677 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:51:23 6677 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000167' at position 897989176 2013-12-13 20:51:23 6677 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:51:23 6677 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000165' at position 325619366, relay log '/srv/mysql/DB9-345729-relay-log.000013' position: 325619538 2013-12-13 20:56:47 6677 [ERROR] Slave SQL: Could not execute Write_rows event on table memcached.default; Duplicate entry 'func_query_ddb4690ca14974adfb347ea984c9b53c_1325_v2' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log DB8-512567-bin-log.000166, end_log_pos 107204377, Error_code: 1062 2013-12-13 20:56:47 6677 [Warning] Slave: Duplicate entry 'func_query_ddb4690ca14974adfb347ea984c9b53c_1325_v2' for key 'PRIMARY' Error_code: 1062 2013-12-13 20:56:47 6677 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000166' position 107202708 2013-12-13 20:57:36 6677 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000168', position 58163736 2013-12-13 20:57:36 6677 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-13 20:57:36 6677 [Note] Giving 0 client threads a chance to die gracefully 2013-12-13 20:57:36 6677 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-13 20:57:36 6677 [Note] Shutting down slave threads 2013-12-13 20:57:36 6677 [Note] Forcefully disconnecting 0 remaining clients 2013-12-13 20:57:38 6677 [Note] Binlog end 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'partition' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'ARCHIVE' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-13 20:57:38 6677 [Note] Shutting down plugin 'InnoDB' 2013-12-13 20:57:38 6677 [Note] InnoDB: FTS optimize thread exiting. 2013-12-13 20:57:38 6677 [Note] InnoDB: Starting shutdown... 2013-12-13 20:58:27 6677 [Note] InnoDB: Shutdown completed; log sequence number 696024839044 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'CSV' 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'MEMORY' 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'MyISAM' 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'sha256_password' 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'mysql_old_password' 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'mysql_native_password' 2013-12-13 20:58:27 6677 [Note] Shutting down plugin 'binlog' 2013-12-13 20:58:27 6677 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131213 20:58:32 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131213 20:58:44 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-13 20:58:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-13 20:58:45 12454 [Note] Plugin 'FEDERATED' is disabled. 2013-12-13 20:58:45 7f1d66893720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-13 20:58:45 12454 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-13 20:58:45 12454 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-13 20:58:45 12454 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-13 20:58:45 12454 [Note] InnoDB: Using CPU crc32 instructions 2013-12-13 20:58:45 12454 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-13 20:58:49 12454 [Note] InnoDB: Completed initialization of buffer pool 2013-12-13 20:58:49 12454 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-13 20:58:51 12454 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-13 20:58:51 12454 [Note] InnoDB: Waiting for purge to start 2013-12-13 20:58:51 12454 [Note] InnoDB: 5.6.14 started; log sequence number 696024839044 2013-12-13 20:58:51 12454 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-13 20:58:51 12454 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-13 20:58:51 12454 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-13 20:58:51 12454 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-13 20:58:51 12454 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000168' at position 58163736 2013-12-13 20:58:51 12454 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-13 20:58:51 12454 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000166' at position 107202708, relay log '/srv/mysql/DB9-345729-relay-log.000016' position: 107202880 2013-12-13 20:58:51 12454 [Note] Event Scheduler: Loaded 0 events 2013-12-13 20:58:51 12454 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-13 21:04:04 12454 [Warning] Slave SQL: Could not execute Write_rows event on table memcached.default; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT; the event's master log DB8-512567-bin-log.000166, end_log_pos 460658637, Error_code: 1205 2013-12-14 00:37:51 12454 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-14 00:37:51 12454 [Note] Giving 2 client threads a chance to die gracefully 2013-12-14 00:37:51 12454 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-14 00:37:51 12454 [Note] Shutting down slave threads 2013-12-14 00:37:51 12454 [Note] Error reading relay log event: slave SQL thread was killed 2013-12-14 00:37:51 12454 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-14 00:37:51 12454 [Note] Slave I/O thread killed while reading event 2013-12-14 00:37:51 12454 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000173', position 673391745 2013-12-14 00:37:51 12454 [Note] Forcefully disconnecting 0 remaining clients 2013-12-14 00:37:53 12454 [Note] Binlog end 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'partition' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'ARCHIVE' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-14 00:37:53 12454 [Note] Shutting down plugin 'InnoDB' 2013-12-14 00:37:53 12454 [Note] InnoDB: FTS optimize thread exiting. 2013-12-14 00:37:53 12454 [Note] InnoDB: Starting shutdown... 2013-12-14 00:38:54 12454 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2013-12-14 00:39:18 12454 [Note] InnoDB: Shutdown completed; log sequence number 703536165719 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'CSV' 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'MEMORY' 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'MyISAM' 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'sha256_password' 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'mysql_old_password' 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'mysql_native_password' 2013-12-14 00:39:18 12454 [Note] Shutting down plugin 'binlog' 2013-12-14 00:39:18 12454 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131214 00:39:23 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131214 00:39:24 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-14 00:39:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-14 00:39:25 2017 [Note] Plugin 'FEDERATED' is disabled. 2013-12-14 00:39:25 7f4169ae1720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-14 00:39:25 2017 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-14 00:39:25 2017 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-14 00:39:25 2017 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-14 00:39:25 2017 [Note] InnoDB: Using CPU crc32 instructions 2013-12-14 00:39:25 2017 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-14 00:39:28 2017 [Note] InnoDB: Completed initialization of buffer pool 2013-12-14 00:39:29 2017 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-14 00:39:31 2017 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-14 00:39:31 2017 [Note] InnoDB: Waiting for purge to start 2013-12-14 00:39:31 2017 [Note] InnoDB: 5.6.14 started; log sequence number 703536165719 2013-12-14 00:39:31 2017 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-14 00:39:31 2017 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-14 00:39:31 2017 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-14 00:39:31 2017 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-14 00:39:31 2017 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000173' at position 673391745 2013-12-14 00:39:31 2017 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-14 00:39:31 2017 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000173' at position 673391745, relay log '/srv/mysql/DB9-345729-relay-log.000048' position: 673391917 2013-12-14 00:39:31 2017 [Note] Event Scheduler: Loaded 0 events 2013-12-14 00:39:31 2017 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-14 00:39:36 2017 [ERROR] Slave SQL: Could not execute Update_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000173, end_log_pos 676312195, Error_code: 1032 2013-12-14 00:39:36 2017 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-14 00:39:36 2017 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000173' position 676311644 2013-12-14 00:40:09 2017 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-14 00:40:09 2017 [Note] Giving 2 client threads a chance to die gracefully 2013-12-14 00:40:09 2017 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-14 00:40:09 2017 [Note] Shutting down slave threads 2013-12-14 00:40:09 2017 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-14 00:40:09 2017 [Note] Slave I/O thread killed while reading event 2013-12-14 00:40:09 2017 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000173', position 727889670 2013-12-14 00:40:11 2017 [Note] Forcefully disconnecting 0 remaining clients 2013-12-14 00:40:13 2017 [Note] Binlog end 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'partition' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'ARCHIVE' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-14 00:40:13 2017 [Note] Shutting down plugin 'InnoDB' 2013-12-14 00:40:13 2017 [Note] InnoDB: FTS optimize thread exiting. 2013-12-14 00:40:13 2017 [Note] InnoDB: Starting shutdown... 2013-12-14 00:40:18 2017 [Note] InnoDB: Shutdown completed; log sequence number 703538804317 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'CSV' 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'MEMORY' 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'MyISAM' 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'sha256_password' 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'mysql_old_password' 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'mysql_native_password' 2013-12-14 00:40:18 2017 [Note] Shutting down plugin 'binlog' 2013-12-14 00:40:18 2017 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131214 00:40:23 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131214 00:40:30 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-14 00:40:30 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-14 00:40:30 4217 [Note] Plugin 'FEDERATED' is disabled. 2013-12-14 00:40:30 7f2dd3a53720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-14 00:40:30 4217 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-14 00:40:30 4217 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-14 00:40:30 4217 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-14 00:40:30 4217 [Note] InnoDB: Using CPU crc32 instructions 2013-12-14 00:40:30 4217 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-14 00:40:35 4217 [Note] InnoDB: Completed initialization of buffer pool 2013-12-14 00:40:35 4217 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-14 00:40:36 4217 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-14 00:40:37 4217 [Note] InnoDB: Waiting for purge to start 2013-12-14 00:40:37 4217 [Note] InnoDB: 5.6.14 started; log sequence number 703538804317 2013-12-14 00:40:37 4217 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-14 00:40:37 4217 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-14 00:40:37 4217 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-14 00:40:37 4217 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-14 00:40:37 4217 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000173' at position 727889670 2013-12-14 00:40:37 4217 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-14 00:40:37 4217 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000173' at position 676311644, relay log '/srv/mysql/DB9-345729-relay-log.000050' position: 2920191 2013-12-14 00:40:37 4217 [Note] Event Scheduler: Loaded 0 events 2013-12-14 00:40:37 4217 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-14 02:32:15 4217 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-14 02:32:15 4217 [Note] Giving 2 client threads a chance to die gracefully 2013-12-14 02:32:15 4217 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-14 02:32:15 4217 [Note] Shutting down slave threads 2013-12-14 02:32:15 4217 [Note] Error reading relay log event: slave SQL thread was killed 2013-12-14 02:32:15 4217 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-14 02:32:15 4217 [Note] Slave I/O thread killed while reading event 2013-12-14 02:32:15 4217 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000175', position 859643976 2013-12-14 02:32:15 4217 [Note] Forcefully disconnecting 0 remaining clients 2013-12-14 02:32:17 4217 [Note] Binlog end 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'partition' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'ARCHIVE' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-14 02:32:17 4217 [Note] Shutting down plugin 'InnoDB' 2013-12-14 02:32:17 4217 [Note] InnoDB: FTS optimize thread exiting. 2013-12-14 02:32:17 4217 [Note] InnoDB: Starting shutdown... 2013-12-14 02:33:17 4217 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2013-12-14 02:33:55 4217 [Note] InnoDB: Shutdown completed; log sequence number 705880568060 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'CSV' 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'MEMORY' 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'MyISAM' 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'sha256_password' 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'mysql_old_password' 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'mysql_native_password' 2013-12-14 02:33:55 4217 [Note] Shutting down plugin 'binlog' 2013-12-14 02:33:55 4217 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131214 02:34:00 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131214 03:23:27 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-14 03:23:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-14 03:23:29 15485 [Note] Plugin 'FEDERATED' is disabled. 2013-12-14 03:23:29 7f14b208e720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-14 03:23:29 15485 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-14 03:23:29 15485 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-14 03:23:29 15485 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-14 03:23:29 15485 [Note] InnoDB: Using CPU crc32 instructions 2013-12-14 03:23:29 15485 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-14 03:23:35 15485 [Note] InnoDB: Completed initialization of buffer pool 2013-12-14 03:23:36 15485 [ERROR] InnoDB: ./ib_logfile0 can't be opened in read-write mode 2013-12-14 03:23:36 15485 [ERROR] Plugin 'InnoDB' init function returned error. 2013-12-14 03:23:36 15485 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2013-12-14 03:23:36 15485 [ERROR] Failed to initialize plugins. 2013-12-14 03:23:36 15485 [ERROR] Aborting Failed to initialize instance. Error code: 13 2013-12-14 03:23:38 15485 [Note] Binlog end 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'partition' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'ARCHIVE' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'CSV' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'MEMORY' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'MyISAM' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'sha256_password' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'mysql_old_password' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'mysql_native_password' 2013-12-14 03:23:38 15485 [Note] Shutting down plugin 'binlog' 2013-12-14 03:23:38 15485 [Note] /usr/sbin/mysqld: Shutdown complete 131214 03:23:38 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131214 03:24:48 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-14 03:24:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-14 03:24:49 17101 [Note] Plugin 'FEDERATED' is disabled. 2013-12-14 03:24:49 7f2cf44b2720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-14 03:24:49 17101 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-14 03:24:49 17101 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-14 03:24:49 17101 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-14 03:24:49 17101 [Note] InnoDB: Using CPU crc32 instructions 2013-12-14 03:24:49 17101 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-14 03:24:55 17101 [Note] InnoDB: Completed initialization of buffer pool 2013-12-14 03:24:55 17101 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-14 03:25:00 17101 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-14 03:25:00 17101 [Note] InnoDB: Waiting for purge to start 2013-12-14 03:25:00 17101 [Note] InnoDB: 5.6.14 started; log sequence number 718636988018 2013-12-14 03:25:00 17101 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 9b3eb5fb-64a1-11e3-930f-b8ca3a6530b4. 2013-12-14 03:25:00 17101 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-14 03:25:00 17101 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-14 03:25:00 17101 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-14 03:25:00 17101 [Note] Event Scheduler: Loaded 0 events 2013-12-14 03:25:00 17101 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-14 03:25:58 17101 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='192.168.100.90', master_port= 3306, master_log_file='DB8-512567-bin-log.000175', master_log_pos= 904353312, master_bind=''. 2013-12-14 03:26:04 17101 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-14 03:26:04 17101 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-14 03:26:04 17101 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000175' at position 904353312, relay log '/srv/mysql/DB9-345729-relay-log.000001' position: 4 2013-12-14 03:26:04 17101 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000175' at position 904353312 2013-12-14 03:27:13 17101 [ERROR] Slave SQL: Could not execute Delete_rows event on table memcached.memcached; Can't find record in 'memcached', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000175, end_log_pos 987709144, Error_code: 1032 2013-12-14 03:27:13 17101 [Warning] Slave: Can't find record in 'memcached' Error_code: 1032 2013-12-14 03:27:13 17101 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000175' position 987700843 2013-12-14 03:28:06 17101 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-14 03:28:06 17101 [Note] Slave I/O thread killed while reading event 2013-12-14 03:28:06 17101 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000176', position 748186978 2013-12-14 03:28:16 17101 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-14 03:28:16 17101 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-14 03:28:16 17101 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000175' at position 987700843, relay log '/srv/mysql/DB9-345729-relay-log.000002' position: 83347823 2013-12-14 03:28:16 17101 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000176' at position 748186978 2013-12-14 03:28:16 17101 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='/srv/mysql/DB9-345729-relay-log.000002', relay_log_pos='83347823', master_log_name='DB8-512567-bin-log.000175', master_log_pos='987700843' and new position at relay_log_file='/srv/mysql/DB9-345729-relay-log.000002', relay_log_pos='84135577', master_log_name='DB8-512567-bin-log.000175', master_log_pos='988488597' 2013-12-14 03:28:16 17101 [ERROR] Slave SQL: Could not execute Delete_rows event on table memcached.default; Can't find record in 'default', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log DB8-512567-bin-log.000175, end_log_pos 988608364, Error_code: 1032 2013-12-14 03:28:16 17101 [Warning] Slave: Can't find record in 'default' Error_code: 1032 2013-12-14 03:28:16 17101 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'DB8-512567-bin-log.000175' position 988600036 2013-12-14 03:28:45 17101 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-14 03:28:45 17101 [Note] Giving 1 client threads a chance to die gracefully 2013-12-14 03:28:45 17101 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-14 03:28:45 17101 [Note] Shutting down slave threads 2013-12-14 03:28:45 17101 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-14 03:28:45 17101 [Note] Slave I/O thread killed while reading event 2013-12-14 03:28:45 17101 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000176', position 757665471 2013-12-14 03:28:45 17101 [Note] Forcefully disconnecting 0 remaining clients 2013-12-14 03:28:47 17101 [Note] Binlog end 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'partition' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'ARCHIVE' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-14 03:28:47 17101 [Note] Shutting down plugin 'InnoDB' 2013-12-14 03:28:47 17101 [Note] InnoDB: FTS optimize thread exiting. 2013-12-14 03:28:47 17101 [Note] InnoDB: Starting shutdown... 2013-12-14 03:28:51 17101 [Note] InnoDB: Shutdown completed; log sequence number 718667970605 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'CSV' 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'MEMORY' 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'MyISAM' 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'sha256_password' 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'mysql_old_password' 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'mysql_native_password' 2013-12-14 03:28:51 17101 [Note] Shutting down plugin 'binlog' 2013-12-14 03:28:51 17101 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131214 03:28:57 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131214 03:29:11 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-14 03:29:11 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-14 03:29:11 20864 [Note] Plugin 'FEDERATED' is disabled. 2013-12-14 03:29:11 7f57c093d720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-14 03:29:11 20864 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-14 03:29:11 20864 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-14 03:29:11 20864 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-14 03:29:11 20864 [Note] InnoDB: Using CPU crc32 instructions 2013-12-14 03:29:11 20864 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-14 03:29:16 20864 [Note] InnoDB: Completed initialization of buffer pool 2013-12-14 03:29:16 20864 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-14 03:29:18 20864 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-14 03:29:18 20864 [Note] InnoDB: Waiting for purge to start 2013-12-14 03:29:18 20864 [Note] InnoDB: 5.6.14 started; log sequence number 718667970605 2013-12-14 03:29:18 20864 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-14 03:29:18 20864 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-14 03:29:18 20864 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-14 03:29:19 20864 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-14 03:29:19 20864 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000176' at position 757665471 2013-12-14 03:29:19 20864 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-14 03:29:19 20864 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000175' at position 988600036, relay log '/srv/mysql/DB9-345729-relay-log.000002' position: 84247016 2013-12-14 03:29:19 20864 [Note] Event Scheduler: Loaded 0 events 2013-12-14 03:29:19 20864 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-14 03:40:17 20864 [Note] Slave SQL thread exiting, replication stopped in log 'DB8-512567-bin-log.000176' at position 899646740 2013-12-14 03:40:17 20864 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2013-12-14 03:40:17 20864 [Note] Slave I/O thread killed while reading event 2013-12-14 03:40:17 20864 [Note] Slave I/O thread exiting, read up to log 'DB8-512567-bin-log.000176', position 928832747 2013-12-14 03:40:28 20864 [Note] /usr/sbin/mysqld: Normal shutdown 2013-12-14 03:40:28 20864 [Note] Giving 0 client threads a chance to die gracefully 2013-12-14 03:40:28 20864 [Note] Event Scheduler: Purging the queue. 0 events 2013-12-14 03:40:28 20864 [Note] Shutting down slave threads 2013-12-14 03:40:28 20864 [Note] Forcefully disconnecting 0 remaining clients 2013-12-14 03:40:30 20864 [Note] Binlog end 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'partition' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'ARCHIVE' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'BLACKHOLE' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_METRICS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_CMP' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'INNODB_TRX' 2013-12-14 03:40:30 20864 [Note] Shutting down plugin 'InnoDB' 2013-12-14 03:40:30 20864 [Note] InnoDB: FTS optimize thread exiting. 2013-12-14 03:40:30 20864 [Note] InnoDB: Starting shutdown... 2013-12-14 03:41:31 20864 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2013-12-14 03:42:00 20864 [Note] InnoDB: Shutdown completed; log sequence number 719393080927 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'MRG_MYISAM' 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'CSV' 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'MEMORY' 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'MyISAM' 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'sha256_password' 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'mysql_old_password' 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'mysql_native_password' 2013-12-14 03:42:00 20864 [Note] Shutting down plugin 'binlog' 2013-12-14 03:42:00 20864 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 2 threads didn't exit 131214 03:42:05 mysqld_safe mysqld from pid file /srv/mysql/544609-db9.com.pid ended 131214 03:42:20 mysqld_safe Starting mysqld daemon with databases from /srv/mysql 2013-12-14 03:42:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-12-14 03:42:20 31407 [Note] Plugin 'FEDERATED' is disabled. 2013-12-14 03:42:20 7f2520507720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-12-14 03:42:20 31407 [Note] InnoDB: The InnoDB memory heap is disabled 2013-12-14 03:42:20 31407 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-12-14 03:42:20 31407 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-12-14 03:42:20 31407 [Note] InnoDB: Using CPU crc32 instructions 2013-12-14 03:42:20 31407 [Note] InnoDB: Initializing buffer pool, size = 70.0G 2013-12-14 03:42:25 31407 [Note] InnoDB: Completed initialization of buffer pool 2013-12-14 03:42:25 31407 [Note] InnoDB: Highest supported file format is Barracuda. 2013-12-14 03:42:27 31407 [Note] InnoDB: 128 rollback segment(s) are active. 2013-12-14 03:42:27 31407 [Note] InnoDB: Waiting for purge to start 2013-12-14 03:42:27 31407 [Note] InnoDB: 5.6.14 started; log sequence number 719393080927 2013-12-14 03:42:27 31407 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2013-12-14 03:42:27 31407 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2013-12-14 03:42:27 31407 [Note] Server socket created on IP: '0.0.0.0'. 2013-12-14 03:42:27 31407 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2013-12-14 03:42:27 31407 [Note] Slave I/O thread: connected to master 'replicant@192.168.100.90:3306',replication started in log 'DB8-512567-bin-log.000176' at position 928832747 2013-12-14 03:42:27 31407 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-14 03:42:27 31407 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000176' at position 899646740, relay log '/srv/mysql/DB9-345729-relay-log.000007' position: 141981561 2013-12-14 03:42:27 31407 [Note] Event Scheduler: Loaded 0 events 2013-12-14 03:42:27 31407 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.14-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-12-16 02:44:58 31407 [Note] Error reading relay log event: slave SQL thread was killed 2013-12-16 02:44:59 31407 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2013-12-16 02:44:59 31407 [Note] Slave SQL thread initialized, starting replication in log 'DB8-512567-bin-log.000251' at position 899423753, relay log '/srv/mysql/DB9-345729-relay-log.000233' position: 899423925