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

[IPV6] no index available when switching to ipv6 or ipv6only IP family

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 7.0.2
    • 7.1.0
    • secondary-index
    • 7.0.2-6558
    • Untriaged
    • 1
    • Unknown

    Description

      To repro (require node with ipv4/ipv6 support)

      1. setup cluster with kv,index and n1ql (use hostname), use default ipv4 ip family
      2. disable autofailover
      3. load travel-sample
      4. run simple query: select * from `travel-sample` limit 10;
      5. switch to ipv6 family: /opt/couchbase/bin/couchbase-cli ip-family -c localhost -u Administrator -p password --set --ipv6
      1. run query again

      cbq> select * from `travel-sample` limit 10;
      {
          "requestID": "a98244a2-b0e7-4865-95d4-4371a8c50648",
          "errors": [
              {
                  "code": 4000,
                  "msg": "No index available on keyspace `default`:`travel-sample` that matches your query. Use CREATE PRIMARY INDEX ON `default`:`travel-sample` to create a primary index, or check that your expected index is online."
              }
          ],
          "status": "fatal", 

      Note indexer process:

      [root@cluster logs]# /opt/couchbase/bin/couchbase-cli ip-family -c localhost -u Administrator -p password --set --ipv4
      Switched IP family for node: http://cluster.couchbase.com:8091
      SUCCESS: Switched IP family of the cluster
       
      [root@cluster logs]# lsof -i -P -n  | grep LISTEN | grep couchbase| grep -i index
      indexer   10900 couchbase   15u  IPv4 185082073      0t0  TCP *:9101 (LISTEN)
      indexer   10900 couchbase   22u  IPv4 185078777      0t0  TCP *:9100 (LISTEN)
      indexer   10900 couchbase   24u  IPv4 185078780      0t0  TCP *:9102 (LISTEN)
      indexer   10900 couchbase   25u  IPv4 185078781      0t0  TCP *:19102 (LISTEN)
      indexer   10900 couchbase  124u  IPv4 185082939      0t0  TCP *:9105 (LISTEN)
       
      [root@cluster logs]# /opt/couchbase/bin/couchbase-cli ip-family -c localhost -u Administrator -p password --set --ipv6
      Switched IP family for node: http://cluster.couchbase.com:8091
      SUCCESS: Switched IP family of the cluster
       
      [root@cluster logs]# lsof -i -P -n  | grep LISTEN | grep couchbase| grep -i index
      indexer   11354 couchbase   15u  IPv6 185084236      0t0  TCP *:9101 (LISTEN)
      indexer   11354 couchbase   22u  IPv6 185084263      0t0  TCP *:9100 (LISTEN)
      indexer   11354 couchbase   24u  IPv6 185084935      0t0  TCP *:9102 (LISTEN)
      indexer   11354 couchbase   25u  IPv6 185084936      0t0  TCP *:19102 (LISTEN) 

      Attachments

        Issue Links

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

          Activity

            Verified on 7.1.0-2210

            Set ipv6:

            #  /opt/couchbase/bin/couchbase-cli ip-family -c localhost -u Administrator -p password --set --ipv6
            Switched IP family for node: http://node1.couchbase.com:8091
            Switched IP family for node: http://node3.couchbase.com:8091
            SUCCESS: Switched IP family of the cluster
             
            #  /opt/couchbase/bin/couchbase-cli ip-family -c localhost -u Administrator -p password --get --ipv6
            Cluster using ipv6 

            Run query:

            cbq> select * from `travel-sample` limit 10;
            {
                "requestID": "414f7431-1774-42e6-a54b-b0262a63d0d3",
                "signature": {
                    "*": "*"
                },
                "results": [
                {
                    "travel-sample": {
                        "callsign": "MILE-AIR",
                        "country": "United States",
                        "iata": "Q5",
                        "icao": "MLA",
                        "id": 10,
                        "name": "40-Mile Air",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "TXW",
                        "country": "United States",
                        "iata": "TQ",
                        "icao": "TXW",
                        "id": 10123,
                        "name": "Texas Wings",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "atifly",
                        "country": "United States",
                        "iata": "A1",
                        "icao": "A1F",
                        "id": 10226,
                        "name": "Atifly",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": null,
                        "country": "United Kingdom",
                        "iata": null,
                        "icao": "JRB",
                        "id": 10642,
                        "name": "Jc royal.britannica",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "LOCAIR",
                        "country": "United States",
                        "iata": "ZQ",
                        "icao": "LOC",
                        "id": 10748,
                        "name": "Locair",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "SASQUATCH",
                        "country": "United States",
                        "iata": "K5",
                        "icao": "SQH",
                        "id": 10765,
                        "name": "SeaPort Airlines",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "ACE AIR",
                        "country": "United States",
                        "iata": "KO",
                        "icao": "AER",
                        "id": 109,
                        "name": "Alaska Central Express",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "FLYSTAR",
                        "country": "United Kingdom",
                        "iata": "5W",
                        "icao": "AEU",
                        "id": 112,
                        "name": "Astraeus",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "REUNION",
                        "country": "France",
                        "iata": "UU",
                        "icao": "REU",
                        "id": 1191,
                        "name": "Air Austral",
                        "type": "airline"
                    }
                },
                {
                    "travel-sample": {
                        "callsign": "AIRLINAIR",
                        "country": "France",
                        "iata": "A5",
                        "icao": "RLA",
                        "id": 1203,
                        "name": "Airlinair",
                        "type": "airline"
                    }
                }
                ],
                "status": "success",
                "metrics": {
                    "elapsedTime": "186.666862ms",
                    "executionTime": "186.366342ms",
                    "resultCount": 10,
                    "resultSize": 2602,
                    "serviceLoad": 6
                }
            } 

            Check indexer listner:

            # lsof -i -P -n  | grep LISTEN | grep couchbase| grep -i index
            indexer   16453 couchbase   18u  IPv6 382194852      0t0  TCP *:9101 (LISTEN)
            indexer   16453 couchbase   21u  IPv6 382194188      0t0  TCP *:9100 (LISTEN)
            indexer   16453 couchbase   24u  IPv6 382194864      0t0  TCP *:9102 (LISTEN)
            indexer   16453 couchbase   25u  IPv6 382194865      0t0  TCP *:19102 (LISTEN)
            indexer   16453 couchbase   30u  IPv6 382193461      0t0  TCP *:9105 (LISTEN) 

            pierre.regazzoni Pierre Regazzoni added a comment - Verified on 7.1.0-2210 Set ipv6: #  /opt/couchbase/bin/couchbase-cli ip-family -c localhost -u Administrator -p password --set --ipv6 Switched IP family for node: http: //node1.couchbase.com:8091 Switched IP family for node: http: //node3.couchbase.com:8091 SUCCESS: Switched IP family of the cluster   #  /opt/couchbase/bin/couchbase-cli ip-family -c localhost -u Administrator -p password --get --ipv6 Cluster using ipv6 Run query: cbq> select * from `travel-sample` limit 10 ; {     "requestID" : "414f7431-1774-42e6-a54b-b0262a63d0d3" ,     "signature" : {         "*" : "*"     },     "results" : [     {         "travel-sample" : {             "callsign" : "MILE-AIR" ,             "country" : "United States" ,             "iata" : "Q5" ,             "icao" : "MLA" ,             "id" : 10 ,             "name" : "40-Mile Air" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "TXW" ,             "country" : "United States" ,             "iata" : "TQ" ,             "icao" : "TXW" ,             "id" : 10123 ,             "name" : "Texas Wings" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "atifly" ,             "country" : "United States" ,             "iata" : "A1" ,             "icao" : "A1F" ,             "id" : 10226 ,             "name" : "Atifly" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : null ,             "country" : "United Kingdom" ,             "iata" : null ,             "icao" : "JRB" ,             "id" : 10642 ,             "name" : "Jc royal.britannica" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "LOCAIR" ,             "country" : "United States" ,             "iata" : "ZQ" ,             "icao" : "LOC" ,             "id" : 10748 ,             "name" : "Locair" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "SASQUATCH" ,             "country" : "United States" ,             "iata" : "K5" ,             "icao" : "SQH" ,             "id" : 10765 ,             "name" : "SeaPort Airlines" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "ACE AIR" ,             "country" : "United States" ,             "iata" : "KO" ,             "icao" : "AER" ,             "id" : 109 ,             "name" : "Alaska Central Express" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "FLYSTAR" ,             "country" : "United Kingdom" ,             "iata" : "5W" ,             "icao" : "AEU" ,             "id" : 112 ,             "name" : "Astraeus" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "REUNION" ,             "country" : "France" ,             "iata" : "UU" ,             "icao" : "REU" ,             "id" : 1191 ,             "name" : "Air Austral" ,             "type" : "airline"         }     },     {         "travel-sample" : {             "callsign" : "AIRLINAIR" ,             "country" : "France" ,             "iata" : "A5" ,             "icao" : "RLA" ,             "id" : 1203 ,             "name" : "Airlinair" ,             "type" : "airline"         }     }     ],     "status" : "success" ,     "metrics" : {         "elapsedTime" : "186.666862ms" ,         "executionTime" : "186.366342ms" ,         "resultCount" : 10 ,         "resultSize" : 2602 ,         "serviceLoad" : 6     } } Check indexer listner: # lsof -i -P -n  | grep LISTEN | grep couchbase| grep -i index indexer   16453 couchbase   18u  IPv6 382194852      0t0  TCP *: 9101 (LISTEN) indexer   16453 couchbase   21u  IPv6 382194188      0t0  TCP *: 9100 (LISTEN) indexer   16453 couchbase   24u  IPv6 382194864      0t0  TCP *: 9102 (LISTEN) indexer   16453 couchbase   25u  IPv6 382194865      0t0  TCP *: 19102 (LISTEN) indexer   16453 couchbase   30u  IPv6 382193461      0t0  TCP *: 9105 (LISTEN)

            Yes. 

            varun.velamuri Varun Velamuri added a comment - Yes. 

            Varun Velamuri Can this be resolved now?

            jeelan.poola Jeelan Poola added a comment - Varun Velamuri Can this be resolved now?

            Build couchbase-server-7.1.0-1225 contains query commit 473831a with commit message:
            MB-48110 Update query go.mod to "replace" gometa

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1225 contains query commit 473831a with commit message: MB-48110 Update query go.mod to "replace" gometa

            Build couchbase-server-7.1.0-1225 contains n1fty commit 885e4a8 with commit message:
            MB-48110 Update n1fty go.mod to "replace" gometa

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1225 contains n1fty commit 885e4a8 with commit message: MB-48110 Update n1fty go.mod to "replace" gometa

            People

              pierre.regazzoni Pierre Regazzoni
              pierre.regazzoni Pierre Regazzoni
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty