DomainKey-Signature: a=rsa-sha1; s=MDaemon; d=tesla.cujae.edu.cu;
	c=simple; q=dns; h=from:message-id;
	b=DZjLpRfv6ZdRAKfnDuixzsPfEmgjOihjmxPXPrk8kcZNmehPx6b6t1+jZ5Eg
	lMS0nstF042OY9bbe7hyurWqTdt8U+lJys3DIn9xyGrFfnUtyZuNbWHx5
	+plCdMQGyMGKqzrCKE4K+BfM+nnI+/Ll9BXLTTWxPKsFXdWwRaoYDE=;
From: "Leticia Larrosa" <leticia@tesla.cujae.edu.cu>
To: "'Scott Marlowe'" <scott.marlowe@gmail.com>
Cc: <pgsql-admin@postgresql.org>
References: <046e01c86e81$d9d79540$8d86bfc0$@cujae.edu.cu>
	<dcc563d10802131341t53c89e8fwf922cb26b826c03f@mail.gmail.com>
In-Reply-To: <dcc563d10802131341t53c89e8fwf922cb26b826c03f@mail.gmail.com>
Subject: Re: terminating connection because of crash of another server process
Date: Fri, 15 Feb 2008 13:22:31 -0500
Message-ID: <00ab01c86fff$bba38aa0$32ea9fe0$@cujae.edu.cu>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AchuiSuIrninW7qrRGCGdMB+4HGv1gBdeZPg
Content-Language: en-us

Hello,

Thanks Scott. 
I dump my database, and move it to other machine, and all works fine now.

Regards
Leticia Larrosa

-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com] 
Sent: Wednesday, February 13, 2008 4:41 PM
To: Leticia Larrosa
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] terminating connection because of crash of another
server process

On Feb 13, 2008 2:48 PM, Leticia 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
> its.
> But now, doing any actions in the database 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 server process to roll back the
> 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
> repeat your command.
> 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: Succeeded.
> """
>
> Any help, to solve this or an idea about anything 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:  database system was not properly shut down; automatic recovery in
> progress
> LOG:  record with zero length at 1C/837496E4
> LOG:  redo is not required
> LOG:  database system is ready
> 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, mkay?  basically it means the postgres process is
crashing.  It could be crashing because of a corrupted / 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, confirm the pg
binaries aren't corrupted, and test your hardware.


__________ NOD32 2872 (20080213) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com


__________________________________________

Participe en Universidad 2008.
11 al 15 de febrero del 2008.
Palacio de las Convenciones, Ciudad de la Habana, Cuba
http://www.universidad2008.cu