Message: Purge run ... which started at ... has been cancelled because it was running too long.
Message: Handler for event 'rroad_scheduled_purge' caused SQLSTATE '57014'
Message: Statement interrupted by user - Handler for event 'rroad_scheduled_purge' caused SQLSTATE '57014'
Message: User "DBA" dropped event connection ... ("rroad_scheduled_purge")
Explanation:
Messages like these may appear in the Foxhound diagnostic text file foxhound4_debug.txt:
I. 05/16 08:19:35. User "DBA" dropped event connection 1000011953 ("rroad_scheduled_purge")
E. 05/16 08:19:35. Handler for event 'rroad_scheduled_purge' caused SQLSTATE '57014'
E. 05/16 08:19:35. Statement interrupted by user
|
These messages appear when the Foxhound purge process has run for more than 19 minutes
and is cancelled before the next purge begins at the 20-minute mark.
Your Foxhound database may be getting very large;
see Help - Introduction - Controlling Growth
and How do I shrink the size of the Foxhound database?.
These messages are safe to ignore if your Foxhound database isn't getting too large, and Foxhound performance isn't suffering.
Note that the message "User "DBA" dropped ... rroad_scheduled_purge" has nothing to do with Alert #1 messages.
|