Re: Server stops responding in every week

Andy,

> Then answer these questions:
>
> Does ram using increase over the week?

Server was re-started yesterday and there was little use after restart.
server is idle. Task Manager shows now

PF Usage 1.22 GB

Physical Memory (K)
Total 4191872
Avail 348xxxx (last 4 vary)
System cache 35676xx (last 2 vary)

How to check for memory increase over week ?

> Do you see "Idle in transaction" (probably in task manager)?

Task Manager shows only image name.
Where I should see this ?

> Show us:
>   select * from pg_stat_activity;

I ran it from pgadmin. It shows now :

11874;"postgres";212;10;"postgres";"";"127.0.0.1";1183;"2011-01-22
21:24:51.343+02";"";"2011-01-22 21:24:51.5+02";f;"<IDLE>"
45923;"mydb";3080;10;"postgres";"";"127.0.0.1";1184;"2011-01-22
21:24:55.25+02";"";"2011-01-22 21:24:55.281+02";f;"<IDLE>"
45923;"mydb";4732;10;"postgres";"";"127.0.0.1";1185;"2011-01-22
21:24:57.156+02";"2011-01-22 21:25:24.109+02";"2011-01-22
21:25:24.109+02";f;"

I will try to run it on next crash if users will not restart server before.

> and
>   select * from pg_locks;

I ran it from pgadmin. It shows now :

"relation";45923;10985;;;"";;;;;"4/241";4732;"AccessShareLock";t
"virtualxid";;;;;"4/241";;;;;"4/241";4732;"ExclusiveLock";t

I will try to run it on next crash if users will not restart server before.


> A little practice up front might help.  When the system is broke, you can
> interrogate it to see what its doing.  Hopefully we'll see something
> locked, and a bunch of things waiting.

Users can restart server without contacting me. For this reason I
asked for automated dump.

Andrus.