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