Could not shut down DB

From: Nagy László Zsolt <gandalf(at)shopzeus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Could not shut down DB
Date: 2016-05-30 05:26:43
Message-ID: a08117a1-054f-9fa4-9fc5-469c69bfcda2@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I could stop it with:

pg_ctl stop -i i

but before that:

May 30 07:21:00 appserver postgres[65202]: [5-1] FATAL: the database
system is shutting down
May 30 07:21:00 appserver postgres[65203]: [5-1] FATAL: the database
system is shutting down
May 30 07:21:00 appserver postgres[65206]: [5-1] FATAL: the database
system is shutting down
May 30 07:21:02 appserver postgres[65221]: [5-1] FATAL: the database
system is shutting down
May 30 07:21:03 appserver postgres[65222]: [5-1] FATAL: the database
system is shutting down
May 30 07:21:04 appserver postgres[65223]: [5-1] FATAL: the database
system is shutting down
May 30 07:23:25 appserver postgres[39643]: [7-1] WARNING: terminating
connection because of crash of another server process
May 30 07:23:25 appserver postgres[39643]: [7-2] 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.
May 30 07:23:25 appserver postgres[39643]: [7-3] HINT: In a moment you
should be able to reconnect to the database and repeat your command.
May 30 07:23:25 appserver postgres[39643]: [7-4] CONTEXT: COPY
sdi_manageditems, line 1

It happened in the weekend, and the server log does not contain anything
except these "FATAL: shutting down" messages, so I'm not able to tell
when is started. Any idea what could possible cause this error?

Thanks,

Laci

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Ignatov 2016-05-30 16:29:15 Re: very slow postgresql startup
Previous Message gleeco 2016-05-27 06:21:44 pg_basebackup restore & odd WAL