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

Error 12008 when query collection

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Duplicate
    • Cheshire-Cat
    • 7.0.0
    • query
    • Untriaged
    • 1
    • Unknown

    Description

      Getting the following error when query collection.

      Repro:

      1. Build 3455
      2. Load travel-sample
      3. Create travel-sample-v2
      4. Run these  N1QL statements to create collections and migrate data into the collections

      CREATE COLLECTION `travel-sample-v2`._default.route;
      CREATE COLLECTION `travel-sample-v2`._default.airline;
      CREATE COLLECTION `travel-sample-v2`._default.airport;

      UPSERT INTO `travel-sample-v2`._default.airline (KEY k, VALUE val)
      SELECT META().id k, t val FROM `travel-sample` t WHERE t.type='airline' ;
      UPSERT INTO `travel-sample-v2`._default.airport (KEY k, VALUE val)
      SELECT META().id k, t val FROM `travel-sample` t WHERE t.type='airport' ;
      UPSERT INTO `travel-sample-v2`._default.route (KEY k, VALUE val)
      SELECT META().id k, t val FROM `travel-sample` t WHERE t.type='route' ;

       

      CREATE INDEX `def_airport_name` ON `travel-sample-v2`._default.airport(name);
      CREATE INDEX `def_airport_city` ON `travel-sample-v2`._default.airport(`city`);
      CREATE INDEX `def_airport_faa` ON `travel-sample-v2`._default.airport(`faa`);
      CREATE INDEX `def_route_src_dst_day` ON `travel-sample-v2`._default.route(`sourceairport`,
      `destinationairport`,(distinct (array (`v`.`day`) for `v` in `schedule` end)));
      CREATE INDEX `def_route_schedule_utc` ON `travel-sample-v2`._default.route(array (`s`.`utc`)
      for `s` in `schedule` end);
      CREATE INDEX `def_route_sourceairport` ON `travel-sample-v2`._default.route(`sourceairport`);
      CREATE INDEX adv_iata ON `default`:`travel-sample-v2`.`_default`.`airline`(`iata`);

      SELECT airline.name, airport.airportname, COUNT(1)
      FROM airport
      INNER JOIN route ON airport.faa = route.sourceairport
      INNER JOIN airline ON route.airline = airline.iata
      WHERE airport.city = "San Jose"
      AND airport.country = "United States"
      AND ANY x in route.schedule SATISFIES x.day =0 END
      GROUP BY airline.name, airport.airportname

       

      Note that: the query_context was set to `travel-sample-v2`._default in the UI

       

       

       

      Attachments

        Issue Links

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

          Activity

            bingjie.miao Bingjie Miao added a comment -

            Binh Le Just tried it on build 7.0.0-3455 on vm (CentOS 7) and the query works for me.

            bingjie.miao Bingjie Miao added a comment - Binh Le Just tried it on build 7.0.0-3455 on vm (CentOS 7) and the query works for me.
            bingjie.miao Bingjie Miao added a comment -

            Repeated execution of the query always succeed for me. Cannot see the error at all. Binh Le indicated the error happened for him twice and is not reproducible on demand. He will try to narrow down the sequence of events that may be important for seeing this error. For me, I just installed the build (7.0.0-3455) and followed the reproduction steps.

            bingjie.miao Bingjie Miao added a comment - Repeated execution of the query always succeed for me. Cannot see the error at all. Binh Le indicated the error happened for him twice and is not reproducible on demand. He will try to narrow down the sequence of events that may be important for seeing this error. For me, I just installed the build (7.0.0-3455) and followed the reproduction steps.

            I ran into this issue once today with 7.0.0-3570. Tried again on a fresh setup, it wasnt reproducible. Here are the logs from my cluster :
            https://cb-jira.s3.us-east-2.amazonaws.com/logs/MB-42384/collectinfo-2020-10-29T223737-ns_1%40172.23.107.87.zip
            https://cb-jira.s3.us-east-2.amazonaws.com/logs/MB-42384/collectinfo-2020-10-29T223737-ns_1%40172.23.121.60.zip

            Screenshot also attached.

            mihir.kamdar Mihir Kamdar (Inactive) added a comment - I ran into this issue once today with 7.0.0-3570. Tried again on a fresh setup, it wasnt reproducible. Here are the logs from my cluster : https://cb-jira.s3.us-east-2.amazonaws.com/logs/MB-42384/collectinfo-2020-10-29T223737-ns_1%40172.23.107.87.zip https://cb-jira.s3.us-east-2.amazonaws.com/logs/MB-42384/collectinfo-2020-10-29T223737-ns_1%40172.23.121.60.zip Screenshot also attached.
            marco.greco Marco Greco added a comment -

            I have done a bit of investigation on MB-41535, and have come to the conclusion that these two might come through different paths.
            In MB-41535 the 12008 is coming from a pool refresh that is caused by querying non existing buckets.
            Here I believe the pool refresh is coming from the UI silently querying system:indexes and system:indexes causing a pool refresh, which then causes the `travel-sample` bucket to be reloaded and connections being switched across buckets.
            We will improve on this as part of MB-39804 / MB-39682.

            marco.greco Marco Greco added a comment - I have done a bit of investigation on MB-41535 , and have come to the conclusion that these two might come through different paths. In MB-41535 the 12008 is coming from a pool refresh that is caused by querying non existing buckets. Here I believe the pool refresh is coming from the UI silently querying system:indexes and system:indexes causing a pool refresh, which then causes the `travel-sample` bucket to be reloaded and connections being switched across buckets. We will improve on this as part of MB-39804 / MB-39682 .

            Mass closing defects in Resolved state with resolution != Fixed,Done

            mihir.kamdar Mihir Kamdar (Inactive) added a comment - Mass closing defects in Resolved state with resolution != Fixed,Done

            People

              marco.greco Marco Greco
              binh.le Binh Le
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty