pgRouting
pgr_createTopology Error during exception cleanup
Hi, I am attempting to run the pgr_createTopology function in Postgres but keep encountering the following error.
NOTICE: 263000 edges processed CONTEXT: PL/pgSQL function pgr_createtopology(text,double precision,text,text,text,text,text,boolean) line 200 at RAISE
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. CONTEXT: PL/pgSQL function pgr_createtopology(text,double precision,text,text,text,text,text,boolean) line 204 during exception cleanup********** Error **********
I have tried running it several times and the process doesn't stop after the same point nor after the same running time. Any ideas how to resolve this?
I am using: "PostgreSQL 10.5, compiled by Visual C++ build 1800, 64-bit" "POSTGIS="2.4.4 r16526" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.4, released 2018/03/19" LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER" pgr version: "(2.6.0,v2.6.0,a6226c4,release/2.6,1.59.0)"
SELECT public.pgr_createTopology('public.RoadsForRouting', 0.0001, 'geom', 'gid', 'source', 'target');
I am pretty confident that the data set is OK as I used the same data about a year ago on a different computer to run the same process (using an earlier version of Pestgres/PostGIS and pgRouting).
Many Thanks.
You better refer to this https://docs.pgrouting.org/dev/en/topology-functions.html.
The function may be in the Experimental state at that time ;)
