[MDEV-27391] Event Scheduler after creation is ENABLED in all 3 servers. Created: 2021-12-30  Updated: 2022-09-30  Resolved: 2022-09-30

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.0.38-galera
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Rajaa Krishnamurthy Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: galera
Environment:

Ubunut - 16.04


 Description   

I have configured 3 node Multi Master Galera Cluster in Production, Development, Testing and Stage environments.

Replication is working fine without any issues.

Recently, I had a requirement to create event for which I have created one. Post creation, it behaves differently between production and other non-prod instances.

For production, it's status is ENABLED in all 3 servers
For non-production, it's status is ENABLED only in the place where I create and other servers it has SLAVESIDE_DISABLED.

Can you please help me with the behaviour.

Please find the below script runs across environment.

CREATE DEFINER = `user`@`%` EVENT IF NOT EXISTS `order_event`
 
    ON SCHEDULE EVERY 15 SECOND
 
    STARTS NOW()
 
    ON COMPLETION PRESERVE ENABLE COMMENT 'Dump filtered data'
 
    DO
 
    BEGIN
 
    END



 Comments   
Comment by Jan Lindström (Inactive) [ 2022-09-30 ]

Unfortunately MariaDB 10.0 is EOL and you should upgrade maintained versions. Note that Events should be SLAVESIDE_DISABLED state by default.

Generated at Thu Feb 08 09:52:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.