Re: [influxdb] Nanoseconds to Human readable Time Format

When you are in the `influx` CLI, you can switch the display to human-readable timestamps by issuing the command: ``` > precision rfc3339 ``` Or you can set it before logging into the instance by adding the parameter `-precision rfc3339` to the CLI option, for example: ``` influx -precision

Re: [influxdb] batch wont compile (using join)

I think the problem is that the `==` operator is not valid InfluxQL. Try updating your queries to use `=` instead of `==`. So the first query should be: SELECT 100*mean("value") FROM "metrics"."default"."134" WHERE "measure" = 'impressions' AND "relative" = '0' AND "env" = 'exchange' AND "type" =

Re: [influxdb] Re: Kapacitor "invalid field type: string" error

The error here: > [cpu_alert:mean3] 2016/08/11 13:34:01 E! invalid field type: Is referring to the `|mean('value')` call, which is receiving a null value for the "value" field. To fix that you'll either need to: * Remove it, since it doesn't look like you're using it anywhere anyways (and

Re: [influxdb] python InfluxDBClient.write() ?

I believe the reasoning is that `client.write()` is more for internal use within the `client` class, since it does require specifying the correct URL parameters on every request (which quickly becomes tiresome). I'd recommend using the `client.write_points()

Re: [influxdb] No data on subscription

What versions of both InfluxDB and Kapacitor are you running? And are you sure points are being written to the `ion` database? What does the output of a `kapacitor show test` look like? Thanks, Ross On Tue, Aug 9, 2016 at 2:15 PM, Kristopher Cieplak wrote: > I cannot seem

Re: [influxdb] with Arista TAC -- needing help with telgraf and InfluxDB web toolset

Hi Joe, Would you be able to open a support ticket with any questions you may have? You can open a ticket by sending an email to supp...@influxdb.com. Thanks, Ross On Fri, Feb 3, 2017 at 4:05 PM, 'Joe Dewberry' via InfluxData < influxdb@googlegroups.com> wrote: > Hello, > > Joe Dewberry with

Re: [influxdb] Re: InfluxDB Raspberry Pi installation?

You can find the v1.2.0 Debian package compatible with ARM-based distributions here: https://dl.influxdata.com/influxdb/releases/influxdb_1.2.0_armhf.deb On Wed, Feb 15, 2017 at 2:45 PM, wrote: > > I want to install version 1.2. How can i do it? > > -- > Remember

Re: [influxdb] InfluxDB keeps on logging for httpd

​Those are disabled by setting `log-enabled` under the `[http]` section to false. For reference: ``` [http] ... log-enabled = false ``` And then restarting the InfluxDB service. On Wed, Feb 15, 2017 at 3:07 PM, wrote: > Hello, > > My /var/log/syslog gets spammed

Re: [influxdb] Kapacitor alerts do not log the tags and fields

Can you share the tick script that was used to generate the alert? On Mon, Feb 27, 2017 at 6:44 AM, wrote: > Hi, > > I am pushing alerts on kapacitor on certain logic. But the alerts that get > logged do not have the fields displayed, instead it shows "\u003cno >

Re: [influxdb] Aggregation across multiple measurements matched with regex?

Hey Casey, That is not currently possible within InfluxQL. As you have found out, the results are still grouped by measurement. This is halfway-possible using Kapacitor , where you can create a stream that collects points from all measurements by not

Re: [influxdb] Re: Correct ownerships for files on ARM/RPi?

Ah, so the tarball packages don't have the necessary permissions to run InfluxDB as a service. What distribution of Linux are you running? Can you not use the RPM or DEB packages instead? If not, you'll need to create the following directories with owner:group as influxdb: - /var/lib/influxdb -

Re: [influxdb] Correct ownerships for files on ARM/RPi?

, Teppo Kurki <t...@iki.fi> wrote: > > > lauantai 17. syyskuuta 2016 Ross McDonald <r...@influxdb.com> kirjoitti: > >> Ah, so the tarball packages don't have the necessary permissions to run >> InfluxDB as a service. What distribution of Linux are you runnin

