[MB-31367] Sync gateway fails to start with multiple couchbase servers on 6.0.0-1643 - Couchbase database

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Test Blocker
Resolution: Fixed
Affects Version/s: 6.0.0
Fix Version/s: 6.0.0
Component/s: query
Labels:
None

Is this a Regression?:
Yes

Description

Sync Gateway version

SG version - 2.1.0-121

Couchbase server

CBS - 6.0.0-1643

Operating system

Centos for CBS and Sync gateway

Sync gateway Config file

{{ "interface":":4984",
"adminInterface": "0.0.0.0:4985",
"maxIncomingConnections": 0,
"maxCouchbaseConnections": 16,
"maxFileDescriptors": 90000,
"slowServerCallWarningThreshold": 500,
"compressResponses": false,

"logging": {"debug":

{"enabled": true}

},
"databases":{
"db":

{ "import_docs": "continuous", "enable_shared_bucket_access": true, "num_index_replicas": 0, "server":"http://192.168.33.10,192.168.33.11,192.168.33.12:8091", "bucket":"data-bucket", "username":"data-bucket", "password": "password" }

}
}}}

Sync gateway Log output

https://gist.github.com/sridevi-15/f64ac3ba064e887188938478142f7265

Steps to reproduce

Set up 3 couchbase servers in the CBS cluster.
Start sync-gateway with above config by providing 3 cbs urls on the config

Expected behavior

It should start successfully

Actual behavior

Sync gateway failed to start

Note : It passed with previous version 5.5.2-3733 and also 6.0.0-1592. It passed in DI mode(sg accel) with CBS 6.0.0-1643.
It passed with use views in CC mode with CBS 6.0.0-1643

It failed only with GSI

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

cbs1.zip
4.10 MB
20/Sep/18 1:33 PM
cbs2.zip
2.69 MB
20/Sep/18 1:33 PM
cbs3.zip
2.67 MB
20/Sep/18 1:33 PM
index-logs.txt
7 kB
20/Sep/18 6:14 PM

Gerrit Reviews

- Issue Only
- Show All Reviews
- Show Open Reviews
- Show All Issues
- Show Open Issues

No reviews matched the request. Check your Options in the drop-down menu of this sections header.

Activity

Ascending order - Click to sort in descending order

Sridevi Saragadam (Inactive) created issue - 20/Sep/18 1:32 PM

Sridevi Saragadam (Inactive) made changes - 20/Sep/18 1:33 PM

