Re: terminating connection because of crash of another server process

From: Fabricio <fabrixio1(at)hotmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: terminating connection because of crash of another server process
Date: 2008-02-15 17:29:45
Message-ID: BLU103-W5670F8037AF1C7039D8CE9FE260@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

the command dmesg show some message about memory or hard disc?
Do you have vm.overcommit_memory=2 in sysctl.conf?

> Date: Wed, 13 Feb 2008 15:41:10 -0600> From: scott(dot)marlowe(at)gmail(dot)com> To: leticia(at)tesla(dot)cujae(dot)edu(dot)cu> Subject: Re: [ADMIN] terminating connection because of crash of another server process> CC: pgsql-admin(at)postgresql(dot)org> > On Feb 13, 2008 2:48 PM, Leticia Larrosa <leticia(at)tesla(dot)cujae(dot)edu(dot)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.> > ---------------------------(end of broadcast)---------------------------> TIP 7: You can help support the PostgreSQL project by donating at> > http://www.postgresql.org/about/donate
_________________________________________________________________
¡Súper premios en nanometrajes subiendo tu video!
http://cine.prodigymsn.com/nanometraje

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Leticia Larrosa 2008-02-15 18:22:31 Re: terminating connection because of crash of another server process
Previous Message Vikram Vincent 2008-02-15 13:26:29 Re: How to re-own db cluster