2:47 p.m.
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> 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> 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/JJMZVSHKB37I3CNM5UVD3Y5AZUQDZ7TI/
>