Couchbase-Ecosystem / grafana-plugin

Grafana Couchbase datasource plugin
MIT License
12 stars 3 forks source link

Query error #8

Closed roadgoat closed 7 months ago

roadgoat commented 7 months ago

I am trying to test this plugin. I have a known working query getting a Capella instance and get "Query error An error occurred within the plugin"

From Grafana 10

grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.04307168Z level=info msg="Processing query" refId=A EXTRA_VALUE_AT_END="TYPE: " grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.043083305Z level=info msg="Transforming query" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.043090305Z level=info msg="Unmarshalled json" query_string= grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.04309643Z level=info msg="Querying couchbase" query_string= grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.8355075Z level=error msg="Query failed: parsing failure | {\"client_context_id\":\"d27b51f8-0bd2-4ed8-b7b1-80882093ef20\",\"errors\":[{\"Code\":3000,\"Message\":\"syntax error - at end of input\"}]}" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.835905416Z level=info msg="Processing query" EXTRA_VALUE_AT_END="TYPE: " refId=B grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.835934708Z level=info msg="Transforming query" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.835958125Z level=info msg="Unmarshalled json" query_string="SELECT d.type, d.value AS temperature, d.timestamp\nFROM bucket._default._default AS d\nWHERE d.type = \"temperature\";" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:50.83597425Z level=info msg="Querying couchbase" query_string="SELECT d.type, d.value AS temperature, d.timestamp\nFROM bucket._default._default AS d\nWHERE d.type = \"temperature\";" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:51.121194291Z level=info msg="Query ok" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:51.121320625Z level=error msg="Panic occured: interface conversion: interface {} is nil, not map[string]interface {}" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:51.171300458Z level=error msg="plugin process exited" plugin=/var/lib/grafana/plugins/couchbase-datasource/dist/gpx_couchbase_linux_arm64 id=52 error="exit status 2" grafana | logger=context userId=1 orgId=1 uname=admin t=2024-03-18T22:23:51.171385916Z level=error msg="Internal server error" error="[plugin.downstreamError] client: failed to query data: Failed to query data: rpc error: code = Unavailable desc = error reading from server: EOF" remote_addr=192.168.65.1 traceID= grafana | logger=context userId=1 orgId=1 uname=admin t=2024-03-18T22:23:51.171553083Z level=error msg="Request Completed" method=POST path=/api/ds/query status=500 remote_addr=192.168.65.1 time_ms=1206 duration=1.206653042s size=116 referer="http://localhost:3000/explore?orgId=1&schemaVersion=1" handler=/api/ds/query status_source=downstream grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:23:51.305088375Z level=info msg=Profiler enabled=false grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:12.591475552Z level=info msg="QueryData called" request="&{PluginContext:{OrgID:1 PluginID:couchbase-datasource User:0x4000249380 AppInstanceSettings: DataSourceInstanceSettings:0x40004928f0} Headers:map[http_X-Datasource-Uid:ddg2m972wevpcb http_X-Grafana-Org-Id:1 http_X-Panel-Id:3580] Queries:[{RefID:A QueryType: MaxDataPoints:1587 Interval:2s TimeRange:{From:2024-03-18 21:24:12.576 +0000 UTC To:2024-03-18 22:24:12.576 +0000 UTC} JSON:[123 34 97 110 97 108 121 116 105 99 115 34 58 102 97 108 115 101 44 34 100 97 116 97 115 111 117 114 99 101 34 58 123 34 116 121 112 101 34 58 34 99 111 117 99 104 98 97 115 101 45 100 97 116 97 115 111 117 114 99 101 34 44 34 117 105 100 34 58 34 100 100 103 50 109 57 55 50 119 101 118 112 99 98 34 125 44 34 100 97 116 97 115 111 117 114 99 101 73 100 34 58 51 44 34 105 110 116 101 114 118 97 108 77 115 34 58 50 48 48 48 44 34 109 97 120 68 97 116 97 80 111 105 110 116 115 34 58 49 53 56 55 44 34 113 117 101 114 121 34 58 34 34 44 34 114 101 102 73 100 34 58 34 65 34 125]} {RefID:B QueryType: MaxDataPoints:1587 Interval:2s TimeRange:{From:2024-03-18 21:24:12.576 +0000 UTC To:2024-03-18 22:24:12.576 +0000 UTC} JSON:[123 34 97 110 97 108 121 116 105 99 115 34 58 102 97 108 115 101 44 34 100 97 116 97 115 111 117 114 99 101 34 58 123 34 116 121 112 101 34 58 34 99 111 117 99 104 98 97 115 101 45 100 97 116 97 115 111 117 114 99 101 34 44 34 117 105 100 34 58 34 100 100 103 50 109 57 55 50 119 101 118 112 99 98 34 125 44 34 100 97 116 97 115 111 117 114 99 101 73 100 34 58 51 44 34 105 110 116 101 114 118 97 108 77 115 34 58 50 48 48 48 44 34 107 101 121 34 58 34 81 45 50 53 55 49 97 102 97 101 45 99 57 49 97 45 52 56 101 55 45 98 48 102 101 45 53 49 52 101 51 49 97 57 97 54 52 101 45 49 34 44 34 109 97 120 68 97 116 97 80 111 105 110 116 115 34 58 49 53 56 55 44 34 113 117 101 114 121 34 58 34 83 69 76 69 67 84 32 100 46 116 121 112 101 44 32 100 46 96 118 97 108 117 101 96 32 65 83 32 116 101 109 112 101 114 97 116 117 114 101 44 32 100 46 116 105 109 101 115 116 97 109 112 92 110 70 82 79 77 32 96 98 117 99 107 101 116 96 46 95 100 101 102 97 117 108 116 46 95 100 101 102 97 117 108 116 32 65 83 32 100 92 110 87 72 69 82 69 32 100 46 116 121 112 101 32 61 32 92 34 116 101 109 112 101 114 97 116 117 114 101 92 34 59 34 44 34 114 101 102 73 100 34 58 34 66 34 125]}]}" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:12.591561718Z level=info msg="Processing query" EXTRA_VALUE_AT_END="TYPE: " refId=A grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:12.591602677Z level=info msg="Transforming query" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:12.591623177Z level=info msg="Unmarshalled json" query_string= grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:12.591638802Z level=info msg="Querying couchbase" query_string= grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.221292344Z level=error msg="Query failed: parsing failure | {\"client_context_id\":\"e07a69d4-0a7f-459c-9d91-ae7372336f05\",\"errors\":[{\"Code\":3000,\"Message\":\"syntax error - at end of input\"}]}" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.22135776Z level=info msg="Processing query" refId=B EXTRA_VALUE_AT_END="TYPE: " grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.221374594Z level=info msg="Transforming query" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.221396302Z level=info msg="Unmarshalled json" query_string="SELECT d.type, d.value AS temperature, d.timestamp\nFROM bucket._default._default AS d\nWHERE d.type = \"temperature\";" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.221411469Z level=info msg="Querying couchbase" query_string="SELECT d.type, d.value AS temperature, d.timestamp\nFROM bucket._default._default AS d\nWHERE d.type = \"temperature\";" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.497325969Z level=info msg="Query ok" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.497424719Z level=error msg="Panic occured: interface conversion: interface {} is nil, not map[string]interface {}" grafana | logger=context userId=1 orgId=1 uname=admin t=2024-03-18T22:24:13.513623635Z level=error msg="Internal server error" error="[plugin.downstreamError] client: failed to query data: Failed to query data: rpc error: code = Unavailable desc = error reading from server: EOF" remote_addr=192.168.65.1 traceID= grafana | logger=context userId=1 orgId=1 uname=admin t=2024-03-18T22:24:13.51378751Z level=error msg="Request Completed" method=POST path=/api/ds/query status=500 remote_addr=192.168.65.1 time_ms=940 duration=940.315959ms size=116 referer="http://localhost:3000/explore?orgId=1&schemaVersion=1" handler=/api/ds/query status_source=downstream grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:13.523647469Z level=error msg="plugin process exited" plugin=/var/lib/grafana/plugins/couchbase-datasource/dist/gpx_couchbase_linux_arm64 id=65 error="exit status 2" grafana | logger=plugin.couchbase-datasource t=2024-03-18T22:24:14.289486344Z level=info msg=Profiler enabled=false