The following bug has been logged online:
Bug reference: 4765
Logged by: Paolo Saul
Email address: paolo.saul@telogis.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