Connect without proxy information hangs if "proxy_protocol_networks" is enabled
Bug #1508909 reported by
OrNix
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Borys Belinsky | |||
5.7 |
Triaged
|
Medium
|
Borys Belinsky |
Bug Description
Server version: 5.6.26-74.0-log Percona Server (GPL), Release 74.0, Revision 32f8dfd
2.6.32-
proxy_protocol_
Connects from 192.168.167.70 with proxy information from haproxy work fine. But simple mysql connect from this address (without proxy information) hangs:
192.168.167.70# mysql --host 192.168.167.73 -u wm_ro -p
Enter password:
...
...
And in processlist on server there is something like:
Connect 570935 login unauthen connecting 58:36.942
To post a comment you must log in.
This behavior is necessitated by the protocol: in MySQL protocol, server speaks first; in proxy protocol, client speaks first. Here both parties wait for the other one to send something.
Converting this to doc bug so that this behavior is documented.
Additionally, the connection timeout in such scenario might be too long, see bug 1502411.