Getting a writer already closed warning

info-rchitect
info-rchitect Registered Posts: 188 ✭✭✭✭✭✭
edited July 16 in General Discussion

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

Setup Info
    Tags
      Help me…