Hi,
>-----Original Message-----
>From: Willy Tarreau [mailto:[email protected]]
>Sent: Friday, June 14, 2013 5:53 PM
>To: Jayadevan M
>Cc: Jayadevan M; [email protected]
>Subject: Re: haproxy mysql-check
>
>On Fri, Jun 14, 2013 at 10:30:14AM +0000, Jayadevan M wrote:
>> Telnet works -
>> -bash-3.00# telnet 192.168.8.37 3406
>> Trying 192.168.8.37...
>> Connected to 192.168.8.37.
>> Escape character is '^]'.
>> B
>> 5.1.34-community-logÂBjon[]Ax<`OI_&<;Qg3^CConnection to 192.168.8.37
>closed by foreign host.
>
>OK. Could you show us the complete strace output from haproxy, from the
>connect() call to the close() call ? Ideally if you could take it with strace
>-ttT, it
>would be nice as we'd also have the timings.
>It is possible that we're simply facing a bug in the timeout handling for
>example.
Here is the output. 192.168.2.27 (MySQL on linux) works. 192.168.8.37 (MySQL on
Windows) does not.
10:25:57.474629 connect(5, {sa_family=AF_INET, sin_port=htons(3306),
sin_addr=inet_addr("192.168.2.27")}, 16) = -1 EINPROGRESS (Operation now in
progress) <0.000202>
10:25:57.475000 sendto(5, "\16\0\0\1\0\200\0\0\1haproxy\0\0\1\0\0\0\1", 23,
MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = 23 <0.000099>
10:25:57.475259 epoll_wait(3, {}, 6, 0) = 0 <0.000084>
10:25:57.475488 recvfrom(5,
"4\0\0\0\n5.1.52\0\253\27\0\0lUC0d,Jn\0\377\367!\2\0\0\0\0\0\0\0\0\0\0\0\0\0\0mWKTA,VKVNe3\0\3\0\0\2\0\0\0",
16384, 0, NULL, NULL) = 63 <0.000071>
10:25:57.475691 recvfrom(5, "", 16321, 0, NULL, NULL) = 0 <0.000050>
10:25:57.475824 shutdown(5, 2 /* send and receive */) = 0 <0.000063>
10:25:57.475943 epoll_wait(3, {}, 6, 0) = 0 <0.000027>
10:25:57.476021 close(5) = 0 <0.000019>
10:25:57.476075 epoll_wait(3, {}, 5, 1000) = 0 <0.999944>
10:25:58.476230 epoll_wait(3, {}, 5, 1000) = 0 <0.999819>
10:25:59.476230 epoll_wait(3, {}, 5, 507) = 0 <0.506766>
10:25:59.983158 epoll_wait(3, {}, 5, 2) = 0 <0.001827>
10:25:59.985133 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 5 <0.000101>
10:25:59.985375 fcntl(5, F_SETFL, O_RDONLY|O_NONBLOCK) = 0 <0.000083>
10:25:59.985609 setsockopt(5, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000083>
10:25:59.985838 connect(5, {sa_family=AF_INET, sin_port=htons(3406),
sin_addr=inet_addr("192.168.8.37")}, 16) = -1 EINPROGRESS (Operation now in
progress) <0.000102>
10:25:59.986031 sendto(5, "\16\0\0\1\0\200\0\0\1haproxy\0\0\1\0\0\0\1", 23,
MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = -1 EAGAIN (Resource temporarily
unavailable) <0.000014>
10:25:59.986110 epoll_ctl(3, EPOLL_CTL_ADD, 5, {EPOLLOUT, {u32=5, u64=5}}) = 0
<0.000063>
10:25:59.986250 epoll_wait(3, {{EPOLLOUT, {u32=5, u64=5}}}, 6, 1000) = 1
<0.000173>
10:25:59.986487 sendto(5, "\16\0\0\1\0\200\0\0\1haproxy\0\0\1\0\0\0\1", 23,
MSG_DONTWAIT|MSG_NOSIGNAL, NULL, 0) = 23 <0.000038>
10:25:59.986609 recvfrom(5, 0x1e92770, 16384, 0, 0, 0) = -1 EAGAIN (Resource
temporarily unavailable) <0.000066>
10:25:59.986778 epoll_ctl(3, EPOLL_CTL_MOD, 5, {EPOLLIN, {u32=5, u64=5}}) = 0
<0.000064>
10:25:59.986929 epoll_wait(3, {{EPOLLIN, {u32=5, u64=5}}}, 6, 1000) = 1
<0.000397>
10:25:59.987373 recvfrom(5,
"B\0\0\0\n5.1.34-community-log\0\20\0\0\0?)L&t9]I\0\377\367\10\2\0\0\0\0\0\0\0\0\0\0\0\0\0\0007uj4an%h`*M%\0\3\0\0\2\0\0\0",
16384, 0, NULL, NULL) = 77 <0.000015>
10:25:59.987440 recvfrom(5, "", 16307, 0, NULL, NULL) = 0 <0.000029>
10:25:59.987508 shutdown(5, 2 /* send and receive */) = 0 <0.000016>
10:25:59.987560 close(5) = 0 <0.000030>
10:25:59.987625 epoll_wait(3, {}, 5, 1000) = 0 <0.999548>
10:26:00.987263 epoll_wait(3, {}, 5, 1000) = 0 <0.999853>
10:26:01.987288 epoll_wait(3, {}, 5, 488) = 0 <0.488027>
10:26:02.476277 socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 5 <0.000096>
10:26:02.476452 fcntl(5, F_SETFL, O_RDONLY|O_NONBLOCK) = 0 <0.000011>
10:26:02.476511 setsockopt(5, SOL_TCP, TCP_NODELAY, [1], 4) = 0 <0.000012>
10:26:02.476563 connect(5, {sa_family=AF_INET, sin_port=htons(3306),
sin_addr=inet_addr("192.168.2.27")}, 16) = -1 EINPROGRESS (Operation now in
progress) <0.000166>
Connect from command line -
[root@n3170 ~]# mysql -h 192.168.8.37 --port=3406 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 74
Server version: 5.1.34-community-log MySQL Community Server (GPL)
Regards,
Jayadevan
DISCLAIMER: "The information in this e-mail and any attachment is intended only
for the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly contact
the sender and destroy all copies of the original communication. IBS makes no
warranty, express or implied, nor guarantees the accuracy, adequacy or
completeness of the information contained in this email or any attachment and
is not liable for any errors, defects, omissions, viruses or for resultant loss
or damage, if any, direct or indirect."
