cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daan Hoogland <daan.hoogl...@gmail.com>
Subject Re: [ACS4.5] SQL Error
Date Tue, 24 Jun 2014 08:25:32 GMT
I reverted my and Ian's commits. I will have a look on how to rebase
them in ovmsupport on latest master.

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