[MB-45967] Volume: Data missing for N1QL handlers - Couchbase database

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Critical
Resolution: Fixed
Affects Version/s: Cheshire-Cat
Fix Version/s: 7.0.0
Component/s: eventing
Labels:

Triage:
Untriaged
Story Points:
1
Is this a Regression?:
Unknown

Description

Build: 7.0.0 build 5046

Test: Eventing volume https://docs.google.com/document/d/1dJ6VhHtLaRLTPVKQm0EomakzUNZDz2x7xJv3JqZVuqw/edit?usp=sharing

Create 9 node cluster ( Eventing:2 , Kv:5,index:1,query:1)
Create 15 handlers (3 of bucket op, timer,n1ql, SBM, curl)
deploy bucket op, timers and N1ql
Rebalance in 1 eventing node
Start CRUD on bucket_op where no handler are deployed
Verify handlers

Source Bucket(n1ql_op.scope_0.coll0) : 6226696, Destination Bucket(['n1ql_op.scope_1.coll0']) : 6226691

Source Bucket(n1ql_op.scope_0.coll1) : 6226416, Destination Bucket(['n1ql_op.scope_1.coll1']) : 6226410

function OnUpdate(doc, meta) {

    try{

        var query = UPSERT INTO n1ql_op.scope_1.`coll0` ( KEY, VALUE ) VALUES ( $meta.id ,"n1ql insert");

    catch(e){

        log("Query failed: ",e)

}function OnDelete(meta, options) {

try{

        var query = DELETE from n1ql_op.scope_1.`coll0` USE KEYS $meta.id ;

    catch(e){

        log("Query failed: ",e)

function OnUpdate(doc, meta) {

    try{

        var query = UPSERT INTO n1ql_op.scope_1.`coll1` ( KEY, VALUE ) VALUES ( $meta.id ,"n1ql insert");

    catch(e){

        log("Query failed: ",e)

}function OnDelete(meta, options) {

try{

        var query = DELETE from n1ql_op.scope_1.`coll1` USE KEYS $meta.id ;

    catch(e){

        log("Query failed: ",e)

Attachments

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

invalid_requests (1).png
268 kB
04/May/21 6:19 AM
n1ql_dmls.png
286 kB
06/May/21 4:06 AM
n1ql_op_scope1_docs_difference.png
386 kB
04/May/21 6:06 AM
n1ql_test0.log
26.99 MB
10/May/21 3:00 AM
n1ql_test01.log
29.66 MB
10/May/21 3:23 AM
n1ql_test02.log
37.63 MB
10/May/21 3:42 AM
n1ql0.log
18.79 MB
10/May/21 3:00 AM
n1ql01.log
19.17 MB
10/May/21 3:23 AM
n1ql02.log
23.03 MB
10/May/21 3:31 AM
queries_prior_to_deployment.png
269 kB
06/May/21 4:04 AM

Issue Links

backports to

MB-46326 [Backport to 6.6.3] - Volume Test: Data missing for N1QL handlers

Closed

depends on

CCBC-1411 Further disambiguate 12009 error returned by Query into retriable-transient-errors and non-retriable-specific-errors

Resolved

is duplicated by

MB-46264 [Eventing][Windows] Data mismatch for rebalance + collection tests

Closed

relates to

MB-47366 Public interface documentation on parsing 12009 DML error

Resolved

MB-44784 [Volume Test]: Timers not getting fired

Closed

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

Vikas Chaudhary created issue - 27/Apr/21 10:42 PM

Vikas Chaudhary made changes - 27/Apr/21 10:44 PM

Field	Original Value	New Value
Description	Build: 7.0.0 build 5046 Test: Eventing volume [https://docs.google.com/document/d/1dJ6VhHtLaRLTPVKQm0EomakzUNZDz2x7xJv3JqZVuqw/edit?usp=sharing] * Create 9 node cluster ( Eventing:2 , Kv:5,index:1,query:1) * Create 15 handlers (3 of bucket op, timer,n1ql, SBM, curl) * deploy bucket op, timers and N1ql * Rebalance in 1 eventing node * Start CRUD on bucket_op where no handler are deployed * Verify handlers {noformat} Source Bucket(n1ql_op.scope_0.coll0) : 6226696, Destination Bucket(['n1ql_op.scope_1.coll0']) : 6226691 {noformat} {noformat} Source Bucket(n1ql_op.scope_0.coll1) : 6226416, Destination Bucket(['n1ql_op.scope_1.coll1']) : 6226410 {noformat}	Build: 7.0.0 build 5046 Test: Eventing volume [https://docs.google.com/document/d/1dJ6VhHtLaRLTPVKQm0EomakzUNZDz2x7xJv3JqZVuqw/edit?usp=sharing] * Create 9 node cluster ( Eventing:2 , Kv:5,index:1,query:1) * Create 15 handlers (3 of bucket op, timer,n1ql, SBM, curl) * deploy bucket op, timers and N1ql * Rebalance in 1 eventing node * Start CRUD on bucket_op where no handler are deployed * Verify handlers {noformat}Source Bucket(n1ql_op.scope_0.coll0) : 6226696, Destination Bucket(['n1ql_op.scope_1.coll0']) : 6226691 {noformat} {noformat}Source Bucket(n1ql_op.scope_0.coll1) : 6226416, Destination Bucket(['n1ql_op.scope_1.coll1']) : 6226410 {noformat} {noformat} function OnUpdate(doc, meta) { try{ var query = UPSERT INTO n1ql_op.scope_1.`coll0` ( KEY, VALUE ) VALUES ( $meta.id ,"n1ql insert"); } catch(e){ log("Query failed: ",e) } }function OnDelete(meta, options) { try{ var query = DELETE from n1ql_op.scope_1.`coll0` USE KEYS $meta.id ; } catch(e){ log("Query failed: ",e) } } {noformat} {noformat} function OnUpdate(doc, meta) { try{ var query = UPSERT INTO n1ql_op.scope_1.`coll1` ( KEY, VALUE ) VALUES ( $meta.id ,"n1ql insert"); } catch(e){ log("Query failed: ",e) } }function OnDelete(meta, options) { try{ var query = DELETE from n1ql_op.scope_1.`coll1` USE KEYS $meta.id ; } catch(e){ log("Query failed: ",e) } } {noformat}

Abhishek Jindal made changes - 28/Apr/21 12:46 AM

Assignee

Jeelan Poola [ jeelan.poola ]

Abhishek Jindal [ abhishek.jindal ]

Abhishek Jindal made changes - 28/Apr/21 1:02 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Vikas Chaudhary [ vikas.chaudhary ]

Vikas Chaudhary made changes - 28/Apr/21 1:14 AM

Assignee

Vikas Chaudhary [ vikas.chaudhary ]

Abhishek Jindal [ abhishek.jindal ]

Abhishek Jindal made changes - 28/Apr/21 1:25 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Marco Greco [ marco.greco ]

Abhishek Jindal made changes - 28/Apr/21 1:25 AM

Component/s

query [ 10718 ]

Marco Greco made changes - 28/Apr/21 2:18 AM

Assignee

Marco Greco [ marco.greco ]

Abhishek Jindal [ abhishek.jindal ]

Kamini Jagtiani (Inactive) made changes - 29/Apr/21 9:10 AM

Component/s

query [ 10718 ]

Abhishek Jindal made changes - 03/May/21 7:51 AM

Due Date

05/May/21

Abhishek Jindal made changes - 03/May/21 11:07 PM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Vikas Chaudhary [ vikas.chaudhary ]

Abhishek Jindal made changes - 03/May/21 11:08 PM

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

Chanabasappa Ghali made changes - 03/May/21 11:10 PM

Assignee

Vikas Chaudhary [ vikas.chaudhary ]

Sujay Gad [ JIRAUSER25279 ]

Sujay Gad made changes - 04/May/21 2:07 AM

Resolution	Fixed [ 1 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Sujay Gad made changes - 04/May/21 2:10 AM

Assignee

Sujay Gad [ JIRAUSER25279 ]

Abhishek Jindal [ abhishek.jindal ]

Abhishek Jindal made changes - 04/May/21 6:06 AM

Attachment

n1ql_op_scope1_docs_difference.png [ 138699 ]

Abhishek Jindal made changes - 04/May/21 6:19 AM

Attachment

invalid_requests (1).png [ 138707 ]

Abhishek Jindal made changes - 04/May/21 6:26 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Sujay Gad [ JIRAUSER25279 ]

Sujay Gad made changes - 04/May/21 9:19 PM

Assignee

Sujay Gad [ JIRAUSER25279 ]

Abhishek Jindal [ abhishek.jindal ]

Mihir Kamdar (Inactive) made changes - 04/May/21 9:37 PM

Labels

volume-test

affects-cc-testing volume-test

Abhishek Jindal made changes - 05/May/21 1:16 AM

Due Date

05/May/21

07/May/21

Abhishek Jindal made changes - 06/May/21 4:04 AM

Attachment

queries_prior_to_deployment.png [ 139237 ]

Abhishek Jindal made changes - 06/May/21 4:06 AM

Attachment

n1ql_dmls.png [ 139238 ]

Abhishek Jindal made changes - 06/May/21 4:53 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Sujay Gad [ JIRAUSER25279 ]

Sujay Gad made changes - 10/May/21 3:00 AM

Attachment		n1ql_test0.log [ 139612 ]
Attachment		n1ql0.log [ 139613 ]

Ritam Sharma made changes - 10/May/21 3:18 AM

Assignee

Sujay Gad [ JIRAUSER25279 ]

Abhishek Jindal [ abhishek.jindal ]

Sujay Gad made changes - 10/May/21 3:23 AM

Attachment		n1ql_test01.log [ 139616 ]
Attachment		n1ql01.log [ 139617 ]

Sujay Gad made changes - 10/May/21 3:31 AM

Attachment		n1ql_test02.log [ 139618 ]
Attachment		n1ql02.log [ 139619 ]

Sujay Gad made changes - 10/May/21 3:42 AM

Attachment

n1ql_test02.log [ 139618 ]

Sujay Gad made changes - 10/May/21 3:42 AM

Attachment

n1ql_test02.log [ 139620 ]

Abhishek Jindal made changes - 10/May/21 5:28 AM

Due Date

07/May/21

14/May/21

Abhishek Jindal made changes - 11/May/21 4:55 AM

Link

This issue relates to ~~MB-44784~~ [ ~~MB-44784~~ ]

Vinayaka Kamath (Inactive) made changes - 12/May/21 3:51 AM

Link

This issue is duplicated by ~~MB-46264~~ [ ~~MB-46264~~ ]

Abhishek Jindal made changes - 12/May/21 5:43 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Sujay Gad [ JIRAUSER25279 ]

Keshav Murthy made changes - 12/May/21 11:36 PM

Due Date

14/May/21

17/May/21

Abhishek Jindal made changes - 17/May/21 12:50 AM

Link

This issue is cloned by ~~MB-46326~~ [ ~~MB-46326~~ ]

Ritam Sharma made changes - 17/May/21 1:55 AM

Assignee

Sujay Gad [ JIRAUSER25279 ]

Abhishek Jindal [ abhishek.jindal ]

Ankit Prabhu made changes - 17/May/21 7:49 AM

Due Date

17/May/21

18/May/21

Wayne Siu made changes - 17/May/21 9:46 AM

Link

This issue backports to ~~MB-46326~~ [ ~~MB-46326~~ ]

Wayne Siu made changes - 17/May/21 9:46 AM

Link

This issue is cloned by ~~MB-46326~~ [ ~~MB-46326~~ ]

Abhishek Jindal made changes - 17/May/21 8:30 PM

Resolution		Fixed [ 1 ]
Status	Reopened [ 4 ]	Resolved [ 5 ]

Mihir Kamdar (Inactive) made changes - 17/May/21 10:05 PM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Ritam Sharma [ ritam.sharma ]

Ritam Sharma made changes - 17/May/21 10:30 PM

Assignee

Ritam Sharma [ ritam.sharma ]

Sujay Gad [ JIRAUSER25279 ]

Sujay Gad made changes - 20/May/21 12:52 AM

Resolution	Fixed [ 1 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Sujay Gad made changes - 20/May/21 12:55 AM

Assignee

Sujay Gad [ JIRAUSER25279 ]

Abhishek Jindal [ abhishek.jindal ]

Abhishek Jindal made changes - 20/May/21 1:51 AM

Due Date

18/May/21

21/May/21

Abhishek Jindal made changes - 21/May/21 4:00 AM

Resolution		Fixed [ 1 ]
Status	Reopened [ 4 ]	Resolved [ 5 ]

Abhishek Jindal made changes - 21/May/21 4:00 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Sujay Gad [ JIRAUSER25279 ]

Sujay Gad made changes - 23/May/21 9:27 PM

Status

Resolved [ 5 ]

Closed [ 6 ]

Abhishek Jindal made changes - 25/May/21 2:20 AM

Assignee	Sujay Gad [ JIRAUSER25279 ]	Abhishek Jindal [ abhishek.jindal ]
Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Abhishek Jindal made changes - 26/May/21 1:49 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Marco Greco [ marco.greco ]

Marco Greco made changes - 26/May/21 2:31 AM

Assignee

Marco Greco [ marco.greco ]

Abhishek Jindal [ abhishek.jindal ]

Abhishek Jindal made changes - 26/May/21 3:10 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Marco Greco [ marco.greco ]

Marco Greco made changes - 26/May/21 3:38 AM

Assignee

Marco Greco [ marco.greco ]

Abhishek Jindal [ abhishek.jindal ]

Jeelan Poola made changes - 26/May/21 3:57 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Marco Greco [ marco.greco ]

Marco Greco made changes - 26/May/21 4:10 AM

Assignee

Marco Greco [ marco.greco ]

Abhishek Jindal [ abhishek.jindal ]

Jeelan Poola made changes - 26/May/21 5:01 AM

Assignee

Abhishek Jindal [ abhishek.jindal ]

Michael Nitschinger [ daschl ]

Michael Nitschinger made changes - 26/May/21 5:43 AM

Assignee

Michael Nitschinger [ daschl ]

Jeelan Poola [ jeelan.poola ]

Lynn Straus made changes - 26/May/21 8:10 AM

Due Date

21/May/21

28/May/21

Lynn Straus made changes - 26/May/21 8:29 AM

Link

This issue blocks MB-44894 [ MB-44894 ]

Lynn Straus made changes - 26/May/21 8:30 AM

Labels

affects-cc-testing volume-test

affects-cc-testing approved-for-7.0.0 volume-test

Jeelan Poola made changes - 26/May/21 8:39 AM

Assignee

Jeelan Poola [ jeelan.poola ]

Marco Greco [ marco.greco ]

Marco Greco made changes - 26/May/21 9:01 AM

Assignee

Marco Greco [ marco.greco ]

Abhishek Jindal [ abhishek.jindal ]

Jeelan Poola made changes - 26/May/21 9:40 AM

Link

This issue depends on ~~CCBC-1411~~ [ ~~CCBC-1411~~ ]

Jeelan Poola made changes - 30/May/21 11:25 PM

Resolution		Fixed [ 1 ]
Status	Reopened [ 4 ]	Resolved [ 5 ]

Sujay Gad made changes - 31/May/21 4:54 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

Lynn Straus made changes - 17/Jun/21 3:06 PM

Fix Version/s

7.0.0 [ 17233 ]

Lynn Straus made changes - 17/Jun/21 3:10 PM

Fix Version/s

Cheshire-Cat [ 15915 ]

Matt Ingenthron made changes - 13/Jul/21 10:04 AM

Link

This issue relates to ~~MB-47366~~ [ ~~MB-47366~~ ]

Ray Cardillo made changes - 17/Jan/22 8:07 AM

Link

This issue relates to CBD-4565 [ CBD-4565 ]

People

Assignee:: Abhishek Jindal

Reporter:: Vikas Chaudhary

Votes:: 0 Vote for this issue

Watchers:: 15 Start watching this issue

Dates

Due:: 28/May/21

Created:: 27/Apr/21 10:42 PM

Updated:: 17/Jan/22 8:07 AM

Resolved:: 30/May/21 11:25 PM

Gerrit Reviews

There are no open Gerrit changes

Show There are 7 closed Gerrit changes

Hide There are 7 closed Gerrit changes

MB-45967 : Retry on DML Failures: Gerrit Review:

MB-45967 : Address mutations getting dropped due to racing worker queues: Gerrit Review:

MB-46326 : Address mutations getting dropped due to racing worker queues: Gerrit Review:

MB-45967: Invalidate credentials cache on error from lcb: Gerrit Review:

MB-45967 : Ensure creds cache entries are no more than 10 seconds old: Gerrit Review:

MB-45967 : Disambiguate between retriable and non-retriable DML errors: Gerrit Review:

MB-45967:: Gerrit Review:

Couchbase Server

Volume: Data missing for N1QL handlers

Details

Description

Attachments

Attachments

Issue Links

Gerrit Reviews

Activity

People

Dates

Gerrit Reviews

PagerDuty