Неподдерживаемая кодовая страница

[inkostin]

Zabbix: 4.4.6
Не обращал внимания, на dashboarde вылезло:

198.39
Неподдерживаемая кодовая страница или тип сравнения для таблиц: tag_filter, maintenance_tag, graph_theme.

В логах:

44746:20200227:105716.963 character set name or collation name that is not supported by Zabbix found in 16 column(s) of database "zabbix"
44746:20200227:105716.963 only character set "utf8" and collation "utf8_bin" should be used in database

character-set-server = utf8mb4
collation-server = utf8mb4_general_ci

MariaDB [(none)]> SHOW VARIABLES LIKE 'collation%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+----------------------+--------------------+
3 rows in set (0.001 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.001 sec)

[inkostin]

Closed.

ALTER TABLE graph_theme CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

Было: ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |