@spacepluk I think you might be seeing this issue https://github.com/metabase/metabase/issues/11251
Go give it a thumbs up and hopefully it’ll be addressed in the Timezones release which it’s currently tagged for.
@flamber I added a Sample Dataset reproduction to that issue but it didn’t seem to work for you guys, but I think my screenshots show that it’s happening in my setup. Looking forward to the timezones release as this issue is really turning some of my key users off.
@notrom Are you still seeing this (even with Sample Dataset) on 0.33.6? I'm on master right now, which has some more timezone fixes, but I cannot reproduce. Can you post your Diagnostic Info from Admin > Troubleshooting, since it contains some timezone info.
Yes this is still a problem for me. This used to work so well, I can't put my finger on exactly which version it changed at.
Here's v0.33.6 after "zoom in" on November 2019
Here's the diagnostic info (Chrome or Firefox makes no difference):
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:70.0) Gecko/20100101 Firefox/70.0",
"vendor": ""
},
"system-info": {
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_101-b13",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_101",
"java.vm.name": "Java HotSpot(TM) Client VM",
"java.vm.version": "25.101-b13",
"os.name": "Windows 7",
"os.version": "6.1",
"user.language": "en",
"user.timezone": "Pacific/Auckland"
},
"metabase-info": {
"databases": [
"sqlserver",
"postgres",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"run-mode": "prod",
"version": {
"tag": "v0.33.6",
"date": "2019-11-19",
"branch": "release-0.33.x",
"hash": "be1e0e1"
},
"settings": {
"report-timezone": "Pacific/Auckland"
}
}
}
I changed my report timezone to match yours, @notrom, (Pacific/Auckland) and the same scenario looks correct to me on master, so this will likely be fixed for you in 0.34. One difference I'm noting is that the SQL now includes with timezone:
Thanks, I’ll stick it out till 0.34. Hopefully that’ll resolve this one.
yeah, I think you’re right @notrom. I did some tests grouping by month an I still get the previous one. It doesn’t look like a TZ issue from what I can gather. I’ll add another reproduction to that github issue.
I forgot to say that I’m using the metabase app (0.33.6.0) on macOS 10.14.6, and PostgreSQL 12.
@maz is there a jar file for the master branch? I’d be more than happy to test this but don’t have a suitable environment here to build it myself at this time.
@notrom I don’t know of any master JARs, but there’s a Docker, where you should either use Docker or extract the file /app/metabase.jar from the image with docker cp.
https://hub.docker.com/r/metabase/metabase-head/tags
We’re aiming to do a release candidate build by the end of the week, so that would probably be a good time to try it out. You can watch this page: https://github.com/metabase/metabase/releases