Field	Original Value	New Value
Description	h3. Sync Gateway version SG version - 2.0.0-121 h3. Couchbase server CBS - 6.0.0-1643 h3. Operating system Centos for CBS and Sync gateway h3. Sync gateway Config file {{ "interface":":4984", "adminInterface": "0.0.0.0:4985", "maxIncomingConnections": 0, "maxCouchbaseConnections": 16, "maxFileDescriptors": 90000, "slowServerCallWarningThreshold": 500, "compressResponses": false, "logging": \{"debug": {"enabled": true} }, "databases":\{ "db":{ "import_docs": "continuous", "enable_shared_bucket_access": true, "num_index_replicas": 0, "server":"http://192.168.33.10,192.168.33.11,192.168.33.12:8091", "bucket":"data-bucket", "username":"data-bucket", "password": "password" } } }}} h3. Sync gateway Log output [https://gist.github.com/sridevi-15/f64ac3ba064e887188938478142f7265] h3. Steps to reproduce # Set up 3 couchbase servers in the CBS cluster. # Start sync-gateway with above config by providing 3 cbs urls on the config h3. Expected behavior It should start successfully h3. Actual behavior Sync gateway failed to start Note : It passed with previous version 5.5.2-3733 and also 6.0.0-1592. It passed in DI mode(sg accel) with CBS 6.0.0-1643. It passed with use views in CC mode with CBS 6.0.0-1643 It failed only with GSI	h3. Sync Gateway version SG version - 2.1.0-121 h3. Couchbase server CBS - 6.0.0-1643 h3. Operating system Centos for CBS and Sync gateway h3. Sync gateway Config file {{ "interface":":4984", "adminInterface": "0.0.0.0:4985", "maxIncomingConnections": 0, "maxCouchbaseConnections": 16, "maxFileDescriptors": 90000, "slowServerCallWarningThreshold": 500, "compressResponses": false, "logging": {"debug": {"enabled": true} }, "databases":{ "db": { "import_docs": "continuous", "enable_shared_bucket_access": true, "num_index_replicas": 0, "server":"http://192.168.33.10,192.168.33.11,192.168.33.12:8091", "bucket":"data-bucket", "username":"data-bucket", "password": "password" } } }}} h3. Sync gateway Log output [https://gist.github.com/sridevi-15/f64ac3ba064e887188938478142f7265] h3. Steps to reproduce # Set up 3 couchbase servers in the CBS cluster. # Start sync-gateway with above config by providing 3 cbs urls on the config h3. Expected behavior It should start successfully h3. Actual behavior Sync gateway failed to start Note : It passed with previous version 5.5.2-3733 and also 6.0.0-1592. It passed in DI mode(sg accel) with CBS 6.0.0-1643. It passed with use views in CC mode with CBS 6.0.0-1643 It failed only with GSI

Sridevi Saragadam (Inactive) made changes - 20/Sep/18 1:33 PM

Attachment		cbs1.zip [ 59211 ]
Attachment		cbs2.zip [ 59212 ]
Attachment		cbs3.zip [ 59213 ]

Sridevi Saragadam (Inactive) added a comment - 20/Sep/18 1:34 PM

https://github.com/couchbase/sync_gateway/issues/3755

Sridevi Saragadam (Inactive) added a comment - 20/Sep/18 1:34 PM https://github.com/couchbase/sync_gateway/issues/3755

Raju Suravarjjala made changes - 20/Sep/18 2:34 PM

Issue Type

Task [ 3 ]

Bug [ 1 ]

Raju Suravarjjala made changes - 20/Sep/18 2:35 PM

Priority

Major [ 3 ]

Test Blocker [ 6 ]

Raju Suravarjjala made changes - 20/Sep/18 2:35 PM

Assignee

Ajit Yagaty [ ajit.yagaty ]

Raju Suravarjjala made changes - 20/Sep/18 2:38 PM

Component/s

secondary-index [ 11211 ]

Raju Suravarjjala made changes - 20/Sep/18 3:24 PM

Fix Version/s

Alice [ 15048 ]

Deepkaran Salooja added a comment - 20/Sep/18 3:40 PM - edited

All the indexes are Ready on 192.168.33.10

2018-09-16T06:34:28.789+00:00 [Info] ClustMgr:handleIndexMap

        Message: MsgUpdateInstMap

        InstanceId: 1754351140469947657 Name: sg_syncDocs_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0

        InstanceId: 2183354563651944360 Name: sg_access_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0

        InstanceId: 2586860435507563506 Name: sg_roleAccess_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0

        InstanceId: 7683416839874631805 Name: sg_channels_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0

        InstanceId: 15621229286760607597 Name: sg_allDocs_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0

        InstanceId: 13398647996422839803 Name: sg_tombstones_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0

How does sync gateway check for the status of the indexes?

Deepkaran Salooja added a comment - 20/Sep/18 3:40 PM - edited All the indexes are Ready on 192.168.33.10 2018-09-16T06:34:28.789+00:00 [Info] ClustMgr:handleIndexMap Message: MsgUpdateInstMap InstanceId: 1754351140469947657 Name: sg_syncDocs_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0 InstanceId: 2183354563651944360 Name: sg_access_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0 InstanceId: 2586860435507563506 Name: sg_roleAccess_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0 InstanceId: 7683416839874631805 Name: sg_channels_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0 InstanceId: 15621229286760607597 Name: sg_allDocs_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0 InstanceId: 13398647996422839803 Name: sg_tombstones_x1 Bucket: data-bucket State: INDEX_STATE_ACTIVE Stream: MAINT_STREAM RState: RebalActive Version: 0 ReplicaId: 0 How does sync gateway check for the status of the indexes?

Raju Suravarjjala made changes - 20/Sep/18 3:41 PM

Assignee

Ajit Yagaty [ ajit.yagaty ]

Adam Fraser [ adamf ]

Lynn Straus made changes - 20/Sep/18 3:43 PM

Is this a Regression?

Yes [ 10450 ]

Daniel Petersen made changes - 20/Sep/18 3:48 PM

Component/s

sgw [ 14012 ]

Adam Fraser added a comment - 20/Sep/18 3:48 PM

For the failing operation in this test, Sync Gateway is issuing a limit=1 query that exercises the index.

Based on the timing in SG logs on the github ticket, the last check was made at:

2018-09-16T03:05:22.311Z [INF] Timeout waiting for index "sg_channels_x1" to be ready for bucket "data-bucket" - retrying...

Is the timestamp in the above message (2018-09-16T06:34:28.789) correspond to when the indexes became ready? Or were they also ready before that time?

Adam Fraser added a comment - 20/Sep/18 3:48 PM For the failing operation in this test, Sync Gateway is issuing a limit=1 query that exercises the index. Based on the timing in SG logs on the github ticket, the last check was made at: 2018-09-16T03:05:22.311Z [INF] Timeout waiting for index "sg_channels_x1" to be ready for bucket "data-bucket" - retrying... Is the timestamp in the above message (2018-09-16T06:34:28.789) correspond to when the indexes became ready? Or were they also ready before that time?

Adam Fraser made changes - 20/Sep/18 3:48 PM

Assignee

Adam Fraser [ adamf ]

Deepkaran Salooja [ deepkaran.salooja ]

Adam Fraser added a comment - 20/Sep/18 3:55 PM

Some additional context:

SG doesn't issue that query until the index state is showing as online (based on system:indexes), so based on the logs, Sync Gateway detects that the index is online as of 2018-09-16T00:37:51.275Z, but queries continue to time out until at least 2018-09-16T03:05:22.311Z

Sridevi Saragadam - I'm assuming the test is expecting an empty bucket at this point (so the query isn't timing out due to data volume). Can you confirm?

