Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 升级后透传失效
[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version] tidb v6.5.0
[Reproduction Path] Operations performed that led to the issue
Upgraded from tidb v5.4.3 to v6.5.0
[Encountered Issue: Phenomenon and Impact]
Before the upgrade, the application server connected normally.
After the upgrade, the application connection failed, as shown in the screenshot:
Upon investigation, it was found that the error’s connection IP is the IP of the HAProxy server, not the application server’s IP.
Before the upgrade, due to pass-through, TiDB recognized the IPs of the application servers, and since the application servers were already authorized, there were no connection issues.
After the upgrade, the connection error indicates that the IPs are from HAProxy, suggesting an issue with pass-through.
Manually granting permissions to the HAProxy server’s IP in the TiDB cluster resolved the connection issue.
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]