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

[Laszlo Hornyak]

hi,

The search queries generate these statements. It looks like something replaced the underscores with spaces in the view names, and that is not good for SQL. But the backend should not do this, maybe only restapi replaces something in the erromessages?
Possibly the db upgrade failed somewhere and it left the schema without views?


----- Original Message -----
> From: "Yair Zaslavsky" <yzaslavs at redhat.com>
> To: "Christopher Morrissey" <Christopher.Morrissey at netapp.com>
> Cc: engine-devel at ovirt.org
> Sent: Wednesday, November 14, 2012 4:02:17 AM
> Subject: Re: [Engine-devel] Unable to view the storage domains - SQL error
> 
> 
> 
> 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
> 
> 
> 
> 
> 
> 
> 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
> 
> 
> _______________________________________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel
>