Re: Backend message type 0x44 arrived while idle

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
>