Skip site navigation (1) Skip section navigation (2)

Unresolved error 0xC0000409 on Windows Server

From: Matthew Gerber <gerber(dot)matthew(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Unresolved error 0xC0000409 on Windows Server
Date: 2012-11-02 18:25:33
Message-ID: CAOcpbfqPLwLq_0BBT4srkbUZZ5kp52_qeeAeqE0UiTh58045_Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello,

I am encountering an error on my Postgres installation for Windows Server
64-bit. The error was posted
here<http://archives.postgresql.org/pgsql-bugs/2012-09/msg00014.php>a
couple months ago; however, no solution was found on the pgsql-bugs
list,
so I am reposting it to pgsql-hackers in the hopes that someone will be
able to help. My error message is identical to the one previously posted:

2012-11-01 22:36:26 EDT LOG:  00000: server process (PID 7060) was
terminated by exception 0xC0000409
2012-11-01 22:36:26 EDT DETAIL:  Failed process was running: INSERT
INTO *[snipped
SQL command]*
2012-11-01 22:36:26 EDT HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2012-11-01 22:36:26 EDT LOCATION:  LogChildExit,
src\backend\postmaster\postmaster.c:2884
2012-11-01 22:36:26 EDT LOG:  00000: terminating any other active server
processes
2012-11-01 22:36:26 EDT LOCATION:  HandleChildCrash,
src\backend\postmaster\postmaster.c:2682
2012-11-01 22:36:26 EDT WARNING:  57P00: terminating connection because of
crash of another server process
2012-11-01 22:36:26 EDT 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.
2012-11-01 22:36:26 EDT HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2012-11-01 22:36:26 EDT LOCATION:  quickdie,
src\backend\tcop\postgres.c:2556
2012-11-01 22:36:26 EDT LOG:  00000: all server processes terminated;
reinitializing
2012-11-01 22:36:26 EDT LOCATION:  PostmasterStateMachine,
src\backend\postmaster\postmaster.c:3135
2012-11-01 22:36:36 EDT FATAL:  XX000: pre-existing shared memory block is
still in use
2012-11-01 22:36:36 EDT HINT:  Check if there are any old server processes
still running, and terminate them.
2012-11-01 22:36:36 EDT LOCATION:  PGSharedMemoryCreate,
src\backend\port\win32_shmem.c:194

The error happens regularly while performing database INSERTS. The [snipped
SQL command] part above contains the INSERT command that was executing when
the server crashed. After restarting the server the command executes fine,
so it's not a problem with the command. I installed Postgres from the
standard Windows binary "postgresql-9.2.1-1-windows-x64.exe" and I have not
changed any configuration settings from their default values.

Does anyone know what might be happening and how I might fix it?

Thanks,
Matt

Responses

pgsql-hackers by date

Next:From: Daniel FarinaDate: 2012-11-02 18:41:55
Subject: Re: Synchronous commit not... synchronous?
Previous:From: Peter EisentrautDate: 2012-11-02 18:16:03
Subject: Re: Synchronous commit not... synchronous?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group