Hi,
It seems that the old issue might have surfaced again (#3349) in v1.0.
I tried to insert a large number of records (3913595) via a script, inserting
10000 rows at a time.
After a while I received
HTTP/1.1 500 Internal Server Error
Content-Type: application/json
Request-Id: ac8ebbbe-8f70-11e6-8ce7-000000000000
X-Influxdb-Version: 1.0.0
Date: Tue, 11 Oct 2016 05:12:02 GMT
Content-Length: 20
{"error":"timeout"}
HTTP/1.1 100 Continue
I killed the process, after which the whole box became pretty much unresponsive.
There is nothing in the logs (i.e. sudo ls /var/log/influxdb/ gives me nothing)
although the setting for http logging is true:
[http]
enabled = true
bind-address = ":8086"
auth-enabled = true
log-enabled = true
I tried to restart influx, but got the following error:
Failed to connect to http://localhost:8086
Please check your connection settings and ensure 'influxd' is running.
Although I can see that influxd is up an running:
> systemctl | grep influx
influxdb.service
loaded active running InfluxDB is an open-source, distributed, time
series database
What do I do now?
I tried the same import over the weekend, then the script timeout happened
eventually but the result was the same unresponsive, unusable server. We
rebuilt the box and started again.
Perhaps it is worthwhile mentioning that the same measurement already contained
about 9 million records. Some of these records had the same timestamp as the
ones I tried to import, i.e. they should have been merged.
Interestingly enough the same amount of data was fine when I forgot to add
precision in ms, i.e. all records were imported as nanoseconds, but in fact
they "lacked" 6 zeroes.
Please advise what kind of action I can take.
Thanks a lot!
Tanya
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups
"InfluxDB" 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/f4ebdb56-32f9-4fb6-88de-f7ef603c4262%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
