You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)"
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: