Well, that doesn't seems to be quite well, alert records get deleted once the alert has been viewed by the users. Maybe you have some configuration issues with how long the error is retained in server.
Once check here :- /admin.php?options/groups/alerts/#alertExpiryDays - Make sure the alert expiry days is less, as alert table doesn't supposed to be that big.