Re: Backend message type 0x44 arrived while idle
От | Tsukaeru.net Webmaster |
---|---|
Тема | Re: Backend message type 0x44 arrived while idle |
Дата | |
Msg-id | 00a301c12d5d$96821340$0200a8c0@earl обсуждение исходный текст |
Ответ на | Backend message type 0x44 arrived while idle ("Tsukaeru.net Webmaster" <webmaster@tsukaeru.net>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: