Jcrespo has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/377484 )
Change subject: mariadb: Fix typo on view creation query (missing `)
......................................................................
mariadb: Fix typo on view creation query (missing `)
Followup to gerrit: 377480
Change-Id: I7cc8259505256ba9fcb4f787e66cbc88ba650ae2
---
M modules/role/files/labs/db/views/heartbeat-views.sql
1 file changed, 2 insertions(+), 3 deletions(-)
Approvals:
jenkins-bot: Verified
Jcrespo: Looks good to me, approved
diff --git a/modules/role/files/labs/db/views/heartbeat-views.sql
b/modules/role/files/labs/db/views/heartbeat-views.sql
index 476b929..bcf462c 100644
--- a/modules/role/files/labs/db/views/heartbeat-views.sql
+++ b/modules/role/files/labs/db/views/heartbeat-views.sql
@@ -5,9 +5,8 @@
CREATE OR REPLACE
ALGORITHM=UNDEFINED
DEFINER=`root`@`localhost`
-SQL SECURITY DEFINER VIEW
-`heartbeat_p`.`heartbeat` AS
-SELECT shard` AS `shard`,
+SQL SECURITY DEFINER VIEW `heartbeat_p`.`heartbeat` AS
+SELECT `shard` AS `shard`,
max(`heartbeat`.`heartbeat`.`ts`) AS `last_updated`,
greatest(timestampdiff(MICROSECOND, max(`heartbeat`.`heartbeat`.`ts`),
utc_timestamp()), 0)/1000.0 AS `lag`
FROM `heartbeat`.`heartbeat`
--
To view, visit https://gerrit.wikimedia.org/r/377484
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I7cc8259505256ba9fcb4f787e66cbc88ba650ae2
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Giuseppe Lavagetto <glavage...@wikimedia.org>
Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
