Re: Unresolved error 0xC0000409 on Windows Server

On Fri, Nov 2, 2012 at 9:00 PM, Noah Misch <noah(at)leadboat(dot)com> wrote:

> On Fri, Nov 02, 2012 at 02:05:47PM -0500, Merlin Moncure wrote:
> > On Fri, Nov 2, 2012 at 1:25 PM, Matthew Gerber <gerber(dot)matthew(at)gmail(dot)com>
> wrote:
> > > I am encountering an error on my Postgres installation for Windows
> Server
> > > 64-bit. The error was posted here 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]
>
> Could you post an anonymized query, post an anonymized query plan, and/or
> describe the general nature of the query? Does it call functions? About
> how
> many rows does it insert?
>

Here is the command that was executing when the 0xC0000409 exception was
raised:

INSERT INTO places (bounding_box,country,full_name,id,name,type,url)

VALUES

(st_transform_null(ST_GeometryFromText('POLYGON((-97.034085
32.771786,-97.034085 32.953966,-96.888789 32.953966,-96.888789
32.771786,-97.034085 32.771786))',4326),26918),'United States','Irving,
TX','dce44ec49eb788f5','Irving','city','
http://api.twitter.com/1/geo/id/dce44ec49eb788f5.json'),

(st_transform_null(ST_GeometryFromText('POLYGON((107.610398
-6.9006302,107.610398 -6.864448,107.637222 -6.864448,107.637222
-6.9006302,107.610398 -6.9006302))',4326),26918),'Indonesia','Coblong, Kota
Bandung','2c0294c5eab821c9','Coblong','city','
http://api.twitter.com/1/geo/id/2c0294c5eab821c9.json')

The st_transform_null function is simply a wrapper around the PostGIS
st_transform function that deals with NULL values. The other fields are all
VARCHARs. This insert is only adding two values. In general, the insert
commands I'm running insert anywhere up to 100 rows each, so they're not
huge.

>
> What server settings have you customized?
> https://wiki.postgresql.org/wiki/Server_Configuration
>

I haven't customized any settings.

>
> If you could get a stack trace or minidump, that would be most helpful:
>
> https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
>

So I attached the VS debugger, but the server died without raising an
exception in VS. Not sure what's going on here.

>
> Magnus's questions for the reporter of bug #7517 are relevant, too. Does
> the
> system have any antivirus software installed?
>

Testing disabling the AV software now. Will post back.

Google suggests those unadorned messages originate in R. Do the affected
> systems use PL/R? If so ...
>

Nope.

Really appreciate any help you can provide.

Matt