Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Sep 19 12:44
    nuratikahhamzah starred influxdata/influxdb-python
  • Sep 15 19:54
    leocavalcante opened #164
  • Sep 15 10:07
    DalilaKmy starred influxdata/influxdb-python
  • Sep 10 12:16
    kris-cloudaccess starred influxdata/influxdb-python
  • Sep 09 22:03
    dentarg starred influxdata/influxdb-ruby
  • Sep 09 15:58
    snooze92 commented #856
  • Sep 09 00:50

    aviau on master

    Prevent overwriting Authorizati… (compare)

  • Sep 09 00:50
    aviau closed #901
  • Sep 09 00:50
    aviau commented #901
  • Sep 08 16:04
    psteinbachs assigned #897
  • Sep 08 12:37
    zgy730 review_requested #901
  • Sep 08 12:37
    zgy730 review_requested #901
  • Sep 08 12:37
    zgy730 opened #901
  • Sep 07 16:17
    Niranjan121212 starred influxdata/influxdb-python
  • Sep 07 14:03
    ErlendFax commented #820
  • Sep 07 14:03
    ErlendFax commented #820
  • Sep 05 13:01
    flameOnYou starred influxdata/influxdb-python
  • Sep 04 12:57
    koutaiba95 commented #638
  • Sep 03 16:48
    LordOfTheSnow closed #900
  • Sep 03 16:48
    LordOfTheSnow commented #900
dupondje
@dupondje
No Telegraf dev in here? :)
Olav Rossøy
@OlavRossoy
is there any way to make a select with a group by time (days) with a tz return only the date portion of the timestamp?
ie have
SELECT mean("value") AS "value" FROM some_data GROUP BY time(1d) tz('Europe/Berlin')
return dates like '2019-07-05' instead of '2019-07-04T22:00:00Z'
its kind of awkward having to transfer dates to local timestamps to be able to query time ranges correctly for aggregated values created with CQs etc
Tushar Nerkar
@tusharnerkar8_gitlab

Our data looks like this and there are 20000 nodes

node     status             time
node-1  status: down      1 hr before
node-1     status: up        now
select count(*) from node_health where status = 'down' and $timeFilter group by node

I want the above query to return 0 but it doesn't.
I think I can solve this by following query.

select count(*) from (select last(status) from node_health where $timeFilter group by node) where status = 'down'

But I wanted improve the performance by adding the status where clause . My query is real slow takes 50 seconds to load.
How to make this work without subquery so as I can improve the performance of the query.

mgiammarco
@mgiammarco
Hi, I try to send an alert from influxdb to alerta but I get always: unsupported protocol scheme "" when I click on "send test alert" button no matter what I do
I have also launched tcpdump and I am pretty sure that kapacitor/chronograf does not even try to send a POST to alerta
can you help me?
thanks
zoe56
@kongkong56
what meaning difference between mean and last
Poul H. Sørensen
@poulhs
@mgiammarco Sounds to me like you have a misconfigured setup
[alerta]
  enabled = true
  url = "https://alerta.api.example"
  token = "GuvfVfGurFrpergNyregnNCVgbxra"
 ...

And now a telegraf question:
Hi - We need to monitor Horizon DaaS.
I hope that someone have some exeperiences with this.
A more general solution would be a CIM plugin (which I have not found)
Any ideas?
Poul H. Sørensen
@poulhs
Marquitos
@sonirico

hello there! A query question. Do you know if it is possible to sum the total sum of two independent measurements in a single query? For instance, for query select sum(value) from metric_1_traffic_in,metric_2_traffic_in where time > now() - 1h ; the following is returned:

name: metric_1_traffic_in
time                sum
----                ---
1573034400000000000 308346.88

name: metric_2_traffic_in
time                sum
----                ---
1573034400000000000 150405.12000000002

Is there a way to have 308346.88 + 150405.12000000002 in a single result row?

Would it be possible with a continous query?
Smit Jain
@smitjainsj
can we post questions regarding telegraf in this channel or there is some other channel created ?
Mikki
@kobvel
Hello, everyone.
I am having a problem with the Telegraf. I can't kill it with Ctrl+C. Have to kill it from console every time.
I am running an input service with Sleep. I assume that is the problem.
@smitjainsj I think we can :D
Smit Jain
@smitjainsj
@kobvel canfirm your version, I never had this issu
mert
@mertbakir
Hi everyone I need help, can you check these:
fixahost
@fixahost_twitter
Hello Guys
Mihail Malo
@qm3ster
Yo yo yo
Is there a discord or something?
Where should I ask about FLUX?
Francisco Palomares
@FranciscoPalomares
image.png
Hi, what is the problem?
slachtar
@slachtar
I'm trying to compare realtime sync solutions, any one checked deepstream?
https://deepstream.slack.com/
https://deepstream.io/
fmcejudo
@fmcejudo
Hi, is there any specific channel for Influx java?
volgad
@volgad
Hello all , I recently discovered influxDB 2.0 and it seems and amazing tool for real time visualization / monitoring.
Instead of building a real GUI for my application, I am looking to connect an akka stream (in scala) to an influxDB (2.0) to store events and visualize them in grafana or telegraph. I saw in a recent webcast that influx was releasing specific clients for programming languages. Is there any JVM client (java, scala) that enables to write to the DB> from the doc / posts the scala client only enables to read records? Any reference, tutorial or articles would be great. Thank you
Ilya
@squadgazzz
Hello everyone! I have a working influxdb+telegraf. I send metrics directly to influxdb with two different ways. With curl and using influxdb-java-2.16.jar library. Will the telegraf work in this case or I should send metrics to telegraf instead of influxdb?
prashanthjbabu
@prashanthjbabu

