I am utilizing MariaDB 10.3.22 on debian buster; I’ve arrange a question to cleanup some expired person session from a desk; this question ought to run each 15 minutes; the question is appropriate (examined and dealing on one other equivalent DB however based mostly on MySQL) however the begin occasion will not be triggered.
What I checked up to now:
Occasion scheduler is ON
MariaDB [(none)]> present processlist;
+-----+-----------------+-----------+------+---------+-------+-----------------------------+------------------+----------+
| Id | Person | Host | db | Command | Time | State | Information | Progress |
+-----+-----------------+-----------+------+---------+-------+-----------------------------+------------------+----------+
| 1 | system person | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 2 | system person | | NULL | Daemon | NULL | InnoDB purge employee | NULL | 0.000 |
| 3 | system person | | NULL | Daemon | NULL | InnoDB purge employee | NULL | 0.000 |
| 4 | system person | | NULL | Daemon | NULL | InnoDB purge employee | NULL | 0.000 |
| 5 | system person | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 37 | event_scheduler | localhost | NULL | Daemon | 13949 | Ready for subsequent activation | NULL | 0.000 |
| 411 | root | localhost | NULL | Question | 0 | Init | present processlist | 0.000 |
+-----+-----------------+-----------+------+---------+-------+-----------------------------+------------------+----------+
7 rows in set (0.000 sec)
Occasion inserted and enabled
MariaDB [integrity]> present eventsG;
*************************** 1. row ***************************
Db: integrity
Title: DELETE_EXPIRED_SESSIONS
Definer: phpmyadmin@localhost
Time zone: SYSTEM
Sort: RECURRING
Execute at: NULL
Interval worth: 15
Interval area: MINUTE
Begins: 2019-04-10 00:00:00
Ends: NULL
Standing: ENABLED
Originator: 1
character_set_client: utf8mb4
collation_connection: utf8mb4_unicode_ci
Database Collation: utf8mb4_general_ci
1 row in set (0.001 sec)
Occasion question appears to be okay
MariaDB [integrity]> present create occasion delete_expired_sessionsG;
*************************** 1. row ***************************
Occasion: DELETE_EXPIRED_SESSIONS
sql_mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
time_zone: SYSTEM
Create Occasion: CREATE DEFINER=`phpmyadmin`@`localhost` EVENT `DELETE_EXPIRED_SESSIONS` ON SCHEDULE EVERY 15 MINUTE STARTS '2019-04-10 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO DELETE FROM `core_sessions` WHERE `core_sessions`.`expiry` <= NOW()
character_set_client: utf8mb4
collation_connection: utf8mb4_unicode_ci
Database Collation: utf8mb4_general_ci
Different issues to examine?
Thanks for any trace…