From melissa at aasteel.com Sun Dec 6 17:06:31 2015 Content-Type: multipart/mixed; boundary="===============0195315536481391135==" MIME-Version: 1.0 From: Melissa Mesler To: users at ovirt.org Subject: [ovirt-users] Ovirt Engine Issue Date: Sun, 06 Dec 2015 16:09:24 -0600 Message-ID: <5664B214.3040104@aasteel.com> --===============0195315536481391135== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This is a multi-part message in MIME format. --------------060606050700060504070304 Content-Type: text/plain; charset=3Dutf-8; format=3Dflowed Content-Transfer-Encoding: 7bit Hopefully someone can give me a good idea of how to troubleshoot an = ovirt issue. I am running 3.5 on CentOS 6.7. Here is the issue I'm = having. I have Ovirt running as a virtual machine in KVM. I recently = moved (with virtsync) the vm to rebuild the host. Once the host was = rebuilt I moved ovirt back. Now ovirt-engine starts but is inaccessible. = In the logs it says this: 2015-12-06 15:57:24,558 ERROR [org.ovirt.engine.core.bll.Backend] (MSC = service thread 1-2) Error in getting DB connection. The database is = inaccessible. Original exception is: DataAccessResourceFailureException: = Error retreiving database metadata; nested exception is = org.springframework.jdbc.support.MetaDataAccessException: Could not get = Connection for extracting meta data; nested exception is = org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get = JDBC Connection; nested exception is java.sql.SQLException: = javax.resource.ResourceException: IJ000453: Unable to get managed = connection for java:/ENGINEDataSource I did notice that I can't get postgresql to start. Everything worked = perfectly fine before. Any ideas? -- = Melissa Mesler --------------060606050700060504070304 Content-Type: text/html; charset=3Dutf-8 Content-Transfer-Encoding: 7bit Hopefully someone can give me a good idea of how to troubleshoot an ovirt issue. I am running 3.5 on CentOS 6.7. Here is the issue I'm having. I have Ovirt running as a virtual machine in KVM. I recently moved (with virtsync) the vm to rebuild the host. Once the host was rebuilt I moved ovirt back. Now ovirt-engine starts but is inaccessible. In the logs it says this:

2015-12-06 15:57:24,558 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-2) Error in getting DB connection. The database is inaccessible. Original exception is: DataAccessResourceFailureException: Error retreiving database metadata; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/ENGINEDataSource

I did notice that I can't get postgresql to start. Everything worked perfectly fine before. Any ideas?

-- =

Melissa Mesler

--------------060606050700060504070304-- --===============0195315536481391135== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4KLS0tLS0tLS0tLS0t LS0wNjA2MDYwNTA3MDAwNjA1MDQwNzAzMDQKQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFy c2V0PXV0Zi04OyBmb3JtYXQ9Zmxvd2VkCkNvbnRlbnQtVHJhbnNmZXItRW5jb2Rpbmc6IDdiaXQK CkhvcGVmdWxseSBzb21lb25lIGNhbiBnaXZlIG1lIGEgZ29vZCBpZGVhIG9mIGhvdyB0byB0cm91 Ymxlc2hvb3QgYW4gCm92aXJ0IGlzc3VlLiBJIGFtIHJ1bm5pbmcgMy41IG9uIENlbnRPUyA2Ljcu IEhlcmUgaXMgdGhlIGlzc3VlIEknbSAKaGF2aW5nLiBJIGhhdmUgT3ZpcnQgcnVubmluZyBhcyBh IHZpcnR1YWwgbWFjaGluZSBpbiBLVk0uIEkgcmVjZW50bHkgCm1vdmVkICh3aXRoIHZpcnRzeW5j KSB0aGUgdm0gdG8gcmVidWlsZCB0aGUgaG9zdC4gT25jZSB0aGUgaG9zdCB3YXMgCnJlYnVpbHQg SSBtb3ZlZCBvdmlydCBiYWNrLiBOb3cgb3ZpcnQtZW5naW5lIHN0YXJ0cyBidXQgaXMgaW5hY2Nl c3NpYmxlLiAKSW4gdGhlIGxvZ3MgaXQgc2F5cyB0aGlzOgoKMjAxNS0xMi0wNiAxNTo1NzoyNCw1 NTggRVJST1IgW29yZy5vdmlydC5lbmdpbmUuY29yZS5ibGwuQmFja2VuZF0gKE1TQyAKc2Vydmlj ZSB0aHJlYWQgMS0yKSBFcnJvciBpbiBnZXR0aW5nIERCIGNvbm5lY3Rpb24uIFRoZSBkYXRhYmFz ZSBpcyAKaW5hY2Nlc3NpYmxlLiBPcmlnaW5hbCBleGNlcHRpb24gaXM6IERhdGFBY2Nlc3NSZXNv dXJjZUZhaWx1cmVFeGNlcHRpb246IApFcnJvciByZXRyZWl2aW5nIGRhdGFiYXNlIG1ldGFkYXRh OyBuZXN0ZWQgZXhjZXB0aW9uIGlzIApvcmcuc3ByaW5nZnJhbWV3b3JrLmpkYmMuc3VwcG9ydC5N ZXRhRGF0YUFjY2Vzc0V4Y2VwdGlvbjogQ291bGQgbm90IGdldCAKQ29ubmVjdGlvbiBmb3IgZXh0 cmFjdGluZyBtZXRhIGRhdGE7IG5lc3RlZCBleGNlcHRpb24gaXMgCm9yZy5zcHJpbmdmcmFtZXdv cmsuamRiYy5DYW5ub3RHZXRKZGJjQ29ubmVjdGlvbkV4Y2VwdGlvbjogQ291bGQgbm90IGdldCAK SkRCQyBDb25uZWN0aW9uOyBuZXN0ZWQgZXhjZXB0aW9uIGlzIGphdmEuc3FsLlNRTEV4Y2VwdGlv bjogCmphdmF4LnJlc291cmNlLlJlc291cmNlRXhjZXB0aW9uOiBJSjAwMDQ1MzogVW5hYmxlIHRv IGdldCBtYW5hZ2VkIApjb25uZWN0aW9uIGZvciBqYXZhOi9FTkdJTkVEYXRhU291cmNlCgpJIGRp ZCBub3RpY2UgdGhhdCBJIGNhbid0IGdldCBwb3N0Z3Jlc3FsIHRvIHN0YXJ0LiBFdmVyeXRoaW5n IHdvcmtlZCAKcGVyZmVjdGx5IGZpbmUgYmVmb3JlLiBBbnkgaWRlYXM/CgotLSAKTWVsaXNzYSBN ZXNsZXIKCgotLS0tLS0tLS0tLS0tLTA2MDYwNjA1MDcwMDA2MDUwNDA3MDMwNApDb250ZW50LVR5 cGU6IHRleHQvaHRtbDsgY2hhcnNldD11dGYtOApDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiA3 Yml0Cgo8aHRtbD4KICA8aGVhZD4KCiAgICA8bWV0YSBodHRwLWVxdWl2PSJjb250ZW50LXR5cGUi IGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD11dGYtOCI+CiAgPC9oZWFkPgogIDxib2R5IGJn Y29sb3I9IiNGRkZGRkYiIHRleHQ9IiMwMDAwMDAiPgogICAgPHNtYWxsPkhvcGVmdWxseSBzb21l b25lIGNhbiBnaXZlIG1lIGEgZ29vZCBpZGVhIG9mIGhvdyB0bwogICAgICB0cm91Ymxlc2hvb3Qg YW4gb3ZpcnQgaXNzdWUuIEkgYW0gcnVubmluZyAzLjUgb24gQ2VudE9TIDYuNy4gSGVyZQogICAg ICBpcyB0aGUgaXNzdWUgSSdtIGhhdmluZy4gSSBoYXZlIE92aXJ0IHJ1bm5pbmcgYXMgYSB2aXJ0 dWFsIG1hY2hpbmUKICAgICAgaW4gS1ZNLiBJIHJlY2VudGx5IG1vdmVkICh3aXRoIHZpcnRzeW5j KSB0aGUgdm0gdG8gcmVidWlsZCB0aGUKICAgICAgaG9zdC4gT25jZSB0aGUgaG9zdCB3YXMgcmVi dWlsdCBJIG1vdmVkIG92aXJ0IGJhY2suIE5vdwogICAgICBvdmlydC1lbmdpbmUgc3RhcnRzIGJ1 dCBpcyBpbmFjY2Vzc2libGUuIEluIHRoZSBsb2dzIGl0IHNheXMgdGhpczo8YnI+CiAgICAgIDxi cj4KICAgICAgMjAxNS0xMi0wNiAxNTo1NzoyNCw1NTggRVJST1IgW29yZy5vdmlydC5lbmdpbmUu Y29yZS5ibGwuQmFja2VuZF0KICAgICAgKE1TQyBzZXJ2aWNlIHRocmVhZCAxLTIpIEVycm9yIGlu IGdldHRpbmcgREIgY29ubmVjdGlvbi4gVGhlCiAgICAgIGRhdGFiYXNlIGlzIGluYWNjZXNzaWJs ZS4gT3JpZ2luYWwgZXhjZXB0aW9uIGlzOgogICAgICBEYXRhQWNjZXNzUmVzb3VyY2VGYWlsdXJl RXhjZXB0aW9uOiBFcnJvciByZXRyZWl2aW5nIGRhdGFiYXNlCiAgICAgIG1ldGFkYXRhOyBuZXN0 ZWQgZXhjZXB0aW9uIGlzCiAgICAgIG9yZy5zcHJpbmdmcmFtZXdvcmsuamRiYy5zdXBwb3J0Lk1l dGFEYXRhQWNjZXNzRXhjZXB0aW9uOiBDb3VsZAogICAgICBub3QgZ2V0IENvbm5lY3Rpb24gZm9y IGV4dHJhY3RpbmcgbWV0YSBkYXRhOyBuZXN0ZWQgZXhjZXB0aW9uIGlzCiAgICAgIG9yZy5zcHJp bmdmcmFtZXdvcmsuamRiYy5DYW5ub3RHZXRKZGJjQ29ubmVjdGlvbkV4Y2VwdGlvbjogQ291bGQK ICAgICAgbm90IGdldCBKREJDIENvbm5lY3Rpb247IG5lc3RlZCBleGNlcHRpb24gaXMKICAgICAg amF2YS5zcWwuU1FMRXhjZXB0aW9uOiBqYXZheC5yZXNvdXJjZS5SZXNvdXJjZUV4Y2VwdGlvbjog SUowMDA0NTM6CiAgICAgIFVuYWJsZSB0byBnZXQgbWFuYWdlZCBjb25uZWN0aW9uIGZvciBqYXZh Oi9FTkdJTkVEYXRhU291cmNlPGJyPgogICAgICA8YnI+CiAgICAgIEkgZGlkIG5vdGljZSB0aGF0 IEkgY2FuJ3QgZ2V0IHBvc3RncmVzcWwgdG8gc3RhcnQuIEV2ZXJ5dGhpbmcKICAgICAgd29ya2Vk IHBlcmZlY3RseSBmaW5lIGJlZm9yZS4gQW55IGlkZWFzPzxicj4KICAgIDwvc21hbGw+CiAgICA8 cHJlIGNsYXNzPSJtb3otc2lnbmF0dXJlIiBjb2xzPSI3MiI+LS0gCk1lbGlzc2EgTWVzbGVyCjwv cHJlPgogIDwvYm9keT4KPC9odG1sPgoKLS0tLS0tLS0tLS0tLS0wNjA2MDYwNTA3MDAwNjA1MDQw NzAzMDQtLQo= --===============0195315536481391135==--