Re: Unresolved error 0xC0000409 on Windows Server - Mailing list pgsql-hackers
| From | Matthew Gerber |
|---|---|
| Subject | Re: Unresolved error 0xC0000409 on Windows Server |
| Date | |
| Msg-id | CAOcpbfrrchP4XgAkXF3tJYFxQo2zd-41mVCfr9i=57AS-KBbMw@mail.gmail.com Whole thread Raw |
| In response to | Re: Unresolved error 0xC0000409 on Windows Server (Noah Misch <noah@leadboat.com>) |
| Responses |
Re: Unresolved error 0xC0000409 on Windows Server
(Craig Ringer <ringerc@ringerc.id.au>)
|
| List | pgsql-hackers |
On Fri, Nov 2, 2012 at 9:00 PM, Noah Misch <noah@leadboat.com> 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'),
(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.
I haven't customized any settings.
So I attached the VS debugger, but the server died without raising an exception in VS. Not sure what's going on here.
Testing disabling the AV software now. Will post back.
Nope.
Really appreciate any help you can provide.
Matt
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.matthew@gmail.com> wrote:> > I am encountering an error on my Postgres installation for Windows ServerCould you post an anonymized query, post an anonymized query plan, and/or
> > 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]
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
pgsql-hackers by date: