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 INSE
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. My
On Sun, Nov 11, 2012 at 8:27 PM, Tom Lane wrote:
> Noah Misch 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
Noah Misch 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 overflow --- but actu
On Sun, Nov 11, 2012 at 2:43 PM, Noah Misch wrote:
> On Sun, Nov 11, 2012 at 10:10:31AM -0500, Matthew Gerber wrote:
> > > > Matthew Gerber writes:
> > > > >> Here is the command that was executing when the 0xC409
> exception
> > > was
> > > > >> raised:
> > > > >> INSERT INTO places
> (boun
On Sun, Nov 11, 2012 at 10:10:31AM -0500, Matthew Gerber wrote:
> > > Matthew Gerber 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 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
Matthew Gerber 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. Should I file this as
On Sun, Nov 11, 2012 at 12:22 PM, Tom Lane wrote:
> Matthew Gerber writes:
> > On Sun, Nov 11, 2012 at 11:19 AM, Tom Lane 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
Matthew Gerber writes:
> On Sun, Nov 11, 2012 at 11:19 AM, Tom Lane 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 c\n"; print "UNION ALL SELECT 1 a, 2
On Sun, Nov 11, 2012 at 11:19 AM, Tom Lane wrote:
> Matthew Gerber writes:
> > On Sun, Nov 11, 2012 at 12:23 AM, Noah Misch 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:
Matthew Gerber writes:
> On Sun, Nov 11, 2012 at 12:23 AM, Noah Misch 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 involved a long
> "SELECT ... UNION
On Sun, Nov 11, 2012 at 12:23 AM, Noah Misch wrote:
> On Sun, Nov 04, 2012 at 02:30:38PM -0500, Tom Lane wrote:
> > Matthew Gerber writes:
> > >> Here is the command that was executing when the 0xC409 exception
> was
> > >> raised:
> > >> INSERT INTO places (bounding_box,country,full_name,id
On Sun, Nov 04, 2012 at 02:30:38PM -0500, Tom Lane wrote:
> Matthew Gerber 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_GeometryFro
On Mon, Nov 05, 2012 at 09:10:30AM -0500, Matthew Gerber wrote:
> On Sun, Nov 4, 2012 at 3:39 AM, Craig Ringer 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.
No
On Fri, Nov 2, 2012 at 8:00 PM, Noah Misch 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
>> Execution h
On Sun, Nov 4, 2012 at 3:39 AM, Craig Ringer 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 the data dir
Matthew Gerber 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 32.953966,-96.88878
On Sun, Nov 4, 2012 at 3:39 AM, Craig Ringer 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
>
> (st_transform_null
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.03
On Fri, Nov 2, 2012 at 9:00 PM, Noah Misch 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
> wrote:
> > > I am encountering an error on my Postgres installation for Windows
> Server
> > > 64-bit. The error was posted her
On Fri, Nov 02, 2012 at 02:05:47PM -0500, Merlin Moncure wrote:
> On Fri, Nov 2, 2012 at 1:25 PM, Matthew Gerber
> 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
On Fri, Nov 2, 2012 at 1:25 PM, Matthew Gerber 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 pgsql-hackers in
>
23 matches
Mail list logo
