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 <[email protected]> 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 <[email protected]> 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 -- [email protected]
>> To unsubscribe send an email to [email protected]
>> 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/[email protected]/
>> message/JJMZVSHKB37I3CNM5UVD3Y5AZUQDZ7TI/
>>
>
_______________________________________________
Devel mailing list -- [email protected]
To unsubscribe send an email to [email protected]
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/[email protected]/message/H34IRXBS6S2ED2VY6YPAUXDXAJBGHHBN/
