The error is could not receive data from client: Connection reset by peer
followed by incomplete startup packet
True. As mentioned up the thread, this does not mean that the database is in the recovery mode. If the database is in recovery mode, you would see a straight forward message in the logs saying that the "database is in recovery mode".
Please help us know how the connections or requests are sent to database from Application. Is there anything you could see in Application/client site logs ?
Things to be identified : If there are any unexpected connection drops/hangs ? do you see any unexpected load spike on DB server ? Network level issues etc.
> When i stress test it with 500 concurrent request, then after 150 - 160 concurrent connections my > database enters into recovery mode and it fails the request. For my stress test i am trying to get > data from one table. > > Do you guys have any idea what is causing the problem or if i am missing some other configuration?
The database does not go into recovery mode just like that. Look into the database log and see if you can find the appropriate messages, then we can figure out what caused the problem.