I'm not sure about the theory about recursion and infinity loop. I have
tested different versions of Postgres and FreeBSD. Please take a look on
results below.
Well, output of "ulimit -a":
$ ulimit -a
cpu time (seconds, -t) unlimited
file size (512-blocks, -f) unlimit
> Recursion within PL/PgSQL?
er ... sorry for stating the belated and obvious. I was dropped from the
CC on the other branch of this thread so it wasn't hitting my INBOX and
didn't realise it'd carried on until I saw it in my Pg list folder.
--
Craig Ringer
--
Sent via pgsql-bugs mailing list (
(resending with list cc'd)
Oleg Jurtšenko wrote:
> Core dump file are available here:
>
> www.fts.ee/pgsqldebug.tgz - with loging enabled
Well, it certainly looks recursive:
> #0 0x0839380b in MemoryContextAllocZeroAligned (context=0x2d9eaf70, size=16)
> at mcxt.c:559
> #1 0x081bfc16 in Exec
Robert Haas writes:
> 2009/12/8 Oleg Jurtšenko :
>> You are right, it crushes on following statement: "select
>> instr(ad_parent_tree(?,?),'|'||?||'|') AS isItsOwnChild from dual;"
>>
>> max_stack_depth is commented out, I think it has the default value:
>> #max_stack_depth = 2MB
> Well, my gue
2009/12/8 Oleg Jurtšenko :
> You are right, it crushes on following statement: "select
> instr(ad_parent_tree(?,?),'|'||?||'|') AS isItsOwnChild from dual;"
>
> max_stack_depth is commented out, I think it has the default value:
> #max_stack_depth = 2MB
Well, my guess is you have your kernel limit
The following bug has been logged online:
Bug reference: 5236
Logged by: Marcelo Mas
Email address: m...@atg.com.uy
PostgreSQL version: 8.4.1
Operating system: Suse 10
Description:Aparent bug in ecpg
Details:
At the company I work we developed a database adapter in
You are right, it crushes on following statement: "select
instr(ad_parent_tree(?,?),'|'||?||'|') AS isItsOwnChild from dual;"
max_stack_depth is commented out, I think it has the default value:
#max_stack_depth = 2MB
I'm attaching related functions.
Oleg
Robert Haas wrote:
2009/12/8 Oleg Ju
2009/12/8 Oleg Jurtšenko :
> Once more:
>
> http://www.fts.ee/pgsqldebug.tgz - with loging enabled
> http://www.ftse.ee/pg_core.tar.bzip2 - full core dump
It looks like you've got a pl/pgsql function that called itself
recursively 1417 times before running out of stack space. What do you
have max
Once more:
http://www.fts.ee/pgsqldebug.tgz
- with loging enabled
http://www.ftse.ee/pg_core.tar.bzip2
- full core dump
Robert Haas wrote:
2009/12/8 Oleg Jurtšenko :
Both files are there.
Both files are where? I don't see an attachment or a link.
...Robert
Both files are there.
Oleg.
Robert Haas wrote:
2009/12/8 Oleg Jurtšenko :
This the end of core dump. It is 8.3M bzip-ed. I can provide it on the
request.
I think maybe the beginning would be more useful than the end.
...Robert
--
Sent via pgsql-bugs mailing list (pgsql-bugs@pos
2009/12/8 Oleg Jurtšenko :
> Both files are there.
Both files are where? I don't see an attachment or a link.
...Robert
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
2009/12/8 Oleg Jurtšenko :
> This the end of core dump. It is 8.3M bzip-ed. I can provide it on the
> request.
I think maybe the beginning would be more useful than the end.
...Robert
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://ww
This the end of core dump. It is 8.3M bzip-ed. I can provide it on the
request.
I'm trying to compile Openbravo ERP application. There is no
C/Perl/Python functions.
My investigations show that pgsql catches segmentation fault on some|
||ported Oracle PLSQL function|:
Query in the source code is
Hi Kris-san.
Great, thanks!!
You have spent very much time for this problem.
I think very many Postgres users was helped by it.
Thanks again:-)
Regards,
Hiroshi Saito
- Original Message -
From: "Kris Jurka"
On Wed, 7 Oct 2009, konishi wrote:
Bug reference: 5099
PostgreSQ
On 8/12/2009 8:09 AM, Tom Lane wrote:
"Oleg Yurchenko" writes:
Program terminated with signal 11, Segmentation fault.
#0 0x0839380b in MemoryContextAllocZeroAligned (context=0x2d9eaf70,
size=16) at mcxt.c:559
559 mcxt.c: No such file or directory.
in mcxt.c
[New Thread 28b01140 (L
15 matches
Mail list logo
