Getting a writer already closed warning
info-rchitect
Registered Posts: 188 ✭✭✭✭✭✭
Operating system used: Windows 10
Hi,
I am getting an 'Writer already closed, cannot write' warning when printing some dynamically generated SQL during recipe debug. Is this expected?
thx
[07:22:13] [INFO] [dku.utils] - Installing debugging signal handler [07:22:13] [INFO] [dku.utils] - {'start_date': '2022-01-01', 'agg': 'median', 'subtest_param_refs': False} [07:22:13] [INFO] [dku.utils] - ['STONES_CCD'] [07:22:13] [INFO] [dku.utils] - create or replace view mydatabase.wafer_agg.myaggtable copy grants as [07:22:13] [INFO] [dku.utils] - with uld_results AS ( [07:22:13] [INFO] [dku.utils] - SELECT DISTINCT DASH_MFG_PROD.PUBLIC.AMD_YEARWEEK(UNIT_START_DATE) as WEEK [07:22:13] [INFO] [dku.utils] - ,unit_event.serial_number [07:22:13] [INFO] [dku.utils] - ,unit_event.master_serial_number [07:22:13] [INFO] [dku.utils] - ,unit_info.wafer_num [07:22:13] [INFO] [dku.utils] - ,concat(split(vendor_scribe, '-')[0], '-', left(split(vendor_scribe, '-')[1], 2)) as vendor_scribe [07:22:13] [INFO] [dku.utils] - ,as_char(split(vendor_scribe, '-')[0]) as root_lot [07:22:13] [INFO] [dku.utils] - ,unit_event.lot_id [07:22:13] [INFO] [dku.utils] - ,equipment_info.mfg_area_name [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.mfg_step_name [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.test_program_name [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.test_program_version [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.test_code [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.product_sub_family [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.opn [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.idv [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.major_die_revision [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.sort_idv [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.part_name [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.product_line [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.die_grade [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.technology_family [07:22:13] [INFO] [dku.utils] - ,runtime_info_with_product_lookup.external_device [07:22:13] [INFO] [dku.utils] - ,unit_event.lot_start_date [07:22:13] [INFO] [dku.utils] - ,unit_event.lot_end_date [07:22:13] [INFO] [dku.utils] - ,unit_event.unit_start_date [07:22:13] [INFO] [dku.utils] - ,unit_event.test_temperature [07:22:13] [INFO] [dku.utils] - ,equipment_info.equipment_id [07:22:13] [INFO] [dku.utils] - ,equipment_info.prober_handler_id [07:22:13] [INFO] [dku.utils] - ,equipment_info.probecard_loadboard_id [07:22:13] [INFO] [dku.utils] - ,unit_event.test_time [07:22:13] [INFO] [dku.utils] - ,unit_bin_event_mv.hard_bin [07:22:13] [INFO] [dku.utils] - ,unit_bin_event_mv.hard_bin_desc [07:22:13] [INFO] [dku.utils] - ,unit_bin_event_mv.soft_bin [07:22:13] [INFO] [dku.utils] - ,unit_bin_event_mv.soft_bin_desc [07:22:13] [INFO] [dku.utils] - ,unit_bin_event_mv.disp_flag [07:22:13] [INFO] [dku.utils] - ,dense_rank() over (partition by mfg_step_name, serial_number order by unit_start_date desc) as rank_desc [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: ,dense_rank() over (partition by mfg_step_name, serial_number order by unit_start_date desc) as rank_desc [07:22:13] [INFO] [dku.utils] - ,dense_rank() over (partition by mfg_step_name, serial_number order by unit_start_date) as rank_asc [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: ,dense_rank() over (partition by mfg_step_name, serial_number order by unit_start_date) as rank_asc [07:22:13] [INFO] [dku.utils] - ,dash_mfg_prod.public.vw_wafer_excursion.list AS EXCURSION_LIST [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: ,dash_mfg_prod.public.vw_wafer_excursion.list AS EXCURSION_LIST [07:22:13] [INFO] [dku.utils] - ,dash_mfg_prod.public.vw_wafer_excursion.tag AS EXCURSION_TAG [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: ,dash_mfg_prod.public.vw_wafer_excursion.tag AS EXCURSION_TAG [07:22:13] [INFO] [dku.utils] - ,dash_mfg_prod.public.vw_wafer_excursion.stage AS EXCURSION_STAGE [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: ,dash_mfg_prod.public.vw_wafer_excursion.stage AS EXCURSION_STAGE [07:22:13] [INFO] [dku.utils] - FROM unit_event [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: FROM unit_event [07:22:13] [INFO] [dku.utils] - JOIN runtime_info_with_product_lookup USING (runtime_key) [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: JOIN runtime_info_with_product_lookup USING (runtime_key) [07:22:13] [INFO] [dku.utils] - JOIN equipment_info USING (equipment_key) [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: JOIN equipment_info USING (equipment_key) [07:22:13] [INFO] [dku.utils] - LEFT OUTER JOIN unit_info USING (serial_number) [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: LEFT OUTER JOIN unit_info USING (serial_number) [07:22:13] [INFO] [dku.utils] - LEFT OUTER JOIN unit_bin_event_mv USING (master_serial_number, unit_start_date) [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: LEFT OUTER JOIN unit_bin_event_mv USING (master_serial_number, unit_start_date) [07:22:13] [INFO] [dku.utils] - LEFT OUTER JOIN dash_mfg_prod.public.vw_wafer_excursion [07:22:13] [WARN] [dku.utils] - Writer already closed, cannot write: LEFT OUTER JOIN dash_mfg_prod.public.vw_wafer_excursion [07:22:13] [INFO] [dku.utils] - ON as_char(split(unit_info.vendor_scribe, '-')[0]) = dash_mfg_prod.public.vw_wafer_excursion.root_lot
Answers
-
Bump. Happens with basic Python print logging, too.
-
Hi, I am also facing the same issue and just wondering if this issue got resolved for you. If so, please tell me how.
Thanks