Sailaja Mada created CLOUDSTACK-4369:
----------------------------------------
Summary: [UPGRADE]Upgrade failed from 307 to 4.2
Key: CLOUDSTACK-4369
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4369
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Management Server, Upgrade
Affects Versions: 4.2.0
Reporter: Sailaja Mada
Priority: Blocker
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-16 17:18:52,326 DEBUG [utils.db.ScriptRunner] (Timer-2:null) INSERT
IGNORE INTO `cloud`.`configuration` VALUES ('Storage', 'DEFAULT',
'management-server', 'storage.cache.replacement.enabled', 'true', 'enable or
disable cache storage replacement algorithm.')
2013-08-16 17:18:52,327 DEBUG [utils.db.ScriptRunner] (Timer-2:null) INSERT
IGNORE INTO `cloud`.`configuration` VALUES ('Storage', 'DEFAULT',
'management-server', 'storage.cache.replacement.interval', '86400', 'time
interval between cache replacement threads (in seconds).')
2013-08-16 17:18:52,328 DEBUG [utils.db.ScriptRunner] (Timer-2:null) DROP VIEW
IF EXISTS `cloud`.`data_center_view`
2013-08-16 17:18:52,346 DEBUG [utils.db.ScriptRunner] (Timer-2:null) CREATE
VIEW `cloud`.`data_center_view` AS select data_center.id,
data_center.uuid, data_center.name,
data_center.is_security_group_enabled,
data_center.is_local_storage_enabled, data_center.description,
data_center.dns1, data_center.dns2, data_center.ip6_dns1,
data_center.ip6_dns2, data_center.internal_dns1,
data_center.internal_dns2, data_center.guest_network_cidr,
data_center.domain, data_center.networktype,
data_center.allocation_state, data_center.zone_token,
data_center.dhcp_provider, data_center.removed, domain.id
domain_id, domain.uuid domain_uuid, domain.name domain_name,
domain.path domain_path,
dedicated_resources.affinity_group_id, dedicated_resources.account_id,
affinity_group.uuid affinity_group_uuid from
`cloud`.`data_center` left join `cloud`.`domain` ON
data_center.domain_id = domain.id left join
`cloud`.`dedicated_resources` ON data_center.id =
dedicated_resources.data_center_id left join
`cloud`.`affinity_group` ON dedicated_resources.affinity_group_id =
affinity_group.id
2013-08-16 17:18:52,361 DEBUG [upgrade.dao.Upgrade412to420] (Timer-2:null)
Adding AffinityGroup of type ExplicitDedication for domain id 1
2013-08-16 17:18:52,387 DEBUG [upgrade.dao.Upgrade412to420] (Timer-2:null)
Adding AffinityGroup of type ExplicitDedication for domain id 1
2013-08-16 17:18:52,425 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-2:null) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Exception while Moving private
zone information to dedicated resources
at
com.cloud.upgrade.dao.Upgrade412to420.movePrivateZoneToDedicatedResource(Upgrade412to420.java:186)
at
com.cloud.upgrade.dao.Upgrade412to420.performDataMigration(Upgrade412to420.java:77)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:302)
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.MySQLIntegrityConstraintViolationException:
Duplicate entry 'DedicatedGrp-domain-ROOT-1' for key 'name'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
com.cloud.upgrade.dao.Upgrade412to420.movePrivateZoneToDedicatedResource(Upgrade412to420.java:169)
... 7 more
2013-08-16 17:18:52,434 DEBUG [db.Transaction.Transaction] (Timer-2:null)
Rolling back the transaction: Time = 7102 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-16 17:18:52,460 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: Exception while
Moving private zone information to dedicated resources
at
com.cloud.upgrade.dao.Upgrade412to420.movePrivateZoneToDedicatedResource(Upgrade412to420.java:186)
at
com.cloud.upgrade.dao.Upgrade412to420.performDataMigration(Upgrade412to420.java:77)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:302)
... 5 more
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry 'DedicatedGrp-domain-ROOT-1' for key 'name'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
com.cloud.upgrade.dao.Upgrade412to420.movePrivateZoneToDedicatedResource(Upgrade412to420.java:169)
... 7 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
