[ovirt-devel] Re: Issue in host deploy

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... >> >