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

Merge and update queries failing with Error "DML Error, possible causes include CAS mismatch or concurrent modificationFailed to perform update"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Test Blocker
    • 5.0.0
    • 5.0.0
    • query
    • 5.0.0-1986
    • Untriaged
    • Yes

    Description

      This is a regression from 5.0.0-1982 build.
       
      Test which fails:
      ./testrunner -i /tmp/n1ql_set4.ini get-cbcollect-info=False,gsi_type=forestdb,primary_indx_type=GSI,doc-per-day=6,standard_buckets=1,nodes_init=3,get-cbcollect-info=True -t tuqquery.tuq_dml.DMLQueryTests.test_merge_update_match_set,skip_load=True
       
      Error reported:
      ERROR: test_merge_update_match_set (tuqquery.tuq_dml.DMLQueryTests)
      ----------------------------------------------------------------------
      Traceback (most recent call last):
        File "pytests/tuqquery/tuq_dml.py", line 917, in test_merge_update_match_set
          actual_result = self.run_cbq_query()
        File "pytests/tuqquery/tuq.py", line 4057, in run_cbq_query
          raise CBQError(result, server.ip)
      CBQError: CBQError: host 172.23.121.127: ERROR:{u'status': u'errors', u'errors': [{u'msg': u'DML Error, possible causes include CAS mismatch or concurrent modificationFailed to perform update - cause: Recovered in f%!(EXTRA *runtime.TypeAssertionError=interface conversion: interface is int64, not uint32)', u'code': 12009}], u'results': [], u'metrics': {u'elapsedTime': u'110.694178ms', u'executionTime': u'110.646506ms', u'resultSize': 0, u'resultCount': 0, u'errorCount': 1}, u'requestID': u'9651f2df-fae5-4fc9-8d53-1ef65abf2dea', u'signature': None}
       
      ----------------------------------------------------------------------
       
      Queries executed by the test:
      INSERT into standard_bucket0 (key , value) VALUES ("test", {"name": "new1"})
       
      INSERT into default (key , value) VALUES ("new1", {"name": "new2"})
       
      MERGE INTO default b1 USING default b2 on key name when matched then update set b1.name="edit"
       
      Failure is seen when merge query is executed.
       
      This failure is also seen in the Build Sanity in 5.0.0. The failure is very consistent across all platforms since build 1986. 
      Attaching logs.
       
      Recent Changelog : http://172.23.123.43:8000/getchangelog?rel=5.0.0&fromb=1983&tob=1987 
       
      Update queries are also failing with same error:
       
      [2017-02-14 21:53:09,647] - [rest_client:2842] INFO - query params : scan_consistency=REQUEST_PLUS&creds=%5B%5D&statement=update+default+set+name%3D%22new_name%22+where+join_day%3D1+returning+name
      ERROR
       
      ======================================================================
      ERROR: test_update_where (tuqquery.tuq_dml.DMLQueryTests)
      ----------------------------------------------------------------------
      Traceback (most recent call last):
        File "pytests/tuqquery/tuq_dml.py", line 1066, in test_update_where
          actual_result = self.run_cbq_query()
        File "pytests/tuqquery/tuq.py", line 4057, in run_cbq_query
          raise CBQError(result, server.ip)
      CBQError: CBQError: host 172.23.121.127: ERROR:{u'status': u'errors', u'errors': [{u'msg': u'DML Error, possible causes include CAS mismatch or concurrent modificationFailed to perform update - cause: Recovered in f%!(EXTRA *runtime.TypeAssertionError=interface conversion: interface is int64, not uint32)', u'code': 12009}], u'results': [{u'name': u'new_name'}, {u'name': u'new_name'}, {u'name': u'new_name'}, {u'name': u'new_name'}, {u'name': u'new_name'}, {u'name': u'new_name'}], u'metrics': {u'elapsedTime': u'195.676434ms', u'executionTime': u'195.612449ms', u'resultSize': 252, u'resultCount': 6, u'errorCount': 1}, u'requestID': u'cc431814-a664-4603-82db-7b8427629930', u'signature': {u'name': u'json'}}
       
       
      
      

      Attachments

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

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty