[
https://issues.apache.org/jira/browse/CLOUDSTACK-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sailaja Mada closed CLOUDSTACK-4380.
------------------------------------
Resolution: Invalid
I had reverted my setup to 307 with wrong DBdump file. I have retested this
scenario. I could not hit this issue now.
I will close the defect as invalid.
Thanks,
Sailaja.M
> [UPGRADE]Upgrade failed from 307 to 4.2 (MySQLSyntaxErrorException: Table
> 'external_nicira_nvp_devices' already exists)
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-4380
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4380
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Upgrade
> Affects Versions: 4.2.0
> Reporter: Sailaja Mada
> Priority: Blocker
> Fix For: 4.2.0
>
> Attachments: newupgissue.rar
>
>
> Steps:
> 1. Tried to upgrade from 307 to 4.2 with Xenserver 2 clusters (xen 602, xen
> 56 fp2)
> 2. This is an adv configuration zone
> Observation:
> Upgrade failed from 307 to 4.2.
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --
> http://www.apache.org/licenses/LICENSE-2.0
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --
> Unless required by applicable law or agreed to in writing,
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --
> software distributed under the License is distributed on an
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- "AS
> IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- KIND,
> either express or implied. See the License for the
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --
> specific language governing permissions and limitations
> 2013-08-17 11:28:12,822 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- under
> the License.
> 2013-08-17 11:28:12,823 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --;
> 2013-08-17 11:28:12,823 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --
> Schema upgrade from 3.0.7 to 4.1.0
> 2013-08-17 11:28:12,823 DEBUG [utils.db.ScriptRunner] (Timer-2:null) --;
> 2013-08-17 11:28:12,823 DEBUG [utils.db.ScriptRunner] (Timer-2:null) -- DB
> upgrade steps from 302-40
> 2013-08-17 11:28:12,824 DEBUG [utils.db.ScriptRunner] (Timer-2:null) CREATE
> TABLE `cloud`.`external_nicira_nvp_devices` ( `id` bigint unsigned NOT NULL
> AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255) UNIQUE,
> `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical
> network in to which nicira nvp device is added', `provider_name`
> varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this
> nicira nvp device', `device_name` varchar(255) NOT NULL COMMENT 'name of
> the nicira nvp device', `host_id` bigint unsigned NOT NULL COMMENT 'host id
> coresponding to the external nicira nvp device', PRIMARY KEY (`id`),
> CONSTRAINT `fk_external_nicira_nvp_devices__host_id` FOREIGN KEY (`host_id`)
> REFERENCES `host`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_external_nicira_nvp_devices__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-08-17 11:28:12,834 ERROR [utils.db.ScriptRunner] (Timer-2:null) Error
> executing: CREATE TABLE `cloud`.`external_nicira_nvp_devices` ( `id` bigint
> unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(255) UNIQUE,
> `physical_network_id` bigint unsigned NOT NULL COMMENT 'id of the physical
> network in to which nicira nvp device is added', `provider_name`
> varchar(255) NOT NULL COMMENT 'Service Provider name corresponding to this
> nicira nvp device', `device_name` varchar(255) NOT NULL COMMENT 'name of
> the nicira nvp device', `host_id` bigint unsigned NOT NULL COMMENT 'host id
> coresponding to the external nicira nvp device', PRIMARY KEY (`id`),
> CONSTRAINT `fk_external_nicira_nvp_devices__host_id` FOREIGN KEY (`host_id`)
> REFERENCES `host`(`id`) ON DELETE CASCADE, CONSTRAINT
> `fk_external_nicira_nvp_devices__physical_network_id` FOREIGN KEY
> (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8
> 2013-08-17 11:28:12,835 ERROR [utils.db.ScriptRunner] (Timer-2:null)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'external_nicira_nvp_devices' already exists
> 2013-08-17 11:28:12,838 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-2:null) Unable to execute upgrade script:
> /usr/share/cloudstack-management/setup/db/schema-307to410.sql
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'external_nicira_nvp_devices' already exists
> 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:237)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:298)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:427)
> at
> com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
> at
> com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
> at java.util.TimerThread.mainLoop(Timer.java:534)
> at java.util.TimerThread.run(Timer.java:484)
> 2013-08-17 11:28:12,843 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-2:null) Unable to upgrade the database
> com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
> script: /usr/share/cloudstack-management/setup/db/schema-307to410.sql
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:246)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:298)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:427)
> at
> com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
> at
> com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
> at java.util.TimerThread.mainLoop(Timer.java:534)
> at java.util.TimerThread.run(Timer.java:484)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'external_nicira_nvp_devices' already exists
> 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:237)
> ... 6 more
> 2013-08-17 11:28:12,846 DEBUG [db.Transaction.Transaction] (Timer-2:null)
> Rolling back the transaction: Time = 57 Name =
> -CloudStartupServlet$1.run:52-TimerThread.mainLoop:534-TimerThread.run:484;
> called by
> -Transaction.rollback:898-Transaction.removeUpTo:841-Transaction.close:665-DatabaseUpgradeChecker.upgrade:331-DatabaseUpgradeChecker.check:427-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:54-TimerThread.mainLoop:534-TimerThread.run:484
> 2013-08-17 11:28:12,849 ERROR [utils.component.ComponentContext]
> (Timer-2:null) System integrity check failed. Refuse to startup
> com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the
> database
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:329)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:427)
> at
> com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
> at
> com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
> at java.util.TimerThread.mainLoop(Timer.java:534)
> at java.util.TimerThread.run(Timer.java:484)
> Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to execute
> upgrade script: /usr/share/cloudstack-management/setup/db/schema-307to410.sql
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:246)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:298)
> ... 5 more
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'external_nicira_nvp_devices' already exists
> 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:237)
> ... 6 more
> 2013-08-17 11:28:12,846 DEBUG [db.Transaction.Transaction] (Timer-2:null)
> Rolling back the transaction: Time = 57 Name =
> -CloudStartupServlet$1.run:52-TimerThread.mainLoop:534-TimerThread.run:484;
> called by
> -Transaction.rollback:898-Transaction.removeUpTo:841-Transaction.close:665-DatabaseUpgradeChecker.upgrade:331-DatabaseUpgradeChecker.check:427-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:54-TimerThread.mainLoop:534-TimerThread.run:484
> 2013-08-17 11:28:12,849 ERROR [utils.component.ComponentContext]
> (Timer-2:null) System integrity check failed. Refuse to startup
> com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the
> database
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:329)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:427)
> at
> com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
> at
> com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
> at java.util.TimerThread.mainLoop(Timer.java:534)
> at java.util.TimerThread.run(Timer.java:484)
> Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to execute
> upgrade script: /usr/share/cloudstack-management/setup/db/schema-307to410.sql
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:246)
> at
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:298)
> ... 5 more
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'external_nicira_nvp_devices' already exists
> 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:237)
> ... 6 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
