Hi All I have posted this question here and someone recommended to send the email to this email address.
Here is simple code which simple condition. But the Kapacitor is ignoring the condition and write the alert info to file & influxDB everytime irrespective of condition matched or not. Please do the needful. https://github.com/influxdata/docs.influxdata.com/issues/875 I have written the TICK script to query the data from InfluxDB, calculate tablespace_used and I want to write back to InfluxDB if the tablespace_used is > 0.6 in this example. The below TICK is able to query the data and write the data back to InfluxDB successfully. However, it is writing the entry into Database (Oracle_Intellix_TableSpace_Alerts meansurement) and to /tmp/batch_alerts.log even if the value of tablespace used is less than 0.6. I do see the entries in the DB and also in File /tmp/batch_alerts.log with tablespace_used value as 0.02, 0.5, 0.8, 0.9..etc. 1. Why the script is writing the entries for the tablespace_used values less than 0.6??? 2. How to pass USED_MB, TOTAL_MB and other parameters of Oracle_Intellix_TableSpace measurement like serverName back into InfluxDB measurement created for alert (i.e Oracle_Intellix_TableSpace_Alerts)? var tablespace_errors = batch |query(''' SELECT * FROM "comm_qa"."default"."Oracle_Intellix_TableSpace" ''') .period(15m) .every(10m) tablespace_errors |eval(lambda: "USED_MB" / "TOTAL_MB") .as('tablespace_used') |alert() .crit(lambda: "tablespace_used" > 0.6) // Whenever we get an alert write it to a file. .log('/tmp/batch_alerts.log') |influxDBOut() .cluster('emmo_relays') .database('comm_qa') .measurement('Oracle_Intellix_TableSpace_Alerts') ==== Kapacitor 1.1 InfluxDB 1.0 Best Regards Jayanna ________________________________________________________ The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer. -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/BL2P103MB00522AF705CFCF9C1E66866EE1BC0%40BL2P103MB0052.NAMP103.PROD.OUTLOOK.COM. For more options, visit https://groups.google.com/d/optout.
