Lets not use this for now. Needs to be better documented. Changing the URL to https://influxdb:8086 fixed it for me (where influxdb is the name of the Docker container running influxdb). To do that I created a connection pointing to InfluxDB. I am using Grafana 7.5.5 on an Ubuntu machine to display data stored in InfluxDB 1.8 in a different Ubuntu machine. Watch now Maybe someone else can help with that. You should check the actual logs of your influxdb server, and try allocating it more CPU/RAM resources. Grafana 4.3.1 breaks influxdb datasource support as non-admin user Grafana won't connect to InfluxDB Ask Question Asked 9 years, 1 month ago Modified 8 years, 4 months ago Viewed 10k times 4 The database, username, and password combination definitely work. New replies are no longer allowed. I also try to write ID in the organization but same error. does it report a working datasource when you press the [TEST] button at the bottom. but the queries always fail with a "database not found error" Influxdb does not have a field for database name, only buckets. Then refresh the dashboard and some others are working and some working ones get "Metric request error". docker-compose up -d influxdb grafana should bring up a Grafana container already configured with the InfluxDB container as data source. I also add custom HTTP then I am getting an error of unauthorized. t=2020-08-25T14:08:04+0000 lvl=eror msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=500 remote_addr=81.5.224.116 time_ms=77 size=34 referer="http://XXX.XXX.XXX.XXX/d/9D8no-ZMk/ubersicht?editPanel=28&orgId=1&from=now%2Fd&to=now" The first option can easily be checked with: Also, try to start the InfluxDB daemon manually to see what happens: sorry stupid question, how can it be possible that my linux doesent recognize lsof? Works. julf September 27, 2021, 7:09pm 1 I have Grafana working great with two InfluxDB databases. In my case, I forgot that I had spun up Grafana in a Docker container, and thus localhost was resolving within the Grafana container and not actually reaching influxdb. This is what I could find regarding the specifics of that error. Grafana 7.1 - Flux query does not respond correctly, https://github.com/grafana/influxdb-flux-datasource, http://XXX.XXX.XXX.XXX/d/9D8no-ZMk/ubersicht?editPanel=28&orgId=1&from=now%2Fd&to=now, can you try this with the current grafana version? corrupted, database name. the result of the test. Many aggregators - including count (), mean (), and median () - drop the _time column because they combine rows. No proxy and no issue of firewall and datasource is getting connected. Any other place I can try? Do we really need the /api/v2 when we are using Influx 1.8.1? This page documents an earlier version of InfluxDB. First of all, when I add a flux datasource and I get the "error reading influxdb". I cant find it on any docs. What is the "not executed" error? - InfluxData Community Forums Thank you for being part of our community! gabor added datasource/InfluxDB datasource/InfluxDB/flux labels on May 17, 2021. gabor mentioned this issue on Aug 25, 2021. You HAVE to use the all access token. Grafana displays the error message in the top-left corner of the panel. How to Build Grafana Dashboards with InfluxDB, Flux, and InfluxQL It worked pre-grafana 7, but Grafana 7 broke it in strange ways. When connecting I see this: I have done the following: Confirmed InfluxDB is listening on 8086 on localhost. To find support, use the following resources: Customers with an annual or support contract can contact InfluxData Support. request:Object look at what the query is - whether it contains the correct, or perhaps some Returned error in Grafana is not expected error, Grafana v8.1.2 does not connect to Influxdb2.0 with fluxQL, Data source type & version: built in InfluxDB data source using Flux, OS Grafana is installed on: Kubernetes version 1.17.4 using Docker image. Also, just as a test, try a simpler password. But maybe the log in this forum changed it? openhabian should have worked for you to set this up. What you expected to happen: Check your bucket name is also same as configured in influxDB UI. You switched accounts on another tab or window. The following configuration for grafana doesn't tho. Just regular letters and numbers. When adding the InfluxDB data source there I have access to different query languages such as InfluxQL and Flux. InfluxDB v1.7.4. does it report a working datasource when you press the [TEST] button at the bottom? Grafana won't connect to InfluxDB - Stack Overflow I have another grafana running version 7.3.7 used for a different service on a different host. and leaving all else blank, does the job. Bad gateway 502 to it.. It seems like this is a different error than when it ran in the script, but its hard to be sure. completed. jayshah3821 May 13, 2022, 12:38pm #2 Hi @arpit8081, I hope you can access UI of influxDB on port 8086 successfully. There are messages in the log file, but if they are all related to IPv6, then maybe the installation actually worked and you are only seeing issues due to IPv6. knaxman (Ralph Burgstahler) February 12, 2020, 8:52pm #24 If you don't have such column, you need to switch to Table mode. Grafana cannot connect to InfluxDB - Stack Overflow running Grafana or the machine running InfluxDB to look at communications going method:POST Looks like at least one of those isnt set up properly so Grafana cant connect to this datasource. I refreshed it again and it worked. Install fresh Grafana, add an influx data source using flux (influx 2.x), create a new dashboard and a new panel with a flux query. For instance, when I add the 'groub by' function, it will most probable crush. If you look at the grafana-server logs while you try to add the datasource, you can see these errors in more detail. precision:ms We read every piece of feedback, and take your input very seriously. Trying to configure grafana to use InfluxDBv2. curl -G 'http://localhost:8086/query?pretty=true' --data-urlencode "db=telegraf" --data-urlencode "q=SELECT "usage_system" FROM "cpu" LIMIT 1; SELECT "usage_system" FROM "cpu" WHERE time > now() - 1m" Default Bucket: Provide a default database and retention policy combination Open the dashboard. For some reason the curl command cant connect in order to create the admin user. You can also try the curl command manually to see what it does (fill in the password). Today I added a third, pretty much identical to the other two, on the same server. Trying to configure grafana to use InfluxDBv2. Sign in |> filter(fn: (r) => r._value > 666). Which Grafana version do you use? same issue, the InfluxQL requests are not always correctly executed. If its taking longer time to process due to low ram, influx may give timeout error resulting in refusing the connection. It seems to be a authentification problem. |> filter(fn: (r) => r._measurement == "example-measurement" and r._value > 666). When using InfluxDB along with grafana you can get some internal statistics for the usage with a build-in internal database. When using InfluxDB along with grafana you can get some internal statistics for the usage with a build-in internal database. Attaching image for reference. Available today in InfluxDB Cloud Dedicated. You signed in with another tab or window. InfluxDB Error: not executed - Grafana Labs Community Forums If you create a new dashboard and add a new panel with very simple flux query (eg. Im not an expert on openhabian, but I can see that it is trying to run the code below. No firewalls on the machine. To see all available qualifiers, see our documentation. See the documentation. Try adding the -v. Im beginning to run out of ideas, but maybe that will tell us. influx db error in my Homeassistant - InfluxDB - Grafana That can cause trouble - although the script should be correct, so it doesnt seem to be the root cause. When using Grafana 6.X and Influxdb2.0 everything worked fine, Just as additional remark which is maybe related to same root case. Just as update Still I have question that do high memory usage could cause time out to httpd. With that filled with above url everythings fine. openhabian knaxman (Ralph Burgstahler) February 4, 2020, 7:11pm 1 Hi guys, I got in the setup via sudo openhabian-config" a error in the installation. This could be related to this issue #26758. i'd like to help with this issue, but it has been open for a long time and many different issues got mixed together, so i'd like to "restart" the situation with these questions: I was running into this exact issue. closing the issue. But still getting the Metric request error, 2020-08-25T14:08:04+0000 lvl=eror msg="Metric request error" logger=context userId=1 orgId=1 uname=admin error="rpc error: code = Unavailable desc = transport is closing" remote_addr=81.5.XXX.XXX Introduced in Grafana 4.3.1, commit 89a7c2c introduced a regression. Oh, my fault. privacy statement. Metrics stored in the _internal database primarily measure workload performance and should only be tested in non-production environments. Grafana Dashboard - No Data. response [ {"statement_id": 0}, {"error": "not executed", "statement_id": 1}] What "not executed" means? Log into instance B. data:q=SELECT%20%22dev.cpu.0%22%20FROM%20%22autogen%22.%22mail%22%20WHERE%20time%20%3E%3D%20now()%20-%206h%20and%20time%20%3C%3D%20now()%20GROUP%20BY%20time(15s)%20fill(null)%3BSELECT%20%22dev.cpu.0%22%20FROM%20%22bigbox%22%20WHERE%20time%20%3E%3D%20now()%20-%206h%20and%20time%20%3C%3D%20now()%20GROUP%20BY%20time(15s)%20fill(null) Now 3 important point you need to check in grafana data source configuration is Your datasource is configured incorrectly. I assume that is the problem? I use Influxdb together with Grafana. organization: seems random, admin works The InfluxDB site does not seem to share these anymore. See the InfluxDB documentation. Mem usage :- constantly above 95% As per the parameters given by you we implemented that, but still giving out same error. Below error occurs only when some dashboard panels go blank and gives out error as Network Error: undefined (undefined) and after some time whole dashboard goes blank giving out error as Network error:Bad Gateway (502) Also I checked logs from grafana.log got a couple of issues one of them is above and second is given below:- did you find an answer ? Not sure that is the problem when using openhabian, though. But of course, go further down the page and unfold: Are you interested in InfluxDB 1.x Open Source? You can then comment out the 3 lines that are showed in order to enable internal monitoring. operating system = Ubuntu 18.04 GRAFANA_VERSION = 8.0.1 in docker-container INFLUXDB_VERSION = 2.0.7 in docker-container What are you trying to achieve? Get started with Grafana and InfluxDB | Grafana documentation Gabriel Tanner In this article, you will build a Grafana dashboard to visualize the data of a temperature sensor that will be read using a microcontroller and send over MQTT. I tried to use the connection to display some data. i always get the expected "correct" error message. If the database _internal is not listed most probably you will not have the internal statistics enabled. Data will be lost org.infl However, I faced the same issue, the InfluxQL requests are not always correctly executed. If you use a simple query and increase the period of time to get more data the returned data is cut off randomly. How to reproduce it (as minimally and precisely as possible): try to run this flux-query: buckets (). response:Object connection is correctly made. When saving data source, Half of the time I get this error: InfluxDb Error: database not found :