Jcrespo has submitted this change and it was merged.
Change subject: dbtools: explicitly set definer as root@localhost
......................................................................
dbtools: explicitly set definer as root@localhost
Bug: T148790
Change-Id: I16ec080c794ec282c17e18920204305ef9cd112e
---
M dbtools/events_coredb_master.sql
M dbtools/events_coredb_slave.sql
2 files changed, 6 insertions(+), 6 deletions(-)
Approvals:
Jcrespo: Looks good to me, approved
jenkins-bot: Verified
diff --git a/dbtools/events_coredb_master.sql b/dbtools/events_coredb_master.sql
index bad6ae8..6822b91 100644
--- a/dbtools/events_coredb_master.sql
+++ b/dbtools/events_coredb_master.sql
@@ -35,7 +35,7 @@
drop event if exists wmf_master_purge;;
-create event wmf_master_purge
+create definer='root'@'localhost' event wmf_master_purge
on schedule every 15 minute starts date(now())
@@ -55,7 +55,7 @@
drop event if exists wmf_master_wikiuser_sleep;;
-create event wmf_master_wikiuser_sleep
+create definer='root'@'localhost' event wmf_master_wikiuser_sleep
on schedule every 30 second starts date(now()) + interval 5 second
diff --git a/dbtools/events_coredb_slave.sql b/dbtools/events_coredb_slave.sql
index 4331c62..ef72fc0 100644
--- a/dbtools/events_coredb_slave.sql
+++ b/dbtools/events_coredb_slave.sql
@@ -36,7 +36,7 @@
drop event if exists wmf_slave_purge;;
-create event wmf_slave_purge
+create definer='root'@'localhost' event wmf_slave_purge
on schedule every 15 minute starts date(now())
@@ -61,7 +61,7 @@
drop event if exists wmf_slave_wikiuser_slow;;
-create event wmf_slave_wikiuser_slow
+create definer='root'@'localhost' event wmf_slave_wikiuser_slow
on schedule every 30 second starts date(now()) + interval 3 second
@@ -125,7 +125,7 @@
drop event if exists wmf_slave_wikiuser_sleep;;
-create event wmf_slave_wikiuser_sleep
+create definer='root'@'localhost' event wmf_slave_wikiuser_sleep
on schedule every 30 second starts date(now()) + interval 5 second
@@ -184,7 +184,7 @@
drop event if exists wmf_slave_overload;;
-create event wmf_slave_overload
+create definer='root'@'localhost' event wmf_slave_overload
on schedule every 10 second starts date(now()) + interval 1 second
--
To view, visit https://gerrit.wikimedia.org/r/317124
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I16ec080c794ec282c17e18920204305ef9cd112e
Gerrit-PatchSet: 1
Gerrit-Project: operations/software
Gerrit-Branch: master
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Marostegui <maroste...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
