Accumulating idle processes

Поиск
Список
Период
Сортировка
От Gary Hoffman
Тема Accumulating idle processes
Дата
Msg-id fc.00249f0e0172ac9c3b9aca00edb8008f.172acb8@irpsmail.ucsd.edu
обсуждение исходный текст
Ответы Re: Accumulating idle processes  (Mario Splivalo <mario.splivalo@mobart.hr>)
Список pgsql-admin
I've run PHP and PostgreSQL for quite a while and never seen this problem
before. I think it's new, but maybe I never paid attention to it before.

I am frequently running out of connections to the database. Here's a
snippet of my ps -ax

 1882  ??  S      0:00.07 postgres: postgres cgssd_members [local] idle

 1883  ??  S      0:00.09 postgres: postgres cgssd_members [local] idle

 1884  ??  S      0:00.07 postgres: postgres cgssd_members [local] idle

 1886  ??  S      0:00.14 postgres: postgres cgssd_members [local] idle

 1887  ??  S      0:00.06 postgres: postgres cgssd_members [local] idle

  500 std- S      0:01.14 /usr/local/bin/postmaster -D
/usr/local/pgsql/data
  501 std- S      0:00.02 postgres: stats buffer process

  502 std- S      0:00.21 postgres: stats collector process


As you can see, there are some connections that have come in from PHP on
my web pages and have gone idle. I've never seen these before and
eventually they build up and I get an error connecting from the PHP page
to the database. I can kill -9 one of them, and the other disappear. What
is going on here? Some cleanup process is not working.

I'm running Apache 1.3.33 on Darwin Kernal 7.9.0 (MacOS X 10.3.9) with PHP
4.3.6 and PostgreSQL 7.4.2.

Ideas and suggestions are welcome.

Thanks,
Gary

**************************************************************************
* Gary B. Hoffman, Computing Services Manager  e-mail: ghoffman@ucsd.edu *
* Graduate School of International Relations and Pacific Studies (IR/PS) *
* University of California, San Diego (UCSD)       voice: (858) 534-1989 *
* 9500 Gilman Dr.  MC 0519                           fax: (858) 534-3939 *
* La Jolla, CA 92093-0519 USA                 web: http://irps.ucsd.edu/ *
**************************************************************************





В списке pgsql-admin по дате отправления:

Предыдущее
От: Enzo D'addario
Дата:
Сообщение: triggers
Следующее
От: Mario Splivalo
Дата:
Сообщение: Re: Server Hardware Configuration