pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Could not shut down DB 2+ messages / 2 participants [nested] [flat]
* Could not shut down DB @ 2016-05-30 05:26 Nagy László Zsolt <gandalf@shopzeus.com> 0 siblings, 1 reply; 2+ messages in thread From: Nagy László Zsolt @ 2016-05-30 05:26 UTC (permalink / raw) To: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Could not shut down DB @ 2016-05-30 16:43 Tom Lane <tgl@sss.pgh.pa.us> parent: Nagy László Zsolt <gandalf@shopzeus.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2016-05-30 16:43 UTC (permalink / raw) To: Nagy László Zsolt <gandalf@shopzeus.com>; +Cc: pgsql-admin =?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= <gandalf@shopzeus.com> writes: > 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 > 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? Well, the default-until-recently "smart" shutdown mode would wait for all existing sessions to finish, while not letting any new ones in. That sure looks like what you have here. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-05-30 16:43 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-05-30 05:26 Could not shut down DB Nagy László Zsolt <gandalf@shopzeus.com> 2016-05-30 16:43 ` Tom Lane <tgl@sss.pgh.pa.us>
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