------=_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@netapp.com> To: engine-devel@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
</div><div><font face=3D"Calibri, sans-serif"><span style=3D"font-size: 15=
------=_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= 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@netapp.com><br><b>To: </b>engine-devel@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--