Warning: pg_query_params(): Query failed: ERROR: could not read blocks 1333119..1333119 in file "pg_tblspc/16386/PG_17_202406281/16390/2227109570.10": Input/output error
CONTEXT: SQL statement "create temp table __r_lhs as
select
t.firm_id,
t.drugstore_id,
t.drugstore_department_phone,
t.dd_advert_flag_utm::int,
t.drugstore_department_id,
t.medical_product_name_id,
t.medical_product_id,
t.load_hs_inet_href,
t.lhs_name,
t.lhs_vendor_name,
t.lhs_country_name,
t.lhs_id,
t.vendor_id,
t.country_id,
t.load_hs_inet_imagepath,
t.load_hs_shelf_life,
t.delivery_flag::int as load_hs_delivery_flag,
t.delivery_flag::int,
t.firm_delivery_description_href,
case when ac.action_unconditional_flag::int = 1 and t.price_min > t.price_action_min then t.price_action_min else t.price_min end as price_min,
t.price_min as price_simple_min,
t.price_action_min,
t.action_id,
ac.action_name,
ac.action_unconditional_flag::int,
t.date_actual_warning_ in /var/www/site.release/module/Common/src/Common/Model/CommonPGSQL.php on line 254
Error information:
Message: ERROR: could not read blocks 1333119..1333119 in file "pg_tblspc/16386/PG_17_202406281/16390/2227109570.10": Input/output error
CONTEXT: SQL statement "create temp table __r_lhs as
select
t.firm_id,
t.drugstore_id,
t.drugstore_department_phone,
t.dd_advert_flag_utm::int,
t.drugstore_department_id,
t.medical_product_name_id,
t.medical_product_id,
t.load_hs_inet_href,
t.lhs_name,
t.lhs_vendor_name,
t.lhs_country_name,
t.lhs_id,
t.vendor_id,
t.country_id,
t.load_hs_inet_imagepath,
t.load_hs_shelf_life,
t.delivery_flag::int as load_hs_delivery_flag,
t.delivery_flag::int,
t.firm_delivery_description_href,
case when ac.action_unconditional_flag::int = 1 and t.price_min > t.price_action_min then t.price_action_min else t.price_min end as price_min,
t.price_min as price_simple_min,
t.price_action_min,
t.action_id,
ac.action_name,
ac.action_unconditional_flag::int,
t.date_actual_warning_flag::int
from (
select
dd.firm_id,
dd.drugstore_id,
dd.drugstore_department_phone,
dd.dd_advert_flag_utm,
ds_mp.drugstore_department_id,
ds_mp.medical_product_name_id,
ds_mp.medical_product_id,
lhs.load_hs_inet_href,
case when lhs.lhs_name is not null then lhs.lhs_name else mpn.medical_product_name_name || ' ' || mp.medical_product_name end as lhs_name,
lhs.lhs_vendor_name,
lhs.lhs_country_name,
lhs.lhs_id,
null as vendor_id,
null as country_id,
lhs.load_hs_inet_imagepath,
lhs.load_hs_shelf_life,
case when f_da.firm_id is null then 0 else lhs.load_hs_delivery_flag::int end as delivery_flag,
f.firm_delivery_description_href,
min(case when lhs.lhs_name is null then ds_mp.price_min else lhs.load_hs_price_min end) as price_min,
price_round(min(case when lhs.lhs_name is null then ds_mp.price_action_min else lhs.load_hs_price_action end)) as price_action_min,
min(case when lhs.lhs_name is null then ds_mp.action_id else lhs.action_id end) as action_id,
max(cast(ds_mp.date_actual_warning_flag as int)) as date_actual_warning_flag
from
/*(select
ds_mp.*,
row_number() over (partition by
ds_mp.medical_product_name_id,
ds_mp.medical_product_id
order by coalesce(ds_mp.price_action_min, 2000000000) asc) as row_action
from
__pre_dd_mp ds_mp
)*/ __pre_dd_mp ds_mp
inner join medical_product_name mpn on mpn.medical_product_name_id = ds_mp.medical_product_name_id
inner join medical_product mp on mp.medical_product_id = ds_mp.medical_product_id
inner join drugstore_department dd on dd.drugstore_department_id = ds_mp.drugstore_department_id
inner join firm f on f.firm_id = dd.firm_id
left join php_lhs lhs on lhs.mpn_dd_id = ds_mp.mpn_dd_id and lhs.medical_product_id = mp.medical_product_id
left join firm_hs_delivery_area f_da on f_da.firm_id = f.firm_id and f_da.area_id = __area_id
group by
dd.firm_id,
dd.drugstore_id,
dd.drugstore_department_phone,
dd.dd_advert_flag_utm,
ds_mp.drugstore_department_id,
ds_mp.medical_product_name_id,
ds_mp.medical_product_id,
lhs.load_hs_inet_href,
case when lhs.lhs_name is not null then lhs.lhs_name else mpn.medical_product_name_name || ' ' || mp.medical_product_name end,
lhs.lhs_vendor_name,
lhs.lhs_country_name,
lhs.lhs_id,
lhs.load_hs_inet_imagepath,
lhs.load_hs_shelf_life,
case when f_da.firm_id is null then 0 else lhs.load_hs_delivery_flag::int end,
f.firm_delivery_description_href
) t
left join action ac on ac.action_id = t.action_id
order by price_min"
PL/pgSQL function p_get_lp_online_dd_data(integer,integer,integer) line 83 at SQL statement