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'),
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