Hi!
Thank your for your response.
i have already imported the timezones (before the update) via
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
and the Time_zone_id is present:
MariaDB [(none)]> select * from mysql.time_zone_name where Name='Europe/Vienna'
-> ;
+---------------+--------------+
| Name | Time_zone_id |
+---------------+--------------+
| Europe/Vienna | 480 |
+---------------+--------------+
1 row in set (0.00 sec)
the id is also present in mysql.time_zone
MariaDB [(none)]> SELECT * FROM mysql.time_zone where Time_zone_id = '480';
+--------------+------------------+
| Time_zone_id | Use_leap_seconds |
+--------------+------------------+
| 480 | N |
+--------------+------------------+
1 row in set (0.00 sec)
also in time_zone_transition_type:
MariaDB [(none)]> SELECT * FROM mysql.time_zone_transition_type where
Time_zone_id = '480';
+--------------+--------------------+--------+--------+--------------+
| Time_zone_id | Transition_type_id | Offset | Is_DST | Abbreviation |
+--------------+--------------------+--------+--------+--------------+
| 480 | 0 | 3921 | 0 | LMT |
| 480 | 1 | 7200 | 1 | CEST |
| 480 | 2 | 3600 | 0 | CET |
| 480 | 3 | 7200 | 1 | CEST |
| 480 | 4 | 3600 | 0 | CET |
| 480 | 5 | 7200 | 1 | CEST |
| 480 | 6 | 3600 | 0 | CET |
+--------------+--------------------+--------+--------+--------------+
7 rows in set (0.00 sec)
and in time_zone_transition
MariaDB [(none)]> SELECT * FROM mysql.time_zone_transition where Time_zone_id =
'480' limit 5;
+--------------+-----------------+--------------------+
| Time_zone_id | Transition_time | Transition_type_id |
+--------------+-----------------+--------------------+
| 480 | -2147483648 | 2 |
| 480 | -1693706400 | 1 |
| 480 | -1680483600 | 2 |
| 480 | -1663455600 | 3 |
| 480 | -1650150000 | 4 |
+--------------+-----------------+--------------------+
5 rows in set (0.00 sec)
best regards,
Chris
--
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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
