12:10 a.m.
--_000_D290AD8432118048947689BA3AE8A9B3EBA578SACEXCMBX04PRDhqn_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi All,
I'm getting an error when trying to view the storage domains using the REST=
API:
<?xml version=3D"1.0" encoding=3D"UTF-8"
standalone=3D"yes"? <fault <reason>Operation Failed</reason <detail>statementcallback; bad sql grammar [select *
from (select * fro=
m storage domains for search where ( id in (select storage domains with hos=
ts view.id from storage domains with hosts view )) order by storage name as=
c ) 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 l=
ist never loads.
Did something change in the DB recently such that I would need to rebuild i=
t?
-Chris
Chris Morrissey
Software Engineer
NetApp Inc.
919.476.4428
--_000_D290AD8432118048947689BA3AE8A9B3EBA578SACEXCMBX04PRDhqn_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml"
xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word"
=
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
xmlns=3D"http:=
//www.w3.org/TR/REC-html40" <head <meta http-equiv=3D"Content-Type"
content=3D"text/html; charset=3Dus-ascii"=
<meta name=3D"Generator" content=3D"Microsoft
Word 14 (filtered medium)" <style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" / </xml><![endif]--><!--[if gte mso
9]><xml <o:shapelayout
v:ext=3D"edit" <o:idmap v:ext=3D"edit"
data=3D"1" /
</o:shapelayout></xml><![endif]--
</head <body lang=3D"EN-US"
link=3D"blue" vlink=3D"purple" <div
class=3D"WordSection1" <p
class=3D"MsoNormal">Hi All,<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal">I’m getting an
error when trying to view the s=
torage domains using the REST API:<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal"><?xml
version=3D"1.0" encoding=3D"=
UTF-8"
standalone=3D"yes"?><o:p></o:p></p <p
class=3D"MsoNormal"><fault><o:p></o:p></p <p
class=3D"MsoNormal">
<reason>Operation Failed<=
;/reason><o:p></o:p></p <p
class=3D"MsoNormal">
<detail>statementcallback; =
bad sql grammar [select * from (select * from storage domains for search wh=
ere ( 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 posit=
ion: 30</detail><o:p></o:p></p <p
class=3D"MsoNormal"></fault><o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal">Also, through the web
admin console, when viewing th=
e storage domains the list never loads.<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal">Did something change in
the DB recently such that I =
would need to rebuild it?<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p
class=3D"MsoNormal">-Chris<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p <p class=3D"MsoNormal"><b>Chris
Morrissey<o:p></o:p></b></p <p
class=3D"MsoNormal">Software Engineer<o:p></o:p></p <p class=3D"MsoNormal">NetApp
Inc.<o:p></o:p></p <p
class=3D"MsoNormal">919.476.4428<o:p></o:p></p <p
class=3D"MsoNormal"><o:p> </o:p></p </div
</body </html
--_000_D290AD8432118048947689BA3AE8A9B3EBA578SACEXCMBX04PRDhqn_--
5:02 a.m.
------=_Part_31325702_2144380534.1352862137081
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Hi Christopher,=20
In general - as a developer at engine project, I would recommend to run the=
upgrade script on a frequent basis.=20
What troubles me with the query you sent (maybe some problematic copy paste=
issue?) are the following issues:=20
a. storage domains for search - not sure what this is=20
b. storage domains with hosts view - I guess you have some underline issue =
at the copy paste.=20
I would appreciate if you attach engine.log (or a part of it that reflects =
the error you encountered)=20
Kind regards,=20
Yair=20
----- Original Message -----
From: "Christopher Morrissey"
<Christopher.Morrissey(a)netapp.com>
To: engine-devel(a)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=E2=80=99m getting an error when trying to view the storage domains
usin=
g
the REST API:
<?xml version=3D"1.0" encoding=3D"UTF-8"
standalone=3D"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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel
------=_Part_31325702_2144380534.1352862137081
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><style type=3D'text/css'>p { margin: 0;
}</style></head><body><=
div style=3D'font-family: times new roman,new york,times,serif; font-size: =
12pt; color: #000000'><font face=3D"times new roman, new york, times,
serif=
" size=3D"3">Hi Christopher,</font><div
style=3D"font-family: 'times new ro=
man', 'new york', times, serif; font-size: 12pt;">In general - as a
develop=
er at engine project, I would recommend to run the upgrade script on a freq=
uent basis.</div><div style=3D"font-family: 'times new roman',
'new york', =
times, serif; font-size: 12pt;">What troubles me with the query you sent (m=
aybe some problematic copy paste issue?) are the following issues:</d=
iv><div style=3D"font-family: 'times new roman', 'new york',
times, serif; =
font-size: 12pt;">a. <span style=3D"font-family: Calibri,
sans-serif; =
font-size: 15px;">storage domains for search</span><span
style=3D"font-fami=
ly: Calibri, sans-serif; font-size: 15px;"> - not sure what this
is&n=
bsp;</span></div><div style=3D"font-family: 'times new roman',
'new york', =
times, serif; font-size: 12pt;"><span style=3D"font-family: Calibri,
sans-s=
erif; font-size: 15px;">b. </span><span
style=3D"font-family: Calibri,=
sans-serif; font-size: 15px;">storage domains with hosts view - I guess &n=
bsp;you have some underline issue at the copy paste.</span></div><div
style=
=3D"font-family: 'times new roman', 'new york', times, serif;
font-size: 12=
pt;"><br></div><div><font face=3D"Calibri,
sans-serif"><span style=3D"font-=
size: 15px;">I would appreciate if you attach engine.log (or a part of it t=
hat reflects the error you
encountered)</span></font></div><div><font face=
=3D"Calibri, sans-serif"><span style=3D"font-size:
15px;"><br></span></font=
</div><div><font face=3D"Calibri,
sans-serif"><span style=3D"font-size: 15=
px;">Kind
regards,</span></font></div><div><font face=3D"Calibri,
sans-seri=
f"><span style=3D"font-size:
15px;">Yair</span></font></div><div><font face=
=3D"Calibri, sans-serif"><span style=3D"font-size:
15px;"><br></span></font=
</div><div style=3D"font-family: 'times new
roman', 'new york', times, ser=
if; font-size:
12pt;"><br><hr id=3D"zwchr"><blockquote
style=3D"border-left=
:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;fon=
t-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetic=
a,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Christopher
Morrissey" &l=
t;Christopher.Morrissey(a)netapp.com&gt;<br><b>To:
</b>engine-devel(a)ovirt.org=
<br><b>Sent: </b>Wednesday, November 14, 2012 12:10:14
AM<br><b>Subject: </=
b>[Engine-devel] Unable to view the storage domains - SQL error<br><br>
<style><!--
@font-face
=09{font-family:Calibri;
=09panose-1:2 15 5 2 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0in;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
=09{mso-style-priority:99;
=09color:blue;
=09text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
=09{mso-style-priority:99;
=09color:purple;
=09text-decoration:underline;}
span.EmailStyle17
=09{mso-style-type:personal-compose;
=09font-family:"Calibri","sans-serif";
=09color:windowtext;}
.MsoChpDefault
=09{mso-style-type:export-only;
=09font-family:"Calibri","sans-serif";}
@page WordSection1
=09{size:8.5in 11.0in;
=09margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
=09{page:WordSection1;}
--></style>
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi All,</p>
<p class=3D"MsoNormal"> </p>
<p class=3D"MsoNormal">I=E2=80=99m getting an error when trying to view
the=
storage domains using the REST API:</p>
<p class=3D"MsoNormal"> </p>
<p class=3D"MsoNormal"><?xml version=3D"1.0"
encoding=3D"UTF-8" standalo=
ne=3D"yes"?></p>
<p class=3D"MsoNormal"><fault></p>
<p class=3D"MsoNormal">
<reason>Operation Failed<=
;/reason></p>
<p class=3D"MsoNormal">
<detail>statementcallback; =
bad sql grammar [select * from (select * from storage domains for search wh=
ere ( 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></p>
<p class=3D"MsoNormal"></fault></p>
<p class=3D"MsoNormal"> </p>
<p class=3D"MsoNormal">Also, through the web admin console, when viewing
th=
e storage domains the list never loads.</p>
<p class=3D"MsoNormal"> </p>
<p class=3D"MsoNormal" id=3D"DWT244">Did something change in the
DB recentl=
y such that I would need to rebuild
it?</p></div></blockquote><blockquote s=
tyle=3D"border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left=
:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;f=
ont-family:Helvetica,Arial,sans-serif;font-size:12pt;"><div
class=3D"WordSe=
ction1"><p class=3D"MsoNormal"></p>
<p class=3D"MsoNormal"
id=3D"DWT245"></p></div></blockquote><blockquote sty=
le=3D"border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5=
px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;fon=
t-family:Helvetica,Arial,sans-serif;font-size:12pt;"><div
class=3D"WordSect=
ion1"><p class=3D"MsoNormal"> </p>
<p class=3D"MsoNormal">-Chris</p>
<p class=3D"MsoNormal"> </p>
<p class=3D"MsoNormal"><b>Chris Morrissey</b></p>
<p class=3D"MsoNormal">Software Engineer</p>
<p class=3D"MsoNormal">NetApp Inc.</p>
<p class=3D"MsoNormal">919.476.4428</p>
<p class=3D"MsoNormal"> </p>
</div>
<br>_______________________________________________<br>Engine-devel mailing=
list<br>Engine-devel@ovirt.org<br>http://lists.ovirt.org/mailman/listinfo/=
engine-devel<br></blockquote><br></div></div></body></html>
------=_Part_31325702_2144380534.1352862137081--
1:01 p.m.
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(a)redhat.com>
To: "Christopher Morrissey" <Christopher.Morrissey(a)netapp.com>
Cc: engine-devel(a)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(a)netapp.com>
To: engine-devel(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________
Engine-devel mailing list
Engine-devel(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel
4:53 p.m.
Thanks for the advice. I rebuild my DB and it seems to be working now. I'll make sure
to do that whenever pulling down new code in the future.
-Chris
-----Original Message-----
From: Laszlo Hornyak [mailto:lhornyak@redhat.com]
Sent: Wednesday, November 14, 2012 6:02 AM
To: Yair Zaslavsky; Morrissey, Christopher
Cc: engine-devel(a)ovirt.org
Subject: Re: [Engine-devel] Unable to view the storage domains - SQL error
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(a)redhat.com>
To: "Christopher Morrissey" <Christopher.Morrissey(a)netapp.com>
Cc: engine-devel(a)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(a)netapp.com>
To: engine-devel(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________
Engine-devel mailing list
Engine-devel(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel
4393
days inactive
4394
days old
3 comments
3 participants
participants (3)
-
Laszlo Hornyak -
Morrissey, Christopher -
Yair Zaslavsky