Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

Hi,
I have several managed MySQL databases and I have set up several event scheduler jobs for maintenance.
None of the scheduled events run correctly and I see errors in the “Logs & Queries” DigitalOcean dashboard, such as:
2022-06-15T16:00:00.146988Z 30638863 [ERROR] [MY-010045] [Server] Event Scheduler: [doadmin@%][packpilot.cleanup_disabled_trips3] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘“cleanup_disabled_trips3”() SQL SECURITY INVOKER delete from trip where enabled=’ at line 1
When I run the exact same Query statement when connected to the database, it runs correctly.
Here is the create event statement:
create event `cleanup_disabled_trips3` ON SCHEDULE EVERY 1 DAY STARTS '2022-06-15 16:00:00' DO
delete from trip where enabled=0 and userID<>3
AND (trip.lastupdate) < DATE_SUB(NOW(), INTERVAL 15 Day);
What I am doing wrong?
hbarnard
keneucker
keneucker
rich
santoshpatil
Aspiresoftserv
Yakin
Thejaswini-Rao-U
775c69c916d345a7a367d867078ccb
mayricoak
ndam
bc2f52583874402a988f587c00195d