Springle has submitted this change and it was merged.
Change subject: purge script bug
......................................................................
purge script bug
Change-Id: I7b93df58fdc0e5ac0576f7ae422dff7d7def015a
---
M modules/coredb_mysql/templates/purge_query_digest.sh.erb
1 file changed, 4 insertions(+), 4 deletions(-)
Approvals:
Springle: Verified; Looks good to me, approved
diff --git a/modules/coredb_mysql/templates/purge_query_digest.sh.erb
b/modules/coredb_mysql/templates/purge_query_digest.sh.erb
index 503a733..6a2ab81 100644
--- a/modules/coredb_mysql/templates/purge_query_digest.sh.erb
+++ b/modules/coredb_mysql/templates/purge_query_digest.sh.erb
@@ -6,12 +6,12 @@
digest_host=<%= digest_host %>
digest_slave=<%= digest_slave %>
digest_db=<%= digest_db %>
-mysql_args="-h ${digest_host} -u ${mysql_user} -p${pw} --skip-column-names"
+mysql_args="-h ${digest_host} -u ${mysql_user} -p${pw} -P 3306
--skip-column-names"
for table in $(mysql ${mysql_args} -e 'show tables like "%history"'
${digest_db}); do
+ echo $table
pt-archiver --no-check-charset --primary-key-only --purge \
- --check-slave-lag="h=${digest_host},u=${mysql_user},p=${pw}"
--limit=1000 \
-
--source="h=${digest_host},u=${mysql_user},p=${pw},D=${digest_db},t=${table}" \
+ --check-slave-lag="h=${digest_slave},P=3306,u=${mysql_user},p=${pw}"
--limit=1000 \
+
--source="h=${digest_host},P=3306,u=${mysql_user},p=${pw},D=${digest_db},t=${table}"
\
--where="ts_max < DATE_SUB(NOW(), INTERVAL 4 WEEK)"
- exit
done
--
To view, visit https://gerrit.wikimedia.org/r/82214
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I7b93df58fdc0e5ac0576f7ae422dff7d7def015a
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Springle <[email protected]>
Gerrit-Reviewer: Springle <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
