Help Center> Data Warehouse Service> Troubleshooting> Database Use> "Connection reset by peer" Is Displayed When a User Executes an SQL Statement
View PDF

"Connection reset by peer" Is Displayed When a User Executes an SQL Statement

Symptom

"Connection reset by peer" is displayed when a user executes an SQL statement.

ERROR:  Failed to read response from Datanodes Detail: Connection reset by peer

Cause Analysis

Network is disconnected due to socket communication errors under heavy network traffic.

Solution

  • Set the following GUC parameters to control the peak value of the network traffic: 
    comm_quota_size = 400
comm_usable_memory = 100
  • After detecting such errors, the database automatically retries the SQL statements. The number of retries is controlled by max_query_retry_times.

Only one SQL statement can be retried excluding error SQL statements in a transaction block.

Parent topic: Database Use