Re: Unresolved error 0xC0000409 on Windows Server

On 11/04/2012 08:47 AM, Matthew Gerber wrote:
>
> 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'
> <http://api.twitter.com/1/geo/id/dce44ec49eb788f5.json%27>),

OK, so you're using PostGIS. What other extensions are loaded? PL/R? Any
other PLs?

Can you show the definition of the table `places`, incuding any
associated triggers, etc? Use `\d+` in psql for the table def'n.

Please also post the query plan. http://explain.depesz.com/ is useful
for this.
>
> So I attached the VS debugger, but the server died without raising an
> exception in VS. Not sure what's going on here.
>
>
Try creating a directory called "crashdumps" in the data directory, at
the same level as "pg_xlog" and "pg_clog" etc. Give the "postgresql"
user the "full control" permission on it. Then run the test again.

Do any minidump files appear in the directory? If so, you can examine
them with windbg or Visual Studio to see where the crash happened.

--
Craig Ringer