On Sun, Dec 09, 2012 at 02:09:21PM -0500, Matthew Gerber wrote:
In this situation, st_transform throws an internal_error, which my
function catches and returns NULL for. The error / crash is not caused by a
NULL argument; rather, it is caused by the final value in the attached
script's INSERT
All,
I have successfully isolated this error and created a simple SQL script to
reproduce it. Just to recap - this script will cause a server crash with
exception 0xC409 as described in previous emails. The crux of the
problem seems to be my creation / use of the function st_transform_null.
On Sun, Nov 11, 2012 at 12:23 AM, Noah Misch n...@leadboat.com wrote:
On Sun, Nov 04, 2012 at 02:30:38PM -0500, Tom Lane wrote:
Matthew Gerber gerber.matt...@gmail.com writes:
Here is the command that was executing when the 0xC409 exception
was
raised:
INSERT INTO places
Matthew Gerber gerber.matt...@gmail.com writes:
On Sun, Nov 11, 2012 at 12:23 AM, Noah Misch n...@leadboat.com wrote:
It signifies scribbling past the end of the frame's local variables:
http://msdn.microsoft.com/en-us/library/8dbf701c.aspx
A slight update on this: previously, my insert code
On Sun, Nov 11, 2012 at 11:19 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Matthew Gerber gerber.matt...@gmail.com writes:
On Sun, Nov 11, 2012 at 12:23 AM, Noah Misch n...@leadboat.com wrote:
It signifies scribbling past the end of the frame's local variables:
Matthew Gerber gerber.matt...@gmail.com writes:
On Sun, Nov 11, 2012 at 11:19 AM, Tom Lane t...@sss.pgh.pa.us wrote:
How long is long?
I was seeing queries with around 5000-7000 UNION ALL statements.
Hm. I experimented with test queries created like so:
perl -e 'print SELECT 1 a, 2 b, 3
On Sun, Nov 11, 2012 at 12:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Matthew Gerber gerber.matt...@gmail.com writes:
On Sun, Nov 11, 2012 at 11:19 AM, Tom Lane t...@sss.pgh.pa.us wrote:
How long is long?
I was seeing queries with around 5000-7000 UNION ALL statements.
Hm. I
Matthew Gerber gerber.matt...@gmail.com writes:
Interesting. I really have no idea why mine seemed to fail so much sooner.
I recalled my 5k-7k figure from memory, so I might be off on that, but
probably not by an order of magnitude. In any case, it sounds like you know
how to fix the problem.
On Sun, Nov 11, 2012 at 12:22:24PM -0500, Tom Lane wrote:
perl -e 'print SELECT 1 a, 2 b, 3 c\n; print UNION ALL SELECT 1 a, 2 b, 3
c\n foreach (1..8200);' | psql
On the machine I tried this on, it works up to about 8200 and then fails
in the way I'd expect:
ERROR: stack depth limit
On Sun, Nov 11, 2012 at 10:10:31AM -0500, Matthew Gerber wrote:
Matthew Gerber gerber.matt...@gmail.com writes:
Here is the command that was executing when the 0xC409 exception
was
raised:
INSERT INTO places (bounding_box,country,full_name,id,name,type,url)
VALUES
On Sun, Nov 11, 2012 at 2:43 PM, Noah Misch n...@leadboat.com wrote:
On Sun, Nov 11, 2012 at 10:10:31AM -0500, Matthew Gerber wrote:
Matthew Gerber gerber.matt...@gmail.com writes:
Here is the command that was executing when the 0xC409
exception
was
raised:
INSERT INTO
Noah Misch n...@leadboat.com writes:
So, I can reproduce the lower threshold, but the exception type does not agree
with the one Matthew observed.
I finally got around to looking at the link you provided about error
0xC409, and realized that I'd been completely confusing it with
stack
On Sun, Nov 11, 2012 at 8:27 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Noah Misch n...@leadboat.com writes:
So, I can reproduce the lower threshold, but the exception type does not
agree
with the one Matthew observed.
I finally got around to looking at the link you provided about error
On Mon, Nov 05, 2012 at 09:10:30AM -0500, Matthew Gerber wrote:
On Sun, Nov 4, 2012 at 3:39 AM, Craig Ringer ring...@ringerc.id.au wrote:
On 11/04/2012 08:47 AM, Matthew Gerber wrote:
So I attached the VS debugger, but the server died without raising an
exception in VS. Not sure what's
On Sun, Nov 04, 2012 at 02:30:38PM -0500, Tom Lane wrote:
Matthew Gerber gerber.matt...@gmail.com writes:
Here is the command that was executing when the 0xC409 exception was
raised:
INSERT INTO places (bounding_box,country,full_name,id,name,type,url)
VALUES
On Sun, Nov 4, 2012 at 3:39 AM, Craig Ringer ring...@ringerc.id.au wrote:
On 11/04/2012 08:47 AM, Matthew Gerber wrote:
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
On Fri, Nov 2, 2012 at 8:00 PM, Noah Misch n...@leadboat.com wrote:
hm, several times over the last couple of months (both on postgres 9.1
and 9.2), i've seen a similar crash, but on linux. It hits the log
like this:
Execution halted (~ 200x)
Error: segfault from C stack overflow
On 11/04/2012 08:47 AM, Matthew Gerber wrote:
Here is the command that was executing when the 0xC409 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
On Sun, Nov 4, 2012 at 3:39 AM, Craig Ringer ring...@ringerc.id.au wrote:
On 11/04/2012 08:47 AM, Matthew Gerber wrote:
Here is the command that was executing when the 0xC409 exception was
raised:
INSERT INTO places (bounding_box,country,full_name,id,name,type,url)
VALUES
Matthew Gerber gerber.matt...@gmail.com writes:
Here is the command that was executing when the 0xC409 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
On Fri, Nov 2, 2012 at 9:00 PM, Noah Misch n...@leadboat.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.matt...@gmail.com
wrote:
I am encountering an error on my Postgres installation for Windows
Server
On Fri, Nov 2, 2012 at 1:25 PM, Matthew Gerber gerber.matt...@gmail.com wrote:
Hello,
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
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.matt...@gmail.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
23 matches
Mail list logo