Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

5.5.0-beta docker image returns null for MILLIS_TO_TZ query

Description

On the docker images for 5.0.1 community and 5.5.0-beta, If you try to run the query returns wrong results:
SELECT MILLIS_TO_TZ(1463284740000, "America/New_York") as zonetime

The query will return null. However, if you install these version without docker, the query returns correct answer.

https://forums.couchbase.com/t/function-millis-to-tz-in-couchbase-community-edition-5-0-1-build-5003-not-working-well/16955

Components

Affects versions

Fix versions

Labels

Environment

docker

Link to Log File, atop/blg, CBCollectInfo, Core dump

None

Release Notes Description

None

Activity

Show:

Korrigan Clark June 6, 2018 at 10:34 PM

Ok I verified the correct image 5.1.1 and it works fine, closing this out.

Chris Hillery June 6, 2018 at 10:19 PM

That's no longer a supported tag. The Official Image only has the most recent EE and CE versions, as shown in the text here: https://hub.docker.com/_/couchbase/

Older tags aren't deleted but are kept for historical consistency. But there's no way for us to modify them anymore, and they aren't "advertised" as part of the Official Image anymore. This is all Docker's policy, not ours.

Korrigan Clark June 6, 2018 at 10:12 PM

I have verified all the images. The offical enterprise-5.1.0 image still has the issue present. You can see by docker run -d --name db -p 8091-8094:8091-8094 -p 11210:11210 couchbase:enterprise-5.1.0 and running the folllowing query: SELECT MILLIS_TO_TZ(1463284740000, "America/New_York") as zonetime. The image returns null.

Chris Hillery June 6, 2018 at 9:32 PM

Official images have been updated. Resolving and assigning back to Korrigan.

Korrigan Clark June 6, 2018 at 5:06 PM

Unofficial images have been verified, just waiting on official images from dockerhub

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Is this a Regression?

Unknown

Triage

Untriaged

Operating System

Centos 64-bit

Due date

Story Points

Sprint

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created May 23, 2018 at 4:53 PM
Updated June 13, 2018 at 3:03 PM
Resolved June 13, 2018 at 3:03 PM
Instabug