Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Inner join query caused a server crash #652

Closed
janajri opened this issue Jun 16, 2014 · 3 comments
Closed

Inner join query caused a server crash #652

janajri opened this issue Jun 16, 2014 · 3 comments

Comments

@janajri
Copy link

janajri commented Jun 16, 2014

One of our data guys was attempting to run the following query before crashing our InfluxDB instance. Not too familiar with Go, so I haven't been able to pinpoint where the crash occurred. I've provided the exact query that was run, along with the debug logs.

Query run: SELECT USERNAME,EVENTID,time FROM analytics_v1 AS table1 INNER JOIN analytics_v1 AS table2 WHERE table1.EVENTID = table2.EVENTID AND TYPE='MSG' AND SUB='TXT' AND time > '2014-06-01 00:00:00.000' AND time < '2014-06-17 00:00:00.000'

Debug logs gist:

https://gist.github.com/yousefj/e45241c984fc7615021c

Let me know if there is anything else I can provide.

Thanks,
Yousef
@janajri
Copy link
Author

janajri commented Jun 16, 2014

Might also help to know that we are running: InfluxDB v0.7.2 (git: 63c2be7) (leveldb: 1.15) on an AWS Linux 64-bit

@janajri janajri mentioned this issue Jun 17, 2014
Closed
@mattheworiordan
Copy link

I too have a consistent crash with InfluxDB 0.8 when I run the following join query: select mean(system.value + user.value) from "host.cpu-0-system" as system inner join "host.cpu-0-user" as user where time > now() - 1h AND environment = 'staging' group by time(2m) order asc.

Here is the log from the server:

+---------------------------------------------+
|  _____        __ _            _____  ____   |
| |_   _|      / _| |          |  __ \|  _ \  |
|   | |  _ __ | |_| |_   ___  _| |  | | |_) | |
|   | | | '_ \|  _| | | | \ \/ / |  | |  _ <  |
|  _| |_| | | | | | | |_| |>  <| |__| | |_) | |
| |_____|_| |_|_| |_|\__,_/_/\_\_____/|____/  |
+---------------------------------------------+

[09/03/14 22:33:48] [INFO] Loading configuration file /config.toml
panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xb code=0x1 addr=0x8 pc=0x6d078b]

