CereusTransporter ERROR

[Kekos]

Hello,

I want to send data with CereusTransporter to my database InfluxDB, and when the plugin tries to send data, I have this log on Cacti.
Do you have an idea to solve this problem ? I don't know where this log comes from, because the data was sent properly.

2019/05/22 11:40:54 - CereusTransporter ERROR: Writing has failed, exception: Client error response
[url] http://X.X.X.X:8086/write?db=influx&precision=s
[reason phrase] Bad Request
[status code] 400

CereusTransporter Version 0.66
Cacti Version 1.1.36

Best Regards
Kekos

[phalek]

What influxdb version are you using?

[chipmonk]

Debian Buster
Cacti v1.2.2
PHP Version => 7.0.33-12+0 <---- btw, this version seems to work best so far in my environment.
NET-SNMP Version NET-SNMP version: 5.7.3
RRDtool Version Configured 1.7.0+
RRDtool Version Found 1.7.1
influxdb v1.7.9

I experienced this too, I went into /usr/share/cacti/site/plugins/CereusTransporter/vendor/influxdb/influxdb-php/src/InfluxDB/Client.php and commented out line #211 to stop the logging.

/** throw new Exception(sprintf('Writing has failed, exception: %s', $e->getMessage()));
*/

I still receive this in my logs:

2019/11/13 18:37:55 - CereusTransporter STATS: Time:2.08 LookupTableSize:3512 LookupUnitsTableSize:3313 MetricsCount:3521 AverageHostTime:0.01 SlowestHostnames:[myhost.com: 0.075s, myhost2.com: 0.028s, myhost3.com: 0.019s, myhost4.com: 0.019s]


which leads me to believe I'm still good. Host names have been changed.

POST EDIT - I was wrong, I'm missing datapoints, lot's of them. Any ideas on what is causing this "Writing has failed, exception"?

POST EDIT 2 - During my install I had a debian confilct with influxdb-client and influxdb, i went back to that, uninstalled the client, did a apt-get update, dropped my original db and recreated, now I'm good for the past 8 hours or so. Heres's a look at my influxdb "show stats"

name: write
pointReq pointReqLocal req subWriteDrop subWriteOk writeDrop writeError writeOk writeTimeout
-------- ------------- --- ------------ ---------- --------- ---------- ------- ------------
378884 378884 23742 0 23742 0 0 23742 0

POST EDIT 3

Writing to influxdb stopped working after about 24 hours with 57600 successful writes then it started failing. Any ideas on why it appears to be hitting a threshold and then stops working? I have other Influxdb databases as datasources for Grafana and they continue to populate.

name: write
pointReq pointReqLocal req subWriteDrop subWriteOk writeDrop writeError writeOk writeTimeout
-------- ------------- --- ------------ ---------- --------- ---------- ------- ------------
1007051 1007051 60861 0 60861 0 3261 57600 0