Warning: pg_query_params(): Query failed: FATAL: terminating connection due to administrator command
CONTEXT: SQL statement "create temp table __r_syn as
select
ig1.international_group_latin,
ig2.international_group2_latin,
mpn.medical_product_name_id,
mpn.medical_product_name_latin,
mpn.medical_product_name_name,
mp.medical_product_id,
mp.medical_form_id,
mp.medical_product_latin,
mp.medical_product_name,
mp.medical_product_stat,
case when mp_im.image_cnt > 0 then 1 else 0 end as mp_image_flag,
case when mf_im.image_cnt > 0 then 1 else 0 end as mf_image_flag,
t_d.presence as pres_cnt,
case when t_d.presence > 0 then 1 else 0 end as pres,
case when t_d.price_action_min > 0 and ac.action_unconditional_flag::int > 0 then price_action_min else coalesce(t_d.price_min,10000000) end as sort_price,
case when t_d.price_action_min > 0 and ac.action_unconditional_flag::int > 0 then price_action_min else t_d.price_min end as price_min
from
__t_mpn_m in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 254
Notice: pg_query_params(): Cannot set connection to blocking mode in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 254
Error information:
Message: FATAL: terminating connection due to administrator command
CONTEXT: SQL statement "create temp table __r_syn as
select
ig1.international_group_latin,
ig2.international_group2_latin,
mpn.medical_product_name_id,
mpn.medical_product_name_latin,
mpn.medical_product_name_name,
mp.medical_product_id,
mp.medical_form_id,
mp.medical_product_latin,
mp.medical_product_name,
mp.medical_product_stat,
case when mp_im.image_cnt > 0 then 1 else 0 end as mp_image_flag,
case when mf_im.image_cnt > 0 then 1 else 0 end as mf_image_flag,
t_d.presence as pres_cnt,
case when t_d.presence > 0 then 1 else 0 end as pres,
case when t_d.price_action_min > 0 and ac.action_unconditional_flag::int > 0 then price_action_min else coalesce(t_d.price_min,10000000) end as sort_price,
case when t_d.price_action_min > 0 and ac.action_unconditional_flag::int > 0 then price_action_min else t_d.price_min end as price_min
from
__t_mpn_mp t_mpn_mp
left join __t_d t_d on t_d.medical_product_id = t_mpn_mp.mp_id
inner join medical_product mp on mp.medical_product_id = t_mpn_mp.mp_id
inner join medical_product_name mpn on mpn.medical_product_name_id = t_mpn_mp.mpn_id
inner join international_group2 ig2 on ig2.international_group2_id = mpn.international_group2_id
inner join international_group ig1 on ig1.international_group_id = ig2.international_group_id
left join image mp_im on mp_im.image_size_id = __image_size_mp_id and mp_im.image_type_id = __image_type_mp_id and mp_im.id_value = mp.medical_product_id
left join image mf_im on mf_im.image_size_id = __image_size_mf_id and mf_im.image_type_id = __image_type_mf_id and mf_im.id_value = mp.medical_form_id
left join action ac on ac.action_id = t_d.action_id
order by pres desc, sort_price --medical_product_stat desc
limit __top"
PL/pgSQL function p_get_lp_mp_synonim(integer,integer,integer,integer) line 134 at SQL statement
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.