Hello All ! I’d like to understand what would be the efficient query to filter a large number of tag values while performing a group by . Here’s an example

Let’s assume we have 5000 hosts which have telegraf running and all of them send their metrics to an influxdb located elsewhere . Lets take the “CPU” telegraf metric for example . Now I’d like to fetch the average CPU consumed for a list of hosts which can be say around 300 . Now “host” is a tag for each metric which is unique for each host.

What would be the most efficient way to query influx to just get the average cpu for the last 1 day for 300 specific hosts?
Lets say the tag values for host are host1,host2,host3 etc

I currently know of only 2 methods
1) Just chain the OR statements
select mean(usage_system) from cpu where time > now() - 1d where host=‘host1’ or host=‘host2’ or … (for 300 hosts) group by host
2)Use regex
select mean(usage_system) from cpu where time > now() - 1d where host ~= /host1|host2|host3|…(300hosts)/ group by host

I find both of them highly inefficient . Is there a better way to do this?

Edgar
@EdgarArout_twitter
is an org or bucket necessary ?
I'm tyring out the golang sdk, client.WriteAPI takes org, bucket but not sure, doesn't seem necessary?
Edgar
@EdgarArout_twitter
ya - seems ncessary - but then how was I able to just do insert in the influx shell - hmm
Edgar
@EdgarArout_twitter
okay - i see - im using 1.8, leaving org name empty is okay - bucket name can be just the db name
Edgar
@EdgarArout_twitter
looking for a way to manage tasks & notifications from the CLI - the docs only mention UI and the golang sdk doesn't mention at all
rather - making a task from CLI is mentioned, but making a ntification seems to be only UI for now?
zanpakuto
@zanpakuto
I want to count the number of events during last 1 week from a measurement X and store the count into another measurement Y periodically using an InfluxDB CONTINUOUS QUERY. However it seems "GROUP BY time" is mandatory in the query. This results in splitting of the result into multiple time range windows. Is there a way to disable GROUP BY or specify some duration in GROUP BY that doesn't result in splitting of the result?
Jed-Giblin
@Jed-Giblin
Anyone very familiar with the external plugin shim for input plugins?
Thumann
@Thumann
Hi, I've installed Influx 2 in docker, If i make a large (silly) query from the data explorer the entire instance exits after about a minute while running the query, any ideas? and where can i see log messages?
Gnurt
@HuaTrung
Hi every1, I've installed telegraf in a container and nginx in another container. So when i set [inputs.nginx] urls = ["nginx:9089/nginx_status"], it cause an error "Error in plugin: error making HTTP request to nginx:9089/nginx_status: Get "nginx:9089/nginx_status": unsupported protocol scheme "nginx" ". Could anyone help me? I cant use http because it's inside a container
raul-parada
@raul-parada

Hi, I've restarted influxdb and the port has changed from 8086 to 8086. This is my code in influxdb.conf `[http]

Determines whether HTTP endpoint is enabled.

enabled = true

Determines whether the Flux query endpoint is enabled.

flux-enabled = true

Determines whether the Flux query logging is enabled.

flux-log-enabled = false

The bind address used by the HTTP service.

bind-address = ":8086"

Determines whether user authentication is enabled over HTTP/HTTPS.

auth-enabled = false

The default realm sent back when issuing a basic auth challenge.

realm = "InfluxDB"

Determines whether HTTP request logging is enabled.

log-enabled = true

Determines whether the HTTP write request logs should be suppressed when the log is enabled.

suppress-write-log = false `

How can I use again the port 8086? I cannot use it now (it is not accepted as data source in Grafana ("Bad gateway")

Stephane
@steevivo
Hi all, if I use a telegraf/dockerised on a vm , how telegraph communicate with the VM , because today I have only it’s own container not the VM machine (sorry i’m new with telegraf)
gdantkat
@gdantkat
Hi, i am creating programmatically an influx task to regularly downsample the data
the downsampling uses the interpolate function so i tried to import the interpolate using the import "interpolate" statement but it fails since the import in the created task falls below the task options
this can be solved using the influxdb ui
but programmatically it seems to me like a bug