From Christopher.Morrissey at netapp.com Tue Nov 13 17:10:33 2012 Content-Type: multipart/mixed; boundary="===============5453801048614908035==" MIME-Version: 1.0 From: Morrissey, Christopher To: devel at ovirt.org Subject: [Engine-devel] Unable to view the storage domains - SQL error Date: Tue, 13 Nov 2012 22:10:14 +0000 Message-ID: --===============5453801048614908035== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable --_000_D290AD8432118048947689BA3AE8A9B3EBA578SACEXCMBX04PRDhqn_ Content-Type: text/plain; charset=3D"us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, I'm getting an error when trying to view the storage domains using the REST= =3D API: Operation Failed statementcallback; bad sql grammar [select * from (select * fro= =3D m storage domains for search where ( id in (select storage domains with hos= =3D ts view.id from storage domains with hosts view )) order by storage name as= =3D c ) as t1 offset (1 -1) limit 100]; nested exception is org.postgresql.util= =3D .psqlexception: error: relation "storage domains for search" does not exist= =3D position: 30 Also, through the web admin console, when viewing the storage domains the l= =3D ist never loads. Did something change in the DB recently such that I would need to rebuild i= =3D t? -Chris Chris Morrissey Software Engineer NetApp Inc. 919.476.4428 --_000_D290AD8432118048947689BA3AE8A9B3EBA578SACEXCMBX04PRDhqn_ Content-Type: text/html; charset=3D"us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All,

 

I’m getting an error when trying to view the= s=3D torage domains using the REST API:

 

<?xml version=3D3D"1.0" encoding=3D3D= "=3D UTF-8" standalone=3D3D"yes"?>

<fault>

    <reason>Operation Failed&= lt=3D ;/reason>

    <detail>statementcallback= ; =3D bad sql grammar [select * from (select * from storage domains for search wh= =3D ere ( id in (select storage domains with hosts view.id from storage domains= =3D with hosts view )) order by storage name asc ) as t1 offset (1 -1) limit 100]; nested exception is org.postgresql.util.psqlexception: = =3D error: relation "storage domains for search" does not exist posit= =3D ion: 30</detail>

</fault>

 

Also, through the web admin console, when viewing = th=3D e storage domains the list never loads.

 

Did something change in the DB recently such that = I =3D would need to rebuild it?

 

-Chris

 

Chris Morrissey

Software Engineer

NetApp Inc.

919.476.4428

 

