Гость
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / Диагностика FATAL: connection to client lost / 4 сообщений из 4, страница 1 из 1
06.12.2018, 10:38
    #39743304
aux3
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Диагностика FATAL: connection to client lost
Господа, при выполнении запроса, по какой-то причине в журнале ошибок получаю сообщение:

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"
...
Рейтинг: 0 / 0
06.12.2018, 11:13
    #39743340
Melkij
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Диагностика FATAL: connection to client lost
aux3,

так а с клиентом что в это время случилось?
Если операционная система недвусмысленно сказала что сокет был закрыт, то больше тут делать решительно нечего.
Соответственно отстаньте от базы и проверяйте клиента, а так же сеть между ними.
...
Рейтинг: 0 / 0
07.12.2018, 08:49
    #39743996
Alex URS
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Диагностика FATAL: connection to client lost
скорее всего на уровне ОС
tcp_keepalive_*
...
Рейтинг: 0 / 0
10.12.2018, 11:47
    #39745201
aux3
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Диагностика FATAL: connection to client lost
Спасибо!
...
Рейтинг: 0 / 0
Форумы / PostgreSQL [игнор отключен] [закрыт для гостей] / Диагностика FATAL: connection to client lost / 4 сообщений из 4, страница 1 из 1
Целевая тема:
Создать новую тему:
Автор:
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]