I made the import of the stored procedure and now it is there. mysql> SHOW PROCEDURE STATUS WHERE Db = 'events'; +--------+------------+-----------+------------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ ...
------------------------------ Davide Mancosu system administartor Tiscali Italia S.p.A. Cagliari ------------------------------
Hi Michael, you are right I have verified that in the DB MySQL there is no store procedure "events.age_events" (command: SHOW PROCEDURE STATUS WHERE Db = 'events'; ). Since the production MySQL DB was installed on a separate VM by loading the backup ...
Davide, Typically speaking, stored procedures in a MySQL database don't simply disappear. If zenactions is unable to age old events, they may not be properly migrated from the event database to the event archive database. I would check the following: ...
hi all, We are using Zenoss 3.1.1 server to monitoring about 300 ip devices. Since that day we get these errors from zenactions process OperationalError: (1305, 'PROCEDURE events.age_events does not exist') 2021-07-26 18:46:04,563 INFO zen.ZenActions: ...