Subqueries can only perform math on two fields

[NotionCommotion]

System info:

InfluxDB shell version 1.3.5
CentOS Linux release 7.3.1611

Steps to reproduce:

Perform the following query from the shell:
SELECT p FROM (SELECT P51 + P55 + P57 AS p FROM L11)

Expected behavior:

The same results as: SELECT P51 + P55 + P57 AS p FROM L11

Actual behavior:

The query runs indefinitely (at least 5 hours) and the shell locks up requiring me to ctrl-z to exit and then kill the query.

Additional info:

My reason to do this is to perform math within an aggregate function using the subquery workaround described by:
https://docs.influxdata.com/influxdb/v1.3/troubleshooting/frequently-asked-questions/#how-do-i-perform-mathematical-operations-within-a-function
https://docs.influxdata.com/influxdb/v1.3/query_language/data_exploration/#subqueries

I am successfully able to perform math on three fields in the main query.
SELECT P51 + P55 + P57 AS p FROM L11

I am successfully able to perform math on two fields in a subquery, and perform an aggregate function on the results.
SELECT p FROM (SELECT P51 + P55 AS p FROM L11)
SELECT mean(p) AS meanp, count(p) AS countp FROM (SELECT P51+P55 AS p FROM L11)

My desired query, however, displays the same behaviour as the query listed under Steps to Reproduce.
SELECT mean(p) AS meanp, count(p) AS countp FROM (SELECT P51 + P55 + P57 AS p FROM L11)

Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z opened service service=subscriber
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Starting monitor system service=monitor
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z 'build' registered for diagnostics monitoring service=monitor
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z 'runtime' registered for diagnostics monitoring service=monitor
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z 'network' registered for diagnostics monitoring service=monitor
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z 'system' registered for diagnostics monitoring service=monitor
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Starting precreation service with check interval of 10m0s, advance period of 30m0s service=shard-precreation
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Starting snapshot service service=snapshot
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Starting continuous query service service=continuous_querier
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Starting HTTP service service=httpd
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Authentication enabled:false service=httpd
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Listening on HTTP:[::]:8086 service=httpd
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Starting retention policy enforcement service with check interval of 30m0s service=retention
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Listening for signals
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Storing statistics in database '_internal' retention policy 'monitor', at interval 10s service=monitor
Sep 19 15:08:49 devserver influxd[45661]: [I] 2017-09-19T15:08:49Z Sending usage statistics to usage.influxdata.com
Sep 19 15:08:52 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:08:52 +0000] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.3.5" 72ac73a0-9d4c-11e7-8001-000000000000 112
Sep 19 15:08:59 devserver influxd[45661]: [I] 2017-09-19T15:08:59Z SHOW DATABASES service=query
Sep 19 15:08:59 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:08:59 +0000] "POST /query?db=&epoch=ns&q=SHOW+DATABASES HTTP/1.1" 200 170 "-" "InfluxDBShell/1.3.5" 76e86642-9d4c-11e7-8002-000000000000 731
Sep 19 15:09:10 devserver influxd[45661]: [I] 2017-09-19T15:09:10Z SELECT P51 + P55 + P57 AS p FROM greenbean_dl.autogen.L11 service=query
Sep 19 15:09:10 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:09:10 +0000] "POST /query?chunked=true&db=greenbean_dl&epoch=ns&q=SELECT+P51+%2B+P55+%2B+P57+AS+p+FROM+L11 HTTP/1.1" 200 401085 "-" "InfluxDBShell/1.
Sep 19 15:09:19 devserver influxd[45661]: [I] 2017-09-19T15:09:19Z SELECT p FROM (SELECT P51 + P55 AS p FROM greenbean_dl.autogen.L11) service=query
Sep 19 15:09:19 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:09:19 +0000] "POST /query?chunked=true&db=greenbean_dl&epoch=ns&q=SELECT+p+FROM+%28SELECT+P51+%2B+P55+AS+p+FROM+L11%29 HTTP/1.1" 200 130435 "-" "Infl
Sep 19 15:09:27 devserver influxd[45661]: [I] 2017-09-19T15:09:27Z SELECT mean(p) AS meanp, count(p) AS countp FROM (SELECT P51 + P55 AS p FROM greenbean_dl.autogen.L11) service=query
Sep 19 15:09:28 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:09:27 +0000] "POST /query?chunked=true&db=greenbean_dl&epoch=ns&q=SELECT+mean%28p%29+AS+meanp%2C+count%28p%29+AS+countp+FROM+%28SELECT+P51%2BP55+AS+p
Sep 19 15:09:38 devserver influxd[45661]: [I] 2017-09-19T15:09:38Z SELECT p FROM (SELECT P51 + P55 + P57 AS p FROM greenbean_dl.autogen.L11) service=query
Sep 19 15:10:12 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:10:12 +0000] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.3.5" a282518e-9d4c-11e7-8007-000000000000 21
Sep 19 15:10:15 devserver influxd[45661]: [I] 2017-09-19T15:10:15Z SHOW QUERIES service=query
Sep 19 15:10:15 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:10:15 +0000] "POST /query?chunked=true&db=&epoch=ns&q=show+queries HTTP/1.1" 200 211 "-" "InfluxDBShell/1.3.5" a40b0b4c-9d4c-11e7-8008-000000000000 7
Sep 19 15:10:22 devserver influxd[45661]: [I] 2017-09-19T15:10:22Z KILL QUERY 5 service=query
Sep 19 15:10:22 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:10:22 +0000] "POST /query?chunked=true&db=&epoch=ns&q=kill+query+5 HTTP/1.1" 200 67 "-" "InfluxDBShell/1.3.5" a81a9319-9d4c-11e7-8009-000000000000 57
Sep 19 15:10:34 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:10:34 +0000] "POST /query?chunked=true&db=&epoch=ns&q=SELECT+mean%28p%29+AS+meanp%2C+count%28p%29+AS+countp+FROM+%28SELECT+P51+%2B+P55+%2B+P57+AS+p+F
Sep 19 15:10:48 devserver influxd[45661]: [I] 2017-09-19T15:10:48Z SHOW DATABASES service=query
Sep 19 15:10:48 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:10:48 +0000] "POST /query?db=&epoch=ns&q=SHOW+DATABASES HTTP/1.1" 200 170 "-" "InfluxDBShell/1.3.5" b7bfb677-9d4c-11e7-800b-000000000000 545
Sep 19 15:10:50 devserver influxd[45661]: [I] 2017-09-19T15:10:50Z SELECT mean(p) AS meanp, count(p) AS countp FROM (SELECT P51 + P55 + P57 AS p FROM greenbean_dl.autogen.L11) service=query
Sep 19 15:11:14 devserver influxd[45661]: [httpd] 127.0.0.1 - - [19/Sep/2017:15:11:14 +000

[jsternberg]

When you kill the query, does the influx client return control or does it continue to stall? Basically, can you take two terminals. In one terminal, run the query that's a problem. In the other, kill the query. Does control return to the first terminal or do you still have to kill the program?

[NotionCommotion]

After killing the query, the influx client does not return control but continues to stall.

[jsternberg]

Meh, I thought that would happen. The query is still using resources, but I never fixed the task manager to actually say it was a zombie task. There are two separate tangential issues that I'll also see if I can fix. Fixing them won't help you get a running query, but having them broken makes it worse.

I'm trying to reproduce this but haven't been able to yet. It works for me on my local machine. Do you have any missing values within the data? Can you run SHOW FIELD KEYS and SHOW SHARDS on your data? Feel free to anonymize anything you want if needed. I'm mostly just interested in shard durations and field types.

[NotionCommotion]

Yes, there is missing data. My data arrives asynchronously and often I don't have data for all fields for a given timestamp. Is that an issue? If necessary, I can give you access to the server.

[michael@devserver ~]$ /usr/bin/influx
Connected to http://localhost:8086 version 1.3.5
InfluxDB shell version: 1.3.5
> use devserver_dl
Using database devserver_dl
> show field keys
name: L11
fieldKey fieldType
-------- ---------
P16      float
P32      float
P49      float
P6       float
P53      float
P69      float
P70      float
P45      float
P72      float
P47      float
P75      float
P77      float
P51      float
P110     float
P55      float
P57      float
P58      float
P59      float
P60      float
P65      float
P66      float

name: L12
fieldKey fieldType
-------- ---------
P158     float
P159     float
P160     float
P161     float

name: L5
fieldKey fieldType
-------- ---------
P141     float
P111     float
P31      float
P134     float
P52      float
P54      float
P18      float
P68      float
P73      float
P44      float
P95      float
P46      float
P98      float
P56      float
P61      float
P63      float
P64      float
P67      float

name: L6
fieldKey fieldType
-------- ---------
P17      float
P33      float
P34      float
P38      float
P41      float
P42      float
P48      float
P50      float
P62      float
P71      float
P74      float
P76      float
> show shards
name: _internal
id  database  retention_policy shard_group start_time           end_time             expiry_time          owners
--  --------  ---------------- ----------- ----------           --------             -----------          ------
168 _internal monitor          168         2017-09-12T00:00:00Z 2017-09-13T00:00:00Z 2017-09-20T00:00:00Z
169 _internal monitor          169         2017-09-13T00:00:00Z 2017-09-14T00:00:00Z 2017-09-21T00:00:00Z
170 _internal monitor          170         2017-09-14T00:00:00Z 2017-09-15T00:00:00Z 2017-09-22T00:00:00Z
171 _internal monitor          171         2017-09-15T00:00:00Z 2017-09-16T00:00:00Z 2017-09-23T00:00:00Z
172 _internal monitor          172         2017-09-16T00:00:00Z 2017-09-17T00:00:00Z 2017-09-24T00:00:00Z
173 _internal monitor          173         2017-09-17T00:00:00Z 2017-09-18T00:00:00Z 2017-09-25T00:00:00Z
174 _internal monitor          174         2017-09-18T00:00:00Z 2017-09-19T00:00:00Z 2017-09-26T00:00:00Z
178 _internal monitor          178         2017-09-19T00:00:00Z 2017-09-20T00:00:00Z 2017-09-27T00:00:00Z

name: devtest_1865094168
id database retention_policy shard_group start_time end_time expiry_time owners
-- -------- ---------------- ----------- ---------- -------- ----------- ------

name: devtest_1586701055
id database retention_policy shard_group start_time end_time expiry_time owners
-- -------- ---------------- ----------- ---------- -------- ----------- ------

name: devtest_1104665423
id  database              retention_policy shard_group start_time           end_time             expiry_time          owners
--  --------              ---------------- ----------- ----------           --------             -----------          ------
19  devtest_1104665423 autogen          19          2017-06-05T00:00:00Z 2017-06-12T00:00:00Z 2017-06-12T00:00:00Z
23  devtest_1104665423 autogen          23          2017-06-12T00:00:00Z 2017-06-19T00:00:00Z 2017-06-19T00:00:00Z
31  devtest_1104665423 autogen          31          2017-06-19T00:00:00Z 2017-06-26T00:00:00Z 2017-06-26T00:00:00Z
39  devtest_1104665423 autogen          39          2017-06-26T00:00:00Z 2017-07-03T00:00:00Z 2017-07-03T00:00:00Z
47  devtest_1104665423 autogen          47          2017-07-03T00:00:00Z 2017-07-10T00:00:00Z 2017-07-10T00:00:00Z
55  devtest_1104665423 autogen          55          2017-07-10T00:00:00Z 2017-07-17T00:00:00Z 2017-07-17T00:00:00Z
63  devtest_1104665423 autogen          63          2017-07-17T00:00:00Z 2017-07-24T00:00:00Z 2017-07-24T00:00:00Z
71  devtest_1104665423 autogen          71          2017-07-24T00:00:00Z 2017-07-31T00:00:00Z 2017-07-31T00:00:00Z
79  devtest_1104665423 autogen          79          2017-07-31T00:00:00Z 2017-08-07T00:00:00Z 2017-08-07T00:00:00Z
87  devtest_1104665423 autogen          87          2017-08-07T00:00:00Z 2017-08-14T00:00:00Z 2017-08-14T00:00:00Z
95  devtest_1104665423 autogen          95          2017-08-14T00:00:00Z 2017-08-21T00:00:00Z 2017-08-21T00:00:00Z
103 devtest_1104665423 autogen          103         2017-08-21T00:00:00Z 2017-08-28T00:00:00Z 2017-08-28T00:00:00Z
111 devtest_1104665423 autogen          111         2017-08-28T00:00:00Z 2017-09-04T00:00:00Z 2017-09-04T00:00:00Z
119 devtest_1104665423 autogen          119         2017-09-04T00:00:00Z 2017-09-11T00:00:00Z 2017-09-11T00:00:00Z
165 devtest_1104665423 autogen          165         2017-09-11T00:00:00Z 2017-09-18T00:00:00Z 2017-09-18T00:00:00Z
175 devtest_1104665423 autogen          175         2017-09-18T00:00:00Z 2017-09-25T00:00:00Z 2017-09-25T00:00:00Z

name: devtest_1974750116
id  database              retention_policy shard_group start_time           end_time             expiry_time          owners
--  --------              ---------------- ----------- ----------           --------             -----------          ------
152 devtest_1974750116 autogen          152         2017-09-04T00:00:00Z 2017-09-11T00:00:00Z 2017-09-11T00:00:00Z
166 devtest_1974750116 autogen          166         2017-09-11T00:00:00Z 2017-09-18T00:00:00Z 2017-09-18T00:00:00Z
176 devtest_1974750116 autogen          176         2017-09-18T00:00:00Z 2017-09-25T00:00:00Z 2017-09-25T00:00:00Z

name: devserver_dl
id  database     retention_policy shard_group start_time           end_time             expiry_time          owners
--  --------     ---------------- ----------- ----------           --------             -----------          ------
163 devserver_dl autogen          163         2017-06-19T00:00:00Z 2017-06-26T00:00:00Z 2017-06-26T00:00:00Z
162 devserver_dl autogen          162         2017-07-03T00:00:00Z 2017-07-10T00:00:00Z 2017-07-10T00:00:00Z
161 devserver_dl autogen          161         2017-07-10T00:00:00Z 2017-07-17T00:00:00Z 2017-07-17T00:00:00Z
160 devserver_dl autogen          160         2017-07-17T00:00:00Z 2017-07-24T00:00:00Z 2017-07-24T00:00:00Z
159 devserver_dl autogen          159         2017-07-24T00:00:00Z 2017-07-31T00:00:00Z 2017-07-31T00:00:00Z
158 devserver_dl autogen          158         2017-07-31T00:00:00Z 2017-08-07T00:00:00Z 2017-08-07T00:00:00Z
157 devserver_dl autogen          157         2017-08-07T00:00:00Z 2017-08-14T00:00:00Z 2017-08-14T00:00:00Z
156 devserver_dl autogen          156         2017-08-14T00:00:00Z 2017-08-21T00:00:00Z 2017-08-21T00:00:00Z
155 devserver_dl autogen          155         2017-08-21T00:00:00Z 2017-08-28T00:00:00Z 2017-08-28T00:00:00Z
154 devserver_dl autogen          154         2017-08-28T00:00:00Z 2017-09-04T00:00:00Z 2017-09-04T00:00:00Z
153 devserver_dl autogen          153         2017-09-04T00:00:00Z 2017-09-11T00:00:00Z 2017-09-11T00:00:00Z
167 devserver_dl autogen          167         2017-09-11T00:00:00Z 2017-09-18T00:00:00Z 2017-09-18T00:00:00Z
177 devserver_dl autogen          177         2017-09-18T00:00:00Z 2017-09-25T00:00:00Z 2017-09-25T00:00:00Z
>