On Sat, Feb 22, 2014 at 12:37 AM, Amardeep Kaur <amardeepkaur88@xxxxxxxxx> wrote:
The error isfollowed by
could not receive data from client: Connection reset by peer
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.
Venkata Balaji N
Sr. Database Administrator
Fujitsu Australia
-AmardeepOn Fri, Feb 21, 2014 at 10:20 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:Amardeep Kaur wrote:As has been mentioned, that is too much.
> I am trying to increase the max_connection from 100 to 5000. I modified shared_buffer and changed
> kernel parameters according to
> http://www.postgresql.org/docs/9.2/static/kernel-resources.html#SYSVIPC.
There is also an interesting article on the Wiki:
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
The database does not go into recovery mode just like that.
> 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?
Look into the database log and see if you can find the appropriate messages, then
we can figure out what caused the problem.
Yours,
Laurenz Albe
--Amardeep Kaur8130553685
