[
https://issues.apache.org/jira/browse/CLOUDSTACK-2207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nicolas Lamirault reopened CLOUDSTACK-2207:
-------------------------------------------
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
