<div dir="ltr">Hi Prashant,<div><br></div><div>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.</div><div>It could be a data problem like here: <a href="https://github.com/pgRouting/pgrouting/issues/1152">https://github.com/pgRouting/pgrouting/issues/1152</a></div><div>But it would be really best if you could first upgrade to newer versions and try again.</div><div><br></div><div>Best regards,</div><div>Daniel</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Dec 19, 2019 at 9:20 PM Patil, Prashant <<a href="mailto:Prashant.Patil@crowncastle.com">Prashant.Patil@crowncastle.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_6439149884819734597WordSection1">
<p class="MsoNormal">Hi Team,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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?<u></u><u></u></p>
<p class="MsoNormal">Server details - <u></u><u></u></p>
<p class="MsoNormal">Postgresql 9.3.25 ( we are in process of upgrading to 11)<u></u><u></u></p>
<p class="MsoNormal">Ubuntu 16.04.6 LTS<u></u><u></u></p>
<p class="MsoNormal">Pgrouting 2.6.0<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:red">2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...<a href="http://er.com/ViewEngine" target="_blank">er.com/ViewEngine</a> (forking...) [41329-3] postgres@odw ERROR:
<b>AssertFailedException</b>: p1.tot_cost() == p2.tot_cost() at /build/pgrouting-Prt6v2/pgrouting-2.6.0/include/yen/pgr_ksp.hpp:63<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> *** Execution path***<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/<a href="http://libpgrouting-2.6.so" target="_blank">libpgrouting-2.6.so</a>(_Z13get_backtraceB5cxx11v+0x3c) [0x7ff5fd368b7c]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/<a href="http://libpgrouting-2.6.so" target="_blank">libpgrouting-2.6.so</a>(_ZNK7Pgr_kspIN9pgrouting5graph14Pgr_base_graphIN5boost14adjacency_listINS3_4vecSES5_NS3_11undirectedSENS0_12Basic_vertexENS0_10Basic_edgeENS3_11no_propertyENS3_5listSEEES7_S8_EEE9compPathsclERK4PathSH_+0x2dd)
[0x7ff5fd3d2bbd]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/<a href="http://libpgrouting-2.6.so" target="_blank">libpgrouting-2.6.so</a>(_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]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/<a href="http://libpgrouting-2.6.so" target="_blank">libpgrouting-2.6.so</a>(_ZN7Pgr_kspIN9pgrouting5graph14Pgr_base_graphIN5boost14adjacency_listINS3_4vecSES5_NS3_11undirectedSENS0_12Basic_vertexENS0_10Basic_edgeENS3_11no_propertyENS3_5listSEEES7_S8_EEE11doNextCycleERSC_+0x641)
[0x7ff5fd3e2251]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/<a href="http://libpgrouting-2.6.so" target="_blank">libpgrouting-2.6.so</a>(_ZN7Pgr_kspIN9pgrouting5graph14Pgr_base_graphIN5boost14adjacency_listINS3_4vecSES5_NS3_11undirectedSENS0_12Basic_vertexENS0_10Basic_edgeENS3_11no_propertyENS3_5listSEEES7_S8_EEE3YenERSC_llib+0x2fb)
[0x7ff5fd3e288b]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/<a href="http://libpgrouting-2.6.so" target="_blank">libpgrouting-2.6.so</a>(do_pgr_ksp+0xbd4) [0x7ff5fd3e5f84]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/<a href="http://libpgrouting-2.6.so" target="_blank">libpgrouting-2.6.so</a>(kshortest_path+0x40e) [0x7ff5fd3ced4e]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(ExecMakeTableFunctionResult+0x19c) [0x55625ab1dcbc]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(+0x1dc116) [0x55625ab31116]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(ExecScan+0x2c9) [0x55625ab1feb9]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(ExecProcNode+0x1a8) [0x55625ab187e8]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(standard_ExecutorRun+0x10e) [0x55625ab15c6e]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]/usr/lib/postgresql/9.3/lib/pg_stat_statements.so(+0x24a5) [0x7ffa2048a4a5]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(+0x2a8717) [0x55625abfd717]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(PortalRunFetch+0x180) [0x55625abff0a0]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> [bt]postgres: postgres odw 10.76.0.185(44748) SELECT(+0x1e423d) [0x55625ab3923d]<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> <u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red">2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...<a href="http://er.com/ViewEngine" target="_blank">er.com/ViewEngine</a> (forking...) [41329-4] postgres@odw HINT:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red">2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...<a href="http://er.com/ViewEngine" target="_blank">er.com/ViewEngine</a> (forking...) [41329-5] postgres@odw CONTEXT: PL/pgSQL function pgr_ksp(text,bigint,bigint,integer,boolean,boolean) line 4 at RETURN QUERY<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> PL/pgSQL function nn_candidate_routes_from_and_to_latlon(geometry,geometry[]) line 75 at RETURN QUERY<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red">2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...<a href="http://er.com/ViewEngine" target="_blank">er.com/ViewEngine</a> (forking...) [41329-6] postgres@odw STATEMENT:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> select st_multi(st_union(geom)) as geom,return_target_seq,path_id,st_length(st_union(st_transform(geom,2163))) as distance<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> from nn_candidate_routes_from_and_to_latlon(st_setsrid(st_makepoint(-117.99466873924484,33.92814775576908),4326), ARRAY(<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> select geom from (<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> select geom, st_distance(st_setsrid(st_makepoint(-117.99466873924484,33.92814775576908),4326),geom)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> from (<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> select<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> (st_dumppoints((st_transform(st_segmentize(st_transform(wkt_geometry,2163),75),4326)))).geom<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> 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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> and wkt_geometry && st_transform(st_buffer(st_transform(st_setsrid(st_makepoint(-117.99466873924484,33.92814775576908),4326),2163),50000),4326)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> 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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:red"> )) where geom is not null group by return_target_seq,path_id order by distance asc limit 25</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards,<u></u><u></u></p>
<p class="MsoNormal">Prashant<u></u><u></u></p>
</div>
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.
</div>
_______________________________________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a></span><div><br></div><div><br></div><div><br></div></div></div></div></div>