{"action":"closed","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/3972","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/3972/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/3972/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/3972/events","html_url":"https://github.com/influxdb/influxdb/issues/3972","id":104686068,"number":3972,"title":"[0.9.3] select * from df_value -> out of memory","user":{"login":"szop85","id":2103595,"avatar_url":"https://avatars.githubusercontent.com/u/2103595?v=3","gravatar_id":"","url":"https://api.github.com/users/szop85","html_url":"https://github.com/szop85","followers_url":"https://api.github.com/users/szop85/followers","following_url":"https://api.github.com/users/szop85/following{/other_user}","gists_url":"https://api.github.com/users/szop85/gists{/gist_id}","starred_url":"https://api.github.com/users/szop85/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/szop85/subscriptions","organizations_url":"https://api.github.com/users/szop85/orgs","repos_url":"https://api.github.com/users/szop85/repos","events_url":"https://api.github.com/users/szop85/events{/privacy}","received_events_url":"https://api.github.com/users/szop85/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-09-03T12:57:41Z","updated_at":"2015-09-08T08:24:01Z","closed_at":"2015-09-08T08:24:01Z","body":"We are having trouble querying some data because our InfluxDB instance is crashing after a select query. We are using collectd 5.5 to put df data metrics into our InfluxDB.\r\n\r\n```\r\n> select * from df_value\r\nfatal error: runtime: out of memory\r\n\r\nruntime stack:\r\nruntime.SysMap(0xc21d140000, 0x100000, 0x77ae00, 0xb3ffd8)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/mem_linux.c:149 +0x98\r\nruntime.MHeap_SysAlloc(0xb456c0, 0x100000, 0x436d62)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/malloc.c:284 +0x124\r\nruntime.MHeap_Alloc(0xb456c0, 0x1, 0x10000000003, 0x41624e)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/mheap.c:240 +0x66\r\nruntime.MCentral_CacheSpan(0xb4c358, 0x7fdb1eafdb88)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/mcentral.c:85 +0x167\r\nruntime.MCache_Refill(0x7fdb264d4000, 0x7fdb00000003, 0x7fdb1eafdb88)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/mcache.c:90 +0xa0\r\n\r\ngoroutine 1 [running]:\r\nruntime.switchtoM()\r\n        /root/.gvm/gos/go1.4.2/src/runtime/asm_amd64.s:198 fp=0xc2080eecd0 sp=0xc2080eecc8\r\nruntime.mallocgc(0x20, 0x0, 0x7fdb00000003, 0xc21d13ed08)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/malloc.go:178 +0x849 fp=0xc2080eed80 sp=0xc2080eecd0\r\nruntime.rawstring(0x16, 0x0, 0x0, 0x0, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/string.go:195 +0x93 fp=0xc2080eedb0 sp=0xc2080eed80\r\nruntime.slicebytetostring(0xc217c28272, 0x16, 0x25cfb8e, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/runtime/string.go:69 +0x4b fp=0xc2080eee40 sp=0xc2080eedb0\r\nencoding/json.(*decodeState).literalStore(0xc2080761a8, 0xc217c28272, 0x16, 0x25cfb8e, 0x77ae20, 0xc21d13cad0, 0xd4, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:770 +0x1cc7 fp=0xc2080ef1f8 sp=0xc2080eee40\r\nencoding/json.(*decodeState).literal(0xc2080761a8, 0x77ae20, 0xc21d13cad0, 0xd4)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:638 +0xf7 fp=0xc2080ef260 sp=0xc2080ef1f8\r\nencoding/json.(*decodeState).value(0xc2080761a8, 0x77ae20, 0xc21d13cad0, 0xd4)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:291 +0x3a8 fp=0xc2080ef338 sp=0xc2080ef260\r\nencoding/json.(*decodeState).array(0xc2080761a8, 0x76d5c0, 0xc21c916810, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:439 +0xa9b fp=0xc2080ef4e0 sp=0xc2080ef338\r\nencoding/json.(*decodeState).value(0xc2080761a8, 0x76d5c0, 0xc21c916810, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:285 +0x3ee fp=0xc2080ef5b8 sp=0xc2080ef4e0\r\nencoding/json.(*decodeState).array(0xc2080761a8, 0x76b940, 0xc20800c190, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:439 +0xa9b fp=0xc2080ef760 sp=0xc2080ef5b8\r\nencoding/json.(*decodeState).value(0xc2080761a8, 0x76b940, 0xc20800c190, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:285 +0x3ee fp=0xc2080ef838 sp=0xc2080ef760\r\nencoding/json.(*decodeState).object(0xc2080761a8, 0x879c60, 0xc20800c160, 0xd9)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:605 +0x1199 fp=0xc2080efb78 sp=0xc2080ef838\r\nencoding/json.(*decodeState).value(0xc2080761a8, 0x879c60, 0xc20800c160, 0xd9)\r\nencoding/json.(*decodeState).object(0xc2080761a8, 0x879c60, 0xc20800c160, 0xd9)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:605 +0x1199 fp=0xc2080efb78 sp=0xc2080ef838\r\nencoding/json.(*decodeState).value(0xc2080761a8, 0x879c60, 0xc20800c160, 0xd9)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:288 +0x3ce fp=0xc2080efc50 sp=0xc2080efb78\r\nencoding/json.(*decodeState).array(0xc2080761a8, 0x76cf60, 0xc20803af60, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:439 +0xa9b fp=0xc2080efdf8 sp=0xc2080efc50\r\nencoding/json.(*decodeState).value(0xc2080761a8, 0x76cf60, 0xc20803af60, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:285 +0x3ee fp=0xc2080efed0 sp=0xc2080efdf8\r\nencoding/json.(*decodeState).object(0xc2080761a8, 0x838100, 0xc20803af60, 0xd9)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:605 +0x1199 fp=0xc2080f0210 sp=0xc2080efed0\r\nencoding/json.(*decodeState).value(0xc2080761a8, 0x767980, 0xc20803af60, 0x16)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:288 +0x3ce fp=0xc2080f02e8 sp=0xc2080f0210\r\nencoding/json.(*decodeState).unmarshal(0xc2080761a8, 0x767980, 0xc20803af60, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:149 +0x1e7 fp=0xc2080f0388 sp=0xc2080f02e8\r\nencoding/json.(*Decoder).Decode(0xc208076180, 0x767980, 0xc20803af60, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/stream.go:53 +0x18f fp=0xc2080f0428 sp=0xc2080f0388\r\ngithub.com/influxdb/influxdb/client.(*Result).UnmarshalJSON(0xc2080580a0, 0xc2121f800c, 0x25895ec, 0x3fffdf4, 0x0, 0x0)\r\n        /root/go/src/github.com/influxdb/influxdb/client/influxdb.go:347 +0x1c0 fp=0xc2080f0500 sp=0xc2080f0428\r\nencoding/json.(*decodeState).object(0xc208076028, 0x848440, 0xc2080580a0, 0xd9)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:481 +0x133 fp=0xc2080f0840 sp=0xc2080f0500\r\nencoding/json.(*decodeState).value(0xc208076028, 0x848440, 0xc2080580a0, 0xd9)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:288 +0x3ce fp=0xc2080f0918 sp=0xc2080f0840\r\nencoding/json.(*decodeState).array(0xc208076028, 0x76ce40, 0xc20803b020, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:439 +0xa9b fp=0xc2080f0ac0 sp=0xc2080f0918\r\nencoding/json.(*decodeState).value(0xc208076028, 0x76ce40, 0xc20803b020, 0xd7)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:285 +0x3ee fp=0xc2080f0b98 sp=0xc2080f0ac0\r\nencoding/json.(*decodeState).object(0xc208076028, 0x838040, 0xc20803b020, 0xd9)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:605 +0x1199 fp=0xc2080f0ed8 sp=0xc2080f0b98\r\nencoding/json.(*decodeState).value(0xc208076028, 0x767920, 0xc20803b020, 0x16)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:288 +0x3ce fp=0xc2080f0fb0 sp=0xc2080f0ed8\r\nencoding/json.(*decodeState).unmarshal(0xc208076028, 0x767920, 0xc20803b020, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:149 +0x1e7 fp=0xc2080f1050 sp=0xc2080f0fb0\r\nencoding/json.(*Decoder).Decode(0xc208076000, 0x767920, 0xc20803b020, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/stream.go:53 +0x18f fp=0xc2080f10f0 sp=0xc2080f1050\r\ngithub.com/influxdb/influxdb/client.(*Response).UnmarshalJSON(0xc2080d0d20, 0xc20c108000, 0x25895fa, 0x3fffe00, 0x0, 0x0)\r\n        /root/go/src/github.com/influxdb/influxdb/client/influxdb.go:390 +0x1c0 fp=0xc2080f11c8 sp=0xc2080f10f0\r\nencoding/json.(*decodeState).object(0xc2080764a8, 0x863d60, 0xc2080d0d20, 0x16)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:481 +0x133 fp=0xc2080f1508 sp=0xc2080f11c8\r\nencoding/json.(*decodeState).value(0xc2080764a8, 0x863d60, 0xc2080d0d20, 0x16)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:288 +0x3ce fp=0xc2080f15e0 sp=0xc2080f1508\r\nencoding/json.(*decodeState).unmarshal(0xc2080764a8, 0x863d60, 0xc2080d0d20, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/decode.go:149 +0x1e7 fp=0xc2080f1680 sp=0xc2080f15e0\r\nencoding/json.(*Decoder).Decode(0xc208076480, 0x863d60, 0xc2080d0d20, 0x0, 0x0)\r\n        /root/.gvm/gos/go1.4.2/src/encoding/json/stream.go:53 +0x18f fp=0xc2080f1720 sp=0xc2080f1680\r\ngithub.com/influxdb/influxdb/client.(*Client).Query(0xc208058000, 0xc2081005c0, 0x16, 0xc208068584, 0x8, 0x0, 0x0, 0x0)\r\n        /root/go/src/github.com/influxdb/influxdb/client/influxdb.go:156 +0x629 fp=0xc2080f18c0 sp=0xc2080f1720\r\nmain.(*CommandLine).ExecuteQuery(0xc208033ee0, 0xc2081005c0, 0x16, 0x0, 0x0)\r\n        /root/go/src/github.com/influxdb/influxdb/cmd/influx/main.go:462 +0xaf fp=0xc2080f19b8 sp=0xc2080f18c0\r\nmain.(*CommandLine).ParseCommand(0xc208033ee0, 0xc2081005c0, 0x16, 0xc2081005c0)\r\n        /root/go/src/github.com/influxdb/influxdb/cmd/influx/main.go:263 +0xa2c fp=0xc2080f1b98 sp=0xc2080f19b8\r\nmain.main()\r\n        /root/go/src/github.com/influxdb/influxdb/cmd/influx/main.go:212 +0x15bc fp=0xc2080f1f98 sp=0xc2080f1b98\r\nruntime.main()\r\n        /root/.gvm/gos/go1.4.2/src/runtime/proc.go:63 +0xf3 fp=0xc2080f1fe0 sp=0xc2080f1f98\r\nruntime.goexit()\r\n        /root/.gvm/gos/go1.4.2/src/runtime/asm_amd64.s:2232 +0x1 fp=0xc2080f1fe8 sp=0xc2080f1fe0\r\n\r\ngoroutine 5 [syscall]:\r\nos/signal.loop()\r\n        /root/.gvm/gos/go1.4.2/src/os/signal/signal_unix.go:21 +0x1f\r\ncreated by os/signal.init·1\r\n        /root/.gvm/gos/go1.4.2/src/os/signal/signal_unix.go:27 +0x35\r\n\r\ngoroutine 21 [select]:\r\nnet/http.(*persistConn).writeLoop(0xc208062420)\r\n        /root/.gvm/gos/go1.4.2/src/net/http/transport.go:945 +0x41d\r\ncreated by net/http.(*Transport).dialConn\r\n        /root/.gvm/gos/go1.4.2/src/net/http/transport.go:661 +0xcbc\r\n\r\ngoroutine 17 [syscall, locked to thread]:\r\nruntime.goexit()\r\n        /root/.gvm/gos/go1.4.2/src/runtime/asm_amd64.s:2232 +0x1\r\n\r\ngoroutine 20 [select]:\r\nnet/http.(*persistConn).readLoop(0xc208062420)\r\n        /root/.gvm/gos/go1.4.2/src/net/http/transport.go:928 +0x9ce\r\ncreated by net/http.(*Transport).dialConn\r\n        /root/.gvm/gos/go1.4.2/src/net/http/transport.go:660 +0xc9f\r\n```\r\n\r\nCheers,\r\nDavid"}}