Re: BUG #7517: terminated by exception 0xC0000409 - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #7517: terminated by exception 0xC0000409
Date
Msg-id CABUevEw9e9WhFmLQNtTmqdJwJFYQccS14bk5K8m-0j83e1iZJA@mail.gmail.com
Whole thread Raw
In response to BUG #7517: terminated by exception 0xC0000409  (katsuhito.habaguchi@fujixerox.co.jp)
Responses Re: BUG #7517: terminated by exception 0xC0000409  (fx HABAGUCHI KATSUHITO <katsuhito.habaguchi@fujixerox.co.jp>)
List pgsql-bugs
On Tue, Sep 4, 2012 at 3:00 AM,  <katsuhito.habaguchi@fujixerox.co.jp> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      7517
> Logged by:          Katsuhito Habaguchi
> Email address:      katsuhito.habaguchi@fujixerox.co.jp
> PostgreSQL version: 8.3.20
> Operating system:   Windows Server 2008 R2
> Description:
>
> I'm Katsuhito Habaguchi. I'm working for Fuji Xerox Co,Ltd.
> In our server, PostgreSQL service stopped by the following error message.
>
> -----------------------------------------------------
> LOG:  server process (PID 1124) was terminated by exception 0xC0000409
> HINT:  See C include file "ntstatus.h" for a description of the hexadecimal
> value.
> LOG:  terminating any other active server processes
> WARNING:  terminating connection because of crash of another server process
> 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.
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command.
> LOG:  all server processes terminated; reinitializing
> -----------------------------------------------------

Interesting - 0xC0000409 means STACK_BUFFER_OVERRUN... The only case
I've seen that happen on connection startup is, as usual, with broken
antivirus/antispyware on the machine. If you have any such product
installed, try uninstalling it (not just disabling it) and see if the
problem goes away.


> OS: Windows Server 2008 R2
> PostgreSQL: 8.3.15
> Client: libpq C++ Application
>
> In client application log, we confirm that the above error occured in
> PQconnectDB or PQsetClientEncoding function.

The error occurred on the server, not the client if you got that
message. The question is what you did on the server when it happened.
If it happened connection, then I would look into things like anything
you have configured in shared_preload_libraries for example.


> The above error occured only one times.
> Is this problem fixed by latest package(8.3.20)?

Not that I know of, but it's always a possible side-effect from
something else - so it's always worth applying the latest patches.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-bugs by date:

Previous
From: james@illusorystudios.com
Date:
Subject: BUG #7515: DROP TABLE IF EXISTS fails if schema does not exist
Next
From: matsusaka@sraoss.co.jp
Date:
Subject: BUG #7518: "FORMAT" in the "COPY" command