Hello,
I have followed the tutorial present in Kapacitor documentation, and successfully created tasks on “telegraf”.“autogen” database, which are functioning correctly.
I then created a separate database, and inserted a few points into a measurement.
Created a few tick_scripts pointed at the new database.
Kapacitor is failing to pull any data from the new database.
I have replicated the same scripts on “telegraf”.“autogen” database, which work fine.
Output of influx show subscriptions:
> show subscriptions
name: _internal
retention_policy name mode destinations
---------------- ---- ---- ------------
monitor kapacitor-8536a758-858a-4390-9c04-df28d465f5c3 ANY [http://localhost:9092]
name: paa
retention_policy name mode destinations
---------------- ---- ---- ------------
autogen kapacitor-8536a758-858a-4390-9c04-df28d465f5c3 ANY [http://localhost:9092]
name: telegraf
retention_policy name mode destinations
---------------- ---- ---- ------------
autogen kapacitor-8536a758-858a-4390-9c04-df28d465f5c3 ANY [http://localhost:9092]
Output of Kapacitor stats ingress
kapacitor stats ingress
Database Retention Policy Measurement Points Received
_internal monitor cq 218
_internal monitor database 654
_internal monitor httpd 218
_internal monitor queryExecutor 218
_internal monitor runtime 218
_internal monitor shard 1090
_internal monitor subscriber 872
_internal monitor tsm1_cache 1090
_internal monitor tsm1_engine 1090
_internal monitor tsm1_filestore 1090
_internal monitor tsm1_wal 1090
_internal monitor write 218
_kapacitor autogen edges 1962
_kapacitor autogen ingress 5858
_kapacitor autogen kapacitor 218
_kapacitor autogen load 218
_kapacitor autogen nodes 1962
_kapacitor autogen runtime 218
_kapacitor autogen topics 218
telegraf autogen cpu 1090
telegraf autogen disk 438
telegraf autogen diskio 876
telegraf autogen kernel 219
telegraf autogen mem 219
telegraf autogen processes 219
telegraf autogen swap 438
telegraf autogen system 657
TickScript on “telegraph”.“autogen”
kapacitor show batch_cpu_httpOut
ID: batch_cpu_httpOut
Error:
Template:
Type: batch
Status: enabled
Executing: true
Created: 19 Jul 18 10:39 CDT
Modified: 19 Jul 18 11:58 CDT
LastEnabled: 19 Jul 18 11:58 CDT
Databases Retention Policies: ["telegraf"."autogen"]
TICKscript:
batch
|query('SELECT * from "telegraf"."autogen"."cpu" limit 10')
.period(10s)
.every(10s)
|httpOut('cpu_alert')
DOT:
digraph batch_cpu_httpOut {
graph [throughput="1.00 batches/s"];
query1 [avg_exec_time_ns="36.934702ms" batches_queried="116" errors="0" points_queried="580" working_cardinality="0" ];
query1 -> http_out2 [processed="116"];
http_out2 [avg_exec_time_ns="27.322µs" errors="0" working_cardinality="1" ];
}
TickScript on the created database:
ID: paa_batch
Error:
Template:
Type: batch
Status: enabled
Executing: true
Created: 18 Jul 18 23:00 CDT
Modified: 19 Jul 18 11:46 CDT
LastEnabled: 19 Jul 18 11:46 CDT
Databases Retention Policies: ["paa"."autogen"]
TICKscript:
batch
|query('SELECT * from "paa"."autogen"."packetloss" limit 10')
.period(10s)
.every(10s)
|httpOut('packetloss')
DOT:
digraph paa_batch {
graph [throughput="0.00 batches/s"];
query1 [avg_exec_time_ns="3.115033ms" batches_queried="0" errors="0" points_queried="0" working_cardinality="0" ];
query1 -> http_out2 [processed="0"];
http_out2 [avg_exec_time_ns="0s" errors="0" working_cardinality="0" ];
}
The database “paa”.“autogen” was created using simpleCREATE DATABASE "paa",
and the measurement packetloss was created using a bunch of INSERT statements.
Is there any special configuration required for kapacitor to pull data from a user created database ?
Thanks!
