[pgrouting-dev] Postgres AssertFailedException Exception

Thu Dec 19 05:53:03 PST 2019

Thanks for your reply. Due to this exception is it possible whole process that runs the query got stuck or hung as we are experiencing the same and logs shows this error message.

Regards,
Prashant

On Dec 19, 2019, at 8:10 AM, Daniel Kastl <daniel at georepublic.de> wrote:

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi Prashant,

As you say your version of PostgreSQL is one that is not supported anymore and also your pgRouting version has seen a few bugfix releases already.
It could be a data problem like here: https://github.com/pgRouting/pgrouting/issues/1152<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FpgRouting%2Fpgrouting%2Fissues%2F1152&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156387184&sdata=YuszRoWvnD2Da7HLHY8fod%2BSahuXqt7dmfE9xxgL2YY%3D&reserved=0>
But it would be really best if you could first upgrade to newer versions and try again.

Best regards,
Daniel

On Thu, Dec 19, 2019 at 9:20 PM Patil, Prashant <Prashant.Patil at crowncastle.com<mailto:Prashant.Patil at crowncastle.com>> wrote:
Hi Team,

We are receiving following AssertFailedException exception while executing pgrouting query listed below. Anyone have idea about this exception? Is this known bug? Possible fix? Is this something hangs the whole process?
Server details -
Postgresql 9.3.25 ( we are in process of upgrading to 11)
Ubuntu 16.04.6 LTS
Pgrouting 2.6.0

