pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpqReadData()
6+ messages / 5 participants
[nested] [flat]
* pqReadData()
@ 1999-09-28 03:52 Haris Susanto <hariss@dnet.net.id>
0 siblings, 0 replies; 6+ messages in thread
From: Haris Susanto @ 1999-09-28 03:52 UTC (permalink / raw)
To: pgsql-sql@hub.org
I have a function, I created it and succeed, I droped it. And when I
want to re-create it without any change, the error message as below :
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible.
Terminating.
Anybody know why it hapened ?
Thanks a lot ! ;)
^ permalink raw reply [nested|flat] 6+ messages in thread
* pqReadData...
@ 2000-01-23 13:44 gav <gav@nlr.ru>
0 siblings, 1 reply; 6+ messages in thread
From: gav @ 2000-01-23 13:44 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-sql
Hi,
I have the database created with the postgresql 6.5.3. I make many
inserts (10-30 thousands) in one of tables in one transaction.
Sometimes I receive the error:
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request
What is it? Is this a bug? Or I do something incorrect? Has anybody
received this message?
Best regards,
Alex
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [SQL] pqReadData...
@ 2000-01-23 16:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: gav <gav@nlr.ru>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2000-01-23 16:18 UTC (permalink / raw)
To: gav <gav@nlr.ru>; +Cc: pgsql-general@postgreSQL.org; pgsql-sql
gav <gav@nlr.ru> writes:
> I have the database created with the postgresql 6.5.3. I make many
> inserts (10-30 thousands) in one of tables in one transaction.
> Sometimes I receive the error:
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request
> What is it? Is this a bug?
It's a bug, but we'll need a lot more info than that to fix it.
For example: what were the last few commands you issued before
the crash? Is there anything in the postmaster log file?
(6.5.* libpq has a bad habit of dropping backend error messages
if the channel is closed immediately after the message arrives.
So if the backend reports a FATAL error and quits, the above is
all you see. But the FATAL message ought to be logged in the
postmaster log file.) Is there a core dump file from the failed
backend? (It'd be in .../data/base/yourdatabasename/core) If
so, can you use gdb to get a backtrace from the core file?
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pqReadData()
@ 2001-01-05 19:02 Tom Lane <tgl@sss.pgh.pa.us>
parent: Najm Hashmi <najm@mondo-live.com>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2001-01-05 19:02 UTC (permalink / raw)
To: Najm Hashmi <najm@mondo-live.com>; +Cc: pgsql-sql
Najm Hashmi <najm@mondo-live.com> writes:
> fliprdb=# update artist set extrinfo='independent' where artist_id=6;
> pqReadData() -- backend closed the channel unexpectedly.
Hmm. Looks like you hit a backend crash :-(. Hard to say more with
only this amount of info. What PG version are you using? What is
the table's declaration? There should be a core file from the backend
crash, in $PGDATA/base/fliprdb/core --- can you get a backtrace from
it with gdb?
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* pqReadData()
@ 2001-01-06 18:33 Najm Hashmi <najm@mondo-live.com>
0 siblings, 1 reply; 6+ messages in thread
From: Najm Hashmi @ 2001-01-06 18:33 UTC (permalink / raw)
To: pgsql-sql
Hi all,
I was trying to simply update single field in one of my tables as given
below:
fliprdb=# update artist set extrinfo='independent' where artist_id=6;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Anyone have idea where the problem is and how it can be fixed?
Thank you all in advance.
Regards.
Najm
^ permalink raw reply [nested|flat] 6+ messages in thread
* PqReadData()
@ 2001-11-19 10:42 Gurudutt <guru@indvalley.com>
0 siblings, 0 replies; 6+ messages in thread
From: Gurudutt @ 2001-11-19 10:42 UTC (permalink / raw)
To: pgsql-sql
Hello ,
Can anybody tell me why we get this error, I get this error sometime
abruptly, from my custom TCP-IP based server, is it problem with DBD::Pg or
Postgres, after a while when the same query is executed once again,
there is no error, strange
---------------------------ERROR MESSAGE-----------------------------
DBD::Pg::st execute failed: pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
-----------------------------------------------------------------
--
Best regards,
Gurudutt mailto:guru@indvalley.com
Life is not fair - get used to it.
Bill Gates
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2001-11-19 10:42 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-28 03:52 pqReadData() Haris Susanto <hariss@dnet.net.id>
2000-01-23 13:44 pqReadData... gav <gav@nlr.ru>
2000-01-23 16:18 ` Re: [SQL] pqReadData... Tom Lane <tgl@sss.pgh.pa.us>
2001-01-06 18:33 pqReadData() Najm Hashmi <najm@mondo-live.com>
2001-01-05 19:02 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-19 10:42 PqReadData() Gurudutt <guru@indvalley.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox