You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by "Matt Mullins (JIRA)" <ji...@apache.org> on 2013/02/21 01:09:13 UTC

[jira] [Commented] (CLOUDSTACK-322) During upgrade displays error - a foreign key constraint fails (`cloud/#sql-f34_6e`...

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13582699#comment-13582699 ] 

Matt Mullins commented on CLOUDSTACK-322:
-----------------------------------------

Prachi,

How is this invalid? We experienced this with a customer and Alena validated it in the lab. 

Thank you,
Matt Mullins
Cloud Platforms Implementation Engineer
Worldwide Cloud Services
mathias.mullins@citrix.com
+1 (407) 920-1107



                
> During upgrade displays error - a foreign key constraint fails (`cloud/#sql-f34_6e`...
> --------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-322
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-322
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Install and Setup
>    Affects Versions: pre-4.0.0
>         Environment: RHEL 5.X, CloudStack 3.0.X, Upgrade utility in management server, error in database. 
>            Reporter: Matt Mullins
>            Assignee: Prachi Damle
>              Labels: Upgrade
>             Fix For: 4.1.0
>
>
> ERROR [utils.db.ScriptRunner] (main:null) Error executing: ALTER TABLE `cloud`.`vlan` ADD CONSTRAINT `fk_vlan__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) 
> Initial Corrective Action:
> Run against Cloud DB - "insert into network_tags values (3, 200, 'GSS');"

--
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