AnsweredAssumed Answered

Error with the mysql replication mecanism with CA UIM 8.4

Question asked by Jonathan GENTILHOMME on Aug 26, 2016
Latest reply on Dec 21, 2016 by Jonathan GENTILHOMME

Hi ^^
I've setup UIM (8.4) on a MySQL replcation between two hosts Cent OS 7 with MySQL 5.6 Enterprise.

I've followed the prerequies and create a database with the charset utf8 and the collation utf8_unicode_ci.

But, at the end of the installation, when the MySQL Replication mecanism try to put the data in the slave, the sql_mode failed on a request with a "START OF HEADING" character (\x01).

As follow, an extraction of the error log :

 

[ERROR] Slave SQL: Error 'Incorrect integer value: '\x01' for column 'is_class' at row 1' on query. Default database: 'uim'. Query: 'insert into `cfg_package_extension` (`pkg_id`, `is_class`, `name`, `data`) values ( NAME_CONST('pPkgId',1),  NAME_CONST('pIsClass',_binary'' COLLATE 'binary'),  NAME_CONST('pName',_utf8'com.nimsoft.config.plugin.cdmPlugin' COLLATE 'utf8_unicode_ci'),  NAME_CONST('pData',_binary' ....

 

If someone have already encounter this problem ?

Outcomes