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