Error with MemSQL 6.8.1 - Failed reading object file

Off-Topic
1

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 queue (worker_type, message, status, createtime, archive, project_id, worker_lock) VALUES (?, ?, ?, ?, ?, ?, ?)] failed. Reason: Failed reading object file.
The table itself is a rowstore, if that makes a difference.

Many thanks,
Nick

2

Hi @nfleming

Thanks for posting your question!

I briefly chatted with our engineering team, and this doesn’t look right to us. Do you mind submitting this to bug-reports@memsql.com so we can take a further look and reproduce it on our end?

The more information you provide, the better (including full reproduction steps).

Thanks!

3

Will do. Writing up email now. Thanks.

1 Like
4

Thanks! Let’s help you get this figured out :slight_smile:

5

For anyone else with this issue, it was resolved in 6.8.2.

1 Like