From: | Ronan Lucio <ronanl(at)melim(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Error inserting a lot of records |
Date: | 2002-08-01 17:18:48 |
Message-ID: | 20020801141848.3e57267f.ronanl@melim.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
We have a FreeBSD-4.3 box with Postgresql-7.0.
We also have a program that reads a txt file and
insert the datas into a postgres database.
The system works fine but, many times, when I will
insert a lot of records (about 500 recordes), it gives
me an error and the system only accept to insert many
records again after a vacuum.
When it happen,the python script shows me the follow error:
Traceback (innermost last): File "/usr/local/www/cgi-bin/admin/listalocimp.py", line 172, in ? foundfilme = fclib.query ("select cod, titulo from filme where lower(titpesq) like lower('%%%s%%')" % (linhaseek)) File "fclib.py", line 34, in query _pg.error: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request.
Looking for some thing weird in pgsql.log, I've found this:
Sorry, too many clients already
Sorry, too many clients already
Sorry, too many clients already
Sorry, too many clients already
Sorry, too many clients already
Sorry, too many clients already
Could anyone help me?
Ronan
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-08-01 17:36:19 | Re: Error inserting a lot of records |
Previous Message | Bruce Momjian | 2002-08-01 17:13:51 | Open Source in Government seminar |