You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by "Rohit Yadav (JIRA)" <ji...@apache.org> on 2013/02/11 08:01:15 UTC
[jira] [Resolved] (CLOUDSTACK-1200) Unknown column
'vm_instance.disk_offering_id' in table vm_instance, db exception shown in
MS log
[ https://issues.apache.org/jira/browse/CLOUDSTACK-1200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rohit Yadav resolved CLOUDSTACK-1200.
-------------------------------------
Resolution: Cannot Reproduce
In my setup, (did deploydb failed for you due to CLOUDSTACK-1181, I just fixed it) I see disk_offering_id table in cloud.vm_instance. When you run deploydb, goto developer/pom.xml and add an argument -v or --verbose at the end of args in the deploydb profile.
Resolving as cannot reproduce, please check and reopen if needed or close after qa. Thanks.
In my case, it did ran 4.1-new-db-schema.sql, see:
========> Processing SQL file at /Bhaisaab/Work/apache-cloudstack/developer/target/db/4.1-new-db-schema.sql
2013-02-11 12:23:52,560 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- Licensed to the Apache Software Foundation (ASF) under one
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- or more contributor license agreements. See the NOTICE file
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- distributed with this work for additional information
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- regarding copyright ownership. The ASF licenses this file
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- to you under the Apache License, Version 2.0 (the
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- "License"); you may not use this file except in compliance
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- with the License. You may obtain a copy of the License at
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) --
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- http://www.apache.org/licenses/LICENSE-2.0
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) --
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- Unless required by applicable law or agreed to in writing,
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- software distributed under the License is distributed on an
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- KIND, either express or implied. See the License for the
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- specific language governing permissions and limitations
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) -- under the License.
2013-02-11 12:23:52,561 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_template add image_data_store_id bigint unsigned
2013-02-11 12:23:52,572 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_template add size bigint unsigned
2013-02-11 12:23:52,589 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_template add state varchar(255)
2013-02-11 12:23:52,600 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_template add update_count bigint unsigned
2013-02-11 12:23:52,618 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_template add updated datetime
2013-02-11 12:23:52,630 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table storage_pool add storage_provider_id bigint unsigned
2013-02-11 12:23:52,648 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table storage_pool add scope varchar(255)
2013-02-11 12:23:52,668 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table storage_pool modify id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL
2013-02-11 12:23:52,677 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table template_spool_ref add state varchar(255)
2013-02-11 12:23:52,698 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table template_spool_ref add update_count bigint unsigned
2013-02-11 12:23:52,718 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table volumes add disk_type varchar(255)
2013-02-11 12:23:52,738 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table volumes drop foreign key `fk_volumes__account_id`
2013-02-11 12:23:52,750 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_instance add column disk_offering_id bigint unsigned
2013-02-11 12:23:52,762 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_instance add column cpu int(10) unsigned
2013-02-11 12:23:52,779 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_instance add column ram bigint unsigned
2013-02-11 12:23:52,799 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_instance add column owner varchar(255)
2013-02-11 12:23:52,810 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_instance add column speed int(10) unsigned
2013-02-11 12:23:52,832 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_instance add column host_name varchar(255)
2013-02-11 12:23:52,844 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table vm_instance add column display_name varchar(255)
2013-02-11 12:23:52,859 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table data_center add column owner varchar(255)
2013-02-11 12:23:52,870 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table data_center add column created datetime COMMENT 'date created'
2013-02-11 12:23:52,889 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table data_center add column lastUpdated datetime COMMENT 'last updated'
2013-02-11 12:23:52,909 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table data_center add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
2013-02-11 12:23:52,989 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table host add column owner varchar(255)
2013-02-11 12:23:53,009 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table host add column lastUpdated datetime COMMENT 'last updated'
2013-02-11 12:23:53,029 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table host add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
2013-02-11 12:23:53,040 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table cluster add column owner varchar(255)
2013-02-11 12:23:53,058 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table cluster add column created datetime COMMENT 'date created'
2013-02-11 12:23:53,078 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table cluster add column lastUpdated datetime COMMENT 'last updated'
2013-02-11 12:23:53,089 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) alter table cluster add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone'
2013-02-11 12:23:53,108 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`object_datastore_ref` ( `id` bigint unsigned NOT NULL auto_increment, `datastore_id` bigint unsigned NOT NULL, `datastore_role` varchar(255) NOT NULL, `object_id` bigint unsigned NOT NULL, `object_type` varchar(255) NOT NULL, `created` DATETIME NOT NULL, `last_updated` DATETIME, `job_id` varchar(255), `download_pct` int(10) unsigned, `download_state` varchar(255), `error_str` varchar(255), `local_path` varchar(255), `install_path` varchar(255), `size` bigint unsigned COMMENT 'the size of the template on the pool', `state` varchar(255) NOT NULL, `update_count` bigint unsigned NOT NULL, `updated` DATETIME, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2013-02-11 12:23:53,117 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`data_store_provider` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) NOT NULL COMMENT 'name of primary data store provider', `uuid` varchar(255) NOT NULL COMMENT 'uuid of primary data store provider', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-02-11 12:23:53,125 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`image_data_store` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) NOT NULL COMMENT 'name of data store', `image_provider_id` bigint unsigned NOT NULL COMMENT 'id of image_data_store_provider', `protocol` varchar(255) NOT NULL COMMENT 'protocol of data store', `data_center_id` bigint unsigned COMMENT 'datacenter id of data store', `scope` varchar(255) COMMENT 'scope of data store', `uuid` varchar(255) COMMENT 'uuid of data store', PRIMARY KEY(`id`), CONSTRAINT `fk_tags__image_data_store_provider_id` FOREIGN KEY(`image_provider_id`) REFERENCES `data_store_provider`(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-02-11 12:23:53,133 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`vm_compute_tags` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `compute_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-02-11 12:23:53,141 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`vm_root_disk_tags` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `root_disk_tag` varchar(255) NOT NULL COMMENT 'name of tag', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-02-11 12:23:53,148 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`vm_network_map` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `network_id` bigint unsigned NOT NULL COMMENT 'network id', PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-02-11 12:23:53,156 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`vm_reservation` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `uuid` varchar(40) NOT NULL COMMENT 'reservation id', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `data_center_id` bigint unsigned NOT NULL COMMENT 'zone id', `pod_id` bigint unsigned NOT NULL COMMENT 'pod id', `cluster_id` bigint unsigned NOT NULL COMMENT 'cluster id', `host_id` bigint unsigned NOT NULL COMMENT 'host id', `created` datetime COMMENT 'date created', `removed` datetime COMMENT 'date removed if not null', CONSTRAINT `uc_vm_reservation__uuid` UNIQUE (`uuid`), PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
2013-02-11 12:23:53,164 DEBUG [utils.db.ScriptRunner] (com.cloud.upgrade.DatabaseCreator.main():) CREATE TABLE `cloud`.`volume_reservation` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `vm_reservation_id` bigint unsigned NOT NULL COMMENT 'id of the vm reservation', `vm_id` bigint unsigned NOT NULL COMMENT 'vm id', `volume_id` bigint unsigned NOT NULL COMMENT 'volume id', `pool_id` bigint unsigned NOT NULL COMMENT 'pool assigned to the volume', CONSTRAINT `fk_vm_pool_reservation__vm_reservation_id` FOREIGN KEY (`vm_reservation_id`) REFERENCES `vm_reservation`(`id`) ON DELETE CASCADE, PRIMARY KEY(`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
Also, the table description:
mysql> desc vm_instance;
+---------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------+-------+
| id | bigint(20) unsigned | NO | PRI | NULL | |
| name | varchar(255) | NO | | NULL | |
| uuid | varchar(40) | YES | UNI | NULL | |
| instance_name | varchar(255) | NO | | NULL | |
| state | varchar(32) | NO | MUL | NULL | |
| desired_state | varchar(32) | YES | | NULL | |
| vm_template_id | bigint(20) unsigned | YES | MUL | NULL | |
| guest_os_id | bigint(20) unsigned | NO | | NULL | |
| private_mac_address | varchar(17) | YES | | NULL | |
| private_ip_address | char(40) | YES | | NULL | |
| pod_id | bigint(20) unsigned | YES | MUL | NULL | |
| data_center_id | bigint(20) unsigned | NO | MUL | NULL | |
| host_id | bigint(20) unsigned | YES | MUL | NULL | |
| last_host_id | bigint(20) unsigned | YES | MUL | NULL | |
| proxy_id | bigint(20) unsigned | YES | | NULL | |
| proxy_assign_time | datetime | YES | | NULL | |
| vnc_password | varchar(255) | NO | | NULL | |
| ha_enabled | tinyint(1) | NO | | 0 | |
| limit_cpu_use | tinyint(1) unsigned | NO | | 0 | |
| update_count | bigint(20) unsigned | NO | MUL | 0 | |
| update_time | datetime | YES | MUL | NULL | |
| created | datetime | NO | | NULL | |
| removed | datetime | YES | MUL | NULL | |
| type | varchar(32) | NO | MUL | NULL | |
| vm_type | varchar(32) | NO | | NULL | |
| account_id | bigint(20) unsigned | NO | MUL | NULL | |
| domain_id | bigint(20) unsigned | NO | | NULL | |
| service_offering_id | bigint(20) unsigned | NO | MUL | NULL | |
| reservation_id | char(40) | YES | | NULL | |
| hypervisor_type | char(32) | YES | | NULL | |
| disk_offering_id | bigint(20) unsigned | YES | | NULL | |
| cpu | int(10) unsigned | YES | | NULL | |
| ram | bigint(20) unsigned | YES | | NULL | |
| owner | varchar(255) | YES | | NULL | |
| speed | int(10) unsigned | YES | | NULL | |
| host_name | varchar(255) | YES | | NULL | |
| display_name | varchar(255) | YES | | NULL | |
+---------------------+---------------------+------+-----+---------+-------+
37 rows in set (0.11 sec)
> Unknown column 'vm_instance.disk_offering_id' in table vm_instance, db exception shown in MS log
> ------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-1200
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1200
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: Management Server
> Affects Versions: 4.1.0
> Environment: CentOS 6.3
> 368d5a1ea597c612e050613e13c95687bc0992c2
> Reporter: Rayees Namathponnan
> Assignee: Rohit Yadav
> Priority: Blocker
> Fix For: 4.1.0
>
>
> Step 1 : Created new build from 4.1 branch
> Step 2 : Install and configure MS server
> You can see below exception log also in error dialog displayed in UI
> 2013-02-07 16:54:36,464 DEBUG [cloud.consoleproxy.ConsoleProxyManagerImpl] (consoleproxy-1:null) Skip capacity scan due to there is no Primary Storage UPintenance mode
> 2013-02-07 16:54:40,115 ERROR [network.router.VirtualNetworkApplianceManagerImpl] (RouterStatusMonitor-1:null) Fail to complete the CheckRouterTask!
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@67b9238a: SELECT 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.removed, 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.disk_offering_id, 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 FROM domain_router INNER JOIN vm_instance ON domain_router.id=vm_instance.id INNER JOIN router_network_ref ON domain_router.id=router_network_ref.router_id WHERE vm_instance.type='DomainRouter' AND vm_instance.removed IS NULL AND (router_network_ref.guest_type = 'Isolated' )
> at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:412)
> at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:347)
> at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:899)
> at com.cloud.utils.db.GenericDaoBase.listBy(GenericDaoBase.java:876)
> at com.cloud.utils.db.GenericDaoBase.listBy(GenericDaoBase.java:889)
> at com.cloud.vm.dao.DomainRouterDaoImpl.listIsolatedByHostId(DomainRouterDaoImpl.java:213)
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
> at com.cloud.utils.db.TransactionContextBuilder.AroundAnyMethod(TransactionContextBuilder.java:37)
> at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
> at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
> at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
> at com.cloud.network.router.VirtualNetworkApplianceManagerImpl$CheckRouterTask.run(VirtualNetworkApplianceManagerImpl.java:1295)
> in db i cannot see the cloumn vm_instance.disk_offering_id
> mysql> desc vm_instance;
> +---------------------+---------------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +---------------------+---------------------+------+-----+---------+-------+
> | id | bigint(20) unsigned | NO | PRI | NULL | |
> | name | varchar(255) | NO | | NULL | |
> | uuid | varchar(40) | YES | UNI | NULL | |
> | instance_name | varchar(255) | NO | | NULL | |
> | state | varchar(32) | NO | MUL | NULL | |
> | desired_state | varchar(32) | YES | | NULL | |
> | vm_template_id | bigint(20) unsigned | YES | MUL | NULL | |
> | guest_os_id | bigint(20) unsigned | NO | | NULL | |
> | private_mac_address | varchar(17) | YES | | NULL | |
> | private_ip_address | char(40) | YES | | NULL | |
> | pod_id | bigint(20) unsigned | YES | MUL | NULL | |
> | data_center_id | bigint(20) unsigned | NO | MUL | NULL | |
> | host_id | bigint(20) unsigned | YES | MUL | NULL | |
> | last_host_id | bigint(20) unsigned | YES | MUL | NULL | |
> | proxy_id | bigint(20) unsigned | YES | | NULL | |
> | proxy_assign_time | datetime | YES | | NULL | |
> | vnc_password | varchar(255) | NO | | NULL | |
> | ha_enabled | tinyint(1) | NO | | 0 | |
> | limit_cpu_use | tinyint(1) unsigned | NO | | 0 | |
> | update_count | bigint(20) unsigned | NO | MUL | 0 | |
> | update_time | datetime | YES | MUL | NULL | |
> | created | datetime | NO | | NULL | |
> | removed | datetime | YES | MUL | NULL | |
> | type | varchar(32) | NO | MUL | NULL | |
> | vm_type | varchar(32) | NO | | NULL | |
> | account_id | bigint(20) unsigned | NO | MUL | NULL | |
> | domain_id | bigint(20) unsigned | NO | | NULL | |
> | service_offering_id | bigint(20) unsigned | NO | MUL | NULL | |
> | reservation_id | char(40) | YES | | NULL | |
> | hypervisor_type | char(32) | YES | | NULL | |
> +---------------------+---------------------+------+-----+---------+-------+
> 30 rows in set (0.03 sec)
--
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