[imp] IMP/Postgresql extrange problem

Federico Petronio petronio@agro.uba.ar
Wed, 21 Aug 2002 09:45:37 -0300


Hello to all:

I use IMP from version 2.0.x. At the moment I have installed version 
2.2.8 with postgresql as database for the "contacts" and sessions. For 
days I have been having the following problem:

IMP screen claims:
"sorry too many clients already"

I known what this means, and it's a postgres matter. But, when I look a 
little deeper I found LOT of this (ps -xa | grep post):

19295 pts/0    S      0:00 /usr/bin/postmaster -D /var/lib/pgsql/data -i 
-B 128
19304 pts/0    S      0:00 postgres: imp_user imp 10.1.1.3 idle
19306 pts/0    D      0:01 postgres: imp_user imp 10.1.1.3 DELETE
19346 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19347 pts/0    S      0:01 postgres: imp_user imp 10.1.1.4 DELETE
19348 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19349 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19350 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19361 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 idle
19379 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 idle
19385 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 idle
19412 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 idle
19418 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19419 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19420 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19421 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19422 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 DELETEwaiting
19446 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 idle
19465 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 idle
19475 pts/0    S      0:00 postgres: imp_user imp 10.1.1.4 idle
19480 pts/0    S      0:00 postgres: imp_user imp 10.1.1.3 idle


10.1.1.4 is the server which have the problem. 10.1.1.3 is a temporal 
server until I find a solution. Both run RH7.2, updated, the same php 
(4.0.6-15) and apache (1.3.22-6). The Postgresql (7.1.3-2) backend is 
always in 10.1.1.4.

I don't understand why everything works fine if I use 10.1.1.3 as the 
web server and 10.1.1.4 as the backend, but the problem appears if I set 
both (web and backend) in 10.1.1.4.

Can it be a matter of insufficient hardware ? Too much work for 10.1.1.4 
when Web and backend are together?

10.1.1.4: Pentium III 550 Mhz, 256Mb RAM, 1 UW-SCSI-2 (almost all the SO 
is here) and 1 IDE HD (with little use). This is a dedicated server, no 
X system.

10.1.1.3: AMD Athlon XP 1500, 1Gb RAM, 1 UW-SCSI-2 and 1 IDE. This is my 
personal PC, with X, netscape, squeak running simulations, etc,etc,etc.

I don't really know about "how much IMP is use" but, if I look in the 
apache log, I found from 3 to 10 lines per second.

An extra note: I have to change the line:

	return (($db = pg_connect($dbconnectstring))) ;
for
	return (($db = pg_pconnect($dbconnectstring))) ;

in horde/imp/lib/db.psgl because strange problems appears with the first 
version of IMP that make the change.

I hope you can help me. Any idea or suggestion is welcome.

Thanks, and sorry about my bad english...
-- 
					Federico Petronio
					petronio@agro.uba.ar
					Linux User #129974

---
Unix IS user friendly. It's just selective about who its friends are.