You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Alena Prokharchyk (JIRA)" <ji...@apache.org> on 2013/08/19 18:31:47 UTC
[jira] [Assigned] (CLOUDSTACK-4380) [UPGRADE]Upgrade failed from
307 to 4.2 (MySQLSyntaxErrorException: Table 'external_nicira_nvp_devices'
already exists)
[ https://issues.apache.org/jira/browse/CLOUDSTACK-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alena Prokharchyk reassigned CLOUDSTACK-4380:
---------------------------------------------
Assignee: Alena Prokharchyk
> [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
> Assignee: Alena Prokharchyk
> 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