Re: [influxdb] Windows installer

Hi Manish, There is not currently an installer for InfluxDB, however we do have experimental Windows builds available. The v1.0.0 build can be found here: https://dl.influxdata.com/influxdb/releases/influxdb-1.0.0_windows_amd64.zip Thanks, Ross On Fri, Sep 16, 2016 at 11:44 AM, Manish Jain

Re: [influxdb] Unable to upgrade from 1.0.0_beta3 to 1.0.0~rc1 on CentOS 7 (yum)

Hi Tim, This was caused by inconsistent naming between the RC and beta versioning for RPM packages. RPM sees `1.0.0_betaX` as a higher version than `1.0.0~rcX`, which is why it's not automatically triggering the upgrade. As a workaround, you can use the `downgrade` option over `install`, making

Re: [influxdb] InfluxDB 0.13 download

You should use the 0.13.0 Debian package here if installing on Ubuntu. On Mon, Oct 3, 2016 at 2:32 AM, wrote: > Can you show me how to install influxdb-0.13.0_linux_amd64.tar.gz on > Ubuntu server? >

Re: [influxdb] Re: Download influxdb for 32 bit machine

The RPM link: https://dl.influxdata.com/influxdb/releases/influxdb-1.0.2.i386.rpm Is correct. The repository also has 32-bit packages under the i386 architecture heading. If you follow the instructions here for configuring the yum repository:

Re: [influxdb] streaming multiple measurement through kapacitor at once

Using a blank measurement in a stream enables the node to receive points for all measurements in the target database and retention policy. For example: ``` |from().measurement('') ``` Will receive points from all measurements. Thanks, Ross On Sun, Nov 6, 2016 at 10:54 PM, Sai Birada

Re: [influxdb] How to monitor disk usage

You can see the approximate size of the InfluxDB data directory by running the following query against the `_internal` databases `shard` measurement: ``` select sum(diskBytes) / 1024 / 1024 /1024 from _internal."monitor"."shard" where time > now() - 10s ``` The result will be in gigabytes. You

Re: [influxdb] Re: help with Kapacitor disk alert query

You can see examples for using `.stateChangesOnly()` in the documentation here: https://docs.influxdata.com/kapacitor/v1.0/nodes/alert_node/#statechangesonly On Wed, Nov 2, 2016 at 10:21 AM, wrote: > Would it be possible for you to illustrate this via example? I am a bit >

Re: [influxdb] Continuous Queries for downsampling data

I don't believe this is currently possible. There is a Github issue open regarding this problem here . On Wed, Dec 7, 2016 at 2:45 PM, wrote: > Hi, > > I've created the following CQ: > > CREATE CONTINUOUS QUERY

Re: [influxdb] Automatic merge does not seem to work

Are the fields part of the same series (do they share the same tag keys and values)? If not, they will be displayed on different lines. Thanks, Ross On Mon, Dec 12, 2016 at 3:35 AM, wrote: > Hi, > > I

Re: [influxdb] Show retention policies where/like clause supported?

That is not supported at the moment. Please open a feature request if you would like to see it added. On Wed, Dec 14, 2016 at 11:05 AM, Jeffery K < jeffery.k...@sightlinesystems.com> wrote: > Is there a way to specify a filtering mechanism on

Re: [influxdb] [Influxdb] Influxdb Yum Repo Fails

the url at ../stable and everything worked. The >> original baseurl line seems to work ok on Centos 6 but fails on Redhat 7. >> >> Thanks >> >> On Wednesday, December 14, 2016 at 9:28:55 AM UTC-6, Ross McDonald wrote: >>> >>> What distribution and version

Re: [influxdb] [Influxdb] Influxdb Yum Repo Fails

What distribution and version are you running? It doesn't look like your yum is substituting the variables properly. The correct URL is: https://repos.influxdata.com/rhel/7/x86_64/stable/repodata/repomd.xml Where `$releasever` is substituted for the current CentOS/RHEL release version (6, 7,

