[ZBX-21385] utf8mb3 error message in zabbix server log in 5.0.26 appliance Created: 2022 Jul 25  Updated: 2024 Apr 10  Resolved: 2022 Aug 24

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Appliance (L), Server (S)
Affects Version/s: 5.0.26rc1
Fix Version/s: 5.0.27rc1, 6.0.8rc1, 6.2.2rc1, 6.4.0alpha1, 6.4 (plan)

Type: Problem report Priority: Trivial
Reporter: Jurijs Klopovskis Assignee: Vladislavs Sokurenko
Resolution: Fixed Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Text File MariaDB10.3-charsets.txt     File ZBX-21385-4.0.diff    
Issue Links:
Causes
caused by ZBXNEXT-3706 mysql utf8 vs utf8mb4 Closed
caused by ZBX-21301 Error message cannot set MySQL charac... Closed
Duplicate
duplicates ZBX-21437 Cannot set MySQL character set to "ut... Closed
Team: Team A
Sprint: Sprint 90 (Jul 2022), Sprint 91 (Aug 2022)
Story Points: 0.5

 Description   

Getting these warnings in zabbix-server log in latest 5.0.26 appliance

1433:20220725:111333.821 cannot set MySQL character set to "utf8mb3"
1433:20220725:111434.062 cannot set MySQL character set to "utf8mb3"
1433:20220725:111535.441 cannot set MySQL character set to "utf8mb3"
1433:20220725:111636.813 cannot set MySQL character set to "utf8mb3"

mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = "zabbix";
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8                       | utf8_bin               |
+----------------------------+------------------------+
1 row in set (0.00 sec)
[root@appliance ~]# mysql -V
mysql  Ver 8.0.26 for Linux on x86_64 (Source distribution)

Aside from that appliance seems to work fine.

 Comments   
Comment by Jurijs Klopovskis [ 2022 Jul 25 ]

ZBXNEXT-3706 was only implemented for 6.0+, 5.0 should not have this issue.

Appliances prior to 6.0 specified utf8 char set during DB creation as it was the only supported one. In 6.0+ utf8mb4 is used.

Comment by sh0thub [ 2022 Jul 26 ]

I have same problem in Zabbix 5.0.26 on OracleLinux 8, MariaDB 10.3.32 (distribution version), a lot of errors in server log:

131920:20220726:122158.677 cannot set MySQL character set to "utf8mb3"

Problem is cased by ZBX-21301

Changelog of 5.0.26 mentions it:

https://www.zabbix.com/rn/rn5.0.26

ZBX-21301 Fixed ambiguity and inability to set character set for MariaDB connection by setting utf8mb3 character instead of utf8

 

Problem is that distribution MariaDB 10.3 don't have utf8mb3 as supported character set:

SHOW CHARACTER SET;

MariaDB10.3-charsets.txt

MariaDB [zabbix_db]> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8                     | utf8_bin             |
+--------------------------+----------------------+

mysql -V
mysql  Ver 15.1 Distrib 10.3.32-MariaDB, for Linux (x86_64) using readline 5.1

Documentation for Zabbix 5.0 also require to use utf8, not mentioning utf8mb3 at all, so this error is wrong. So please check only utf8mb3 if there is no utf8 character set supported.

Comment by Rosolino [ 2022 Jul 29 ]

I have same problem in Zabbix 5.0.26 on RockyLinux 8.6, MariaDB 10.3.32

Comment by Vladislavs Sokurenko [ 2022 Aug 19 ]

Fixed in:

Comment by Edgar Akhmetshin [ 2022 Aug 29 ]

Why no 4.0 ?

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-30.html

8.0.30 removed utf8_ naming and LTS 4.0 is still supported.

4.0.x:

Incorrect default charset for Zabbix database: "utf8mb3" instead "UTF8".

Also docs allows to use 8.0.x:
https://www.zabbix.com/documentation/4.0/en/manual/installation/requirements

Comment by Vladislavs Sokurenko [ 2022 Aug 29 ]

Attached patch for 4.0 ZBX-21385-4.0.diff if required, is it really a problem with 4.0, just tried it with 8.0.30 and it is still working with just utf8

Generated at Mon Jun 30 08:29:47 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.