cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sailaja Mada (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CLOUDSTACK-4380) [UPGRADE]Upgrade failed from 307 to 4.2 (MySQLSyntaxErrorException: Table 'external_nicira_nvp_devices' already exists)
Date Sat, 17 Aug 2013 06:10:47 GMT

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sailaja Mada updated CLOUDSTACK-4380:
-------------------------------------

    Attachment: newupgissue.rar
    
> [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

Mime
View raw message