Details
-
Bug
-
Resolution: Fixed
-
Critical
-
4.6.2
-
4.6.2-3884
-
Triaged
-
No
Description
Dynamic Index created:
CREATE INDEX `idx_simple_table_db_3083_simple_table` ON `simple_table_db_3083_simple_table`((distinct (array `v` for `v` in pairs(self) end))) WITH { "defer_build"=true } |
|
Following query hangs:
(SELECT * FROM simple_table_db_3083_simple_table WHERE ((NOT ((primary_key_id IN [ "1" , "10" , "100" , "1000" , "101" ]) OR ((char_field1 > "N") OR (primary_key_id <= "549"))) AND (decimal_field1 IS NOT NULL) OR (decimal_field1 IS NULL))) AND ((bool_field1 != true AND varchar_field1 != "aPLgGnRwOm")) ORDER BY primary_key_id , varchar_field1 , char_field1 ) UNION ALL (SELECT * FROM simple_table_db_3083_simple_table WHERE NOT ((NOT (bool_field1) OR (int_field1 != 5058) AND (int_field1 < 5058))) ORDER BY int_field1 , decimal_field1 , primary_key_id , bool_field1 ) ; |
Query.log shows following panic:
github.com/couchbase/query/algebra.(*ExpressionTerm).Accept(0xc211c36a80, 0x7fc881f23f60, 0xc213968000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/algebra/from_expression.go:38 +0x5c fp=0xc2125d4940 sp=0xc2125d4908 |
github.com/couchbase/query/planner.(*builder).visitFrom(0xc213968000, 0xc208516410, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_select_from.go:38 +0x2f0 fp=0xc2125d4a70 sp=0xc2125d4940 |
github.com/couchbase/query/planner.(*builder).VisitSubselect(0xc213968000, 0xc208516410, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_select_sub.go:153 +0x19d3 fp=0xc2125d5110 sp=0xc2125d4a70 |
github.com/couchbase/query/algebra.(*Subselect).Accept(0xc208516410, 0x7fc881f23f60, 0xc213968000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/algebra/select_sub.go:47 +0x5f fp=0xc2125d5148 sp=0xc2125d5110 |
github.com/couchbase/query/planner.(*builder).VisitSelect(0xc213968000, 0xc208516460, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_select.go:53 +0x469 fp=0xc2125d53a0 sp=0xc2125d5148 |
github.com/couchbase/query/algebra.(*Select).Accept(0xc208516460, 0x7fc881f1b698, 0xc213968000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/algebra/select.go:59 +0x5f fp=0xc2125d53d8 sp=0xc2125d53a0 |
github.com/couchbase/query/planner.(*builder).VisitSelectTerm(0xc213968000, 0xc208d08020, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_select_term.go:17 +0x90 fp=0xc2125d5438 sp=0xc2125d53d8 |
github.com/couchbase/query/algebra.(*SelectTerm).Accept(0xc208d08020, 0x7fc881f23f60, 0xc213968000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/algebra/select_term.go:38 +0x5c fp=0xc2125d5470 sp=0xc2125d5438 |
github.com/couchbase/query/planner.(*builder).VisitUnion(0xc213968000, 0xc208ecd040, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_set_op.go:26 +0x192 fp=0xc2125d5590 sp=0xc2125d5470 |
github.com/couchbase/query/algebra.(*Union).Accept(0xc208ecd040, 0x7fc881f23f60, 0xc213968000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/algebra/set_op.go:206 +0x5f fp=0xc2125d55c8 sp=0xc2125d5590 |
github.com/couchbase/query/planner.(*builder).VisitUnion(0xc213968000, 0xc211fab000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_set_op.go:26 +0x192 fp=0xc2125d56e8 sp=0xc2125d55c8 |
github.com/couchbase/query/algebra.(*Union).Accept(0xc211fab000, 0x7fc881f23f60, 0xc213968000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/algebra/set_op.go:206 +0x5f fp=0xc2125d5720 sp=0xc2125d56e8 |
github.com/couchbase/query/planner.(*builder).VisitSelect(0xc213968000, 0xc20872a050, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_select.go:53 +0x469 fp=0xc2125d5978 sp=0xc2125d5720 |
github.com/couchbase/query/algebra.(*Select).Accept(0xc20872a050, 0x7fc881f1b698, 0xc213968000, 0x0, 0x0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/algebra/select.go:59 +0x5f fp=0xc2125d59b0 sp=0xc2125d5978 |
github.com/couchbase/query/planner.Build(0x7fc881f237c0, 0xc20872a050, 0x7fc8820d9888, 0xc2080a6000, 0x7fc8820daf78, 0xc2081166a0, 0x10f6d80, 0x7, 0xc20e722e00, 0x0, ...) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build.go:24 +0x1e5 fp=0xc2125d5ae0 sp=0xc2125d59b0 |
github.com/couchbase/query/planner.BuildPrepared(0x7fc881f237c0, 0xc20872a050, 0x7fc8820d9888, 0xc2080a6000, 0x7fc8820daf78, 0xc2081166a0, 0x10f6d80, 0x7, 0x200000000000000, 0xc207e6f7e2, ...) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/planner/build_prepared.go:20 +0xb2 fp=0xc2125d5ba8 sp=0xc2125d5ae0 |
github.com/couchbase/query/server.(*Server).getPrepared(0xc2084607e0, 0x7fc8820f3550, 0xc2125a6000, 0x10f6d80, 0x7, 0xc2084bf7a0, 0x0, 0x0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/server/server.go:480 +0x204 fp=0xc2125d5ca8 sp=0xc2125d5ba8 |
github.com/couchbase/query/server.(*Server).serviceRequest(0xc2084607e0, 0x7fc8820f3550, 0xc2125a6000) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/server/server.go:408 +0x155 fp=0xc2125d5ee8 sp=0xc2125d5ca8 |
github.com/couchbase/query/server.(*Server).doPlusServe(0xc2084607e0) |
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/server/server.go:380 +0x12f fp=0xc2125d5fd8 sp=0xc2125d5ee8 |
runtime.goexit()
|
/usr/local/go/src/runtime/asm_amd64.s:2232 +0x1 fp=0xc2125d5fe0 sp=0xc2125d5fd8 |
created by github.com/couchbase/query/server.(*Server).PlusServe
|
/home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/query/server/server.go:370 +0x7d |
|
Attaching logs.
Attachments
Issue Links
- relates to
-
MB-26374 [N1QL Adaptive Index] Queries not having "NOT" are timing out with adaptive index
- Closed