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 mailto:rajani.karut...@citrix.com>> wrote: I also faced this issue on master today. Logged a defect in jira https://issues.apache.org/jira/browse/CLOUDSTACK-

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 mailto:mike.tutkow...@solidfire.com>> wrote: Looks like we have another SQL issue on master (this time clicking on the St

Re: [ACS4.5] SQL Error

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

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 wrote: > I will revert, this is definatelly my bad. > > On Tue, Jun 24, 2014 at 9:00 AM, sebgoa wrote: >> Looping Daan in, >> >> I created an

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 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 yo

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 w

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, volume_view.provisioning

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 wrote: > >> Just pushed a fix for it. >> >> > The OVM stuff

Re: [ACS4.5] SQL Error

2014-06-23 Thread Mike Tutkowski
Thanks, Ian On Mon, Jun 23, 2014 at 1:41 PM, Ian Duffy 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/8a485b9b59e4108e862022baf7477f768380b3

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 wrote: > > On Jun 23, 2014, at 3:

Re: [ACS4.5] SQL Error

2014-06-23 Thread Sebastien Goasguen
On Jun 23, 2014, at 3:34 PM, Ian Duffy 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 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 at

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 wrote: > Do we seriously have an error in our SQL code? :) I ran mvn -P developer > -pl developer -D deploydb

[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 /home/cloudstack/cloudstack/developer/target/db/create