Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group