{"action":"created","comment":{"url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/comments/58414963","id":58414963,"diff_hunk":"@@ -0,0 +1,25 @@\n+﻿using System;\n+using System.Configuration;\n+using Common.Logging;\n+using Druq.Framework;\n+\n+namespace Druq.Hub.Queuing\n+{\n+    public class PartitionMaintenanceSettings : ISettings\n+    {\n+        private static readonly ILog Log = LogManager.GetLogger(typeof(PartitionMaintenanceSettings));\n+        public int EnqueueBatchSize { get; set; }\n+\n+        public PartitionMaintenanceSettings()\n+        {\n+            var defaultEnqueueBatchSize = 500;","path":"Druq.Hub/Queuing/PartitionMaintenanceSettings.cs","position":15,"original_position":15,"commit_id":"fbba5f854e6ee90c5093ce32f5fb7cdee26f99a6","original_commit_id":"fbba5f854e6ee90c5093ce32f5fb7cdee26f99a6","user":{"login":"srobaudo","id":7291751,"avatar_url":"https://avatars.githubusercontent.com/u/7291751?v=3","gravatar_id":"","url":"https://api.github.com/users/srobaudo","html_url":"https://github.com/srobaudo","followers_url":"https://api.github.com/users/srobaudo/followers","following_url":"https://api.github.com/users/srobaudo/following{/other_user}","gists_url":"https://api.github.com/users/srobaudo/gists{/gist_id}","starred_url":"https://api.github.com/users/srobaudo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srobaudo/subscriptions","organizations_url":"https://api.github.com/users/srobaudo/orgs","repos_url":"https://api.github.com/users/srobaudo/repos","events_url":"https://api.github.com/users/srobaudo/events{/privacy}","received_events_url":"https://api.github.com/users/srobaudo/received_events","type":"User","site_admin":false},"body":"have we tested this batch size? isn't it too large?","created_at":"2016-04-04T17:36:05Z","updated_at":"2016-04-04T17:36:05Z","html_url":"https://github.com/daptiv/Daptiv.Bus/pull/103#discussion_r58414963","pull_request_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103","_links":{"self":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/comments/58414963"},"html":{"href":"https://github.com/daptiv/Daptiv.Bus/pull/103#discussion_r58414963"},"pull_request":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103"}}},"pull_request":{"url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103","id":65168654,"html_url":"https://github.com/daptiv/Daptiv.Bus/pull/103","diff_url":"https://github.com/daptiv/Daptiv.Bus/pull/103.diff","patch_url":"https://github.com/daptiv/Daptiv.Bus/pull/103.patch","issue_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/103","number":103,"state":"open","locked":false,"title":"115020 event processor not processing","user":{"login":"SQLBob","id":746610,"avatar_url":"https://avatars.githubusercontent.com/u/746610?v=3","gravatar_id":"","url":"https://api.github.com/users/SQLBob","html_url":"https://github.com/SQLBob","followers_url":"https://api.github.com/users/SQLBob/followers","following_url":"https://api.github.com/users/SQLBob/following{/other_user}","gists_url":"https://api.github.com/users/SQLBob/gists{/gist_id}","starred_url":"https://api.github.com/users/SQLBob/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SQLBob/subscriptions","organizations_url":"https://api.github.com/users/SQLBob/orgs","repos_url":"https://api.github.com/users/SQLBob/repos","events_url":"https://api.github.com/users/SQLBob/events{/privacy}","received_events_url":"https://api.github.com/users/SQLBob/received_events","type":"User","site_admin":false},"body":"#### NNIT A/S - Prod EU - Event Processor isn't processing records\r\n\r\nAcceptance criteria:\r\n1. A configurable application config key to allow the adjustment of the SQL COMMAND (not connection) timeout value to allow slow queries to take longer. A config file default of 60, 90, or 120 seconds would be acceptable as a place holder value.\r\nResolution: Added appsetting for CommandTimeoutInSeconds\r\n\r\n2. A new index on the 'CreatedOn' column of the druq_messagesubscriber table should be added as a new migration. The impact is almost non-existent on small (normal) tables, but adds immense value on the table during massive workload events.\r\nResolution: Updated clustering and indexes\r\n\r\n3. A document procedure on how to restart the DRUQ workflow for a given enterprise (not to be confused with \"how to restart the Event Processor service\") to get it to begin working old records that have never reached a 'finished' state.\r\nResolution: DRUQ automatically tries to process messages.  The query was timing out so the processed failed.  Configurable timeout and number of messages to process at one time gives us more control to avoid the timeout.\r\n\r\n#### Pre-PR Checklist\r\n- [x] Branch is from the Release branch\r\n- [x] Story is not tagged as _**NotCD**_\r\n\r\n#### Code Review\r\n- [ ] @hernandezgustavo or @srobaudo or @bscown \r\n\r\n#### Testing\r\n- [ ] [Teamcity tests pass](http://teamcity.hq.daptiv.com/project.html?projectId=PpmFeatureBranches&branch_PpmFeatureBranches=115020-Event-Processor-Not-Processing-ppm&tab=buildTypeStatusDiv)\r\n- [ ] @fbrochado\r\n\r\n#### Additional Requirements\r\n- [ ] [Feature is dev complete](http://daptiv.tpondemand.com/entity/115020)\r\n- [ ] [Database changes are backwards compatible](https://docs.google.com/document/d/1i4vl8TR34ec-rFaiFwe2A-ZcKwGcxriRIU8gBcvF9sw/edit#)\r\n- [ ] All other repositories contain changes that are \"safe/backwards compatible\" for Release branch\r\n\r\n#### :warning: CD Deployment Requirements :warning:\r\n- [ ] [Merge RELEASE to Branch --> merge PR](https://github.com/daptiv/Ppm/compare/release...115020-Event-Processor-Not-Processing-ppm)\r\n- [ ] Change documented\r\n- [ ] Notification of deployment to CPC_SEA_DEV_CD\r\n- [ ] [CD Steps to upper tiers] (https://sites.google.com/a/daptiv.com/portal/Daptiv-Engineering-Wiki/sdlc/code-handoff-process#TOC-Hotfix-Handoff-to-Release-Branch---CD)\r\n- [ ] Merge MASTER to Branch\r\n\t- [ ] [Create new PR for master] (https://github.com/daptiv/Ppm/compare/master...115020-Event-Processor-Not-Processing-ppm)\r\n\t\t- [ ] [Master tests pass before merging] (http://teamcity.hq.daptiv.com/project.html?projectId=PpmMaster&tab=projectOverview&branch_PpmMaster=<default>)\r\n","created_at":"2016-04-04T15:54:12Z","updated_at":"2016-04-04T17:36:06Z","closed_at":null,"merged_at":null,"merge_commit_sha":"590784a61a27ed7e7f3ba6691b7b521528ce80ad","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103/commits","review_comments_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103/comments","review_comment_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/comments{/number}","comments_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/103/comments","statuses_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/statuses/fbba5f854e6ee90c5093ce32f5fb7cdee26f99a6","head":{"label":"daptiv:115020-Event-Processor-Not-Processing","ref":"115020-Event-Processor-Not-Processing","sha":"fbba5f854e6ee90c5093ce32f5fb7cdee26f99a6","user":{"login":"daptiv","id":601501,"avatar_url":"https://avatars.githubusercontent.com/u/601501?v=3","gravatar_id":"","url":"https://api.github.com/users/daptiv","html_url":"https://github.com/daptiv","followers_url":"https://api.github.com/users/daptiv/followers","following_url":"https://api.github.com/users/daptiv/following{/other_user}","gists_url":"https://api.github.com/users/daptiv/gists{/gist_id}","starred_url":"https://api.github.com/users/daptiv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daptiv/subscriptions","organizations_url":"https://api.github.com/users/daptiv/orgs","repos_url":"https://api.github.com/users/daptiv/repos","events_url":"https://api.github.com/users/daptiv/events{/privacy}","received_events_url":"https://api.github.com/users/daptiv/received_events","type":"Organization","site_admin":false},"repo":{"id":17488097,"name":"Daptiv.Bus","full_name":"daptiv/Daptiv.Bus","owner":{"login":"daptiv","id":601501,"avatar_url":"https://avatars.githubusercontent.com/u/601501?v=3","gravatar_id":"","url":"https://api.github.com/users/daptiv","html_url":"https://github.com/daptiv","followers_url":"https://api.github.com/users/daptiv/followers","following_url":"https://api.github.com/users/daptiv/following{/other_user}","gists_url":"https://api.github.com/users/daptiv/gists{/gist_id}","starred_url":"https://api.github.com/users/daptiv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daptiv/subscriptions","organizations_url":"https://api.github.com/users/daptiv/orgs","repos_url":"https://api.github.com/users/daptiv/repos","events_url":"https://api.github.com/users/daptiv/events{/privacy}","received_events_url":"https://api.github.com/users/daptiv/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/daptiv/Daptiv.Bus","description":"Temporary message bus until we can get resources for a real message bus","fork":false,"url":"https://api.github.com/repos/daptiv/Daptiv.Bus","forks_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/forks","keys_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/keys{/key_id}","collaborators_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/teams","hooks_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/hooks","issue_events_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/events{/number}","events_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/events","assignees_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/assignees{/user}","branches_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/branches{/branch}","tags_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/tags","blobs_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/refs{/sha}","trees_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/trees{/sha}","statuses_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/statuses/{sha}","languages_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/languages","stargazers_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/stargazers","contributors_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/contributors","subscribers_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/subscribers","subscription_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/subscription","commits_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/commits{/sha}","git_commits_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/commits{/sha}","comments_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/comments{/number}","issue_comment_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/comments{/number}","contents_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/contents/{+path}","compare_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/compare/{base}...{head}","merges_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/merges","archive_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/downloads","issues_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues{/number}","pulls_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls{/number}","milestones_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/milestones{/number}","notifications_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/labels{/name}","releases_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/releases{/id}","deployments_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/deployments","created_at":"2014-03-06T18:32:04Z","updated_at":"2015-05-21T07:15:37Z","pushed_at":"2016-04-04T15:54:13Z","git_url":"git://github.com/daptiv/Daptiv.Bus.git","ssh_url":"git@github.com:daptiv/Daptiv.Bus.git","clone_url":"https://github.com/daptiv/Daptiv.Bus.git","svn_url":"https://github.com/daptiv/Daptiv.Bus","homepage":null,"size":12787,"stargazers_count":2,"watchers_count":2,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":6,"forks":0,"open_issues":6,"watchers":2,"default_branch":"master"}},"base":{"label":"daptiv:master","ref":"master","sha":"3e503f91fbab899a8778b5c2003c00c847fb8f1e","user":{"login":"daptiv","id":601501,"avatar_url":"https://avatars.githubusercontent.com/u/601501?v=3","gravatar_id":"","url":"https://api.github.com/users/daptiv","html_url":"https://github.com/daptiv","followers_url":"https://api.github.com/users/daptiv/followers","following_url":"https://api.github.com/users/daptiv/following{/other_user}","gists_url":"https://api.github.com/users/daptiv/gists{/gist_id}","starred_url":"https://api.github.com/users/daptiv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daptiv/subscriptions","organizations_url":"https://api.github.com/users/daptiv/orgs","repos_url":"https://api.github.com/users/daptiv/repos","events_url":"https://api.github.com/users/daptiv/events{/privacy}","received_events_url":"https://api.github.com/users/daptiv/received_events","type":"Organization","site_admin":false},"repo":{"id":17488097,"name":"Daptiv.Bus","full_name":"daptiv/Daptiv.Bus","owner":{"login":"daptiv","id":601501,"avatar_url":"https://avatars.githubusercontent.com/u/601501?v=3","gravatar_id":"","url":"https://api.github.com/users/daptiv","html_url":"https://github.com/daptiv","followers_url":"https://api.github.com/users/daptiv/followers","following_url":"https://api.github.com/users/daptiv/following{/other_user}","gists_url":"https://api.github.com/users/daptiv/gists{/gist_id}","starred_url":"https://api.github.com/users/daptiv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daptiv/subscriptions","organizations_url":"https://api.github.com/users/daptiv/orgs","repos_url":"https://api.github.com/users/daptiv/repos","events_url":"https://api.github.com/users/daptiv/events{/privacy}","received_events_url":"https://api.github.com/users/daptiv/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/daptiv/Daptiv.Bus","description":"Temporary message bus until we can get resources for a real message bus","fork":false,"url":"https://api.github.com/repos/daptiv/Daptiv.Bus","forks_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/forks","keys_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/keys{/key_id}","collaborators_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/teams","hooks_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/hooks","issue_events_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/events{/number}","events_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/events","assignees_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/assignees{/user}","branches_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/branches{/branch}","tags_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/tags","blobs_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/refs{/sha}","trees_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/trees{/sha}","statuses_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/statuses/{sha}","languages_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/languages","stargazers_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/stargazers","contributors_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/contributors","subscribers_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/subscribers","subscription_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/subscription","commits_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/commits{/sha}","git_commits_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/git/commits{/sha}","comments_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/comments{/number}","issue_comment_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/comments{/number}","contents_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/contents/{+path}","compare_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/compare/{base}...{head}","merges_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/merges","archive_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/downloads","issues_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues{/number}","pulls_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls{/number}","milestones_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/milestones{/number}","notifications_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/labels{/name}","releases_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/releases{/id}","deployments_url":"https://api.github.com/repos/daptiv/Daptiv.Bus/deployments","created_at":"2014-03-06T18:32:04Z","updated_at":"2015-05-21T07:15:37Z","pushed_at":"2016-04-04T15:54:13Z","git_url":"git://github.com/daptiv/Daptiv.Bus.git","ssh_url":"git@github.com:daptiv/Daptiv.Bus.git","clone_url":"https://github.com/daptiv/Daptiv.Bus.git","svn_url":"https://github.com/daptiv/Daptiv.Bus","homepage":null,"size":12787,"stargazers_count":2,"watchers_count":2,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":6,"forks":0,"open_issues":6,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103"},"html":{"href":"https://github.com/daptiv/Daptiv.Bus/pull/103"},"issue":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/103"},"comments":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/issues/103/comments"},"review_comments":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103/comments"},"review_comment":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/pulls/103/commits"},"statuses":{"href":"https://api.github.com/repos/daptiv/Daptiv.Bus/statuses/fbba5f854e6ee90c5093ce32f5fb7cdee26f99a6"}}}}