Adam Fraser added a comment - 20/Sep/18 3:55 PM Some additional context: SG doesn't issue that query until the index state is showing as online (based on system:indexes), so based on the logs, Sync Gateway detects that the index is online as of 2018-09-16T00:37:51.275Z, but queries continue to time out until at least 2018-09-16T03:05:22.311Z Sridevi Saragadam - I'm assuming the test is expecting an empty bucket at this point (so the query isn't timing out due to data volume). Can you confirm?

Amit Krishnan (Inactive) added a comment - 20/Sep/18 4:09 PM - edited

One additional observation.

Since the timeout error in the sync gateway log is caused as a result of a failed query

https://github.com/couchbase/sync_gateway/blob/667cde53ac5d24d5da2b8266e56b933d418086d9/db/indexes.go#L346

I took a quick look at the ns_server.query.log on node 192.168.33.10. Its full of null pointer exceptions like

_time=2018-09-16T06:34:30.197+00:00 _level=SEVERE _msg= panic=runtime error: invalid memory address or nil pointer dereference stack=goroutine 67 [running]:
github.com/couchbase/query/server.(*Server).serviceRequest.func1()
goproj/src/github.com/couchbase/query/server/server.go:501 +0xbc
panic(0xe3b140, 0x1873120)
<.......>

Adam Fraser if you could post the specific query that is being issued it would help the query team triage further.

Amit Krishnan (Inactive) added a comment - 20/Sep/18 4:09 PM - edited One additional observation. Since the timeout error in the sync gateway log is caused as a result of a failed query https://github.com/couchbase/sync_gateway/blob/667cde53ac5d24d5da2b8266e56b933d418086d9/db/indexes.go#L346 I took a quick look at the ns_server.query.log on node 192.168.33.10. Its full of null pointer exceptions like _time=2018-09-16T06:34:30.197+00:00 _level=SEVERE _msg= panic=runtime error: invalid memory address or nil pointer dereference stack=goroutine 67 [running] : github.com/couchbase/query/server.(*Server).serviceRequest.func1() goproj/src/github.com/couchbase/query/server/server.go:501 +0xbc panic(0xe3b140, 0x1873120) <.......> Adam Fraser if you could post the specific query that is being issued it would help the query team triage further.

Amit Krishnan (Inactive) made changes - 20/Sep/18 4:11 PM

Assignee

Deepkaran Salooja [ deepkaran.salooja ]

Keshav Murthy [ keshav ]

Sridevi Saragadam (Inactive) added a comment - 20/Sep/18 4:31 PM

Adam Fraser, Yes it is expecting empty bucket . No docs loaded yet at this point.

Sridevi Saragadam (Inactive) added a comment - 20/Sep/18 4:31 PM Adam Fraser , Yes it is expecting empty bucket . No docs loaded yet at this point.

Ajit Yagaty [X] (Inactive) made changes - 20/Sep/18 4:33 PM

Component/s		query [ 10718 ]
Component/s	secondary-index [ 11211 ]

Traun Leyden (Inactive) added a comment - 20/Sep/18 4:38 PM

Hey @Amit, Adam is traveling and he asked me to look into this. This is the query: https://github.com/couchbase/sync_gateway/blob/master/db/indexes.go#L107-L112

Traun Leyden (Inactive) added a comment - 20/Sep/18 4:38 PM Hey @Amit, Adam is traveling and he asked me to look into this. This is the query: https://github.com/couchbase/sync_gateway/blob/master/db/indexes.go#L107-L112

Keshav Murthy added a comment - 20/Sep/18 4:41 PM

Traun Leyden: That sounds good. We're unfamiliar with sync gateway code. Please debug and let us know if you need any help.

/cc Daniel Petersen

Keshav Murthy added a comment - 20/Sep/18 4:41 PM Traun Leyden : That sounds good. We're unfamiliar with sync gateway code. Please debug and let us know if you need any help. /cc Daniel Petersen

Traun Leyden (Inactive) made changes - 20/Sep/18 6:14 PM

Attachment

index-logs.txt [ 59228 ]

Traun Leyden (Inactive) added a comment - 20/Sep/18 6:17 PM - edited

To debug this I'll either have to get a repro setup locally, which will take a decent chunk of effort, or find out from Sridevi Saragadam the details of the hosts where this test is running and coordinate with her so that my debugging doesn't interfere with the automated testing.

I did some local inspection and enabled additional logging, and here are the log messages for the index creation and query strings. (attached as [^index-logs.txt).]

In particular, the query string that corresponds to the code link I linked to earlier:

SELECT [op.name, LEAST(`test_data_bucket`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)][1] AS sequence FROM `test_data_bucket` UNNEST OBJECT_PAIRS(`test_data_bucket`._sync.channels) AS op WHERE [op.name, LEAST(`test_data_bucket`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)] BETWEEN ['foo', 0] AND ['foo', 1] ORDER BY sequence LIMIT 1

I'm not sure if there is some unexpected/unwanted formatting in that string, if so let me know and I can dig into how to get it formatted better.

Traun Leyden (Inactive) added a comment - 20/Sep/18 6:17 PM - edited To debug this I'll either have to get a repro setup locally, which will take a decent chunk of effort, or find out from Sridevi Saragadam the details of the hosts where this test is running and coordinate with her so that my debugging doesn't interfere with the automated testing. I did some local inspection and enabled additional logging, and here are the log messages for the index creation and query strings. (attached as [^index-logs.txt).] In particular, the query string that corresponds to the code link I linked to earlier: SELECT [op.name, LEAST(`test_data_bucket`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)] [1] AS sequence FROM `test_data_bucket` UNNEST OBJECT_PAIRS(`test_data_bucket`._sync.channels) AS op WHERE [op.name, LEAST(`test_data_bucket`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)] BETWEEN ['foo', 0] AND ['foo', 1] ORDER BY sequence LIMIT 1 I'm not sure if there is some unexpected/unwanted formatting in that string, if so let me know and I can dig into how to get it formatted better.

Traun Leyden (Inactive) added a comment - 20/Sep/18 6:29 PM

Sridevi Saragadam the following steps might reveal something from the failing test:

1. Enable trace level logs for queries by updating your sync gateway config to enable trace level logging on the Query log key, for example:

{
"adminInterface":":4985",
"logging": {
"console":

{ "log_level": "trace", "log_keys": ["HTTP", "Query"] }

2. Reproduce the issue using those settings.

3. Look into the logs and find the equivalent query mentioned in my previous comment.

4. Try running the query directly on the query workbench to see if it returns in a timely manner.

Traun Leyden (Inactive) added a comment - 20/Sep/18 6:29 PM Sridevi Saragadam the following steps might reveal something from the failing test: 1. Enable trace level logs for queries by updating your sync gateway config to enable trace level logging on the Query log key, for example: { "adminInterface":":4985", "logging": { "console": { "log_level": "trace", "log_keys": ["HTTP", "Query"] } }, 2. Reproduce the issue using those settings. 3. Look into the logs and find the equivalent query mentioned in my previous comment. 4. Try running the query directly on the query workbench to see if it returns in a timely manner.

Sitaram Vemulapalli added a comment - 20/Sep/18 7:45 PM

_time=2018-09-16T08:13:16.014+00:00 _level=SEVERE _msg= panic=runtime error: invalid memory address or nil pointer dereference stack=goroutine 52 [running]:
github.com/couchbase/query/server.(*Server).serviceRequest.func1()
goproj/src/github.com/couchbase/query/server/server.go:501 +0xbc
panic(0xe3b140, 0x1873120)
/home/couchbase/.cbdepscache/exploded/x86_64/go-1.8.5/go/src/runtime/panic.go:489 +0x2cf
github.com/couchbase/query/planner.(*Filter).Copy(0xc4211fad20, 0xc42102af38)
goproj/src/github.com/couchbase/query/planner/filter.go:56 +0x68
github.com/couchbase/query/planner.addUnnestPreds(0xc4211fab10, 0xc420e81d80)
goproj/src/github.com/couchbase/query/planner/build_scan_unnest.go:215 +0x473
github.com/couchbase/query/planner.(*builder).buildScan(0xc4206d7a40, 0x18a7860, 0xc42053bf90, 0xc42054caf0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
goproj/src/github.com/couchbase/query/planner/build_scan.go:105 +0x7d2
github.com/couchbase/query/planner.(*builder).selectScan(0xc4206d7a40, 0x18a7860, 0xc42053bf90, 0xc42054caf0, 0x0, 0x0, 0x0, 0x0)
goproj/src/github.com/couchbase/query/planner/build_scan.go:39 +0x3b1
github.com/couchbase/query/planner.(*builder).VisitKeyspaceTerm(0xc4206d7a40, 0xc42054caf0, 0x18d88a0, 0xc42141a240, 0xf4ada0, 0xc4211a4870)
goproj/src/github.com/couchbase/query/planner/build_select_from.go:118 +0xf3
github.com/couchbase/query/algebra.(*KeyspaceTerm).Accept(0xc42054caf0, 0x18aacc0, 0xc4206d7a40, 0x18ad6c0, 0xc4211a4870, 0xc4211fab10, 0x0)
goproj/src/github.com/couchbase/query/algebra/from_keyspace.go:58 +0x3b
github.com/couchbase/query/planner.(*builder).VisitExpressionTerm(0xc4206d7a40, 0xc4211fa630, 0x9371f3, 0xc4211fa630, 0x18a5540, 0xc4211fa630)
goproj/src/github.com/couchbase/query/planner/build_select_from.go:176 +0x628
github.com/couchbase/query/algebra.(*ExpressionTerm).Accept(0xc4211fa630, 0x18aacc0, 0xc4206d7a40, 0x0, 0x0, 0x0, 0x0)
goproj/src/github.com/couchbase/query/algebra/from_expression.go:38 +0x3b
github.com/couchbase/query/planner.(*builder).VisitUnnest(0xc4206d7a40, 0xc4214892c0, 0x0, 0x0, 0x0, 0x0)
goproj/src/github.com/couchbase/query/planner/build_select_from.go:446 +0x9c
github.com/couchbase/query/algebra.(*Unnest).Accept(0xc4214892c0, 0x18aacc0, 0xc4206d7a40, 0x0, 0x0, 0x0, 0x0)
goproj/src/github.com/couchbase/query/algebra/from_unnest.go:37 +0x3e
github.com/couchbase/query/planner.(*builder).visitFrom(0xc4206d7a40, 0xc420fed950, 0x0, 0x0, 0x0)
goproj/src/github.com/couchbase/query/planner/build_select_from.go:74 +0x617
github.com/couchbase/query/planner.(*builder).VisitSubselect(0xc4206d7a40, 0xc420fed950, 0x0, 0x0, 0x0, 0x0)
goproj/src/github.com/couchbase/query/planner/build_select_sub.go:194 +0x80a
github.com/couchbase/query/algebra.(*Subselect).Accept(0xc420fed950, 0x18aacc0, 0xc4206d7a40, 0x18b0ac0, 0xc4211fa780, 0x0, 0x0)

Sitaram Vemulapalli added a comment - 20/Sep/18 7:45 PM _time=2018-09-16T08:13:16.014+00:00 _level=SEVERE _msg= panic=runtime error: invalid memory address or nil pointer dereference stack=goroutine 52 [running] : github.com/couchbase/query/server.(*Server).serviceRequest.func1() goproj/src/github.com/couchbase/query/server/server.go:501 +0xbc panic(0xe3b140, 0x1873120) /home/couchbase/.cbdepscache/exploded/x86_64/go-1.8.5/go/src/runtime/panic.go:489 +0x2cf github.com/couchbase/query/planner.(*Filter).Copy(0xc4211fad20, 0xc42102af38) goproj/src/github.com/couchbase/query/planner/filter.go:56 +0x68 github.com/couchbase/query/planner.addUnnestPreds(0xc4211fab10, 0xc420e81d80) goproj/src/github.com/couchbase/query/planner/build_scan_unnest.go:215 +0x473 github.com/couchbase/query/planner.(*builder).buildScan(0xc4206d7a40, 0x18a7860, 0xc42053bf90, 0xc42054caf0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) goproj/src/github.com/couchbase/query/planner/build_scan.go:105 +0x7d2 github.com/couchbase/query/planner.(*builder).selectScan(0xc4206d7a40, 0x18a7860, 0xc42053bf90, 0xc42054caf0, 0x0, 0x0, 0x0, 0x0) goproj/src/github.com/couchbase/query/planner/build_scan.go:39 +0x3b1 github.com/couchbase/query/planner.(*builder).VisitKeyspaceTerm(0xc4206d7a40, 0xc42054caf0, 0x18d88a0, 0xc42141a240, 0xf4ada0, 0xc4211a4870) goproj/src/github.com/couchbase/query/planner/build_select_from.go:118 +0xf3 github.com/couchbase/query/algebra.(*KeyspaceTerm).Accept(0xc42054caf0, 0x18aacc0, 0xc4206d7a40, 0x18ad6c0, 0xc4211a4870, 0xc4211fab10, 0x0) goproj/src/github.com/couchbase/query/algebra/from_keyspace.go:58 +0x3b github.com/couchbase/query/planner.(*builder).VisitExpressionTerm(0xc4206d7a40, 0xc4211fa630, 0x9371f3, 0xc4211fa630, 0x18a5540, 0xc4211fa630) goproj/src/github.com/couchbase/query/planner/build_select_from.go:176 +0x628 github.com/couchbase/query/algebra.(*ExpressionTerm).Accept(0xc4211fa630, 0x18aacc0, 0xc4206d7a40, 0x0, 0x0, 0x0, 0x0) goproj/src/github.com/couchbase/query/algebra/from_expression.go:38 +0x3b github.com/couchbase/query/planner.(*builder).VisitUnnest(0xc4206d7a40, 0xc4214892c0, 0x0, 0x0, 0x0, 0x0) goproj/src/github.com/couchbase/query/planner/build_select_from.go:446 +0x9c github.com/couchbase/query/algebra.(*Unnest).Accept(0xc4214892c0, 0x18aacc0, 0xc4206d7a40, 0x0, 0x0, 0x0, 0x0) goproj/src/github.com/couchbase/query/algebra/from_unnest.go:37 +0x3e github.com/couchbase/query/planner.(*builder).visitFrom(0xc4206d7a40, 0xc420fed950, 0x0, 0x0, 0x0) goproj/src/github.com/couchbase/query/planner/build_select_from.go:74 +0x617 github.com/couchbase/query/planner.(*builder).VisitSubselect(0xc4206d7a40, 0xc420fed950, 0x0, 0x0, 0x0, 0x0) goproj/src/github.com/couchbase/query/planner/build_select_sub.go:194 +0x80a github.com/couchbase/query/algebra.(*Subselect).Accept(0xc420fed950, 0x18aacc0, 0xc4206d7a40, 0x18b0ac0, 0xc4211fa780, 0x0, 0x0)

Sitaram Vemulapalli added a comment - 20/Sep/18 7:46 PM - edited

CREATE INDEX `ix20` ON `default`(ALL (ARRAY [op.name, LEAST(`self`._sync.sequence,op.val.seq), IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)] FOR op IN OBJECT_PAIRS(`self`._sync.channels) END), `self`._sync.rev, `self`._sync.sequence, `self`._sync.flags);

SELECT  [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)][1] AS sequence FROM `default` UNNEST OBJECT_PAIRS(`d`._sync.channels) AS op WHERE [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)]  BETWEEN  ['foo', 0] AND ['foo', 1] ORDER BY sequence LIMIT 1;

Sitaram Vemulapalli added a comment - 20/Sep/18 7:46 PM - edited CREATE INDEX `ix20` ON ` default `(ALL (ARRAY [op.name, LEAST(`self`._sync.sequence,op.val.seq), IFMISSING(op.val.rev, null ), IFMISSING(op.val.del, null )] FOR op IN OBJECT_PAIRS(`self`._sync.channels) END), `self`._sync.rev, `self`._sync.sequence, `self`._sync.flags); SELECT [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev, null ), IFMISSING(op.val.del, null )][ 1 ] AS sequence FROM ` default ` UNNEST OBJECT_PAIRS(`d`._sync.channels) AS op WHERE [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev, null ), IFMISSING(op.val.del, null )] BETWEEN [ 'foo' , 0 ] AND [ 'foo' , 1 ] ORDER BY sequence LIMIT 1 ;

