You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Nicolas Lamirault (JIRA)" <ji...@apache.org> on 2013/05/02 14:56:18 UTC
[jira] [Issue Comment Deleted] (CLOUDSTACK-2207) Upgrade from
2.2.14 to 4.1.0 failed due to system VM not present
[ https://issues.apache.org/jira/browse/CLOUDSTACK-2207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nicolas Lamirault updated CLOUDSTACK-2207:
------------------------------------------
Comment: was deleted
(was: I retry the upgrade with system template "system-vmware-3.0.5" :
2013-05-02 10:06:33,504 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null) Dropping public_ip_address keys from `cloud`.`secondary_storage_vm` and console_proxy tables...
2013-05-02 10:06:33,585 DEBUG [upgrade.dao.DbUpgradeUtils] (Timer-1:null) Key public_ip_address is dropped successfully from the table secondary_storage_vm
2013-05-02 10:06:33,640 DEBUG [upgrade.dao.DbUpgradeUtils] (Timer-1:null) Key public_ip_address is dropped successfully from the table console_proxy
2013-05-02 10:06:33,640 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null) Updating System Vm template IDs
2013-05-02 10:06:33,641 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null) Updating XenSever System Vms
2013-05-02 10:06:33,642 WARN [upgrade.dao.Upgrade2214to30] (Timer-1:null) 3.0.0 XenServer SystemVm template not found. XenServer hypervisor is not used, so not failing upgrade
2013-05-02 10:06:33,643 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null) Updating KVM System Vms
2013-05-02 10:06:33,643 WARN [upgrade.dao.Upgrade2214to30] (Timer-1:null) 3.0.0 KVM SystemVm template not found. KVM hypervisor is not used, so not failing upgrade
2013-05-02 10:06:33,644 DEBUG [upgrade.dao.Upgrade2214to30] (Timer-1:null) Updating VMware System Vms
2013-05-02 10:06:33,649 DEBUG [db.Transaction.Transaction] (Timer-1:null) Rolling back the transaction: Time = 30651 Name = Upgrade; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.clos
e:657-DatabaseUpgradeChecker.upgrade:284-DatabaseUpgradeChecker.check:379-ComponentContext.initComponentsLifeCycle:91-CloudStartupServlet$1.run:50-TimerThread.mainLoop:512-TimerThread.run:462
2013-05-02 10:06:33,653 ERROR [utils.component.ComponentContext] (Timer-1:null) System integrity check failed. Refuse to startup
com.cloud.utils.exception.CloudRuntimeException: 3.0.0 VMware SystemVm template not found. Cannot upgrade system Vms
at com.cloud.upgrade.dao.Upgrade2214to30.updateSystemVms(Upgrade2214to30.java:713)
at com.cloud.upgrade.dao.Upgrade2214to30.performDataMigration(Upgrade2214to30.java:82)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:258)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:379)
at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:91)
at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
So i restore database in 2.2.14 andi install new template "system-vmware-3.0.0". Now the error is :
2013-05-02 14:35:56,349 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Grabbing lock to check for database upgrade.
2013-05-02 14:35:56,367 DEBUG [upgrade.dao.VersionDaoImpl] (Timer-1:null) Checking to see if the database is at a version before it was the version table is created
2013-05-02 14:35:56,374 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) DB version = 2.2.14 Code Version = 4.1.0
2013-05-02 14:35:56,375 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Database upgrade must be performed from 2.2.14 to 4.1.0
2013-05-02 14:35:56,375 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) DBVersion upgrade from : 2.2.14
2013-05-02 14:35:56,375 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) --> Upgrade: 3.0.0
2013-05-02 14:35:56,375 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) --> Upgrade: 3.0.1
2013-05-02 14:35:56,375 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) --> Upgrade: 3.0.2
2013-05-02 14:35:56,375 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) --> Upgrade: 4.0.0
2013-05-02 14:35:56,375 INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) --> Upgrade: 4.1.0
2013-05-02 14:35:56,376 DEBUG [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Running upgrade Upgrade2214to30 to upgrade from 2.2.14-3.0.0 to 3.0.0
2013-05-02 14:35:56,383 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-2214to30.sql in the classpath
2013-05-02 14:35:56,383 DEBUG [utils.script.Script] (Timer-1:null) System resource: null
2013-05-02 14:35:56,384 DEBUG [utils.script.Script] (Timer-1:null) Classpath resource: null
2013-05-02 14:35:56,384 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-2214to30.sql
2013-05-02 14:35:56,384 DEBUG [utils.script.Script] (Timer-1:null) Current binaries reside at /usr2/web/cloudstack-prp.bop.cloud.mbs/client/WEB-INF/lib
2013-05-02 14:35:56,385 DEBUG [utils.script.Script] (Timer-1:null) Looking for db/schema-2214to30.sql in /usr2/web/cloudstack-prp.bop.cloud.mbs/client/WEB-INF/lib/db/schema-2214to30.sql
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Licensed to the Apache Software Foundation (ASF) under one
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- or more contributor license agreements. See the NOTICE file
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- distributed with this work for additional information
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- regarding copyright ownership. The ASF licenses this file
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- to you under the Apache License, Version 2.0 (the
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- "License"); you may not use this file except in compliance
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- with the License. You may obtain a copy of the License at
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- http://www.apache.org/licenses/LICENSE-2.0
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) --
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Unless required by applicable law or agreed to in writing,
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- software distributed under the License is distributed on an
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- KIND, either express or implied. See the License for the
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- specific language governing permissions and limitations
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- under the License.
2013-05-02 14:35:56,387 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Schema upgrade from 2.2.14 to 3.0;
2013-05-02 14:35:56,388 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`host` ADD COLUMN `hypervisor_version` varchar(32) COMMENT 'hypervisor version' AFTER hypervisor_type
2013-05-02 14:35:57,081 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE TABLE `cloud`.`hypervisor_capabilities` ( `id` bigint unsigned NOT NULL auto_increment, `hypervisor_type` varchar(32) NOT NULL, `hy
pervisor_version` varchar(32), `max_guests_limit` bigint unsigned DEFAULT 50, `security_group_enabled` int(1) unsigned DEFAULT 1 COMMENT 'Is security group supported', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUT
O_INCREMENT=1 DEFAULT CHARSET=utf8
2013-05-02 14:35:57,280 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Xen
Server', 'default', 50, 1)
2013-05-02 14:35:57,281 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Xen
Server', 'XCP 1.0', 50, 1)
2013-05-02 14:35:57,282 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Xen
Server', '5.6', 50, 1)
2013-05-02 14:35:57,283 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Xen
Server', '5.6 FP1', 50, 1)
2013-05-02 14:35:57,283 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Xen
Server', '5.6 SP2', 50, 1)
2013-05-02 14:35:57,284 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Xen
Server', '6.0', 50, 1)
2013-05-02 14:35:57,285 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('VMw
are', 'default', 128, 0)
2013-05-02 14:35:57,286 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('VMw
are', '4.0', 128, 0)
2013-05-02 14:35:57,286 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('VMw
are', '4.1', 128, 0)
2013-05-02 14:35:57,287 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('KVM
', 'default', 50, 1)
2013-05-02 14:35:57,288 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Ovm
', 'default', 25, 1)
2013-05-02 14:35:57,288 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled) VALUES ('Ovm
', '2.3', 25, 1)
2013-05-02 14:35:57,289 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE TABLE `cloud`.`projects` ( `id` bigint unsigned NOT NULL auto_increment, `name` varchar(255) COMMENT 'project name', `display_text
` varchar(255) COMMENT 'project name', `project_account_id` bigint unsigned NOT NULL, `domain_id` bigint unsigned NOT NULL, `created` datetime COMMENT 'date created', `removed` datetime COMMENT 'date remov
ed', `state` varchar(255) NOT NULL COMMENT 'state of the project (Active/Inactive/Suspended)', PRIMARY KEY (`id`), CONSTRAINT `fk_projects__project_account_id` FOREIGN KEY(`project_account_id`) REFERENCES `a
ccount`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_projects__domain_id` FOREIGN KEY(`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, INDEX `i_projects__removed`(`removed`) ) ENGINE=InnoDB DEFAULT CHARSE
T=utf8
2013-05-02 14:35:57,608 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE TABLE `cloud`.`project_account` ( `id` bigint unsigned NOT NULL auto_increment, `account_id` bigint unsigned NOT NULL COMMENT'accoun
t id', `account_role` varchar(255) NOT NULL DEFAULT 'Regular' COMMENT 'Account role in the project (Owner or Regular)', `project_id` bigint unsigned NOT NULL COMMENT 'project id', `project_account_id` bigint
unsigned NOT NULL, `created` datetime COMMENT 'date created', PRIMARY KEY (`id`), CONSTRAINT `fk_project_account__account_id` FOREIGN KEY(`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTR
AINT `fk_project_account__project_id` FOREIGN KEY(`project_id`) REFERENCES `projects`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_project_account__project_account_id` FOREIGN KEY(`project_account_id`) REFERENCES `ac
count`(`id`) ON DELETE CASCADE, UNIQUE (`account_id`, `project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-05-02 14:35:57,880 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE TABLE `cloud`.`project_invitations` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `project_id` bigint unsign
ed NOT NULL COMMENT 'project id', `account_id` bigint unsigned COMMENT 'account id', `domain_id` bigint unsigned COMMENT 'domain id', `email` varchar(255) COMMENT 'email', `token` varchar(255) COMMENT 'tok
en', `state` varchar(255) NOT NULL DEFAULT 'Pending' COMMENT 'the state of the invitation', `created` datetime COMMENT 'date created', PRIMARY KEY (`id`), CONSTRAINT `fk_project_invitations__account_id` FO
REIGN KEY(`account_id`) REFERENCES `account`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_project_invitations__domain_id` FOREIGN KEY(`domain_id`) REFERENCES `domain`(`id`) ON DELETE CASCADE, CONSTRAINT `fk_project
_invitations__project_id` FOREIGN KEY(`project_id`) REFERENCES `projects`(`id`) ON DELETE CASCADE, UNIQUE (`project_id`, `account_id`), UNIQUE (`project_id`, `email`), UNIQUE (`project_id`, `token`), CONST
RAINT `uc_project_invitations__uuid` UNIQUE (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-05-02 14:35:58,196 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE TABLE `cloud`.`load_balancer_stickiness_policies` ( `id` bigint unsigned NOT NULL auto_increment, `uuid` varchar(40), `load_balance
r_id` bigint unsigned NOT NULL, `name` varchar(255) NOT NULL, `description` varchar(4096) NULL COMMENT 'description', `method_name` varchar(255) NOT NULL, `params` varchar(4096) NOT NULL, `revoke` tinyin
t(1) unsigned NOT NULL DEFAULT 0 COMMENT '1 is when rule is set for Revoke', PRIMARY KEY (`id`), CONSTRAINT `fk_load_balancer_stickiness_policies__load_balancer_id` FOREIGN KEY(`load_balancer_id`) REFERENCES
`load_balancing_rules`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-05-02 14:35:58,304 DEBUG [utils.db.ScriptRunner] (Timer-1:null) CREATE TABLE `cloud`.`template_swift_ref` ( `id` bigint unsigned NOT NULL auto_increment, `swift_id` bigint unsigned NOT NULL, `template_
id` bigint unsigned NOT NULL, `created` DATETIME NOT NULL, `path` varchar(255), `size` bigint unsigned, `physical_size` bigint unsigned DEFAULT 0, PRIMARY KEY (`id`), CONSTRAINT `fk_template_swift_ref
__swift_id` FOREIGN KEY `fk_template_swift_ref__swift_id` (`swift_id`) REFERENCES `swift` (`id`) ON DELETE CASCADE, INDEX `i_template_swift_ref__swift_id`(`swift_id`), CONSTRAINT `fk_template_swift_ref__templa
te_id` FOREIGN KEY `fk_template_swift_ref__template_id` (`template_id`) REFERENCES `vm_template` (`id`), INDEX `i_template_swift_ref__template_id`(`template_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=
utf8
2013-05-02 14:35:58,528 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`snapshots` DROP COLUMN `swift_name`
2013-05-02 14:35:58,690 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` DROP COLUMN `hostname`
2013-05-02 14:35:58,839 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` DROP COLUMN `token`
2013-05-02 14:35:58,919 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `uuid` varchar(40)
2013-05-02 14:35:58,967 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `url` varchar(255) NOT NULL
2013-05-02 14:35:59,120 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `key` varchar(255) NOT NULL COMMENT 'token for this user'
2013-05-02 14:35:59,211 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD COLUMN `created` datetime COMMENT 'date the swift first signed on'
2013-05-02 14:35:59,266 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`swift` ADD CONSTRAINT `uc_swift__uuid` UNIQUE (`uuid`)
2013-05-02 14:36:00,197 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'swift.enable', 'false', 'enable swift')
2013-05-02 14:36:00,200 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'max.project.user.vms', '20', 'The defaul
t maximum number of user VMs that can be deployed for a project')
2013-05-02 14:36:00,201 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'max.project.public.ips', '20', 'The defa
ult maximum number of public IPs that can be consumed by a project')
2013-05-02 14:36:00,240 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'max.project.templates', '20', 'The defau
lt maximum number of templates that can be deployed for a project')
2013-05-02 14:36:00,241 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'max.project.snapshots', '20', 'The defau
lt maximum number of snapshots that can be created for a project')
2013-05-02 14:36:00,242 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'max.project.volumes', '20', 'The default
maximum number of volumes that can be created for a project')
2013-05-02 14:36:00,243 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.invite.required', 'false', 'If i
nvitation confirmation is required when add account to project. Default value is false')
2013-05-02 14:36:00,243 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.invite.timeout', '86400', 'Invit
ation expiration time (in seconds). Default is 1 day - 86400 seconds')
2013-05-02 14:36:00,244 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'allow.user.create.projects', 'true', 'If
regular user can create a project; true by default')
2013-05-02 14:36:00,245 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.email.sender', null, 'Sender of
project invitation email (will be in the From header of the email).')
2013-05-02 14:36:00,246 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.smtp.host', null, 'SMTP hostname
used for sending out email project invitations')
2013-05-02 14:36:00,246 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.smtp.password', null, 'Password
for SMTP authentication (applies only if project.smtp.useAuth is true)')
2013-05-02 14:36:00,247 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.smtp.port', '465', 'Port the SMT
P server is listening on')
2013-05-02 14:36:00,248 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.smtp.useAuth', null, 'If true, u
se SMTP authentication when sending emails')
2013-05-02 14:36:00,248 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Project Defaults', 'DEFAULT', 'management-server', 'project.smtp.username', null, 'Username
for SMTP authentication (applies only if project.smtp.useAuth is true)')
2013-05-02 14:36:00,249 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'cluster.memory.allocated.capacity.disablethreshold'
, .85, 'Percentage (as a value between 0 and 1) of memory utilization above which allocators will disable using the cluster for low memory available. Keep the corresponding notification threshold lower than this
to be notified beforehand.')
2013-05-02 14:36:00,250 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'cluster.cpu.allocated.capacity.disablethreshold' ,
.85, 'Percentage (as a value between 0 and 1) of cpu utilization above which allocators will disable using the cluster for low cpu available. Keep the corresponding notification threshold lower than this to be not
ified beforehand.')
2013-05-02 14:36:00,251 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'pool.storage.allocated.capacity.disablethreshold' ,
.85, 'Percentage (as a value between 0 and 1) of allocated storage utilization above which allocators will disable using the pool for low allocated storage available.')
2013-05-02 14:36:00,251 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'pool.storage.capacity.disablethreshold' , .85, 'Per
centage (as a value between 0 and 1) of storage utilization above which allocators will disable using the pool for low storage available.')
2013-05-02 14:36:00,252 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'zone.vlan.capacity.notificationthreshold' , .75, 'P
ercentage (as a value between 0 and 1) of Zone Vlan utilization above which alerts will be sent about low number of Zone Vlans.')
2013-05-02 14:36:00,253 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'cluster.localStorage.capacity.notificationthreshold
' , .75, 'Percentage (as a value between 0 and 1) of local storage utilization above which alerts will be sent about low local storage available.')
2013-05-02 14:36:00,254 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'zone.directnetwork.publicip.capacity.notificationth
reshold' , .75, 'Percentage (as a value between 0 and 1) of Direct Network Public Ip Utilization above which alerts will be sent about low number of direct network public ips.')
2013-05-02 14:36:00,254 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Alert', 'DEFAULT', 'management-server', 'zone.secstorage.capacity.notificationthreshold' , .
75, 'Percentage (as a value between 0 and 1) of secondary storage utilization above which alerts will be sent about low storage available.')
2013-05-02 14:36:00,255 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'custom.diskoffering.size.min', '1', 'Minimum siz
e in GB for custom disk offering')
2013-05-02 14:36:00,256 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'custom.diskoffering.size.max', '1024', 'Maximum
size in GB for custom disk offering')
2013-05-02 14:36:00,256 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', 'system.vm.random.password', 'false', 'Randomize
system vm password the first time management server starts')
2013-05-02 14:36:00,257 DEBUG [utils.db.ScriptRunner] (Timer-1:null) INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network', 'DEFAULT', 'management-server', 'network.securitygroups.defaultadding' , 'true', '
If true, the user VM would be added to the default security group by default')
2013-05-02 14:36:00,258 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set name = 'cluster.storage.allocated.capacity.notificationthreshold' , category = 'Alert' where name = 'storage.
allocated.capacity.threshold'
2013-05-02 14:36:00,259 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set name = 'cluster.storage.capacity.notificationthreshold' , category = 'Alert' where name = 'storage.capacity.t
hreshold'
2013-05-02 14:36:00,260 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set name = 'cluster.cpu.allocated.capacity.notificationthreshold' , category = 'Alert' where name = 'cpu.capacity
.threshold'
2013-05-02 14:36:00,260 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set name = 'cluster.memory.allocated.capacity.notificationthreshold' , category = 'Alert' where name = 'memory.ca
pacity.threshold'
2013-05-02 14:36:00,261 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set name = 'zone.virtualnetwork.publicip.capacity.notificationthreshold' , category = 'Alert' where name = 'publi
c.ip.capacity.threshold'
2013-05-02 14:36:00,262 DEBUG [utils.db.ScriptRunner] (Timer-1:null) update `cloud`.`configuration` set name = 'pod.privateip.capacity.notificationthreshold' , category = 'Alert' where name = 'private.ip.capacity.
threshold'
2013-05-02 14:36:00,263 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`domain_router` ADD COLUMN `template_version` varchar(100) COMMENT 'template version' AFTER role
2013-05-02 14:36:00,427 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`domain_router` ADD COLUMN `scripts_version` varchar(100) COMMENT 'scripts version' AFTER template_version
2013-05-02 14:36:00,565 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`alert` ADD `cluster_id` bigint unsigned
2013-05-02 14:36:00,634 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user_statistics` ADD COLUMN `agg_bytes_received` bigint unsigned NOT NULL default '0'
2013-05-02 14:36:00,811 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`user_statistics` ADD COLUMN `agg_bytes_sent` bigint unsigned NOT NULL default '0'
2013-05-02 14:36:00,960 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vm_instance` ADD COLUMN `uuid` varchar(40)
2013-05-02 14:36:01,277 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`vm_instance` ADD CONSTRAINT `uc_vm_instance_uuid` UNIQUE (`uuid`)
2013-05-02 14:36:02,021 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`async_job` ADD COLUMN `uuid` varchar(40)
2013-05-02 14:36:02,393 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`async_job` ADD CONSTRAINT `uc_async__uuid` UNIQUE (`uuid`)
2013-05-02 14:36:02,492 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`domain` ADD COLUMN `uuid` varchar(40)
2013-05-02 14:36:02,648 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`domain` ADD CONSTRAINT `uc_domain__uuid` UNIQUE (`uuid`)
2013-05-02 14:36:02,937 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`account` ADD COLUMN `uuid` varchar(40)
2013-05-02 14:36:03,088 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`account` ADD CONSTRAINT `uc_account__uuid` UNIQUE (`uuid`)
2013-05-02 14:36:03,267 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud_usage`.`account` ADD COLUMN `uuid` varchar(40)
2013-05-02 14:36:03,269 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error executing: ALTER TABLE `cloud_usage`.`account` ADD COLUMN `uuid` varchar(40)
2013-05-02 14:36:03,269 ERROR [utils.db.ScriptRunner] (Timer-1:null) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'uuid'
2013-05-02 14:36:03,273 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable to execute upgrade script: /usr2/web/cloudstack-prp.bop.cloud.mbs/client/WEB-INF/lib/db/schema-2214to30.sql
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'uuid'
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:189)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:254)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:379)
at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:91)
at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
2013-05-02 14:36:03,275 DEBUG [db.Transaction.Transaction] (Timer-1:null) Rolling back the transaction: Time = 6899 Name = Upgrade; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close
:657-DatabaseUpgradeChecker.upgrade:284-DatabaseUpgradeChecker.check:379-ComponentContext.initComponentsLifeCycle:91-CloudStartupServlet$1.run:50-TimerThread.mainLoop:512-TimerThread.run:462
2013-05-02 14:36:03,278 ERROR [utils.component.ComponentContext] (Timer-1:null) System integrity check failed. Refuse to startup
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade script: /usr2/web/cloudstack-prp.bop.cloud.mbs/client/WEB-INF/lib/db/schema-2214to30.sql
at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:198)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:254)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:379)
at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:91)
at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'uuid'
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:189)
... 6 more
)
> Upgrade from 2.2.14 to 4.1.0 failed due to system VM not present
> ----------------------------------------------------------------
>
> Key: CLOUDSTACK-2207
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2207
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: Doc
> Affects Versions: 4.1.0
> Reporter: Nicolas Lamirault
> Assignee: Chip Childers
> Priority: Critical
> Fix For: 4.1.0
>
>
> We're trying to upgrade from 2.2.14 to 4.1.0.
> DatabaseUpgradeChecker failed :
> 2013-04-26 12:11:45,205 ERROR [utils.component.ComponentContext] (Timer-1:null) System integrity check failed. Refuse to startup
> com.cloud.utils.exception.CloudRuntimeException: 3.0.0 VMware SystemVm template not found. Cannot upgrade system Vms
> at com.cloud.upgrade.dao.Upgrade2214to30.updateSystemVms(Upgrade2214to30.java:713)
> at com.cloud.upgrade.dao.Upgrade2214to30.performDataMigration(Upgrade2214to30.java:82)
> at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:258)
> at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:379)
> at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:91)
> at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> According to the documentation, there is no VMware SystemVm 3.0.0 to install.
--
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