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

Duplicate rows returned in View Query result after view compaction

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 3.0
    • 3.0
    • view-engine
    • Security Level: Public
    • 3.0.0-1205-rel
    • Triaged
    • Ubuntu 64-bit
    • Yes

    Description

      Jenkins Ref Link:
      http://qa.sc.couchbase.com/job/centos_x64--29_01--view_create_all-P1/150/consoleFull

      Test to Reproduce:
      ./testrunner -i test.ini get-cbcollect-info=True,get-logs=True, -t view.createdeleteview.CreateDeleteViewTests.ddoc_ops_during_compaction,ddoc_ops=update,test_with_view=True,num_ddocs=4,num_views_per_ddoc=2,items=20000,fragmentation_value=40

      Note: This issue is reproducible once in 3-4 times.

      Steps to Reproduce:
      1. Create bucket
      2. Disable Auto Compaction
      3. Load 20000 items
      4. Create Views
      5. Generate load until fragmentation value reached
      6. Trigger View Compaction
      7. Run View Queries

      Duplicate Rows - Please refer attached "query.txt" for complete query result
      http://10.3.5.92:8092/default/_design/dev_ddoc1/_view/views0?stale=false&connection_timeout=60000&full_set=true

      2

      {"id":"test_docs-18160","key":0,"value":"james"}

      ,
      2

      {"id":"test_docs-18256","key":1,"value":"sharon"}

      ,
      2

      {"id":"test_docs-18524","key":4,"value":"james"}

      ,
      2

      {"id":"test_docs-18612","key":2,"value":"james"}

      ,
      2

      {"id":"test_docs-18698","key":3,"value":"sharon"}

      ,
      2

      {"id":"test_docs-18708","key":3,"value":"sharon"}

      ,
      2

      {"id":"test_docs-18782","key":2,"value":"james"}

      ,
      2

      {"id":"test_docs-19864","key":4,"value":"james"}

      ,

      [ns_server:warn,2014-09-01T12:34:18.553,ns_1@127.0.0.1:<0.4829.0>:compaction_new_daemon:do_chain_compactors:612]Compactor for view `default/_design/dev_ddoc3/main` (pid [

      {type,view},
      {important,true},
      {name, <<"default/_design/dev_ddoc3/main">>},
      {fa,
      {#Fun<compaction_new_daemon.23.43740339>,
      [<<"default">>,
      <<"_design/dev_ddoc3">>,
      main,
      {config,
      {100, 18446744073709551616},
      {100, 18446744073709551616},
      undefined,false,
      false,
      {daemon_config,
      30,131072}},
      true,
      {[{type,view}

      ,

      {name, <<"_design/dev_ddoc3">>}

      ]}]}}]) terminated unexpectedly: {normal,
      {gen_server,
      call,
      [<0.4373.0>,

      {start_compact, #Fun<couch_set_view_compactor.0.132742762>}

      ,
      infinity]}}
      [user:error,2014-09-01T12:34:18.554,ns_1@127.0.0.1:compaction_new_daemon<0.467.0>:compaction_new_daemon:handle_info:408]User-triggered compaction of view `default/_design/dev_ddoc3` failed: {normal,
      {gen_server,
      call,
      [<0.4373.0>,

      {start_compact, #Fun<couch_set_view_compactor.0.132742762>}

      ,
      infinity]}}. See logs for detailed reason.
      [error_logger:error,2014-09-01T12:34:18.555,ns_1@127.0.0.1:error_logger<0.6.0>:ale_error_logger_handler:do_log:203]
      =========================CRASH REPORT=========================
      crasher:
      initial call: compaction_new_daemon:spawn_view_index_compactor/6-fun-0/0
      pid: <0.4830.0>
      registered_name: []
      exception exit: {normal,
      {gen_server,call,
      [<0.4373.0>,

      {start_compact, #Fun<couch_set_view_compactor.0.132742762>}

      ,
      infinity]}}
      in function gen_server:call/3 (gen_server.erl, line 188)
      in call from compaction_new_daemon:start_view_index_compactor/4 (src/compaction_new_daemon.erl, line 939)
      in call from compaction_new_daemon:do_spawn_view_index_compactor/5 (src/compaction_new_daemon.erl, line 909)
      in call from compaction_new_daemon:'spawn_view_index_compactor/6-fun-0'/7 (src/compaction_new_daemon.erl, line 902)
      ancestors: [<0.4829.0>,compaction_new_daemon,ns_server_sup,
      ns_server_cluster_sup,<0.60.0>]
      messages: []
      links: [<0.4829.0>]
      dictionary: []
      trap_exit: true
      status: running
      heap_size: 2586
      stack_size: 27
      reductions: 2860
      neighbours:

      Uploading Logs.

      Live Node:
      10.3.5.92

      Attachments

        1. query.txt
          976 kB
        2. test.txt
          28 kB

        Issue Links

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

          Activity

            People

              Meenakshi Meenakshi Goel
              Meenakshi Meenakshi Goel
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty