[postgis-devel] [PostGIS] #1903: Crash when inserting ~280 GEOGRAPHY POINTs (and NULLs) into a GIST indexed table

[PostGIS]

#1903: Crash when inserting ~280 GEOGRAPHY POINTs (and NULLs) into a GIST indexed
table
------------------------------------------------+---------------------------
 Reporter:  renefournier                        |       Owner:  pramsey      
     Type:  defect                              |      Status:  new          
 Priority:  critical                            |   Milestone:  PostGIS 1.5.4
Component:  postgis                             |     Version:  1.5.X        
 Keywords:  postgis crash gist geography point  |  
------------------------------------------------+---------------------------
Description changed by pramsey:

Old description:

> Creating a table with a GIST index on the GEOGRAPHY(POINT,4326) column,
> and then inserting hundreds rows, PostgreSQL will crash every time at row
> 284 (changing the order of the rows will affect at which row the crash
> occurs -- appears to be dependent on cumulative data size). If I remove
> the index, the crash never occurs.
>
>                                        postgis_full_version
> --------------------------------------------------------------------------------------------------
>  POSTGIS="1.5.4" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March 2012"
> LIBXML="2.7.8" USE_STATS
>

> Log output:
>
> LOG:  server process (PID 1373) was terminated by signal 11: Segmentation
> fault
> LOG:  terminating any other active server processes
> WARNING:  terminating connection because of crash of another server
> process
> DETAIL:  The postmaster has commanded this server process to roll back
> the current transaction and exit, because another server process exited
> abnormally and possibly corrupted shared memory.
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command.
> LOG:  all server processes terminated; reinitializing
> LOG:  database system was interrupted; last known up at 2012-07-06
> 10:46:58 CEST
> LOG:  database system was not properly shut down; automatic recovery in
> progress
> LOG:  redo starts at 0/38E6268
> LOG:  record with zero length at 0/393AB08
> LOG:  redo done at 0/393AAC8
> LOG:  last completed transaction was at log time 2012-07-06
> 10:47:17.590389+02
> LOG:  database system is ready to accept connections
> LOG:  autovacuum launcher started

New description:

 Creating a table with a GIST index on the GEOGRAPHY(POINT,4326) column,
 and then inserting hundreds rows, PostgreSQL will crash every time at row
 284 (changing the order of the rows will affect at which row the crash
 occurs -- appears to be dependent on cumulative data size). If I remove
 the index, the crash never occurs.
 {{{
                                        postgis_full_version
 --------------------------------------------------------------------------------------------------
  POSTGIS="1.5.4" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March 2012"
 LIBXML="2.7.8" USE_STATS


 Log output:

 LOG:  server process (PID 1373) was terminated by signal 11: Segmentation
 fault
 LOG:  terminating any other active server processes
 WARNING:  terminating connection because of crash of another server
 process
 DETAIL:  The postmaster has commanded this server process to roll back the
 current transaction and exit, because another server process exited
 abnormally and possibly corrupted shared memory.
 HINT:  In a moment you should be able to reconnect to the database and
 repeat your command.
 LOG:  all server processes terminated; reinitializing
 LOG:  database system was interrupted; last known up at 2012-07-06
 10:46:58 CEST
 LOG:  database system was not properly shut down; automatic recovery in
 progress
 LOG:  redo starts at 0/38E6268
 LOG:  record with zero length at 0/393AB08
 LOG:  redo done at 0/393AAC8
 LOG:  last completed transaction was at log time 2012-07-06
 10:47:17.590389+02
 LOG:  database system is ready to accept connections
 LOG:  autovacuum launcher started
 }}}

--

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1903#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.