Hi Christopher, In general - as a developer at engine project, I would recommend to run the upgrade script on a frequent basis. What troubles me with the query you sent (maybe some problematic copy paste issue?) are the following issues: a. storage domains for search - not sure what this is b. storage domains with hosts view - I guess you have some underline issue at the copy paste.
I would appreciate if you attach engine.log (or a part of it that reflects the error you encountered) Kind regards, Yair ----- Original Message ----- > From: "Christopher Morrissey" <[email protected]> > To: [email protected] > Sent: Wednesday, November 14, 2012 12:10:14 AM > Subject: [Engine-devel] Unable to view the storage domains - SQL > error > Hi All, > I’m getting an error when trying to view the storage domains using > the REST API: > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <fault> > <reason>Operation Failed</reason> > <detail>statementcallback; bad sql grammar [select * from (select * > from storage domains for search where ( id in (select storage > domains with hosts view.id from storage domains with hosts view )) > order by storage name asc ) as t1 offset (1 -1) limit 100]; nested > exception is org.postgresql.util.psqlexception: error: relation > "storage domains for search" does not exist position: 30</detail> > </fault> > Also, through the web admin console, when viewing the storage domains > the list never loads. > Did something change in the DB recently such that I would need to > rebuild it? > -Chris > Chris Morrissey > Software Engineer > NetApp Inc. > 919.476.4428 > _______________________________________________ > Engine-devel mailing list > [email protected] > http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-devel
