[root@karma049 ~]# tcpdump -i enp5s0f0 port 3306 -A tcpdump: verbose output suppressed, use -v or -vv for full protocol decode listening on enp5s0f0, link-type EN10MB (Ethernet), capture size 262144 bytes 18:15:29.805869 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 4259137795:4259137800, ack 444450569, win 1424, options [nop,nop,TS val 423961537 ecr 427960138], length 5 E..9.[@.@... ... ..~.p....I..}. .....5..... .E#...'J..... 18:15:29.805990 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 1:12, ack 5, win 1432, options [nop,nop,TS val 427970536 ecr 423961537], length 11 E..?.B@.@.'! ..~ ......p.}. ..I.....0...... ..O..E#............ 18:15:29.806130 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 12, win 1424, options [nop,nop,TS val 423961537 ecr 427970536], length 0 E..4.\@.@.. ... ..~.p....I..}............. .E#...O. 18:15:29.806175 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 5:67, ack 12, win 1424, options [nop,nop,TS val 423961537 ecr 427970536], length 62 E..r.]@.@... ... ..~.p....I..}............. .E#...O.:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:15:29.806712 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 12:110, ack 67, win 1432, options [nop,nop,TS val 427970537 ecr 423961537], length 98 E....C@.@.&. ..~ ......p.}....IF....0...... ..O..E#......<....def.system membership membership.status.status.-.........................quorum......... 18:15:29.806929 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 67:138, ack 110, win 1424, options [nop,nop,TS val 423961538 ecr 427970537], length 71 E..{.^@.@... ... ..~.p....IF.}.v.....Z..... .E#...O.C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:15:29.807304 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 110:209, ack 138, win 1432, options [nop,nop,TS val 427970537 ecr 423961538], length 99 E....D@.@.&. ..~ ......p.}.v..I.....0...... ..O..E#......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:15:29.807523 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 138:204, ack 209, win 1424, options [nop,nop,TS val 423961538 ecr 427970537], length 66 E..v._@.@... ... ..~.p....I..}......`...... .E#...O.>....SELECT nid, status, instance, substate FROM system.membership 18:15:29.807935 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 209:556, ack 204, win 1432, options [nop,nop,TS val 427970538 ecr 423961538], length 347 E....E@.@.%. ..~ ......p.}....I.....1...... ..O..E#......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:15:29.808175 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 204:375, ack 556, win 1424, options [nop,nop,TS val 423961539 ecr 427970538], length 171 E....`@.@..[ ... ..~.p....I..}.4........... .E#...O......SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:15:29.810075 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 556:972, ack 375, win 1432, options [nop,nop,TS val 427970540 ecr 423961539], length 416 E....F@.@.%. ..~ ......p.}.4..Jz....2...... ..O..E#......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .3.10.2.15.143.3306.3581.... .2.10.2.12.232.3306.3581.......... 18:15:29.849731 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 972, win 1424, options [nop,nop,TS val 423961581 ecr 427970540], length 0 E..4.a@.@... ... ..~.p....Jz.}.......2..... .E#...O. 18:15:40.207961 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 375:380, ack 972, win 1424, options [nop,nop,TS val 423971939 ecr 427970540], length 5 E..9.b@.@... ... ..~.p....Jz.}......h...... .ELc..O...... 18:15:40.208082 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 972:983, ack 380, win 1432, options [nop,nop,TS val 427980938 ecr 423971939], length 11 E..?.G@.@.'. ..~ ......p.}....J.....0...... ..x..ELc........... 18:15:40.208253 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 983, win 1424, options [nop,nop,TS val 423971939 ecr 427980938], length 0 E..4.c@.@... ... ..~.p....J..}......O...... .ELc..x. 18:15:40.208271 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 380:442, ack 983, win 1424, options [nop,nop,TS val 423971939 ecr 427980938], length 62 E..r.d@.@... ... ..~.p....J..}......CE..... .ELc..x.:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:15:40.208901 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 983:1081, ack 442, win 1432, options [nop,nop,TS val 427980939 ecr 423971939], length 98 E....H@.@.&. ..~ ......p.}....J.....0...... ..x..ELc.....<....def.system membership membership.status.status.-.........................quorum......... 18:15:40.209134 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 442:513, ack 1081, win 1424, options [nop,nop,TS val 423971940 ecr 427980939], length 71 E..{.e@.@... ... ..~.p....J..}.A........... .ELd..x.C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:15:40.209607 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 1081:1180, ack 513, win 1432, options [nop,nop,TS val 427980940 ecr 423971940], length 99 E....I@.@.&. ..~ ......p.}.A..K.....0...... ..x..ELd.....H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:15:40.209828 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 513:579, ack 1180, win 1424, options [nop,nop,TS val 423971941 ecr 427980940], length 66 E..v.f@.@... ... ..~.p....K..}...... ...... .ELe..x.>....SELECT nid, status, instance, substate FROM system.membership 18:15:40.210249 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 1180:1527, ack 579, win 1432, options [nop,nop,TS val 427980940 ecr 423971941], length 347 E....J@.@.%. ..~ ......p.}....KF....1...... ..x..ELe.....6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:15:40.210500 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 579:750, ack 1527, win 1424, options [nop,nop,TS val 423971941 ecr 427980940], length 171 E....g@.@..T ... ..~.p....KF.}......`{..... .ELe..x......SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:15:40.212620 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 1527:1943, ack 750, win 1432, options [nop,nop,TS val 427980943 ecr 423971941], length 416 E....K@.@.%. ..~ ......p.}....K.....2...... ..x..ELe.....2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .2.10.2.12.232.3306.3581.... .3.10.2.15.143.3306.3581.......... 18:15:40.252768 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 1943, win 1424, options [nop,nop,TS val 423971984 ecr 427980943], length 0 E..4.h@.@... ... ..~.p....K..}......I...... .EL...x. 18:15:50.610487 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 750:755, ack 1943, win 1424, options [nop,nop,TS val 423982341 ecr 427980943], length 5 E..9.i@.@... ... ..~.p....K..}.......(..... .Eu...x...... 18:15:50.610607 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 1943:1954, ack 755, win 1432, options [nop,nop,TS val 427991341 ecr 423982341], length 11 E..?.L@.@.'. ..~ ......p.}....K.....0...... ...-.Eu............ 18:15:50.610762 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 1954, win 1424, options [nop,nop,TS val 423982342 ecr 427991341], length 0 E..4.j@.@... ... ..~.p....K..}............. .Eu....- 18:15:50.610813 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 755:817, ack 1954, win 1424, options [nop,nop,TS val 423982342 ecr 427991341], length 62 E..r.k@.@... ... ..~.p....K..}............. .Eu....-:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:15:50.611339 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 1954:2052, ack 817, win 1432, options [nop,nop,TS val 427991341 ecr 423982342], length 98 E....M@.@.&. ..~ ......p.}....L4....0...... ...-.Eu......<....def.system membership membership.status.status.-.........................quorum......... 18:15:50.611575 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 817:888, ack 2052, win 1424, options [nop,nop,TS val 423982342 ecr 427991341], length 71 E..{.l@.@... ... ..~.p....L4.}......1N..... .Eu....-C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:15:50.611954 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 2052:2151, ack 888, win 1432, options [nop,nop,TS val 427991342 ecr 423982342], length 99 E....N@.@.&. ..~ ......p.}....L{....0...... .....Eu......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:15:50.612176 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 888:954, ack 2151, win 1424, options [nop,nop,TS val 423982343 ecr 427991342], length 66 E..v.m@.@... ... ..~.p....L{.}.o........... .Eu.....>....SELECT nid, status, instance, substate FROM system.membership 18:15:50.612606 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 2151:2498, ack 954, win 1432, options [nop,nop,TS val 427991343 ecr 423982343], length 347 E....O@.@.%. ..~ ......p.}.o..L.....1...... .../.Eu......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:15:50.612848 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 954:1125, ack 2498, win 1424, options [nop,nop,TS val 423982344 ecr 427991343], length 171 E....n@.@..M ... ..~.p....L..}...... ...... .Eu..../.....SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:15:50.614815 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 2498:2914, ack 1125, win 1432, options [nop,nop,TS val 427991345 ecr 423982344], length 416 E....P@.@.%~ ..~ ......p.}....Mh....2...... ...1.Eu......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .3.10.2.15.143.3306.3581.... .2.10.2.12.232.3306.3581.......... 18:15:50.654758 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 2914, win 1424, options [nop,nop,TS val 423982386 ecr 427991345], length 0 E..4.o@.@... ... ..~.p....Mh.}.j.....#..... .Eu2...1 18:16:01.110740 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1125:1130, ack 2914, win 1424, options [nop,nop,TS val 423992842 ecr 427991345], length 5 E..9.p@.@... ... ..~.p....Mh.}.j.....>..... .E. ...1..... 18:16:01.110859 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 2914:2925, ack 1130, win 1432, options [nop,nop,TS val 428001841 ecr 423992842], length 11 E..?.Q@.@.'. ..~ ......p.}.j..Mm....0...... ...1.E. ........... 18:16:01.111035 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 2925, win 1424, options [nop,nop,TS val 423992842 ecr 428001841], length 0 E..4.q@.@... ... ..~.p....Mm.}.u.....;..... .E. ...1 18:16:01.111047 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1130:1192, ack 2925, win 1424, options [nop,nop,TS val 423992842 ecr 428001841], length 62 E..r.r@.@... ... ..~.p....Mm.}.u.....r..... .E. ...1:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:16:01.111576 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 2925:3023, ack 1192, win 1432, options [nop,nop,TS val 428001842 ecr 423992842], length 98 E....R@.@.&. ..~ ......p.}.u..M.....0...... ...2.E. .....<....def.system membership membership.status.status.-.........................quorum......... 18:16:01.111804 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1192:1263, ack 3023, win 1424, options [nop,nop,TS val 423992843 ecr 428001842], length 71 E..{.s@.@... ... ..~.p....M..}............. .E.....2C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:16:01.112187 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 3023:3122, ack 1263, win 1432, options [nop,nop,TS val 428001842 ecr 423992843], length 99 E....S@.@.&. ..~ ......p.}....M.....0...... ...2.E.......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:16:01.112379 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1263:1329, ack 3122, win 1424, options [nop,nop,TS val 423992843 ecr 428001842], length 66 E..v.t@.@... ... ..~.p....M..}.:....[...... .E.....2>....SELECT nid, status, instance, substate FROM system.membership 18:16:01.112803 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 3122:3469, ack 1329, win 1432, options [nop,nop,TS val 428001843 ecr 423992843], length 347 E....T@.@.%. ..~ ......p.}.:..N4....1...... ...3.E.......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:16:01.113051 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1329:1500, ack 3469, win 1424, options [nop,nop,TS val 423992844 ecr 428001843], length 171 E....u@.@..F ... ..~.p....N4.}............. .E.....3.....SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:16:01.115015 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 3469:3885, ack 1500, win 1432, options [nop,nop,TS val 428001845 ecr 423992844], length 416 E....U@.@.%y ..~ ......p.}....N.....2...... ...5.E.......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .3.10.2.15.143.3306.3581.... .2.10.2.12.232.3306.3581.......... 18:16:01.154749 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 3885, win 1424, options [nop,nop,TS val 423992886 ecr 428001845], length 0 E..4.v@.@... ... ..~.p....N..}.5........... .E.6...5 18:16:01.473168 IP karma075.colo.sproutsys.com.56290 > karma049.colo.sproutsys.com.mysql: Flags [S], seq 636191773, win 29200, options [mss 1460,sackOK,TS val 423993204 ecr 0,nop,wscale 7], length 0 E..<.i@.@... ... ..~....%.........r.Z.......... .E.t........ 18:16:01.473197 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.56290: Flags [S.], seq 3597000468, ack 636191774, win 28960, options [mss 1460,sackOK,TS val 428002203 ecr 423993204,nop,wscale 7], length 0 E..<..@.@. g ..~ ........e..%.....q 0.......... .....E.t.... 18:16:01.473339 IP karma075.colo.sproutsys.com.56290 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 1, win 229, options [nop,nop,TS val 423993204 ecr 428002203], length 0 E..4.j@.@... ... ..~....%....e......_Y..... .E.t.... 18:16:11.483506 IP karma075.colo.sproutsys.com.56290 > karma049.colo.sproutsys.com.mysql: Flags [F.], seq 1, ack 1, win 229, options [nop,nop,TS val 424003214 ecr 428002203], length 0 E..4.k@.@... ... ..~....%....e......8>..... .E...... 18:16:11.483583 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.56290: Flags [F.], seq 1, ack 2, win 227, options [nop,nop,TS val 428012214 ecr 424003214], length 0 E..4..@.@... ..~ ........e..%.......0|..... .....E.. 18:16:11.483711 IP karma075.colo.sproutsys.com.56290 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 2, win 229, options [nop,nop,TS val 424003215 ecr 428012214], length 0 E..4.l@.@... ... ..~....%....e.......!..... .E...... 18:16:11.512832 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1500:1505, ack 3885, win 1424, options [nop,nop,TS val 424003244 ecr 428001845], length 5 E..9.w@.@... ... ..~.p....N..}.5....dV..... .E.....5..... 18:16:11.512952 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 3885:3896, ack 1505, win 1432, options [nop,nop,TS val 428012243 ecr 424003244], length 11 E..?.V@.@.' ..~ ......p.}.5..N.....0...... .....E............. 18:16:11.513161 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 3896, win 1424, options [nop,nop,TS val 424003244 ecr 428012243], length 0 E..4.x@.@... ... ..~.p....N..}.@....J...... .E...... 18:16:11.513175 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1505:1567, ack 3896, win 1424, options [nop,nop,TS val 424003244 ecr 428012243], length 62 E..r.y@.@... ... ..~.p....N..}.@....>...... .E......:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:16:11.513717 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 3896:3994, ack 1567, win 1432, options [nop,nop,TS val 428012244 ecr 424003244], length 98 E....W@.@.&. ..~ ......p.}.@..O"....0...... .....E.......<....def.system membership membership.status.status.-.........................quorum......... 18:16:11.513924 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1567:1638, ack 3994, win 1424, options [nop,nop,TS val 424003245 ecr 428012244], length 71 E..{.z@.@... ... ..~.p....O".}.......{..... .E......C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:16:11.514313 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 3994:4093, ack 1638, win 1432, options [nop,nop,TS val 428012244 ecr 424003245], length 99 E....X@.@.&. ..~ ......p.}....Oi....0...... .....E.......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:16:11.514506 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1638:1704, ack 4093, win 1424, options [nop,nop,TS val 424003245 ecr 428012244], length 66 E..v.{@.@... ... ..~.p....Oi.}.......6..... .E......>....SELECT nid, status, instance, substate FROM system.membership 18:16:11.514932 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 4093:4440, ack 1704, win 1432, options [nop,nop,TS val 428012245 ecr 424003245], length 347 E....Y@.@.%. ..~ ......p.}....O.....1...... .....E.......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:16:11.515185 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1704:1875, ack 4440, win 1424, options [nop,nop,TS val 424003246 ecr 428012245], length 171 E....|@.@..? ... ..~.p....O..}.`....\"..... .E...........SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:16:11.517169 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 4440:4856, ack 1875, win 1432, options [nop,nop,TS val 428012247 ecr 424003246], length 416 E....Z@.@.%t ..~ ......p.}.`..PV....2...... .....E.......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .2.10.2.12.232.3306.3581.... .3.10.2.15.143.3306.3581.......... 18:16:11.556725 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 4856, win 1424, options [nop,nop,TS val 424003288 ecr 428012247], length 0 E..4.}@.@... ... ..~.p....PV.}......ES..... .E...... 18:16:22.014149 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1875:1880, ack 4856, win 1424, options [nop,nop,TS val 424013745 ecr 428012247], length 5 E..9.~@.@... ... ..~.p....PV.}.......m..... .E........... 18:16:22.014275 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 4856:4867, ack 1880, win 1432, options [nop,nop,TS val 428022744 ecr 424013745], length 11 E..?.[@.@.'. ..~ ......p.}....P[....0...... .....E............. 18:16:22.014423 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 4867, win 1424, options [nop,nop,TS val 424013745 ecr 428022744], length 0 E..4..@.@... ... ..~.p....P[.}.......h..... .E...... 18:16:22.014469 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1880:1942, ack 4867, win 1424, options [nop,nop,TS val 424013745 ecr 428022744], length 62 E..r..@.@... ... ..~.p....P[.}............. .E......:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:16:22.015000 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 4867:4965, ack 1942, win 1432, options [nop,nop,TS val 428022745 ecr 424013745], length 98 E....\@.@.&. ..~ ......p.}....P.....0...... .....E.......<....def.system membership membership.status.status.-.........................quorum......... 18:16:22.015209 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 1942:2013, ack 4965, win 1424, options [nop,nop,TS val 424013746 ecr 428022745], length 71 E..{..@.@... ... ..~.p....P..}.m....,/..... .E......C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:16:22.015609 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 4965:5064, ack 2013, win 1432, options [nop,nop,TS val 428022746 ecr 424013746], length 99 E....]@.@.&. ..~ ......p.}.m..P.....0...... .....E.......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:16:22.015837 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2013:2079, ack 5064, win 1424, options [nop,nop,TS val 424013747 ecr 428022746], length 66 E..v..@.@... ... ..~.p....P..}............. .E......>....SELECT nid, status, instance, substate FROM system.membership 18:16:22.016245 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 5064:5411, ack 2079, win 1432, options [nop,nop,TS val 428022746 ecr 424013747], length 347 E....^@.@.%. ..~ ......p.}....Q"....1...... .....E.......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:16:22.016485 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2079:2250, ack 5411, win 1424, options [nop,nop,TS val 424013747 ecr 428022746], length 171 E.....@.@..8 ... ..~.p....Q".}.+........... .E...........SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:16:22.018498 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 5411:5827, ack 2250, win 1432, options [nop,nop,TS val 428022748 ecr 424013747], length 416 E...._@.@.%o ..~ ......p.}.+..Q.....2...... .....E.......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .2.10.2.12.232.3306.3581.... .3.10.2.15.143.3306.3581.......... 18:16:22.058734 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 5827, win 1424, options [nop,nop,TS val 424013790 ecr 428022748], length 0 E..4..@.@... ... ..~.p....Q..}............. .E...... 18:16:32.515320 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2250:2255, ack 5827, win 1424, options [nop,nop,TS val 424024246 ecr 428022748], length 5 E..9..@.@... ... ..~.p....Q..}....... ..... .F........... 18:16:32.515440 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 5827:5838, ack 2255, win 1432, options [nop,nop,TS val 428033245 ecr 424024246], length 11 E..?.`@.@.'. ..~ ......p.}....Q.....0...... ..D..F............. 18:16:32.515606 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 5838, win 1424, options [nop,nop,TS val 424024246 ecr 428033245], length 0 E..4..@.@... ... ..~.p....Q..}............. .F....D. 18:16:32.515648 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2255:2317, ack 5838, win 1424, options [nop,nop,TS val 424024247 ecr 428033245], length 62 E..r..@.@... ... ..~.p....Q..}.......R..... .F....D.:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:16:32.516195 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 5838:5936, ack 2317, win 1432, options [nop,nop,TS val 428033246 ecr 424024247], length 98 E....a@.@.&. ..~ ......p.}....R.....0...... ..D..F.......<....def.system membership membership.status.status.-.........................quorum......... 18:16:32.516401 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2317:2388, ack 5936, win 1424, options [nop,nop,TS val 424024247 ecr 428033246], length 71 E..{..@.@... ... ..~.p....R..}.8........... .F....D.C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:16:32.516800 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 5936:6035, ack 2388, win 1432, options [nop,nop,TS val 428033247 ecr 424024247], length 99 E....b@.@.&. ..~ ......p.}.8..RW....0...... ..D..F.......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:16:32.517033 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2388:2454, ack 6035, win 1424, options [nop,nop,TS val 424024248 ecr 428033247], length 66 E..v..@.@... ... ..~.p....RW.}......V...... .F....D.>....SELECT nid, status, instance, substate FROM system.membership 18:16:32.517455 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 6035:6382, ack 2454, win 1432, options [nop,nop,TS val 428033247 ecr 424024248], length 347 E....c@.@.%. ..~ ......p.}....R.....1...... ..D..F.......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:16:32.517729 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2454:2625, ack 6382, win 1424, options [nop,nop,TS val 424024249 ecr 428033247], length 171 E.....@.@..1 ... ..~.p....R..}............. .F....D......SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:16:32.519753 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 6382:6798, ack 2625, win 1432, options [nop,nop,TS val 428033250 ecr 424024249], length 416 E....d@.@.%j ..~ ......p.}....SD....2...... ..D..F.......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................2.10.2.12.232.3306.3581.... .1.10.2.15.126.3306.3581.... .3.10.2.15.143.3306.3581.......... 18:16:32.559749 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 6798, win 1424, options [nop,nop,TS val 424024291 ecr 428033250], length 0 E..4..@.@... ... ..~.p....SD.}............. .F....D. 18:16:42.916755 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2625:2630, ack 6798, win 1424, options [nop,nop,TS val 424034648 ecr 428033250], length 5 E..9..@.@... ... ..~.p....SD.}......_6..... .FAX..D...... 18:16:42.916877 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 6798:6809, ack 2630, win 1432, options [nop,nop,TS val 428043647 ecr 424034648], length 11 E..?.e@.@.&. ..~ ......p.}....SI....0...... ..m..FAX........... 18:16:42.917046 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 6809, win 1424, options [nop,nop,TS val 424034648 ecr 428043647], length 0 E..4..@.@... ... ..~.p....SI.}......E...... .FAX..m. 18:16:42.917063 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2630:2692, ack 6809, win 1424, options [nop,nop,TS val 424034648 ecr 428043647], length 62 E..r..@.@... ... ..~.p....SI.}......9...... .FAX..m.:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:16:42.917597 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 6809:6907, ack 2692, win 1432, options [nop,nop,TS val 428043648 ecr 424034648], length 98 E....f@.@.&. ..~ ......p.}....S.....0...... ..m..FAX.....<....def.system membership membership.status.status.-.........................quorum......... 18:16:42.917852 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2692:2763, ack 6907, win 1424, options [nop,nop,TS val 424034649 ecr 428043648], length 71 E..{..@.@... ... ..~.p....S..}......~\..... .FAY..m.C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:16:42.918240 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 6907:7006, ack 2763, win 1432, options [nop,nop,TS val 428043648 ecr 424034649], length 99 E....g@.@.&. ..~ ......p.}....S.....0...... ..m..FAY.....H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:16:42.918458 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2763:2829, ack 7006, win 1424, options [nop,nop,TS val 424034649 ecr 428043648], length 66 E..v..@.@... ... ..~.p....S..}.f........... .FAY..m.>....SELECT nid, status, instance, substate FROM system.membership 18:16:42.918877 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 7006:7353, ack 2829, win 1432, options [nop,nop,TS val 428043649 ecr 424034649], length 347 E....h@.@.%. ..~ ......p.}.f..T.....1...... ..m..FAY.....6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:16:42.919114 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 2829:3000, ack 7353, win 1424, options [nop,nop,TS val 424034650 ecr 428043649], length 171 E.....@.@..* ... ..~.p....T..}......W...... .FAZ..m......SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:16:42.921006 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 7353:7769, ack 3000, win 1432, options [nop,nop,TS val 428043651 ecr 424034650], length 416 E....i@.@.%e ..~ ......p.}....T.....2...... ..m..FAZ.....2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .3.10.2.15.143.3306.3581.... .2.10.2.12.232.3306.3581.......... 18:16:42.960721 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 7769, win 1424, options [nop,nop,TS val 424034692 ecr 428043651], length 0 E..4..@.@... ... ..~.p....T..}.a....@4..... .FA...m. 18:16:53.318629 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3000:3005, ack 7769, win 1424, options [nop,nop,TS val 424045049 ecr 428043651], length 5 E..9..@.@... ... ..~.p....T..}.a........... .Fi...m...... 18:16:53.318728 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 7769:7780, ack 3005, win 1432, options [nop,nop,TS val 428054049 ecr 424045049], length 11 E..?.j@.@.&. ..~ ......p.}.a..T.....0...... ...!.Fi............ 18:16:53.318904 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 7780, win 1424, options [nop,nop,TS val 424045050 ecr 428054049], length 0 E..4..@.@... ... ..~.p....T..}.l........... .Fi....! 18:16:53.318917 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3005:3067, ack 7780, win 1424, options [nop,nop,TS val 424045050 ecr 428054049], length 62 E..r..@.@... ... ..~.p....T..}.l.....F..... .Fi....!:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:16:53.319419 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 7780:7878, ack 3067, win 1432, options [nop,nop,TS val 428054049 ecr 424045050], length 98 E....k@.@.&. ..~ ......p.}.l..T.....0...... ...!.Fi......<....def.system membership membership.status.status.-.........................quorum......... 18:16:53.319666 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3067:3138, ack 7878, win 1424, options [nop,nop,TS val 424045050 ecr 428054049], length 71 E..{..@.@... ... ..~.p....T..}......'...... .Fi....!C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:16:53.319992 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 7878:7977, ack 3138, win 1432, options [nop,nop,TS val 428054050 ecr 424045050], length 99 E....l@.@.&. ..~ ......p.}....UE....0...... ...".Fi......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:16:53.320180 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3138:3204, ack 7977, win 1424, options [nop,nop,TS val 424045051 ecr 428054050], length 66 E..v..@.@... ... ..~.p....UE.}.1........... .Fi....">....SELECT nid, status, instance, substate FROM system.membership 18:16:53.320573 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 7977:8324, ack 3204, win 1432, options [nop,nop,TS val 428054051 ecr 424045051], length 347 E....m@.@.%. ..~ ......p.}.1..U.....1...... ...#.Fi......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:16:53.320802 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3204:3375, ack 8324, win 1424, options [nop,nop,TS val 424045052 ecr 428054051], length 171 E.....@.@..# ... ..~.p....U..}.......}..... .Fi....#.....SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:16:53.322732 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 8324:8740, ack 3375, win 1432, options [nop,nop,TS val 428054053 ecr 424045052], length 416 E....n@.@.%` ..~ ......p.}....V2....2...... ...%.Fi......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .3.10.2.15.143.3306.3581.... .2.10.2.12.232.3306.3581.......... 18:16:53.362717 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 8740, win 1424, options [nop,nop,TS val 424045094 ecr 428054053], length 0 E..4..@.@... ... ..~.p....V2.}.,........... .Fj&...% 18:17:03.819647 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3375:3380, ack 8740, win 1424, options [nop,nop,TS val 424055550 ecr 428054053], length 5 E..9..@.@... ... ..~.p....V2.}.,........... .F.....%..... 18:17:03.819768 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 8740:8751, ack 3380, win 1432, options [nop,nop,TS val 428064550 ecr 424055550], length 11 E..?.o@.@.&. ..~ ......p.}.,..V7....0...... ...&.F............. 18:17:03.819969 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 8751, win 1424, options [nop,nop,TS val 424055551 ecr 428064550], length 0 E..4..@.@... ... ..~.p....V7.}.7........... .F.....& 18:17:03.819984 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3380:3442, ack 8751, win 1424, options [nop,nop,TS val 424055551 ecr 428064550], length 62 E..r..@.@... ... ..~.p....V7.}.7........... .F.....&:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:17:03.820535 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 8751:8849, ack 3442, win 1432, options [nop,nop,TS val 428064551 ecr 424055551], length 98 E....p@.@.&. ..~ ......p.}.7..Vu....0...... ...'.F.......<....def.system membership membership.status.status.-.........................quorum......... 18:17:03.820737 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3442:3513, ack 8849, win 1424, options [nop,nop,TS val 424055552 ecr 428064551], length 71 E..{..@.@... ... ..~.p....Vu.}............. .F.....'C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:17:03.821092 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 8849:8948, ack 3513, win 1432, options [nop,nop,TS val 428064551 ecr 424055552], length 99 E....q@.@.&. ..~ ......p.}....V.....0...... ...'.F.......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:17:03.821319 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3513:3579, ack 8948, win 1424, options [nop,nop,TS val 424055552 ecr 428064551], length 66 E..v..@.@... ... ..~.p....V..}......RD..... .F.....'>....SELECT nid, status, instance, substate FROM system.membership 18:17:03.821693 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 8948:9295, ack 3579, win 1432, options [nop,nop,TS val 428064552 ecr 424055552], length 347 E....r@.@.%. ..~ ......p.}....V.....1...... ...(.F.......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:17:03.821945 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3579:3750, ack 9295, win 1424, options [nop,nop,TS val 424055553 ecr 428064552], length 171 E.....@.@... ... ..~.p....V..}.W.....0..... .F.....(.....SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:17:03.823906 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 9295:9711, ack 3750, win 1432, options [nop,nop,TS val 428064554 ecr 424055553], length 416 E....s@.@.%[ ..~ ......p.}.W..W.....2...... ...*.F.......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................1.10.2.15.126.3306.3581.... .2.10.2.12.232.3306.3581.... .3.10.2.15.143.3306.3581.......... 18:17:03.863714 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 9711, win 1424, options [nop,nop,TS val 424055595 ecr 428064554], length 0 E..4..@.@... ... ..~.p....W..}.......a..... .F.+...* 18:17:14.222648 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3750:3755, ack 9711, win 1424, options [nop,nop,TS val 424065953 ecr 428064554], length 5 E..9..@.@... ... ..~.p....W..}......Z...... .F.....*..... 18:17:14.222745 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 9711:9722, ack 3755, win 1432, options [nop,nop,TS val 428074953 ecr 424065953], length 11 E..?.t@.@.&. ..~ ......p.}....W.....0...... .....F............. 18:17:14.222928 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 9722, win 1424, options [nop,nop,TS val 424065954 ecr 428074953], length 0 E..4..@.@... ... ..~.p....W..}......A;..... .F...... 18:17:14.222943 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3755:3817, ack 9722, win 1424, options [nop,nop,TS val 424065954 ecr 428074953], length 62 E..r..@.@... ... ..~.p....W..}......5r..... .F......:....SELECT status FROM system.membership WHERE nid = gtmnid() 18:17:14.223440 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 9722:9820, ack 3817, win 1432, options [nop,nop,TS val 428074953 ecr 424065954], length 98 E....u@.@.&. ..~ ......p.}....W.....0...... .....F.......<....def.system membership membership.status.status.-.........................quorum......... 18:17:14.223723 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3817:3888, ack 9820, win 1424, options [nop,nop,TS val 424065955 ecr 428074953], length 71 E..{..@.@..{ ... ..~.p....W..}.d....z...... .F......C....SELECT nodeid FROM system.softfailed_nodes WHERE nodeid = gtmnid() 18:17:14.224101 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 9820:9919, ack 3888, win 1432, options [nop,nop,TS val 428074954 ecr 424065955], length 99 E....v@.@.&. ..~ ......p.}.d..X3....0...... .....F.......H....def.system.softfailed_nodes.softfailed_nodes.nodeid.nodeid.?......!...................... 18:17:14.224327 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3888:3954, ack 9919, win 1424, options [nop,nop,TS val 424065955 ecr 428074954], length 66 E..v..@.@... ... ..~.p....X3.}............. .F......>....SELECT nid, status, instance, substate FROM system.membership 18:17:14.224658 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 9919:10266, ack 3954, win 1432, options [nop,nop,TS val 428074955 ecr 424065955], length 347 E....w@.@.%. ..~ ......p.}....Xu....1...... .....F.......6....def.system membership membership.nid.nid.?......!....<....def.system membership membership.status.status.-...........@....def.system membership membership.instance.instance.?...... ....@....def.system membership membership.substate.substate.-.........................1.quorum.2.normal.....2.quorum.2.normal... .3.quorum.2.normal... ..... 18:17:14.224883 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [P.], seq 3954:4125, ack 10266, win 1424, options [nop,nop,TS val 424065956 ecr 428074955], length 171 E.....@.@... ... ..~.p....Xu.}."....R...... .F...........SELECT ni.nodeid, ni.iface_ip, ni.mysql_port, ni.healthmon_port, sn.nodeid FROM system.nodeinfo AS ni LEFT JOIN system.softfailed_nodes AS sn ON ni.nodeid = sn.nodeid 18:17:14.226861 IP karma049.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.49008: Flags [P.], seq 10266:10682, ack 4125, win 1432, options [nop,nop,TS val 428074957 ecr 424065956], length 416 E....x@.@.%V ..~ ......p.}."..Y ....2...... .....F.......2....def.system.ni.nodeinfo.nodeid.nodeid.?......!....6....def.system.ni.nodeinfo.iface_ip.iface_ip.-...........:....def.system.ni.nodeinfo mysql_port mysql_port.?...... ....B....def.system.ni.nodeinfo.healthmon_port.healthmon_port.?...... ....:....def.system.sn.softfailed_nodes.nodeid.nodeid.?...... ..................3.10.2.15.143.3306.3581.... .1.10.2.15.126.3306.3581.... .2.10.2.12.232.3306.3581.......... 18:17:14.266710 IP karma075.colo.sproutsys.com.49008 > karma049.colo.sproutsys.com.mysql: Flags [.], ack 10682, win 1424, options [nop,nop,TS val 424065998 ecr 428074957], length 0 E..4..@.@... ... ..~.p....Y .}......;...... .F...... ^C 138 packets captured 152 packets received by filter 0 packets dropped by kernel [root@karma049 ~]# ============================================================ [root@karma054 ~]# tcpdump -i enp5s0f0 port 3306 -A tcpdump: verbose output suppressed, use -v or -vv for full protocol decode listening on enp5s0f0, link-type EN10MB (Ethernet), capture size 262144 bytes 18:16:21.494332 IP karma075.colo.sproutsys.com.57132 > karma054.colo.sproutsys.com.mysql: Flags [S], seq 3759861680, win 29200, options [mss 1460,sackOK,TS val 424013225 ecr 0,nop,wscale 7], length 0 E..<..@.@..= ... ....,............r............ .E.......... 18:16:21.494355 IP karma054.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.57132: Flags [S.], seq 2081635361, ack 3759861681, win 28960, options [mss 1460,sackOK,TS val 427869226 ecr 424013225,nop,wscale 7], length 0 E..<..@.@. V ... ......,|. karma054.colo.sproutsys.com.mysql: Flags [.], ack 1, win 229, options [nop,nop,TS val 424013225 ecr 427869226], length 0 E..4..@.@..D ... ....,......|.<"........... .E.....* 18:16:31.504642 IP karma075.colo.sproutsys.com.57132 > karma054.colo.sproutsys.com.mysql: Flags [F.], seq 1, ack 1, win 229, options [nop,nop,TS val 424023235 ecr 427869226], length 0 E..4..@.@..; ... ....,......|.<"........... .F.....* 18:16:31.504752 IP karma054.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.57132: Flags [F.], seq 1, ack 2, win 227, options [nop,nop,TS val 427879236 ecr 424023235], length 0 E..4..@.@..U ... ......,|.<"........0...... ...D.F.. 18:16:31.504882 IP karma075.colo.sproutsys.com.57132 > karma054.colo.sproutsys.com.mysql: Flags [.], ack 2, win 229, options [nop,nop,TS val 424023236 ecr 427879236], length 0 E..4..@.@..: ... ....,......|.<#........... .F.....D ^C 6 packets captured 13 packets received by filter 0 packets dropped by kernel [root@karma054 ~]# =============================================== [root@karma085 ~]# tcpdump -i enp5s0f0 port 3306 -A tcpdump: verbose output suppressed, use -v or -vv for full protocol decode listening on enp5s0f0, link-type EN10MB (Ethernet), capture size 262144 bytes 18:16:11.483895 IP karma075.colo.sproutsys.com.56028 > karma085.colo.sproutsys.com.mysql: Flags [S], seq 1320601352, win 29200, options [mss 1460,sackOK,TS val 424003215 ecr 0,nop,wscale 7], length 0 E..<..@.@..v ... .......N.........r............ .E.......... 18:16:11.483922 IP karma085.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.56028: Flags [S.], seq 3738952270, ack 1320601353, win 28960, options [mss 1460,sackOK,TS val 427622214 ecr 424003215,nop,wscale 7], length 0 E..<..@.@... ... ..........NN.. ..q -.......... .|.F.E...... 18:16:11.484011 IP karma075.colo.sproutsys.com.56028 > karma085.colo.sproutsys.com.mysql: Flags [.], ack 1, win 229, options [nop,nop,TS val 424003215 ecr 427622214], length 0 E..4..@.@..} ... .......N.. ...O........... .E...|.F 18:16:21.494211 IP karma075.colo.sproutsys.com.56028 > karma085.colo.sproutsys.com.mysql: Flags [F.], seq 1, ack 1, win 229, options [nop,nop,TS val 424013225 ecr 427622214], length 0 E..4..@.@..t ... .......N.. ...O....i...... .E...|.F 18:16:21.494321 IP karma085.colo.sproutsys.com.mysql > karma075.colo.sproutsys.com.56028: Flags [F.], seq 1, ack 2, win 227, options [nop,nop,TS val 427632224 ecr 424013225], length 0 E..4. @.@... ... ..........ON.. ....-...... .}&`.E.. 18:16:21.494405 IP karma075.colo.sproutsys.com.56028 > karma085.colo.sproutsys.com.mysql: Flags [.], ack 2, win 229, options [nop,nop,TS val 424013225 ecr 427632224], length 0 E..4..@.@..s ... .......N.. ...P....B...... .E...}&` ^C 6 packets captured 13 packets received by filter 0 packets dropped by kernel [root@karma085 ~]#