Re: BUG #14246: Postgres crashing frequently

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: BUG #14246: Postgres crashing frequently
Дата
Msg-id CACjxUsO3BMSi7cRnHgxVrnRax-e_NExC_AN0rodQr-HXwEDBDQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14246: Postgres crashing frequently  (amal@guerrillamail.com)
Ответы Re: BUG #14246: Postgres crashing frequently  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
On Wed, Jul 13, 2016 at 3:29 AM,  <amal@guerrillamail.com> wrote:

> PostgreSQL version: 9.4.2

Please update to the latest minor release of 9.4.

https://www.postgresql.org/support/versioning/

> WARNING:  worker took too long to start; canceled
> LOG:  server process (PID 123713) was terminated by exception 0xC0000142
> HINT:  See C include file "ntstatus.h" for a description of the hexadecimal
> value.

What do you see in ntstatus.h for exception 0xC0000142?

> FATAL:  the database system is starting up
> FATAL:  the database system is starting up
> FATAL:  the database system is starting up
> FATAL:  the database system is starting up

These are just logging connection attempts before the service is ready.

> LOG:  database system is ready to accept connections
> LOG:  autovacuum launcher started
> ERROR:  database "finance" already exists
> STATEMENT:  CREATE DATABASE "finance"
> LOG:  received fast shutdown request

Who issued that?  Why?

> FATAL:  pre-existing shared memory block is still in use
> HINT:  Check if there are any old server processes still running, and
> terminate them.

I seem to remember a fix related to this in a minor release.

If you update PostgreSQL, and maybe reboot Windows, and still see
problems, please refer to this page and provide additional
information:

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14249: In FDW, variable not found in subplan target list
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #14250: Error in subquery fails silently and parent query continues to execute