You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Syed Ahmed <sa...@cloudops.com> on 2013/11/20 20:59:38 UTC
Error while running master
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
Re: Error while running master
Posted by Wei ZHOU <us...@gmail.com>.
Thanks Hugo.
Wido, it failed when CS create the default offerings in
server/src/com/cloud/server/ConfigurationServerImpl.java, as "Column
'cache_mode' cannot be null" . Can you fix it?
Can cache_mode be null in database?
2013/11/21 Hugo Trippaers <hu...@trippaers.nl>
> Just bumped master to 4.4.0 and Wido did the upgrade scripts
>
> Cheers,
>
> Hugo
>
> On 21 nov. 2013, at 16:19, Alex Huang <Al...@citrix.com> wrote:
>
> > Here's a wiki page about it.
> >
> >
> https://cwiki.apache.org/confluence/display/CLOUDSTACK/DB+Upgrade+in+CloudStack
> >
> > --Alex
> >
> >> -----Original Message-----
> >> From: Syed Ahmed [mailto:sahmed@cloudops.com]
> >> Sent: Wednesday, November 20, 2013 12:37 PM
> >> To: dev@cloudstack.apache.org
> >> Cc: Wei ZHOU
> >> Subject: Re: Error while running master
> >>
> >> 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?
> >>
> >>
> >> 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 <sa...@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
> >>>>
> >>>>
> >>>
> >>
> >
>
>
Re: Error while running master
Posted by Hugo Trippaers <hu...@trippaers.nl>.
Just bumped master to 4.4.0 and Wido did the upgrade scripts
Cheers,
Hugo
On 21 nov. 2013, at 16:19, Alex Huang <Al...@citrix.com> wrote:
> Here's a wiki page about it.
>
> https://cwiki.apache.org/confluence/display/CLOUDSTACK/DB+Upgrade+in+CloudStack
>
> --Alex
>
>> -----Original Message-----
>> From: Syed Ahmed [mailto:sahmed@cloudops.com]
>> Sent: Wednesday, November 20, 2013 12:37 PM
>> To: dev@cloudstack.apache.org
>> Cc: Wei ZHOU
>> Subject: Re: Error while running master
>>
>> 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?
>>
>>
>> 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 <sa...@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
>>>>
>>>>
>>>
>>
>
RE: Error while running master
Posted by Alex Huang <Al...@citrix.com>.
Here's a wiki page about it.
https://cwiki.apache.org/confluence/display/CLOUDSTACK/DB+Upgrade+in+CloudStack
--Alex
> -----Original Message-----
> From: Syed Ahmed [mailto:sahmed@cloudops.com]
> Sent: Wednesday, November 20, 2013 12:37 PM
> To: dev@cloudstack.apache.org
> Cc: Wei ZHOU
> Subject: Re: Error while running master
>
> 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?
>
>
> 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 <sa...@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
> >>
> >>
> >
>
RE: Error while running master
Posted by Alex Huang <Al...@citrix.com>.
Feature freeze for 4.3 is closed. This should go into the new db upgrade.
--Alex
> -----Original Message-----
> From: Wido den Hollander [mailto:wido@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 <sa...@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
> >>>
> >>>
> >>
> >
> >
Re: Error while running master
Posted by Wido den Hollander <wi...@widodh.nl>.
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 <sa...@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
>>>
>>>
>>
>
>
Re: Error while running master
Posted by Syed Ahmed <sa...@cloudops.com>.
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?
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 <sa...@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
>>
>>
>
Re: Error while running master
Posted by Wei ZHOU <us...@gmail.com>.
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 <sa...@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
>
>