Skip to content

Instantly share code, notes, and snippets.

/mysql_error.log Secret

Created May 16, 2013
Embed
What would you like to do?
130515 21:13:38 [Note] WSREP: (94815cf5-bdda-11e2-0800-fb01bec433f4, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.0.2.11:4567
130515 21:13:39 [Note] WSREP: (94815cf5-bdda-11e2-0800-fb01bec433f4, 'tcp://0.0.0.0:4567') reconnecting to 1a633e88-bddb-11e2-0800-58d9472b0386 (tcp://10.0.2.11:4567), attempt 0
130515 21:13:43 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,1a633e88-bddb-11e2-0800-58d9472b0386,10)) suspecting node: 1a633e88-bddb-11e2-0800-58d9472b0386
130515 21:13:43 [Note] WSREP: declaring e4cd22cb-bdda-11e2-0800-87707ee4ab49 stable
130515 21:13:43 [Note] WSREP: Node 94815cf5-bdda-11e2-0800-fb01bec433f4 state prim
130515 21:13:43 [Note] WSREP: view(view_id(PRIM,94815cf5-bdda-11e2-0800-fb01bec433f4,11) memb {
94815cf5-bdda-11e2-0800-fb01bec433f4,
e4cd22cb-bdda-11e2-0800-87707ee4ab49,
} joined {
} left {
} partitioned {
1a633e88-bddb-11e2-0800-58d9472b0386,
})
130515 21:13:43 [Note] WSREP: forgetting 1a633e88-bddb-11e2-0800-58d9472b0386 (tcp://10.0.2.11:4567)
130515 21:13:43 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
130515 21:13:43 [Note] WSREP: (94815cf5-bdda-11e2-0800-fb01bec433f4, 'tcp://0.0.0.0:4567') turning message relay requesting off
130515 21:13:43 [Note] WSREP: STATE_EXCHANGE: sent state UUID: ff4dd2f8-bdde-11e2-0800-551d878dfda5
130515 21:13:43 [Note] WSREP: STATE EXCHANGE: sent state msg: ff4dd2f8-bdde-11e2-0800-551d878dfda5
130515 21:13:43 [Note] WSREP: STATE EXCHANGE: got state msg: ff4dd2f8-bdde-11e2-0800-551d878dfda5 from 1 (aquaman)
130515 21:13:43 [Note] WSREP: STATE EXCHANGE: got state msg: ff4dd2f8-bdde-11e2-0800-551d878dfda5 from 0 (gambit)
130515 21:13:43 [Note] WSREP: Quorum results:
version = 2,
component = PRIMARY,
conf_id = 4,
members = 2/2 (joined/total),
act_id = 38078,
last_appl. = 38071,
protocols = 0/4/2 (gcs/repl/appl),
group UUID = 16819721-b6c1-11e2-0800-8d78b46e9a6d
130515 21:13:43 [Note] WSREP: Flow-control interval: [23, 23]
130515 21:13:43 [Note] WSREP: New cluster view: global state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078, view# 5: Primary, number of nodes: 2, my index: 0, protocol version 2
130515 21:13:43 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:13:43 [Note] WSREP: Assign initial position for certification: 38078, protocol version: 2
130515 21:13:49 [Note] WSREP: cleaning up 1a633e88-bddb-11e2-0800-58d9472b0386 (tcp://10.0.2.11:4567)
130515 21:14:07 [Note] WSREP: (94815cf5-bdda-11e2-0800-fb01bec433f4, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.0.2.51:4567
130515 21:14:08 [Note] WSREP: (94815cf5-bdda-11e2-0800-fb01bec433f4, 'tcp://0.0.0.0:4567') reconnecting to e4cd22cb-bdda-11e2-0800-87707ee4ab49 (tcp://10.0.2.51:4567), attempt 0
130515 21:14:11 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, OPERATIONAL, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:12 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:12 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:13 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:13 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:14 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:14 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:15 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:15 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:16 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:16 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:17 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:17 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:18 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:18 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:19 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:19 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:20 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:20 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:21 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) suspecting node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:21 [Note] WSREP: evs::proto(94815cf5-bdda-11e2-0800-fb01bec433f4, GATHER, view_id(REG,94815cf5-bdda-11e2-0800-fb01bec433f4,11)) detected inactive node: e4cd22cb-bdda-11e2-0800-87707ee4ab49
130515 21:14:22 [Note] WSREP: view(view_id(NON_PRIM,94815cf5-bdda-11e2-0800-fb01bec433f4,11) memb {
94815cf5-bdda-11e2-0800-fb01bec433f4,
} joined {
} left {
} partitioned {
e4cd22cb-bdda-11e2-0800-87707ee4ab49,
})
130515 21:14:22 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
130515 21:14:22 [Note] WSREP: Flow-control interval: [16, 16]
130515 21:14:22 [Note] WSREP: Received NON-PRIMARY.
130515 21:14:22 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 38078)
130515 21:14:22 [Note] WSREP: view(view_id(NON_PRIM,94815cf5-bdda-11e2-0800-fb01bec433f4,12) memb {
94815cf5-bdda-11e2-0800-fb01bec433f4,
} joined {
} left {
} partitioned {
e4cd22cb-bdda-11e2-0800-87707ee4ab49,
})
130515 21:14:22 [Note] WSREP: New cluster view: global state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 2
130515 21:14:22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:14:22 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
130515 21:14:22 [Note] WSREP: Flow-control interval: [16, 16]
130515 21:14:22 [Note] WSREP: Received NON-PRIMARY.
130515 21:14:22 [Note] WSREP: New cluster view: global state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 2
130515 21:14:22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:14:23 [Note] /usr/sbin/mysqld: Normal shutdown
130515 21:14:23 [Note] WSREP: Stop replication
130515 21:14:23 [Note] WSREP: Closing send monitor...
130515 21:14:23 [Note] WSREP: Closed send monitor.
130515 21:14:23 [Note] WSREP: gcomm: terminating thread
130515 21:14:23 [Note] WSREP: gcomm: joining thread
130515 21:14:23 [Note] WSREP: gcomm: closing backend
130515 21:14:23 [Note] WSREP: view((empty))
130515 21:14:23 [Note] WSREP: Received self-leave message.
130515 21:14:23 [Note] WSREP: gcomm: closed
130515 21:14:23 [Note] WSREP: Flow-control interval: [0, 0]
130515 21:14:23 [Note] WSREP: Received SELF-LEAVE. Closing connection.
130515 21:14:23 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 38078)
130515 21:14:23 [Note] WSREP: RECV thread exiting 0: Success
130515 21:14:23 [Note] WSREP: New cluster view: global state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 2
130515 21:14:23 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:14:23 [Note] WSREP: recv_thread() joined.
130515 21:14:23 [Note] WSREP: Closing slave action queue.
130515 21:14:23 [Note] WSREP: applier thread exiting (code:0)
130515 21:14:23 [Note] WSREP: applier thread exiting (code:5)
130515 21:14:23 [Note] WSREP: applier thread exiting (code:5)
130515 21:14:23 [Note] WSREP: applier thread exiting (code:5)
130515 21:14:23 [Note] WSREP: applier thread exiting (code:5)
130515 21:14:23 [Note] WSREP: applier thread exiting (code:5)
130515 21:14:23 [Note] WSREP: applier thread exiting (code:5)
130515 21:14:23 [Note] WSREP: applier thread exiting (code:5)
130515 21:14:25 [Note] WSREP: killing local connection: 330
130515 21:14:25 [Note] WSREP: killing local connection: 329
130515 21:14:25 [Note] WSREP: killing local connection: 328
130515 21:14:25 [Note] WSREP: killing local connection: 322
130515 21:14:25 [Note] WSREP: killing local connection: 321
130515 21:14:25 [Note] WSREP: killing local connection: 320
130515 21:14:25 [Note] WSREP: killing local connection: 311
130515 21:14:25 [Note] WSREP: killing local connection: 310
130515 21:14:25 [Note] WSREP: killing local connection: 309
130515 21:14:25 [Note] WSREP: killing local connection: 285
130515 21:14:25 [Note] WSREP: killing local connection: 284
130515 21:14:25 [Note] WSREP: killing local connection: 283
130515 21:14:25 [Note] WSREP: killing local connection: 282
130515 21:14:25 [Note] WSREP: killing local connection: 279
130515 21:14:25 [Note] WSREP: killing local connection: 276
130515 21:14:25 [Note] WSREP: rollbacker thread exiting
130515 21:14:25 [Note] Event Scheduler: Killing the scheduler thread, thread id 5
130515 21:14:25 [Note] Event Scheduler: Waiting for the scheduler thread to reply
130515 21:14:25 [Note] Event Scheduler: Stopped
130515 21:14:25 [Note] Event Scheduler: Purging the queue. 0 events
130515 21:14:25 [Note] Error reading relay log event: slave SQL thread was killed
130515 21:14:25 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
130515 21:14:25 [Note] Slave I/O thread killed while reading event
130515 21:14:25 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000076', position 65614571
130515 21:14:25 [Note] WSREP: dtor state: CLOSED
130515 21:14:25 [Note] WSREP: mon: entered 13 oooe fraction 0 oool fraction 0
130515 21:14:25 [Note] WSREP: mon: entered 13 oooe fraction 0 oool fraction 0
130515 21:14:25 [Note] WSREP: mon: entered 108 oooe fraction 0 oool fraction 0
130515 21:14:25 [Note] WSREP: cert index usage at exit 0
130515 21:14:25 [Note] WSREP: cert trx map usage at exit 0
130515 21:14:25 [Note] WSREP: deps set usage at exit 0
130515 21:14:25 [Note] WSREP: avg deps dist 0
130515 21:14:25 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
130515 21:14:25 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 38078)
130515 21:14:25 [Note] WSREP: Flushing memory map to disk...
130515 21:14:25 InnoDB: Starting shutdown...
130515 21:14:29 InnoDB: Shutdown completed; log sequence number 2218833436
130515 21:14:29 [Note] /usr/sbin/mysqld: Shutdown complete
130515 21:14:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130515 21:14:31 mysqld_safe Starting mysqld daemon with databases from /db/mysql
130515 21:14:31 mysqld_safe WSREP: Running position recovery with --log_error=/tmp/tmp.rJC7Mw0pvn
130515 21:14:38 mysqld_safe WSREP: Recovered position 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078
130515 21:14:38 [Note] WSREP: wsrep_start_position var submitted: '16819721-b6c1-11e2-0800-8d78b46e9a6d:38078'
130515 21:14:38 [Note] WSREP: Setting wsrep_ready to 0
130515 21:14:38 [Note] WSREP: Read nil XID from storage engines, skipping position init
130515 21:14:38 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
130515 21:14:38 [Note] WSREP: wsrep_load(): Galera 2.5(r150) by Codership Oy <info@codership.com> loaded succesfully.
130515 21:14:38 [Note] WSREP: Found saved state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078
130515 21:14:38 [Note] WSREP: Reusing existing '/db/mysql//galera.cache'.
130515 21:14:38 [Note] WSREP: Passing config to GCS: base_host = 10.0.2.17; base_port = 4567; cert.log_conflicts = no; gcache.dir = /db/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /db/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; 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; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
130515 21:14:38 [Note] WSREP: Assign initial position for certification: 38078, protocol version: -1
130515 21:14:38 [Note] WSREP: wsrep_sst_grab()
130515 21:14:38 [Note] WSREP: Start replication
130515 21:14:38 [Note] WSREP: Setting initial position to 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078
130515 21:14:38 [Note] WSREP: protonet asio version 0
130515 21:14:38 [Note] WSREP: backend: asio
130515 21:14:38 [Note] WSREP: GMCast version 0
130515 21:14:38 [Note] WSREP: (1fafa14b-bddf-11e2-0800-aaa163abcf06, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
130515 21:14:38 [Note] WSREP: (1fafa14b-bddf-11e2-0800-aaa163abcf06, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
130515 21:14:38 [Note] WSREP: EVS version 0
130515 21:14:38 [Note] WSREP: PC version 0
130515 21:14:38 [Note] WSREP: Node 1fafa14b-bddf-11e2-0800-aaa163abcf06 state prim
130515 21:14:38 [Note] WSREP: view(view_id(PRIM,1fafa14b-bddf-11e2-0800-aaa163abcf06,1) memb {
1fafa14b-bddf-11e2-0800-aaa163abcf06,
} joined {
} left {
} partitioned {
})
130515 21:14:38 [Note] WSREP: gcomm: connected
130515 21:14:38 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
130515 21:14:38 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
130515 21:14:38 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
130515 21:14:38 [Note] WSREP: Waiting for SST to complete.
130515 21:14:38 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 1fb40641-bddf-11e2-0800-0a4153380d2a
130515 21:14:38 [Note] WSREP: STATE EXCHANGE: sent state msg: 1fb40641-bddf-11e2-0800-0a4153380d2a
130515 21:14:38 [Note] WSREP: STATE EXCHANGE: got state msg: 1fb40641-bddf-11e2-0800-0a4153380d2a from 0 (gambit)
130515 21:14:38 [Note] WSREP: Quorum results:
version = 2,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 38078,
last_appl. = -1,
protocols = 0/4/2 (gcs/repl/appl),
group UUID = 16819721-b6c1-11e2-0800-8d78b46e9a6d
130515 21:14:38 [Note] WSREP: Flow-control interval: [16, 16]
130515 21:14:38 [Note] WSREP: Restored state OPEN -> JOINED (38078)
130515 21:14:38 [Note] WSREP: Member 0 (gambit) synced with group.
130515 21:14:38 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 38078)
130515 21:14:38 [Note] WSREP: New cluster view: global state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 2
130515 21:14:38 [Note] WSREP: SST complete, seqno: 38078
130515 21:14:38 [Note] Plugin 'FEDERATED' is disabled.
130515 21:14:38 InnoDB: The InnoDB memory heap is disabled
130515 21:14:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130515 21:14:38 InnoDB: Compressed tables use zlib 1.2.3
130515 21:14:38 InnoDB: Using Linux native AIO
130515 21:14:38 InnoDB: Initializing buffer pool, size = 1.0G
130515 21:14:38 InnoDB: Completed initialization of buffer pool
130515 21:14:38 InnoDB: highest supported file format is Barracuda.
130515 21:14:38 InnoDB: Waiting for the background threads to start
130515 21:14:39 Percona XtraDB (http://www.percona.com) 5.5.30-rel30.2 started; log sequence number 2218833436
130515 21:14:39 [Note] WSREP: Initial TC log open: binlog
130515 21:14:39 [Note] WSREP: Waiting to reach ready state
130515 21:14:39 [Note] Event Scheduler: Loaded 0 events
130515 21:14:39 [Note] Slave I/O thread: connected to master 'repl@magneto.thousandeyes.com:3306',replication started in log 'mysql-bin.000076' at position 65614571
130515 21:14:39 [Note] WSREP: Set WSREPXid for InnoDB: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38078
130515 21:14:39 [Note] Event Scheduler: scheduler thread started with id 5
130515 21:14:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.30-30.2-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release 30.2, wsrep_23.7.4.r3843
130515 21:14:39 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:14:39 [Note] WSREP: Assign initial position for certification: 38078, protocol version: 2
130515 21:14:39 [Note] WSREP: Synchronized with group, ready for connections
130515 21:14:39 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:14:39 [Note] WSREP: ready state reached
130515 21:14:39 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000076' at position 65614571, relay log '/db/binlog/mysql-relay-bin.000162' position: 21446937
130515 21:15:13 [Note] WSREP: declaring 34873a77-bddf-11e2-0800-28d255de9e9f stable
130515 21:15:13 [Note] WSREP: Node 1fafa14b-bddf-11e2-0800-aaa163abcf06 state prim
130515 21:15:13 [Note] WSREP: view(view_id(PRIM,1fafa14b-bddf-11e2-0800-aaa163abcf06,2) memb {
1fafa14b-bddf-11e2-0800-aaa163abcf06,
34873a77-bddf-11e2-0800-28d255de9e9f,
} joined {
} left {
} partitioned {
})
130515 21:15:13 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
130515 21:15:13 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 34d50f82-bddf-11e2-0800-06919e323aa4
130515 21:15:13 [Note] WSREP: STATE EXCHANGE: sent state msg: 34d50f82-bddf-11e2-0800-06919e323aa4
130515 21:15:13 [Note] WSREP: STATE EXCHANGE: got state msg: 34d50f82-bddf-11e2-0800-06919e323aa4 from 0 (gambit)
130515 21:15:14 [Note] WSREP: STATE EXCHANGE: got state msg: 34d50f82-bddf-11e2-0800-06919e323aa4 from 1 (aquaman)
130515 21:15:14 [Note] WSREP: Quorum results:
version = 2,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 38081,
last_appl. = 0,
protocols = 0/4/2 (gcs/repl/appl),
group UUID = 16819721-b6c1-11e2-0800-8d78b46e9a6d
130515 21:15:14 [Note] WSREP: Flow-control interval: [23, 23]
130515 21:15:14 [Note] WSREP: New cluster view: global state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38081, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 2
130515 21:15:14 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:15:14 [Note] WSREP: Assign initial position for certification: 38081, protocol version: 2
130515 21:15:16 [Note] WSREP: Node 1 (aquaman) requested state transfer from '*any*'. Selected 0 (gambit)(SYNCED) as donor.
130515 21:15:16 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 38081)
130515 21:15:16 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:15:16 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.0.2.51:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/db/mysql/' --defaults-file '/etc/mysql/my.cnf' --gtid '16819721-b6c1-11e2-0800-8d78b46e9a6d:38081''
130515 21:15:16 [Note] WSREP: sst_donor_thread signaled with 0
130515 21:15:16 [Note] WSREP: Flushing tables for SST...
130515 21:15:16 [Note] WSREP: Provider paused at 16819721-b6c1-11e2-0800-8d78b46e9a6d:38081
130515 21:15:16 [Note] WSREP: Tables flushed.
130515 21:15:57 [Note] WSREP: Provider resumed.
130515 21:15:57 [Note] WSREP: binlog cache not initialized, conn :102
130515 21:15:57 [Note] WSREP: binlog cache not initialized, conn :102
130515 21:15:57 [Note] WSREP: binlog cache not initialized, conn :102
130515 21:15:57 [Note] WSREP: binlog cache not initialized, conn :102
130515 21:15:57 [Note] WSREP: binlog cache not initialized, conn :102
130515 21:15:57 [Note] WSREP: 0 (gambit): State transfer to 1 (aquaman) complete.
130515 21:15:57 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 38082)
130515 21:15:57 [Note] WSREP: Member 0 (gambit) synced with group.
130515 21:15:57 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 38082)
130515 21:15:57 [Note] WSREP: Synchronized with group, ready for connections
130515 21:15:57 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:15:58 [Note] WSREP: binlog cache not initialized, conn :102
130515 21:15:58 [Note] WSREP: binlog cache not initialized, conn :102
130515 21:16:04 [Note] WSREP: 1 (aquaman): State transfer from 0 (gambit) complete.
130515 21:16:04 [Note] WSREP: Member 1 (aquaman) synced with group.
130515 21:16:36 [Note] WSREP: declaring 34873a77-bddf-11e2-0800-28d255de9e9f stable
130515 21:16:36 [Note] WSREP: declaring 65b5fed9-bddf-11e2-0800-092e2b1917e8 stable
130515 21:16:36 [Note] WSREP: Node 1fafa14b-bddf-11e2-0800-aaa163abcf06 state prim
130515 21:16:36 [Note] WSREP: view(view_id(PRIM,1fafa14b-bddf-11e2-0800-aaa163abcf06,3) memb {
1fafa14b-bddf-11e2-0800-aaa163abcf06,
34873a77-bddf-11e2-0800-28d255de9e9f,
65b5fed9-bddf-11e2-0800-092e2b1917e8,
} joined {
} left {
} partitioned {
})
130515 21:16:36 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
130515 21:16:36 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 6604724f-bddf-11e2-0800-79b9e792f9c1
130515 21:16:36 [Note] WSREP: STATE EXCHANGE: sent state msg: 6604724f-bddf-11e2-0800-79b9e792f9c1
130515 21:16:36 [Note] WSREP: STATE EXCHANGE: got state msg: 6604724f-bddf-11e2-0800-79b9e792f9c1 from 1 (aquaman)
130515 21:16:36 [Note] WSREP: STATE EXCHANGE: got state msg: 6604724f-bddf-11e2-0800-79b9e792f9c1 from 0 (gambit)
130515 21:16:36 [Note] WSREP: STATE EXCHANGE: got state msg: 6604724f-bddf-11e2-0800-79b9e792f9c1 from 2 (punisher)
130515 21:16:36 [Note] WSREP: Quorum results:
version = 2,
component = PRIMARY,
conf_id = 2,
members = 2/3 (joined/total),
act_id = 38091,
last_appl. = 38084,
protocols = 0/4/2 (gcs/repl/appl),
group UUID = 16819721-b6c1-11e2-0800-8d78b46e9a6d
130515 21:16:36 [Note] WSREP: Flow-control interval: [28, 28]
130515 21:16:36 [Note] WSREP: New cluster view: global state: 16819721-b6c1-11e2-0800-8d78b46e9a6d:38091, view# 3: Primary, number of nodes: 3, my index: 0, protocol version 2
130515 21:16:36 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:16:36 [Note] WSREP: Assign initial position for certification: 38091, protocol version: 2
130515 21:16:38 [Note] WSREP: Node 2 (punisher) requested state transfer from '*any*'. Selected 0 (gambit)(SYNCED) as donor.
130515 21:16:38 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 38091)
130515 21:16:38 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:16:38 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '10.0.2.11:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/db/mysql/' --defaults-file '/etc/mysql/my.cnf' --gtid '16819721-b6c1-11e2-0800-8d78b46e9a6d:38091''
130515 21:16:38 [Note] WSREP: sst_donor_thread signaled with 0
130515 21:16:38 [Note] WSREP: Flushing tables for SST...
130515 21:16:38 [Note] WSREP: Provider paused at 16819721-b6c1-11e2-0800-8d78b46e9a6d:38091
130515 21:16:38 [Note] WSREP: Tables flushed.
130515 21:17:17 [Note] WSREP: Provider resumed.
130515 21:17:17 [Note] WSREP: binlog cache not initialized, conn :286
130515 21:17:17 [Note] WSREP: 0 (gambit): State transfer to 2 (punisher) complete.
130515 21:17:17 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 38093)
130515 21:17:17 [Note] WSREP: Member 0 (gambit) synced with group.
130515 21:17:17 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 38093)
130515 21:17:17 [Note] WSREP: Synchronized with group, ready for connections
130515 21:17:17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130515 21:17:21 [Note] WSREP: 2 (punisher): State transfer from 0 (gambit) complete.
130515 21:17:21 [Note] WSREP: Member 2 (punisher) synced with group.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment