Troubleshoot issues writing data
Learn how to handle and recover from errors when writing to InfluxDB.
Discover common failure scenarios
Write requests made to InfluxDB may fail for a number of reasons. Common failure scenarios that return an HTTP 4xx
or 5xx
error status code include the following:
- API token was invalid. . See how to manage API tokens.
- Payload size was too large.
- Client or server reached a timeout threshold.
- Data was not formatted correctly.
To find the causes of a specific error, review HTTP status codes.
Troubleshoot partial writes
Writes may fail partially or completely even though InfluxDB returns an HTTP 2xx
status code for a valid request. For example, a partial write may occur when InfluxDB writes all points that conform to the bucket schema, but rejects points that have the wrong data type in a field. To resolve partial writes and rejected points, see troubleshoot failures.
Review HTTP status codes
InfluxDB uses conventional HTTP status codes to indicate the success or failure of a request. Write requests return the following status codes:
204
Success: InfluxDB validated the request data format and accepted the data for writing to the bucket.204
doesn’t indicate a successful write operation since writes are asynchronous. If some of your data did not write to the bucket, see how to troubleshoot rejected points.400
Bad request: The line protocol data in the request was malformed. The response body contains the first malformed line in the data. All request data was rejected and not written.401
Unauthorized: May indicate one of the following:- Authorization: Token header is missing or malformed.
- API token value is missing from the header.
- API token does not have sufficient permissions to write to the organization and the bucket. For more information about token types and permissions, see Manage API tokens
404
Not found: A requested resource (e.g. an organization or bucket) was not found. The response body contains the requested resource type, e.g. “organization”, and resource name.413
Request entity too large: All request data was rejected and not written. InfluxDB OSS only returns this error if the Go (golang) ioutil.ReadAll() function raises an error.500
Internal server error: Default HTTP status for an error.503
Service unavailable: Server is temporarily unavailable to accept writes. TheRetry-After
header describes when to try the write again.
The message
property of the response body may contain additional details about the error.
Troubleshoot failures
If you notice data is missing in your bucket, do the following:
- Check the
message
property in the response body for details about the error - Verify all lines contain valid syntax, e.g. line protocol or CSV
- Verify the data types match other data points with the same series. For example, did you attempt to write
string
data to anint
field? - Verify the timestamps match the precision parameter.
- Minimize payload size and network errors by optimizing writes
Troubleshoot rejected points
InfluxDB may reject points even if the HTTP request returns “Success”. If some of your data did not write to the bucket, check for field type differences between the missing data point and other points that have the same series. For example, did you attempt to write string
data to an int
field?
InfluxDB rejects points for the following reasons:
- The batch contains another point with the same series, but one of the fields has a different value type.
- The bucket contains another point with the same series, but one of the fields has a different value type.