[2026-07-30 00:30:03] local.INFO: Run start {"mode":"LIVE","thresholds":[180,365,547,730,1095]} 
[2026-07-30 00:30:03] local.INFO: Threshold start {"days":180,"dry_run":false} 
[2026-07-30 00:30:09] local.INFO: S1 done {"days":180,"count":0,"dry_run":false} 
[2026-07-30 00:30:10] local.INFO: S2 done {"days":180,"count":103052,"dry_run":false} 
[2026-07-30 00:30:11] local.INFO: S3 done {"days":180,"count":25282,"dry_run":false} 
[2026-07-30 00:30:11] local.INFO: S4 done {"days":180,"count":2406,"dry_run":false} 
[2026-07-30 00:30:11] local.INFO: Threshold complete {"days":180,"stats":{"s1_seeds":0,"s2_reset":103052,"s3_partslink_agg":25282,"s4_partnum_agg":2406,"errors":0}} 
[2026-07-30 00:30:11] local.INFO: Threshold start {"days":365,"dry_run":false} 
[2026-07-30 00:30:18] local.INFO: S1 done {"days":365,"count":0,"dry_run":false} 
[2026-07-30 00:30:19] local.INFO: S2 done {"days":365,"count":103054,"dry_run":false} 
[2026-07-30 00:30:21] local.INFO: S3 done {"days":365,"count":40188,"dry_run":false} 
[2026-07-30 00:30:22] local.INFO: S4 done {"days":365,"count":5020,"dry_run":false} 
[2026-07-30 00:30:22] local.INFO: Threshold complete {"days":365,"stats":{"s1_seeds":0,"s2_reset":103054,"s3_partslink_agg":40188,"s4_partnum_agg":5020,"errors":0}} 
[2026-07-30 00:30:22] local.INFO: Threshold start {"days":547,"dry_run":false} 
[2026-07-30 00:30:28] local.INFO: S1 done {"days":547,"count":0,"dry_run":false} 
[2026-07-30 00:30:28] local.INFO: S2 done {"days":547,"count":103055,"dry_run":false} 
[2026-07-30 00:30:31] local.INFO: S3 done {"days":547,"count":53558,"dry_run":false} 
[2026-07-30 00:30:32] local.INFO: S4 done {"days":547,"count":8000,"dry_run":false} 
[2026-07-30 00:30:32] local.INFO: Threshold complete {"days":547,"stats":{"s1_seeds":0,"s2_reset":103055,"s3_partslink_agg":53558,"s4_partnum_agg":8000,"errors":0}} 
[2026-07-30 00:30:32] local.INFO: Threshold start {"days":730,"dry_run":false} 
[2026-07-30 00:30:37] local.INFO: S1 done {"days":730,"count":0,"dry_run":false} 
[2026-07-30 00:30:38] local.INFO: S2 done {"days":730,"count":103046,"dry_run":false} 
[2026-07-30 00:30:43] local.INFO: S3 done {"days":730,"count":65600,"dry_run":false} 
[2026-07-30 00:30:43] local.ERROR: S4 exception {"days":730,"error":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cnt' cannot be null (Connection: mysql, SQL: INSERT INTO non_selling_items (partslink, cnt, days_limit)
                     SELECT oi.part_num AS partslink, SUM(qty) AS cnt, 730 AS days_limit
                     FROM orders o, orders_items oi
                     WHERE o.order_id = oi.order_id
                       AND o.source IN (1,200,500)
                       AND oi.part_num IS NOT NULL
                       AND oi.part_num REGEXP ^[[:alpha:]]{2}[[:digit:]]{7}[CN]?$
                       AND oi.created_at >= DATE_SUB(NOW(), INTERVAL 730 DAY)
                     GROUP BY 1
                     ON DUPLICATE KEY UPDATE cnt = cnt + VALUES(cnt), updated_at = NOW())"} 
[2026-07-30 00:30:43] local.INFO: Threshold complete {"days":730,"stats":{"s1_seeds":0,"s2_reset":103046,"s3_partslink_agg":65600,"s4_partnum_agg":0,"errors":1}} 
[2026-07-30 00:30:43] local.INFO: Threshold start {"days":1095,"dry_run":false} 
[2026-07-30 00:30:49] local.INFO: S1 done {"days":1095,"count":0,"dry_run":false} 
[2026-07-30 00:30:50] local.INFO: S2 done {"days":1095,"count":103049,"dry_run":false} 
[2026-07-30 00:30:53] local.INFO: S3 done {"days":1095,"count":86032,"dry_run":false} 
[2026-07-30 00:30:54] local.ERROR: S4 exception {"days":1095,"error":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'cnt' cannot be null (Connection: mysql, SQL: INSERT INTO non_selling_items (partslink, cnt, days_limit)
                     SELECT oi.part_num AS partslink, SUM(qty) AS cnt, 1095 AS days_limit
                     FROM orders o, orders_items oi
                     WHERE o.order_id = oi.order_id
                       AND o.source IN (1,200,500)
                       AND oi.part_num IS NOT NULL
                       AND oi.part_num REGEXP ^[[:alpha:]]{2}[[:digit:]]{7}[CN]?$
                       AND oi.created_at >= DATE_SUB(NOW(), INTERVAL 1095 DAY)
                     GROUP BY 1
                     ON DUPLICATE KEY UPDATE cnt = cnt + VALUES(cnt), updated_at = NOW())"} 
[2026-07-30 00:30:54] local.INFO: Threshold complete {"days":1095,"stats":{"s1_seeds":0,"s2_reset":103049,"s3_partslink_agg":86032,"s4_partnum_agg":0,"errors":1}} 
[2026-07-30 00:30:54] local.INFO: Run complete {"mode":"LIVE","per_threshold":{"180":{"s1_seeds":0,"s2_reset":103052,"s3_partslink_agg":25282,"s4_partnum_agg":2406,"errors":0},"365":{"s1_seeds":0,"s2_reset":103054,"s3_partslink_agg":40188,"s4_partnum_agg":5020,"errors":0},"547":{"s1_seeds":0,"s2_reset":103055,"s3_partslink_agg":53558,"s4_partnum_agg":8000,"errors":0},"730":{"s1_seeds":0,"s2_reset":103046,"s3_partslink_agg":65600,"s4_partnum_agg":0,"errors":1},"1095":{"s1_seeds":0,"s2_reset":103049,"s3_partslink_agg":86032,"s4_partnum_agg":0,"errors":1}}}