Submitted patch https://reviews.apache.org/r/20901/ for this. Sorry for the issue
Amogh On 4/30/14 3:22 AM, "Rajesh Battala" <[email protected]> wrote: >I have figure out that root cause. >Murali commit has committed the file with instance_ip column. >(https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=commit;h=09515 >1c98a45022b9759a45c066d8ec815de19e4) >After that again Amogh commit is trying to create the same column. >(https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=commit;h=78c68 >3f5682560deffa405ac76edf23f8e17565d) > >769 ALTER TABLE `cloud`.`load_balancer_vm_map` ADD COLUMN instance_ip >VARCHAR(40); > 770 ALTER TABLE `cloud`.`load_balancer_vm_map` DROP KEY >`load_balancer_id`, ADD UNIQUE KEY load_balancer_id (`load_balancer_id`, >`instance_id`, `instance_ip`); > 771 ALTER TABLE `cloud`.`vpc_offerings` ADD COLUMN >supports_region_level_vpc boolean default false; > 772 ALTER TABLE `cloud`.`network_offerings` ADD COLUMN >supports_streched_l2 boolean default false; > 773 ALTER TABLE `cloud`.`networks` ADD COLUMN streched_l2 boolean >default false; > 774 ALTER TABLE `cloud`.`vpc` ADD COLUMN region_level_vpc boolean >default false; > 775 INSERT INTO `cloud`.`configuration`(category, instance, component, >name, value, description, default_value) VALUES ('Advanced', 'DEFAULT', >'NetworkOrchestrationService', 'router.redundant.vrrp.interval', '1', >'seconds between VRRP broadcast. It would 3 times broadcast fail to >trigger fail-over mechanism of redundant router', '1') ON DUPLICATE KEY >UPDATE category='Advanced'; > 776 INSERT INTO `cloud`.`configuration`(category, instance, component, >name, value, description, default_value) VALUES ('Advanced', 'DEFAULT', >'NetworkOrchestrationService', 'router.aggregation.command.each.timeout', >'3', 'timeout in seconds for each Virtual Router command being >aggregated. The final aggregation command timeout would be determined by >this timeout * commands counts ', '3') ON DUPLICATE KEY UPDATE >category='Advanced'; > 777 ALTER TABLE `cloud`.`load_balancer_vm_map` ADD COLUMN instance_ip >VARCHAR(40); > 778 ALTER TABLE `cloud`.`load_balancer_vm_map` DROP KEY >`load_balancer_id`, ADD UNIQUE KEY load_balancer_id (`load_balancer_id`, >`instance_id`, `instance_ip`) > > > >I can fix this issue and commit the changes. > >Thanks >Rajesh Battala > > >-----Original Message----- >From: Rajesh Battala [mailto:[email protected]] >Sent: Wednesday, April 30, 2014 3:29 PM >To: [email protected] >Subject: db deployment is failing in master branch > >Hi All, > >Deploying DB on master branch is failing. > >========> Processing upgrade: com.cloud.upgrade.DatabaseUpgradeChecker >[WARNING] >java.lang.reflect.InvocationTargetException > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: >57) > at >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm >pl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at >org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297) > at java.lang.Thread.run(Thread.java:722) >Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to >upgrade the database > at >com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.ja >va:352) > at >com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java >:447) > at >com.cloud.upgrade.DatabaseCreator.main(DatabaseCreator.java:222) > ... 6 more >Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to >execute upgrade script: >/home/rajesh/hyperv/developer/target/db/db/schema-430to440.sql > at >com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker. >java:267) > at >com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.ja >va:321) > ... 8 more >Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >Duplicate column name 'instance_ip' > at >com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193) > at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87) > at >com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker. >java:258) > ... 9 more > > >Thanks >Rajesh Battala
