hung back end

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: hung back end
Date: 2001-02-09 06:37:24
Message-ID: Pine.NEB.4.21.0102090034010.22877-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i'm porting some apps from mysql to pgsql and i'm using php4.0.5-cvs with
phplib db classes. i'm starting to see that when ever i load a web page,
it starts a backend. then when i try to reload the page, i get:

---
Warning: Unable to connect to PostgreSQL server: Sorry, too many clients
already in /home/staffs/t/tom/public_html/phpweblog/include/db_pgsql.inc
on line 47
Database error: Link-ID == false, pconnect failed
PostgreSQL Error: 0 ()
Session halted.
---

sure i could increase the # of child processes, but instead i decided to
check why it was doing this. it appears that after a webpage is openned, a
new child process or backend starts. the persistent link doesn't seem to
exist any longer. on the next reload, a new process. but the old one never
disappeared. it'll sit there for hours and days.

# ps ax | grep post
16082 ?? I 0:00.09 postmaster: web mnwork [local] idle (postgres)
16149 ?? I 0:00.08 postmaster: web mnwork [local] idle (postgres)
16236 ?? I 0:00.67 postmaster: web mnwork [local] idle (postgres)
16407 ?? I 0:00.81 postmaster: web mnwork [local] idle (postgres)
16453 ?? I 0:00.57 postmaster: web mnwork [local] idle (postgres)
16519 ?? I 0:00.96 postmaster: web mnwork [local] idle (postgres)
16537 ?? I 0:00.76 postmaster: web mnwork [local] idle (postgres)
16902 ?? I 0:00.71 postmaster: web mnwork [local] idle (postgres)
16917 ?? I 0:00.58 postmaster: web mnwork [local] idle (postgres)
16936 ?? I 0:00.76 postmaster: web mnwork [local] idle (postgres)
16945 ?? I 0:00.91 postmaster: web mnwork [local] idle (postgres)
19854 ?? I 0:00.19 postmaster: web mnwork [local] idle (postgres)
19918 ?? I 0:00.14 postmaster: web mnwork [local] idle (postgres)
19929 ?? I 0:00.14 postmaster: web mnwork [local] idle (postgres)
19952 ?? I 0:00.13 postmaster: web mnwork [local] idle (postgres)
19969 ?? I 0:00.14 postmaster: web mnwork [local] idle (postgres)
20063 ?? I 0:00.34 postmaster: web mnwork [local] idle (postgres)
22681 ?? I 0:00.54 postmaster: web mnwork [local] idle (postgres)
22769 ?? I 0:00.18 postmaster: web mnwork [local] idle (postgres)
17591 p1- IN 77:23.76 postmaster: web mnwork [local] waiting (postgres)
17593 p1- IN 78:37.34 postmaster: web mnwork [local] waiting (postgres)
17595 p1- IN 76:35.68 postmaster: web mnwork [local] waiting (postgres)
26624 p1- SN 76:06.14 postmaster: web mnwork [local] SELECT (postgres)
26626 p1- SN 81:51.65 postmaster: web mnwork [local] SELECT (postgres)
26628 p1- IN 76:03.21 postmaster: web mnwork [local] waiting (postgres)
26630 p1- DN 80:10.06 postmaster: web mnwork [local] SELECT (postgres)
26636 p1- SN 78:51.12 postmaster: web mnwork [local] SELECT (postgres)
26638 p1- IN 77:10.42 postmaster: web mnwork [local] waiting (postgres)
26640 p1- RN 83:42.56 postmaster: web mnwork [local] SELECT (postgres)
26643 p1- SN 92:37.74 postmaster: web mnwork [local] SELECT (postgres)
27481 p1- I 0:05.57 /usr/local/bin/postmaster -D /var/pgsql/data
(postgres)
27694 p1- SN 82:09.49 postmaster: web mnwork [local] SELECT (postgres)
27697 p1- DN 76:27.96 postmaster: web mnwork [local] SELECT (postgres)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Poul L. Christiansen 2001-02-09 06:49:11 Re: TOAST
Previous Message Thomas T. Thai 2001-02-09 06:24:00 Returned mail: see transcript for details (fwd)