Could not shut down DB
Could not shut down DB
От:
Nagy László Zsolt <gandalf@shopzeus.com>
Дата:
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
Re: Could not shut down DB
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
=?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= 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