Thread: Backend message type 0x44 arrived while idle

Backend message type 0x44 arrived while idle

From
"Tsukaeru.net Webmaster"
Date:
Hi.

My database is giving me trouble. I assume that it is due to a bad record,
but I am unable to select/delete that record. Have checked logs with no
helpful info.

Version 7.0.2 on Cobalt RAQ4.

Can anybody help?

Jason



Re: Backend message type 0x44 arrived while idle

From
"Tsukaeru.net Webmaster"
Date:
----- Original Message -----
From: "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>
To: <pgsql-general@postgresql.org>
Sent: Friday, August 24, 2001 10:33 AM
Subject: [GENERAL] Backend message type 0x44 arrived while idle


> Hi.
>
> My database is giving me trouble. I assume that it is due to a bad record,
> but I am unable to select/delete that record. Have checked logs with no
> helpful info.
>
> Version 7.0.2 on Cobalt RAQ4.
>
> Can anybody help?
>
> Jason
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


Re: Backend message type 0x44 arrived while idle

From
"Tsukaeru.net Webmaster"
Date:
Sorry forgot to send the whole message...

Backend message type 0x44 arrived while idle
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.

Hope someone can help...

Jason

----- Original Message -----
From: "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>
To: <pgsql-general@postgresql.org>
Sent: Friday, August 24, 2001 10:33 AM
Subject: [GENERAL] Backend message type 0x44 arrived while idle


> Hi.
>
> My database is giving me trouble. I assume that it is due to a bad record,
> but I am unable to select/delete that record. Have checked logs with no
> helpful info.
>
> Version 7.0.2 on Cobalt RAQ4.
>
> Can anybody help?
>
> Jason
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


Re: Backend message type 0x44 arrived while idle

From
Tom Lane
Date:
"Tsukaeru.net Webmaster" <webmaster@tsukaeru.net> writes:
> My database is giving me trouble. I assume that it is due to a bad record,
> but I am unable to select/delete that record. Have checked logs with no
> helpful info.

The problem could be at the client side, eg libpq running out of memory.
(Its recovery from this problem is pretty abysmal at the moment :-(.)
Are you selecting a whole lot of data in this query?

            regards, tom lane

Re: Backend message type 0x44 arrived while idle

From
"Tsukaeru.net Webmaster"
Date:
I can actually select just one row as

select  * from table limit 1 offset 270
(anything below 270 is fine)

and the same error pops up. It have heaps of memory available..

Jason

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, August 24, 2001 12:31 PM
Subject: Re: [GENERAL] Backend message type 0x44 arrived while idle


> "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net> writes:
> > My database is giving me trouble. I assume that it is due to a bad
record,
> > but I am unable to select/delete that record. Have checked logs with no
> > helpful info.
>
> The problem could be at the client side, eg libpq running out of memory.
> (Its recovery from this problem is pretty abysmal at the moment :-(.)
> Are you selecting a whole lot of data in this query?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>


Re: Backend message type 0x44 arrived while idle

From
Tom Lane
Date:
"Tsukaeru.net Webmaster" <webmaster@tsukaeru.net> writes:
> I can actually select just one row as
> select  * from table limit 1 offset 270
> (anything below 270 is fine)
> and the same error pops up. It have heaps of memory available..

Hmm.  Okay, my frontend-out-of-memory theory goes down the drain.

It would seem that the 271'st row in your table is corrupt somehow,
but I'm curious to learn just how.  I do not recall any previous
reports of data corruption with exactly this symptom.  Would you be
interested in tracing through the backend with a debugger to figure
out what's going wrong?  Or giving me or another developer access to
your system to do that?

            regards, tom lane

Re: Backend message type 0x44 arrived while idle

From
"Tsukaeru.net Webmaster"
Date:
Ok, have tried this in debug mode and the log shows....

010825.20:54:27.635  [8851] StartTransactionCommand
010825.20:54:27.635  [8851] query: select * from users;
010825.20:54:27.645  [8851] ProcessQuery
Server process (pid 8851) exited with status 11 at Sat Aug 25 20:54:27 2001
Terminating any active server processes...
Server processes were terminated at Sat Aug 25 20:54:27 2001
Reinitializing shared memory and semaphores
010825.20:54:27.885  [8873] DEBUG:  Data Base System is starting up at Sat
Aug 25 20:54:27 2001

Does this help at all?

Regards,

Jason Frisch

----- Original Message -----
From: "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, August 24, 2001 12:58 PM
Subject: Re: [GENERAL] Backend message type 0x44 arrived while idle


> I can actually select just one row as
>
> select  * from table limit 1 offset 270
> (anything below 270 is fine)
>
> and the same error pops up. It have heaps of memory available..
>
> Jason
>
> ----- Original Message -----
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
> To: "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>
> Cc: <pgsql-general@postgresql.org>
> Sent: Friday, August 24, 2001 12:31 PM
> Subject: Re: [GENERAL] Backend message type 0x44 arrived while idle
>
>
> > "Tsukaeru.net Webmaster" <webmaster@tsukaeru.net> writes:
> > > My database is giving me trouble. I assume that it is due to a bad
> record,
> > > but I am unable to select/delete that record. Have checked logs with
no
> > > helpful info.
> >
> > The problem could be at the client side, eg libpq running out of memory.
> > (Its recovery from this problem is pretty abysmal at the moment :-(.)
> > Are you selecting a whole lot of data in this query?
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://www.postgresql.org/search.mpl
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>