[postgis-tickets] [PostGIS] #4287: Assertion failure in gserialized_gist_picksplit while creating gist index on geometry(LineString, 4326) column

PostGIS trac at osgeo.org
Mon Jan 28 18:48:48 PST 2019


#4287: Assertion failure in gserialized_gist_picksplit while creating gist index
on geometry(LineString,4326) column
-----------------------+---------------------------
  Reporter:  bgandhi1  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.5.2
 Component:  postgis   |    Version:  2.4.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by bgandhi1):

 I took a pg_dump of the table that reproduces issue for me. Since the
 table is ~21 MB, I split it using split command into 5 small files and
 attached here (since this site allows only 5.9 MB max). Once you've
 reassembled the attached files, you can pg_restore it to a PostgreSQL
 server (version details are in earlier comments).

 In the dump file, there's only one table (t). This table has just one
 column, it is of type Geometry(LineString, 4326). Once you've restored it,
 run below create index command: CREATE INDEX index_name ON public.t USING
 gist (surface_bh_ls);

 For me, this create index command causes the assertion failure reported
 here. Please let me know if you need any further information.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4287#comment:2>
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.


More information about the postgis-tickets mailing list