Re: [ACS4.5] SQL Error

2014-06-24 Thread sebgoa
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

Re: [ACS4.5] SQL Error

2014-06-24 Thread Daan Hoogland
I will revert, this is definatelly my bad. On Tue, Jun 24, 2014 at 9:00 AM, sebgoa run...@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.

Re: [ACS4.5] SQL Error

2014-06-24 Thread Daan Hoogland
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.hoogl...@gmail.com wrote: I will revert, this is definatelly my bad. On Tue, Jun 24, 2014 at 9:00 AM, sebgoa run...@gmail.com wrote:

Re: [ACS4.5] SQL Error

2014-06-24 Thread sebgoa
On Jun 24, 2014, at 10:25 AM, Daan Hoogland daan.hoogl...@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

Re: [ACS4.5] SQL Error

2014-06-24 Thread Rajani Karuturi
I also faced this issue on master today. Logged a defect in jira https://issues.apache.org/jira/browse/CLOUDSTACK-6986 ~Rajani On 24-Jun-2014, at 3:44 am, Mike Tutkowski mike.tutkow...@solidfire.commailto:mike.tutkow...@solidfire.com wrote: Looks like we have another SQL issue on master

Re: [ACS4.5] SQL Error

2014-06-24 Thread Rajani Karuturi
oops... looks like its already fixed. will close once i take the latest and test. ~Rajani On 24-Jun-2014, at 3:05 pm, Rajani Karuturi rajani.karut...@citrix.commailto:rajani.karut...@citrix.com wrote: I also faced this issue on master today. Logged a defect in jira

[ACS4.5] SQL Error

2014-06-23 Thread Mike Tutkowski
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

Re: [ACS4.5] SQL Error

2014-06-23 Thread Ian Duffy
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. 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

Re: [ACS4.5] SQL Error

2014-06-23 Thread Mike Tutkowski
I think the problem is that no primary key is specified: http://smallbusiness.chron.com/duplicate-ignore-mysql-inserts-28260.html If we need to specify a primary key for these statements to work, I'm not sure how we can use them because the id column is auto-incremented. On Mon, Jun 23, 2014

Re: [ACS4.5] SQL Error

2014-06-23 Thread Sebastien Goasguen
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

Re: [ACS4.5] SQL Error

2014-06-23 Thread Ian Duffy
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

Re: [ACS4.5] SQL Error

2014-06-23 Thread Mike Tutkowski
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

Re: [ACS4.5] SQL Error

2014-06-23 Thread Mike Tutkowski
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

Re: [ACS4.5] SQL Error

2014-06-23 Thread Mike Tutkowski
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,