Re: Server stops responding in every week
От | Andrus Moor |
---|---|
Тема | Re: Server stops responding in every week |
Дата | |
Msg-id | DB6D5351FF1F4141B6D3DEFBE0782752@server обсуждение исходный текст |
Ответ на | Re: Server stops responding in every week (Andy Colson <andy@squeakycode.net>) |
Ответы |
Re: Server stops responding in every week
|
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: