Re: terminating connection because of crash of another server process

Поиск
Список
Период
Сортировка
От Fabricio
Тема Re: terminating connection because of crash of another server process
Дата
Msg-id BLU103-W5670F8037AF1C7039D8CE9FE260@phx.gbl
обсуждение исходный текст
Ответ на Re: terminating connection because of crash of another server process  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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.marlowe@gmail.com
> To: leticia@tesla.cujae.edu.cu
> Subject: Re: [ADMIN] terminating connection because of crash of another server process
> CC: pgsql-admin@postgresql.org
>
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate



¡Gana X Box, juegos y demás premios con sólo un video! ¡Sube el tuyo aquí!

В списке pgsql-admin по дате отправления:

Предыдущее
От: Vikram Vincent
Дата:
Сообщение: Re: How to re-own db cluster
Следующее
От: "Peter Kovacs"
Дата:
Сообщение: Re: How much space do database objects take up in data files