Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pgr_createTopology Error during exception cleanup #1180

Open
MartinDDDD opened this issue Jan 8, 2019 · 1 comment
Open

pgr_createTopology Error during exception cleanup #1180

MartinDDDD opened this issue Jan 8, 2019 · 1 comment

Comments

@MartinDDDD
Copy link

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.

@veenits123
Copy link
Member

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 ;)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants