mullerpeter / databricks-grafana

Grafana Databricks integration allowing direct connection to Databricks to query and visualize Databricks data in Grafana.
Apache License 2.0
55 stars 4 forks source link

Getting this error #35

Closed udiazulayintel closed 10 months ago

udiazulayintel commented 10 months ago

Hi, Plugin works great, i get this error from time to time in Grafana :

An error occurred within the plugin Trace ID: 02c09a77a32f4b1f83aa165da8ec2577

logger=plugin.mullerpeter-databricks-datasource t=2023-11-13T13:29:34.2909037+02:00 level=info msg="QueryData called" request="map[Headers:map[http_X-Dashboard-Uid:de3befa8-f342-4e15-865c-11cdab800fce http_X-Datasource-Uid:dcb05559-888a-4172-8e8a-1afcfeb36def http_X-Grafana-Org-Id:5 http_X-Grafana-User:udi.azulay@intel.com http_X-Panel-Id:5] PluginContext:map[AppInstanceSettings: DataSourceInstanceSettings:map[BasicAuthEnabled:false BasicAuthUser: Database: DecryptedSecureJSONData:map[token:dapiaa9f9f2ed8ff4a3ff7d1ef8b7790376f] ID:31 JSONData:map[autoCompletion:true hostname:adb-1251297925467971.11.azuredatabricks.net path:sql/1.0/warehouses/0448732958594fb2] Name:Databricks Type:mullerpeter-databricks-datasource UID:dcb05559-888a-4172-8e8a-1afcfeb36def URL: Updated:2023-11-06T21:00:40+02:00 User:] OrgID:5 PluginID:mullerpeter-databricks-datasource User:map[Email:udi.azulay@intel.com Login:udi.azulay@intel.com Name:Azulay, Udi Role:Admin]] Queries:[map[Interval:2e+09 JSON:map[datasource:map[type:mullerpeter-databricks-datasource uid:dcb05559-888a-4172-8e8a-1afcfeb36def] datasourceId:31 intervalMs:2000 maxDataPoints:1306 querySettings:map[convertLongToWide:true fillMode:1] rawSqlQuery:\r\nSELECT VisualId,Tname,Value,ProductFamily,CAST(MaxValue AS STRING) MaxValue\r\nFROM z_product_engineering_mpe_mit_trace.trace_api.results_dts_gold\r\nWHERE JobId = 'Y326016GGOL_6248_CLASSCOLD' refId:A] MaxDataPoints:1306 QueryType: RefID:A TimeRange:map[From:2023-10-01T05:59:48.385+03:00 To:2023-10-01T07:07:54+03:00]]]]"

mullerpeter commented 10 months ago

Hi, there is not much information I can extract from this error message. Not sure why this is happening. Are you able to provide me with the logs of the Grafana instance around the time of the error?

udiazulayintel commented 10 months ago

Hi,

I have resolved it by creating a “default” schema under my catalog (I am using UC). Thanks!

Udi

From: Peter Müller @.> Sent: Sunday, November 19, 2023 5:42 PM To: mullerpeter/databricks-grafana @.> Cc: Azulay, Udi @.>; Author @.> Subject: Re: [mullerpeter/databricks-grafana] Getting this error (Issue #35)

Hi, there is not much information I can extract from this error message. Not sure why this is happening. Are you able to provide me with the logs of the Grafana instance around the time of the error?

— Reply to this email directly, view it on GitHubhttps://github.com/mullerpeter/databricks-grafana/issues/35#issuecomment-1817891926, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A5GKGU2DV6FCDLGDTJLNR63YFISFRAVCNFSM6AAAAAA7JAA27WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMJXHA4TCOJSGY. You are receiving this because you authored the thread.Message ID: @.**@.>>

Intel Israel (74) Limited

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s). Any review or distribution by others is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.

mullerpeter commented 10 months ago

Then I guess this issue is related to the Code Auto Completion feature, since this is the only place where the default schema is used.

I'll look into the corner case when there is no default schema. Thanks for the information

udiazulayintel commented 10 months ago

Thanks much, great plugin!!

Thanks, Udi


From: Peter Müller @.> Sent: Sunday, November 19, 2023 5:51:04 PM To: mullerpeter/databricks-grafana @.> Cc: Azulay, Udi @.>; Author @.> Subject: Re: [mullerpeter/databricks-grafana] Getting this error (Issue #35)

Then I guess this issue is related to the Code Auto Completion feature, since this is the only place where the default catalog is used.

I'll look into the corner case when there is no default catalog. Thanks for the information

— Reply to this email directly, view it on GitHubhttps://github.com/mullerpeter/databricks-grafana/issues/35#issuecomment-1817894204, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A5GKGU5EN2TBGK6AHAUQZDDYFITGPAVCNFSM6AAAAAA7JAA27WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMJXHA4TIMRQGQ. You are receiving this because you authored the thread.Message ID: @.***>

Intel Israel (74) Limited

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s). Any review or distribution by others is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.