jenkins-bot has submitted this change and it was merged.

Change subject: Set up SmashPig cron and more tables
......................................................................


Set up SmashPig cron and more tables

Consume the pending queue to db once a minute, requeue and expire
delayed messages, and run Adyen jobs from the Stomp job queue.

Note that the scripts in Schema are idempotent (so far), so we can
run them all to keep up with additions.

Change-Id: Icfd3890c356fcb5acafa87012abc8643442e2888
---
M puppet/modules/smashpig/manifests/init.pp
A puppet/modules/smashpig/templates/SmashPig.cron.d.erb
2 files changed, 15 insertions(+), 2 deletions(-)

Approvals:
  Awight: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/puppet/modules/smashpig/manifests/init.pp 
b/puppet/modules/smashpig/manifests/init.pp
index 222fc63..b86c9af 100644
--- a/puppet/modules/smashpig/manifests/init.pp
+++ b/puppet/modules/smashpig/manifests/init.pp
@@ -50,11 +50,18 @@
     mysql::db { 'smashpig': }
 
     exec { 'smashpig_schema':
-        command => "/usr/bin/mysql -uroot -p${mysql::root_password} smashpig 
-qfsA < ${dir}/Schema/001_CreatePendingTable.sql",
-        unless  => "/usr/bin/mysql -uroot -p${mysql::root_password} smashpig 
-qfsANe \"select 1 from smashpig.pending\" | /usr/bin/tail -1 | /bin/grep -q 1",
+        command => "cat ${dir}/Schema/mysql/*.sql | /usr/bin/mysql -uroot 
-p${mysql::root_password} smashpig -qfsA",
         require => [
             Git::Clone['wikimedia/fundraising/SmashPig'],
             Mysql::Db['smashpig'],
         ],
     }
+
+    file { '/etc/cron.d/SmashPig':
+        content => template('smashpig/SmashPig.cron.d.erb'),
+        owner  => 'root',
+        group  => 'root',
+        mode   => '0644'
+    }
+
 }
diff --git a/puppet/modules/smashpig/templates/SmashPig.cron.d.erb 
b/puppet/modules/smashpig/templates/SmashPig.cron.d.erb
new file mode 100644
index 0000000..d22e4b3
--- /dev/null
+++ b/puppet/modules/smashpig/templates/SmashPig.cron.d.erb
@@ -0,0 +1,6 @@
+# Consume the pending queue to a database once every minute
+* * * * *      www-data        php <%= scope.lookupvar('smashpig::dir') 
%>/Maintenance/ConsumePendingQueue.php
+# Requeue delayed messages that are due for reprocessing
+2-52/10 * * * *        www-data        php <%= 
scope.lookupvar('smashpig::dir') %>/Maintenance/RequeueDelayedMessages.php
+# Run jobs to process Adyen IPN messages
+4-59/5 * * * * www-data        php <%= scope.lookupvar('smashpig::dir') 
%>/Maintenance/StompJobRunner.php --config-node adyen

-- 
To view, visit https://gerrit.wikimedia.org/r/309221
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: Icfd3890c356fcb5acafa87012abc8643442e2888
Gerrit-PatchSet: 3
Gerrit-Project: mediawiki/vagrant
Gerrit-Branch: master
Gerrit-Owner: Ejegg <eeggles...@wikimedia.org>
Gerrit-Reviewer: Awight <awi...@wikimedia.org>
Gerrit-Reviewer: BryanDavis <bda...@wikimedia.org>
Gerrit-Reviewer: Cdentinger <cdentin...@wikimedia.org>
Gerrit-Reviewer: Dduvall <dduv...@wikimedia.org>
Gerrit-Reviewer: Ejegg <eeggles...@wikimedia.org>
Gerrit-Reviewer: XenoRyet <dkozlow...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to