BigQuery plugin - slow loading times + loop of errors with code status 500

[joelmfonseca]

Hi, I am using a BigQuery datasource for one of my projects. I am facing an issue that is related to grafana and more precisely on the plugin for the BigQuery datasource (I guess).

When loading a dashboard that contains the BigQuery data source and every time I change de time window setting, refresh of the dashboards take ~10 +/- 5 seconds. Typically, the larger the time window (and therefore the number of points), the longer it takes to load properly. You can imagine the frustration of the end user.

Here are the tracks I have already explored:

• Do a comparison between the cloud instance (GCE) versus locally => exact same behavior.

• Run the exact same query on BigQuery directly => I got results in < 1sec => query and data itself are OK.

• Inspect the grafana logs =>

  

• Inspect the network logs from the console =>

  

It might be related to this post as well; he got the same error but with another plugin/configuration: Error 500 when update dashboard.

Thanks for your help! Happy to contribute if I have some additional insights!

[zoltanbedi]

Hi @joelmfonseca,

Do you have query caching enabled? Also can you please provide a way to reproduce this?

[gabor]

hi, as we got no response, we are closing the issue for now. if new info is provided, we can reopen it. thanks!