Sitaram Vemulapalli made changes - 20/Sep/18 8:41 PM

Assignee

Keshav Murthy [ keshav ]

Sitaram Vemulapalli [ sitaram.vemulapalli ]

Sitaram Vemulapalli added a comment - 20/Sep/18 8:42 PM

Raju Suravarjjala, Keshav Murthy If this need for 6.0.0 please triage this.

Sitaram Vemulapalli added a comment - 20/Sep/18 8:42 PM Raju Suravarjjala , Keshav Murthy If this need for 6.0.0 please triage this.

Couchbase Build Team added a comment - 20/Sep/18 11:29 PM

Build couchbase-server-6.5.0-1343 contains query commit 7b4d40c with commit message:
~~MB-31367~~. Copy expression when it is not nil

Couchbase Build Team added a comment - 20/Sep/18 11:29 PM Build couchbase-server-6.5.0-1343 contains query commit 7b4d40c with commit message: MB-31367 . Copy expression when it is not nil

Lynn Straus added a comment - 21/Sep/18 8:32 AM

Approved for 6.0. Will add to Alice release ticket shortly.

Lynn Straus added a comment - 21/Sep/18 8:32 AM Approved for 6.0. Will add to Alice release ticket shortly.

Lynn Straus made changes - 21/Sep/18 8:49 AM

