Feb 17 09:18:11 optdb01 mysqld_safe: Number of processes running now: 0 Feb 17 09:18:11 optdb01 mysqld_safe: mysqld restarted Feb 17 09:18:11 optdb01 mysqld: 160217 9:18:11 [Note] /usr/sbin/mysqld (mysqld 10.0.23-MariaDB-log) starting as process 25113 ... Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: Using mutexes to ref count buffer pool pages Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: The InnoDB memory heap is disabled Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: Memory barrier is not used Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: Compressed tables use zlib 1.2.7 Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: Using Linux native AIO Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: Using CPU crc32 instructions Feb 17 09:18:13 optdb01 mysqld: 160217 9:18:13 [Note] InnoDB: Initializing buffer pool, size = 128.0M Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Completed initialization of buffer pool Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Opened 16 undo tablespaces Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Highest supported file format is Barracuda. Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Log scan progressed past the checkpoint lsn 379958775400 Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Database was not shutdown normally! Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Starting crash recovery. Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Reading tablespace information from the .ibd files... Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: Restoring possible half-written data pages Feb 17 09:18:14 optdb01 mysqld: 160217 9:18:14 [Note] InnoDB: from the doublewrite buffer... Feb 17 09:18:14 optdb01 mysqld: InnoDB: Doing recovery: scanned up to log sequence number 379959516079 Feb 17 09:18:15 optdb01 mysqld: 160217 9:18:15 [Note] InnoDB: Starting an apply batch of log records to the database... Feb 17 09:18:16 optdb01 mysqld: InnoDB: Progress in percent: 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 Feb 17 09:18:16 optdb01 mysqld: InnoDB: Apply batch completed Feb 17 09:18:16 optdb01 mysqld: InnoDB: Last MySQL binlog file position 0 858803592, file name /var/lib/mysql/binary-logs/optdb01.000669 Feb 17 09:18:16 optdb01 mysqld: 160217 9:18:16 [Note] InnoDB: 128 rollback segment(s) are active. Feb 17 09:18:16 optdb01 mysqld: 160217 9:18:16 [Note] InnoDB: Waiting for purge to start Feb 17 09:18:16 optdb01 mysqld: 160217 9:18:16 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 379959516079 Feb 17 09:18:16 optdb01 mysqld: 2016-02-17 09:18:16 7f8a423f9700 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool Feb 17 09:18:17 optdb01 mysqld: 160217 9:18:17 [Note] Plugin 'FEEDBACK' is disabled. Feb 17 09:18:17 optdb01 mysqld: 2016-02-17 09:18:17 7f8a423f9700 InnoDB: Buffer pool(s) load completed at 160217 9:18:17 Feb 17 09:18:17 optdb01 mysqld: Wed Feb 17 09:18:17 2016 PerconaFT recovery starting in env /var/lib/mysql/ Feb 17 09:18:17 optdb01 mysqld: Wed Feb 17 09:18:17 2016 PerconaFT recovery scanning backward from 120530613077 Feb 17 09:18:22 optdb01 mysqld: Wed Feb 17 09:18:22 2016 PerconaFT recovery bw_end_checkpoint at 120529422669 timestamp 1455700646006605 xid 120529185810 (bw_newer) Feb 17 09:18:23 optdb01 mysqld: Wed Feb 17 09:18:23 2016 PerconaFT recovery bw_begin_checkpoint at 120529185810 timestamp 1455700636845983 (bw_between) Feb 17 09:18:23 optdb01 mysqld: Wed Feb 17 09:18:23 2016 PerconaFT recovery turning around at begin checkpoint 120529185810 time 9160622 Feb 17 09:18:23 optdb01 mysqld: Wed Feb 17 09:18:23 2016 PerconaFT recovery starts scanning forward to 120530613077 from 120529185810 left 1427267 (fw_between) Feb 17 09:18:32 optdb01 mysqld: Wed Feb 17 09:18:32 2016 PerconaFT recovery scanning forward to 120530613077 at 120529187810 left 1425267 (fw_between) Feb 17 09:18:47 optdb01 mysqld: Wed Feb 17 09:18:47 2016 PerconaFT recovery scanning forward to 120530613077 at 120530401810 left 211267 (fw_newer) Feb 17 09:18:49 optdb01 mysqld: Wed Feb 17 09:18:49 2016 PerconaFT recovery has 1 live transaction Feb 17 09:18:49 optdb01 mysqld: recover_abort_live_txn 20051226515 Feb 17 09:19:00 optdb01 mysqld: Wed Feb 17 09:19:00 2016 PerconaFT recovery closing 1276 dictionaries Feb 17 09:19:04 optdb01 mysqld: Wed Feb 17 09:19:04 2016 PerconaFT recovery making a checkpoint Feb 17 09:19:04 optdb01 mysqld: Wed Feb 17 09:19:04 2016 PerconaFT recovery done Feb 17 09:19:04 optdb01 mysqld: 160217 9:19:04 [Note] Recovering after a crash using /var/lib/mysql/binary-logs/optdb01 Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Starting crash recovery... Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Crash recovery finished. Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Server socket created on IP: '0.0.0.0'. Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Server socket created on IP: '0.0.0.0'. Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [ERROR] mysqld: Table 'event' is marked as crashed and should be repaired Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Warning] Checking table: './mysql/event' Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Reading Master_info: 'master-lon3aggdb07.info' Relay_info:'relay-log-lon3aggdb07.info' Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Initialized Master_info from 'master-lon3aggdb07.info' Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Added new Master_info 'lon3aggdb07' to hash table Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Reading Master_info: 'master-toolsdb05.info' Relay_info:'relay-log-toolsdb05.info' Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Initialized Master_info from 'master-toolsdb05.info' Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Added new Master_info 'toolsdb05' to hash table Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Reading Master_info: 'master-lon3aggdb01.info' Relay_info:'relay-log-lon3aggdb01.info' Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Initialized Master_info from 'master-lon3aggdb01.info' Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Added new Master_info 'lon3aggdb01' to hash table Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Reading of all Master_info entries succeded Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] Added new Master_info '' to hash table Feb 17 09:19:06 optdb01 mysqld: 160217 9:19:06 [Note] /usr/sbin/mysqld: ready for connections. Feb 17 09:19:06 optdb01 mysqld: Version: '10.0.23-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Feb 17 09:19:12 optdb01 mysqld: 160217 9:19:12 [Note] Start binlog_dump to slave_server(316126), pos(optdb01.000669, 858820066) Feb 17 09:19:12 optdb01 mysqld: 160217 9:19:12 [Note] Start binlog_dump to slave_server(32347), pos(optdb01.000669, 858820066)