Postgres AssertFailedException Exception

Поиск
Список
Период
Сортировка
От Patil, Prashant
Тема Postgres AssertFailedException Exception
Дата
Msg-id CY4PR13MB1205E3EA47F4F38F43B9C39F93530@CY4PR13MB1205.namprd13.prod.outlook.com
обсуждение исходный текст
Ответы Re: Postgres AssertFailedException Exception  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Steven Lembark
Дата:
Сообщение: Re: How to prevent POSTGRES killing linux system from accepting toomuch inserts?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres AssertFailedException Exception