Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
Bump. Happens with basic Python print logging, too.