{"action":"created","issue":{"url":"https://api.github.com/repos/RWTH-i5-IDSG/steve/issues/94","repository_url":"https://api.github.com/repos/RWTH-i5-IDSG/steve","labels_url":"https://api.github.com/repos/RWTH-i5-IDSG/steve/issues/94/labels{/name}","comments_url":"https://api.github.com/repos/RWTH-i5-IDSG/steve/issues/94/comments","events_url":"https://api.github.com/repos/RWTH-i5-IDSG/steve/issues/94/events","html_url":"https://github.com/RWTH-i5-IDSG/steve/issues/94","id":387102627,"node_id":"MDU6SXNzdWUzODcxMDI2Mjc=","number":94,"title":"How to kill a zombie transaction?","user":{"login":"chuck-h","id":2141014,"node_id":"MDQ6VXNlcjIxNDEwMTQ=","avatar_url":"https://avatars3.githubusercontent.com/u/2141014?v=4","gravatar_id":"","url":"https://api.github.com/users/chuck-h","html_url":"https://github.com/chuck-h","followers_url":"https://api.github.com/users/chuck-h/followers","following_url":"https://api.github.com/users/chuck-h/following{/other_user}","gists_url":"https://api.github.com/users/chuck-h/gists{/gist_id}","starred_url":"https://api.github.com/users/chuck-h/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chuck-h/subscriptions","organizations_url":"https://api.github.com/users/chuck-h/orgs","repos_url":"https://api.github.com/users/chuck-h/repos","events_url":"https://api.github.com/users/chuck-h/events{/privacy}","received_events_url":"https://api.github.com/users/chuck-h/received_events","type":"User","site_admin":false},"labels":[{"id":323087553,"node_id":"MDU6TGFiZWwzMjMwODc1NTM=","url":"https://api.github.com/repos/RWTH-i5-IDSG/steve/labels/feature%20request","name":"feature request","color":"009800","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2018-12-04T03:22:00Z","updated_at":"2018-12-09T14:10:14Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"I have an old \"ghost\" transaction in my database which was never correctly terminated. Is there, or can there be, a UI method for cleanly terminating it?"},"comment":{"url":"https://api.github.com/repos/RWTH-i5-IDSG/steve/issues/comments/445541324","html_url":"https://github.com/RWTH-i5-IDSG/steve/issues/94#issuecomment-445541324","issue_url":"https://api.github.com/repos/RWTH-i5-IDSG/steve/issues/94","id":445541324,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NTU0MTMyNA==","user":{"login":"goekay","id":3861031,"node_id":"MDQ6VXNlcjM4NjEwMzE=","avatar_url":"https://avatars0.githubusercontent.com/u/3861031?v=4","gravatar_id":"","url":"https://api.github.com/users/goekay","html_url":"https://github.com/goekay","followers_url":"https://api.github.com/users/goekay/followers","following_url":"https://api.github.com/users/goekay/following{/other_user}","gists_url":"https://api.github.com/users/goekay/gists{/gist_id}","starred_url":"https://api.github.com/users/goekay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/goekay/subscriptions","organizations_url":"https://api.github.com/users/goekay/orgs","repos_url":"https://api.github.com/users/goekay/repos","events_url":"https://api.github.com/users/goekay/events{/privacy}","received_events_url":"https://api.github.com/users/goekay/received_events","type":"User","site_admin":false},"created_at":"2018-12-09T14:10:14Z","updated_at":"2018-12-09T14:10:14Z","author_association":"MEMBER","body":"@chuck-h thanks, this is a good idea. i will take this further and split `transaction` table into two: `transaction_start` and `transaction_stop`. by doing this, the tables will just write timestamped events as in `connector_meter_value` and `connector_status`. this will make reading logic a little bir more complicated, though."}}
{"actor":{"display_login":"goekay"}}