140908 17:18:12 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted: Query execution was interrupted 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.1.72:4567 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:47 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:48 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') reconnecting to b0f9d299 (tcp://192.168.1.72:4567), attempt 0 140908 17:19:50 [Note] WSREP: evs::proto(8e5d9f3c, GATHER, view_id(REG,31b55857,25)) suspecting node: b0f9d299 140908 17:19:50 [Note] WSREP: evs::proto(8e5d9f3c, GATHER, view_id(REG,31b55857,25)) suspected node without join message, declaring inactive 140908 17:19:50 [Note] WSREP: declaring 31b55857 at tcp://192.168.0.212:4567 stable 140908 17:19:50 [Note] WSREP: declaring e9cdef6b at tcp://192.168.0.214:4567 stable 140908 17:19:50 [Note] WSREP: Node 31b55857 state prim 140908 17:19:50 [Note] WSREP: forgetting b0f9d299 (tcp://192.168.1.72:4567) 140908 17:19:50 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 140908 17:19:50 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 140908 17:19:50 [Note] WSREP: deleting entry tcp://192.168.1.72:4567 140908 17:19:50 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:50 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:19:50 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') turning message relay requesting off 140908 17:19:50 [Note] WSREP: STATE EXCHANGE: sent state msg: d032006b-375a-11e4-bb5f-a356dceb7219 140908 17:19:50 [Note] WSREP: STATE EXCHANGE: got state msg: d032006b-375a-11e4-bb5f-a356dceb7219 from 0 (dbp04) 140908 17:19:50 [Note] WSREP: STATE EXCHANGE: got state msg: d032006b-375a-11e4-bb5f-a356dceb7219 from 1 (dbp02) 140908 17:19:50 [Note] WSREP: STATE EXCHANGE: got state msg: d032006b-375a-11e4-bb5f-a356dceb7219 from 2 (dbp06) 140908 17:19:50 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 24, members = 3/3 (joined/total), act_id = 12010374841, last_appl. = 12010374730, protocols = 0/4/3 (gcs/repl/appl), group UUID = 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5 140908 17:19:50 [Note] WSREP: Flow-control interval: [28, 28] 140908 17:19:50 [Note] WSREP: New cluster view: global state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010374841, view# 25: Primary, number of nodes: 3, my index: 1, protocol version 3 140908 17:19:50 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 140908 17:19:50 [Note] WSREP: Assign initial position for certification: 12010374841, protocol version: 2 140908 17:19:53 [Note] WSREP: cleaning up b0f9d299 (tcp://192.168.1.72:4567) 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 8e5d9f3c is blacklisted, skipping 140908 17:34:40 [Note] WSREP: declaring 31b55857 at tcp://192.168.0.212:4567 stable 140908 17:34:40 [Note] WSREP: declaring e28d1da6 at tcp://192.168.1.72:4567 stable 140908 17:34:40 [Note] WSREP: declaring e9cdef6b at tcp://192.168.0.214:4567 stable 140908 17:34:40 [Note] WSREP: Node 31b55857 state prim 140908 17:34:40 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 4 140908 17:34:40 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 140908 17:34:40 [Note] WSREP: STATE EXCHANGE: sent state msg: e2aa0ca2-375c-11e4-a05a-22de60b44c5b 140908 17:34:40 [Note] WSREP: STATE EXCHANGE: got state msg: e2aa0ca2-375c-11e4-a05a-22de60b44c5b from 0 (dbp04) 140908 17:34:40 [Note] WSREP: STATE EXCHANGE: got state msg: e2aa0ca2-375c-11e4-a05a-22de60b44c5b from 1 (dbp02) 140908 17:34:40 [Note] WSREP: STATE EXCHANGE: got state msg: e2aa0ca2-375c-11e4-a05a-22de60b44c5b from 3 (dbp06) 140908 17:34:41 [Note] WSREP: STATE EXCHANGE: got state msg: e2aa0ca2-375c-11e4-a05a-22de60b44c5b from 2 (dbp08) 140908 17:34:41 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 25, members = 3/4 (joined/total), act_id = 12010537227, last_appl. = 12010537224, protocols = 0/4/3 (gcs/repl/appl), group UUID = 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5 140908 17:34:41 [Note] WSREP: Flow-control interval: [32, 32] 140908 17:34:41 [Note] WSREP: New cluster view: global state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010537227, view# 26: Primary, number of nodes: 4, my index: 1, protocol version 3 140908 17:34:41 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 140908 17:34:41 [Note] WSREP: Assign initial position for certification: 12010537227, protocol version: 2 140908 17:34:41 [Note] WSREP: Node 2 (dbp08) requested state transfer from '*any*'. Selected 0 (dbp04)(SYNCED) as donor. 140908 17:34:44 [Note] WSREP: (8e5d9f3c, 'tcp://0.0.0.0:4567') turning message relay requesting off WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- Killed 140908 17:37:17 mysqld_safe Number of processes running now: 0 140908 17:37:17 mysqld_safe WSREP: not restarting wsrep node automatically 140908 17:37:17 mysqld_safe mysqld from pid file /mysql/mysql.pid ended 140908 17:37:47 mysqld_safe Starting mysqld daemon with databases from /mysql/data 140908 17:37:47 mysqld_safe WSREP: Running position recovery with --log_error='/mysql/data/wsrep_recovery.lzvohq' --pid-file='/mysql/data/dbp02-recover.pid' 140908 17:52:23 mysqld_safe WSREP: Recovered position 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010539461 140908 17:52:23 [Note] WSREP: wsrep_start_position var submitted: '2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010539461' 140908 17:52:23 [Note] WSREP: Read nil XID from storage engines, skipping position init 140908 17:52:23 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so' 140908 17:52:23 [Note] WSREP: wsrep_load(): Galera 2.11(r318911d) by Codership Oy loaded successfully. 140908 17:52:24 [Note] WSREP: Found saved state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:-1 140908 17:52:24 [Note] WSREP: Reusing existing '/mysql/data//galera.cache'. 140908 17:52:24 [Note] WSREP: Passing config to GCS: base_host = 193.26.19.69; base_port = 4567; cert.log_conflicts = no; debug = no; 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 = /mysql/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mysql/data//galera.cache; gcache.page_size = 128M; gcache.size = 512M; 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.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet.backend = asio; protonet 140908 17:52:24 [Note] WSREP: Assign initial position for certification: 12010539461, protocol version: -1 140908 17:52:24 [Note] WSREP: wsrep_sst_grab() 140908 17:52:24 [Note] WSREP: Start replication 140908 17:52:24 [Note] WSREP: Setting initial position to 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010539461 140908 17:52:24 [Note] WSREP: protonet asio version 0 140908 17:52:24 [Note] WSREP: backend: asio 140908 17:52:24 [Note] WSREP: GMCast version 0 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 140908 17:52:24 [Note] WSREP: EVS version 0 140908 17:52:24 [Note] WSREP: PC version 0 140908 17:52:24 [Note] WSREP: gcomm: connecting to group 'dbp', peer 'dbp02:,dbp04:,dbp06:,dbp08:' 140908 17:52:24 [Warning] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' points to own listening address, blacklisting 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:24 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid 5c729c1a is blacklisted, skipping 140908 17:52:25 [Note] WSREP: declaring 31b55857 at tcp://192.168.0.212:4567 stable 140908 17:52:25 [Note] WSREP: declaring e28d1da6 at tcp://192.168.1.72:4567 stable 140908 17:52:25 [Note] WSREP: declaring e9cdef6b at tcp://192.168.0.214:4567 stable 140908 17:52:25 [Note] WSREP: Node 31b55857 state prim 140908 17:52:25 [Note] WSREP: gcomm: connected 140908 17:52:25 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 140908 17:52:25 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 140908 17:52:25 [Note] WSREP: Opened channel 'dbp' 140908 17:52:25 [Note] WSREP: Waiting for SST to complete. 140908 17:52:25 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 4 140908 17:52:25 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 140908 17:52:25 [Note] WSREP: STATE EXCHANGE: sent state msg: 5d1034e7-375f-11e4-b439-e22927c379c1 140908 17:52:25 [Note] WSREP: STATE EXCHANGE: got state msg: 5d1034e7-375f-11e4-b439-e22927c379c1 from 0 (dbp04) 140908 17:52:25 [Note] WSREP: STATE EXCHANGE: got state msg: 5d1034e7-375f-11e4-b439-e22927c379c1 from 2 (dbp08) 140908 17:52:25 [Note] WSREP: STATE EXCHANGE: got state msg: 5d1034e7-375f-11e4-b439-e22927c379c1 from 3 (dbp06) 140908 17:52:25 [Note] WSREP: STATE EXCHANGE: got state msg: 5d1034e7-375f-11e4-b439-e22927c379c1 from 1 (dbp02) 140908 17:52:25 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 27, members = 3/4 (joined/total), act_id = 12010562951, last_appl. = -1, protocols = 0/4/3 (gcs/repl/appl), group UUID = 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5 140908 17:52:25 [Note] WSREP: Flow-control interval: [32, 32] 140908 17:52:25 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 12010562951) 140908 17:52:25 [Note] WSREP: State transfer required: Group state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010562951 Local state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010539461 140908 17:52:25 [Note] WSREP: New cluster view: global state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010562951, view# 28: Primary, number of nodes: 4, my index: 1, protocol version 3 140908 17:52:25 [Warning] WSREP: Gap in state sequence. Need state transfer. 140908 17:52:25 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.69' --auth 'root:p7sVbxAf' --datadir '/mysql/data/' --defaults-file '/etc/my.cnf' --parent '14694'' WSREP_SST: [INFO] Streaming with xbstream (20140908 17:52:25.735) WSREP_SST: [INFO] Using socat as streamer (20140908 17:52:25.738) WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | xbstream -x; RC=( ${PIPESTATUS[@]} ) (20140908 17:52:26.069) 140908 17:52:26 [Note] WSREP: Prepared SST request: xtrabackup-v2|192.168.1.69:4444/xtrabackup_sst 140908 17:52:26 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 140908 17:52:26 [Note] WSREP: Assign initial position for certification: 12010562951, protocol version: 2 140908 17:52:26 [Note] WSREP: Prepared IST receiver, listening at: tcp://193.26.19.69:4568 140908 17:52:26 [Note] WSREP: Node 1 (dbp02) requested state transfer from '*any*'. Selected 0 (dbp04)(SYNCED) as donor. 140908 17:52:26 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 12010563039) 140908 17:52:26 [Note] WSREP: Requesting state transfer: success, donor: 0 WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20140908 17:52:26.779) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20140908 17:52:26.784) WSREP_SST: [INFO] Removing the sst_in_progress file (20140908 17:52:26.788) 140908 17:52:26 [Note] WSREP: SST complete, seqno: 12010539461 140908 17:52:26 InnoDB: The InnoDB memory heap is disabled 140908 17:52:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140908 17:52:26 InnoDB: Compressed tables use zlib 1.2.3.4 140908 17:52:26 InnoDB: Using Linux native AIO 140908 17:52:26 InnoDB: Initializing buffer pool, size = 90.0G 140908 17:52:27 [Note] WSREP: (5c729c1a, 'tcp://0.0.0.0:4567') turning message relay requesting off 140908 17:52:32 InnoDB: Completed initialization of buffer pool 140908 17:52:33 InnoDB: highest supported file format is Barracuda. 140908 17:52:37 InnoDB: Waiting for the background threads to start 140908 17:52:38 Percona XtraDB (http://www.percona.com) 5.5.39-36.0 started; log sequence number 17816829657851 140908 17:52:38 [Warning] 'proxies_priv' entry '@ root@percona1' ignored in --skip-name-resolve mode. 140908 17:52:38 [Note] Event Scheduler: Loaded 0 events 140908 17:52:38 [Note] WSREP: Signalling provider to continue. 140908 17:52:38 [Note] WSREP: SST received: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010539461 140908 17:52:38 [Note] WSREP: Receiving IST: 23490 writesets, seqnos 12010539461-12010562951 140908 17:52:38 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.39-36.0' socket: '/mysql/tmp/mysql.sock' port: 8661 , wsrep_25.11.rXXXX 140908 17:59:14 [Note] WSREP: 0 (dbp04): State transfer to 1 (dbp02) complete. 140908 17:59:14 [Note] WSREP: Member 0 (dbp04) synced with group. 140908 17:59:14 [Note] WSREP: IST received: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010562951 140908 17:59:14 [Warning] WSREP: last seen seqno below limit for trx source: e9cdef6b-373e-11e4-aec5-f3fa8e7898db version: 2 local: 0 state: CERTIFYING flags: 129 conn_id: 15135 trx_id: 42359392659 seqnos (l: 4, g: 12010562954, s: 12010562949, d: -1, ts: 1410184344051261071) 140908 17:59:14 [Note] WSREP: 1 (dbp02): State transfer from 0 (dbp04) complete. 140908 17:59:14 [Note] WSREP: Shifting JOINER -> JOINED (TO: 12010571666) 140908 18:01:04 [Note] WSREP: Member 1 (dbp02) synced with group. 140908 18:01:04 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 12010574072) 140908 18:01:05 [Note] WSREP: Synchronized with group, ready for connections 140908 18:01:05 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long WSREP: BF lock wait long ===================================== 140908 18:59:57 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 14 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 3978 1_second, 3976 sleeps, 397 10_second, 1 background, 0 flush srv_master_thread log flush and writes: 4141 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 490850, signal count 11286814 Mutex spin waits 117028093, rounds 105689185, OS waits 39811 RW-shared spins 13109811, rounds 30652658, OS waits 295500 RW-excl spins 1003243, rounds 20033017, OS waits 137328 Spin rounds per wait: 0.90 mutex, 2.34 RW-shared, 19.97 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 140908 18:12:49 Transaction: TRANSACTION 9DC93BDAF, ACTIVE 0 sec inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 401, OS thread handle 0x7f5114c1f700, query id 933565 192.168.1.30 fbhub update INSERT INTO user_channels (user,channel,subscr,address,s_key,last_daily_deannoy) VALUES ('46034226','14',NOW(),AES_ENCRYPT('',''),'default_key',NOW()) ON DUPLICATE KEY UPDATE user = VALUES(user), subscr = IF('1' > active, NOW(), subscr), active = IF('1',1,active), unsubscr = IF('1',NULL,unsubscr), address = VALUES(address), last_daily_deannoy = IF(last_daily_deannoy < NOW() - INTERVAL 1 WEEK,NOW(),last_daily_deannoy) Foreign key constraint fails for table `lib_area_100`.`user_channels`: , CONSTRAINT `__user_channels_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`id`) ON DELETE CASCADE Trying to add in child table, in index `user_ch` tuple: DATA TUPLE: 4 fields; 0: len 4; hex 02be6d32; asc m2;; 1: len 4; hex 0000000e; asc ;; 2: len 11; hex 64656661756c745f6b6579; asc default_key;; 3: len 8; hex 00000000048af61e; asc ;; But in parent table `lib_area_100`.`users`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 67; compact format; info bits 0 0: len 4; hex 02be6d2c; asc m,;; 1: len 6; hex 0009dc93bd42; asc B;; 2: len 7; hex 8b00300f9c0110; asc 0 ;; 3: len 20; hex 7770385f65376532386161373434643735663662; asc wp8_e7e28aa744d75f6b;; 4: len 30; hex 396164663338636237396638376264373132316665323833383935323262; asc 9adf38cb79f87bd7121fe28389522b; (total 40 bytes); 5: len 0; hex ; asc ;; 6: len 0; hex ; asc ;; 7: SQL NULL; 8: SQL NULL; 9: len 0; hex ; asc ;; 10: len 1; hex 00; asc ;; 11: len 2; hex 2020; asc ;; 12: len 0; hex ; asc ;; 13: len 0; hex ; asc ;; 14: len 0; hex ; asc ;; 15: len 0; hex ; asc ;; 16: SQL NULL; 17: len 4; hex 540db95c; asc T \;; 18: len 2; hex 0aaf; asc ;; 19: len 1; hex 00; asc ;; 20: len 1; hex 00; asc ;; 21: SQL NULL; 22: SQL NULL; 23: SQL NULL; 24: SQL NULL; 25: len 1; hex 80; asc ;; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: SQL NULL; 30: len 8; hex 800012516bad76fc; asc Qk v ;; 31: SQL NULL; 32: SQL NULL; 33: SQL NULL; 34: len 5; hex 8000000000; asc ;; 35: SQL NULL; 36: len 3; hex 8fac21; asc !;; 37: SQL NULL; 38: len 1; hex 00; asc ;; 39: SQL NULL; 40: len 1; hex 00; asc ;; 41: len 1; hex 00; asc ;; 42: SQL NULL; 43: SQL NULL; 44: SQL NULL; 45: len 1; hex 00; asc ;; 46: SQL NULL; 47: len 2; hex 8000; asc ;; 48: len 5; hex 8000000000; asc ;; 49: len 8; hex 8000125147ea30fc; asc QG 0 ;; 50: SQL NULL; 51: len 1; hex 02; asc ;; 52: len 1; hex 01; asc ;; 53: len 1; hex 02; asc ;; 54: SQL NULL; 55: SQL NULL; 56: len 4; hex 00000000; asc ;; 57: SQL NULL; 58: SQL NULL; 59: SQL NULL; 60: SQL NULL; 61: SQL NULL; 62: SQL NULL; 63: len 8; hex 8000000006052340; asc #@;; 64: SQL NULL; 65: SQL NULL; 66: len 1; hex 81; asc ;; -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 793587 OS file reads, 1083148 OS file writes, 38718 OS fsyncs 46.50 reads/s, 15515 avg bytes/read, 221.77 writes/s, 8.71 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 15555, free list len 132167, seg size 147723, 238289 merges merged operations: insert 5137767, delete mark 640307, delete 494082 discarded operations: insert 801, delete mark 0, delete 0 Hash table size 191247989, node heap has 13564 buffer(s) 196903.94 hash searches/s, 111513.89 non-hash searches/s --- LOG --- Log sequence number 17823823180414 Log flushed up to 17823823167662 Last checkpoint at 17820972146888 Max checkpoint age 8490395198 Checkpoint age target 8225070349 Modified age 2848987650 Checkpoint age 2851033526 0 pending log writes, 0 pending chkp writes 288095 log i/o's done, 1.57 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 99184803840; in additional pool allocated 0 Total memory allocated by read views 49784 Internal hash tables (constant factor + variable factor) Adaptive hash index 1752220704 (1529983912 + 222236792) Page hash 95624824 (buffer pool 0 only) Dictionary cache 383122943 (382497488 + 625455) File system 272752 (82672 + 190080) Lock system 239598760 (239060648 + 538112) Recovery system 0 (0 + 0) Dictionary memory allocated 625455 Buffer pool size 5898239 Buffer pool size, bytes 96636747776 Free buffers 4851841 Database pages 1017202 Old database pages 375510 Modified db pages 389777 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 33633, not young 0 0.07 youngs/s, 0.00 non-youngs/s Pages read 793557, created 223645, written 776066 46.50 reads/s, 0.93 creates/s, 215.98 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1017202, unzip_LRU len: 62441 I/O sum[0]:cur[200], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 40 queries inside InnoDB, 31 queries in queue 5 read views open inside InnoDB 50 transactions active inside InnoDB 50 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 9DC962A03 Read view up limit trx id 9DC95FDBC Read view low limit trx id 9DC962A03 Read view individually stored trx ids: Read view trx id 9DC962A02 Read view trx id 9DC962785 Read view trx id 9DC962723 Read view trx id 9DC96209B Read view trx id 9DC961FA0 Read view trx id 9DC95FECF Read view trx id 9DC95FE4E Read view trx id 9DC95FDBC ----------------- Main thread process no. 14694, id 139986259678976, state: sleeping Number of rows inserted 30390195, updated 1757729, deleted 320933, read 1831981037 19.00 inserts/s, 11.57 updates/s, 11.57 deletes/s, 270979.07 reads/s ------------ TRANSACTIONS ------------ Trx id counter 9DC9644D9 Purge done for trx's n:o < 9DC962A0E undo n:o < 0 History list length 1172 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2315, OS thread handle 0x7f511633a700, query id 4182200 192.168.0.203 fbhub Sending data SELECT spam FROM spam_hits WHERE user='37330252' AND spam='1744349' AND type='1' AND time > NOW() - INTERVAL 1 HOUR ---TRANSACTION 9DC9642D6, not started MySQL thread id 2305, OS thread handle 0x7f5114ce2700, query id 4166382 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964241, not started MySQL thread id 2303, OS thread handle 0x7f50f596e700, query id 4164751 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964027, not started MySQL thread id 2296, OS thread handle 0x7f51150b1700, query id 4157410 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964007, not started waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2295, OS thread handle 0x7f50f5a31700, query id 4182187 192.168.0.203 fbhub Sending data SELECT spam FROM spam_hits WHERE user='39813012' AND spam='1744349' AND type='1' AND time > NOW() - INTERVAL 1 HOUR ---TRANSACTION 9DC963F9C, not started MySQL thread id 2293, OS thread handle 0x7f51147ce700, query id 4155209 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC963BF1, not started waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2284, OS thread handle 0x7f511474c700, query id 4182191 192.168.0.203 fbhub update INSERT INTO user_best_times (hits, hour, week_day, user) VALUES ('3','18','1','21493532') ON DUPLICATE KEY UPDATE hits=hits+VALUES(hits) ---TRANSACTION 9DC963B63, not started MySQL thread id 2283, OS thread handle 0x7f5115953700, query id 4137043 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC963ACC, not started MySQL thread id 2277, OS thread handle 0x7f5114175700, query id 4133604 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC963AA9, not started MySQL thread id 2281, OS thread handle 0x7f5115606700, query id 4133056 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC963BAC, not started MySQL thread id 2279, OS thread handle 0x7f5115e26700, query id 4138633 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644C0, not started MySQL thread id 2274, OS thread handle 0x7f50f54dc700, query id 4180282 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9629AF, not started MySQL thread id 2271, OS thread handle 0x7f511433c700, query id 4084693 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC962960, not started MySQL thread id 2180, OS thread handle 0x7f50f5621700, query id 4081391 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC96397C, not started MySQL thread id 2268, OS thread handle 0x7f5114f2b700, query id 4133982 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644C6, not started MySQL thread id 2267, OS thread handle 0x7f50f56a3700, query id 4180671 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC96234C, not started MySQL thread id 2230, OS thread handle 0x7f50f58ec700, query id 4061906 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9622FD, not started MySQL thread id 2264, OS thread handle 0x7f68c85af700, query id 4057871 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96442F, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2263, OS thread handle 0x7f68c8631700, query id 4182193 192.168.1.30 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '45785266' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '6' ---TRANSACTION 9DC963B60, not started MySQL thread id 2254, OS thread handle 0x7f5115b9c700, query id 4136931 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC961E57, not started MySQL thread id 2253, OS thread handle 0x7f5115fed700, query id 4154430 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96232F, not started MySQL thread id 2252, OS thread handle 0x7f5114e68700, query id 4060272 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644BB, not started MySQL thread id 2249, OS thread handle 0x7f50f518f700, query id 4180137 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC962A8C, not started MySQL thread id 2248, OS thread handle 0x7f50f58ab700, query id 4087991 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC962E36, not started MySQL thread id 2247, OS thread handle 0x7f50f5af4700, query id 4100204 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644B2, not started waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2246, OS thread handle 0x7f51142ba700, query id 4182202 192.168.1.30 fbhub Sorting result SELECT av.art FROM art_views av WHERE av.user = '890922' AND av.type = 2 ORDER BY av.last_time DESC LIMIT 25 ---TRANSACTION 9DC961972, not started MySQL thread id 2187, OS thread handle 0x7f51152fa700, query id 4007195 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9629C3, not started MySQL thread id 2240, OS thread handle 0x7f5115c5f700, query id 4085932 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964086, not started MySQL thread id 2239, OS thread handle 0x7f51160b0700, query id 4158663 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9617B7, not started MySQL thread id 2238, OS thread handle 0x7f50f5725700, query id 3997713 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9639CC, not started MySQL thread id 2234, OS thread handle 0x7f51157cd700, query id 4126808 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC961AE4, not started MySQL thread id 2231, OS thread handle 0x7f51151f6700, query id 4015726 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC961126, not started MySQL thread id 2226, OS thread handle 0x7f50f5ec3700, query id 4080740 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9610BC, not started MySQL thread id 2225, OS thread handle 0x7f5115d63700, query id 3976671 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC96419E, not started waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 2181, OS thread handle 0x7f68c8776700, query id 4182179 192.168.1.30 fbhub update INSERT INTO art_views(user,art,type,last_time) VALUES('46039452','6283512','1',IFNULL('2014-09-08 18:59:42',NOW())) on duplicate key update hits = hits + 1, last_time = NOW() ---TRANSACTION 9DC96409C, not started MySQL thread id 2132, OS thread handle 0x7f50f5c39700, query id 4158891 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9604DF, not started MySQL thread id 2213, OS thread handle 0x7f68c809b700, query id 3938382 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC95F7D4, not started MySQL thread id 2172, OS thread handle 0x7f5115a57700, query id 3876281 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC96448F, not started MySQL thread id 2171, OS thread handle 0x7f50f508b700, query id 4177130 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9627BE, not started MySQL thread id 2167, OS thread handle 0x7f51145c6700, query id 4079414 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644BC, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2155, OS thread handle 0x7f5115ad9700, query id 4182203 192.168.0.203 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '22005760' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '1' ---TRANSACTION 9DC9640E4, not started MySQL thread id 2130, OS thread handle 0x7f51160f1700, query id 4159938 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964407, not started MySQL thread id 2122, OS thread handle 0x7f511543f700, query id 4169939 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964497, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2113, OS thread handle 0x7f5115f2a700, query id 4182209 192.168.1.30 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '43145794' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '4' ---TRANSACTION 9DC96445F, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 2111, OS thread handle 0x7f5115ca0700, query id 4182189 192.168.1.30 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '32054068' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '6' ---TRANSACTION 9DC963EE7, not started MySQL thread id 2102, OS thread handle 0x7f51153bd700, query id 4149561 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964495, not started MySQL thread id 2098, OS thread handle 0x7f50f53d8700, query id 4178074 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644A2, not started waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 2092, OS thread handle 0x7f5115a98700, query id 4182211 192.168.1.30 fbhub Sorting result SELECT av.art FROM art_views av WHERE av.user = '42052442' AND av.type = 2 ORDER BY av.last_time DESC LIMIT 25 ---TRANSACTION 9DC9620C5, not started MySQL thread id 2019, OS thread handle 0x7f5114913700, query id 4051008 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9640CF, not started MySQL thread id 2037, OS thread handle 0x7f50f5e82700, query id 4159605 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC96328C, not started MySQL thread id 1954, OS thread handle 0x7f5115ea8700, query id 4106324 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC963E7D, not started MySQL thread id 1988, OS thread handle 0x7f50f51d0700, query id 4145349 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644C4, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1946, OS thread handle 0x7f50f5009700, query id 4182208 192.168.1.30 fbhub Sending data SELECT ch.id, u.id FROM spam_channels AS ch LEFT JOIN users AS u ON u.id = '43145794' WHERE ch.spam_engine = 'push' AND IF('19',ch.app = '19',ch.app IS NULL) AND IFNULL(ch.spam_engine_channel = NULL,1) ---TRANSACTION 9DC964492, not started MySQL thread id 1917, OS thread handle 0x7f68c805a700, query id 4177648 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964473, not started MySQL thread id 1891, OS thread handle 0x7f50f5dbf700, query id 4175141 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964453, not started MySQL thread id 1889, OS thread handle 0x7f50f50cc700, query id 4173517 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC963ED5, not started MySQL thread id 1886, OS thread handle 0x7f50f5829700, query id 4148351 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644C8, not started MySQL thread id 1885, OS thread handle 0x7f5115bdd700, query id 4181171 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644CF, not started MySQL thread id 1861, OS thread handle 0x7f5115d22700, query id 4181651 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964491, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1822, OS thread handle 0x7f51151b5700, query id 4182194 192.168.1.30 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '30490606' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '4' ---TRANSACTION 9DC9629BE, not started MySQL thread id 1819, OS thread handle 0x7f5115543700, query id 4085805 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964442, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1811, OS thread handle 0x7f5114954700, query id 4182207 192.168.0.203 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '45998200' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '6' ---TRANSACTION 9DC96443E, not started MySQL thread id 1810, OS thread handle 0x7f51152b9700, query id 4172295 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964480, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1794, OS thread handle 0x7f5114d64700, query id 4182196 192.168.0.203 fbhub Sending data SELECT ch.id, u.id FROM spam_channels AS ch LEFT JOIN users AS u ON u.id = '40147092' WHERE ch.spam_engine = 'push' AND IF('4',ch.app = '4',ch.app IS NULL) AND IFNULL(ch.spam_engine_channel = NULL,1) ---TRANSACTION 9DC964003, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1785, OS thread handle 0x7f5114481700, query id 4182195 192.168.0.203 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '40147092' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '4' ---TRANSACTION 9DC9644C1, not started MySQL thread id 1762, OS thread handle 0x7f50f559f700, query id 4180378 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964470, not started MySQL thread id 1755, OS thread handle 0x7f50f545a700, query id 4174959 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964429, not started MySQL thread id 1726, OS thread handle 0x7f5115f6b700, query id 4171718 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644A9, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1700, OS thread handle 0x7f51140f3700, query id 4182201 192.168.1.30 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '45785266' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '6' ---TRANSACTION 9DC9644A1, not started MySQL thread id 1685, OS thread handle 0x7f5115e67700, query id 4178735 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644AE, not started MySQL thread id 1657, OS thread handle 0x7f50f5356700, query id 4179591 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC96443A, not started waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 1629, OS thread handle 0x7f511584f700, query id 4182178 192.168.1.30 fbhub Sorting result SELECT av.art FROM art_views av WHERE av.user = '482092' AND av.type = 2 ORDER BY av.last_time DESC LIMIT 25 ---TRANSACTION 9DC9518D3, not started MySQL thread id 1551, OS thread handle 0x7f511537c700, query id 2725844 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964478, not started MySQL thread id 1542, OS thread handle 0x7f68c856e700, query id 4175679 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644CB, not started MySQL thread id 1533, OS thread handle 0x7f51140b2700, query id 4181288 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC950B07, not started MySQL thread id 1496, OS thread handle 0x7f5115b5b700, query id 2635799 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC950A61, not started MySQL thread id 1493, OS thread handle 0x7f5114ada700, query id 2635392 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC95093C, not started MySQL thread id 1490, OS thread handle 0x7f5115584700, query id 2626869 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC963EA1, not started MySQL thread id 1439, OS thread handle 0x7f68c82e4700, query id 4147127 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964482, not started MySQL thread id 1414, OS thread handle 0x7f511480f700, query id 4176510 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC962A19, not started MySQL thread id 1405, OS thread handle 0x7f50f5bb7700, query id 4087796 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96449D, not started MySQL thread id 1387, OS thread handle 0x7f50f5d3d700, query id 4178637 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96446E, not started MySQL thread id 1383, OS thread handle 0x7f68c8325700, query id 4174838 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9641CF, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1379, OS thread handle 0x7f5114eea700, query id 4182186 192.168.0.203 fbhub Sending data SELECT ch.id, u.id FROM spam_channels AS ch LEFT JOIN users AS u ON u.id = '45545180' WHERE ch.spam_engine = 'push' AND IF('1',ch.app = '1',ch.app IS NULL) AND IFNULL(ch.spam_engine_channel = NULL,1) ---TRANSACTION 9DC964191, not started MySQL thread id 1374, OS thread handle 0x7f511574b700, query id 4162717 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644B8, not started MySQL thread id 1349, OS thread handle 0x7f51150f2700, query id 4180092 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964171, not started MySQL thread id 1344, OS thread handle 0x7f51149d6700, query id 4162000 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC963EBE, not started waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1342, OS thread handle 0x7f5114a99700, query id 4182182 192.168.0.203 fbhub update INSERT IGNORE INTO users VALUES ('46039972','andy00b88797937d','ab4e3fbf55ef44def2641cd9587c86edaf01e2a4','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:52','2741','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:52',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:52',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') ---TRANSACTION 9DC964208, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1341, OS thread handle 0x7f51162b8700, query id 4182184 192.168.0.203 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '37671108' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '6' ---TRANSACTION 9DC9644B1, not started MySQL thread id 1335, OS thread handle 0x7f50f5211700, query id 4179605 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96447A, not started MySQL thread id 1325, OS thread handle 0x7f5115480700, query id 4175704 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96449E, not started MySQL thread id 1307, OS thread handle 0x7f5114da5700, query id 4178732 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964479, not started MySQL thread id 1299, OS thread handle 0x7f50f5c7a700, query id 4175692 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC949C1D, not started MySQL thread id 1189, OS thread handle 0x7f5115237700, query id 2107284 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC949ACC, not started MySQL thread id 1181, OS thread handle 0x7f5115de5700, query id 2103019 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644D0, not started waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1098, OS thread handle 0x7f511478d700, query id 4182180 192.168.1.30 fbhub update INSERT IGNORE INTO users VALUES ('46039976','android_freed0e8ae34-265e-3eba-9ad0-45875c0ec46e','a10989d1e9def271237c1322a5dafb35b6f43758','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:52','2609','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:52',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:52',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') ---TRANSACTION 9DC964490, not started MySQL thread id 1093, OS thread handle 0x7f5114279700, query id 4177477 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644C7, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1087, OS thread handle 0x7f5114134700, query id 4182204 192.168.0.203 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '13297034' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '2' ---TRANSACTION 9DC9639FB, not started MySQL thread id 1081, OS thread handle 0x7f50f5e00700, query id 4128477 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644AB, not started MySQL thread id 1080, OS thread handle 0x7f5114b1b700, query id 4179076 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964458, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 1077, OS thread handle 0x7f50f592d700, query id 4182183 192.168.0.203 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '46036284' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '6' ---TRANSACTION 9DC964192, not started MySQL thread id 1069, OS thread handle 0x7f50f504a700, query id 4162725 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644C5, not started MySQL thread id 1061, OS thread handle 0x7f5116173700, query id 4180481 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644B7, not started MySQL thread id 1059, OS thread handle 0x7f50f5bf8700, query id 4180064 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9641A0, not started MySQL thread id 1046, OS thread handle 0x7f5115c1e700, query id 4162864 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC9644A5, not started MySQL thread id 1044, OS thread handle 0x7f5114de6700, query id 4178796 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964198, not started MySQL thread id 1043, OS thread handle 0x7f50f514e700, query id 4162736 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96417A, not started MySQL thread id 1040, OS thread handle 0x7f5114585700, query id 4162055 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC963FC4, not started MySQL thread id 1038, OS thread handle 0x7f5115ce1700, query id 4156240 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC964153, not started MySQL thread id 1023, OS thread handle 0x7f5114fad700, query id 4161353 192.168.0.203 fbhub sleeping ---TRANSACTION 9DC96449A, not started MySQL thread id 989, OS thread handle 0x7f50f5e41700, query id 4178570 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964418, not started MySQL thread id 849, OS thread handle 0x7f50f5cbb700, query id 4170541 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC93D868, not started MySQL thread id 671, OS thread handle 0x7f50f5397700, query id 1133394 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964476, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 663, OS thread handle 0x7f68c87b7700, query id 4182205 192.168.1.30 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '45216276' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '6' ---TRANSACTION 9DC93D3EA, not started MySQL thread id 660, OS thread handle 0x7f68c84ec700, query id 1084383 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644A4, not started waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 567, OS thread handle 0x7f51142fb700, query id 4182210 192.168.1.30 fbhub update INSERT INTO art_views(user,art,type,last_time) VALUES('46022984','6686897','5',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() ---TRANSACTION 9DC9644BF, not started MySQL thread id 536, OS thread handle 0x7f5115133700, query id 4180270 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644AD, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 531, OS thread handle 0x7f5114ea9700, query id 4182188 192.168.1.30 fbhub Sending data SELECT ch.id, u.id FROM spam_channels AS ch LEFT JOIN users AS u ON u.id = '32054068' WHERE ch.spam_engine = 'push' AND IF('6',ch.app = '6',ch.app IS NULL) AND IFNULL(ch.spam_engine_channel = NULL,1) ---TRANSACTION 9DC9643FD, not started waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 495, OS thread handle 0x7f50f5293700, query id 4182192 192.168.1.30 fbhub Sorting result SELECT av.art FROM art_views av WHERE av.user = '45920234' AND av.type = 2 ORDER BY av.last_time DESC LIMIT 25 ---TRANSACTION 9DC93A98E, not started MySQL thread id 494, OS thread handle 0x7f50f52d4700, query id 783142 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC93A54C, not started MySQL thread id 476, OS thread handle 0x7f50f5419700, query id 760742 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964498, not started MySQL thread id 471, OS thread handle 0x7f50f551d700, query id 4178425 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC93A452, not started MySQL thread id 470, OS thread handle 0x7f50f555e700, query id 754411 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964245, not started MySQL thread id 460, OS thread handle 0x7f50f5766700, query id 4164893 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964496, not started waiting in InnoDB queue mysql tables in use 2, locked 0 MySQL thread id 442, OS thread handle 0x7f511533b700, query id 4182206 192.168.1.30 fbhub statistics SELECT COUNT(st.id) FROM spam_tickets AS st JOIN spam_channels AS ch ON ch.id=st.channel WHERE st.user = '46039716' AND st.status IN ('delivered','sent') AND st.last_update >= NOW() - INTERVAL '30' DAY AND ch.app = '4' ---TRANSACTION 9DC9641F1, not started MySQL thread id 418, OS thread handle 0x7f5115174700, query id 4164074 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC964499, not started MySQL thread id 409, OS thread handle 0x7f511437d700, query id 4178456 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC963FEE, not started MySQL thread id 408, OS thread handle 0x7f5114b5c700, query id 4156876 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC96444D, not started MySQL thread id 406, OS thread handle 0x7f5114b9d700, query id 4173452 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC9644A3, not started MySQL thread id 393, OS thread handle 0x7f51141f7700, query id 4178758 192.168.1.30 fbhub sleeping ---TRANSACTION 9DC933DE1, not started MySQL thread id 222, OS thread handle 0x7f511470b700, query id 368437 192.168.1.69 pu sleeping ---TRANSACTION 9DC964158, not started MySQL thread id 33, OS thread handle 0x7f68d84b1700, query id 4161424 committed 12010679894 ---TRANSACTION 9DC9643E8, not started MySQL thread id 32, OS thread handle 0x7f68d84f2700, query id 4167017 committed 12010680222 ---TRANSACTION 9DC964268, not started MySQL thread id 9, OS thread handle 0x7f68e064d700, query id 4166019 committed 12010680030 ---TRANSACTION 9DC9643E9, not started MySQL thread id 19, OS thread handle 0x7f68e0184700, query id 4167037 committed 12010680223 ---TRANSACTION 9DC964391, not started MySQL thread id 22, OS thread handle 0x7f68e00c1700, query id 4166743 committed 12010680178 ---TRANSACTION 9DC964359, not started MySQL thread id 11, OS thread handle 0x7f68e058a700, query id 4166691 committed 12010680149 ---TRANSACTION 9DC964395, not started MySQL thread id 27, OS thread handle 0x7f68d8678700, query id 4166753 committed 12010680181 ---TRANSACTION 9DC96420C, not started MySQL thread id 25, OS thread handle 0x7f68d86fa700, query id 4164236 committed 12010679985 ---TRANSACTION 9DC9643F0, not started MySQL thread id 10, OS thread handle 0x7f68e060c700, query id 4167043 committed 12010680226 ---TRANSACTION 9DC9642D0, not started MySQL thread id 28, OS thread handle 0x7f68d85f6700, query id 4166330 committed 12010680080 ---TRANSACTION 9DC9643EB, not started MySQL thread id 5, OS thread handle 0x7f6908098700, query id 4167039 committed 12010680224 ---TRANSACTION 9DC964204, not started MySQL thread id 14, OS thread handle 0x7f68e02c9700, query id 4164124 committed 12010679980 ---TRANSACTION 9DC96423F, not started MySQL thread id 24, OS thread handle 0x7f68d86b9700, query id 4164708 committed 12010680008 ---TRANSACTION 9DC964293, not started MySQL thread id 18, OS thread handle 0x7f68e01c5700, query id 4166207 committed 12010680050 ---TRANSACTION 9DC96434E, not started MySQL thread id 35, OS thread handle 0x7f68d842f700, query id 4166685 committed 12010680144 ---TRANSACTION 9DC96421C, not started MySQL thread id 17, OS thread handle 0x7f68e0206700, query id 4164321 committed 12010679993 ---TRANSACTION 9DC964247, not started MySQL thread id 3, OS thread handle 0x7f690811a700, query id 4164937 committed 12010680012 ---TRANSACTION 9DC96424B, not started MySQL thread id 30, OS thread handle 0x7f68d8574700, query id 4165611 committed 12010680016 ---TRANSACTION 9DC964346, not started MySQL thread id 21, OS thread handle 0x7f68e0102700, query id 4166610 committed 12010680139 ---TRANSACTION 9DC96425E, not started MySQL thread id 31, OS thread handle 0x7f68d8533700, query id 4165753 committed 12010680024 ---TRANSACTION 9DC96438B, not started MySQL thread id 23, OS thread handle 0x7f68e0080700, query id 4166740 committed 12010680175 ---TRANSACTION 9DC964262, not started MySQL thread id 36, OS thread handle 0x7f68d83ee700, query id 4165803 committed 12010680026 ---TRANSACTION 9DC9641F3, not started MySQL thread id 26, OS thread handle 0x7f68d8637700, query id 4164084 committed 12010679971 ---TRANSACTION 9DC96422C, not started MySQL thread id 20, OS thread handle 0x7f68e0143700, query id 4164551 committed 12010680001 ---TRANSACTION 9DC964310, not started MySQL thread id 34, OS thread handle 0x7f68d8470700, query id 4166437 committed 12010680112 ---TRANSACTION 9DC964216, not started MySQL thread id 4, OS thread handle 0x7f69080d9700, query id 4164310 committed 12010679990 ---TRANSACTION 9DC9643D1, not started MySQL thread id 16, OS thread handle 0x7f68e0247700, query id 4166855 committed 12010680210 ---TRANSACTION 9DC964351, not started MySQL thread id 15, OS thread handle 0x7f68e0288700, query id 4166687 committed 12010680145 ---TRANSACTION 9DC964265, not started MySQL thread id 29, OS thread handle 0x7f68d85b5700, query id 4165945 committed 12010680028 ---TRANSACTION 9DC964392, not started MySQL thread id 37, OS thread handle 0x7f68d83ad700, query id 4166751 committed 12010680179 ---TRANSACTION 9DC964269, not started MySQL thread id 38, OS thread handle 0x7f68d836c700, query id 4166081 committed 12010680031 ---TRANSACTION 9DC964206, not started MySQL thread id 40, OS thread handle 0x7f68d82ea700, query id 4164128 committed 12010679981 ---TRANSACTION 9DC96429A, not started MySQL thread id 41, OS thread handle 0x7f68d82a9700, query id 4166244 committed 12010680054 ---TRANSACTION 9DC964263, not started MySQL thread id 43, OS thread handle 0x7f68d8227700, query id 4165864 committed 12010680027 ---TRANSACTION 9DC964266, not started MySQL thread id 42, OS thread handle 0x7f68d8268700, query id 4165989 committed 12010680029 ---TRANSACTION 9DC9641BD, not started MySQL thread id 44, OS thread handle 0x7f68d81e6700, query id 4163357 committed 12010679945 ---TRANSACTION 9DC964260, not started MySQL thread id 45, OS thread handle 0x7f68d81a5700, query id 4165761 committed 12010680025 ---TRANSACTION 9DC9643D3, not started MySQL thread id 46, OS thread handle 0x7f68d8164700, query id 4166876 committed 12010680212 ---TRANSACTION 9DC9643ED, not started MySQL thread id 47, OS thread handle 0x7f68d8123700, query id 4167041 committed 12010680225 ---TRANSACTION 9DC96426B, not started MySQL thread id 48, OS thread handle 0x7f68d80e2700, query id 4166120 committed 12010680032 ---TRANSACTION 9DC96425A, not started MySQL thread id 39, OS thread handle 0x7f68d832b700, query id 4165692 committed 12010680022 ---TRANSACTION 9DC96417B, not started MySQL thread id 49, OS thread handle 0x7f68d80a1700, query id 4162074 committed 12010679913 ---TRANSACTION 9DC964336, not started MySQL thread id 6, OS thread handle 0x7f6908057700, query id 4166559 committed 12010680132 ---TRANSACTION 9DC96425C, not started MySQL thread id 12, OS thread handle 0x7f68e05cb700, query id 4165709 committed 12010680023 ---TRANSACTION 9DC9641FE, not started MySQL thread id 8, OS thread handle 0x7f68e068e700, query id 4164114 committed 12010679977 ---TRANSACTION 9DC964212, not started MySQL thread id 7, OS thread handle 0x7f68e06cf700, query id 4164303 committed 12010679988 ---TRANSACTION 9DC964258, not started MySQL thread id 2, OS thread handle 0x7f690d554700, query id 4165686 committed 12010680021 ---TRANSACTION 9DC9644D8, ACTIVE 5 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 2081, OS thread handle 0x7f5114440700, query id 4182174 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('35558974','182359','1',IFNULL('2014-09-08 18:59:42',NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC9644D8 lock mode IX ---TRANSACTION 9DC9644D7, ACTIVE 6 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 492, OS thread handle 0x7f51143ff700, query id 4182164 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('46039452','6283512','2',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC9644D7 lock mode IX ---TRANSACTION 9DC9644D5, ACTIVE 6 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 2127, OS thread handle 0x7f5114891700, query id 4182162 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('35558974','182359','2',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC9644D5 lock mode IX ---TRANSACTION 9DC9644D3, ACTIVE 6 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2152, OS thread handle 0x7f50f5a72700, query id 4181935 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('44380674', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9644D3 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9644D3 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9644D3 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644D3 lock mode IS RECORD LOCKS space id 12854 page no 115594 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9644D3 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9644D3 lock mode IX ---TRANSACTION 9DC9644D1, ACTIVE 6 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 895, OS thread handle 0x7f5116132700, query id 4181812 192.168.1.30 fbhub wsrep in pre-commit stage INSERT IGNORE INTO users VALUES ('46039966','','63a097f3081c712cc8afbb156091c7c5cf5daf5a','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:51','2609','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:51',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:51',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644D1 lock mode IX ---TRANSACTION 9DC9644CE, ACTIVE 7 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2272, OS thread handle 0x7f5114f6c700, query id 4181522 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('42549416', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9644CE lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9644CE lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9644CE lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644CE lock mode IS RECORD LOCKS space id 12854 page no 111306 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9644CE lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9644CE lock mode IX ---TRANSACTION 9DC9644CC, ACTIVE 7 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1417, OS thread handle 0x7f51144c2700, query id 4181483 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('45782374','128393','5',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC9644CC lock mode IX ---TRANSACTION 9DC9644CA, ACTIVE 8 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2236, OS thread handle 0x7f50f5662700, query id 4181187 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('20843942', '1744162', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9644CA lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9644CA lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9644CA lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644CA lock mode IS RECORD LOCKS space id 12854 page no 44065 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9644CA lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9644CA lock mode IX ---TRANSACTION 9DC9644C3, ACTIVE 9 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2179, OS thread handle 0x7f5114503700, query id 4180423 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('36217932', '1744349', '2', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9644C3 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9644C3 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9644C3 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644C3 lock mode IS RECORD LOCKS space id 12854 page no 94689 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9644C3 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9644C3 lock mode IX ---TRANSACTION 9DC9644B6, ACTIVE 10 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1053, OS thread handle 0x7f50f549b700, query id 4180041 192.168.0.203 fbhub wsrep in pre-commit stage INSERT IGNORE INTO users VALUES ('46039952','','30e59f4522eeadb81561f2614a401da10bba76c1','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:47','2609','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:47',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:47',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644B6 lock mode IX ---TRANSACTION 9DC9644B4, ACTIVE 11 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2235, OS thread handle 0x7f51148d2700, query id 4179775 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('754522', '1744162', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9644B4 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9644B4 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9644B4 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644B4 lock mode IS RECORD LOCKS space id 12854 page no 6013 n bits 128 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9644B4 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9644B4 lock mode IX ---TRANSACTION 9DC9644AC, ACTIVE 12 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1049, OS thread handle 0x7f5114d23700, query id 4179082 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('40286436','6607243','2',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC9644AC lock mode IX ---TRANSACTION 9DC9644A8, ACTIVE 13 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2312, OS thread handle 0x7f5114a58700, query id 4178869 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('22708780', '1744162', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9644A8 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9644A8 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9644A8 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9644A8 lock mode IS RECORD LOCKS space id 12854 page no 53293 n bits 128 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9644A8 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9644A8 lock mode IX ---TRANSACTION 9DC96448E, ACTIVE 17 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1272, OS thread handle 0x7f5115994700, query id 4176745 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO user_best_times (user, week_day, hour, hits) VALUES ('1135782','0','0','29') ON DUPLICATE KEY UPDATE hits = hits + VALUES(hits) TABLE LOCK table `lib_area_100`.`user_best_times` trx id 9DC96448E lock mode IX ---TRANSACTION 9DC96447F, ACTIVE 18 sec, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 446, OS thread handle 0x7f50f5b35700, query id 4175728 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('119956','4603557','3',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC96447F lock mode IX RECORD LOCKS space id 505 page no 188723 n bits 504 index `uat` of table `lib_area_100`.`art_views` trx id 9DC96447F lock_mode X locks rec but not gap ---TRANSACTION 9DC964471, ACTIVE 19 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1066, OS thread handle 0x7f5115da4700, query id 4175044 192.168.0.203 fbhub wsrep in pre-commit stage INSERT IGNORE INTO users VALUES ('46039942','android_crime2ce6361c-b020-3543-ba64-a043ec6915b3','2990812b4f46c7aa08b44fc64d7f1aa646f97447','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:38','2762','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:38',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:38',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') TABLE LOCK table `lib_area_100`.`users` trx id 9DC964471 lock mode IX ---TRANSACTION 9DC96446F, ACTIVE 19 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1884, OS thread handle 0x7f50f5315700, query id 4174954 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('24149830','7065187','5',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC96446F lock mode IX ---TRANSACTION 9DC96446C, ACTIVE 20 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2292, OS thread handle 0x7f5115a16700, query id 4174754 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('41673506', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC96446C lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC96446C lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC96446C lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC96446C lock mode IS RECORD LOCKS space id 12854 page no 109118 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96446C lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC96446C lock mode IX ---TRANSACTION 9DC964469, ACTIVE 20 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2095, OS thread handle 0x7f50f5b76700, query id 4174439 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('18487978', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC964469 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC964469 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC964469 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC964469 lock mode IS RECORD LOCKS space id 12854 page no 35459 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964469 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC964469 lock mode IX ---TRANSACTION 9DC964466, ACTIVE 20 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2262, OS thread handle 0x7f50f57a7700, query id 4174404 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('25979756', '1744162', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC964466 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC964466 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC964466 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC964466 lock mode IS RECORD LOCKS space id 12854 page no 67914 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964466 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC964466 lock mode IX ---TRANSACTION 9DC964456, ACTIVE 22 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 438, OS thread handle 0x7f5115912700, query id 4173676 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('46039716','6686936','5',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC964456 lock mode IX ---TRANSACTION 9DC96444F, ACTIVE 22 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1072, OS thread handle 0x7f51156c9700, query id 4173472 192.168.0.203 fbhub wsrep in pre-commit stage INSERT IGNORE INTO users VALUES ('46039922','iph5ckfvuw','003473c9cf49b3fc77ef7dedb461146c7843d0b0','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:35','2634','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:35',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:35',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') TABLE LOCK table `lib_area_100`.`users` trx id 9DC96444F lock mode IX ---TRANSACTION 9DC96444B, ACTIVE 23 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 7 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 2 MySQL thread id 2291, OS thread handle 0x7f511570a700, query id 4173270 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('14754566', '1744162', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC96444B lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC96444B lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC96444B lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC96444B lock mode IS RECORD LOCKS space id 12854 page no 16613 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96444B lock mode S RECORD LOCKS space id 12854 page no 16614 n bits 128 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96444B lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC96444B lock mode IX ---TRANSACTION 9DC964449, ACTIVE 23 sec, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 7 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 1 MySQL thread id 1095, OS thread handle 0x7f5115502700, query id 4173247 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO user_channels (user,channel,subscr,address,s_key,last_daily_deannoy) VALUES ('44267474','7',NOW(),AES_ENCRYPT('',''),'e2aa592797d0bdb5babf48fa5e7460c32f4fddb4',NOW()) ON DUPLICATE KEY UPDATE user = VALUES(user), subscr = IF('0' > active, NOW(), subscr), active = IF('0',1,active), unsubscr = IF('0',NULL,unsubscr) TABLE LOCK table `lib_area_100`.`user_channels` trx id 9DC964449 lock mode IX TABLE LOCK table `lib_area_100`.`users` trx id 9DC964449 lock mode IS RECORD LOCKS space id 12854 page no 115316 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964449 lock mode S locks rec but not gap RECORD LOCKS space id 0 page no 187055 n bits 320 index `user_ch` of table `lib_area_100`.`user_channels` trx id 9DC964449 lock_mode X RECORD LOCKS space id 0 page no 6431161 n bits 192 index `PRIMARY` of table `lib_area_100`.`user_channels` trx id 9DC964449 lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_channels` trx id 9DC964449 lock mode IS RECORD LOCKS space id 0 page no 3044676 n bits 104 index `PRIMARY` of table `lib_area_100`.`spam_channels` trx id 9DC964449 lock mode S locks rec but not gap ---TRANSACTION 9DC964445, ACTIVE 23 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 2311, OS thread handle 0x7f5116236700, query id 4173169 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('40286436','6607243','1',IFNULL('2014-09-08 18:59:34',NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC964445 lock mode IX ---TRANSACTION 9DC96443C, ACTIVE 25 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1310, OS thread handle 0x7f50f57e8700, query id 4172284 192.168.0.203 fbhub wsrep in pre-commit stage INSERT IGNORE INTO users VALUES ('46039912','android_free3d82a017-8c46-3e26-8ab5-466c469f0ac6','8406a8eff2f2a12456a1fdfb9b280d4102468670','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:32','2609','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:32',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:32',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') TABLE LOCK table `lib_area_100`.`users` trx id 9DC96443C lock mode IX ---TRANSACTION 9DC964439, ACTIVE 25 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2255, OS thread handle 0x7f5115890700, query id 4172088 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('24790820', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC964439 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC964439 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC964439 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC964439 lock mode IS RECORD LOCKS space id 12854 page no 62592 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964439 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC964439 lock mode IX ---TRANSACTION 9DC964437, ACTIVE 25 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 1329, OS thread handle 0x7f51141b6700, query id 4172057 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('46039502', '1744291', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC964437 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC964437 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC964437 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC964437 lock mode IS RECORD LOCKS space id 12854 page no 121186 n bits 160 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964437 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC964437 lock mode IX ---TRANSACTION 9DC96442B, ACTIVE 26 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2310, OS thread handle 0x7f5114850700, query id 4171725 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('44750632', '1744349', '2', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC96442B lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC96442B lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC96442B lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC96442B lock mode IS RECORD LOCKS space id 12854 page no 116436 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96442B lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC96442B lock mode IX ---TRANSACTION 9DC964428, ACTIVE 26 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2214, OS thread handle 0x7f5115ee9700, query id 4171546 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('37911080', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC964428 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC964428 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC964428 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC964428 lock mode IS RECORD LOCKS space id 12854 page no 99652 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964428 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC964428 lock mode IX ---TRANSACTION 9DC964421, ACTIVE 27 sec, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 7 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 1 MySQL thread id 450, OS thread handle 0x7f50f59f0700, query id 4171052 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO user_channels (user,channel,subscr,address,s_key,last_daily_deannoy) VALUES ('45628352','7',NOW(),AES_ENCRYPT('',''),'d4a38c6a25cb3e066dad67432e72e29cfea4fe5e',NOW()) ON DUPLICATE KEY UPDATE user = VALUES(user), subscr = IF('0' > active, NOW(), subscr), active = IF('0',1,active), unsubscr = IF('0',NULL,unsubscr) TABLE LOCK table `lib_area_100`.`user_channels` trx id 9DC964421 lock mode IX TABLE LOCK table `lib_area_100`.`users` trx id 9DC964421 lock mode IS RECORD LOCKS space id 12854 page no 118479 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964421 lock mode S locks rec but not gap RECORD LOCKS space id 0 page no 6471547 n bits 320 index `user_ch` of table `lib_area_100`.`user_channels` trx id 9DC964421 lock_mode X RECORD LOCKS space id 0 page no 16712897 n bits 192 index `PRIMARY` of table `lib_area_100`.`user_channels` trx id 9DC964421 lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_channels` trx id 9DC964421 lock mode IS RECORD LOCKS space id 0 page no 3044676 n bits 104 index `PRIMARY` of table `lib_area_100`.`spam_channels` trx id 9DC964421 lock mode S locks rec but not gap ---TRANSACTION 9DC96441E, ACTIVE 27 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2309, OS thread handle 0x7f6908203700, query id 4171044 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('23131766', '1744298', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC96441E lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC96441E lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC96441E lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC96441E lock mode IS RECORD LOCKS space id 12854 page no 55009 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96441E lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC96441E lock mode IX ---TRANSACTION 9DC964417, ACTIVE 28 sec, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 7 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 1 MySQL thread id 1753, OS thread handle 0x7f5115278700, query id 4170528 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO user_channels (user,channel,subscr,address,s_key,last_daily_deannoy) VALUES ('41837416','7',NOW(),AES_ENCRYPT('',''),'168ac72197fa79289003012ec9474138507c10e8',NOW()) ON DUPLICATE KEY UPDATE user = VALUES(user), subscr = IF('0' > active, NOW(), subscr), active = IF('0',1,active), unsubscr = IF('0',NULL,unsubscr) TABLE LOCK table `lib_area_100`.`user_channels` trx id 9DC964417 lock mode IX TABLE LOCK table `lib_area_100`.`users` trx id 9DC964417 lock mode IS RECORD LOCKS space id 12854 page no 109677 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC964417 lock mode S locks rec but not gap RECORD LOCKS space id 0 page no 2377271 n bits 352 index `user_ch` of table `lib_area_100`.`user_channels` trx id 9DC964417 lock_mode X RECORD LOCKS space id 0 page no 7522335 n bits 200 index `PRIMARY` of table `lib_area_100`.`user_channels` trx id 9DC964417 lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_channels` trx id 9DC964417 lock mode IS RECORD LOCKS space id 0 page no 3044676 n bits 104 index `PRIMARY` of table `lib_area_100`.`spam_channels` trx id 9DC964417 lock mode S locks rec but not gap ---TRANSACTION 9DC964410, ACTIVE 29 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1369, OS thread handle 0x7f5114a17700, query id 4170303 192.168.0.203 fbhub wsrep in pre-commit stage INSERT IGNORE INTO users VALUES ('46039902','iph7u7m1si','364bdc95f1d214e45299e4479157154526aaed99','','',NULL,NULL,'','0',' ','','','','',NULL,'2014-09-08 18:59:28','2634','0','0',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'2014-09-08 18:59:28',NULL,NULL,NULL,'0.00',NULL,'2006-01-01',NULL,'0',NULL,'0','0',NULL,NULL,NULL,'0',NULL,'0.0000','0.00','2014-03-08 18:59:28',NULL,'2','1','2',NULL,NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'0000-01-01 00:00:00',NULL,NULL,'1') TABLE LOCK table `lib_area_100`.`users` trx id 9DC964410 lock mode IX ---TRANSACTION 9DC96440F, ACTIVE 29 sec, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 2275, OS thread handle 0x7f51158d1700, query id 4170148 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('46023772','8251513','2',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC96440F lock mode IX RECORD LOCKS space id 505 page no 21529278 n bits 232 index `uat` of table `lib_area_100`.`art_views` trx id 9DC96440F lock_mode X locks rec but not gap ---TRANSACTION 9DC96440D, ACTIVE 29 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2204, OS thread handle 0x7f51159d5700, query id 4170113 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('23084906', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC96440D lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC96440D lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC96440D lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC96440D lock mode IS RECORD LOCKS space id 12854 page no 54838 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96440D lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC96440D lock mode IX ---TRANSACTION 9DC964405, ACTIVE 30 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 1437, OS thread handle 0x7f51161f5700, query id 4169539 192.168.0.203 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('40461956','6682831','5',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC964405 lock mode IX ---TRANSACTION 9DC964403, ACTIVE 31 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 404, OS thread handle 0x7f5114995700, query id 4169289 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('40062332','172433','5',IFNULL(NULL,NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC964403 lock mode IX ---TRANSACTION 9DC9643F8, ACTIVE 32 sec, thread declared inside InnoDB 500 mysql tables in use 2, locked 2 6 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 MySQL thread id 2276, OS thread handle 0x7f5114607700, query id 4168379 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO spam_hits (user, spam, type, time) VALUES ('40098082', '1744349', '1', NOW()) TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9643F8 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9643F8 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9643F8 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9643F8 lock mode IS RECORD LOCKS space id 12854 page no 105378 n bits 120 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9643F8 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9643F8 lock mode IX ---TRANSACTION 9DC9643F3, ACTIVE 33 sec, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 2306, OS thread handle 0x7f51153fe700, query id 4168011 192.168.1.30 fbhub wsrep in pre-commit stage INSERT INTO art_views(user,art,type,last_time) VALUES('45920234','4235905','1',IFNULL('2014-09-08 18:59:24',NOW())) on duplicate key update hits = hits + 1, last_time = NOW() TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC9643F3 lock mode IX ---TRANSACTION 9DC9643F1, ACTIVE 33 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 155 lock struct(s), heap size 31160, 893 row lock(s), undo log entries 1879 MySQL thread id 13, OS thread handle 0x7f68e0549700, query id 4167930 Write_rows_log_event::write_row(12010680227) ------- TRX HAS BEEN WAITING 33 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 12856 page no 1804 n bits 496 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC9643F1 lock mode S locks rec but not gap waiting ------------------ TABLE LOCK table `lib_area_100`.`tasty_arts` trx id 9DC9643F1 lock mode IX RECORD LOCKS space id 474 page no 1401106 n bits 432 index `uaf` of table `lib_area_100`.`tasty_arts` trx id 9DC9643F1 lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC9643F1 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC9643F1 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC9643F1 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC9643F1 lock mode IS RECORD LOCKS space id 12854 page no 34106 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC9643F1 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC9643F1 lock mode IX TABLE LOCK table `lib_area_100`.`spam_tickets` trx id 9DC9643F1 lock mode IX RECORD LOCKS space id 10 page no 1054064 n bits 288 index `PRIMARY` of table `lib_area_100`.`spam_tickets` trx id 9DC9643F1 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC964248, ACTIVE 36 sec waiting in InnoDB queue mysql tables in use 3, locked 0 308 lock struct(s), heap size 47544, 3153 row lock(s), undo log entries 787 MySQL thread id 2304, OS thread handle 0x7f50f59af700, query id 4182099 192.168.0.215 fbhub Copying to tmp table INSERT INTO temp.tasty_arts_tmp24614 (art, weight, rate) SELECT ad.art, mi.weight, CASE WHEN mir.is_root = 1 THEN 1 WHEN COUNT(DISTINCT mir.genre) = 1 THEN 2 WHEN COUNT(DISTINCT mir.genre) = 2 THEN 5 ELSE 7 END AS tasting FROM arts_deploy AS ad JOIN genres_link AS o ON o.art = ad.art JOIN genres_link AS mir ON mir.genre = o.genre AND mir.art != ad.art JOIN temp.most_interesting_arts AS mi ON mi.art = mir.art WHERE ad.face = '475' GROUP BY ad.art, mi.art ORDER BY ad.art ASC, ta Trx read view will not see trx with id >= 9DC9644D4, sees < 9DC96209B TABLE LOCK table `lib_area_100`.`arts_deploy` trx id 9DC964248 lock mode IX RECORD LOCKS space id 12856 page no 1141 n bits 512 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC964248 lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 1055 n bits 528 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC964248 lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 1420 n bits 496 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC964248 lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 2147 n bits 496 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC964248 lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 2004 n bits 496 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC964248 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`ownership` trx id 9DC964248 lock mode IX RECORD LOCKS space id 12857 page no 620 n bits 584 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC964248 lock mode S locks rec but not gap RECORD LOCKS space id 12857 page no 612 n bits 336 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC964248 lock mode S locks rec but not gap RECORD LOCKS space id 12857 page no 593 n bits 624 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC964248 lock mode S locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC96420D, ACTIVE 37 sec 3 lock struct(s), heap size 376, 1 row lock(s), undo log entries 2 MySQL thread id 2269, OS thread handle 0x7f5115b1a700, query id 4164285 192.168.1.30 fbhub sleeping TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC96420D lock mode IX TABLE LOCK table `lib_area_100`.`users` trx id 9DC96420D lock mode IX RECORD LOCKS space id 12854 page no 93554 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96420D lock_mode X locks rec but not gap ---TRANSACTION 9DC9640AB, ACTIVE 45 sec waiting in InnoDB queue mysql tables in use 4, locked 0 399 lock struct(s), heap size 63928, 5175 row lock(s), undo log entries 890 MySQL thread id 2299, OS thread handle 0x7f5114fee700, query id 4182177 192.168.0.215 fbhub Sending data SELECT ta.art, IF(ta.rate > 100, 100, ROUND(ta.rate)) AS msg_tasty, o.person FROM tasty_arts ta JOIN ownership o ON o.art = ta.art AND o.relation = 0 LEFT JOIN tasty_arts AS one_pers ON one_pers.user = ta.user AND one_pers.face = ta.face AND one_pers.rate >= ta.rate AND one_pers.art > ta.art LEFT JOIN ownership oo ON oo.person = o.person AND o.relation = 0 AND oo.art = one_pers.art WHERE ta.user = 23538332 AND ta.face = 475 GROUP BY ta.user, ta.face, ta.rate, ta.art HAVING COUNT(oo.art) <= 3 ORDER BY ta.user DESC, ta.face TABLE LOCK table `lib_area_100`.`arts_deploy` trx id 9DC9640AB lock mode IX RECORD LOCKS space id 12856 page no 1141 n bits 512 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC9640AB lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 2147 n bits 496 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC9640AB lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`ownership` trx id 9DC9640AB lock mode IX RECORD LOCKS space id 12857 page no 620 n bits 584 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC9640AB lock mode S locks rec but not gap RECORD LOCKS space id 12857 page no 593 n bits 624 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC9640AB lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`genres_link` trx id 9DC9640AB lock mode IX RECORD LOCKS space id 12858 page no 1582 n bits 608 index `uniq_genre_link` of table `lib_area_100`.`genres_link` trx id 9DC9640AB lock mode S locks rec but not gap RECORD LOCKS space id 12858 page no 1551 n bits 640 index `uniq_genre_link` of table `lib_area_100`.`genres_link` trx id 9DC9640AB lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`sequences_link` trx id 9DC9640AB lock mode IX TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC963EEF, ACTIVE 57 sec waiting in InnoDB queue mysql tables in use 6, locked 1 465 lock struct(s), heap size 63928, 5691 row lock(s), undo log entries 1174 MySQL thread id 2289, OS thread handle 0x7f5114ca1700, query id 4182173 192.168.0.215 fbhub Copying to tmp table REPLACE INTO tasty_arts (user, art, face, updated, rate) SELECT '22588094' AS user, foo.art, '475' AS face, '2014-09-08 18:59:51' AS updated, POW(foo.is_hot * foo.rrate / 100, 0.9) + foo.is_hot * (o.lvl - 1) * 3.75 AS rrrate FROM ( SELECT tt.art, ad.is_hot, tt.weight * tt.rate * EXP(SUM(LOG(IFNULL(avt.still_interesting/av.hits/100,1)))) AS rrate FROM temp.tasty_arts_tmp24240 AS tt JOIN arts_deploy AS ad ON ad.art = tt.art AND ad.face = '475' LEFT JOIN art_views AS av ON av.art = tt.art AND av.user = '2258809 Trx read view will not see trx with id >= 9DC9644D8, sees < 9DC96209B TABLE LOCK table `lib_area_100`.`arts_deploy` trx id 9DC963EEF lock mode IX RECORD LOCKS space id 12856 page no 2195 n bits 312 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC963EEF lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 1141 n bits 512 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC963EEF lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 3543 n bits 448 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC963EEF lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 2227 n bits 456 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC963EEF lock mode S locks rec but not gap RECORD LOCKS space id 12856 page no 828 n bits 496 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC963EEF lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`ownership` trx id 9DC963EEF lock mode IX RECORD LOCKS space id 12857 page no 620 n bits 584 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC963EEF lock mode S locks rec but not gap RECORD LOCKS space id 12857 page no 617 n bits 552 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC963EEF lock mode S locks rec but not gap RECORD LOCKS space id 12857 page no 416 n bits 288 index `PRIMARY` of table `lib_area_100`.`ownership` trx id 9DC963EEF lock mode S locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC963980, ACTIVE 84 sec 706 lock struct(s), heap size 96696, 8741 row lock(s), undo log entries 5596 MySQL thread id 2191, OS thread handle 0x7f5114071700, query id 4168026 192.168.0.215 fbhub wsrep in pre-commit stage commit TABLE LOCK table `lib_area_100`.`tasty_arts` trx id 9DC963980 lock mode IX RECORD LOCKS space id 474 page no 118063 n bits 432 index `uaf` of table `lib_area_100`.`tasty_arts` trx id 9DC963980 lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC963980 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC963980 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC963980 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC963980 lock mode IS RECORD LOCKS space id 12854 page no 71617 n bits 128 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC963980 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC963980 lock mode IX TABLE LOCK table `lib_area_100`.`spam_tickets` trx id 9DC963980 lock mode IX RECORD LOCKS space id 10 page no 99806 n bits 176 index `PRIMARY` of table `lib_area_100`.`spam_tickets` trx id 9DC963980 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC962A02, ACTIVE 113 sec 10 lock struct(s), heap size 1248, 15 row lock(s), undo log entries 16 MySQL thread id 2128, OS thread handle 0x7f68c8221700, query id 4174464 192.168.1.30 fbhub sleeping Trx read view will not see trx with id >= 9DC962A03, sees < 9DC95FDBC TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC962A02 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC962A02 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC962A02 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC962A02 lock mode IS RECORD LOCKS space id 12854 page no 101484 n bits 136 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC962A02 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC962A02 lock mode IX TABLE LOCK table `lib_area_100`.`user_best_times` trx id 9DC962A02 lock mode IX RECORD LOCKS space id 0 page no 4995548 n bits 680 index `PRIMARY` of table `lib_area_100`.`user_best_times` trx id 9DC962A02 lock_mode X locks rec but not gap RECORD LOCKS space id 12854 page no 103755 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC962A02 lock mode S locks rec but not gap RECORD LOCKS space id 0 page no 3554646 n bits 680 index `PRIMARY` of table `lib_area_100`.`user_best_times` trx id 9DC962A02 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC962785, ACTIVE 126 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 19 lock struct(s), heap size 3112, 138 row lock(s), undo log entries 38 MySQL thread id 2184, OS thread handle 0x7f5114bde700, query id 4174743 192.168.0.215 fbhub update INSERT IGNORE INTO arts_deploy VALUES('5629628','645','2013-05-29 15:52:49','0.998474576') ------- TRX HAS BEEN WAITING 20 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 12856 page no 1280 n bits 496 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC962785 lock mode S locks rec but not gap waiting ------------------ TABLE LOCK table `lib_area_100`.`tasty_arts` trx id 9DC962785 lock mode IX RECORD LOCKS space id 474 page no 262942 n bits 440 index `uaf` of table `lib_area_100`.`tasty_arts` trx id 9DC962785 lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC962785 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC962785 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC962785 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC962785 lock mode IS RECORD LOCKS space id 12854 page no 43481 n bits 120 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC962785 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC962785 lock mode IX TABLE LOCK table `lib_area_100`.`spam_tickets` trx id 9DC962785 lock mode IX RECORD LOCKS space id 10 page no 99786 n bits 288 index `PRIMARY` of table `lib_area_100`.`spam_tickets` trx id 9DC962785 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC962723, ACTIVE 129 sec 10 lock struct(s), heap size 1248, 9 row lock(s), undo log entries 10 MySQL thread id 2220, OS thread handle 0x7f5114e27700, query id 4182095 192.168.1.30 fbhub sleeping Trx read view will not see trx with id >= 9DC9644D4, sees < 9DC96209B TABLE LOCK table `lib_area_100`.`art_views` trx id 9DC962723 lock mode IX TABLE LOCK table `lib_area_100`.`users` trx id 9DC962723 lock mode IX RECORD LOCKS space id 12854 page no 117678 n bits 144 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC962723 lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC962723 lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC962723 lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC962723 lock mode S locks rec but not gap RECORD LOCKS space id 12854 page no 107376 n bits 152 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC962723 lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC962723 lock mode IX TABLE LOCK table `lib_area_100`.`user_best_times` trx id 9DC962723 lock mode IX RECORD LOCKS space id 0 page no 748407 n bits 680 index `PRIMARY` of table `lib_area_100`.`user_best_times` trx id 9DC962723 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION 9DC96209B, ACTIVE 148 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 937 lock struct(s), heap size 129464, 15880 row lock(s), undo log entries 4078 MySQL thread id 2175, OS thread handle 0x7f50f510d700, query id 4179022 192.168.0.215 fbhub update INSERT IGNORE INTO arts_deploy VALUES('119704','312','2013-01-01 00:00:00','0.99847') ------- TRX HAS BEEN WAITING 12 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 12856 page no 2176 n bits 520 index `PRIMARY` of table `lib_area_100`.`arts_deploy` trx id 9DC96209B lock mode S locks rec but not gap waiting ------------------ TABLE LOCK table `lib_area_100`.`tasty_arts` trx id 9DC96209B lock mode IX RECORD LOCKS space id 474 page no 1523461 n bits 384 index `uaf` of table `lib_area_100`.`tasty_arts` trx id 9DC96209B lock_mode X locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits` trx id 9DC96209B lock mode IX TABLE LOCK table `lib_area_100`.`spam_packs` trx id 9DC96209B lock mode IS RECORD LOCKS space id 52 page no 4234 n bits 208 index `PRIMARY` of table `lib_area_100`.`spam_packs` trx id 9DC96209B lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`users` trx id 9DC96209B lock mode IS RECORD LOCKS space id 12854 page no 5861 n bits 112 index `PRIMARY` of table `lib_area_100`.`users` trx id 9DC96209B lock mode S locks rec but not gap TABLE LOCK table `lib_area_100`.`spam_hits_pj` trx id 9DC96209B lock mode IX TABLE LOCK table `lib_area_100`.`spam_tickets` trx id 9DC96209B lock mode IX RECORD LOCKS space id 10 page no 256253 n bits 296 index `PRIMARY` of table `lib_area_100`.`spam_tickets` trx id 9DC96209B lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---------------------------- END OF INNODB MONITOR OUTPUT ============================ WSREP: BF lock wait long ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- Killed 140908 19:00:01 mysqld_safe Number of processes running now: 0 140908 19:00:01 mysqld_safe WSREP: not restarting wsrep node automatically 140908 19:00:01 mysqld_safe mysqld from pid file /mysql/mysql.pid ended 140908 19:00:42 mysqld_safe Starting mysqld daemon with databases from /mysql/data 140908 19:00:42 mysqld_safe WSREP: Running position recovery with --log_error='/mysql/data/wsrep_recovery.AGU9Te' --pid-file='/mysql/data/dbp02-recover.pid' 140908 19:08:06 mysqld_safe WSREP: Recovered position 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010680226 140908 19:08:06 [Note] WSREP: wsrep_start_position var submitted: '2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010680226' 140908 19:08:06 [Note] WSREP: Read nil XID from storage engines, skipping position init 140908 19:08:06 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so' 140908 19:08:06 [Note] WSREP: wsrep_load(): Galera 2.11(r318911d) by Codership Oy loaded successfully. 140908 19:08:06 [Note] WSREP: Found saved state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:-1 140908 19:08:06 [Note] WSREP: Reusing existing '/mysql/data//galera.cache'. 140908 19:08:06 [Note] WSREP: Passing config to GCS: base_host = 193.26.19.69; base_port = 4567; cert.log_conflicts = no; debug = no; 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 = /mysql/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mysql/data//galera.cache; gcache.page_size = 128M; gcache.size = 512M; 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.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet.backend = asio; protonet 140908 19:08:06 [Note] WSREP: Assign initial position for certification: 12010680226, protocol version: -1 140908 19:08:06 [Note] WSREP: wsrep_sst_grab() 140908 19:08:06 [Note] WSREP: Start replication 140908 19:08:06 [Note] WSREP: Setting initial position to 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010680226 140908 19:08:06 [Note] WSREP: protonet asio version 0 140908 19:08:06 [Note] WSREP: backend: asio 140908 19:08:06 [Note] WSREP: GMCast version 0 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 140908 19:08:06 [Note] WSREP: EVS version 0 140908 19:08:06 [Note] WSREP: PC version 0 140908 19:08:06 [Note] WSREP: gcomm: connecting to group 'dbp', peer 'dbp02:,dbp04:,dbp06:,dbp08:' 140908 19:08:06 [Warning] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' points to own listening address, blacklisting 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:06 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') address 'tcp://192.168.1.69:4567' pointing to uuid f03b17bd is blacklisted, skipping 140908 19:08:08 [Note] WSREP: declaring 31b55857 at tcp://192.168.0.212:4567 stable 140908 19:08:08 [Note] WSREP: declaring e28d1da6 at tcp://192.168.1.72:4567 stable 140908 19:08:08 [Note] WSREP: declaring e9cdef6b at tcp://192.168.0.214:4567 stable 140908 19:08:08 [Note] WSREP: Node 31b55857 state prim 140908 19:08:08 [Note] WSREP: gcomm: connected 140908 19:08:08 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 140908 19:08:08 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 140908 19:08:08 [Note] WSREP: Opened channel 'dbp' 140908 19:08:08 [Note] WSREP: Waiting for SST to complete. 140908 19:08:08 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 3, memb_num = 4 140908 19:08:08 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 140908 19:08:08 [Note] WSREP: STATE EXCHANGE: sent state msg: f123468d-3769-11e4-a989-d7f6e4fee95e 140908 19:08:08 [Note] WSREP: STATE EXCHANGE: got state msg: f123468d-3769-11e4-a989-d7f6e4fee95e from 0 (dbp04) 140908 19:08:08 [Note] WSREP: STATE EXCHANGE: got state msg: f123468d-3769-11e4-a989-d7f6e4fee95e from 1 (dbp08) 140908 19:08:08 [Note] WSREP: STATE EXCHANGE: got state msg: f123468d-3769-11e4-a989-d7f6e4fee95e from 2 (dbp06) 140908 19:08:08 [Note] WSREP: STATE EXCHANGE: got state msg: f123468d-3769-11e4-a989-d7f6e4fee95e from 3 (dbp02) 140908 19:08:08 [Note] WSREP: Quorum results: version = 2, component = PRIMARY, conf_id = 29, members = 3/4 (joined/total), act_id = 12010697358, last_appl. = -1, protocols = 0/4/3 (gcs/repl/appl), group UUID = 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5 140908 19:08:08 [Note] WSREP: Flow-control interval: [32, 32] 140908 19:08:08 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 12010697358) 140908 19:08:08 [Note] WSREP: State transfer required: Group state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010697358 Local state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010680226 140908 19:08:08 [Note] WSREP: New cluster view: global state: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010697358, view# 30: Primary, number of nodes: 4, my index: 3, protocol version 3 140908 19:08:08 [Warning] WSREP: Gap in state sequence. Need state transfer. 140908 19:08:08 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.69' --auth 'root:p7sVbxAf' --datadir '/mysql/data/' --defaults-file '/etc/my.cnf' --parent '7971'' WSREP_SST: [INFO] Streaming with xbstream (20140908 19:08:09.140) WSREP_SST: [INFO] Using socat as streamer (20140908 19:08:09.144) WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | xbstream -x; RC=( ${PIPESTATUS[@]} ) (20140908 19:08:09.442) 140908 19:08:09 [Note] WSREP: Prepared SST request: xtrabackup-v2|192.168.1.69:4444/xtrabackup_sst 140908 19:08:09 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 140908 19:08:09 [Note] WSREP: Assign initial position for certification: 12010697358, protocol version: 2 140908 19:08:09 [Note] WSREP: Prepared IST receiver, listening at: tcp://193.26.19.69:4568 140908 19:08:09 [Note] WSREP: Node 3 (dbp02) requested state transfer from '*any*'. Selected 0 (dbp04)(SYNCED) as donor. 140908 19:08:09 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 12010697517) 140908 19:08:09 [Note] WSREP: Requesting state transfer: success, donor: 0 WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20140908 19:08:10.149) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20140908 19:08:10.153) WSREP_SST: [INFO] Removing the sst_in_progress file (20140908 19:08:10.157) 140908 19:08:10 [Note] WSREP: SST complete, seqno: 12010680226 140908 19:08:10 InnoDB: The InnoDB memory heap is disabled 140908 19:08:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140908 19:08:10 InnoDB: Compressed tables use zlib 1.2.3.4 140908 19:08:10 InnoDB: Using Linux native AIO 140908 19:08:10 InnoDB: Initializing buffer pool, size = 90.0G 140908 19:08:10 [Note] WSREP: (f03b17bd, 'tcp://0.0.0.0:4567') turning message relay requesting off 140908 19:08:16 InnoDB: Completed initialization of buffer pool 140908 19:08:16 InnoDB: highest supported file format is Barracuda. 140908 19:08:21 InnoDB: Waiting for the background threads to start 140908 19:08:22 Percona XtraDB (http://www.percona.com) 5.5.39-36.0 started; log sequence number 17823831948897 140908 19:08:22 [Warning] 'proxies_priv' entry '@ root@percona1' ignored in --skip-name-resolve mode. 140908 19:08:22 [Note] Event Scheduler: Loaded 0 events 140908 19:08:22 [Note] WSREP: Signalling provider to continue. 140908 19:08:22 [Note] WSREP: SST received: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010680226 140908 19:08:22 [Note] WSREP: Receiving IST: 17132 writesets, seqnos 12010680226-12010697358 140908 19:08:22 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.39-36.0' socket: '/mysql/tmp/mysql.sock' port: 8661 , wsrep_25.11.rXXXX 140908 19:11:51 [Note] WSREP: 0 (dbp04): State transfer to 3 (dbp02) complete. 140908 19:11:51 [Note] WSREP: Member 0 (dbp04) synced with group. 140908 19:11:51 [Note] WSREP: IST received: 2db76c9f-1717-11e3-b9d2-2f0c3a53a9e5:12010697358 140908 19:11:51 [Note] WSREP: 3 (dbp02): State transfer from 0 (dbp04) complete. 140908 19:11:51 [Note] WSREP: Shifting JOINER -> JOINED (TO: 12010704612) 140908 19:13:13 [Note] WSREP: Member 3 (dbp02) synced with group. 140908 19:13:13 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 12010706486) 140908 19:13:14 [Note] WSREP: Synchronized with group, ready for connections 140908 19:13:14 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.