Public bug reported: with default-time zone variable set in /etc/mysql/mariadb.conf.d/50-server.cnf: [mysqld] default_time_zone=Europe/Paris mariadb-server update to version 10.1.34 crashes. time_zone tables at the mysql db are installed : select * from mysql.time_zone limit 5; +--------------+------------------+ | Time_zone_id | Use_leap_seconds | +--------------+------------------+ | 1 | N | | 2 | N | | 3 | N | | 4 | N | | 5 | N | +--------------+------------------+ 5 rows in set (0.00 sec)
MariaDB [(none)]> select * from mysql.time_zone_name limit 5; +--------------------+--------------+ | Name | Time_zone_id | +--------------------+--------------+ | Africa/Abidjan | 1 | | Africa/Accra | 2 | | Africa/Addis_Ababa | 3 | | Africa/Algiers | 4 | | Africa/Asmara | 5 | +--------------------+--------------+ from mysql_error.log [ERROR] Fatal error: Illegal or unknown default time zone 'Europe/Vienna' more detailed: 2018-08-28 9:22:21 140579951983744 [Note] InnoDB: 128 rollback segment(s) are active. [Note] InnoDB: Waiting for purge to start [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 4976042 [Note] InnoDB: Dumping buffer pool(s) not yet started [ERROR] Fatal error: Illegal or unknown default time zone 'Europe/Vienna' [Note] InnoDB: Using mutexes to ref count buffer pool pages [Note] InnoDB: The InnoDB memory heap is disabled [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier [Note] InnoDB: Compressed tables use zlib 1.2.11 [Note] InnoDB: Using Linux native AIO [Note] InnoDB: Using SSE crc32 instructions [Note] InnoDB: Initializing buffer pool, size = 512.0M [Note] InnoDB: Completed initialization of buffer pool [Note] InnoDB: Highest supported file format is Barracuda. [Note] InnoDB: The log sequence number 4976042 in ibdata file do not match the log sequence number 4976052 in the ib_logfiles! [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... [Note] InnoDB: 128 rollback segment(s) are active. [Note] InnoDB: Waiting for purge to start [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 4976052 [Note] InnoDB: Dumping buffer pool(s) not yet started [Note] Plugin 'FEEDBACK' is disabled. [Note] Recovering after a crash using tc.log [Note] Starting crash recovery... [Note] Crash recovery finished. [ERROR] Fatal error: Illegal or unknown default time zone 'Europe/Vienna' With removed default time zone, update continues. lsb_release: Ubuntu 18.04.1 LTS mariadb-server: Installed: 1:10.1.34-0ubuntu0.18.04.1 ** Affects: mariadb-10.1 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1789411 Title: mariadb-server update crashes cause of default time zone variable To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.1/+bug/1789411/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
