Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3FB842E005B for ; Fri, 15 Feb 2008 13:29:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 98673-04 for ; Fri, 15 Feb 2008 13:29:46 -0400 (AST) Received: from blu139-omc1-s9.blu139.hotmail.com (blu139-omc1-s9.blu139.hotmail.com [65.55.175.149]) by postgresql.org (Postfix) with ESMTP id 568952E0037 for ; Fri, 15 Feb 2008 13:29:47 -0400 (AST) Received: from BLU103-W56 ([65.55.162.181]) by blu139-omc1-s9.blu139.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Fri, 15 Feb 2008 09:29:46 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_eaf97145-0180-40f6-a69d-cac2b52b796e_" X-Originating-IP: [201.144.221.247] From: Fabricio To: Subject: Re: terminating connection because of crash of another server process Date: Fri, 15 Feb 2008 17:29:45 +0000 Importance: Normal In-Reply-To: References: <046e01c86e81$d9d79540$8d86bfc0$@cujae.edu.cu> MIME-Version: 1.0 X-OriginalArrivalTime: 15 Feb 2008 17:29:46.0004 (UTC) FILETIME=[5BA2FD40:01C86FF8] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/178 X-Sequence-Number: 28252 --_eaf97145-0180-40f6-a69d-cac2b52b796e_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable the command dmesg show some message about memory or hard disc? Do you have vm.overcommit_memory=3D2 in sysctl.conf? =20 > Date: Wed, 13 Feb 2008 15:41:10 -0600> From: scott.marlowe@gmail.com> To:= leticia@tesla.cujae.edu.cu> Subject: Re: [ADMIN] terminating connection be= cause of crash of another server process> CC: pgsql-admin@postgresql.org> >= On Feb 13, 2008 2:48 PM, Leticia Larrosa wrot= e:> >> > Hello> >> > I have a postgres database version 8.1.11, in an Ubunt= u Server 6.10.> >> > Some days before, I have a hardware failure in my serv= er, and after recover> > the database I get some problems with tables and I= had to REINDEX some of> > its.> > But now, doing any actions in the databa= se server (for example: SELECT *> > from my_table), I continue getting the = follow error:> >> > """> > WARNING: terminating connection because of crash= of another server process> > DETAIL: The postmaster has commanded this ser= ver process to roll back the> > current transaction and exit, because anoth= er server process exited> > abnormally and possibly corrupted shared memory= .> > HINT: In a moment you should be able to reconnect to the database and>= > repeat your command.> > server closed the connection unexpectedly> > Thi= s probably means the server terminated abnormally> > before or while proces= sing the request.> > The connection to the server was lost. Attempting rese= t: Succeeded.> > """> >> > Any help, to solve this or an idea about anythin= g I must check, will be> > appreciated.> >> > The log of my server shows th= e follow messages over and over:> >> > LOG: database system was interrupted= at 2008-02-13 15:37:00 EST> > LOG: checkpoint record is at 1C/837496A0> > = LOG: redo record is at 1C/837496A0; undo record is at 0/0; shutdown TRUE> >= LOG: next transaction ID: 1596704648; next OID: 2939703> > LOG: next Multi= XactId: 1; next MultiXactOffset: 0> > LOG: database system was not properly= shut down; automatic recovery in> > progress> > LOG: record with zero leng= th at 1C/837496E4> > LOG: redo is not required> > LOG: database system is r= eady> > LOG: transaction ID wrap limit is 2147484146, limited by database> = > "postgres"> > LOG: server process (PID 9747) was terminated by signal 11>= > LOG: terminating any other active server processes> > Sig 11 is bad, mka= y? basically it means the postgres process is> crashing. It could be crashi= ng because of a corrupted / buggy> executable, or bad hardware. Do you have= another machine you trust to> move your pgsql database to? Because I would= n't trust the one it's> on right now until you can pull it from service, co= nfirm the pg> binaries aren't corrupted, and test your hardware.> > -------= --------------------(end of broadcast)---------------------------> TIP 7: Y= ou can help support the PostgreSQL project by donating at> > http://www.pos= tgresql.org/about/donate _________________________________________________________________ =A1S=FAper premios en nanometrajes subiendo tu video! http://cine.prodigymsn.com/nanometraje= --_eaf97145-0180-40f6-a69d-cac2b52b796e_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
the   command dmesg show some messa= ge about memory or hard disc?
Do you have vm.overcommit_memory=3D2 in sysctl.conf?  



> Date: Wed, 13 Feb 2008 15:41:10 -0600
> From: scott.marlowe@gmai= l.com
> To: leticia@tesla.cujae.edu.cu
> Subject: Re: [ADMIN] t= erminating connection because of crash of another server process
> CC= : pgsql-admin@postgresql.org
>
> On Feb 13, 2008 2:48 PM, Leti= cia Larrosa <leticia@tesla.cujae.edu.cu> wrote:
> >
> = > Hello
> >
> > I have a postgres database version 8.1= .11, in an Ubuntu Server 6.10.
> >
> > Some days before, = I have a hardware failure in my server, and after recover
> > the = database I get some problems with tables and I had to REINDEX some of
&g= t; > its.
> > But now, doing any actions in the database server= (for example: SELECT *
> > from my_table), I continue getting the= follow error:
> >
> > """
> > WARNING: terminat= ing connection because of crash of another server process
> > DETA= IL: The postmaster has commanded this server process to roll back the
&g= t; > current transaction and exit, because another server process exited=
> > abnormally and possibly corrupted shared memory.
> >= HINT: In a moment you should be able to reconnect to the database and
&= gt; > repeat your command.
> > server closed the connection une= xpectedly
> > This probably means the server terminated abnormally=
> > before or while processing the request.
> > The conn= ection to the server was lost. Attempting reset: Succeeded.
> > ""= "
> >
> > Any help, to solve this or an idea about anythi= ng I must check, will be
> > appreciated.
> >
> >= ; The log of my server shows the follow messages over and over:
> >= ;
> > LOG: database system was interrupted at 2008-02-13 15:37:00 = EST
> > LOG: checkpoint record is at 1C/837496A0
> > LOG:= redo record is at 1C/837496A0; undo record is at 0/0; shutdown TRUE
>= ; > LOG: next transaction ID: 1596704648; next OID: 2939703
> >= LOG: next MultiXactId: 1; next MultiXactOffset: 0
> > LOG: databa= se system was not properly shut down; automatic recovery in
> > pr= ogress
> > LOG: record with zero length at 1C/837496E4
> >= ; LOG: redo is not required
> > LOG: database system is ready
&= gt; > LOG: transaction ID wrap limit is 2147484146, limited by database<= BR>> > "postgres"
> > LOG: server process (PID 9747) was ter= minated by signal 11
> > LOG: terminating any other active server = processes
>
> Sig 11 is bad, mkay? basically it means the post= gres process is
> crashing. It could be crashing because of a corrupt= ed / buggy
> executable, or bad hardware. Do you have another machine= you trust to
> move your pgsql database to? Because I wouldn't trust= the one it's
> on right now until you can pull it from service, conf= irm the pg
> binaries aren't corrupted, and test your hardware.
&g= t;
> ---------------------------(end of broadcast)------------------= ---------
> TIP 7: You can help support the PostgreSQL project by don= ating at
>
> http://www.postgresql.org/about/donate

=A1Gana X Box, juegos y dem=E1s premios con s=F3lo un video! =A1Sube el tu= yo aqu=ED! = --_eaf97145-0180-40f6-a69d-cac2b52b796e_--