|
Диагностика FATAL: connection to client lost
|
|||
---|---|---|---|
#18+
Господа, при выполнении запроса, по какой-то причине в журнале ошибок получаю сообщение: 2018-12-06 10:20:57.326 MSK [772] FATAL: connection to client lost Как диагностировать данную ошибку? Может ли данная ошибка быть связана с неправильной настройкой параметров сервера postgres. Как определить данную ошибку?? 2018-12-06 10:20:57.326 MSK [772] STATEMENT: SELECT "avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rckolvo_tt_vse0_0" AS "avg_sale_dtz_v_measures_rckolvo_tt_vse0_0","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsum_opsum_ vse0_1" AS "avg_sale_dtz_v_measures_rcsum_opsum_vse0_1","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsum_sale_qnty_vse0_2" AS "avg_sale_dtz_v_measures_rcsum_sale_qnty_vse0_2","avg_sale_dtz_v_measure s_rc"."avg_sale_dtz_v_measures_rcsum_sale_kg_vse0_3" AS "avg_sale_dtz_v_measures_rcsum_sale_kg_vse0_3","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcus_vse0_4" AS "avg_sale_dtz_v_measures_rcus_vse0_4 ","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcprodaz_cena_vse0_5" AS "avg_sale_dtz_v_measures_rcprodaz_cena_vse0_5","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsrd_oborot_vse0_6" AS "av g_sale_dtz_v_measures_rcsrd_oborot_vse0_6","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsrd_oborot_vse_kg0_7" AS "avg_sale_dtz_v_measures_rcsrd_oborot_vse_kg0_7","avg_sale_dtz_v_measures_rc"."avg_sa le_dtz_v_measures_rcavg_price_vse0_8" AS "avg_sale_dtz_v_measures_rcavg_price_vse0_8","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcnacenka_v_oborote_vse0_9" AS "avg_sale_dtz_v_measures_rcnacenka_v_o borote_vse0_9","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcnacenka_prodagnaya_vse0_10" AS "avg_sale_dtz_v_measures_rcnacenka_prodagnaya_vse0_10","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measure s_rckolvo_tt_horosh0_11" AS "avg_sale_dtz_v_measures_rckolvo_tt_horosh0_11","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsum_opsum_horosh0_12" AS "avg_sale_dtz_v_measures_rcsum_opsum_horosh0_12","av g_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsum_sale_qnty_horosh0_13" AS "avg_sale_dtz_v_measures_rcsum_sale_qnty_horosh0_13","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsum_sale_kg_horosh 0_14" AS "avg_sale_dtz_v_measures_rcsum_sale_kg_horosh0_14","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcus_horosh0_15" AS "avg_sale_dtz_v_measures_rcus_horosh0_15","avg_sale_dtz_v_measures_rc"."avg _sale_dtz_v_measures_rcprodaz_cena_horosh0_16" AS "avg_sale_dtz_v_measures_rcprodaz_cena_horosh0_16","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsrd_oborot_horosh0_17" AS "avg_sale_dtz_v_measures_r csrd_oborot_horosh0_17","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcsrd_oborot_horosh_kg0_18" AS "avg_sale_dtz_v_measures_rcsrd_oborot_horosh_kg0_18","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_me asures_rcavg_price_horosh0_19" AS "avg_sale_dtz_v_measures_rcavg_price_horosh0_19","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcnacenka_v_oborote_horosh0_20" AS "avg_sale_dtz_v_measures_rcnacenka_v_ oborote_horosh0_20","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcnacenka_prodagnaya_horosh0_21" AS "avg_sale_dtz_v_measures_rcnacenka_prodagnaya_horosh0_21","avg_sale_dtz_v_measures_rc"."avg_sale_dt z_v_measures_rc0_22" AS "avg_sale_dtz_v_measures_rc0_22","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcdate_raschet0_23" AS "avg_sale_dtz_v_measures_rcdate_raschet0_23","avg_sale_dtz_v_measures_rc"." avg_sale_dtz_v_measures_rccntr_id0_24" AS "avg_sale_dtz_v_measures_rccntr_id0_24","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcweek_id_20_25" AS "avg_sale_dtz_v_measures_rcweek_id_20_25","avg_sale_d tz_v_measures_rc"."avg_sale_dtz_v_measures_rcno_id0_26" AS "avg_sale_dtz_v_measures_rcno_id0_26","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcassort0_27" AS "avg_sale_dtz_v_measures_rcassort0_27","a vg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcart_id0_28" AS "avg_sale_dtz_v_measures_rcart_id0_28","avg_sale_dtz_v_measures_rc"."avg_sale_dtz_v_measures_rcfrmt_id0_29" AS "avg_sale_dtz_v_measures_rcfr mt_id0_29" FROM ( SELECT "kolvo_tt_vse" AS "avg_sale_dtz_v_measures_rckolvo_tt_vse0_0","sum_opsum_vse" AS "avg_sale_dtz_v_measures_rcsum_opsum_vse0_1","sum_sale_qnty_vse" AS "avg_sale_dtz_v_measures_rcsum_sale_q nty_vse0_2","sum_sale_kg_vse" AS "avg_sale_dtz_v_measures_rcsum_sale_kg_vse0_3","us_vse" AS "avg_sale_dtz_v_measures_rcus_vse0_4","prodaz_cena_vse" AS "avg_sale_dtz_v_measures_rcprodaz_cena_vse0_5","srd_oborot _vse" AS "avg_sale_dtz_v_measures_rcsrd_oborot_vse0_6","srd_oborot_vse_kg" AS "avg_sale_dtz_v_measures_rcsrd_oborot_vse_kg0_7","avg_price_vse" AS "avg_sale_dtz_v_measures_rcavg_price_vse0_8","nacenka_v_oborote _vse" AS "avg_sale_dtz_v_measures_rcnacenka_v_oborote_vse0_9","nacenka_prodagnaya_vse" AS "avg_sale_dtz_v_measures_rcnacenka_prodagnaya_vse0_10","kolvo_tt_horosh" AS "avg_sale_dtz_v_measures_rckolvo_tt_horosh0 _11","sum_opsum_horosh" AS "avg_sale_dtz_v_measures_rcsum_opsum_horosh0_12","sum_sale_qnty_horosh" AS "avg_sale_dtz_v_measures_rcsum_sale_qnty_horosh0_13","sum_sale_kg_horosh" AS "avg_sale_dtz_v_measures_rcsum _sale_kg_horosh0_14","us_horosh" AS "avg_sale_dtz_v_measures_rcus_horosh0_15","prodaz_cena_horosh" AS "avg_sale_dtz_v_measures_rcprodaz_cena_horosh0_16","srd_oborot_horosh" AS "avg_sale_dtz_v_measures_rcsrd_ob orot_horosh0_17","srd_oborot_horosh_kg" AS "avg_sale_dtz_v_measures_rcsrd_oborot_horosh_kg0_18","avg_price_horosh" AS "avg_sale_dtz_v_measures_rcavg_price_horosh0_19","nacenka_v_oborote_horosh" AS "avg_sale_dt z_v_measures_rcnacenka_v_oborote_horosh0_20","nacenka_prodagnaya_horosh" AS "avg_sale_dtz_v_measures_rcnacenka_prodagnaya_horosh0_21",1 AS "avg_sale_dtz_v_measures_rc0_22","date_raschet" AS "avg_sale_dtz_v_m easures_rcdate_raschet0_23","cntr_id" AS "avg_sale_dtz_v_measures_rccntr_id0_24","week_id_2" AS "avg_sale_dtz_v_measures_rcweek_id_20_25","no_id" AS "avg_sale_dtz_v_measures_rcno_id0_26","assort" AS "avg_sale_ dtz_v_measures_rcassort0_27","art_id" AS "avg_sale_dtz_v_measures_rcart_id0_28","frmt_id" AS "avg_sale_dtz_v_measures_rcfrmt_id0_29" FROM "avg_sale_dtz"."v_measures_rc" ) AS "avg_sale_dtz_v_measures_rc" ... |
|||
:
Нравится:
Не нравится:
|
|||
06.12.2018, 10:38 |
|
Диагностика FATAL: connection to client lost
|
|||
---|---|---|---|
#18+
aux3, так а с клиентом что в это время случилось? Если операционная система недвусмысленно сказала что сокет был закрыт, то больше тут делать решительно нечего. Соответственно отстаньте от базы и проверяйте клиента, а так же сеть между ними. ... |
|||
:
Нравится:
Не нравится:
|
|||
06.12.2018, 11:13 |
|
|
start [/forum/topic.php?fid=53&fpage=47&tid=1995452]: |
0ms |
get settings: |
9ms |
get forum list: |
13ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
38ms |
get topic data: |
13ms |
get forum data: |
3ms |
get page messages: |
50ms |
get tp. blocked users: |
2ms |
others: | 17ms |
total: | 151ms |
0 / 0 |