I ran into an issue after updating to MemSQL 6.8.1 that was not present in earlier version of MemSQL (I believe it was 6.7.4). I am currently running 6.8.1 in a local single leaf, single MA instance. The table in question is queried using “FOR UPDATE” and that row is then locked for a minute or so before releasing. If I attempt to add a new row during that time MemSQL throws an error:
ERROR: Compilation of [INSERT INTO
worker_lock) VALUES (?, ?, ?, ?, ?, ?, ?)] failed. Reason: Failed reading object file.
The table itself is a rowstore, if that makes a difference.