On Wed, 12 Sep 2018 at 14:48 Ravi Shankar Nori <[email protected]> wrote:
> 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.
>
>
While java handle \u0000 in a string, it seems that postgres will refuse to
do so.
ovirt=# insert into testa values (1, U&'\0000');
ERRERROR: invalid byte sequence for encoding "UTF8": 0x00
Do you know why it started to appear as an op code? I'd blame host deploy
and eliminate those.
>
> 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/GL444T6ELVHPLBR7KUKQEEFK5D4JBJTU/
