Hi, Host deploy is failing on master with errors. The issue seems to be that the opcode that is returned from vdsm has Unicode null characters in it (obtained using a break point in VdsDeploy.userVisibleLog). "Failed to execute stage 'Initializing': Invalid response opcode '\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000CONFIRM'" Resulting in below errors when the message is inserted into database. Can someone take a look 2018-09-11 13:38:11,121-04 INFO [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (VdsDeploy) [669a0081] EVENT_ID: VDS_INSTALL_IN_PROGRESS(509), Installing Host 192.168.122.57. Stage: Initializing. 2018-09-11 13:38:39,231-04 INFO [org.ovirt.engine.core.utils.transaction.TransactionSupport] (VdsDeploy) [669a0081] transaction rolled back 2018-09-11 13:38:39,231-04 ERROR [org.ovirt.engine.core.bll.hostdeploy.VdsDeployBase] (VdsDeploy) [669a0081] Error during deploy dialog 2018-09-11 13:38:39,246-04 ERROR [org.ovirt.engine.core.bll.hostdeploy.VdsDeployBase] (EE-ManagedThreadFactory-engine-Thread-11) [669a0081] Error during host 192.168.122.57 install 2018-09-11 13:38:41,791-04 ERROR [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (EE-ManagedThreadFactory-engine-Thread-11) [669a0081] EVENT_ID: VDS_INSTALL_IN_PROGRESS_ERROR(511), An error has occurred during installation of Host 192.168.122.57: CallableStatementCallback; SQL [{call insertauditlog(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}ERROR: invalid byte sequence for encoding "UTF8": 0x00; nested exception is org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00. _______________________________________________ Devel mailing list -- devel(a)ovirt.org To unsubscribe send an email to devel-leave(a)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/devel@ovirt.org/message/JJMZVSHKB37...

postgres=# select * from pg_database ; datname | datdba | encoding | datcollate | datctype | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | datminmxid | dattablespace | datacl ------------------------+--------+----------+-------------+-------------+---------------+--------------+--------------+---------------+--------------+------------+---------------+-------------------------------- ----- postgres | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 13288 | 548 | 1 | 1663 | engineMnew9 | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 13288 | 548 | 1 | 1663 | template1 | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | t | t | -1 | 13288 | 548 | 1 | 1663 | {=c/postgres,postgres=CTc/postg res} template0 | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | t | f | -1 | 13288 | 548 | 1 | 1663 | {=c/postgres,postgres=CTc/postg res} engine | 21876 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 13288 | 548 | 1 | 1663 | engine_dao_tests | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 13288 | 548 | 1 | 1663 | engine42 | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 13288 | 548 | 1 | 1663 | engineMnew8 | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 13288 | 548 | 1 | 1663 | engine_master_aaa_jdbc | 16384 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 13288 | 548 | 1 | 1663 | (9 rows) I think the problem is the null characters in the op code returned to VdsDeploy.

On Wed, Sep 12, 2018 at 7:36 AM, Roy Golan <rgolan(a)redhat.com&gt; wrote: > Collate of the db is wrong? > > Can you give the output of 'select * from pg_database ;' > > Mine is: > Name | Owner | Encoding | Collate | Ctype | Access > privileges > > -----------+----------+----------+------------+------------+----------------------- > ovirt | postgres | UTF8 | en_US.utf8 | en_US.utf8 | > > > > On Wed, 12 Sep 2018 at 13:46 Ravi Shankar Nori <rnori(a)redhat.com&gt; wrote: > >> Hi, >> >> Host deploy is failing on master with errors. The issue seems to be that >> the opcode that is returned from vdsm has Unicode null characters in it >> (obtained using a break point in VdsDeploy.userVisibleLog). >> >> "Failed to execute stage 'Initializing': Invalid response opcode >> '\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000CONFIRM'" >> >> Resulting in below errors when the message is inserted into database. >> >> Can someone take a look >> >> 2018-09-11 13:38:11,121-04 INFO >> [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] >> (VdsDeploy) [669a0081] EVENT_ID: VDS_INSTALL_IN_PROGRESS(509), Installing >> Host 192.168.122.57. Stage: Initializing. >> 2018-09-11 13:38:39,231-04 INFO >> [org.ovirt.engine.core.utils.transaction.TransactionSupport] (VdsDeploy) >> [669a0081] transaction rolled back >> 2018-09-11 13:38:39,231-04 ERROR >> [org.ovirt.engine.core.bll.hostdeploy.VdsDeployBase] (VdsDeploy) [669a0081] >> Error during deploy dialog >> 2018-09-11 13:38:39,246-04 ERROR >> [org.ovirt.engine.core.bll.hostdeploy.VdsDeployBase] >> (EE-ManagedThreadFactory-engine-Thread-11) [669a0081] Error during host >> 192.168.122.57 install >> 2018-09-11 13:38:41,791-04 ERROR >> [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] >> (EE-ManagedThreadFactory-engine-Thread-11) [669a0081] EVENT_ID: >> VDS_INSTALL_IN_PROGRESS_ERROR(511), An error has occurred during >> installation of Host 192.168.122.57: CallableStatementCallback; SQL >> [{call insertauditlog(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}ERROR: invalid byte >> sequence for encoding "UTF8": 0x00; nested exception is >> org.postgresql.util.PSQLException: ERROR: invalid byte sequence for >> encoding "UTF8": 0x00. >> >> _______________________________________________ >> Devel mailing list -- devel(a)ovirt.org >> To unsubscribe send an email to devel-leave(a)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/devel@ovirt.org/message/JJMZVSHKB37... >> >