BUG #4765: GIST box Segfaulting on Inserts

From: "Paolo Saul" <paolo(dot)saul(at)telogis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4765: GIST box Segfaulting on Inserts
Date: 2009-04-21 05:50:51
Message-ID: 200904210550.n3L5op9u028988@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4765
Logged by: Paolo Saul
Email address: paolo(dot)saul(at)telogis(dot)com
PostgreSQL version: 8.3.5
Operating system: RHEL5 x64
Description: GIST box Segfaulting on Inserts
Details:

We have a table with GIST indexes on a box. Its throwing segfaults with a
certain set of box data.

To recreate:

FILE NEEDED: xx.sql
Where can I attach this? Its 47MB.

SQL:
CREATE TABLE wre_xx (
id oid,
geom box
);

RUN: psql -U postgres -f xx.sql

OUTPUT:
psql:xx.sql:230203: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
psql:xx.sql:230203: connection to server was lost

LOG:
[13844]2009-04-21 05:22:58.606 GMT 0 : LOG: 00000: server process (PID
12363) was terminated by signal 11: Segmentation fault

TOP OF STACK:
(gdb) bt
#0 0x000000000065255f in DirectFunctionCall2 ()
#1 0x0000000000454c29 in gist_box_picksplit ()
#2 0x0000000000651cdf in FunctionCall2 ()
#3 0x0000000000455582 in gistSplitByKey ()
#4 0x000000000044c8f5 in gistSplit ()
#5 0x000000000044c99b in gistSplit ()
#6 0x000000000044c99b in gistSplit ()
#7 0x000000000044c99b in gistSplit ()
#8 0x000000000044c99b in gistSplit ()
#9 0x000000000044c99b in gistSplit ()
#10 0x000000000044c99b in gistSplit ()
........
#16356 0x000000000044c99b in gistSplit ()
#16357 0x000000000044c99b in gistSplit ()
#16358 0x000000000044d2c7 in gistmakedeal ()
#16359 0x000000000044db2b in ?? ()
#16360 0x000000000044def5 in gistinsert ()
#16361 0x000000000065197c in FunctionCall6 ()
#16362 0x000000000046489f in index_insert ()
#16363 0x0000000000522635 in ExecInsertIndexTuples ()
#16364 0x000000000051a0db in ExecutorRun ()
#16365 0x00000000005aed84 in ?? ()
#16366 0x00000000005aefa4 in ?? ()
#16367 0x00000000005af7ca in PortalRun ()
#16368 0x00000000005ac748 in PostgresMain ()
#16369 0x0000000000582907 in ?? ()
#16370 0x000000000058358b in PostmasterMain ()
#16371 0x000000000053c4de in main ()

If you need the file, Just tell me where to upload it.

Regards,

Paolo Saul
Telogis.com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert 2009-04-21 10:55:58 BUG #4766: i cant setup a program
Previous Message Paolo Saul 2009-04-21 04:04:57 Segfaults When Inserting into a Geom Index