I am facing issue with my metabase timezone.I have mysql database running on UTC and postgres as well on UTC.When i change timezone to asia/calcuttta it is adding 11 hours to UTC rather than 5:30 minute.
Sorry for the trouble. I just wrote a response to another user about this same issue here: Issue with metabase! Urgent
New Timezone related issue.
New install.
metabase v0.24.2
DB = Mysql 5.7
Getting the following error when after attempting to set the timezone through the UI.
07-11 14:12:56 DEBUG generic-sql.query-processor :: Setting timezone with statement: SET @@session.time_zone = ‘US/Eastern’;
07-11 14:12:56 ERROR generic-sql.query-processor :: Failed to set timezone:
SQLException:
Message: Unknown or incorrect time zone: ‘US/Eastern’
SQLState: HY000
Error Code: 1298
I had the same Issue.
You can fix this by loading the timezones data into MySQL using
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p
After I did that the errors were gone.
1 Like