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@redhat.com> 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@redhat.com> 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 look2018-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@ovirt.org
To unsubscribe send an email to devel-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/devel@ovirt.org/message/JJMZVSHKB37I3CNM5UVD3Y5AZUQDZ7TI/