Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-45967

Volume: Data missing for N1QL handlers

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • 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

        1. invalid_requests (1).png
          invalid_requests (1).png
          268 kB
        2. n1ql_dmls.png
          n1ql_dmls.png
          286 kB
        3. n1ql_op_scope1_docs_difference.png
          n1ql_op_scope1_docs_difference.png
          386 kB
        4. n1ql_test0.log
          26.99 MB
        5. n1ql_test01.log
          29.66 MB
        6. n1ql_test02.log
          37.63 MB
        7. n1ql0.log
          18.79 MB
        8. n1ql01.log
          19.17 MB
        9. n1ql02.log
          23.03 MB
        10. queries_prior_to_deployment.png
          queries_prior_to_deployment.png
          269 kB

        Issue Links

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

          Activity

            vikas.chaudhary Vikas Chaudhary created issue -
            vikas.chaudhary Vikas Chaudhary made changes -
            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 Abhishek Jindal made changes -
            Assignee Jeelan Poola [ jeelan.poola ] Abhishek Jindal [ abhishek.jindal ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Vikas Chaudhary [ vikas.chaudhary ]
            vikas.chaudhary Vikas Chaudhary made changes -
            Assignee Vikas Chaudhary [ vikas.chaudhary ] Abhishek Jindal [ abhishek.jindal ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Marco Greco [ marco.greco ]
            abhishek.jindal Abhishek Jindal made changes -
            Component/s query [ 10718 ]
            marco.greco Marco Greco made changes -
            Assignee Marco Greco [ marco.greco ] Abhishek Jindal [ abhishek.jindal ]
            kamini.jagtiani Kamini Jagtiani (Inactive) made changes -
            Component/s query [ 10718 ]
            abhishek.jindal Abhishek Jindal made changes -
            Due Date 05/May/21
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Vikas Chaudhary [ vikas.chaudhary ]
            abhishek.jindal Abhishek Jindal made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            chanabasappa.ghali Chanabasappa Ghali made changes -
            Assignee Vikas Chaudhary [ vikas.chaudhary ] Sujay Gad [ JIRAUSER25279 ]
            sujay.gad Sujay Gad made changes -
            Resolution Fixed [ 1 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            sujay.gad Sujay Gad made changes -
            Assignee Sujay Gad [ JIRAUSER25279 ] Abhishek Jindal [ abhishek.jindal ]
            abhishek.jindal Abhishek Jindal made changes -
            Attachment n1ql_op_scope1_docs_difference.png [ 138699 ]
            abhishek.jindal Abhishek Jindal made changes -
            Attachment invalid_requests (1).png [ 138707 ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Sujay Gad [ JIRAUSER25279 ]
            sujay.gad Sujay Gad made changes -
            Assignee Sujay Gad [ JIRAUSER25279 ] Abhishek Jindal [ abhishek.jindal ]
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Labels volume-test affects-cc-testing volume-test
            abhishek.jindal Abhishek Jindal made changes -
            Due Date 05/May/21 07/May/21
            abhishek.jindal Abhishek Jindal made changes -
            Attachment queries_prior_to_deployment.png [ 139237 ]
            abhishek.jindal Abhishek Jindal made changes -
            Attachment n1ql_dmls.png [ 139238 ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Sujay Gad [ JIRAUSER25279 ]
            sujay.gad Sujay Gad made changes -
            Attachment n1ql_test0.log [ 139612 ]
            Attachment n1ql0.log [ 139613 ]
            ritam.sharma Ritam Sharma made changes -
            Assignee Sujay Gad [ JIRAUSER25279 ] Abhishek Jindal [ abhishek.jindal ]
            sujay.gad Sujay Gad made changes -
            Attachment n1ql_test01.log [ 139616 ]
            Attachment n1ql01.log [ 139617 ]
            sujay.gad Sujay Gad made changes -
            Attachment n1ql_test02.log [ 139618 ]
            Attachment n1ql02.log [ 139619 ]
            sujay.gad Sujay Gad made changes -
            Attachment n1ql_test02.log [ 139618 ]
            sujay.gad Sujay Gad made changes -
            Attachment n1ql_test02.log [ 139620 ]
            abhishek.jindal Abhishek Jindal made changes -
            Due Date 07/May/21 14/May/21
            abhishek.jindal Abhishek Jindal made changes -
            Link This issue relates to MB-44784 [ MB-44784 ]
            vinayaka.kamath Vinayaka Kamath (Inactive) made changes -
            Link This issue is duplicated by MB-46264 [ MB-46264 ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Sujay Gad [ JIRAUSER25279 ]
            keshav Keshav Murthy made changes -
            Due Date 14/May/21 17/May/21
            abhishek.jindal Abhishek Jindal made changes -
            Link This issue is cloned by MB-46326 [ MB-46326 ]
            ritam.sharma Ritam Sharma made changes -
            Assignee Sujay Gad [ JIRAUSER25279 ] Abhishek Jindal [ abhishek.jindal ]
            ankit.prabhu Ankit Prabhu made changes -
            Due Date 17/May/21 18/May/21
            wayne Wayne Siu made changes -
            Link This issue backports to MB-46326 [ MB-46326 ]
            wayne Wayne Siu made changes -
            Link This issue is cloned by MB-46326 [ MB-46326 ]
            abhishek.jindal Abhishek Jindal made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Ritam Sharma [ ritam.sharma ]
            ritam.sharma Ritam Sharma made changes -
            Assignee Ritam Sharma [ ritam.sharma ] Sujay Gad [ JIRAUSER25279 ]
            sujay.gad Sujay Gad made changes -
            Resolution Fixed [ 1 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            sujay.gad Sujay Gad made changes -
            Assignee Sujay Gad [ JIRAUSER25279 ] Abhishek Jindal [ abhishek.jindal ]
            abhishek.jindal Abhishek Jindal made changes -
            Due Date 18/May/21 21/May/21
            abhishek.jindal Abhishek Jindal made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Sujay Gad [ JIRAUSER25279 ]
            sujay.gad Sujay Gad made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Sujay Gad [ JIRAUSER25279 ] Abhishek Jindal [ abhishek.jindal ]
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Marco Greco [ marco.greco ]
            marco.greco Marco Greco made changes -
            Assignee Marco Greco [ marco.greco ] Abhishek Jindal [ abhishek.jindal ]
            abhishek.jindal Abhishek Jindal made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Marco Greco [ marco.greco ]
            marco.greco Marco Greco made changes -
            Assignee Marco Greco [ marco.greco ] Abhishek Jindal [ abhishek.jindal ]
            jeelan.poola Jeelan Poola made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Marco Greco [ marco.greco ]
            marco.greco Marco Greco made changes -
            Assignee Marco Greco [ marco.greco ] Abhishek Jindal [ abhishek.jindal ]
            jeelan.poola Jeelan Poola made changes -
            Assignee Abhishek Jindal [ abhishek.jindal ] Michael Nitschinger [ daschl ]
            daschl Michael Nitschinger made changes -
            Assignee Michael Nitschinger [ daschl ] Jeelan Poola [ jeelan.poola ]
            lynn.straus Lynn Straus made changes -
            Due Date 21/May/21 28/May/21
            lynn.straus Lynn Straus made changes -
            Link This issue blocks MB-44894 [ MB-44894 ]
            lynn.straus Lynn Straus made changes -
            Labels affects-cc-testing volume-test affects-cc-testing approved-for-7.0.0 volume-test
            jeelan.poola Jeelan Poola made changes -
            Assignee Jeelan Poola [ jeelan.poola ] Marco Greco [ marco.greco ]
            marco.greco Marco Greco made changes -
            Assignee Marco Greco [ marco.greco ] Abhishek Jindal [ abhishek.jindal ]
            jeelan.poola Jeelan Poola made changes -
            Link This issue depends on CCBC-1411 [ CCBC-1411 ]
            jeelan.poola Jeelan Poola made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            sujay.gad Sujay Gad made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            lynn.straus Lynn Straus made changes -
            Fix Version/s 7.0.0 [ 17233 ]
            lynn.straus Lynn Straus made changes -
            Fix Version/s Cheshire-Cat [ 15915 ]
            ingenthr Matt Ingenthron made changes -
            Link This issue relates to MB-47366 [ MB-47366 ]
            ray.cardillo Ray Cardillo made changes -
            Link This issue relates to CBD-4565 [ CBD-4565 ]

            People

              abhishek.jindal Abhishek Jindal
              vikas.chaudhary Vikas Chaudhary
              Votes:
              0 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty