Data Center non-responsive, storage not loading, and psql errors after importing an ova

I posted about this a few months ago on Reddit when it happened the first time, and I have now repeated it on two more separate installations. I have a simple oVirt 4.2 hosted-engine setup, two hosts, with a qnap NAS as the shared NFS storage. I copied an ova file (exported from vmware) to the NFS storage. I then imported it by logging into the engine gui, going to "Virtual machines", selecting the host/file path/datacenter/etc, and starting the import. Once I started the import, I get an alert that it failed almost immediately, followed by a notice that the data center is in a non-responsive state. Clicking on the "storage" tab under Data Center, or going to the "Storage Domain" page directly yields the three ". . ." loading animation, which never ends. I can still see the storage mounts on the hosts, and I can move files to and from them. the engine.log file on the hosted-engine VM contains a lot of the following lines: Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select * from getstorage_domains_list_by_imageid (?)]; ERROR: integer out of range Where: PL/pgSQL function getstorage_domains_list_by_imageid(uuid) line 3 at RETURN QUERY; nested exception is org.postgresql.util.PSQLException: ER ROR: integer out of range Where: PL/pgSQL function getstorage_domains_list_by_imageid(uuid) line 3 at RETURN QUERY at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102) [spring-jdbc.jar:4.3. 9.RELEASE] What I have tried: Restarting the hosted-engine service Restarting nfs and vdsm services Rebooting the hosted-engine Rebooting both hosts Entering an exiting maintenance mode (one host never came out of maintenance, and refuses to with the error " General command validation failure ") Any idea what might have happened? And what should I have done to try to rectify it? Entering maintenance mode and restarting services seems to have made things much worse.

I still havn't found a solution to this issue, but it was requested that I post my engine.log and vdsm.log files. You can find a copy of my engine.log here: https://git.nightscapetech.com/uploads/-/system/personal_snippet/1/baddae4e4... and my vdsm.log here: https://git.nightscapetech.com/uploads/-/system/personal_snippet/1/e43cf9648... Thank you.

Michal, Tal, can you please have a look? 2018-08-22 2:54 GMT+02:00 <josh@nightscapetech.com>:
I still havn't found a solution to this issue, but it was requested that I post my engine.log and vdsm.log files. You can find a copy of my engine.log here: https://git.nightscapetech.com/uploads/-/system/personal_snippet/1/ baddae4e4cdc787d6f13363eb4657350/engine.log and my vdsm.log here: https://git.nightscapetech.com/uploads/-/system/personal_snippet/1/ e43cf9648a138b717343adda3c02b594/vdsm.log
Thank you. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community- guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/ message/CXSZGTKJXBQFZYHWWDRVCM2DYZUVRIA4/
-- SANDRO BONAZZOLA MANAGER, SOFTWARE ENGINEERING, EMEA R&D RHV Red Hat EMEA <https://www.redhat.com/> sbonazzo@redhat.com <https://red.ht/sig> <https://www.redhat.com/en/events/red-hat-open-source-day-italia?sc_cid=701f2000000RgRyAAK>

Can you provide the content of the table "storage_domains" from the database? On Thu, Aug 23, 2018 at 10:44 AM, Sandro Bonazzola <sbonazzo@redhat.com> wrote:
Michal, Tal, can you please have a look?
2018-08-22 2:54 GMT+02:00 <josh@nightscapetech.com>:
I still havn't found a solution to this issue, but it was requested that I post my engine.log and vdsm.log files. You can find a copy of my engine.log here: https://git.nightscapetech.com /uploads/-/system/personal_snippet/1/baddae4e4cdc787d6f13363 eb4657350/engine.log and my vdsm.log here: https://git.nightscapetech.com /uploads/-/system/personal_snippet/1/e43cf9648a138b717343add a3c02b594/vdsm.log
Thank you. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/communit y/about/community-guidelines/ List Archives: https://lists.ovirt.org/archiv es/list/users@ovirt.org/message/CXSZGTKJXBQFZYHWWDRVCM2DYZUVRIA4/
--
SANDRO BONAZZOLA
MANAGER, SOFTWARE ENGINEERING, EMEA R&D RHV
Red Hat EMEA <https://www.redhat.com/>
sbonazzo@redhat.com <https://red.ht/sig> <https://www.redhat.com/en/events/red-hat-open-source-day-italia?sc_cid=701f2000000RgRyAAK>
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community- guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/ message/O2RTFLHVSEJFENGFG2NUO3NFYYY2UOIQ/
participants (3)
-
Fred Rolland
-
josh@nightscapetech.com
-
Sandro Bonazzola