goroutine 2417 [running]:
runtime.panic(0xbf83e0, 0x1209193)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/panic.c:279 +0xf5
github.com/influxdb/influxdb/engine.func·016(0xc2088982a0, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/engine/merge.go:56 +0x9db
github.com/influxdb/influxdb/engine.(*mergeState).yieldNextPoints(0xc2081ff6b0, 0xc208279c20, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/engine/merge.go:191 +0x14f
github.com/influxdb/influxdb/engine.func·018(0xc2082b1a40, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/engine/merge.go:280 +0xb8
github.com/influxdb/influxdb/engine.(*QueryEngine).yieldSeriesData(0xc2081903c0, 0xc2082b1a40, 0x7f7d4c0a5e28)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/engine/engine.go:181 +0x30
github.com/influxdb/influxdb/engine.(*QueryEngine).YieldSeries(0xc2081903c0, 0xc2082b1a40, 0x7f7d4c0a5f30)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/engine/engine.go:177 +0x15c
github.com/influxdb/influxdb/coordinator.(*CoordinatorImpl).readFromResponseChannels(0xc2080c5410, 0x7f7d4ee93068, 0xc2081903c0, 0x7f7d4ee7fcf8, 0xc208189278, 0x0, 0xc208507650, 0xc208180960)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:371 +0x3c7
created by github.com/influxdb/influxdb/coordinator.(*CoordinatorImpl).runQuerySpec
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:449 +0x4bd

goroutine 16 [IO wait]:
net.runtime_pollWait(0x7f7d4ee7a658, 0x72, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/netpoll.goc:146 +0x66
net.(*pollDesc).Wait(0xc2081dcb50, 0x72, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:84 +0x46
net.(*pollDesc).WaitRead(0xc2081dcb50, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:89 +0x42
net.(*netFD).accept(0xc2081dcaf0, 0xd8f4e0, 0x0, 0x7f7d4ee772b8, 0xb)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_unix.go:409 +0x343
net.(*TCPListener).AcceptTCP(0xc2081897e0, 0x8, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:234 +0x5d
net.(*TCPListener).Accept(0xc2081897e0, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:244 +0x4b
net/http.(*Server).Serve(0xc20809e960, 0x7f7d4ee79810, 0xc2081897e0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1698 +0x91
github.com/influxdb/influxdb/api/http.(*HttpServer).serveListener(0xc2080706e0, 0x7f7d4ee79810, 0xc2081897e0, 0xc2081897e8)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:209 +0xb9
github.com/influxdb/influxdb/api/http.(*HttpServer).Serve(0xc2080706e0, 0x7f7d4ee79810, 0xc2081897e0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:179 +0xeed
github.com/influxdb/influxdb/api/http.(*HttpServer).ListenAndServe(0xc2080706e0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:94 +0x1a4
github.com/influxdb/influxdb/server.(*Server).ListenAndServe(0xc208042090, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/server/server.go:191 +0x9b9
main.main()
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/daemon/influxd.go:162 +0xe94

goroutine 19 [finalizer wait, 1 minutes]:
runtime.park(0x4f7980, 0x1221940, 0x120bf09)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/proc.c:1369 +0x89
runtime.parkunlock(0x1221940, 0x120bf09)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/proc.c:1385 +0x3b
runfinq()
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/mgc0.c:2644 +0xcf
runtime.goexit()
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/proc.c:1445

goroutine 20 [syscall, 1 minutes]:
os/signal.loop()
        /home/vagrant/.gvm/gos/go1.3/src/pkg/os/signal/signal_unix.go:21 +0x1e
created by os/signal.init·1
        /home/vagrant/.gvm/gos/go1.3/src/pkg/os/signal/signal_unix.go:27 +0x32

goroutine 21 [chan receive, 1 minutes]:
code.google.com/p/log4go.ConsoleLogWriter.run(0xc20806e000, 0x7f7d4ee77550, 0xc20802c008)
        /home/vagrant/gocodez/src/code.google.com/p/log4go/termlog.go:27 +0x79
created by code.google.com/p/log4go.NewConsoleLogWriter
        /home/vagrant/gocodez/src/code.google.com/p/log4go/termlog.go:19 +0x68

goroutine 17 [syscall, 1 minutes]:
runtime.goexit()
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/proc.c:1445

goroutine 22 [select]:
code.google.com/p/log4go.func·002()
        /home/vagrant/gocodez/src/code.google.com/p/log4go/filelog.go:84 +0x8ac
created by code.google.com/p/log4go.NewFileLogWriter
        /home/vagrant/gocodez/src/code.google.com/p/log4go/filelog.go:116 +0x2c4

goroutine 23 [chan receive]:
github.com/influxdb/influxdb/wal.(*WAL).processEntries(0xc2080282a0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/wal/wal.go:252 +0x64
created by github.com/influxdb/influxdb/wal.NewWAL
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/wal/wal.go:103 +0xa53

goroutine 24 [sleep, 1 minutes]:
time.Sleep(0x8bb2c97000)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/time.goc:39 +0x31
github.com/influxdb/influxdb/cluster.func·001()
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/cluster/cluster_configuration.go:170 +0x3d
created by github.com/influxdb/influxdb/cluster.(*ClusterConfiguration).CreateFutureShardsAutomaticallyBeforeTimeComes
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/cluster/cluster_configuration.go:177 +0x63

goroutine 25 [chan receive, 1 minutes]:
main.waitForSignals(0x7f7d4ee79790, 0xc208042090)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/daemon/null_profiler.go:23 +0x14c
created by main.startProfiler
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/daemon/null_profiler.go:15 +0x4b

goroutine 26 [IO wait, 1 minutes]:
net.runtime_pollWait(0x7f7d4ee7a7b8, 0x72, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/netpoll.goc:146 +0x66
net.(*pollDesc).Wait(0xc208028060, 0x72, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:84 +0x46
net.(*pollDesc).WaitRead(0xc208028060, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:89 +0x42
net.(*netFD).accept(0xc208028000, 0xd8f4e0, 0x0, 0x7f7d4ee772b8, 0xb)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_unix.go:409 +0x343
net.(*TCPListener).AcceptTCP(0xc20802c060, 0xc20802b8a8, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:234 +0x5d
net.(*TCPListener).Accept(0xc20802c060, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:244 +0x4b
net/http.(*Server).Serve(0xc208004120, 0x7f7d4ee79810, 0xc20802c060, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1698 +0x91
github.com/influxdb/influxdb/coordinator.func·008()
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/raft_server.go:564 +0x3a
created by github.com/influxdb/influxdb/coordinator.(*RaftServer).Serve
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/raft_server.go:568 +0x516

goroutine 31 [select, 1 minutes]:
github.com/influxdb/influxdb/cluster.(*WriteBuffer).handleWrites(0xc2081dc540)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/cluster/write_buffer.go:75 +0xd3
created by github.com/influxdb/influxdb/cluster.NewWriteBuffer
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/cluster/write_buffer.go:43 +0x286

goroutine 28 [select, 1 minutes]:
github.com/influxdb/influxdb/_vendor/raft.(*server).leaderLoop(0xc2080a67e0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/_vendor/raft/server.go:834 +0x6c5
github.com/influxdb/influxdb/_vendor/raft.(*server).loop(0xc2080a67e0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/_vendor/raft/server.go:609 +0x3d1
github.com/influxdb/influxdb/_vendor/raft.func·007()
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/_vendor/raft/server.go:470 +0x5d
created by github.com/influxdb/influxdb/_vendor/raft.(*server).Start
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/_vendor/raft/server.go:471 +0x3b8

goroutine 29 [select]:
github.com/influxdb/influxdb/coordinator.(*RaftServer).CompactLog(0xc208070630)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/raft_server.go:340 +0x332
created by github.com/influxdb/influxdb/coordinator.(*RaftServer).startRaft
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/raft_server.go:394 +0x487

goroutine 34 [select]:
github.com/influxdb/influxdb/coordinator.(*RaftServer).raftLeaderLoop(0xc208070630, 0xc2080c2e00, 0xc2080c2d80)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/raft_server.go:453 +0x34c
created by github.com/influxdb/influxdb/coordinator.(*RaftServer).raftEventHandler
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/raft_server.go:441 +0x268

goroutine 30 [IO wait, 1 minutes]:
net.runtime_pollWait(0x7f7d4ee7a708, 0x72, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/netpoll.goc:146 +0x66
net.(*pollDesc).Wait(0xc2081dc840, 0x72, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:84 +0x46
net.(*pollDesc).WaitRead(0xc2081dc840, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:89 +0x42
net.(*netFD).accept(0xc2081dc7e0, 0xd8f4e0, 0x0, 0x7f7d4ee772b8, 0xb)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_unix.go:409 +0x343
net.(*TCPListener).AcceptTCP(0xc2081897d0, 0xc2081af1f0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:234 +0x5d
net.(*TCPListener).Accept(0xc2081897d0, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:244 +0x4b
github.com/influxdb/influxdb/coordinator.(*ProtobufServer).ListenAndServe(0xc2080c2e80)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/protobuf_server.go:64 +0x1c7
created by github.com/influxdb/influxdb/server.(*Server).ListenAndServe
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/server/server.go:122 +0x2a2

goroutine 50 [IO wait]:
net.runtime_pollWait(0x7f7d4ee7a5a8, 0x72, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/netpoll.goc:146 +0x66
net.(*pollDesc).Wait(0xc2081dcf40, 0x72, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:84 +0x46
net.(*pollDesc).WaitRead(0xc2081dcf40, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:89 +0x42
net.(*netFD).accept(0xc2081dcee0, 0xd8f4e0, 0x0, 0x7f7d4ee772b8, 0xb)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_unix.go:409 +0x343
net.(*TCPListener).AcceptTCP(0xc208189c48, 0x8, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:234 +0x5d
net.(*TCPListener).Accept(0xc208189c48, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/tcpsock_posix.go:244 +0x4b
net/http.(*Server).Serve(0xc20809e9c0, 0x7f7d4ee79810, 0xc208189c48, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1698 +0x91
net/http.Serve(0x7f7d4ee79810, 0xc208189c48, 0x7f7d4ee7f618, 0xc2080bc7d0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1576 +0x7c
github.com/influxdb/influxdb/admin.(*HttpServer).ListenAndServe(0xc20802a400)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/admin/http_server.go:35 +0x1ea
created by github.com/influxdb/influxdb/server.(*Server).ListenAndServe
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/server/server.go:136 +0x556

goroutine 51 [chan receive, 1 minutes]:
github.com/influxdb/influxdb/server.(*Server).startReportingLoop(0xc208042090, 0xc2081af6c0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/server/server.go:203 +0xc9
created by github.com/influxdb/influxdb/server.(*Server).ListenAndServe
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/server/server.go:184 +0x8aa

goroutine 2396 [runnable]:
github.com/influxdb/influxdb/coordinator.(*CoordinatorImpl).runQuerySpec(0xc2080c5410, 0xc20803cf00, 0x7f7d4ee7fcf8, 0xc208189278, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:454 +0x587
github.com/influxdb/influxdb/coordinator.(*CoordinatorImpl).runQuery(0xc2080c5410, 0xc20803cf00, 0x7f7d4ee7fcf8, 0xc208189278, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:169 +0x57
github.com/influxdb/influxdb/coordinator.(*CoordinatorImpl).RunQuery(0xc2080c5410, 0x7f7d4ee7fc60, 0xc208196d40, 0xc2081822c6, 0xa, 0xc2085da780, 0xbf, 0x7f7d4ee7fcf8, 0xc208189278, 0x0, ...)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:147 +0xa6a
github.com/influxdb/influxdb/api/http.func·004(0x7f7d4ee7fc60, 0xc208196d40, 0x7, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:335 +0x416
github.com/influxdb/influxdb/api/http.yieldUser(0x7f7d4ee7fc60, 0xc208196d40, 0x7f7d4c1319e0, 0xc208182200, 0x20, 0x0, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:528 +0x88
github.com/influxdb/influxdb/api/http.(*HttpServer).tryAsClusterAdmin(0xc2080706e0, 0x7f7d4ee7fc00, 0xc208264480, 0xc2088dbee0, 0x7f7d4c1319e0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:590 +0x397
github.com/influxdb/influxdb/api/http.(*HttpServer).tryAsDbUserAndClusterAdmin(0xc2080706e0, 0x7f7d4ee7fc00, 0xc208264480, 0xc2088dbee0, 0x7f7d4c1319e0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:756 +0x2bc
github.com/influxdb/influxdb/api/http.(*HttpServer).query(0xc2080706e0, 0x7f7d4ee7fc00, 0xc208264480, 0xc2088dbee0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:345 +0x1c8
github.com/influxdb/influxdb/api/http.*HttpServer.(github.com/influxdb/influxdb/api/http.query)·fm(0x7f7d4ee7fc00, 0xc208264480, 0xc2088dbee0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/api.go:118 +0x44
github.com/influxdb/influxdb/api/http.func·039(0x7f7d4ee7fad8, 0xc20803ce60, 0xc2088dbee0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/http_compression.go:73 +0xa1
github.com/influxdb/influxdb/api/http.func·038(0x7f7d4ee7fad8, 0xc20803ce60, 0xc2088dbee0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/api/http/cors.go:14 +0x1d0
net/http.HandlerFunc.ServeHTTP(0xc2081f4b40, 0x7f7d4ee7fad8, 0xc20803ce60, 0xc2088dbee0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1235 +0x40
github.com/bmizerany/pat.(*PatternServeMux).ServeHTTP(0xc2081897e8, 0x7f7d4ee7fad8, 0xc20803ce60, 0xc2088dbee0)
        /home/vagrant/gocodez/src/github.com/bmizerany/pat/mux.go:109 +0x20b
net/http.serverHandler.ServeHTTP(0xc20809e960, 0x7f7d4ee7fad8, 0xc20803ce60, 0xc2088dbee0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1673 +0x19f
net/http.(*conn).serve(0xc208378500)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1174 +0xa7e
created by net/http.(*Server).Serve
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1721 +0x313

goroutine 2416 [chan receive]:
github.com/influxdb/influxdb/coordinator.func·002()
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:317 +0x6a
created by github.com/influxdb/influxdb/coordinator.(*CoordinatorImpl).getShardsAndProcessor
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:330 +0x3bf

goroutine 2418 [runnable]:
encoding/binary.(*encoder).value(0xc2081b8480, 0xadda00, 0x0, 0x62, 0xb0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/encoding/binary/binary.go:524
encoding/binary.Write(0x7f7d4ee7a938, 0xc2085875e0, 0x7f7d4ee80458, 0x0, 0xadda00, 0x62, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/encoding/binary/binary.go:332 +0x1a03
github.com/influxdb/influxdb/metastore.(*Field).IdAsBytes(0xc2083f4e00, 0x0, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/metastore/store.go:37 +0x198
github.com/influxdb/influxdb/datastore.(*Shard).executeQueryForSeries(0xc2082a5810, 0xc20803cf00, 0xc20868e7d0, 0xf, 0xc2081c4b60, 0x2, 0x2, 0x7f7d4ee93020, 0xc208180a20, 0x0, ...)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/datastore/shard.go:205 +0x2216
github.com/influxdb/influxdb/datastore.(*Shard).Query(0xc2082a5810, 0xc20803cf00, 0x7f7d4ee93020, 0xc208180a20, 0x0, 0x0)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/datastore/shard.go:135 +0x69f
github.com/influxdb/influxdb/cluster.(*ShardData).Query(0xc2082aa960, 0xc20803cf00, 0xc2086af180)
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/cluster/shard.go:309 +0x6d0
created by github.com/influxdb/influxdb/coordinator.(*CoordinatorImpl).queryShards
        /home/vagrant/gocodez/src/github.com/influxdb/influxdb/coordinator/coordinator.go:410 +0x2f3

goroutine 2415 [IO wait]:
net.runtime_pollWait(0x7f7d4ee7a188, 0x72, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/runtime/netpoll.goc:146 +0x66
net.(*pollDesc).Wait(0xc208506c30, 0x72, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:84 +0x46
net.(*pollDesc).WaitRead(0xc208506c30, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_poll_runtime.go:89 +0x42
net.(*netFD).Read(0xc208506bd0, 0xc208497000, 0x1000, 0x1000, 0x0, 0x7f7d4ee772b8, 0xb)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/fd_unix.go:232 +0x34c
net.(*conn).Read(0xc2081891f8, 0xc208497000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/net.go:122 +0xe7
net/http.(*liveSwitchReader).Read(0xc2080bafa8, 0xc208497000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:206 +0xaf
io.(*LimitedReader).Read(0xc2081cff00, 0xc208497000, 0x1000, 0x1000, 0x10, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/io/io.go:399 +0xd0
bufio.(*Reader).fill(0xc208866c60)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/bufio/bufio.go:97 +0x1b3
bufio.(*Reader).ReadSlice(0xc208866c60, 0xc208242e0a, 0x0, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/bufio/bufio.go:298 +0x22c
bufio.(*Reader).ReadLine(0xc208866c60, 0x0, 0x0, 0x0, 0x506100, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/bufio/bufio.go:326 +0x69
net/textproto.(*Reader).readLineSlice(0xc2081fe6c0, 0x0, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/textproto/reader.go:55 +0x9d
net/textproto.(*Reader).ReadLine(0xc2081fe6c0, 0x0, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/textproto/reader.go:36 +0x4e
net/http.ReadRequest(0xc208866c60, 0xc208228750, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/request.go:556 +0xc7
net/http.(*conn).readRequest(0xc2080baf80, 0x0, 0x0, 0x0)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:577 +0x276
net/http.(*conn).serve(0xc2080baf80)
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1132 +0x61e
created by net/http.(*Server).Serve
        /home/vagrant/.gvm/gos/go1.3/src/pkg/net/http/server.go:1721 +0x313

This was referenced Sep 3, 2014
Closed
Closed
@jvshahid
Copy link
Contributor

jvshahid commented Sep 4, 2014

@mattheworiordan This crash is caused by this part of the query environment = 'staging'. You have to prefix the column environment with the alias of the series, e.g. user.environment = ... or system.environment = .... I pushed a fix to master so a proper error is returned instead of crashing.

@jvshahid jvshahid mentioned this issue Sep 5, 2014
Closed
jvshahid added a commit that referenced this issue Sep 24, 2014
@jvshahid
Return an error if an invalid column is used to filter after a join
42bef25 
Fix #652
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@mattheworiordan @jvshahid @janajri