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

Getting Partial result set for SEARCH() queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Critical
    • 7.2.1
    • 7.2.1
    • fts
    • None

    Description

      Test: 

      test_fts_node_failover_partial_results,services_init=kv:index:n1ql-kv:index:fts-n1ql:fts-fts,reset_services=True,nodes_init=4,GROUP=P2 

      Last good build : 7.2.1-5928
      Test Steps:

      • Create a 4 node cluster with following config

      ['fts', 'index', 'kv'], ['index', 'kv', 'n1ql'], ['fts'], ['fts', 'n1ql'

      • Load beer sample
      • Create default fts index on beer sample
        • Run the following SEARCH() query - 

          2023-09-04 04:58:13 | INFO | MainProcess | test_thread | [tuq.run_cbq_query] RUN QUERY select meta().id from `beer-sample` where search(`beer-sample`, {"query":{"field":"state", "match":"California"}, "size":10000})

      • Failover one of the nodes
        1. 2023-09-04 04:58:13 | INFO | MainProcess | Cluster_Thread | [task._failover_nodes] Failing over 172.23.123.38:8091 with graceful=False 2023-09-04 04:58:14 | INFO | MainProcess | Cluster_Thread | [rest_client.fail_over] fail_over node ns_1@172.23.123.38 successful 

      • Run query agaian and expect the query to fail with : " pindex not available " since Partial result set is not allowed for SEARCH() queries, we however don't receive any error message.
        1. 2023-09-04 04:58:14 | INFO | MainProcess | test_thread | [tuq.run_cbq_query] RUN QUERY select meta().id from `beer-sample` where search(`beer-sample`, {"query":{"field":"state", "match":"California"}, "size":10000}) 
          2023-09-04 04:58:14 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=select+meta%28%29.id+from+%60beer-sample%60+where+search%28%60beer-sample%60%2C+%7B%22query%22%3A%7B%22field%22%3A%22state%22%2C+%22match%22%3A%22California%22%7D%2C+%22size%22%3A10000%7D%29&scan_consistency=NOT_BOUNDED 
          2023-09-04 04:58:14 | INFO | MainProcess | test_thread | [tuq.run_cbq_query] TOTAL ELAPSED TIME: 6.498656ms 

      Attachments

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

        Activity

          People

            sarthak.dua Sarthak Dua
            sarthak.dua Sarthak Dua
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty