Github user nvazquez commented on the pull request:
https://github.com/apache/cloudstack/pull/1466#issuecomment-215529568
@rhtyd @rafaelweingartner I could discover the problem by deleting `cloud`
and `cloud_usage` database, then `cloudstack-databases-setup` to create them
blank and restarting CS to create schemas. Error was whis:
````
2016-04-27 08:35:19,850 ERROR [utils.db.ScriptRunner] (main:null) Error
executing: ALTER TABLE `cloud`.`remote_access_vpn` DROP INDEX `id`
2016-04-27 08:35:19,851 ERROR [utils.db.ScriptRunner] (main:null)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect table
definition; there can be only one auto column and it must be defined as a key
````
That shouldn't be a problem because in `schema-410to420-cleanup.sql` it was:
````
ALTER TABLE `cloud`.`remote_access_vpn` DROP primary key;
ALTER TABLE `cloud`.`remote_access_vpn` ADD primary key (`id`);
````
However, it was noticed that `schemaXXXtoYYY-cleanup.sql` files hadn't been
executed before the failure, so it was decided to move some sentences from
`schema-481to490.sql` to `schema-481to490-cleanup.sql` so they can be executed
after all `schemaXXXtoYYY.sql` files, it succeeded.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
