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

MariaDB upgrade fail when using default_time_zone



      I am using official MariaDB APT repository on Debian 8 to install mariadb-server-10.1 package.

      I populate timezone tables using:

      /usr/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql

      Then setting default_time_zone variable in my.cnf:


      After restarting mysql service all works fine:

      :~# /etc/init.d/mysql restart
      [ ok ] Restarting mysql (via systemctl): mysql.service.
      :~# mysql -e "show variables like 'time_zone'"
      | Variable_name | Value        |
      | time_zone     | Europe/Paris |

      The problem occurs when upgrading mariadb-server packages. For example, my last apt-get upgrade upgraded MariaDB from v10.1.22 to v10.1.25:

      :~# apt-get upgrade
      Errors were encountered while processing:
      E: Sub-process /usr/bin/dpkg returned an error code (1)

      :~# apt-get install -f
      Reading package lists... Done
      Building dependency tree       
      Reading state information... Done
      0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
      2 not fully installed or removed.
      After this operation, 0 B of additional disk space will be used.
      Setting up mariadb-server-10.1 (10.1.25+maria-1~jessie) ...
      dpkg: error processing package mariadb-server-10.1 (--configure):
       subprocess installed post-installation script returned error exit status 1
      dpkg: dependency problems prevent configuration of mariadb-server:
       mariadb-server depends on mariadb-server-10.1 (= 10.1.25+maria-1~jessie); however:
        Package mariadb-server-10.1 is not configured yet.
      dpkg: error processing package mariadb-server (--configure):
       dependency problems - leaving unconfigured
      Errors were encountered while processing:
      E: Sub-process /usr/bin/dpkg returned an error code (1)

      MariaDB error log (/var/log/mysql.err) says:

      2017-07-28 10:09:20 140185074391296 [ERROR] Fatal error: Illegal or unknown default time zone 'Europe/Paris'

      If I comment the default_time_zone parameter in my.cnf, I can complete the upgrade process:


      Then, reintroducing default_time_zone parameter in my.cnf, I am able to restart mysql service without any problem.

      It seems that something is broken in apt upgrade process when default_time_zone is set, whereas time zone tables are filled or not...

      Other users have encountered the same problem as you can see on StackOverflow: https://stackoverflow.com/questions/29565278/apt-get-upgrade-always-fails-on-mariadb-server-due-to-timezone




            • Assignee:
              serg Sergei Golubchik
              nico Nicolas Payart
            • Votes:
              0 Vote for this issue
              5 Start watching this issue


              • Created: