"log entry checksum mismatch" when inserting data


#1

Hi,

our InfluxDb unfortunately ran out of disk space, after clearing up some space and restarting, I now get the following error when I try to add data to an existing measurement:

Connected to http://localhost:8186 version 1.3.2
InfluxDB shell version: 1.3.2

use xxxDb
Using database xxxDb
INSERT quotes,isin=DE00TESTTEST ib.ask=1
ERR: {“error”:"[shard 267] log entry checksum mismatch"}

This happens when using the HTTP interface too.

Thanks,
Michael


#2

I have same problem too while insert
{“error”:"[shard 129] log entry checksum mismatch"}


#3

Hello,

I see this same error from time to time in InfluxDB instances running 1.3.6 and 1.4.2 versions both with “tsi1” index-version.

Log output example:
[I] 2018-02-22T10:34:12Z write failed for shard 784: [shard 784] log entry checksum mismatch service=write
[httpd] 112.178.142.113 - admin [22/Feb/2018:11:34:12 +0100] “POST /write?db=mon_prod_collectd&precision=s HTTP/1.1” 500 52 “-” “Java/1.8.0_161” ec3aeea8-17bb-11e8-8026-000000000000 28496
[E] 2018-02-22T10:34:12Z [500] - “[shard 784] log entry checksum mismatch” service=httpd
[I] 2018-02-22T10:34:12Z write failed for shard 784: [shard 784] log entry checksum mismatch service=write

Do you know what could be the reason for that and how we could avoid further writing failures?
In addition, how could I fix these without dropping the shard?

Thanks,
David