[17081] Зацикливание точек учета в запросе

ЛЭРС УЧЁТ Ошибки
1

Версия ЛЭРС УЧЁТ: 3.64.3
Сервер БД: PostgreSQL

ЛЭРС сделал такой запрос к БД

СООБЩЕНИЕ:  продолжительность: 73540.130 мс  выполнение <unnamed>: SELECT m."ArchiveType", m."ChannelNumber", m."DataType", m."DateTime", m."EventCode", m."MeasurePointId", m."Description", m."Duration", m."Importance"
        FROM public."MeasurePointDeviceErrors" AS m
        WHERE m."MeasurePointId" = ANY ($1) AND m."DateTime" >= $2 AND m."DateTime" <= $3
2026-02-02 03:17:54.856 +07 [107045] alex@LERS ПОДРОБНОСТИ:  Параметры: $1 = '{1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183,1823,2183}', $2 = '1983-07-16 23:59:00', $3 = '2026-02-02 02:01:00'

Запрос по факту еще больше, пришлось его обрезать, что бы он в сообщение поместился. Это явно ненормально. Это как то можно поправить?

2

Вероятно это происходит при сохранении данных опроса ВКТ-9

3

Уточните, пожалуйста, такой запрос действительно только при опросе ВКТ-9 или при опросе любого прибора учета с архивом ошибок?

4

Сложно сказать, у меня настроено логировать долгие запрос. Вот и записалось такое. А всегда ли такая портянка в параметрах, нужно смотреть.

5

По хорошему нам нужен журнал работы Сервера с отладочной информацией за тот период времени, в который приходит рассматриваемый запрос. Если удастся выявить какую либо закономерность его появления, пожалуйста, включите отладку Сервера, воспроизведите ситуацию, при которой возникает данный запрос и приложите аналогичную выдержку журнала СУБД и журнал работы Сервера с отладочной информацией. После этого отладку модно и даже стоит выключить.

6

Включил логирование. Опросил другой прибор. Тоже самое.

image
image1902×212 7.61 KB

Даже на другой модели прибора.

7

Кажется нам удалось найти причину, по которой в запросе архива ошибок может присутствовать такое большое количество дубликатов идентификаторов точек.

Спасибо за обращение! Мы поставили в план работ исправление данной ошибки. Как только она будет исправлена, обязательно сообщим в каком обновлении будет доступно исправление.

8

Исправление будет доступно в следующей версии 3.65.0.