Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34196

Database will not start when "character_set_server = latin1" is in cnf file

Details

    Description

      ● I can set it to utf8mb4 in the cnf file, and it starts OK
      ● I can set it to latin1 from a running session: set global character_set_server=latin1;

      Tested on 10.6 Enterprise
      Tested on 10.11

      Attachments

        Activity

          Will not start how?

          It worked for me.

          serg Sergei Golubchik added a comment - Will not start how? It worked for me.
          edward Edward Stoever added a comment - - edited

          Hello serg
          I don't understand. I just tested it again on debian 12 - a new install - and you can see in the attached image, all I do is add character_set_server = latin1 to a custom options file, and the server cannot start. No error is produced in the error log.

          edward Edward Stoever added a comment - - edited Hello serg I don't understand. I just tested it again on debian 12 - a new install - and you can see in the attached image, all I do is add character_set_server = latin1 to a custom options file, and the server cannot start. No error is produced in the error log.

          what's in your zz_custom_option.cnf?
          what does journalctl say?

          serg Sergei Golubchik added a comment - what's in your zz_custom_option.cnf ? what does journalctl say?

          There is nothing of interest in zz_custom_option.cnf (attached).
          journalctl says:

          May 28 10:34:17 db mariadbd[2984]: 2024-05-28 10:34:17 0 [ERROR] COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1'
          May 28 10:34:17 db mariadbd[2984]: 2024-05-28 10:34:17 0 [ERROR] Aborting
          May 28 10:34:17 db systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
          

          Ok, that is interesting. I can at least see why it died.

          That fixes it essentially, I add this to my .cnf, and it starts now:

          character_set_server = latin1
          collation_server = latin1_general_cs
          

          Thank you!

          edward Edward Stoever added a comment - There is nothing of interest in zz_custom_option.cnf (attached). journalctl says: May 28 10:34:17 db mariadbd[2984]: 2024-05-28 10:34:17 0 [ERROR] COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1' May 28 10:34:17 db mariadbd[2984]: 2024-05-28 10:34:17 0 [ERROR] Aborting May 28 10:34:17 db systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Ok, that is interesting. I can at least see why it died. That fixes it essentially, I add this to my .cnf, and it starts now: character_set_server = latin1 collation_server = latin1_general_cs Thank you!

          People

            Unassigned Unassigned
            edward Edward Stoever
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.