[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