Are you seeing that same error message? Do you see...
# fleet
z
Are you seeing that same error message? Do you see the same value for
host_identifier
in the log line?
More details in https://github.com/fleetdm/fleet/issues/102. If you are seeing a perf issue please follow these instructions to get a debug archive that we can use to debug the perf: https://github.com/fleetdm/fleet/blob/master/docs/infrastructure/performance.md#generate-debug-archive-fleet-340
c
ah, we're on 3.1.0 😞
z
We've only seen this in association with the duplicate host identifier problem, so consider whether you could be running into that scenario. If you are able to modify the osqueryd flagfile, setting
host_identifier=instance
can be a good remediation.
c
OK thanks, I'll look into that
Do you know if MySQL should have
innodb_rollback_on_timeout
enabled?
z
Fleet's tx handling (https://github.com/fleetdm/fleet/blob/master/server/datastore/mysql/mysql.go#L63-L99) will rollback on any error encountered during the transaction, so I don't think that should make any difference. Please let us know if you observe any issues.