{"action":"created","issue":{"url":"https://api.github.com/repos/django-helpdesk/django-helpdesk/issues/534","repository_url":"https://api.github.com/repos/django-helpdesk/django-helpdesk","labels_url":"https://api.github.com/repos/django-helpdesk/django-helpdesk/issues/534/labels{/name}","comments_url":"https://api.github.com/repos/django-helpdesk/django-helpdesk/issues/534/comments","events_url":"https://api.github.com/repos/django-helpdesk/django-helpdesk/issues/534/events","html_url":"https://github.com/django-helpdesk/django-helpdesk/issues/534","id":245961815,"node_id":"MDU6SXNzdWUyNDU5NjE4MTU=","number":534,"title":"Heroku demo is out of date, and approaching Postgres size limit","user":{"login":"rossp","id":91261,"node_id":"MDQ6VXNlcjkxMjYx","avatar_url":"https://avatars3.githubusercontent.com/u/91261?v=4","gravatar_id":"","url":"https://api.github.com/users/rossp","html_url":"https://github.com/rossp","followers_url":"https://api.github.com/users/rossp/followers","following_url":"https://api.github.com/users/rossp/following{/other_user}","gists_url":"https://api.github.com/users/rossp/gists{/gist_id}","starred_url":"https://api.github.com/users/rossp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rossp/subscriptions","organizations_url":"https://api.github.com/users/rossp/orgs","repos_url":"https://api.github.com/users/rossp/repos","events_url":"https://api.github.com/users/rossp/events{/privacy}","received_events_url":"https://api.github.com/users/rossp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"rossp","id":91261,"node_id":"MDQ6VXNlcjkxMjYx","avatar_url":"https://avatars3.githubusercontent.com/u/91261?v=4","gravatar_id":"","url":"https://api.github.com/users/rossp","html_url":"https://github.com/rossp","followers_url":"https://api.github.com/users/rossp/followers","following_url":"https://api.github.com/users/rossp/following{/other_user}","gists_url":"https://api.github.com/users/rossp/gists{/gist_id}","starred_url":"https://api.github.com/users/rossp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rossp/subscriptions","organizations_url":"https://api.github.com/users/rossp/orgs","repos_url":"https://api.github.com/users/rossp/repos","events_url":"https://api.github.com/users/rossp/events{/privacy}","received_events_url":"https://api.github.com/users/rossp/received_events","type":"User","site_admin":false},"assignees":[{"login":"rossp","id":91261,"node_id":"MDQ6VXNlcjkxMjYx","avatar_url":"https://avatars3.githubusercontent.com/u/91261?v=4","gravatar_id":"","url":"https://api.github.com/users/rossp","html_url":"https://github.com/rossp","followers_url":"https://api.github.com/users/rossp/followers","following_url":"https://api.github.com/users/rossp/following{/other_user}","gists_url":"https://api.github.com/users/rossp/gists{/gist_id}","starred_url":"https://api.github.com/users/rossp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rossp/subscriptions","organizations_url":"https://api.github.com/users/rossp/orgs","repos_url":"https://api.github.com/users/rossp/repos","events_url":"https://api.github.com/users/rossp/events{/privacy}","received_events_url":"https://api.github.com/users/rossp/received_events","type":"User","site_admin":false},{"login":"gwasser","id":4760531,"node_id":"MDQ6VXNlcjQ3NjA1MzE=","avatar_url":"https://avatars3.githubusercontent.com/u/4760531?v=4","gravatar_id":"","url":"https://api.github.com/users/gwasser","html_url":"https://github.com/gwasser","followers_url":"https://api.github.com/users/gwasser/followers","following_url":"https://api.github.com/users/gwasser/following{/other_user}","gists_url":"https://api.github.com/users/gwasser/gists{/gist_id}","starred_url":"https://api.github.com/users/gwasser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gwasser/subscriptions","organizations_url":"https://api.github.com/users/gwasser/orgs","repos_url":"https://api.github.com/users/gwasser/repos","events_url":"https://api.github.com/users/gwasser/events{/privacy}","received_events_url":"https://api.github.com/users/gwasser/received_events","type":"User","site_admin":false}],"milestone":null,"comments":9,"created_at":"2017-07-27T08:20:20Z","updated_at":"2018-06-20T01:47:14Z","closed_at":null,"author_association":"COLLABORATOR","body":"In the project handover I'd forgotten we had an [instance of django-helpdesk hosted on Heroku](https://django-helpdesk-demo.herokuapp.com/). It is likely out of date and needs a refresh. However it is also approaching Heroku's free tier database limit (email copy below).\r\n\r\nWould you like me to clean up the data as-is, or reassign the Heroku app to a current django-helpdesk maintainer? I could possibly update the version of django-helpdesk that the demo is using sometime in the next week or two if you like. \r\n\r\n> From: Heroku Notifications <bot@heroku.com>\r\n> To: ross@rossp.org\r\n> Subject: [Warning] Approaching row limit for hobby-dev database on Heroku app django-helpdesk-demo\r\n> Date: Tue, 25 Jul 2017 18:18:38 +0000\r\n> \r\n> The database HEROKU_POSTGRESQL_CYAN_URL on Heroku app django-helpdesk-demo is approaching its allocated storage capacity.\r\n> \r\n> The database contains 7,149 rows. The Hobby-dev plan allows a maximum of 10,000 rows. If the databases exceeds 10,000 rows then INSERT privileges will be revoked, preventing more data from being written. INSERT privileges are automatically reinstated if rows are removed and the database once again complies with the plan limit."},"comment":{"url":"https://api.github.com/repos/django-helpdesk/django-helpdesk/issues/comments/398598010","html_url":"https://github.com/django-helpdesk/django-helpdesk/issues/534#issuecomment-398598010","issue_url":"https://api.github.com/repos/django-helpdesk/django-helpdesk/issues/534","id":398598010,"node_id":"MDEyOklzc3VlQ29tbWVudDM5ODU5ODAxMA==","user":{"login":"rossp","id":91261,"node_id":"MDQ6VXNlcjkxMjYx","avatar_url":"https://avatars3.githubusercontent.com/u/91261?v=4","gravatar_id":"","url":"https://api.github.com/users/rossp","html_url":"https://github.com/rossp","followers_url":"https://api.github.com/users/rossp/followers","following_url":"https://api.github.com/users/rossp/following{/other_user}","gists_url":"https://api.github.com/users/rossp/gists{/gist_id}","starred_url":"https://api.github.com/users/rossp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rossp/subscriptions","organizations_url":"https://api.github.com/users/rossp/orgs","repos_url":"https://api.github.com/users/rossp/repos","events_url":"https://api.github.com/users/rossp/events{/privacy}","received_events_url":"https://api.github.com/users/rossp/received_events","type":"User","site_admin":false},"created_at":"2018-06-20T01:47:14Z","updated_at":"2018-06-20T01:47:14Z","author_association":"COLLABORATOR","body":"```\r\ndjango-helpdesk-demo::HEROKU_POSTGRESQL_CYAN=> delete from django_session where expire_date < now();\r\nDELETE 6568\r\ndjango-helpdesk-demo::HEROKU_POSTGRESQL_CYAN=> \\q\r\n$ heroku pg | grep Rows\r\nRows:                  816/10000 (In compliance)\r\n```\r\n\r\nIdeally this would be done regularly with the above query or with `manage.py clearsessions`. We can't add the Scheduler addon without adding a credit card, but that seems like a failsafe way to do it. Worst case we can run clearsessions every year or two when this occurs :)"}}
{"actor":{"display_login":"rossp"}}