Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] /usr/sbin/mysqld: Normal shutdown Jan 11 12:13:56 dbmysql1 mysqld: Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: Stop replication Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: Closing send monitor... Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: Closed send monitor. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: gcomm: terminating thread Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: gcomm: joining thread Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: gcomm: closing backend Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: view(view_id(NON_PRIM,4486b9f1,79) memb { Jan 11 12:13:56 dbmysql1 mysqld: #0114486b9f1,0 Jan 11 12:13:56 dbmysql1 mysqld: } joined { Jan 11 12:13:56 dbmysql1 mysqld: } left { Jan 11 12:13:56 dbmysql1 mysqld: } partitioned { Jan 11 12:13:56 dbmysql1 mysqld: #01152d55d55,0 Jan 11 12:13:56 dbmysql1 mysqld: #011b8168d00,0 Jan 11 12:13:56 dbmysql1 mysqld: }) Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: view((empty)) Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: gcomm: closed Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: Flow-control interval: [16, 16] Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: Received NON-PRIMARY. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3117204) Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: Received self-leave message. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: Flow-control interval: [0, 0] Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: Received SELF-LEAVE. Closing connection. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 3117204) Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851602999040 [Note] WSREP: RECV thread exiting 0: Success Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851893757696 [Note] WSREP: New cluster view: global state: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117204, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851893757696 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851893757696 [Note] WSREP: New cluster view: global state: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117204, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851893757696 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851893757696 [Note] WSREP: applier thread exiting (code:0) Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: recv_thread() joined. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: Closing replication queue. Jan 11 12:13:56 dbmysql1 mysqld: 2016-01-11 12:13:56 139851875899136 [Note] WSREP: Closing slave action queue. Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851893958400 [Note] WSREP: rollbacker thread exiting Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] Event Scheduler: Purging the queue. 0 events Jan 11 12:13:58 dbmysql1 /etc/mysql/debian-start[16452]: /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") when executing 'CHECK TABLE ... FOR UPGRADE' Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: dtor state: CLOSED Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: mon: entered 135 oooe fraction 0 oool fraction 0 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: mon: entered 135 oooe fraction 0 oool fraction 0 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: mon: entered 115 oooe fraction 0 oool fraction 0.00869565 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: cert index usage at exit 0 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: cert trx map usage at exit 2 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: deps set usage at exit 0 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: avg deps dist 4.16129 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: avg cert interval 0.0430108 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: cert index size 455 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851667736320 [Note] WSREP: Service thread queue flushed. Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 1, in use: 0, in pool: 1 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0.895522, misses: 14, in use: 0, in pool: 14 Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 3117204) Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] WSREP: Flushing memory map to disk... Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139848732075776 [Note] InnoDB: FTS optimize thread exiting. Jan 11 12:13:58 dbmysql1 mysqld: 2016-01-11 12:13:58 139851875899136 [Note] InnoDB: Starting shutdown... Jan 11 12:14:00 dbmysql1 mysqld: 2016-01-11 12:14:00 139851875899136 [Note] InnoDB: Shutdown completed; log sequence number 162568171784 Jan 11 12:14:00 dbmysql1 mysqld: 2016-01-11 12:14:00 139851875899136 [Note] /usr/sbin/mysqld: Shutdown complete Jan 11 12:14:00 dbmysql1 mysqld: Jan 11 12:14:00 dbmysql1 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Jan 11 12:14:01 dbmysql1 mysqld_safe: Starting mysqld_using_numactl daemon with databases from /mnt/disco2/mysql Jan 11 12:14:01 dbmysql1 mysqld_safe: WSREP: Running position recovery with --log_error='/mnt/disco2/mysql/wsrep_recovery.OKfdZY' --pid-file='/mnt/disco2/mysql/dbmysql1.cc.upv.es-recover.pid' Jan 11 12:14:01 dbmysql1 mysqld: 2016-01-11 12:14:01 140145852245952 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. Jan 11 12:14:01 dbmysql1 mysqld: 2016-01-11 12:14:01 140145852245952 [Note] /usr/sbin/mysqld (mysqld 10.1.10-MariaDB-1~trusty) starting as process 16932 ... Jan 11 12:14:20 dbmysql1 mysqld_safe: WSREP: Failed to recover position: '2016-01-11 12:13:18 140546293131200 [ERROR] mysqld: Can't lock aria control file '/mnt/disco2/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds#0122016-01-11 12:13:49 140546293131200 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/mnt/disco2/mysql/aria_log_control'#0122016-01-11 12:13:49 140546293131200 [ERROR] Plugin 'Aria' init function returned error.#0122016-01-11 12:13:49 140546293131200 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Using mutexes to ref count buffer pool pages#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: The InnoDB memory heap is disabled#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Memory barrier is not used#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Compressed tables use zlib 1.2.8#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Using Linux native AIO#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Using generic crc32 instructions#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Initializing buffer pool, size = 2.0G#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Completed initialization of buffer pool#0122016-01-11 12:13:49 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:49 140546293131200 [Note] InnoDB: Retrying to lock the first data file#0122016-01-11 12:13:50 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:50 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:51 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:51 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:52 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:52 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:53 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:53 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:54 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:54 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:55 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:55 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:56 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:56 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:57 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:57 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:58 140546293131200 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11#0122016-01-11 12:13:58 140546293131200 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.#0122016-01-11 12:13:59 140546293131200 [Note] InnoDB: Highest supported file format is Barracuda.#0122016-01-11 12:14:18 140546293131200 [Note] InnoDB: 128 rollback segment(s) are active.#0122016-01-11 12:14:18 140546293131200 [Note] InnoDB: Waiting for purge to start#0122016-01-11 12:14:18 140546293131200 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 162568171784#0122016-01-11 12:14:18 140546293131200 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.#0122016-01-11 12:14:18 140546293131200 [Note] Plugin 'FEEDBACK' is disabled.#0122016-01-11 12:14:18 140546293131200 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables#0122016-01-11 12:14:18 140546293131200 [ERROR] Aborting' Jan 11 12:14:32 dbmysql1 /etc/init.d/mysql[17293]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")' Jan 11 12:14:32 dbmysql1 /etc/init.d/mysql[17293]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jan 11 12:14:39 dbmysql1 mysqld_safe: WSREP: Recovered position 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117204 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] /usr/sbin/mysqld (mysqld 10.1.10-MariaDB-1~trusty) starting as process 17325 ... Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Read nil XID from storage engines, skipping position init Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: wsrep_load(): Galera 3.9(rXXXX) by Codership Oy loaded successfully. Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm. Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Found saved state: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117204 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Passing config to GCS: base_host = 158.42.249.185; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /mnt/disco2/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mnt/disco2/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false Jan 11 12:14:39 dbmysql1 mysqld: ; pc.ignore_sb = false; pc.npvo = false; pc Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680202458880 [Note] WSREP: Service thread queue flushed. Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Assign initial position for certification: 3117204, protocol version: -1 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: wsrep_sst_grab() Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Start replication Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Setting initial position to 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117204 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: protonet asio version 0 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Using CRC-32C for message checksums. Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: backend: asio Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: restore pc from disk failed Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: GMCast version 0 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: (81abebc1, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: (81abebc1, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: EVS version 0 Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: gcomm: connecting to group 'asic_db_cluster', peer 'dbmysql1.cc.upv.es:,dbmysql2.cc.upv.es:,dbmysql3.cc.upv.es:' Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Warning] WSREP: (81abebc1, 'tcp://0.0.0.0:4567') address 'tcp://127.0.1.1:4567' points to own listening address, blacklisting Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: (81abebc1, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: declaring 52d55d55 at tcp://158.42.249.186:4567 stable Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: declaring b8168d00 at tcp://158.42.249.187:4567 stable Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: Node 52d55d55 state prim Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: view(view_id(PRIM,52d55d55,81) memb { Jan 11 12:14:39 dbmysql1 mysqld: #01152d55d55,0 Jan 11 12:14:39 dbmysql1 mysqld: #01181abebc1,0 Jan 11 12:14:39 dbmysql1 mysqld: #011b8168d00,0 Jan 11 12:14:39 dbmysql1 mysqld: } joined { Jan 11 12:14:39 dbmysql1 mysqld: } left { Jan 11 12:14:39 dbmysql1 mysqld: } partitioned { Jan 11 12:14:39 dbmysql1 mysqld: }) Jan 11 12:14:39 dbmysql1 mysqld: 2016-01-11 12:14:39 139680428042176 [Note] WSREP: save pc into disk Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680428042176 [Note] WSREP: gcomm: connected Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680428042176 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680428042176 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680428042176 [Note] WSREP: Opened channel 'asic_db_cluster' Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680428042176 [Note] WSREP: Waiting for SST to complete. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: STATE EXCHANGE: sent state msg: c8c7a841-b854-11e5-94fd-ae714050a904 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: STATE EXCHANGE: got state msg: c8c7a841-b854-11e5-94fd-ae714050a904 from 0 (dbmysql2.cc.upv.es) Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: STATE EXCHANGE: got state msg: c8c7a841-b854-11e5-94fd-ae714050a904 from 2 (dbmysql3.cc.upv.es) Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: STATE EXCHANGE: got state msg: c8c7a841-b854-11e5-94fd-ae714050a904 from 1 (dbmysql1.cc.upv.es) Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: Quorum results: Jan 11 12:14:40 dbmysql1 mysqld: #011version = 3, Jan 11 12:14:40 dbmysql1 mysqld: #011component = PRIMARY, Jan 11 12:14:40 dbmysql1 mysqld: #011conf_id = 53, Jan 11 12:14:40 dbmysql1 mysqld: #011members = 2/3 (joined/total), Jan 11 12:14:40 dbmysql1 mysqld: #011act_id = 3117263, Jan 11 12:14:40 dbmysql1 mysqld: #011last_appl. = -1, Jan 11 12:14:40 dbmysql1 mysqld: #011protocols = 0/7/3 (gcs/repl/appl), Jan 11 12:14:40 dbmysql1 mysqld: #011group UUID = 0b0379b3-a949-11e5-b414-ab8a34af3e6e Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: Flow-control interval: [28, 28] Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3117263) Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: State transfer required: Jan 11 12:14:40 dbmysql1 mysqld: #011Group state: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117263 Jan 11 12:14:40 dbmysql1 mysqld: #011Local state: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117204 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: New cluster view: global state: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117263, view# 54: Primary, number of nodes: 3, my index: 1, protocol version 3 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Warning] WSREP: Gap in state sequence. Need state transfer. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680108508928 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '158.42.249.185' --datadir '/mnt/disco2/mysql/' --parent '17325' '' ' Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: Prepared SST request: rsync|158.42.249.185:4444/rsync_sst Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: REPL Protocols: 7 (3, 2) Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680202458880 [Note] WSREP: Service thread queue flushed. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: Assign initial position for certification: 3117263, protocol version: 3 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680202458880 [Note] WSREP: Service thread queue flushed. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: Prepared IST receiver, listening at: tcp://158.42.249.185:4568 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: Member 1.0 (dbmysql1.cc.upv.es) requested state transfer from '*any*'. Selected 2.0 (dbmysql3.cc.upv.es)(SYNCED) as donor. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3117263) Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680427833088 [Note] WSREP: Requesting state transfer: success, donor: 2 Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: 2.0 (dbmysql3.cc.upv.es): State transfer to 1.0 (dbmysql1.cc.upv.es) complete. Jan 11 12:14:40 dbmysql1 mysqld: 2016-01-11 12:14:40 139680137729792 [Note] WSREP: Member 2.0 (dbmysql3.cc.upv.es) synced with group. Jan 11 12:14:41 dbmysql1 mysqld: WSREP_SST: [INFO] Joiner cleanup. rsync PID: 17365 (20160111 12:14:41.318) Jan 11 12:14:41 dbmysql1 mysqld: WSREP_SST: [INFO] Joiner cleanup done. (20160111 12:14:41.824) Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] WSREP: SST complete, seqno: 3117204 Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: Using mutexes to ref count buffer pool pages Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: The InnoDB memory heap is disabled Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: Memory barrier is not used Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: Compressed tables use zlib 1.2.8 Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: Using Linux native AIO Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: Using generic crc32 instructions Jan 11 12:14:41 dbmysql1 mysqld: 2016-01-11 12:14:41 139680428042176 [Note] InnoDB: Initializing buffer pool, size = 2.0G Jan 11 12:14:42 dbmysql1 mysqld: 2016-01-11 12:14:42 139680428042176 [Note] InnoDB: Completed initialization of buffer pool Jan 11 12:14:42 dbmysql1 mysqld: 2016-01-11 12:14:42 139680428042176 [Note] InnoDB: Highest supported file format is Barracuda. Jan 11 12:14:43 dbmysql1 mysqld: 2016-01-11 12:14:43 139680146122496 [Note] WSREP: (81abebc1, 'tcp://0.0.0.0:4567') turning message relay requesting off Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] InnoDB: 128 rollback segment(s) are active. Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] InnoDB: Waiting for purge to start Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 162568171804 Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139677281519360 [Note] InnoDB: Dumping buffer pool(s) not yet started Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] Plugin 'FEEDBACK' is disabled. Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] Server socket created on IP: '0.0.0.0'. Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] WSREP: Signalling provider to continue. Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] WSREP: SST received: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117204 Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680427833088 [Note] WSREP: Receiving IST: 59 writesets, seqnos 3117204-3117263 Jan 11 12:15:02 dbmysql1 mysqld: 2016-01-11 12:15:02 139680428042176 [Note] /usr/sbin/mysqld: ready for connections. Jan 11 12:15:02 dbmysql1 mysqld: Version: '10.1.10-MariaDB-1~trusty' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Jan 11 12:15:03 dbmysql1 mysqld: 2016-01-11 12:15:03 139680427833088 [Note] WSREP: IST received: 0b0379b3-a949-11e5-b414-ab8a34af3e6e:3117263 Jan 11 12:15:03 dbmysql1 mysqld: 2016-01-11 12:15:03 139680137729792 [Note] WSREP: 1.0 (dbmysql1.cc.upv.es): State transfer from 2.0 (dbmysql3.cc.upv.es) complete. Jan 11 12:15:03 dbmysql1 mysqld: 2016-01-11 12:15:03 139680137729792 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3117294) Jan 11 12:15:03 dbmysql1 mysqld: 2016-01-11 12:15:03 139680137729792 [Note] WSREP: Member 1.0 (dbmysql1.cc.upv.es) synced with group. Jan 11 12:15:03 dbmysql1 mysqld: 2016-01-11 12:15:03 139680137729792 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3117294) Jan 11 12:15:04 dbmysql1 mysqld: 2016-01-11 12:15:04 139680427833088 [Note] WSREP: Synchronized with group, ready for connections Jan 11 12:15:04 dbmysql1 mysqld: 2016-01-11 12:15:04 139680427833088 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.