Race Condition Issue in PostgreSQL SSL Connection Process

Bắt đầu trong lib/connection.js và theo dõi cách stream.connect(), sự kiện TCP 'connect', requestSsl() và listener 'data' của stream phối hợp với nhau trong quá trình kết nối PostgreSQL thông qua RDS Proxy. Nếu có thể, hãy tái hiện hiện tượng ngắt kết nối TLS không liên tục và so sánh với một kết nối PostgreSQL trực tiếp. Hoàn tất có nghĩa là xác nhận hoặc bác bỏ giả thuyết về điều kiện tranh chấp, đồng thời ghi lại một biện pháp giảm thiểu hoặc bản sửa lỗi cụ thể.

I have been encountering "Error: Client network socket disconnected before secure TLS connection was established" errors recently without any specific cause when connecting to PostgreSQL through RDS Proxy. These errors occur intermittently, making them difficult to reproduce consistently.
After examining the code in the pg module's lib/connection.js file, I suspect there is a race condition issue between the TCP connection and TLS connection process. The architecture of the connection flow appears problematic:

• Client initiates TCP connection (stream.connect(port, host))
• When TCP connection succeeds, a 'connect' event is emitted
• However, the code for SSL/TLS connection is not directly linked to the 'connect' event
• Instead, logic to wait for the server's SSL support response is set up separately (stream.once('data', function (buffer) {...})

This design creates potential timing issues because:

• There's no explicit synchronization between the TCP connection establishment and when requestSsl() is called
• The SSL handshake process depends on event listeners that operate asynchronously
• When working with RDS Proxy as an intermediary layer, these timing sensitivities may become more problematic

I've verified this by testing direct connections to PostgreSQL without RDS Proxy, which work consistently. The issue only manifests when connecting through the proxy layer.
Please check if my understanding of this potential race condition is correct, and if there are any recommended approaches to mitigate this issue.