{"action":"created","issue":{"url":"https://api.github.com/repos/apache/cloudstack/issues/1466","repository_url":"https://api.github.com/repos/apache/cloudstack","labels_url":"https://api.github.com/repos/apache/cloudstack/issues/1466/labels{/name}","comments_url":"https://api.github.com/repos/apache/cloudstack/issues/1466/comments","events_url":"https://api.github.com/repos/apache/cloudstack/issues/1466/events","html_url":"https://github.com/apache/cloudstack/pull/1466","id":146705416,"number":1466,"title":"CLOUDSTACK-9340: General DB Optimization","user":{"login":"nvazquez","id":5295080,"avatar_url":"https://avatars.githubusercontent.com/u/5295080?v=3","gravatar_id":"","url":"https://api.github.com/users/nvazquez","html_url":"https://github.com/nvazquez","followers_url":"https://api.github.com/users/nvazquez/followers","following_url":"https://api.github.com/users/nvazquez/following{/other_user}","gists_url":"https://api.github.com/users/nvazquez/gists{/gist_id}","starred_url":"https://api.github.com/users/nvazquez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvazquez/subscriptions","organizations_url":"https://api.github.com/users/nvazquez/orgs","repos_url":"https://api.github.com/users/nvazquez/repos","events_url":"https://api.github.com/users/nvazquez/events{/privacy}","received_events_url":"https://api.github.com/users/nvazquez/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":27,"created_at":"2016-04-07T18:22:26Z","updated_at":"2016-04-26T18:07:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/cloudstack/pulls/1466","html_url":"https://github.com/apache/cloudstack/pull/1466","diff_url":"https://github.com/apache/cloudstack/pull/1466.diff","patch_url":"https://github.com/apache/cloudstack/pull/1466.patch"},"body":"## Description\r\nIn some production environments there were being experimented delays in most of the jobs. A search for DB optimization was taken and some deficiencies were discovered, we can group them in 4 groups:\r\n* Incorrect PRIMARY key\r\n* Duplicate PRIMARY KEY\r\n* Missing indexes (Add indexes to avoid full table scans)\r\n* Some views query (Change view to improve account retrieval speed)"},"comment":{"url":"https://api.github.com/repos/apache/cloudstack/issues/comments/214831953","html_url":"https://github.com/apache/cloudstack/pull/1466#issuecomment-214831953","issue_url":"https://api.github.com/repos/apache/cloudstack/issues/1466","id":214831953,"user":{"login":"nvazquez","id":5295080,"avatar_url":"https://avatars.githubusercontent.com/u/5295080?v=3","gravatar_id":"","url":"https://api.github.com/users/nvazquez","html_url":"https://github.com/nvazquez","followers_url":"https://api.github.com/users/nvazquez/followers","following_url":"https://api.github.com/users/nvazquez/following{/other_user}","gists_url":"https://api.github.com/users/nvazquez/gists{/gist_id}","starred_url":"https://api.github.com/users/nvazquez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvazquez/subscriptions","organizations_url":"https://api.github.com/users/nvazquez/orgs","repos_url":"https://api.github.com/users/nvazquez/repos","events_url":"https://api.github.com/users/nvazquez/events{/privacy}","received_events_url":"https://api.github.com/users/nvazquez/received_events","type":"User","site_admin":false},"created_at":"2016-04-26T18:07:24Z","updated_at":"2016-04-26T18:07:24Z","body":"@rafaelweingartner @rhtyd @swill I did `push -f` tests start again, I'm getting an error on Travis test due to duplicate field name 'size' in `schema-40to410.sql`, but I added this changes in `schema-481to490.sql`, do you know why is it failing?\r\n\r\n`[ERROR] Failed to execute goal org.codehaus.mojo:exec-maven-plugin:1.2.1:java (create-schema-simulator) on project cloud-developer: An exception occured while executing the Java class. null: InvocationTargetException: Unable to upgrade the database: Unable to execute upgrade script: /home/travis/build/apache/cloudstack/developer/target/db/db/schema-40to410.sql: Duplicate column name 'size' -> [Help 1]`"}}