Xmlrpc-c method registry code

[Senthil_Kumar_M (SK)]

When i open opennebula-sunstone UI i am getting this error

Unexpected error executing code for particular method, detected by Xmlrpc-c method registry code. Method did not fail; rather, it did not complete at all. 191478-byte supposed UTF-8 string is not valid UTF-8. UTF-8 string contains a character not in the Basic Multilingual Plane (first byte 0xfffffff0)

Any suggesstions?

[Senthil_Kumar_M (SK)]

Here some additional informations

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 563
Server version: 5.6.51 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>
mysql> SHOW VARIABLES LIKE ‘character_set%’;
±-------------------------±---------------------------+
| Variable_name | Value |
±-------------------------±---------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
±-------------------------±---------------------------+
8 rows in set (0.00 sec)

mysql> SHOW VARIABLES LIKE ‘collation%’;
±---------------------±------------------+
| Variable_name | Value |
±---------------------±------------------+
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
±---------------------±------------------+
3 rows in set (0.00 sec)

mysql> Ctrl-C – exit!
Aborted
rpm -qa | grep mysql
mysql-community-server-5.6.51-2.el7.x86_64
mysql-community-release-el7-5.noarch
mysql-community-libs-5.6.51-2.el7.x86_64
mysql-community-common-5.6.51-2.el7.x86_64
mysql-community-client-5.6.51-2.el7.x86_64

[brunorro (Bruno Rodríguez)]

Hello,

It looks like there may be a emoji or similar char on your database. You should be able to do a onedb backup, uncompress it and grep it with this regex to detect it

grep -P "[\x{10000}-\x{1FFFF}]" DB_BACKUP_FILE

Cheers