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

[N1QL] array-indexing query hangs

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.1.1, 5.5.0
    • 5.1.1, 5.5.0
    • query
    • None
    • 5.5.0-2556
    • Untriaged
    • Unknown

    Description

       

      basically these indexes are present:

      CREATE INDEX nested_idx ON default( DISTINCT ARRAY ( DISTINCT array j for j in i end) FOR i in tasks END) USING GSI

      CREATE INDEX idxtasks ON default( DISTINCT ARRAY x FOR x in tasks END) USING GSI

       

      This is the query that was run:

      explain select name from default WHERE ANY i IN default.tasks SATISFIES  (ANY j IN i SATISFIES j='Search' end) END AND (ANY x IN default.tasks SATISFIES x = 'Sales' END) AND  NOT (department = 'Manager') order BY name limit 10

       

      Logs and backup will be attatched. 

       

      Service 'query' exited with status 137. Restarting. Messages: 2018-04-27T11:17:12.600-07:00 [INFO] Trying with http://127.0.0.1:8091/pools/default/bucketsStreaming/default 2018-04-27T11:17:12.606-07:00 [INFO] Got new configuration for bucket default 2018-04-27T11:17:12.617-07:00 [Info] Refreshing indexer list due to cluster changes or auto-refresh. 2018-04-27T11:17:12.617-07:00 [Info] Refreshed Indexer List: [127.0.0.1:9100] 2018-04-27T11:17:12.618-07:00 [Info] switched currmeta from 3 -> 3 force true 2018-04-27T11:17:12.637-07:00 [INFO] Using plain authentication for user <ud>@cbq-engine</ud> 2018-04-27T11:17:12.637-07:00 [Info] Refreshing indexer list due to cluster changes or auto-refresh. 2018-04-27T11:17:12.637-07:00 [Info] Refreshed Indexer List: [127.0.0.1:9100] 2018-04-27T11:17:12.638-07:00 [Info] switched currmeta from 3 -> 3 force true 2018-04-27T11:17:13.095-07:00 [Info] Rollback time has changed for index inst 7982652367221162837. New rollback time 1524853002956746521 [goport(/opt/couchbase/bin/cbq-engine)] 2018/04/27 11:17:49 child process exited with status 137

       

      Service 'indexer' exited with status 137. Restarting. Messages: 2018-04-27T11:17:43.014-07:00 [Info] ServiceMgr::GetCurrentTopology [] 2018-04-27T11:17:43.014-07:00 [Info] ServiceMgr::GetCurrentTopology returns &{[0 0 0 0 0 0 0 1] [2c8b158783de6e72436366a2a425e961] true []} 2018-04-27T11:17:43.014-07:00 [Info] ServiceMgr::GetTaskList [] 2018-04-27T11:17:43.014-07:00 [Info] ServiceMgr::GetTaskList returns &{[0 0 0 0 0 0 0 1] []} 2018-04-27T11:17:43.015-07:00 [Info] ServiceMgr::GetTaskList [0 0 0 0 0 0 0 1] 2018-04-27T11:17:43.015-07:00 [Info] ServiceMgr::GetCurrentTopology [0 0 0 0 0 0 0 1] 2018-04-27T11:17:44.463-07:00 [Info] Indexer::ReadMemstats Time Taken 228.665µs 2018-04-27T11:17:49.704-07:00 [Info] [Queryport ":9101"] connection 127.0.0.1:39664 closed 2018-04-27T11:17:49.704-07:00 [Error] PeerPipe.doRecieve() : ecounter error when received mesasage from Peer 127.0.0.1:33026. Error = EOF. Kill Pipe. 2018-04-27T11:17:49.704-07:00 [Info] messageListener.start(): message channel closed. Remove peer 91:30:c:83:75:3d:17:ea as follower. [goport(/opt/couchbase/bin/indexer)] 2018/04/27 11:17:49 child process exited with status 137

       

      You can run this test to observe this behavior as well

       
      ./testrunner -i /tmp/testexec.5871.ini -p doc-per-day=6,primary_indx_type=GSI,array_indexing=True -t tuqquery.tuq_2i_index.QueriesIndexTests.test_simple_nested_index,index_type=GSI,array_indexing=True

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              ajay.bhullar Ajay Bhullar
              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