{"action":"created","issue":{"url":"https://api.github.com/repos/celery/celery/issues/5048","repository_url":"https://api.github.com/repos/celery/celery","labels_url":"https://api.github.com/repos/celery/celery/issues/5048/labels{/name}","comments_url":"https://api.github.com/repos/celery/celery/issues/5048/comments","events_url":"https://api.github.com/repos/celery/celery/issues/5048/events","html_url":"https://github.com/celery/celery/issues/5048","id":359642329,"node_id":"MDU6SXNzdWUzNTk2NDIzMjk=","number":5048,"title":"You can't execute queries until the end of the 'atomic' block.","user":{"login":"oortega","id":5816015,"node_id":"MDQ6VXNlcjU4MTYwMTU=","avatar_url":"https://avatars0.githubusercontent.com/u/5816015?v=4","gravatar_id":"","url":"https://api.github.com/users/oortega","html_url":"https://github.com/oortega","followers_url":"https://api.github.com/users/oortega/followers","following_url":"https://api.github.com/users/oortega/following{/other_user}","gists_url":"https://api.github.com/users/oortega/gists{/gist_id}","starred_url":"https://api.github.com/users/oortega/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oortega/subscriptions","organizations_url":"https://api.github.com/users/oortega/orgs","repos_url":"https://api.github.com/users/oortega/repos","events_url":"https://api.github.com/users/oortega/events{/privacy}","received_events_url":"https://api.github.com/users/oortega/received_events","type":"User","site_admin":false},"labels":[{"id":46818,"node_id":"MDU6TGFiZWw0NjgxOA==","url":"https://api.github.com/repos/celery/celery/labels/Component:%20Django","name":"Component: Django","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/celery/celery/milestones/20","html_url":"https://github.com/celery/celery/milestone/20","labels_url":"https://api.github.com/repos/celery/celery/milestones/20/labels","id":3359245,"node_id":"MDk6TWlsZXN0b25lMzM1OTI0NQ==","number":20,"title":"v4.3","description":"The last version to support python2","creator":{"login":"thedrow","id":48936,"node_id":"MDQ6VXNlcjQ4OTM2","avatar_url":"https://avatars2.githubusercontent.com/u/48936?v=4","gravatar_id":"","url":"https://api.github.com/users/thedrow","html_url":"https://github.com/thedrow","followers_url":"https://api.github.com/users/thedrow/followers","following_url":"https://api.github.com/users/thedrow/following{/other_user}","gists_url":"https://api.github.com/users/thedrow/gists{/gist_id}","starred_url":"https://api.github.com/users/thedrow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thedrow/subscriptions","organizations_url":"https://api.github.com/users/thedrow/orgs","repos_url":"https://api.github.com/users/thedrow/repos","events_url":"https://api.github.com/users/thedrow/events{/privacy}","received_events_url":"https://api.github.com/users/thedrow/received_events","type":"User","site_admin":false},"open_issues":145,"closed_issues":72,"state":"open","created_at":"2018-05-20T07:51:39Z","updated_at":"2018-10-25T09:23:08Z","due_on":"2018-11-30T08:00:00Z","closed_at":null},"comments":2,"created_at":"2018-09-12T20:35:26Z","updated_at":"2018-10-29T22:51:34Z","closed_at":"2018-10-13T18:45:27Z","author_association":"NONE","body":"## Checklist\r\n\r\n- [ x] I have included the output of ``celery -A proj report`` in the issue.\r\n      (if you are not able to do this, then at least specify the Celery\r\n       version affected).\r\n- [ x] I have verified that the issue exists against the `master` branch of Celery.\r\n\r\n## Steps to reproduce\r\nI think it's when they update or add tasks from django admin\r\nI get this error via sentry\r\n## Expected behavior\r\nUpdate the scheduler without this error.\r\n\r\n## Actual behavior\r\n\r\n```\r\nTransactionManagementError: An error occurred in the current transaction. You can't execute queries until the end of the 'atomic' block.\r\n  File \"django_celery_beat/schedulers.py\", line 216, in schedule_changed\r\n    last, ts = self._last_timestamp, self.Changes.last_change()\r\n  File \"django_celery_beat/models.py\", line 226, in last_change\r\n    return cls.objects.get(ident=1).last_update\r\n  File \"django/db/models/manager.py\", line 85, in manager_method\r\n    return getattr(self.get_queryset(), name)(*args, **kwargs)\r\n  File \"django/db/models/query.py\", line 379, in get\r\n    num = len(clone)\r\n  File \"django/db/models/query.py\", line 238, in __len__\r\n    self._fetch_all()\r\n  File \"django/db/models/query.py\", line 1087, in _fetch_all\r\n    self._result_cache = list(self.iterator())\r\n  File \"django/db/models/query.py\", line 54, in __iter__\r\n    results = compiler.execute_sql()\r\n  File \"django/db/models/sql/compiler.py\", line 835, in execute_sql\r\n    cursor.execute(sql, params)\r\n  File \"django/db/backends/utils.py\", line 59, in execute\r\n    self.db.validate_no_broken_transaction()\r\n  File \"django/db/backends/base/base.py\", line 428, in validate_no_broken_transaction\r\n    \"An error occurred in the current transaction. You can't \"\r\n\r\n```\r\n## Setup\r\namqp==2.3.2\r\nbilliard==3.5.0.4\r\ncelery==4.2.1\r\nDjango==1.10.4\r\ndjango-celery-beat==1.1.1\r\ndjango-celery-results==1.0.1\r\nkombu==4.2.1\r\nvine==1.1.4\r\nredis==2.10.5\r\n\r\nThank you very much, I remain for your comments."},"comment":{"url":"https://api.github.com/repos/celery/celery/issues/comments/434110094","html_url":"https://github.com/celery/celery/issues/5048#issuecomment-434110094","issue_url":"https://api.github.com/repos/celery/celery/issues/5048","id":434110094,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNDExMDA5NA==","user":{"login":"rthille","id":3536582,"node_id":"MDQ6VXNlcjM1MzY1ODI=","avatar_url":"https://avatars2.githubusercontent.com/u/3536582?v=4","gravatar_id":"","url":"https://api.github.com/users/rthille","html_url":"https://github.com/rthille","followers_url":"https://api.github.com/users/rthille/followers","following_url":"https://api.github.com/users/rthille/following{/other_user}","gists_url":"https://api.github.com/users/rthille/gists{/gist_id}","starred_url":"https://api.github.com/users/rthille/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rthille/subscriptions","organizations_url":"https://api.github.com/users/rthille/orgs","repos_url":"https://api.github.com/users/rthille/repos","events_url":"https://api.github.com/users/rthille/events{/privacy}","received_events_url":"https://api.github.com/users/rthille/received_events","type":"User","site_admin":false},"created_at":"2018-10-29T22:51:34Z","updated_at":"2018-10-29T22:51:34Z","author_association":"NONE","body":"@oortega Try what exactly?  Is there a patch/diff I'm missing?"}}
{"actor":{"display_login":"rthille"}}