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.tutkow...@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.tutkow...@solidfire.com> wrote: > >> Thanks, Ian >> >> >> On Mon, Jun 23, 2014 at 1:41 PM, Ian Duffy <i...@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 <run...@gmail.com> wrote: >>> >>> > >>> > On Jun 23, 2014, at 3:34 PM, Ian Duffy <i...@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.tutkow...@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.tutkow...@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.tutkow...@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.tutkow...@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.tutkow...@solidfire.com o: 303.746.7302 Advancing the way the world uses the cloud <http://solidfire.com/solution/overview/?video=play>*™*
