{"action":"created","issue":{"url":"https://api.github.com/repos/buildbot/buildbot/issues/2063","repository_url":"https://api.github.com/repos/buildbot/buildbot","labels_url":"https://api.github.com/repos/buildbot/buildbot/issues/2063/labels{/name}","comments_url":"https://api.github.com/repos/buildbot/buildbot/issues/2063/comments","events_url":"https://api.github.com/repos/buildbot/buildbot/issues/2063/events","html_url":"https://github.com/buildbot/buildbot/pull/2063","id":142363278,"number":2063,"title":"model.py: restrict index lengths to 255","user":{"login":"yetanotherion","id":2205232,"avatar_url":"https://avatars.githubusercontent.com/u/2205232?v=3","gravatar_id":"","url":"https://api.github.com/users/yetanotherion","html_url":"https://github.com/yetanotherion","followers_url":"https://api.github.com/users/yetanotherion/followers","following_url":"https://api.github.com/users/yetanotherion/following{/other_user}","gists_url":"https://api.github.com/users/yetanotherion/gists{/gist_id}","starred_url":"https://api.github.com/users/yetanotherion/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yetanotherion/subscriptions","organizations_url":"https://api.github.com/users/yetanotherion/orgs","repos_url":"https://api.github.com/users/yetanotherion/repos","events_url":"https://api.github.com/users/yetanotherion/events{/privacy}","received_events_url":"https://api.github.com/users/yetanotherion/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/buildbot/buildbot/labels/needs%20work","name":"needs work","color":"f7c6c7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2016-03-21T14:21:18Z","updated_at":"2016-03-23T11:26:43Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/buildbot/buildbot/pulls/2063","html_url":"https://github.com/buildbot/buildbot/pull/2063","diff_url":"https://github.com/buildbot/buildbot/pull/2063.diff","patch_url":"https://github.com/buildbot/buildbot/pull/2063.patch"},"body":"mysql/InnoDB tables have a limitation on index size,\r\nregarding string elements.\r\n\r\nhttp://dev.mysql.com/doc/refman/5.7/en/create-index.html\r\n\"...a prefix can be up to 767 bytes long for InnoDB tables...\"\r\n\r\nSome indexed attributes used to overflow that limit\r\non utf8 databases. This commit reduces the length of those\r\nfrom 256 to 255 to fit that constraint."},"comment":{"url":"https://api.github.com/repos/buildbot/buildbot/issues/comments/200303793","html_url":"https://github.com/buildbot/buildbot/pull/2063#issuecomment-200303793","issue_url":"https://api.github.com/repos/buildbot/buildbot/issues/2063","id":200303793,"user":{"login":"yetanotherion","id":2205232,"avatar_url":"https://avatars.githubusercontent.com/u/2205232?v=3","gravatar_id":"","url":"https://api.github.com/users/yetanotherion","html_url":"https://github.com/yetanotherion","followers_url":"https://api.github.com/users/yetanotherion/followers","following_url":"https://api.github.com/users/yetanotherion/following{/other_user}","gists_url":"https://api.github.com/users/yetanotherion/gists{/gist_id}","starred_url":"https://api.github.com/users/yetanotherion/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yetanotherion/subscriptions","organizations_url":"https://api.github.com/users/yetanotherion/orgs","repos_url":"https://api.github.com/users/yetanotherion/repos","events_url":"https://api.github.com/users/yetanotherion/events{/privacy}","received_events_url":"https://api.github.com/users/yetanotherion/received_events","type":"User","site_admin":false},"created_at":"2016-03-23T11:26:43Z","updated_at":"2016-03-23T11:26:43Z","body":"Well, I won't say they didn't help, but I still don't know how the user making \"buildbot upgrade-master\" will see that he needs to change some 'changes, users, object_state having given changeids, objectid, uid' before trying again.\r\n\r\n\r\n\r\n"}}