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

[ADVISE] advise on a query statement causes a panic

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • 7.0.0-3980
    • Untriaged
    • 1
    • Unknown

    Description

      Fresh install (kv,index,n1ql)
      no bucket
      Run this advise statement:
      ADVISE SELECT DISTINCT( bool_field1 ) FROM bucket_01 WHERE NOT ( ( bool_field1 ) ) ORDER BY bool_field1 DESC

      {
      "errors": [

      { "code": 3000, "msg": "syntax error - at ADVISE", "query_from_user": "explain ADVISE SELECT DISTINCT( bool_field1 ) FROM bucket_01 WHERE NOT ( ( bool_field1 ) ) ORDER BY bool_field1 DESC" }

      ]
      }

      If we check the logs we see this panic (query.log)

      stack=goroutine 242 [running]:
      github.com/couchbase/query/server.(*Server).serviceRequest.func1()
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/server/server.go:868 +0xb8
      panic(0x223bca0, 0x279df10)
      	/home/couchbase/.cbdepscache/exploded/x86_64/go-1.13.7/go/src/runtime/panic.go:679 +0x1b2
      github.com/couchbase/query-ee/indexadvisor.(*coverCollector).collect(0xc0000d6420, 0x2839020, 0xc000388d70, 0xc00047e390, 0xd)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query-ee/indexadvisor/covercollector.go:550 +0xde
      github.com/couchbase/query-ee/indexadvisor.(*coverCollector).VisitField(0xc0000d6420, 0xc000388d70, 0x0, 0x0, 0x0, 0x0)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query-ee/indexadvisor/covercollector.go:398 +0x33d
      github.com/couchbase/query/expression.(*Field).Accept(0xc000388d70, 0x285e3c0, 0xc0000d6420, 0xc000466360, 0xc0003b1530, 0x0, 0x0)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/expression/nav_field.go:47 +0x3e
      github.com/couchbase/query-ee/indexadvisor.collectCoverKeys(0xc000800230, 0xc00028e000, 0xc0003b1410, 0x3, 0x3, 0xc000010170)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query-ee/indexadvisor/covergenerator.go:45 +0x33c
      github.com/couchbase/query-ee/indexadvisor.getCoverCollectors(0xc000010170, 0x1, 0x1, 0xc00028e000, 0xc0003b1410, 0x3, 0x3, 0xc000c569c8, 0x17c51a0, 0x0)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query-ee/indexadvisor/indexgenerator.go:151 +0xa4
      github.com/couchbase/query-ee/indexadvisor.generateIndex(0xc00028e000, 0xc0003b1440, 0xc0003b13b0, 0xc0003b1410, 0x3, 0x3, 0x24f6d20, 0xc0000f5400, 0xc000388c30, 0x2839020, ...)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query-ee/indexadvisor/indexgenerator.go:69 +0xef
      github.com/couchbase/query-ee/indexadvisor.AdviseIdxs(0xc000d23fb0, 0xc0003b13b0, 0xc0003b1410, 0x3, 0x3, 0x24f6d20, 0xc0000f5400, 0x7f28b1246100)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query-ee/indexadvisor/indexgenerator.go:46 +0x298
      github.com/couchbase/query/planner.(*builder).VisitAdvise(0xc000ec2000, 0xc000388780, 0x240, 0x24a5d80, 0x278ba98, 0x0)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/planner/build_advise_ee.go:66 +0x198
      github.com/couchbase/query/algebra.(*Advise).Accept(0xc000388780, 0x2826560, 0xc000ec2000, 0xc000d23f80, 0xc000c573a0, 0x203000, 0x203000)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/algebra/advise.go:37 +0x3b
      github.com/couchbase/query/planner.Build(0x280b4a0, 0xc000388780, 0x2823160, 0xc0000b7ba0, 0x2823460, 0xc00000e240, 0x252c2c5, 0x7, 0x2470100, 0xc000800070, ...)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/planner/build.go:32 +0x19d
      github.com/couchbase/query/planner.BuildPrepared(0x280b4a0, 0xc000388780, 0x2823160, 0xc0000b7ba0, 0x2823460, 0xc00000e240, 0x252c2c5, 0x7, 0x100, 0xc000800070, ...)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/planner/build_prepared.go:20 +0xc0
      github.com/couchbase/query/server.(*Server).getPrepared(0xc00000c1e0, 0x286a3a0, 0xc000dc0000, 0xc0000f5400, 0x0, 0x0, 0xc000926e00)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/server/server.go:1090 +0x1280
      github.com/couchbase/query/server.(*Server).serviceRequest(0xc00000c1e0, 0x286a3a0, 0xc000dc0000)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/server/server.go:901 +0x13e
      github.com/couchbase/query/server.(*Server).handleRequest(0xc00000c1e0, 0x286a3a0, 0xc000dc0000, 0xc00000c210, 0x9)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/server/server.go:590 +0x6c
      github.com/couchbase/query/server.(*Server).ServiceRequest(0xc00000c1e0, 0x286a3a0, 0xc000dc0000, 0x0)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/server/server.go:531 +0x77
      github.com/couchbase/query/server/http.(*HttpEndpoint).ServeHTTP(0xc0004ea420, 0x27ead40, 0xc000914ee0, 0xc000bebf00)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/goproj/src/github.com/couchbase/query/server/http/service_endpoint.go:249 +0x357
      github.com/gorilla/mux.(*Router).ServeHTTP(0xc00079c3c0, 0x27ead40, 0xc000914ee0, 0xc000bebd00)
      	/home/couchbase/jenkins/workspace/couchbase-server-unix/server_build/gopkg/go-1.13.7/pkg/mod/github.com/gorilla/mux@v1.7.4/mux.go:210 +0xe2
      net/http.serverHandler.ServeHTTP(0xc0001001c0, 0x27ead40, 0xc000914ee0, 0xc000bebd00)
      	/home/couchbase/.cbdepscache/exploded/x86_64/go-1.13.7/go/src/net/http/server.go:2802 +0xa4
      net/http.(*conn).serve(0xc0008ac0a0, 0x27f6a00, 0xc00034a2c0)
      	/home/couchbase/.cbdepscache/exploded/x86_64/go-1.13.7/go/src/net/http/server.go:1890 +0x875
      created by net/http.(*Server).Serve
      	/home/couchbase/.cbdepscache/exploded/x86_64/go-1.13.7/go/src/net/http/server.go:2928 +0x384
       
       
       
      
      

      Attachments

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

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            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