cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebgoa <run...@gmail.com>
Subject Re: [ACS4.5] SQL Error
Date Tue, 24 Jun 2014 08:35:25 GMT

On Jun 24, 2014, at 10:25 AM, Daan Hoogland <daan.hoogland@gmail.com> wrote:

> I reverted my and Ian's commits. I will have a look on how to rebase
> them in ovmsupport on latest master.

Right, Funs should submit reviews for the ovmsupport branch to get it in sync with master.
The branch was created off an old commit dated back January 2014 (because that's when he started).

Once the branch is tested, rebased etc…we should call a [MERGE]...

> 
> On Tue, Jun 24, 2014 at 10:19 AM, Daan Hoogland <daan.hoogland@gmail.com> wrote:
>> I will revert, this is definatelly my bad.
>> 
>> On Tue, Jun 24, 2014 at 9:00 AM, sebgoa <runseb@gmail.com> wrote:
>>> Looping Daan in,
>>> 
>>> I created an ovmsupport branch to drop some early WIP about ovm3 support. This
is not yet ready for merge to master.
>>> No ovm3 stuff should be committed to master.
>>> 
>>> @Daan, can you revert the commits you made yesterday ?
>>> 
>>> -Sebastien
>>> 
>>> 
>>> On Jun 24, 2014, at 12:14 AM, Mike Tutkowski <mike.tutkowski@solidfire.com>
wrote:
>>> 
>>>> Looks like we have another SQL issue on master (this time clicking on the
>>>> Storage button in the GUI):
>>>> 
>>>> DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@7e1b4c2b: SELECT
>>>> volume_view.id, volume_view.uuid, volume_view.name, volume_view.device_id,
>>>> volume_view.volume_type, volume_view.provisioning_type, volume_view.size,
>>>> volume_view.min_iops, volume_view.max_iops, volume_view.state,
>>>> volume_view.created, volume_view.attached, volume_view.removed,
>>>> volume_view.account_id, volume_view.account_uuid, volume_view.account_name,
>>>> volume_view.account_type, volume_view.domain_id, volume_view.domain_uuid,
>>>> volume_view.domain_name, volume_view.domain_path, volume_view.project_id,
>>>> volume_view.project_uuid, volume_view.project_name, volume_view.pod_id,
>>>> volume_view.data_center_id, volume_view.data_center_uuid,
>>>> volume_view.data_center_name, volume_view.vm_id, volume_view.vm_uuid,
>>>> volume_view.vm_name, volume_view.vm_display_name, volume_view.vm_state,
>>>> volume_view.vm_type, volume_view.volume_store_size,
>>>> volume_view.created_on_store, volume_view.format, volume_view.download_pct,
>>>> volume_view.download_state, volume_view.error_str,
>>>> volume_view.hypervisor_type, volume_view.disk_offering_id,
>>>> volume_view.disk_offering_uuid, volume_view.disk_offering_name,
>>>> volume_view.disk_offering_display_text, volume_view.system_use,
>>>> volume_view.use_local_storage, volume_view.bytes_read_rate,
>>>> volume_view.bytes_write_rate, volume_view.iops_read_rate,
>>>> volume_view.iops_write_rate, volume_view.pool_id, volume_view.pool_uuid,
>>>> volume_view.pool_name, volume_view.template_id, volume_view.template_uuid,
>>>> volume_view.template_name, volume_view.template_display_text,
>>>> volume_view.extractable, volume_view.template_type, volume_view.iso_id,
>>>> volume_view.iso_uuid, volume_view.iso_name, volume_view.iso_display_text,
>>>> volume_view.job_id, volume_view.job_uuid, volume_view.job_status,
>>>> volume_view.tag_id, volume_view.tag_uuid, volume_view.tag_key,
>>>> volume_view.tag_value, volume_view.tag_domain_id,
>>>> volume_view.tag_account_id, volume_view.tag_resource_id,
>>>> volume_view.tag_resource_uuid, volume_view.tag_resource_type,
>>>> volume_view.tag_customer, volume_view.display_volume, volume_view.path,
>>>> volume_view.chain_info FROM volume_view WHERE volume_view.id=3
>>>> 
>>>> 
>>>> On Mon, Jun 23, 2014 at 1:47 PM, Mike Tutkowski <
>>>> mike.tutkowski@solidfire.com> wrote:
>>>> 
>>>>> I see they had an extra couple "$" chars in the code. Thanks for removing
>>>>> them, Ian.
>>>>> 
>>>>> 
>>>>> On Mon, Jun 23, 2014 at 1:43 PM, Mike Tutkowski <
>>>>> mike.tutkowski@solidfire.com> wrote:
>>>>> 
>>>>>> Thanks, Ian
>>>>>> 
>>>>>> 
>>>>>> On Mon, Jun 23, 2014 at 1:41 PM, Ian Duffy <ian@ianduffy.ie>
wrote:
>>>>>> 
>>>>>>> Just pushed a fix for it.
>>>>>>> 
>>>>>>>> The OVM stuff was put in the ovmsupport branch, nothing should
be on
>>>>>>> master
>>>>>>> 
>>>>>>> There is stuff in master....
>>>>>>> 
>>>>>>> 
>>>>>>> https://github.com/apache/cloudstack/commit/8a485b9b59e4108e862022baf7477f768380b325
>>>>>>> 
>>>>>>> On 23 June 2014 20:38, Sebastien Goasguen <runseb@gmail.com>
wrote:
>>>>>>> 
>>>>>>>> 
>>>>>>>> On Jun 23, 2014, at 3:34 PM, Ian Duffy <ian@ianduffy.ie>
wrote:
>>>>>>>> 
>>>>>>>>> Hey Mike,
>>>>>>>>> 
>>>>>>>>> This appears to be correct.
>>>>>>>>> 
>>>>>>>>> There newly added lines in create-schema-sql ending in
;$
>>>>>>>>> 
>>>>>>>>> They appear to be introduced with the OVM stuff.
>>>>>>>> 
>>>>>>>> The OVM stuff was put in the ovmsupport branch, nothing should
be on
>>>>>>> master
>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> On 23 June 2014 20:17, Mike Tutkowski <mike.tutkowski@solidfire.com>
>>>>>>>> wrote:
>>>>>>>>> 
>>>>>>>>>> Do we seriously have an error in our SQL code? :)
I ran mvn -P
>>>>>>> developer
>>>>>>>>>> -pl developer -D deploydb and received the following:
>>>>>>>>>> 
>>>>>>>>>> ========> Processing SQL file at
>>>>>>>>>> /home/cloudstack/cloudstack/developer/target/db/create-schema.sql
>>>>>>>>>> Unable to execute
>>>>>>>>>> /home/cloudstack/cloudstack/developer/target/db/create-schema.sql:
>>>>>>> You
>>>>>>>> have
>>>>>>>>>> an error in your SQL syntax; check the manual that
corresponds to
>>>>>>> your
>>>>>>>>>> MySQL server version for the right syntax to use
near '$ INSERT
>>>>>>> IGNORE
>>>>>>>> INTO
>>>>>>>>>> `cloud`.`hypervisor_capabilities`(hypervisor_type,
hypervis' at
>>>>>>> line 1
>>>>>>>>>> 
>>>>>>>>>> --
>>>>>>>>>> *Mike Tutkowski*
>>>>>>>>>> *Senior CloudStack Developer, SolidFire Inc.*
>>>>>>>>>> e: mike.tutkowski@solidfire.com
>>>>>>>>>> o: 303.746.7302
>>>>>>>>>> Advancing the way the world uses the cloud
>>>>>>>>>> <http://solidfire.com/solution/overview/?video=play>*™*
>>>>>>>>>> 
>>>>>>>> 
>>>>>>>> 
>>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> --
>>>>>> *Mike Tutkowski*
>>>>>> *Senior CloudStack Developer, SolidFire Inc.*
>>>>>> e: mike.tutkowski@solidfire.com
>>>>>> o: 303.746.7302
>>>>>> Advancing the way the world uses the cloud
>>>>>> <http://solidfire.com/solution/overview/?video=play>*™*
>>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> --
>>>>> *Mike Tutkowski*
>>>>> *Senior CloudStack Developer, SolidFire Inc.*
>>>>> e: mike.tutkowski@solidfire.com
>>>>> o: 303.746.7302
>>>>> Advancing the way the world uses the cloud
>>>>> <http://solidfire.com/solution/overview/?video=play>*™*
>>>>> 
>>>> 
>>>> 
>>>> 
>>>> --
>>>> *Mike Tutkowski*
>>>> *Senior CloudStack Developer, SolidFire Inc.*
>>>> e: mike.tutkowski@solidfire.com
>>>> o: 303.746.7302
>>>> Advancing the way the world uses the cloud
>>>> <http://solidfire.com/solution/overview/?video=play>*™*
>>> 
>> 
>> 
>> 
>> --
>> Daan
> 
> 
> 
> -- 
> Daan


Mime
View raw message