pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pqReadData()
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>
  2000-01-23 16:18 ` Re: [SQL] pqReadData... Tom Lane <tgl@sss.pgh.pa.us>
  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 13:44 pqReadData... gav <gav@nlr.ru>
@ 2000-01-23 16:18 ` Tom Lane <tgl@sss.pgh.pa.us>
  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

* pqReadData()
@ 2001-01-06 18:33 Najm Hashmi <najm@mondo-live.com>
  2001-01-05 19:02 ` Re: pqReadData() Tom Lane <tgl@sss.pgh.pa.us>
  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

* Re: pqReadData()
  2001-01-06 18:33 pqReadData() Najm Hashmi <najm@mondo-live.com>
@ 2001-01-05 19:02 ` Tom Lane <tgl@sss.pgh.pa.us>
  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-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