From: Nagy László Zsolt <gandalf@shopzeus.com>
To: pgsql-admin@postgresql.org
Subject: Could not shut down DB
Date: Mon, 30 May 2016 07:26:43 +0200
Message-ID: <a08117a1-054f-9fa4-9fc5-469c69bfcda2@shopzeus.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gandalf@shopzeus.com
Subject: Re: Could not shut down DB
In-Reply-To: <a08117a1-054f-9fa4-9fc5-469c69bfcda2@shopzeus.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox