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
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 |