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 2012/10/11 22:51:06 UTC
[jira] [Created] (CLOUDSTACK-322) During upgrade displays error - a
foreign key constraint fails (`cloud/#sql-f34_6e`...
Matt Mullins created CLOUDSTACK-322:
---------------------------------------
Summary: 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
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
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
[jira] [Updated] (CLOUDSTACK-322) During upgrade displays error - a
foreign key constraint fails (`cloud/#sql-f34_6e`...
Posted by "Sudha Ponnaganti (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CLOUDSTACK-322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sudha Ponnaganti updated CLOUDSTACK-322:
----------------------------------------
Fix Version/s: 4.1.0
> 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
> 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
[jira] [Updated] (CLOUDSTACK-322) During upgrade displays error - a
foreign key constraint fails (`cloud/#sql-f34_6e`...
Posted by "Alena Prokharchyk (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CLOUDSTACK-322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alena Prokharchyk updated CLOUDSTACK-322:
-----------------------------------------
Assignee: Prachi Damle
> 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
> 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
>
> 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
[jira] [Commented] (CLOUDSTACK-322) During upgrade displays error -
a foreign key constraint fails (`cloud/#sql-f34_6e`...
Posted by "David Nalley (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CLOUDSTACK-322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13474609#comment-13474609 ]
David Nalley commented on CLOUDSTACK-322:
-----------------------------------------
What version is the from and to?
> 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
> 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
[jira] [Commented] (CLOUDSTACK-322) During upgrade displays error -
a foreign key constraint fails (`cloud/#sql-f34_6e`...
Posted by "Matt Mullins (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CLOUDSTACK-322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13474686#comment-13474686 ]
Matt Mullins commented on CLOUDSTACK-322:
-----------------------------------------
This is from 2.2.14 to 3.0.5 (Commercial Version #'s)
Matt Mullins
CloudPlatform Implementation Engineer
Worldwide Cloud Services Citrix System, Inc.
+1 (407) 920-1107 Office/Cell Phone
matt.mullins@citrix.com
> 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
> 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
[jira] [Commented] (CLOUDSTACK-322) During upgrade displays error -
a foreign key constraint fails (`cloud/#sql-f34_6e`...
Posted by "John Kinsella (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CLOUDSTACK-322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13474673#comment-13474673 ]
John Kinsella commented on CLOUDSTACK-322:
------------------------------------------
Shouldn't this be fixed for 4.0?
> 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
> 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
[jira] [Commented] (CLOUDSTACK-322) During upgrade displays error -
a foreign key constraint fails (`cloud/#sql-f34_6e`...
Posted by "Chip Childers (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CLOUDSTACK-322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13474695#comment-13474695 ]
Chip Childers commented on CLOUDSTACK-322:
------------------------------------------
Prachi - Can you please confirm if this is limited to CloudPlatform? If that's the case, then please close this bug as invalid for CloudStack. (I assume that Citrix has an internal tracker for you to use instead).
If this affects for CloudStack, can you please see if we can figure out the root cause? If there is a code fix, please commit to master. I'll cherry pick into the 4.0 branch.
> 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
> 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