gppl-patch crash

From: David Helgason <david(at)otee(dot)dk>
To: Potemkin Evgen <gppl(at)inbox(dot)ru>
Cc: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: gppl-patch crash
Date: 2004-09-20 16:24:40
Message-ID: 927DBD3D-0B21-11D9-ADEE-000A9566DA8A@otee.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(I'm not quite sure which forum would be the right one, but since I'm
pretty stuck I hope someone around here will have a suggestion)

Using postgres 7.4.1 with version 0.5.3 of the gppl patch applied.
Working like a charm under test conditions, but using a CONNECT BY
statement with a large-ish start set (START WITH set of 1023 rows is
sufficient, 1022 is not. Suspicious numbers I must say) the following
crashes the backend with a signal 11:

create table clientstate (asset integer);
create table configuration (asset integer, parent integer);

... insert some 1290 rows into configuration, connecting asset-parent
into a hierarchy (representing a directory tree, but doesn't seem to
matter)

begin work;
insert into clientstatus (asset) select serial as asset from asset
limit 1023;
select count(*)
from
(select *
from configuration
connect by prior asset = parent start with asset in (select asset
from clientstatus)) as s;

rollback;

I'm pretty blank here. Any leads? Not doing the select in a subselect
removes the crash, so does having few enough objects in clientstatus...
I tried browsing the code of the patch, but it's pretty opaque code and
I didn't get any wiser.

Regards,

David Helgason,
Over the Edge (http://otee.dk) doing great game technology

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2004-09-20 19:35:14 Re: [GENERAL] New PayPal Donate Option
Previous Message Steve Atkins 2004-09-20 15:13:48 Re: How to get most frequent and least frequent values in a column?