I think your log files, and the description of your issue provide at
least a decent idea of what is probably happening. Unfortunately
without being able to observe the server when it happens, I think you
are going to have limited success tracking this down.
Proximal causes could be network errors
Peter,
Sometimes per week server stops randomly responding for approx 5 minutes.
User should wait for 5 minutes before server responds.
Other users can work normally at same time.
Sounds very much like a locking issue.
Thank you.
This may be the issue.
Are you doing something like
storing a
On 13 Červenec 2011, 13:34, Andrus wrote:
> 2011-07-11 12:18:35 EEST LOG: unexpected EOF on client connection
> 2011-07-11 12:18:46 EEST LOG: could not receive data from client: No
> connection could be made because the target machine actively refused it.
>
>
> 2011-07-11 12:18:46 EEST LOG: unex
Tomáš and Tony,
thank you.
Have you done some basic monitoring? This typically happens when the
machine does a lot of I/O (swapping, checkpoints, ...) - not sure how this
is logged.
This is dedicated server, used only for PostgreSql.
I filtered windows event logs near this time (12:16) . The
2011/7/13 Andrus :
> Sometimes per week server stops randomly responding for approx 5 minutes.
> User should wait for 5 minutes before server responds.
> Other users can work normally at same time.
Sounds very much like a locking issue. Are you doing something like
storing a frequently updated sy
> Sometimes per week server stops randomly responding for approx 5 minutes.
> User should wait for 5 minutes before server responds.
> Other users can work normally at same time.
So does the whole machine just stop responding, or just the postgresql?
Are those other users using postgresql or some
I think logs may help. Have you checked that?
2011/7/13 Andrus
> Sometimes per week server stops randomly responding for approx 5 minutes.
> User should wait for 5 minutes before server responds.
> Other users can work normally at same time.
>
> Monday this happens at 12:16
> I havent noticed
Sometimes per week server stops randomly responding for approx 5 minutes.
User should wait for 5 minutes before server responds.
Other users can work normally at same time.
Monday this happens at 12:16
I havent noticed anythis special in PostgreSql and windows logs at this
time.
How to fix o
