Getting a writer already closed warning
info-rchitect
Registered Posts: 198 ✭✭✭✭✭✭
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