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

Dear Mr.Hagander.
Thank you for your answer to my report.

> 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.

I describe the situation when the error occurred a little in detail.

The client application connect with the server by "localhost(127.0.0.1)" co=
nnection.
It output error-code to application log when an error will occurred in libp=
q function.
When this error happened, I found the error-code means PQconnectDB or PQset=
ClientEncoding function in application log.

So I suppose that it occurred when this error connect with server.

> If it happened connection, then I would look into things like anything yo=
u
> have configured in shared_preload_libraries for example.

I specified following definition in postgresql.conf.
shared_preload_libraries =3D '$libdir/plugins/plugin_debugger.dll'

Sincerely yours.

//Katsuhito Habaguchi

> -----Original Message-----
> From: Magnus Hagander [mailto:magnus@hagander.net]
> Sent: Tuesday, September 04, 2012 4:04 PM
> To: fx HABAGUCHI KATSUHITO
> Cc: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #7517: terminated by exception 0xC0000409
>=20
> 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 messag=
e.
> >
> > -----------------------------------------------------
> > 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
> > -----------------------------------------------------
>=20
> 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 instal=
led,
> try uninstalling it (not just disabling it) and see if the problem goes
> away.
>=20
>=20
> > 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.
>=20
> 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 yo=
u
> have configured in shared_preload_libraries for example.
>=20
>=20
> > The above error occured only one times.
> > Is this problem fixed by latest package(8.3.20)?
>=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.
>=20
> --
>  Magnus Hagander
>  Me: http://www.hagander.net/
>  Work: http://www.redpill-linpro.com/