Re: [influxdb] kapacitor -- node|last() function

ot;Error: last3: invalid influxql func last with field uptime: invalid field > type: " > > I don't get why that is ? > > The influxdb query "select last(uptime) from system" returns correctly. > If I run "SHOW FIELD KEYS on systems", I see that the "u

Re: [influxdb] New, numbered tags created after using a renamed/migrated measurement

​If you don't use a `GROUP BY *` at the end of a `SELECT ... INTO ...` query, then any tags are automatically converted to fields. You're most likely seeing the new tags with numbers due to there already being a field by the same name. This is mentioned in the documentation here

Re: [influxdb] kapacitor -- node|last() function

​If the task stops executing, there should be an error stating why it was stopped next to the `Error:` heading in the `kapacitor show` output. Can you share the output to the output of `kapacitor show` for your task? Is there anything in the Kapacitor service logs for your task that look like an

Re: [influxdb] Telegraf as write buffer proxy for InfluxDB causes time unit mismatch

Could you provide your Telegraf configuration? Also what version of Telegraf are you using? On Fri, Jan 13, 2017 at 9:20 AM, Niels van Klaveren < niels.vanklave...@gmail.com> wrote: > When metrics are sent to Telegraf's http-input plugin and from there sent > to InfluxDB, the nanosecond

Re: [influxdb] influxdb-1.1.0-1.x86_64 admin UI not listening on port 8083

> Any reason to deprecate admin ui in influxdb-1.1.0-1.x86_64? This has been discussed in more detail here: https://groups.google.com/forum/#!topic/influxdb/1jhjX8kQF6M/discussion > I did set enabled = true in [admin] in influxdb.conf. I am still not able to get to the admin ui using

Re: [influxdb] influxdb python tutorial not working

There is no precision specified on the writes, so they are defaulting to nanosecond. The retention policy is also being set here for 3 days so the writes are getting dropped as they're being written,

Re: [influxdb] Re: Install 1.1.0 deb package on Ubuntu fails

​Was this an upgrade of InfluxDB? The `/var/lib/influxdb/meta/raft.db` file was removed with the 0.13 release, so it shouldn't be present in a 1.1.0 installation. Upgrading from pre-1.0 versions typically require extra steps that are documented here

Re: [influxdb] influxdb python tutorial not working

What if you set the RP to infinite? You'll want to change the "3d" to "inf": ``` client.create_retention_policy(retention_policy, 'inf', 3, default=True) ``` On Thu, Dec 1, 2016 at 5:42 PM, <vikas...@gmail.com> wrote: > On Thursday, December 1, 2016 at 2:13:39

Re: [influxdb] Is there a batch limit on Kapacitor batch process?

that you are still seeing that cap. On Thu, Dec 15, 2016 at 11:38 AM, <carlo.acti...@gmail.com> wrote: > On Tuesday, December 13, 2016 at 3:49:39 PM UTC-5, Ross McDonald wrote: > > I believe this is due to the default row limit in InfluxDB's HTTP > handler, not Kapacitor. C

Re: [influxdb] Kapacitor index.Tags on "com.docker.swarm.service.name"

Does this not work? {{ index .Tags "com.docker.swarm.service.name" }} There is a space between 'index' and '.Tags'. The brackets need to be together. And it looks like there is a typo with 'sswarm' (should be 'swarm'). On Fri, Dec 30, 2016 at 11:12 PM, Aditya C.S wrote:

Re: [influxdb] What can be deleted from /var/influxdb after relocating Meta and Data directories

Hi Alan, The InfluxDB process uses only what's in the configuration, so assuming all of your configuration has been migrated to use `/opt/influxdb`, then everything under `/var/lib/influxdb` can be removed. I would recommend double checking that the InfluxDB process is using the correct

Re: [influxdb] Kapacitor Java Library

I don't believe we have any official plans at the moment, however the API is documented in detail here if you would like to start your own. Thanks, Ross On Mon, Dec 19, 2016 at 11:19 AM,