Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-21385

utf8mb3 error message in zabbix server log in 5.0.26 appliance

    XMLWordPrintable

Details

    • Team A
    • Sprint 90 (Jul 2022), Sprint 91 (Aug 2022)
    • 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)
      [[email protected] ~]# mysql -V
mysql  Ver 8.0.26 for Linux on x86_64 (Source distribution)

      Aside from that appliance seems to work fine.

      Attachments

        Issue Links

          caused by

          Change Request - An Change Request or enhancement Improvement to an existing feature or task. ZBXNEXT-3706 mysql utf8 vs utf8mb4

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Problem report - Problem report ZBX-21301 Error message cannot set MySQL character to "utf8"

          • Major - Major loss of function.
          • Closed
          duplicates

          Problem report - Problem report ZBX-21437 Cannot set MySQL character set to "utf8mb3"

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Activity

            People

              vso Vladislavs Sokurenko
              yurii Jurijs Klopovskis
              Votes:
              2 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: