Feature freeze for 4.3 is closed. This should go into the new db upgrade. --Alex
> -----Original Message----- > From: Wido den Hollander [mailto:w...@widodh.nl] > Sent: Thursday, November 21, 2013 12:03 AM > To: dev@cloudstack.apache.org > Subject: Re: Error while running master > > > > On 11/20/2013 09:37 PM, Syed Ahmed wrote: > > Is this change going in 4.3? Is so then the Alter table I guess should > > be in schema-421to430.sql. I don't see a schema-430to440.sql though. > > How deploydb read the files? Does it go through all the schema files > > or does it pick the latest one? > > > > It somehow got lost due to my own merging. I comitted it into 421to430.sql > now, but I think this should be in 430to440.sql, but that file doesn't exist > yet. > > The feature freeze for 4.3 is closed, right? > > Wido > > > > > Thanks, > > -Syed > > > > > > On Wed 20 Nov 2013 03:24:37 PM EST, Wei ZHOU wrote: > >> Wido committed 1edaa36cc68e845a42339d5f267d49c82343aefb today. > >> try after "ALTER TABLE disk_offering ADD COLUMN cache_mode > varchar(20)" > >> I do not know which schema file should be inserted into, > >> schema-421to430.sql or schema-430to440.sql ? > >> > >> 2013/11/20 Syed Ahmed <sah...@cloudops.com> > >> > >>> Hi All, > >>> > >>> I am facing the following error when running the latest master. I > >>> have done a clean compile and have dropped and created the db again. > >>> > >>> [WARNING] Nested in > >>> org.springframework.context.ApplicationContextException: > >>> Failed to start bean 'cloudStackLifeCycle'; nested exception is > >>> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: > >>> com.mysql.jdbc.JDBC4PreparedStatement@538a1556: SELECT > >>> disk_offering.id, disk_offering.domain_id, > >>> disk_offering.unique_name, disk_offering.name, > >>> disk_offering.display_text, disk_offering.disk_size, > >>> disk_offering.tags, disk_offering.type, disk_offering.removed, > >>> disk_offering.created, disk_offering.recreatable, > >>> disk_offering.use_local_storage, disk_offering.system_use, > >>> disk_offering.customized, disk_offering.uuid, > >>> disk_offering.customized_iops, disk_offering.min_iops, > >>> disk_offering.max_iops, disk_offering.sort_key, > >>> disk_offering.bytes_read_rate, disk_offering.bytes_write_rate, > >>> disk_offering.iops_read_rate, disk_offering.iops_write_rate, > >>> disk_offering.cache_mode, disk_offering.display_offering, > >>> disk_offering.state, disk_offering.hv_ss_reserve, > >>> service_offering.cpu, service_offering.speed, > >>> service_offering.ram_size, service_offering.nw_rate, > >>> service_offering.mc_rate, service_offering.ha_enabled, > >>> service_offering.limit_cpu_use, service_offering.is_volatile, > >>> service_offering.host_tag, service_offering.default_use, > >>> service_offering.vm_type, service_offering.sort_key, > >>> service_offering.deployment_planner FROM service_offering INNER > JOIN > >>> disk_offering ON service_offering.id=disk_ offering.id WHERE > disk_offering.type='Service' AND disk_offering.unique_name = > _binary'Cloud.Com-Small Instance' AND disk_offering.system_use = 1 AND > disk_offering.removed IS NULL : > >>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Unknown > >>> column 'disk_offering.cache_mode' in 'field list' > >>> > >>> > >>> This is the definition of disk_offering from create-schema.sql > >>> > >>> CREATE TABLE `cloud`.`disk_offering` ( > >>> `id` bigint unsigned NOT NULL auto_increment, > >>> `domain_id` bigint unsigned, > >>> `name` varchar(255) NOT NULL, > >>> `uuid` varchar(40), > >>> `display_text` varchar(4096) NULL COMMENT 'Descrianaption text > >>> set by the admin for display purpose only', > >>> `disk_size` bigint unsigned NOT NULL COMMENT 'disk space in byte', > >>> `type` varchar(32) COMMENT 'inheritted by who?', > >>> `tags` varchar(4096) COMMENT 'comma separated tags about the > >>> disk_offering', > >>> `recreatable` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT 'The > >>> root disk is always recreatable', > >>> `use_local_storage` tinyint(1) unsigned NOT NULL DEFAULT 0 > >>> COMMENT 'Indicates whether local storage pools should be used', > >>> `unique_name` varchar(32) UNIQUE COMMENT 'unique name', > >>> `system_use` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT 'is > >>> this offering for system used only', > >>> `customized` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT '0 > >>> implies not customized by default', > >>> `removed` datetime COMMENT 'date removed', > >>> `created` datetime COMMENT 'date the disk offering was created', > >>> `sort_key` int(32) NOT NULL default 0 COMMENT 'sort key used for > >>> customising sort method', > >>> PRIMARY KEY (`id`), > >>> INDEX `i_disk_offering__removed`(`removed`), > >>> CONSTRAINT `uc_disk_offering__uuid` UNIQUE (`uuid`) > >>> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > >>> > >>> > >>> And this is in my DB > >>> > >>> mysql> describe disk_offering; > >>> +-------------------+---------------------+------+-----+---- > >>> -----+----------------+ > >>> | Field | Type | Null | Key | Default | Extra > >>> | > >>> +-------------------+---------------------+------+-----+---- > >>> -----+----------------+ > >>> | id | bigint(20) unsigned | NO | PRI | NULL | > >>> auto_increment | > >>> | domain_id | bigint(20) unsigned | YES | | NULL | > >>> | > >>> | name | varchar(255) | NO | | NULL | > >>> | > >>> | uuid | varchar(40) | YES | UNI | NULL | > >>> | > >>> | display_text | varchar(4096) | YES | | NULL | > >>> | > >>> | disk_size | bigint(20) unsigned | NO | | NULL | > >>> | > >>> | type | varchar(32) | YES | | NULL | > >>> | > >>> | tags | varchar(4096) | YES | | NULL | > >>> | > >>> | recreatable | tinyint(1) unsigned | NO | | 0 | > >>> | > >>> | use_local_storage | tinyint(1) unsigned | NO | | 0 | > >>> | > >>> | unique_name | varchar(32) | YES | UNI | NULL | > >>> | > >>> | system_use | tinyint(1) unsigned | NO | | 0 | > >>> | > >>> | customized | tinyint(1) unsigned | NO | | 0 | > >>> | > >>> | removed | datetime | YES | MUL | NULL | > >>> | > >>> | created | datetime | YES | | NULL | > >>> | > >>> | sort_key | int(32) | NO | | 0 | > >>> | > >>> | display_offering | tinyint(1) | NO | | 1 | > >>> | > >>> | customized_iops | tinyint(1) unsigned | YES | | NULL | > >>> | > >>> | min_iops | bigint(20) unsigned | YES | | NULL | > >>> | > >>> | max_iops | bigint(20) unsigned | YES | | NULL | > >>> | > >>> | bytes_read_rate | bigint(20) | YES | | NULL | > >>> | > >>> | bytes_write_rate | bigint(20) | YES | | NULL | > >>> | > >>> | iops_read_rate | bigint(20) | YES | | NULL | > >>> | > >>> | iops_write_rate | bigint(20) | YES | | NULL | > >>> | > >>> | state | char(40) | NO | | Active | > >>> | > >>> | hv_ss_reserve | int(32) unsigned | YES | | NULL | > >>> | > >>> +-------------------+---------------------+------+-----+---- > >>> -----+----------------+ > >>> 26 rows in set (0.00 sec) > >>> > >>> > >>> I don't see "cache_mode" anywhere. Does anyone else have this > problem? > >>> > >>> Thanks, > >>> -Syed > >>> > >>> > >> > > > >