Link

This issue blocks MB-30692 [ MB-30692 ]

Sitaram Vemulapalli made changes - 21/Sep/18 9:02 AM

Assignee	Sitaram Vemulapalli [ sitaram.vemulapalli ]	Sridevi Saragadam [ sridevi.saragadam ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

Sridevi Saragadam (Inactive) added a comment - 21/Sep/18 11:05 AM

verified on 6.0.0-1658 and 6.5.0-1343. Test has passed now on both the builds

Sridevi Saragadam (Inactive) added a comment - 21/Sep/18 11:05 AM verified on 6.0.0-1658 and 6.5.0-1343. Test has passed now on both the builds

Sridevi Saragadam (Inactive) made changes - 21/Sep/18 11:10 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

People

Assignee:: Sridevi Saragadam (Inactive)

Reporter:: Sridevi Saragadam (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 13 Start watching this issue

Dates

Created:: 20/Sep/18 1:32 PM

Updated:: 21/Sep/18 11:10 AM

Resolved:: 21/Sep/18 9:02 AM

Gerrit Reviews

There are no open Gerrit changes

Show There are 2 closed Gerrit changes

Hide There are 2 closed Gerrit changes

MB-31367. Copy expression when it is not nil: Gerrit Review:

MB-31367. Copy expression when it is not nil: Gerrit Review:

PagerDuty

Couchbase Server

Details

Description

Sync Gateway version

Couchbase server

Operating system

Sync gateway Config file

Sync gateway Log output

Steps to reproduce

Expected behavior

Actual behavior

Attachments

Attachments

Gerrit Reviews

Activity

People

Dates

Gerrit Reviews

PagerDuty