[
https://issues.apache.org/jira/browse/CLOUDSTACK-4369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Prachi Damle resolved CLOUDSTACK-4369.
--------------------------------------
Resolution: Fixed
> [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
> Assignee: Prachi Damle
> Priority: Blocker
> Fix For: 4.2.0
>
> Attachments: upgradeissie.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-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
