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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Farina 2012-11-02 18:41:55 Re: Synchronous commit not... synchronous?
Previous Message Peter Eisentraut 2012-11-02 18:16:03 Re: Synchronous commit not... synchronous?