Re: BUG #14246: Postgres crashing frequently

On Wed, Jul 13, 2016 at 3:29 AM, <amal(at)guerrillamail(dot)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