QUERY: SELECT COUNT(*) - COUNT(*) / SPREAD("pH") FROM ( SELECT "pH", "degrees" FROM "h2o_temperature" OFFSET 922 SLIMIT 3) SLIMIT 340120 ===== STDOUT ===== ===== STDERR ===== [I] 2017-02-27T18:47:23Z InfluxDB starting, version unknown, branch unknown, commit[[[[httpd[[httpd] :[httpd] [h[htt[ht[httpd] ::1 - - [27/Feb/[httpd] ::1 - - [27/Feb/2017:18:50:46 +0000] [E] 2017-02-27T18:50:46Z SELECT count(*) - count(*) / spread(pH) FROM (SELECT pH, degrees FROM NOAA_water_database.autogen.h2o_temperature OFFSET 922 SLIMIT 3) SLIMIT 340120 [panic:interface conversion: influxql.Expr is *influxql.Wildcard, not *influxql.VarRef] goroutine 251155 [running]: runtime/debug.Stack(0xc42606f300, 0xc4254df540, 0x94) /usr/local/share/go/src/runtime/debug/stack.go:24 +0x79 github.com/influxdata/influxdb/influxql.(*QueryExecutor).recover(0xc42017c900, 0xc42606f300, 0xc425013440) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/query_executor.go:381 +0x96 panic(0x60eea0, 0xc42385f600) /usr/local/share/go/src/runtime/panic.go:458 +0x243 github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildCallIterator.func1.1(0xc430e2ea00, 0xc430e2e110, 0xc421689230, 0xc424f74920, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:807 +0x6f3 github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildCallIterator.func1(0xc421689230, 0xc430e2ea00, 0x0, 0xc4204e4c00, 0x2e31303a30303a30, 0xbb9000) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:828 +0x7eb github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildCallIterator(0xc430e2ea00, 0xc421689230, 0x107fa2, 0xc4248af810, 0xc42385f122, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:934 +0x8f github.com/influxdata/influxdb/influxql.buildExprIterator(0xa3ae00, 0xc421689230, 0x288e3f8, 0xc423ac5cc8, 0xc424f74090, 0x1, 0x1, 0xa3ae00, 0xc421689230, 0xa813c0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:409 +0x497 github.com/influxdata/influxdb/influxql.(*exprIteratorBuilder).buildBinaryExprIterator(0xc430e2ee90, 0xc4216892f0, 0x28, 0xc4216892c0, 0x0, 0x2) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:976 +0xfbb github.com/influxdata/influxdb/influxql.buildExprIterator(0xa3ad80, 0xc4216892f0, 0x288e3f8, 0xc423ac5cc8, 0xc424f74090, 0x1, 0x1, 0xa3ad80, 0xc4216892f0, 0xa813c0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:411 +0x342 github.com/influxdata/influxdb/influxql.buildFieldIterators.func1(0xc423ac5ce8, 0x1, 0x1, 0x288e3f8, 0xc423ac5cc8, 0xc424f74090, 0x1, 0x1, 0xc430e2f310, 0x13100, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:345 +0x1a9 github.com/influxdata/influxdb/influxql.buildFieldIterators(0xc423ac5ce8, 0x1, 0x1, 0x288e3f8, 0xc423ac5cc8, 0xc424f74090, 0x1, 0x1, 0x0, 0x0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:380 +0x10f github.com/influxdata/influxdb/influxql.buildIterators(0xc421f907e0, 0x288e3f8, 0xc423ac5cc8, 0x0, 0x0, 0xa813c0, 0x0, 0x0, 0x0, 0x0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:100 +0x50c github.com/influxdata/influxdb/influxql.Select(0xc421f907e0, 0x288e3f8, 0xc423ac5cc8, 0xc4251fdea0, 0xc423ac5cc8, 0x0, 0xc423ac5cc8, 0x0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/select.go:41 +0xee github.com/influxdata/influxdb/coordinator.(*StatementExecutor).createIterators(0xc42014bce0, 0xc421f90540, 0xc430e2fc38, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/coordinator/statement_executor.go:597 +0x5c9 github.com/influxdata/influxdb/coordinator.(*StatementExecutor).executeSelectStatement(0xc42014bce0, 0xc424a97ea0, 0xc430e2fc38, 0x0, 0x0) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/coordinator/statement_executor.go:433 +0x75 github.com/influxdata/influxdb/coordinator.(*StatementExecutor).ExecuteStatement(0xc42014bce0, 0xa3e6c0, 0xc424a97ea0, 0x0, 0xb88e, 0xc4238beea0, 0xc425013440, 0xa41de0, 0xc42019a060, 0xc4238bede0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/coordinator/statement_executor.go:57 +0x2b0d github.com/influxdata/influxdb/influxql.(*QueryExecutor).executeQuery(0xc42017c900, 0xc42606f300, 0xc4243d80ff, 0x13, 0xa35900, 0xa813c0, 0x2710, 0x0, 0x0, 0x0, ...) /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/query_executor.go:331 +0x55d created by github.com/influxdata/influxdb/influxql.(*QueryExecutor).ExecuteQuery /Users/edd/Development/golang/src/github.com/influxdata/influxdb/influxql/query_executor.go:226 +0xc3 service=query [httpd] ::1 - - [27/Feb/2017:18:50:46 +0000] "POST /query?db=NOAA_water_database¶ms=%7B%7D&q=SELECT++++COUNT%28%2A%29+-+++COUNT%28%2A%29+%2F+++SPREAD%28%22pH%22%29+FROM+%28+SELECT++%22pH%22%2C+%22degrees%22+FROM++%22h2o_temperature%22+OFFSET+922+SLIMIT+3%29+SLIMIT+340120 HTTP/1.1" 200 243 "-" "InfluxDBClient" a624fc78-fd1d-11e6-ace7-000000000000 756