1: Customer records are deleted but related entries in the product_alert_stock table remain.
2: GDPR or privacy modules (like PIP) may remove customers but leave orphaned product alert records.

So cleat the related entries from table product_alert_stock  and To catch these issues early (before they cause errors), configure error notifications for admin users: Store -> Configuration -> Catalog -> Catalog -> Product Alerts Run Settings -> Error Email Recipient