2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...er.com/ViewEngine<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fer.com%2FViewEngine&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156397177&sdata=%2BGGr4vG7Hqej%2B8IKn7yv9JSccs1puBc3Ztg6n9J0UAs%3D&reserved=0> (forking...) [41329-3] postgres at odw ERROR:  AssertFailedException: p1.tot_cost() == p2.tot_cost() at /build/pgrouting-Prt6v2/pgrouting-2.6.0/include/yen/pgr_ksp.hpp:63
               *** Execution path***
               [bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flibpgrouting-2.6.so&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156407169&sdata=FqwGqBcrsjPixTy9CckVaGZJeQO1eXBjmGpd01Usk%2BQ%3D&reserved=0>(_Z13get_backtraceB5cxx11v+0x3c) [0x7ff5fd368b7c]
               [bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flibpgrouting-2.6.so&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156407169&sdata=FqwGqBcrsjPixTy9CckVaGZJeQO1eXBjmGpd01Usk%2BQ%3D&reserved=0>(_ZNK7Pgr_kspIN9pgrouting5graph14Pgr_base_graphIN5boost14adjacency_listINS3_4vecSES5_NS3_11undirectedSENS0_12Basic_vertexENS0_10Basic_edgeENS3_11no_propertyENS3_5listSEEES7_S8_EEE9compPathsclERK4PathSH_+0x2dd) [0x7ff5fd3d2bbd]
               [bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flibpgrouting-2.6.so&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156417160&sdata=h0sG6xL%2BUu6JRxxA%2BG%2B4kVsbuM0ReKk4921km%2BbN7nU%3D&reserved=0>(_ZNSt8_Rb_treeI4PathS0_St9_IdentityIS0_EN7Pgr_kspIN9pgrouting5graph14Pgr_base_graphIN5boost14adjacency_listINS7_4vecSES9_NS7_11undirectedSENS4_12Basic_vertexENS4_10Basic_edgeENS7_11no_propertyENS7_5listSEEESB_SC_EEE9compPathsESaIS0_EE16_M_insert_uniqueIRKS0_EESt4pairISt17_Rb_tree_iteratorIS0_EbEOT_+0x4e) [0x7ff5fd3d2dae]
               [bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flibpgrouting-2.6.so&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156427939&sdata=GrS6SP4aP6XOcnMoRb10T5Tp2tPXtiaWCkfEXqeBs4Y%3D&reserved=0>(_ZN7Pgr_kspIN9pgrouting5graph14Pgr_base_graphIN5boost14adjacency_listINS3_4vecSES5_NS3_11undirectedSENS0_12Basic_vertexENS0_10Basic_edgeENS3_11no_propertyENS3_5listSEEES7_S8_EEE11doNextCycleERSC_+0x641) [0x7ff5fd3e2251]
               [bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flibpgrouting-2.6.so&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156437160&sdata=Cj8lbpF1Fvt1tRtluUE4Z8Uo0Df72wiymsrmcfF6URI%3D&reserved=0>(_ZN7Pgr_kspIN9pgrouting5graph14Pgr_base_graphIN5boost14adjacency_listINS3_4vecSES5_NS3_11undirectedSENS0_12Basic_vertexENS0_10Basic_edgeENS3_11no_propertyENS3_5listSEEES7_S8_EEE3YenERSC_llib+0x2fb) [0x7ff5fd3e288b]
               [bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flibpgrouting-2.6.so&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156437160&sdata=Cj8lbpF1Fvt1tRtluUE4Z8Uo0Df72wiymsrmcfF6URI%3D&reserved=0>(do_pgr_ksp+0xbd4) [0x7ff5fd3e5f84]
               [bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Flibpgrouting-2.6.so&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156447155&sdata=A3xdJ3qh83p8itLuD6WLeidYRX7xnIHEWxyoB2kQzRw%3D&reserved=0>(kshortest_path+0x40e) [0x7ff5fd3ced4e]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(ExecMakeTableFunctionResult+0x19c) [0x55625ab1dcbc]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(+0x1dc116) [0x55625ab31116]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(ExecScan+0x2c9) [0x55625ab1feb9]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(ExecProcNode+0x1a8) [0x55625ab187e8]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(standard_ExecutorRun+0x10e) [0x55625ab15c6e]
               [bt]/usr/lib/postgresql/9.3/lib/pg_stat_statements.so(+0x24a5) [0x7ffa2048a4a5]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(+0x2a8717) [0x55625abfd717]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(PortalRunFetch+0x180) [0x55625abff0a0]
               [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(+0x1e423d) [0x55625ab3923d]

2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...er.com/ViewEngine<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fer.com%2FViewEngine&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156457149&sdata=IZkOaTWq91qfxcNke0ySzCu6KosZM8hE%2FSGPNkAoVAg%3D&reserved=0> (forking...) [41329-4] postgres at odw HINT:
2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...er.com/ViewEngine<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fer.com%2FViewEngine&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156457149&sdata=IZkOaTWq91qfxcNke0ySzCu6KosZM8hE%2FSGPNkAoVAg%3D&reserved=0> (forking...) [41329-5] postgres at odw CONTEXT:  PL/pgSQL function pgr_ksp(text,bigint,bigint,integer,boolean,boolean) line 4 at RETURN QUERY
               PL/pgSQL function nn_candidate_routes_from_and_to_latlon(geometry,geometry[]) line 75 at RETURN QUERY
2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...er.com/ViewEngine<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fer.com%2FViewEngine&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156467141&sdata=scB9dO9x9IxxayfKYM4lQjx%2B4YPAU500cAQ0n9BeoZU%3D&reserved=0> (forking...) [41329-6] postgres at odw STATEMENT:
                       select st_multi(st_union(geom)) as geom,return_target_seq,path_id,st_length(st_union(st_transform(geom,2163))) as distance
                        from nn_candidate_routes_from_and_to_latlon(st_setsrid(st_makepoint(-117.99466873924484,33.92814775576908),4326), ARRAY(
                       select geom from (
                       select geom, st_distance(st_setsrid(st_makepoint(-117.99466873924484,33.92814775576908),4326),geom)
                       from (
                          select
                        (st_dumppoints((st_transform(st_segmentize(st_transform(wkt_geometry,2163),75),4326)))).geom
                        from (select * from staging_dw_cables where upper(owner) ~ 'OWNED' and start_ne_dw_enclosure_id is not null and end_ne_dw_enclosure_id is not null and pop_cable_tf = true
                        and wkt_geometry && st_transform(st_buffer(st_transform(st_setsrid(st_makepoint(-117.99466873924484,33.92814775576908),4326),2163),50000),4326)
                        order by st_distance(st_setsrid(st_makepoint(-117.99466873924484,33.92814775576908),4326),wkt_geometry) limit 15) cables) sq order by 2 asc limit 15) sq
                        )) where geom is not null group by return_target_seq,path_id order by distance asc limit 25

Regards,
Prashant
This email may contain confidential or privileged material. Use or disclosure of it by anyone other than the recipient is unauthorized. If you are not an intended recipient, please delete this email.
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev at lists.osgeo.org<mailto:pgrouting-dev at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/pgrouting-dev<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fpgrouting-dev&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156467141&sdata=%2B1hq8sOsCPGWHmqUbwofxFOonGSoX3yB4Qii9Ju%2FchA%3D&reserved=0>

--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de<mailto:daniel.kastl at georepublic.de>
Web: https://georepublic.info<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgeorepublic.info&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156477133&sdata=i0hzPX1VhLytLIAQP4urZ5RbqmNHuu0FiubggNUaIQU%3D&reserved=0>

_______________________________________________
pgrouting-dev mailing list
pgrouting-dev at lists.osgeo.org
https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fpgrouting-dev&data=02%7C01%7CPrashant.Patil%40crowncastle.com%7Cf535395ceef84184924908d78484c7db%7C3c614fdd671142aea368f96ab9460598%7C0%7C1%7C637123578156507129&sdata=Jo1ydITQTVCYm1yKMxB3a983D8pqgsHk8iUB1yOUaoI%3D&reserved=0
This email may contain confidential or privileged material. Use or disclosure of it by anyone other than the recipient is unauthorized. If you are not an intended recipient, please delete this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20191219/5be5a614/attachment-0001.html>