You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Tomasz Zieba (JIRA)" <ji...@apache.org> on 2013/06/03 18:47:20 UTC
[jira] [Commented] (CLOUDSTACK-2675) Missing network_id on
restarting/host adding to a new shared network
[ https://issues.apache.org/jira/browse/CLOUDSTACK-2675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13673304#comment-13673304 ]
Tomasz Zieba commented on CLOUDSTACK-2675:
------------------------------------------
I have found that there is a problem with INSERT SQL statement. When you are creating vm machine and take a shared network, CloudStack create following sql statements:
8 Query SET autocommit=0
8 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
8 Query SELECT 1
8 Query SET autocommit=1
8 Query SELECT vm_template.id, vm_template.format, vm_template.unique_name, vm_template.name, vm_template.public, vm_template.featured, vm_template.type, vm_template.url, vm_template.hvm, vm_template.bits, vm_template.created, vm_template.removed, vm_template.account_id, vm_template.checksum, vm_template.display_text, vm_template.enable_password, vm_template.guest_os_id, vm_template.bootable, vm_template.prepopulate, vm_template.cross_zones, vm_template.hypervisor_type, vm_template.extractable, vm_template.source_template_id, vm_template.template_tag, vm_template.uuid, vm_template.sort_key, vm_template.enable_sshkey FROM vm_template WHERE vm_template.type = 'SYSTEM' AND vm_template.hypervisor_type = 'XenServer' ORDER BY vm_template.id DESC
8 Query SET autocommit=1
9 Query SET autocommit=0
9 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
9 Query SELECT 1
9 Query SET autocommit=0
9 Query INSERT INTO vm_instance (vm_instance.id, vm_instance.name, vm_instance.vnc_password, vm_instance.proxy_id, vm_instance.proxy_assign_time, vm_instance.state, vm_instance.private_ip_address, vm_instance.instance_name, vm_instance.vm_template_id, vm_instance.guest_os_id, vm_instance.host_id, vm_instance.last_host_id, vm_instance.pod_id, vm_instance.private_mac_address, vm_instance.data_center_id, vm_instance.vm_type, vm_instance.ha_enabled, vm_instance.limit_cpu_use, vm_instance.update_count, vm_instance.created, vm_instance.update_time, vm_instance.domain_id, vm_instance.account_id, vm_instance.service_offering_id, vm_instance.reservation_id, vm_instance.hypervisor_type, vm_instance.uuid, vm_instance.type) VALUES (29, _binary'r-29-VM', _binary'L2fmUmx6ikdjMva5WFwRleblZTgaCjdH8JPYTcAVmcQ=', null, null, 'Stopped', null, _binary'r-29-VM', 1, 15, null, null, null, null, 1, 'DomainRouter', 1, 0, 0, '2013-06-03 14:27:17', null, 1, 1, 7, null, 'XenServer', _binary'29443e94-3960-4370-8970-4f2917bfb940', 'DomainRouter')
9 Query INSERT INTO domain_router (domain_router.element_id, domain_router.public_ip_address, domain_router.public_mac_address, domain_router.public_netmask, domain_router.is_redundant_router, domain_router.priority, domain_router.is_priority_bumpup, domain_router.redundant_state, domain_router.stop_pending, domain_router.role, domain_router.template_version, domain_router.scripts_version, domain_router.vpc_id, domain_router.id) VALUES (2, null, null, null, 0, 0, 0, 'UNKNOWN', 0, 'VIRTUAL_ROUTER', null, null, null, 29)
9 Query rollback
9 Query rollback
9 Query SET autocommit=1
There is a problem with " INSERT INTO domain_router " statement because the definition of domain_router table is the following:
mysql> describe domain_router;
+---------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------+-------+
| id | bigint(20) unsigned | NO | PRI | NULL | |
| element_id | bigint(20) unsigned | NO | MUL | NULL | |
| public_mac_address | varchar(17) | YES | | NULL | |
| public_ip_address | char(40) | YES | | NULL | |
| public_netmask | varchar(15) | YES | | NULL | |
| guest_netmask | varchar(15) | YES | | NULL | |
| guest_ip_address | char(40) | YES | | NULL | |
| network_id | bigint(20) unsigned | NO | | NULL | |
| is_redundant_router | int(1) unsigned | NO | | NULL | |
| priority | int(4) unsigned | YES | | NULL | |
| is_priority_bumpup | int(1) unsigned | NO | | NULL | |
| redundant_state | varchar(64) | NO | | NULL | |
| stop_pending | int(1) unsigned | NO | | NULL | |
| role | varchar(64) | NO | | NULL | |
| template_version | varchar(100) | YES | | NULL | |
| scripts_version | varchar(100) | YES | | NULL | |
| vpc_id | bigint(20) unsigned | YES | MUL | NULL | |
+---------------------+---------------------+------+-----+---------+-------+
As you can see the network_id value is missing in the insert statement.
Please correct this situation because there is not possible to create shared networks.
PS: When i create shared network in CS 3.0.2 - evertything is OK, additionally after upgrade from 3.0.2 to 4.0.2 - shared network is working but you can not create new ones.
> Missing network_id on restarting/host adding to a new shared network
> --------------------------------------------------------------------
>
> Key: CLOUDSTACK-2675
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2675
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: Network Controller
> Affects Versions: 4.0.2
> Environment: CloudStack 4.0.2,
> Reporter: Tomasz Zieba
>
> I have got the same situation as follows:
> http://mail-archives.apache.org/mod_mbox/cloudstack-users/201304.mbox/%3C4B77B928-A3C5-4742-8AC3-652AF4A7CC5B@ringplus.net%3E
--
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