Re: BUG #14246: Postgres crashing frequently

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