--_000_D290AD8432118048947689BA3AE8A9B3EBA578SACEXCMBX04PRDhqn_-- --===============5453801048614908035== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" LS1fMDAwX0QyOTBBRDg0MzIxMTgwNDg5NDc2ODlCQTNBRThBOUIzRUJBNTc4U0FDRVhDTUJYMDRQ UkRocW5fCkNvbnRlbnQtVHlwZTogdGV4dC9wbGFpbjsgY2hhcnNldD0idXMtYXNjaWkiCkNvbnRl bnQtVHJhbnNmZXItRW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKCkhpIEFsbCwKCkknbSBnZXR0 aW5nIGFuIGVycm9yIHdoZW4gdHJ5aW5nIHRvIHZpZXcgdGhlIHN0b3JhZ2UgZG9tYWlucyB1c2lu ZyB0aGUgUkVTVD0KIEFQSToKCjw/eG1sIHZlcnNpb249M0QiMS4wIiBlbmNvZGluZz0zRCJVVEYt OCIgc3RhbmRhbG9uZT0zRCJ5ZXMiPz4KPGZhdWx0PgogICAgPHJlYXNvbj5PcGVyYXRpb24gRmFp bGVkPC9yZWFzb24+CiAgICA8ZGV0YWlsPnN0YXRlbWVudGNhbGxiYWNrOyBiYWQgc3FsIGdyYW1t YXIgW3NlbGVjdCAqIGZyb20gKHNlbGVjdCAqIGZybz0KbSBzdG9yYWdlIGRvbWFpbnMgZm9yIHNl YXJjaCB3aGVyZSAoIGlkIGluIChzZWxlY3Qgc3RvcmFnZSBkb21haW5zIHdpdGggaG9zPQp0cyB2 aWV3LmlkIGZyb20gc3RvcmFnZSBkb21haW5zIHdpdGggaG9zdHMgdmlldyApKSBvcmRlciBieSBz dG9yYWdlIG5hbWUgYXM9CmMgKSBhcyB0MSBvZmZzZXQgKDEgLTEpIGxpbWl0IDEwMF07IG5lc3Rl ZCBleGNlcHRpb24gaXMgb3JnLnBvc3RncmVzcWwudXRpbD0KLnBzcWxleGNlcHRpb246IGVycm9y OiByZWxhdGlvbiAic3RvcmFnZSBkb21haW5zIGZvciBzZWFyY2giIGRvZXMgbm90IGV4aXN0PQog cG9zaXRpb246IDMwPC9kZXRhaWw+CjwvZmF1bHQ+CgpBbHNvLCB0aHJvdWdoIHRoZSB3ZWIgYWRt aW4gY29uc29sZSwgd2hlbiB2aWV3aW5nIHRoZSBzdG9yYWdlIGRvbWFpbnMgdGhlIGw9CmlzdCBu ZXZlciBsb2Fkcy4KCkRpZCBzb21ldGhpbmcgY2hhbmdlIGluIHRoZSBEQiByZWNlbnRseSBzdWNo IHRoYXQgSSB3b3VsZCBuZWVkIHRvIHJlYnVpbGQgaT0KdD8KCi1DaHJpcwoKQ2hyaXMgTW9ycmlz c2V5ClNvZnR3YXJlIEVuZ2luZWVyCk5ldEFwcCBJbmMuCjkxOS40NzYuNDQyOAoKCi0tXzAwMF9E MjkwQUQ4NDMyMTE4MDQ4OTQ3Njg5QkEzQUU4QTlCM0VCQTU3OFNBQ0VYQ01CWDA0UFJEaHFuXwpD b250ZW50LVR5cGU6IHRleHQvaHRtbDsgY2hhcnNldD0idXMtYXNjaWkiCkNvbnRlbnQtVHJhbnNm ZXItRW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKCjxodG1sIHhtbG5zOnY9M0QidXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89M0QidXJuOnNjaGVtYXMtbWljcj0Kb3NvZnQt Y29tOm9mZmljZTpvZmZpY2UiIHhtbG5zOnc9M0QidXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpv ZmZpY2U6d29yZCIgPQp4bWxuczptPTNEImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vb2Zm aWNlLzIwMDQvMTIvb21tbCIgeG1sbnM9M0QiaHR0cDo9Ci8vd3d3LnczLm9yZy9UUi9SRUMtaHRt bDQwIj4KPGhlYWQ+CjxtZXRhIGh0dHAtZXF1aXY9M0QiQ29udGVudC1UeXBlIiBjb250ZW50PTNE InRleHQvaHRtbDsgY2hhcnNldD0zRHVzLWFzY2lpIj0KPgo8bWV0YSBuYW1lPTNEIkdlbmVyYXRv ciIgY29udGVudD0zRCJNaWNyb3NvZnQgV29yZCAxNCAoZmlsdGVyZWQgbWVkaXVtKSI+CjxzdHls ZT48IS0tCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8KQGZvbnQtZmFjZQoJe2ZvbnQtZmFtaWx5OkNh bGlicmk7CglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9Ci8qIFN0eWxlIERlZmluaXRp b25zICovCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3JtYWwKCXttYXJnaW46 MGluOwoJbWFyZ2luLWJvdHRvbTouMDAwMXB0OwoJZm9udC1zaXplOjExLjBwdDsKCWZvbnQtZmFt aWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7fQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rCgl7 bXNvLXN0eWxlLXByaW9yaXR5Ojk5OwoJY29sb3I6Ymx1ZTsKCXRleHQtZGVjb3JhdGlvbjp1bmRl cmxpbmU7fQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQKCXttc28tc3R5bGUt cHJpb3JpdHk6OTk7Cgljb2xvcjpwdXJwbGU7Cgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30K c3Bhbi5FbWFpbFN0eWxlMTcKCXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1jb21wb3NlOwoJZm9u dC1mYW1pbHk6IkNhbGlicmkiLCJzYW5zLXNlcmlmIjsKCWNvbG9yOndpbmRvd3RleHQ7fQouTXNv Q2hwRGVmYXVsdAoJe21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5OwoJZm9udC1mYW1pbHk6IkNh bGlicmkiLCJzYW5zLXNlcmlmIjt9CkBwYWdlIFdvcmRTZWN0aW9uMQoJe3NpemU6OC41aW4gMTEu MGluOwoJbWFyZ2luOjEuMGluIDEuMGluIDEuMGluIDEuMGluO30KZGl2LldvcmRTZWN0aW9uMQoJ e3BhZ2U6V29yZFNlY3Rpb24xO30KLS0+PC9zdHlsZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4K PG86c2hhcGVkZWZhdWx0cyB2OmV4dD0zRCJlZGl0IiBzcGlkbWF4PTNEIjEwMjYiIC8+CjwveG1s PjwhW2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPgo8bzpzaGFwZWxheW91dCB2OmV4 dD0zRCJlZGl0Ij4KPG86aWRtYXAgdjpleHQ9M0QiZWRpdCIgZGF0YT0zRCIxIiAvPgo8L286c2hh cGVsYXlvdXQ+PC94bWw+PCFbZW5kaWZdLS0+CjwvaGVhZD4KPGJvZHkgbGFuZz0zRCJFTi1VUyIg bGluaz0zRCJibHVlIiB2bGluaz0zRCJwdXJwbGUiPgo8ZGl2IGNsYXNzPTNEIldvcmRTZWN0aW9u MSI+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+SGkgQWxsLDxvOnA+PC9vOnA+PC9wPgo8cCBjbGFz cz0zRCJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPgo8cCBjbGFzcz0zRCJNc29Ob3Jt YWwiPkkmIzgyMTc7bSBnZXR0aW5nIGFuIGVycm9yIHdoZW4gdHJ5aW5nIHRvIHZpZXcgdGhlIHM9 CnRvcmFnZSBkb21haW5zIHVzaW5nIHRoZSBSRVNUIEFQSTo8bzpwPjwvbzpwPjwvcD4KPHAgY2xh c3M9M0QiTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4KPHAgY2xhc3M9M0QiTXNvTm9y bWFsIj4mbHQ7P3htbCB2ZXJzaW9uPTNEJnF1b3Q7MS4wJnF1b3Q7IGVuY29kaW5nPTNEJnF1b3Q7 PQpVVEYtOCZxdW90OyBzdGFuZGFsb25lPTNEJnF1b3Q7eWVzJnF1b3Q7PyZndDs8bzpwPjwvbzpw PjwvcD4KPHAgY2xhc3M9M0QiTXNvTm9ybWFsIj4mbHQ7ZmF1bHQmZ3Q7PG86cD48L286cD48L3A+ CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+Jm5ic3A7Jm5ic3A7Jm5ic3A7ICZsdDtyZWFzb24mZ3Q7 T3BlcmF0aW9uIEZhaWxlZCZsdD0KOy9yZWFzb24mZ3Q7PG86cD48L286cD48L3A+CjxwIGNsYXNz PTNEIk1zb05vcm1hbCI+Jm5ic3A7Jm5ic3A7Jm5ic3A7ICZsdDtkZXRhaWwmZ3Q7c3RhdGVtZW50 Y2FsbGJhY2s7ID0KYmFkIHNxbCBncmFtbWFyIFtzZWxlY3QgKiBmcm9tIChzZWxlY3QgKiBmcm9t IHN0b3JhZ2UgZG9tYWlucyBmb3Igc2VhcmNoIHdoPQplcmUgKCBpZCBpbiAoc2VsZWN0IHN0b3Jh Z2UgZG9tYWlucyB3aXRoIGhvc3RzIHZpZXcuaWQgZnJvbSBzdG9yYWdlIGRvbWFpbnM9CiB3aXRo IGhvc3RzIHZpZXcgKSkgb3JkZXIgYnkgc3RvcmFnZSBuYW1lIGFzYyApIGFzIHQxIG9mZnNldAog KDEgLTEpIGxpbWl0IDEwMF07IG5lc3RlZCBleGNlcHRpb24gaXMgb3JnLnBvc3RncmVzcWwudXRp bC5wc3FsZXhjZXB0aW9uOiA9CmVycm9yOiByZWxhdGlvbiAmcXVvdDtzdG9yYWdlIGRvbWFpbnMg Zm9yIHNlYXJjaCZxdW90OyBkb2VzIG5vdCBleGlzdCBwb3NpdD0KaW9uOiAzMCZsdDsvZGV0YWls Jmd0OzxvOnA+PC9vOnA+PC9wPgo8cCBjbGFzcz0zRCJNc29Ob3JtYWwiPiZsdDsvZmF1bHQmZ3Q7 PG86cD48L286cD48L3A+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48 L3A+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+QWxzbywgdGhyb3VnaCB0aGUgd2ViIGFkbWluIGNv bnNvbGUsIHdoZW4gdmlld2luZyB0aD0KZSBzdG9yYWdlIGRvbWFpbnMgdGhlIGxpc3QgbmV2ZXIg bG9hZHMuPG86cD48L286cD48L3A+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+PG86cD4mbmJzcDs8 L286cD48L3A+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+RGlkIHNvbWV0aGluZyBjaGFuZ2UgaW4g dGhlIERCIHJlY2VudGx5IHN1Y2ggdGhhdCBJID0Kd291bGQgbmVlZCB0byByZWJ1aWxkIGl0Pzxv OnA+PC9vOnA+PC9wPgo8cCBjbGFzcz0zRCJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9w Pgo8cCBjbGFzcz0zRCJNc29Ob3JtYWwiPi1DaHJpczxvOnA+PC9vOnA+PC9wPgo8cCBjbGFzcz0z RCJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPgo8cCBjbGFzcz0zRCJNc29Ob3JtYWwi PjxiPkNocmlzIE1vcnJpc3NleTxvOnA+PC9vOnA+PC9iPjwvcD4KPHAgY2xhc3M9M0QiTXNvTm9y bWFsIj5Tb2Z0d2FyZSBFbmdpbmVlcjxvOnA+PC9vOnA+PC9wPgo8cCBjbGFzcz0zRCJNc29Ob3Jt YWwiPk5ldEFwcCBJbmMuPG86cD48L286cD48L3A+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+OTE5 LjQ3Ni40NDI4PG86cD48L286cD48L3A+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+PG86cD4mbmJz cDs8L286cD48L3A+CjwvZGl2Pgo8L2JvZHk+CjwvaHRtbD4KCi0tXzAwMF9EMjkwQUQ4NDMyMTE4 MDQ4OTQ3Njg5QkEzQUU4QTlCM0VCQTU3OFNBQ0VYQ01CWDA0UFJEaHFuXy0tCg== --===============5453801048614908035==--