dbTalk Databases Forums  

[BUGS] Killing the backends

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] Killing the backends in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Helvio Hild
 
Posts: n/a

Default [BUGS] Killing the backends - 05-04-2004 , 08:05 AM






SELECT int8in(8);
OVER psql do:
llamados=> SELECT int8in(8);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset:
Failed.
!>



In psql superuser an other terminal:
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared
memory.
I have rolled back the current
transaction and am
going to terminate your database
system connection and exit.
Please reconnect to the
database system and repeat your query.


In other Terminal
BEFORE
:~$ pidof postmaster
15489 15488 15474 338 337 335
AFTER
:~$ pidof postmaster
338 337 335



PC:
i386->Celeron300
Linux->Debian->Kernel 2.2.18
Postgresql->7.2.1-2woody2 -> PostgreSQL 7.2.1 on i686-pc-linux-gnu,
compiled by GCC 2.95.4
BYE

---
[This E-mail scanned for viruses by Declude Virus]


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] Killing the backends - 05-05-2004 , 08:28 AM






Helvio Hild <compulogia (AT) coopcolorado (DOT) com.ar> writes:
Quote:
llamados=> SELECT int8in(8);
server closed the connection unexpectedly
This is fixed as of PG 7.3. It's not fixable in earlier releases
because they don't have a type-safe way of declaring I/O functions.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.