[Engine-devel] Unable to view the storage domains - SQL error

[Yair Zaslavsky]

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" <Christopher.Morrissey at netapp.com>
> To: engine-devel at ovirt.org
> 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
> Engine-devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/engine-devel/attachments/20121113/10ccfe64/attachment.html>