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?
Server details -
Postgresql 9.3.25
Ubuntu 16.04.6 LTS
Pgrouting 2.6.0
2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...er.com/ViewEngine
(forking...) [41329-3] postgres@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(_Z13get_backtraceB5cxx11v+0x3c)
[0x7ff5fd368b7c]
[bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so(_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(_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(_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(_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(do_pgr_ksp+0xbd4)
[0x7ff5fd3e5f84]
[bt]/usr/lib/postgresql/9.3/lib/libpgrouting-2.6.so(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
(forking...) [41329-4] postgres@odw HINT:
2019-12-16 19:31:55 EST Passenger AppPreloader: /var/w...er.com/ViewEngine
(forking...) [41329-5] postgres@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
(forking...) [41329-6] postgres@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.
