https://questdb.io logo
Title
j

John Dyer

03/06/2023, 8:49 PM
hey folks... trying to get QuestDB working on Grafana 9.4.3 and I keep getting a null pointer exception.... user/quest for the creds, no tls, and qdb for the db name.... anyone run into anything similar ?
n

Nicolas Hourcard

03/06/2023, 9:17 PM
hi @John Dyer this is not something we are aware of, are you able to share as many details as possible and we’ll look into it tomorrow first thing
j

John Dyer

03/06/2023, 10:27 PM
Mar 06 19:19:40 grafana grafana[140]: logger=context userId=0 orgId=1 uname= t=2023-03-06T19:19:40.444051812Z level=info msg="Request Completed" method=GET path=/api/frontend/settings status=200 remote_addr=192.168.100.42 time_ms=62 duration=62.653381ms size=6818 referer=<http://192.168.120.121:4000/datasources/edit/NzHxCqb4z> handler=/api/frontend/settings/
Mar 06 19:19:40 grafana grafana[140]: logger=context userId=0 orgId=1 uname= t=2023-03-06T19:19:40.486856041Z level=info msg="Request Completed" method=GET path=/api/datasources/uid/NzHxCqb4z status=200 remote_addr=192.168.100.42 time_ms=36 duration=36.500763ms size=776 referer=<http://192.168.120.121:4000/datasources/edit/NzHxCqb4z> handler=/api/datasources/uid/:uid
Mar 06 19:19:40 grafana grafana[140]: [xorm] [info]  2023/03/06 19:19:40.549452 PING DATABASE postgres
Mar 06 19:19:40 grafana grafana[140]: logger=context userId=0 orgId=1 uname= t=2023-03-06T19:19:40.552902001Z level=error msg="Request error" error="runtime error: invalid memory address or nil pointer dereference" stack="/usr/local/go/src/runtime/panic.go:260 (0x45a695)\n/usr/local/go/src/runtime/signal_unix.go:835 (0x45a665)\n/opt/drone/gomodcache/github.com/lib/pq@v1.10.7/conn.go:1525 (0x11639af)\n/opt/drone/gomodcache/github.com/lib/pq@v1.10.7/conn_go18.go:98 (0x1168889)\n/usr/local/go/src/database/sql/sql.go:837 (0xa53992)\n/usr/local/go/src/database/sql/sql.go:3439 (0xa60f0b)\n/usr/local/go/src/database/sql/sql.go:836 (0xa538e4)\n/usr/local/go/src/database/sql/sql.go:864 (0xa53b0b)\n/opt/drone/gomodcache/github.com/grafana/xorm@v0.8.3-0.20220614223926-2fcda7565af6/session_schema.go:22 (0x111a90c)\n/opt/drone/gomodcache/github.com/grafana/xorm@v0.8.3-0.20220614223926-2fcda7565af6/engine.go:362 (0x10dac57)\n/drone/src/pkg/tsdb/sqleng/sql_engine.go:177 (0x34fec24)\n/drone/src/pkg/tsdb/postgres/postgres.go:206 (0x34fec13)\n/drone/src/pkg/plugins/backendplugin/coreplugin/core_plugin.go:77 (0x3511170)\n/drone/src/pkg/plugins/plugins.go:301 (0x12116d4)\n/drone/src/pkg/plugins/manager/client/client.go:158 (0x3536cb1)\n/drone/src/pkg/plugins/backendplugin/instrumentation/instrumentation.go:42 (0x353499e)\n/drone/src/pkg/plugins/backendplugin/instrumentation/instrumentation.go:93 (0x3536ab8)\n/drone/src/pkg/plugins/manager/client/client.go:154 (0x3536a93)\n/drone/src/pkg/services/pluginsintegration/clientmiddleware/httpclient_middleware.go:91 (0x353b07e)\n/drone/src/pkg/services/pluginsintegration/clientmiddleware/cookies_middleware.go:116 (0x353a3fb)\n/drone/src/pkg/services/pluginsintegration/clientmiddleware/oauthtoken_middleware.go:126 (0x353bd7c)\n/drone/src/pkg/services/pluginsintegration/clientmiddleware/clear_auth_headers_middleware.go:68 (0x353984a)\n/drone/src/pkg/services/pluginsintegration/clientmiddleware/tracing_header_middleware.go:66 (0x353c3aa)\n/drone/src/pkg/plugins/manager/client/decorator.go:66 (0x3537728)\n/drone/src/pkg/api/datasources.go:825 (0x2d8ab47)\n/drone/src/pkg/api/datasources.go:792 (0x2d8a71e)\n/drone/src/pkg/api/routing/routing.go:17 (0x190ca21)\n/drone/src/pkg/api/response/web_hack.go:40 (0x11da175)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:134 (0x11ced54)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/services/contexthandler/contexthandler.go:221 (0x18f9f39)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/render.go:44 (0x11cf915)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/macaron.go:140 (0x11cedfb)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/middleware/csrf/csrf.go:64 (0x20a87a5)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/middleware/recovery.go:171 (0x19073a1)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/middleware/gziper.go:61 (0x190426d)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/middleware/logger.go:42 (0x1904b01)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/middleware/request_metrics.go:59 (0x19081c9)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/middleware/request_tracing.go:88 (0x190991a)\n/usr/local/go/src/net/http/server.go:2109 (0x7ae40e)\n/drone/src/pkg/web/context.go:49 (0x11cd6bd)\n/drone/src/pkg/web/router.go:155 (0x11d0e8d)\n/drone/src/pkg/web/router.go:221 (0x11d1ad1)\n/drone/src/pkg/web/macaron.go:166 (0x11cf270)\n/usr/local/go/src/net/http/server.go:2947 (0x7b180b)\n/usr/local/go/src/net/http/server.go:1991 (0x7acee6)\n/usr/local/go/src/runtime/asm_amd64.s:1594 (0x4783c0)\n"
Thanks
n

Nicolas Hourcard

03/07/2023, 8:42 AM
sounds good, @Bolek Ziobrowski and @Miguel Arregui will look into this one
m

Miguel Arregui

03/07/2023, 8:50 AM
having a look 😄
b

Bolek Ziobrowski

03/07/2023, 9:05 AM
Hi John. Did you follow https://questdb.io/blog/2020/10/19/grafana-tutorial/ ? Could you share questdb logs ?
m

Miguel Arregui

03/07/2023, 9:13 AM
yes, I have hit the same error, my grafana was installed with
brew install grafana
and that error shows when I hit the
Save & Test
button after having added QuestDB as a datasource, with Postgresql version 9.4
n

Nicolas Hourcard

03/07/2023, 9:43 AM
@Amy Wang could we look at this tutorial and tweak accordingly ?
m

Miguel Arregui

03/07/2023, 8:58 PM
I can add QuestDB 7.0.1 to grafana 9.3.8 as a datasource:
docker run -it --rm --name=grafana -p 3000:3000 grafana/grafana:9.3.8
the problem comes when I go beyond this release. The next up is grafana/grafana:9.4.0-beta1 and this one already has the problem reported by @John Dyer
I have submitted an issue, I am not a GO master, so I cannot really fix this myself. I hope to gain more clarity from grafana (first time I post an issue there)
This has been sorted now, the fix is in master